Corporate Strategies by SkillPath
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

    Corporate Strategies by SkillPath 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