Microsoft Official Academic Course: Microsoft Project Home. Browse by Chapter. Browse by Chapter. TU Dublin – City Campus | Technological University Dublin. Integrity Matters. Wiley is Microsoft’s official worldwide publisher for all Microsoft Official Academic Course (MOAC) materials. Our partnership means that your students are the first to get the most reliable, direct, and focused materials.
 
 

 

Microsoft official academic course powerpoint 2013 pdf free download

 
Welcome to the Microsoft Official Academic Course (MOAC) program for Microsoft Office. MOAC represents the collaboration between Microsoft Learning. Microsoft Offi cial Academic Course programs address their needs by emphasizing authentic workplace scenarios with an abun-dance of projects.

 
 

Microsoft official academic course powerpoint 2013 pdf free download

 
 

In these free courses, you will find all the answers to your questions. Some courses are specifically for beginners but whatever your level you should learn something. Home Computer tutorials. Home » Office course. Join our site and enjoy office tutorials which interest you Word, Excel, Power-Point,.. Notice that the toolbar is moved below the Ribbon. Click the drop-down arrow on the right side of the Quick Access Toolbar again. Click Show Above the Ribbon to return the toolbar to its original position.

When you start typing text at the insertion point in a blank document, you have begun to create a Word document. The margin defaults are set to one-inch top, bottom, left, and right margins; the line spacing is set to 1. Word also has a number of tools and automatic features to make creating a document easier, including nonprinting characters, AutoComplete, and Word Wrap.

Later in this chapter, you learn to create a new document by selecting different line spacing and margin settings. These symbols can help you create and edit your document. By default, these sym- bols are hidden. When you print your document, these hidden symbols do not appear. In this exercise, you learn to display nonprinting characters in Word. Hiding White Space The white space is the space between pages of the document.

This appears as a gray area between the bottom of each page and the top of the next one. By default, the white space appears in Print Layout view. You can change the view of the document to reduce the amount of gray appearing by double-clicking between the pages. In this exercise, you learn to hide and unhide the white space. Make sure your insertion point is at the beginning of the document. Place the mouse below the Ribbon until you see the ScreenTip Double-click to hide white space and then double-click.

Notice the gray border line representing the white space becoming thinner. Understanding Word 9 2. Place the mouse over the gray border line until you see two arrows again and then double-click. This reveals the white space. Entering Document Text Entering document text is easy in Word. Word sets default margins and line-spacing measure- ments for newly created documents, and Word Wrap automatically wraps text to the next line as it reaches the right margin.

To separate paragraphs and create blank lines, press Enter. In this lesson, you create a letter using the Block Style format with mixed punctuation. Be sure to type the document text exactly as shown in the steps that follow—in a later lesson, you learn to format the document. When sending professional correspondence to customers, it is good business practice to ensure the document is in an acceptable format and error free.

The Block Style letter format has open or mixed punctuation and is common to many business documents. Block Style format aligns text along the left margin, including the date, inside address, salutation, body of the letter, clos- ing, and signature. Open punctuation requires no punctuation after the salutation or the closing, whereas mixed punctuation requires a colon after the salutation and a comma after the closing.

The insertion point should be positioned at the top of the page. Press Enter twice. Type the delivery address as shown: Ms. Miriam Lockhart Press Enter once. Boston, MA Press Enter twice. Type Dear Ms. Lockhart: 5. Press Enter once. Type the following text and press Enter once after each paragraph. We are pleased that you have chosen to list your home with Tech Terrace Real Estate.

Our office has bought, sold, renovated, appraised, leased, and managed more homes in the Tech Terrace neighborhood than anyone and now we will be putting that experience to work for you. Our goal is to sell your house quick for the best possible price. The enclosed packet contains a competitive market analysis, complete listing data, a copy of the contracts, and a customized house brochure. Your home has been input into the MLS listing and an Internet ad is on our website.

We will be contacting you soon to determine the best time for an open house. We look forward to working with you to sell your home. Please do not hesitate to call if you have any questions. Type Sincerely, 9. Type Steve Buckley. Your document should appear as shown in Figure This letter still needs to be formatted in an accepted mailable format and this is discussed in a later lesson.

