Description

Excel 2010 Complete Training DVD Course

Basic, Intermediate and Advanced Level

Looking for Microsoft Excel training to improve your skills and save you time? This Basic, intermediate and Advanced Excel courses can quickly get you up to speed with Excel, taking you from complete novice to Expert. By the end of the course, you will be equipped with the real-world Excel knowledge you need to accomplish your daily tasks with ease.

In this course, you will learn:

• How to be a better, faster, and stronger Excel user
• How to save yourself hours of time and boost your productivity in Excel
• How to navigate the Excel Ribbon interface
• How to use math, statistical, logic and text functions
• How to find a value with VLOOKUP, HLOOKUP, INDEX, MATCH
• How to sort and filter your data to find exactly what you are looking for
• How to work with charts to present clear insights from your data
• How to create and format Pivot Tables
• How to record a basic Macro to automate repetitive tasks
• How to customize your page setup options for printing

Course Outline:

Microsoft Excel 2010 Basic Level 

1.0 Learning Basic Excel Elements
2.0 Applying Selection and Viewing Techniques
3.0  Utilizing Data Entry and Editing Techniques
4.0  Working with Excel Data
5.0  Formatting an Excel Worksheet
6.0  Performing Calculations

Microsoft Excel 2010 Intermediate Level 
1.0 Applying Formatting Techniques
2.0  Organizing Worksheet and Table Data
3.0  Using Multiple Pages, Worksheets and Workbooks
4.0  Inserting Graphic Objects
5.0  Creating Charts
6.0 Utilizing Formulas
7.0 Finishing Details before the Workbook is Complete

Microsoft Excel 2010 Advanced Level 
1.0 Managing Data
2.0  Collaborating with Others
3.0  Working with Data Tools
4.0  Recording and Using Macros
5.0   Using Functions
6.0 Analyzing Data with Pivot Tables and Pivot Charts
7.0 Finishing Details before the Workbook is Complete

DVD-ROM disc (sealed in a DVD-case)

System Requirements: 
PC Platform: Windows 10, 8, 7 and Vista
CD-ROM Drive speed: 24