Table Of Contents. Quick Links. Microsoft Office Excel Table of Contents. Previous Page. Next Page. Page 3 Create a Review or Approval Workflow Page 4: Overview Of Microsoft Office Excel Excel that is optimized for managing, consuming, and sharing spreadsheets.

A compact and robust file format, Office XML Formats allow for better data integration between documents and back-end systems. Page 5: Improve Spreadsheet Analysis Improved! Customization with Microsoft Office art, predefined styles, and integrated graphics help you apply a consistent, professional look to your spreadsheets that can easily be placed in other Microsoft Office system documents. Improve Spreadsheet Analysis New data analysis and visualization tools help you analyze information, spot trends, and access your company information more easily.

Her employees need a robust yet flexible tool for analyzing data to make more informed decisions. Office Excel offers a comprehensive solution. Important features are organized and presented in context. For example, when you are writing a formula to calculate a value, Office Excel displays the Formulae tab and toolset to help you in your selection. Page 10 Office Excel Some of the designer-quality formatting options include banded rows and columns for identifying key data or highlighting the last column of a table.

You can see a live preview of your selection before making the final changes. Page Professional Charting Tools Shared Charting Engine Across the Microsoft Office System The improved charting capabilities in Office Excel are shared across the Microsoft Office system, which means that you can create and interact with charts the same way— Page Custom Data Output Tools Faster Formatting with Cell Styles Cell Styles offer visual previews of how a cell might look with format enhancements, so you can modify the look of a report with fewer clicks.

Page Editing Report Headers And Footers Customization with Microsoft Office Art and Styles Customization with Microsoft Office art, predefined styles, and integrated graphics help you quickly apply a consistent, professional look to your spreadsheets that can easily be placed in other Microsoft Office system documents. You can apply these or other www. Page 15 www. Page Improve Spreadsheet Analysis When you apply color scales with one click, Excel uses the lowest, highest, and midpoint values in the range to determine the color scales.

You can change the colors or the way Excel determines the values for the highest, lowest, or midpoint values by selecting More Options.

Page Rules Manager You can change the icons or the way Excel determines the values for the icon sets, as well as pick from further icon sets, by selecting More Options.

Figure Conditional formatting icon sets Rules Manager Use the Rules Manager to work with conditional formatting when you need to: www. Page 19 Figure Enhanced filtering and sorting www. Page Easy-To-Use Pivottable And Pivotchart Views such as a SQL Server Analysis Services cube , all you need to decide is which fields to display as rows, which fields to display as columns, and which fields to display as values and in what form values can be displayed as sum, averages, or other calculations.

Page 21 PivotTable by using the chart gallery. Local and external filters It is now easier to filter data in PivotTable views. This is effective in cases where it would be tedious to select the individual items manually. It is also useful when the set is defined by a business rule. For instance, Top Sellers can change on a daily basis.

You can permit others to view the entire spreadsheet or only parts of it. In addition, you can help: www. The file formats have open, published format specifications that any technology provider can use to integrate Microsoft Office system documents into their solutions.

Because the file formats are compressed, they result in substantially smaller file sizes than with previous versions of Excel, Word, and PowerPoint, thereby reducing storage and bandwidth requirements.

A reference to the data connection file is added to the Office Excel spreadsheet. When the spreadsheet is executed in Excel Services, the server checks the connection in the library to see if it has www. Page Report Management Features Report Management Features Office Excel , coupled with Excel Services and Office SharePoint Server , offers important report management features to help ensure people can view the data they need while enhancing protection of the underlying proprietary information.

When you publish a document to Office SharePoint Server , you can control whether the viewer sees an entire spreadsheet, specific sheets within a spreadsheet, or charts, tables, PivotTable views, and Named Ranges within a spreadsheet. The workflow creates a task for each participant and notifies them with an e-mail message of a new document for review.

When participants receive the notification and open the spreadsheet, they can complete their review and indicate their status on a workflow completion form. Using Office Excel , you can upload documents to this repository directly from the application. As a result, you have greater control and management over your spreadsheets.

Page Information Management Policies As a result, you can add an extra layer of security to your spreadsheets by designating access to them. For example, if you only want to allow a certain department access to spreadsheets, you can easily define the spreadsheets to require the correct credentials.

Page Summary Summary Microsoft Office Excel delivers the Office Fluent interface that presents the relevant tools you need when you need them. New formatting tools, new charts, expanded row counts, and Page Layout View will enable you to create better and bigger spreadsheets faster.

Page System Requirements Microsoft Corporation on the issues discussed as of the date of publication. Because Microsoft must respond to changing market conditions, this document should not be interpreted to be a commitment on the part of Microsoft, and Microsoft cannot guarantee the accuracy of any information presented after the date of publication.

This manual is also suitable for: Office excel Print page 1 Print document 37 pages. Cancel Delete. Sign In OR. Don't have an account? Sign up! Restore password. Upload from disk. Upload from URL.

Microsoft PowerPoint download free tutorial in pdf - Was this information helpful?