Take Note It is always important to save your document before closing the program. However, if you close the document or Word by accident, a prompt appears, asking whether you want to save your document. Choose Yes to save and close, No to close without saving, or Cancel to stop the Close command. After editing an existing document, you can choose to save that document with a new filename, a different file format, or in another location. When saving a document to the Cloud, such as OneDrive, you have access to your doc- uments on any computer or tablet and can share them with others.

In some cases, you might want to save the original and edited documents in the same place but with different filenames. Keeping the original document enables you to reference it at a future date on any computer.

Understanding Word 11 Saving a Document for the First Time When saving a document for the first time, you must specify a filename, the file type, and a place where you can access the document. The Save As command enables users to save their work to the cloud and access the document quickly from any computer or tablet. In Lesson 13, you learn to save documents to OneDrive.

In this exercise, you learn to save a document with a specific filename to your flash drive. If necessary, connect your flash drive to one of the USB ports on your computer. Click the File tab, and then click the Save As command. The Save As screen appears. Click This PC. The right side of the screen changes and displays Recent Folders that have been opened, as shown in Figure Click Browse. The Save As combo box appears. In the Windows 10 environment, the Documents Library is the default location for saving new files.

Change the location from the default to your flash drive by using the vertical scroll bar and scrolling down until you see This PC. Expand the This PC container and select your flash drive. Storage devices are given a specific letter identified by the operating system. For example, your flash drive might be labeled as Removable Drive I:. Click the flash drive to select that as the location to save your document.

By default, the first few characters that you typed in your document appear in the File name box. Drag the mouse over the text and press Delete or begin typing over the highlighted text.

If a prompt appears to upgrade to the newest format click the OK button. This action allows you to use the new features in Word Be default, Word saves your work every 10 minutes. This makes it possible to recover some of your work if a problem occurs. However, this useful option is not a substitute for frequently saving your documents as you work.

You should always click the Save button regularly to avoid losing work in case of a power outage or computer crash. Choosing a Different File Format Some individuals and companies might not have upgraded their Office suites to the latest version and might still be working in an earlier version, such as Word Changing the file format of a document enables those individuals and companies to open and edit your document without losing its text formatting.

In this exercise, you learn to save a document in a format compatible with an earlier version of Word. Under Current Folder, click your flash drive. Type Tech Terrace in the File name box. Click Save. On the title bar, the new file name appears, along with a Compatibility Mode designation.

In the next exercise, you learn about Compatibility Mode. LEAVE document open for the next exercise. Converting a Document Compatibility Mode enables you to work in a document created in an earlier version of Word without saving the file in a different file format.

In this exercise, you learn to use the Convert com- mand to clear the compatibility options and convert a document to the Word file format. With the Tech Terrace In the main pane of the Info command, click Convert, and then click OK to confirm the conversion, as shown in Figure To save the document in the Word file format, click the File tab. Click Save As, and then click your flash drive.

Then in the File name box, type Tech Terrace Update. The new filename displays in the title bar. You can choose from many different categories of templates, such as letters, resumes, faxes, labels, cards, calendars, and more.

Some templates are preinstalled with Word and there are more options available online. A template is a master document with predefined page layout, fonts, margins, and styles that is used to create new documents with the same basic formatting. Using templates keeps you from having to recreate the layout and formatting of recurring doc- uments, such as letters and interoffice memoranda.

Templates are reusable even if you saved the document with a different file name. In this exercise, you locate an installed template, enter infor- mation, and save the document as a template. Locating a Template Installed on Your Computer Microsoft continues to add new templates to its categories.

If you are looking for a document that contains no formatting, single spacing, and margins at one-inch top, bottom, left, and right, then the Single spaced blank document template will do just that. In this exercise, you select this template to create and save a Word document.

USE the document that is open from the previous exercise. Click the File tab, and then click New. The New screen displays the available templates. Scroll down and review the accessible templates. First determine what type of document you need to create. For this exercise, you select a blank template. Click the Single spaced blank document, and then click the Create button. Creating a Document Using a Template In this exercise, you use the document you created from the template in the previous exercise to write a memo and save it, not as a template, but as a standard Word file.

