Microsoft Excel 2010 Training

Training Courses

Microsoft Excel 2010 Introduction Training

In this Microsoft Excel 2010 Introduction Training course students will be introduced to spreadsheet terminology and Excel's window components, students will learn how to use the Help system and navigate worksheets and workbooks. Then they will enter and edit text, values, formulas, and pictures, and they will save workbooks in various formats. Students will also move and copy data, learn about absolute and relative references, and work with ranges, rows, and columns. This course also covers simple functions, basic formatting techniques, and printing. .More Details

Microsoft Excel 2010 Intermediate Training

In this Microsoft Excel 2010 Intermediate Training course, students will learn how to manage multiple worksheets and workbooks, apply special formals, define and apply cell and range names, sort and filter data, share worksheets as web pages and email attachments, use trendlines and sparklines, track changes in a workbook and use PivotTables to analyze large amounts of data.More Details

Microsoft Excel 2010 Advanced Training

In this Microsoft Excel 2010 Advanced Training course, students will automate common Excel tasks using Macros, apply advanced analysis techniques to more complex data sets, and learn how to use VLOOKUP and HLOOKUP to find values in worksheets.More Details

Microsoft Excel 2010 PowerPivot Training

In this Microsoft Excel 2010 PowerPivot Training course, students will learn how to use PowerPivot to import and manipulate data, create PowerPivot reports, use DAX functions and protect and distribute PowerPivot reports.More Details

Microsoft Excel 2010 VBA Training

In this Microsoft Excel 2010 VBA Training course, students will learn to use VBA in the Excel 2010 environment to create interactive worksheets and automate common worksheet tasks.More Details