Submitted On : File type : pdf Downloads : Advanced Word With this PDF tutorial you will be familiar with the basic functionality of Microsoft Word and you will learn how to write document with ease. PowerPoint Presentation This PDF tutorial introduces you to the basic features of PowerPoint which are particularly valuable in the teaching and learning environment.

Microsoft PowerPoint This PDF tutorial is aimed at beginner who wants to creat their own PowerPoint presentation ,easy course with illustrative images,free training lesson under 14 pages by Dawn Rauscher. Microsoft Excel : Essential Guide The purpose of this course is to provide a basic guide for student who wants to be familar with the basics of Microsoft Excel Local and external filters It is now easier to filter data in PivotTable views.

This is effective in cases where it would be tedious to select the individual items manually. It is also useful when the set is defined by a business rule. For instance, Top Sellers can change on a daily basis. You can permit others to view the entire spreadsheet or only parts of it.

In addition, you can help: www. The file formats have open, published format specifications that any technology provider can use to integrate Microsoft Office system documents into their solutions. Because the file formats are compressed, they result in substantially smaller file sizes than with previous versions of Excel, Word, and PowerPoint, thereby reducing storage and bandwidth requirements.

A reference to the data connection file is added to the Office Excel spreadsheet. When the spreadsheet is executed in Excel Services, the server checks the connection in the library to see if it has www. Page Report Management Features Report Management Features Office Excel , coupled with Excel Services and Office SharePoint Server , offers important report management features to help ensure people can view the data they need while enhancing protection of the underlying proprietary information.

When you publish a document to Office SharePoint Server , you can control whether the viewer sees an entire spreadsheet, specific sheets within a spreadsheet, or charts, tables, PivotTable views, and Named Ranges within a spreadsheet. The workflow creates a task for each participant and notifies them with an e-mail message of a new document for review. When participants receive the notification and open the spreadsheet, they can complete their review and indicate their status on a workflow completion form.

Using Office Excel , you can upload documents to this repository directly from the application. As a result, you have greater control and management over your spreadsheets. Page Information Management Policies As a result, you can add an extra layer of security to your spreadsheets by designating access to them. For example, if you only want to allow a certain department access to spreadsheets, you can easily define the spreadsheets to require the correct credentials.

Page Summary Summary Microsoft Office Excel delivers the Office Fluent interface that presents the relevant tools you need when you need them. New formatting tools, new charts, expanded row counts, and Page Layout View will enable you to create better and bigger spreadsheets faster. Click in this box and type in the cell address to go to.

You must press E when done. You can also use the vertical down the right and the horizontal along the bottom scroll bars to move. Drag the box in the scroll bar to move more quickly. The pointer does not move until you click in the cell to move to. Remember to look at the formula bar for the current cell address. If you are using a mouse with a scroll wheel, roll the rubber wheel located between the [LEFT] and [RIGHT] mouse buttons forward or back to quickly scroll through large worksheets.

Excel lights up column and row headings as you move from cell to cell. This helps to distinguish the current cell address. This tool displays Page Layout view. This tool displays Page Break Preview.

In addition to the three views discussed above, you can create your own custom views discussed in the advanced manual. A small dialog box will open allowing you to choose from a list of saved views.

You can clear the Office menu, tabs and current Ribbon from your screen so that you can see more of your worksheet. To redisplay the screen items, press X. Click in the cell you want to store the data in and then simply begin typing the word s , number or formula.

If you make a mistake and want to start over, press X. Notice as you type, the entry is displayed both in the cell and in the formula bar. A thin, blinking cursor appears to the right of the entry and moves as you type. You cannot use the arrow keys at this time to make corrections!

Pressing an arrow key at this point will enter what you have typed in the cell and then automatically move the pointer in the direction of the arrow key you pressed. Two symbols also pop up to the left of the formula bar. The X is used like the X key to cancel. When entering text, words are automatically left aligned within the cell while numbers are placed to the right. While entering columns of numbers, the column heading may not align correctly with the values.

If text is wider than the cell it is stored in, it will appear to "spill" into the adjacent cell s , providing they are empty. R Moves the cursor to the right one character. Q Moves the cursor to the left one character. In those instances it would make sense to delete the contents of the selected cell s. A single cell may contain one or more of the following: Formats Includes fonts, bold, borders surrounding the cell s , as well as, number formats e.

Contents The data stored within the cell numbers or text. Comments Can be attached to a cell to explain the reasoning behind its entry e. These comments are usually not printed. Choose what you want to clear from the pull-down list provided. Click on this tool located towards the top left corner of your screen to undo the last action.

Click on this tool located towards the top left corner of your screen to redo the last undo. While you may not require the entire worksheet, you may need to work on a Block of cells.

A block includes any group of cells in a rectangular format, as shown in the illustration below. Every block of cells has a beginning and ending address. The beginning address is the address of the cell in the top-left corner of the block whereas the ending address is the cell in the lower-right.

Normally, in the English language we use a dash to indicate a block of numbers, as in pages Excel, however, requires that you use the colon between the beginning and ending addresses. Remember that the dash represents subtraction in spreadsheet programs. For example, the block C3:E14 refers to cells C3 through E There are many commands e. The mouse changes to the thick cross when placed in the middle of a cell.