OPEN Word if it is not already open. Click the File tab, and then click Save As. Then click your flash drive to open that location. In the File name box, type Welcome Memo. Type the document as follows and press the Tab or Enter key as indicated.

By pressing the Tab key twice, you are aligning the text at the one-inch marker on the ruler. Enclosed please find the meeting and refreshment schedule for the next six months. See you in January! SAVE the document, then leave open for the next exercise.

Finding Templates on the Internet Microsoft offers numerous templates online, and other templates are also available from third-par- ty providers, as well as other users in the community.

You can select from a category using the Office. In this exercise, you select a template category and view a listing of templates online. Word should be open from the previous exercise. In the Search for online templates box, type forms, and then click the Start Searching button.

Additional templates appear. You can also filter the templates by category to narrow your search. Preview by using the scroll bar and select any template.

Click Create. CLOSE the forms template and do not save. As the assistant to the Tech Terrace Real Estate manager, you are in the beginning stages of gathering the materials together for the annual report. You decide to use one of the available templates in Word Click the File tab, and then select New. In the Search for online templates box, type Annual Report Timeless design , and then click the Start Searching button.

Select the template with the image, and then click Create. The template will download. On the first page, click the drop-down arrow by the [Year] variable and select the current date—note the year displays in the placeholder. As you gather information for the report, you begin entering data into the document.

Click File, and then click Save As. In the File name box, type Annual Report. Change the file type by clicking the drop-down arrow and select Word Template. Note that you might need to select your flash drive again because Word automatically saves templates to the Templates folder located on the computer. Click SAVE. LEAVE the document open for the next exercise. Modifying a Template You might find that a template needs some changes to meet your needs.

Rather than making those changes to the document every time you use it, you can choose to modify the template itself. You can modify the template files in this location to create customized versions. In the following exercise you will make changes to the downloaded copy of the template that you used in the previous exercise. On the File tab, click Open. To do so, open File Explorer and, on the View tab, select the Hidden items check box.

In the Open dialog box, select Annual report Timeless design. Click Open. The template opens for editing. Select the first five lines of text. On the Home tab, in the Paragraph group, click Center to center the selected lines. On the File tab, click Save As. The same folder opens as you selected in step 2. In the File name box, change the name to Annual report modified. On the File tab, click New. On the File tab, click Options, and click Save.

In the Default personal templates location, enter the same path as in step 2 and click OK. You should then be able to resume the procedure at step Click Annual report modified to start a new document with that template. Close the new document without saving your changes.

There you find the printing options, including printer properties and settings. The Preview pane gives you an opportunity to see what your printed document will look like, so you can correct errors before printing. Previewing in Backstage Before printing your document, you need to preview its contents so you can correct any text or layout errors.

In this exercise, you learn to use Backstage to preview your document. While the ribbon contains commands you use while working within a document, the Backstage view contains commands for managing the document. On the left side of the Backstage screen, there are tabs that enable you to create, open, save, close, share, print, and view information about your documents.

To exit the Backstage screen, you can click the Return to Document icon, which is a circled left arrow located in the upper-left corner, or press the Esc key. The Print command feature includes three sets of options: Print, Printer, and Settings. Choosing the Print button au- tomatically prints the document to the default printer using the default settings. Use the Copies spin box to change the number of copies to be printed. The Printer options enable you to select an installed printer, print to a file, or change printer properties.

Use the Settings options to control document-specific print parameters. For example, you can choose to print only specific pages, change the paper size, and select collation options. You also have access to Page Setup here, where you can change additional settings for the document. The Preview screen to the right of the Print options settings enables you to view your document as it will appear when it is printed, so you can make any necessary changes, such as changing the margins or orientation, before printing.

The Preview screen lets you preview every page by clicking on the right and left arrows to page through multiple-page documents. Click the File tab, and then click Print. The Print screen opens with the Print options on the left and the Print Preview on the right, as shown in Figure Click the Return to Document icon or press the Esc key to close Backstage.

Your document will be saved with the same filename on your flash drive. Choosing a Printer If your computer has access to multiple printers, you might need to choose a destination printer for your document. If your printer is already set up and ready to print, as is the case in most class- room environments, you do not need to complete this exercise. Otherwise, follow this exercise to choose a printer.

