SkillPath Seminars
Call us: 1-866-222-6315

In Microsoft® Excel® 2010 Basic, participants will learn...

  • How to customize the ribbon to increase productivity and even create new tabs and hide the ones never used
  • Data, reports, graphs and formulas—making the most of Microsoft Excel’s many talents
  • How to review, share and print Microsoft Excel files and worksheets
  • Spreadsheets, charts and more—easy ways to make spreadsheets and figures into colorful, clear and precise presentations

This Microsoft Excel 2010 Basic training course is an informative, hands-on experience that will provide your employees with the “how-to’s” for breezing through spreadsheets, forecasts, graphs and financial reporting, plus little-known shortcuts and time-saving techniques. They will return to work working smarter and harder after attending this training course.




    SkillPath Training Information

    SkillPath Enterprise Solutions can bring the following topic to your company: Microsoft® Excel® 2010 Basic

    Click on the link below for more information. http://www.skillpath.com/index.cfm/on-site/training/topic/Microsoft-Excel-2010-Basic



    TRAINING AGENDA

    Click on a title to view details

    Getting started—Microsoft Excel 2010 essentials

    +
    • Installation tips and tricks—how to decide which version, the 32-bit or the 64-bit, to install and the issues that may arise with the 64-bit version
    • What to know about the Microsoft Excel interface including working with the ribbon
    • How to customize the ribbon to increase productivity and even create new tabs and hide the ones never used
    • The Microsoft Office button is gone—how to use the new Microsoft Office Backstage view
    • Workbook and worksheet essentials—how to create, manage, save and rename workbooks and worksheets
    • How to increase productivity with special keyboard shortcuts and mouse techniques
    • How to get started quickly with one of the many templates Microsoft Excel has to offer
    • Uncover all the different Options settings and find out which ones might need to change

    Microsoft Excel formatting and styles

    +
    • How to modify the format of numerical data in worksheets
    • How to format large blocks of cells quickly and efficiently with the power of Format Painter
    • How to add, change, find or clear conditional formats
    • What icon sets are and how to use them to make important data stand out
    • Quick cell formatting from predefined styles
    • How to easily select a range of cells and convert it into a great-looking table that stands out on a worksheet
    • Secrets of the Merge and Center button and how to use it to create professional-looking headings
    • How to use the Format option to modify cell sizes and visibility, and organize and protect worksheets

    Formulas and functions—The real power of Microsoft Excel

    +
    • Mastering the mysteries of relative and absolute cell references—”must-know” information for working with formulas
    • Discover the Function Library and how to add functions to formulas and make sure the correct syntax is used
    • How to use the Insert Function dialog box to insert functions and to quickly get help on how the selected function works
    • How to use the Name Manager to name a data range and use it in formulas to save time and effort
    • How to use the Error Checking feature to check for common errors in formulas
    • How to use the Watch Window to watch the values of selected cells as values are changed on worksheets
    • How to use the Evaluate Formula dialog box to evaluate each part of a complex formula individually to locate and correct any errors
    • Understanding and using the Trace Precedents and Trace Dependents features

    Microsoft Excel—Objects, charts and Sparklines

    +
    • How to quickly insert objects such as pictures, clip art, shapes and more with just a few clicks of the mouse
    • How to insert complex mathematical equations and symbols into worksheets
    • How to use the new Screenshot feature to quickly insert a screenshot of any open application
    • How to quickly select data and insert a chart into a worksheet
    • Bar chart, pie chart, line chart—how to choose and use the right type of chart
    • How to use the Chart Tools to create stunning charts that have that professional look
    • How to save a finished chart as a template that can be applied to future charts
    • Stock, Surface, Doughnut, Bubble and Radar—how using advanced chart types can capture an audience’s attention

    Managing data—Connections, sorting, filtering and data tools

    +
    • How to create data connections to virtually any type of data, including simple text files, Web pages and other Microsoft Office applications
    • How to use the Sort feature to sort on not only values of cells but the color of the cells, color of the cell font and more
    • How to prevent bad data from being entered by using the Data Validation feature
    • How to automatically add subtotals to several rows of related data with just a couple of mouse clicks
    • Using the powerful filter features of Excel to view only the data needed
    • How to insert a slicer to interactively filter data
    • How to easily separate the contents of one cell into multiple columns such as first and last names
    • How to dramatically speed up data input with the powerful AutoFill feature and increase the power of the AutoFill feature by using Custom Lists

    Reviewing, sharing and printing

    +
    • How to add comments to a worksheet
    • Keeping track of the changes made to a spreadsheet by others
    • How to protect a workbook
    • How to share a workbook with others
    • How to quickly check for issues such as compatibility with previous versions
    • How to create a range of cells that other users can edit while the rest of the worksheet is locked
    • How to save time by creating a Custom view to select a print area
    • How to use the Print Titles feature to specify rows and columns to repeat on each printed page