 Presenter notes:  This Microsoft Excel presentation is a prepackaged solution for basic Excel training.  You may use the presentation as-is or customize it.  Complete TechRepublic’s feedback form for a chance to win a free TechRepublic title.  Remove this slide before presenting the slideshow. Tips for maximizing Microsoft Excel 2010 Say hello to the ribbon • Revolutionary way to work. • Simple click to access. • Tabs on the ribbon replace menu structuring. File format changes abound  The file format used by Microsoft Excel 2010 is an XML-based format.  The new format provides less rigid standards for its files, making documents more accessible and easier to handle. Creating formulas  Excel formulas are powerful and versatile.  Excel uses a specific order of operation.  Use parentheses to override the order of operation (i.e., =2+3*2 results in 8 while =(2+3)*2 results in 10). Using functions  Use functions to calculate financial and statistical expressions.  Access functions by clicking the Formula tab and selecting Insert Function in the Function Library group. Cell operations  Refer to contents of cells instead of numbers.  Make for easy manipulation and provide capability for what if scenarios.  Cells are named by a unique letter and number combination.  Formulas use this combination to evaluate the contents of a cell.  Key Performance Indicator reporting is available to show graphical representation without a chart or graph. Absolute v. relative  A relative reference changes when a formula is copied, but not when a formula is moved.  Use a dollar sign ($) to mark a cell reference as absolute.  Highlight any cell reference in the formula bar and press F4 to cycle through the relative/absolute combos. Formatting a cell and its data  Excel offers numerous formatting options.  Excel formatting includes boldface, italics, underline, shading, lines, currency signs, percentages, and more.  Cell and data formatting options are on the Home tab in the Font, Alignment, and Number groups. Formatting a page    Change page margins to fit more content on a page. Add a header or footer with the date and time or any other static information. See additional items in context. Cell operations - KPI Conditional formatting of cells allows for better representation of data. Using filters  Filters enable displaying specific data subsets from a long table.  Use multiple or custom filters to quickly drill down to the exact data you require.  Use filters to compare data. AutoFilter options  AutoFilter includes several options:  Sort Ascending / Sort Descending  Color (where available)  Custom Sorting data  Use Excel’s Sort feature and combine multiple Sort levels to sort data exactly as you require.  Advanced options further customize data sorting.  Sorting features are on the Data tab in the Sort & Filter group. About subtotals and data levels  Subtotals provide at-a-glance subset totals.  Create subtotals by sorting tables according to your needs.  Display subtotals by clicking the Data tab and then clicking Subtotals in the Outline group. Using subtotals and data levels  Related data levels let you quickly view just a grand total, subtotals, or all the data. PivotTables    Enable quick reviews of what if scenarios. Manipulate data without accidentally deleting it or changing it. Display data in a meaningful way. Creating PivotTables  Create PivotTables using the PivotTable and PivotChart Report Wizard. Creating charts     Excel supports numerous chart types. Use different chart types to portray different kinds of information. Create charts from pivot tables. Create charts using the Chart Wizard. Using macros  Simplify routine tasks.  Automate common functions.  Easily record macros and play them back to repeat the action as needed. Exporting Excel data/charts  Excel data is easily exported to other Microsoft Office applications.  You can copy and paste information from one Office application to another. Exporting Excel data/charts  Link data between Office applications.  Linking data enables changes made within one application to be reflected in another. Retrieving database data  Combine Access’ database power with Excel’s flexibility.  Databases and spreadsheets have many important differences.  Import Access data a table at a time into Excel. Printing Excel data  Excel supports numerous print configuration options:  Page margins  Column and row headings  Date and time information  Configure printing options from the Page Setup group in the Page Layout tab of the ribbon. Share Excel data on the Web  Share a spreadsheet or worksheet on the Web.  Change the file name (if needed) and specify other options. Collaboration features  Microsoft SharePoint Services empower enhanced collaboration through support for:  Document Workspaces  Meeting Workspaces Final steps  Are there any questions?  Thank you for attending.  Don’t forget your handout.