Dragging the pointer when it is this shape simply highlights cells. If the mouse is in the shape of a diagonal arrow, you can move the contents of the currently selected cell or block of cells to another location within the worksheet. The mouse changes to a pointer only when the tip of the arrow points to one of the outer borders of the cell block.

Dragging the pointer when it is in this shape actually picks up the contents of the cell s and moves them to another location. If the mouse is in the shape of a thin cross-hair, you can fill a formula or other information into adjacent cells within the worksheet. The mouse pointer changes to a thin cross-hair only when the tip of the arrow is placed in the small square located in the bottom right-corner of a cell.

Dragging the pointer when it is in this shape fills data. The pointer's shape should be a thick cross-hair. Click and drag to highlight. To select an entire column or row, click on the letter of the column or the number of the row. Hold the S key down and press the arrows to select a block.

The entire worksheet will be highlighted. Text will appear to "spill" over into adjacent cells as long as those cells are empty. If the adjacent cells are not empty, Excel will truncate the text. When entering large numbers, however, Excel will display the number in scientific notation if the column is not wide enough to display the entire number. However, if you apply formatting such as dollar signs , Excel will automatically adjust the column to fit the largest entry so that the number remains visible.

Make sure the mouse pointer is on the column margin line. The pointer changes to a cross-hair indicating you are on the margin line. In the example above, column F is being stretched to the right. Notice the "cross-hair". When creating formulas, you may use actual values, cell addresses or a combination of the two. This also ensures that formulas beginning with a cell address are not mistaken for text.

The formula itself is displayed in the formula bar located in the upper-left of the screen next to the cell address. NOTE: In order to view a formula, you must select the cell in which it is stored. TIP: If you select a group of cells and look at the status bar at bottom of the screen , Excel will display the total sum of the selected cells.

However, Excel provides a mathematical function which is used primarily to add blocks of numbers. The last function you chose will be displayed on the button. If you simply click on the button that function will be selected. To choose a different function, click on the down arrow to the right of the button and then select a new function from the list. Once the function has been selected Excel will display the Function Arguments box, as shown below: The box will display a description of the currently selected function and list the arguments required for the function.

The next required argument will be displayed in bold. This helps guide you through each step properly. Notice as you begin entering the arguments, the palette displays the current result. When you are done, click on to actually enter the function and close the box. This is called the AutoSum feature. The second click is used to confirm the selection. If, by chance, Excel has selected the wrong group of cells, you can highlight the correct block before clicking on the tool a second time.

The pointer should change to a thin cross-hair. When the mouse is released, the formula will be "filled" in all cells. Filling also works for text and numbers without formulas, such as months shown in the example above.

Excel's auto fill feature will fill a block of cells with either numbers or text depending on what is located in the first cell. As you begin filling the destination cells with months, Excel will display the name of each month as it is being filled so that you know how far to fill.

If you only enter a single number and then try to create a fill based on that single cell, Excel will simply copy the number down the worksheet. Once the two cells have been selected, release the mouse button. After selecting the cells to fill, click on this tool located within the Editing section on the Home Ribbon. A pull-down list of fill options will be displayed: Select the direction of the fill or define the series to use when filling. When you click on this icon, a list of auto fill options is displayed.

The default option is Copy Cells which instructs Excel to copy the data and formatting from the original cell to the destination cells. The Fill Formatting Only option is used to copy the format from the original cell to the destination cells. This does not copy the data from the original cell.

Select Fill Without Formatting to copy the data from the original cell to the destination cells without changing the existing format. NOTE: These auto fill options will vary depending on what you have just filled e. Click on the Save tool located on the Quick Access Bar. The first time you save a document, Excel provides a dialog box prompting you to enter a file name, as shown below: Letters, numbers and spaces are allowed. In this latest version using Windows Vista, the address bar is displayed a bit differently, as shown below: The path is displayed horizontally on the bar instead of vertically as was the case in previous versions.

If you want to save the workbook in another format such as another spreadsheet application or any previous version of Excel so that someone else can edit the file who does not have this version , click on the down arrow beside the box labeled Save as type and select the format from the list provided. Enter a name for the workbook in the box labeled File name and then click on to actually save the file.

Select the paper size you would like to use when printing your worksheet. Choose to either set the print area or clear it. Choose whether you want to insert a page break, remove one, or rest all page breaks within the worksheet. Scaling This section allows you to enlarge or reduce the printout. Not all printers will be able to use this feature. Use the Adjust to: option to reduce or enlarge the output from 10 to percent of the original size. Use the Fit to: option to specify exactly how many pages wide or tall you want the final printout to be.

Paper size Provides various paper sizes to choose from. Available sizes will vary from printer to printer. Print quality Allows you to specify the resolution dots per inch for printing. The higher the number, the better the quality - but it also takes longer. First page number Leave this option at Auto to start page numbering at the next sequential number or enter a number with which the first page should begin.

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.