Take Note Before printing your document, check with your instructor. Figure 2. In the Printer selection area, click the drop-down arrow to produce a list of all printers Available printers connected to your computer see Figure Available printers 3. Select a printer, and then click the Print icon. Changes to Settings options apply to the current document. In this lesson, you learn how to change the Settings options before printing. Check with your instructor before printing this exercise on a lab printer.

Click the drop-down arrow on Print All Pages to produce the menu shown in Figure Figure Print options Print settings 2. Select Print Current Page, and then click the Print icon. Selecting this option prints the current page. Return to the Print screen area.

In the Copies section of the Print options area, click the up arrow to select 2, and then click the Print icon. Place your insertion point at the beginning of the first paragraph, and then hold down the left mouse button and drag to the end of the paragraph to select it.

Click the Print Current Page drop-down arrow, select Print Selection, and then change the number of copies from 2 to 1 by clicking the down arrow.

Next, click the Print icon. The selected paragraph is printed. Click the File tab, and then click Close to close the document. The Annual Report document should still be open from a previous exercise.

This eight-page document is now printed on four pages with two pages per sheet. Click the Close button to close both the document and Microsoft Word. The first screen you see when you open Word is called the: a. Word screen b. Recent screen c. Start screen d. Screen saver 2. Which of the following contains the commands you use most often, such as Save, Undo, and Repeat. Quick Access Screen b. Quick toolbar c. Quick Access Toolbar d. Quick command 3.

The headings that appear on the Ribbon, such as File, Home, and Insert, are called: a. Which command would you use to save a document for the first time? Save b. Save As c. Save for th e first time d. Either a or b 5. Which of the following options would you use when saving a document with a new filename? When you start Word , a new blank document appears.

Clicking the Print button on the Backstage Print screen sends the document straight to the currently selected printer with the default settings. The File tab can be used to save and print files. You can hide the Ribbon by double-clicking the active tab. Previewing and printing can be completed by accessing Backstage. Create the following letter in block style with mixed punctuation. When Word opens, the Recent screen appears. Click Single spaced blank document. Use the vertical scroll bar to locate your flash drive.

Create a folder on the flash drive and name it Lesson 1 Projects. Double-click to open the folder. In the File name box, type Quotes. At the insertion point, type January 10, 20XX. Press Enter four times to create blank lines. David Pacheco Press Enter once. A Datum Corporation Press Enter once. Type the salutation Dear Mr. Pacheco: 9. Type the body of the letter: It was our pleasure meeting with you last week to discuss quotes for the components you requested. As agreed upon, the specifications discussed will be provided to you once we receive final approval from you.

Type At Proseware, Inc. Type the closing Sincerely,. Press the Enter key four times. Type Joe Villanueva. Proof your document carefully. The updated version of the letter will be saved with the same filename in the lesson folder on your flash drive.

LEAVE the document open for the next project. Project Printing a Document After proofing the letter you just wrote, you are ready to print copies of the document. Use the Quotes document you created in Project In the Copies section of the Print options area, click the up arrow to change the number of copies from 1 to 2.

Click the Print icon. Click Save on the Quick Access Toolbar. After opening a document, you can access related commands on the View tab, shown in Figure Use this figure as a reference throughout this lesson, as well as the rest of the book. You can also change the view by adding horizontal and vertical rulers or gridlines; increasing or decreasing the zoom value of the document view; arranging the document windows; viewing documents side by side; or splitting the document.

In addition, the Navigation Pane provides options for browsing and searching in a document. Word also enables you to open and arrange multiple document windows. You learn about all these features in this section. Opening an Existing Document Word can open files that have been saved in Word format or many other popular formats, such as.

TXT, or. You can edit the documents in Word and save the document in the original file format or another file format. The Open button in the Open dialog box contains a drop-down arrow that displays options for opening a document in a different manner. See Table for a list of options. In this exercise, you learn to open a document using the Open dialog box. Table List Description Options for opening files Open Read-Only Opens the document as a read-only file—no changes can be made to the document.

