(PDF) Microsoft Office Training Manual | robert banda – replace.me.Best Practices For Microsoft Office Outlook PDF Book | Free PDF Books
See options for work. Office is now retired Get the most up-to-date version of Outlook and have your email, calendar, and contacts in one place. See plans and pricing for Microsoft Shift your business to Microsoft Collaborate with ease With 1 TB of OneDrive cloud storage, you can back up, share, and coauthor workbooks from any device.
Take Outlook on the go Keep up with email, plus review and edit attachments from anywhere, with powerful mobile apps. Always up to date Get exclusive, new features and security updates available only for Outlook in Microsoft Outlook Compare Microsoft Office Product features.
Improved calendar features. Outlook Groups. Improved conversation view. Not Included. Mobile apps for your devices. Share files from the cloud. Always up to date. Always have the latest Office apps, features, and services. Swipe to view more plans. Get more done. On the go. Upload and share attachments from OneDrive without leaving Outlook. Recipients have automatic access to the latest version. Microsoft plans include premium versions of these applications plus other services that are enabled over the Internet, including online storage with OneDrive and Skype minutes for home use.
See system requirements for compatible versions of Windows and macOS, and for other feature requirements. However, Internet access is required to install and activate all the latest releases of Office suites and all Microsoft subscription plans.
For Microsoft plans, Internet access is also needed to manage your subscription account, for example to install Office on other PCs or to change billing options.
Internet access is also required to access documents stored on OneDrive, unless you install the OneDrive desktop app. You should also connect to the Internet regularly to keep your version of Office up to date and benefit from automatic upgrades. To reactivate your Office applications, reconnect to the Internet. Documents that you have created belong fully to you. If you cancel your subscription or it expires, you can still access and download all your files by signing in to OneDrive directly using the Microsoft account you used to set up Microsoft You do lose the additional storage that comes with your subscription, so you must save your files elsewhere or buy more OneDrive storage if your OneDrive account exceeds the free storage quota.
If you purchase an auto-renew subscription, your subscription starts when you complete your purchase. You can purchase auto-renew subscriptions from Microsoft If you purchase a pre-paid subscription, your subscription starts when you activate your subscription and land on your My Account page. You can purchase pre-paid subscriptions from a retailer or reseller, or a Microsoft support agent. In the section called Header is a pull-down list of predefined headers.
Simply click on the down arrow and choose from the list of available headers. In the section called Footer is a pull-down list of predefined footers. Simply click on the down arrow and choose from the list of available footers.
Use the following buttons to add special options: Allows you to customize the font. Inserts the current Page Number. Adds the Total number of pages in the printout. If you have a picture, use this to Format the Picture. If you selected a block before you entered this box, the block will already be displayed. If not, you may enter the range as A1:B15 to specify that the block from A1 to B15 should be printed. You can enter more than one range if you separate the ranges with a comma – as in A1:B15,DF Print titles This section allows you to specify rows to be printed along the top or the columns to be printed along the left of each page.
To specify a range, click in the row or column section and then type the block. Click on this button to the right of these two sections to return to the worksheet to select the block. When done, reactivate the Page Setup dialog box. Black and white is used to print in black and white for faster printing.
Checking the Draft quality option speeds up the printout by printing less graphics and suppresses the gridlines. Check the Row and column headings box to print the row numbers and column letters around the border of the printout. Depending on your preference, you can choose to print Comments on a separate page at the end of your document or as they are displayed in the worksheet. Page order Use this section to specify the order pages are to be printed.
You can choose to print Down, then Across or Across, then Down. You should notice the button to the right side of each of the tabbed boxes. You should also notice the button within each of the tabbed dialog boxes. If you want to see how the worksheet will print based on the current settings, click on this button.
Once you have made your selections from the various tabs, click on the button. If you do not specify otherwise, Excel assumes you want to print the entire worksheet.
It is possible, though, to specify a print range. This button allows you to further specify how the document will be printed. You will be taken to a dialog box where you can define Once all printer options have been set, choose to have Excel begin printing the document. Create a second formula in cell G2 which calculates the percentage of the objective and then add totals at the bottom of the table for each of the three months.
If, however, you are in the midst of working with one file and then decide to create another workbook, you will need to instruct Excel as to what type of new document you want to create. A template is used to determine the basic structure of the workbook and can contain predefined settings, such as formulas, formatting, and macros.
The far left section contains a list of available template categories that you can base your new workbook on. The new workbook will be created – based on the template you have selected. Choosing to open a file will place the requested workbook in another window so that more than one file can be open at the same time.
You can then switch between the opened workbooks using the taskbar across the bottom of your screen or by accessing the View Ribbon. The following dialog box will be displayed: Along the left side of the dialog box, Excel displays the Navigation Pane. You could then select the folder containing your Excel files. If you click on the down arrow beside the button, you can choose from a list of options such as opening the file as read- only or as a copy.
For example, if you have a title in cell A1 that you would like centered across several adjacent columns they must be blank , you can have Excel automatically merge the cells and then center the data in that new cell.
Once selected, release the mouse button. If you select this tool a second time, Excel will remove the centering and place the data in the original cell. This can be useful when trying to label narrow columns. Begin by selecting the cell s to be modified.
Click on the Orientation tool which is located within the Alignment section on the Home Ribbon. A list of orientation choices is displayed. Select the one you want to use. If you select the same choice a second time, the cell s will revert back to the normal orientation. This can make numbers difficult to read at times and inconsistent. Excel does, however, allow you to access other built-in formats such as percentage signs, dollar signs, etc.
Select the cells to format and then choose one of the following tools located within the Number section on the Home Ribbon : Formats the current selection for currency with a dollar sign, a comma as a thousand separator and 2 decimal places.
Example: 4, Each time this button is selected another decimal place is added to the selection. Decreases the number of decimal places displayed. Each time this button is selected another decimal place is removed from the selection.
Click on the down arrow beside this tool located within the Number section of the Home Ribbon to choose from a list of formats. These formats include fonts, borders, patterns, alignment, and shading. Notice you can create a new cell style yourself or merge styles contained within another workbook.
If you have a shortcut on your desktop, double-click on the Microsoft Office PowerPoint icon. Although the quickest way of running PowerPoint is through the desktop shown above , you can also open the Start menu which is located along the left side of the taskbar at the bottom of the desktop to locate any program available on your system. You will notice that the program window includes many of the standard elements common to most Office applications as well as a few items that are unique to PowerPoint.
Along the top left corner of the screen is the Office Menu Button which provides quick access for creating, opening, converting, saving, printing, preparing, sending, publishing, and closing files.
Recently accessed presentations are also listed within this menu. This button provides the only true menu within PowerPoint or the other Office applications. The name of current presentation is displayed in the middle of the Title Bar. The second line contains a new feature within PowerPoint and is called the Ribbon Bar. Each tab on the ribbon relates to a type of activity, such as inserting an object or designing a slide.
There is no way to delete or replace the ribbon with the toolbars and menus from previous versions of Microsoft Office. However, you can minimize the ribbon to make more space available on the screen. If you prefer using the mouse, point to an empty space to the right of the last tab across the top of your screen and click the [RIGHT] mouse button.
From the pop-up menu, choose Minimize the Ribbon. Each time you press A, PowerPoint displays corresponding letters for the ribbon items to help you to continue using keyboard shortcuts to select them.
Below the ribbon are three window panes. Select Outline to include the actual text of each slide within this pane. Select Slide to view thumbnails of each slide within this pane. The large middle pane contains the currently selected slide and is your actual working area. Directly beneath the working area is yet another pane which can be used to add notes to the current slide.
Each presentation is based on a theme which consists of a family of fonts, colors, graphics, etc. The third icon along the status bar indicates whether PowerPoint has detected any spelling errors. A red X indicates an error has been located. Towards the right side of the status bar are the View Icons. These icons allow you to switch to the various views – depending on what you are currently doing.
For example, normal view is best for adding graphics or editing existing objects while the slide sorter is used to quickly rearrange or delete slides within your presentation.
The slide show tool is used to display a visual presentation of all of your slides using various special effects. Just to the right of the view icons is the Zoom area. PowerPoint displays the current percentage just to the left of this area. To quickly move to the next or previous slide, PowerPoint provides buttons in the lower right side of the vertical scroll bar. The following dialog box will be displayed: Along the left side of the dialog box, PowerPoint displays the Navigation Pane.
You could then select the folder containing your presentation files. However, if you click on you can choose to display other types of files such as templates or Web pages. Once you have located the presentation you want to open, double- click on it or highlight the name of the file and click. If you click on the down arrow beside the button, you can choose from a list of options such as opening the file as read-only or opening a copy of the file.
TIP: To open more than one file at a time, select the first by clicking on its name once to highlight it. Once all required files have been selected, click on to actually open them. TIP: By default, PowerPoint lists your most recently accessed files along the right side of the Office menu so that you can quickly reopen a presentation.
You can increase the number of files displayed within the Office menu to a maximum of 50 by clicking on the button within the Office menu and then choosing the Advanced set of options. Simply click on the presentation file you want to switch to and that file will become the active window.
They are most often used when presenting information to an audience. Slide shows can be instrumental in conveying your message to a group of people since graphics can help make it more understandable. You can connect your PC to an overhead projector and display the show to a large group of people or it can be used on the PC in front of a small group i.
It can either be running in the background as you speak to the group or you can add enough special effects and sound that the show itself is sufficient in conveying the point you are trying to make. Rather than simply showing the audience a set of boring slides, including animation and special effects give the presentation added appeal so that the slides hold the audience’s attention while still making a dramatic point.
It is possible to control the flow of the show using either the keyboard or the mouse. It can be a self-running demonstration or can run interactively with the audience depending on your requirements. You can also change the sequence of the slides in the middle of the show if needed.
Running a slide show displays each of the slides contained within a presentation file one at a time on the computer screen. You can determine an automatic time interval between slides being drawn on the screen or you can instruct PowerPoint that you want to manually determine the speed each of the slides is drawn.
If you run it manually, you can use the mouse or keyboard to move between slides. Another nice feature is the ability to Rehearse the times between slides by previewing the show and setting individual times for each slide of the presentation.
PowerPoint will immediately begin displaying the slide show – with the first slide taking up the full screen. Click on this button located with the other slide show tools in the bottom left corner of the slide show screen to display the previous slide. The tools are very light in color so that they do not distract from the slide show.
Press Y or N to move to the next slide. Press Z or O to move to the previous slide. Press X to cancel the show.
The leftmost pane is most often used to display thumbnails of each slide within your presentation while the large middle pane displays the currently selected slide. The pane beneath the working area is used for adding and displaying slide notes. To switch between the various views, PowerPoint offers a series of buttons located along the bottom right of the screen, as shown in the diagram below: Each view has its advantages.
For example, the normal view is best used to show the outline and current slide simultaneously. The slide sorter view is best used to view the entire presentation at once, rearrange the slides, copy and move slides between presentations and delete slides from the presentation. The slide show view is best used to preview your presentation to verify the timing and transition methods between slides.
Along the status bar just to the right of the viewing icons is the Zoom area. You can also drag the slider horizontally to change the slide size as it appears on the screen. These miniature slides are spread across several rows on a single screen whenever possible. This view is the quickest way to move slides around and delete unwanted slides.
Click on this button located with the other view buttons along the bottom right side of the screen to access the Slide Sorter view. As you begin dragging a slide, a thin vertical line is displayed to indicate where the slide will be placed when you release the mouse button. This option is also useful when working in slide view to show you what the slide will look like when printed on a black and white printer.
Once you select grayscale or black and white, the ribbon changes to display various grayscale options to further customize your view. Once you have chosen grayscale or black and white, click on this button to return to color view. These notes can be printed as a reference for the speaker to help them with the presentation as they deliver it or can be left blank and handed out to the audience so that they can write their own comments as the presentation is being delivered.
The screen changes to display the slide with an area at the bottom for notes, as shown in the diagram below: Before entering your notes, you might want to switch to a larger viewing size by clicking on the increase button located just to the right of the current zoom factor along the bottom right side of the screen.
Notice along the bottom left side of the screen on the status bar that PowerPoint indicates the current slide number. Along the bottom right side of the slide on the vertical scroll bar are two buttons which can be used to quickly move to the previous and next slide within the presentation. Click on either of these two buttons to move to the previous or next slide. Along the right side of the slide, PowerPoint displays a vertical scroll bar which can be used to move to specific slides.
PowerPoint allows you to move, copy, resize, delete and change the color of the selected object. If the object contains text, you may also edit the font and size of the text, as well as any attributes that may have been applied. Move to the edge of unfilled objects or to the middle of filled pictures. Once you see the pointer change to a four-way arrow, click the [LEFT] mouse button. An object is selected when it has the outline of a box with small circular handles.
A rotation handle appears at the top of the selected object. NOTE: If you click on an object a second time while holding S down , you will be deselecting that object. TIP: You can also click in an empty area and drag a rectangle around all the objects to select.
PowerPoint selects all objects enclosed within the rectangle. From the pull-down list, choose Select All. To unselect specific objects, hold the S key down and click the objects that you do not want to include in the group. From the pull-down list, choose Selection Pane. The right side of the screen will display a list of all the objects on the slide. You can also rename objects by double- clicking on its current name.
The reorder arrows are used to change the priority of overlapping objects. Be sure that the mouse pointer changes to the four- way arrow. Click and drag the object to its new location. Notice that as you drag the mouse, a transparent version of the object follows your mouse pointer. TIP: You can also move an object by selecting it and then clicking on located within the Clipboard section of the Home Ribbon. To paste it in a new location, click on the tool. Be sure that the mouse pointer changes to the four-way arrow.
Hold down the C key. Continue to hold the C key down while dragging the object to its new location. As you drag the object, notice that a transparent copy of the object is dragged with the mouse pointer. The original object will be copied to its new location. TIP: You can also copy an object by selecting it and then clicking on located within the Clipboard section of the Home Ribbon. To paste it, click on the tool. NOTE: Dragging the handles of a text item only serves to change the left or right margins of the text block.
This may cause the text to wrap within the margins. To undo more than one action, click on the down arrow beside the tool. To modify the default value, click on the Office button and choose located along the bottom right section of the menu. From the resulting Window, choose Advanced. Click on this tool located on the Quick Access toolbar to Redo the last action. You can change the color of the lines surrounding an object, the fill color or pattern within the object, add shading or even apply 3D effects to some objects.
If you do not see the desired color from the list, select More Outline Colors Notice as you move your mouse over each of the options within the list, PowerPoint provides a preview of the selected object using the option you are currently pointing to. If you do not see the desired color from the list, select More Fill Colors A gradient typically consists of two colors gradually blending from one color to the other. You can select the colors to be used as well as the intensity and the direction in which the gradient will be generated.
Textures are basically small patches of patterns that resemble real- life textures such as marble, cloth, grass, paper, wood, etc. Rather than using one of the built-in textures or patterns, you can also choose to fill an object with a custom picture. First, select the text to be edited by clicking the pointer on the text item that you want to edit. You can also select a single word or group of characters from within a text object. Total PDF Converter.
You can process up to thousands of files at the same time. The powerful applic. Nitro PDF Reader bit. The application has numerous features.
You can comment, review, and collaborate all your work. It lets you fill and. Download Latest Version Office Service Pack 1.
[PDF] MS Outlook A Beginners Guide free tutorial for Beginners
We have eBooks for every area of interest suitable for download. Free access for microsoft office outlook user guide pdf free to read online or download to your computer. Download the file. Login or Create an account to leave a feedback.