Open as Copy Opens a copy of the original document. Open in Browser Opens the document that was saved as a web page in a web browser. Open and Repair Opens and repairs corruption to the document. To access the Open screen in Word , you click the File tab and in the Backstage view, click the Open command.

You can locate a file quickly in the Recent Documents list, which displays the last 25 documents you accessed. From any computer, you can open documents that were saved to your OneDrive. Or, you can open documents that were saved to your local hard disk. Using this combo box, you can open existing documents from locations such as a flash drive, a hard drive, a network location, the desktop, or a portable device.

For the purpose of these exercises, the instructions assume that all data files are stored on your flash drive. Connect your flash drive to one of the USB ports on your computer. Click the File tab to open Backstage. The Open screen appears, with locations on the left side and recently opened documents on the right. Notice the right side of the screen displays the current recent folders. See Figure , but note that your screen will not be identical to the figure.

Click the Browse button. The Open combo box appears. Use the scroll bar and scroll down and locate the data files for this lesson on your flash drive. Double-click the Lesson02 folder to open it. Locate and click Star Bright Satellite Proposal once. Click the Open button.

The document appears. In this section, you learn to use the Document Views command group to change the way Word displays your document. Some tools are available for editing and navigating through the document.

To advance to the next page, click the arrow key on the right of the screen or tap if you are using a touch screen. It displays the document as it will look when printed and enables you to use the Ribbon to create and edit your document. Advanced elements such as charts, graphs, pictures, and other objects are hidden in this view.

Click the View tab to see the command groups that are available. In the Views group, click the Read Mode button to change the view of the document as shown in Figure The document page layout changes with an increased font size for easier reading. Click Tools on the menu in the upper-left corner of the screen to produce the Tools options menu, as shown in Figure Four additional commands appear.

The inactive commands change to active after an action has been performed. Figure Tools options menu 4. Hover the mouse over each command to view a ScreenTip, and then click Edit Document. The screen changes to the Print Layout view for editing.

Click the Read Mode button again. Click View on the menu, and then click Navigation Pane. The pane opens on the left side of the screen. This allows you to navigate your document quickly by selecting headings and pages, or by searching for text. In the Navigation Pane, click Option 3 and notice that your document jumps to that location.

Option 3 is formatted with a heading style. Click the Pages tab, and then click the first page. Page images are called thumbnails. Click Close X on the Navigation Pane to close. Basic Editing 25 Click the Web Layout button in the View tab. This view allows you to see the document as a web page. Click the Outline button, and notice the Outlining tab and the groups of commands that appear for editing outlines. Click the Close Outline View button.

Click the View tab, and then click the Draft view button. This view is typically used for editing text. Click the Print Layout view button to return the view of the document back to its default setting. Note that some of the View options buttons are also available on the status bar at the bottom right of your screen. Click each button and compare the resulting views with the views you accessed from the View tab. Use update queries to change data in Access Query criteria 2: Using date criteria in queries.

Add numbers in Excel. Basic math in Excel. Create a chart. Create your first Excel workbook. Freeze or lock panes. Top tips for working in Excel Online. Understand and use cell references.

Use AutoFill and Flash Fill. Add or subtract time. Average a group of numbers. Insert headers and footers. Make the switch to Excel Sort and filter data. Take conditional formatting to the next level. Use conditional formatting. Advanced IF functions. Array formulas. Create and manage drop-down lists. Create a PivotTable and analyze your data. Password protect workbooks and worksheets. Print worksheets and workbooks. Webinar: Understanding Power Pivot in Excel Webinar: Understanding the Excel Data Model.

Work with macros. Create your first OneNote notebook. Using Tables in OneNote. Webinar: Back to school with OneNote. Webinar: OneNote for free plus cool new tools. Webinar: Onetastic for OneNote. Add and use contacts. Calendar basics. Email basics. Fonts, hyperlinks, and spell check. Recall and replace sent messages. Setting up automatic replies and inbox rules in Outlook. Send and open attachments. The ins and outs of BCC.

Use Instant Search to find Calendar items. Use Instant Search to find contacts. Use Instant Search to find messages and text. Webinar: Using Outlook Web App. Add holidays to your calendar.

Control spam. Create or delete a search folder.