The first day of online Excel training is designed to create a strong foundation for using the world's most popular business software as a place to organize and analyze information. Participants in this course will start by establishing fundamental skills and best practices essential for using Excel, and will leave with a working knowledge of basic formulas and functions, as well as key tools to organize, format, and manage data in a spreadsheet. This online Excel course is designed for Individuals, Career Changers, Skill enhancement.

Microsoft Excel Training: Introduction
MODULE 1: Essentials & Intro to Formulas and Functions		MODULE 2: Formatting, Spreadsheet Design, Page Setup & Printing
Introduction to the Excel 2010 Interface Zooming in and out of a worksheet Navigating and selecting cells Keyboard Shortcuts Entering and editing data Deleting/replacing cell data Performing simple calculations Saving the workbook file Checking compatibility with older versions of Excel Overview of the Formulas Ribbon Building basic Formulas Using simple Functions Copying formulas/functions with the AutoFill command Using Relative and Absolute cell references in calculations		Inserting rows & columns Moving & copying data Using AutoFill to complete a series of values Introduction to worksheet Themes Formatting worksheet data/using Cell Styles Using Excel templates/creating custom templates Managing worksheets: inserting, deleting, renaming, move/copy Grouping worksheets Freezing or splitting panes Creating custom views Spell checking your worksheets Setting print options through Page Setup Using the Page Layout view Printing your worksheet
Sign up to view this video		Sign up to view this video
Microsoft Excel Training: Intermediate
MODULE 3: List/Table Essentials & Charting		MODULE 4: Importing Data, Pivot Tables, Protecting & Linking Data
Overview of List design Formatting lists as Tables Single and Multi-level Sorting Removing duplicates from a list or table Filtering records in a list or table Search by Filter Inserting automatic subtotals in a list Inserting data charts Formatting and editing chart elements Adding/removing data from a chart Creating custom chart templates Printing charts Changing table and chart formatting through Themes Inserting Sparkline		Importing data from other sources Overview of exporting options Creating a database query Creating Pivot Tables from lists or tables Filtering Pivot Tables Using the Slicer tool within a Pivot Table Working with Pivot charts Applying Data Validation rules Applying built in Conditional Formatting Creating custom conditional formats Inserting & editing Comments Linking Data Cell, sheet, and file protection
Sign up to view this video		Sign up to view this video
Microsoft Excel Training: Advanced
MODULE 5: Creating advanced Functions		MODULE 6: Using the "What If" Analysis Tools & Recording Macros
Creating and applying Names in a worksheet Using the IF function Introduction to nesting functions Using the formula auditing tools Using the LOOKUP functions Using SUMIF(S), COUNTIF(S), AVERAGEIF(S) functions Using the IFERROR function Other useful functions (Database, Text and Datefunctions – time permitting)		Using the Consolidate Data commands Using the Goal Seek and Solver tools Creating Data Tables Using the Scenario Manager Adding the Developer Tab to the Ribbon Recording and running macros Editing macros with the Visual Basic Editor Creating buttons to run macros (Quick Access Toolbar & worksheet buttons) Microsoft SkyDrive Overview Customizing the Ribbon
Sign up to view this video		Sign up to view this video

The first day of Excel is designed to create a strong foundation for using the world's most popular business software as a place to organize and analyze information. Participants in this course will start by establishing fundamental skills and best practices essential for using Excel, and will leave with a working knowledge of basic formulas and functions, as well as key tools to organize, format, and manage data in a spreadsheet. This course is designed for Individuals, Career Changers, Skill enhancement.

Microsoft Excel Introduction
MODULE 1: Essentials & Intro to Formulas and Functions		MODULE 2: Formatting, Spreadsheet Design, Page Setup & Printing
Introduction to the Excel 2010 Interface Zooming in and out of a worksheet Navigating and selecting cells Keyboard Shortcuts Entering and editing data Deleting/replacing cell data Performing simple calculations Saving the workbook file Checking compatibility with older versions of Excel Overview of the Formulas Ribbon Building basic Formulas Using simple Functions Copying formulas/functions with the AutoFill command Using Relative and Absolute cell references in calculations		Inserting rows & columns Moving & copying data Using AutoFill to complete a series of values Introduction to worksheet Themes Formatting worksheet data/using Cell Styles Using Excel templates/creating custom templates Managing worksheets: inserting, deleting, renaming, move/copy Grouping worksheets Freezing or splitting panes Creating custom views Spell checking your worksheets Setting print options through Page Setup Using the Page Layout view Printing your worksheet
Sign up to view this video		Sign up to view this video
Microsoft Excel Intermediate
MODULE 3: List/Table Essentials & Charting		MODULE 4: Importing Data, Pivot Tables, Protecting & Linking Data
Overview of List design Formatting lists as Tables Single and Multi-level Sorting Removing duplicates from a list or table Filtering records in a list or table Search by Filter Inserting automatic subtotals in a list Inserting data charts Formatting and editing chart elements Adding/removing data from a chart Creating custom chart templates Printing charts Changing table and chart formatting through Themes Inserting Sparkline		Importing data from other sources Overview of exporting options Creating a database query Creating Pivot Tables from lists or tables Filtering Pivot Tables Using the Slicer tool within a Pivot Table Working with Pivot charts Applying Data Validation rules Applying built in Conditional Formatting Creating custom conditional formats Inserting & editing Comments Linking Data Cell, sheet, and file protection
Sign up to view this video		Sign up to view this video
Microsoft Excel Advanced
MODULE 5: Creating advanced Functions		MODULE 6: Using the "What If" Analysis Tools & Recording Macros
Creating and applying Names in a worksheet Using the IF function Introduction to nesting functions Using the formula auditing tools Using the LOOKUP functions Using SUMIF(S), COUNTIF(S), AVERAGEIF(S) functions Using the IFERROR function Other useful functions (Database, Text and Datefunctions – time permitting)		Using the Consolidate Data commands Using the Goal Seek and Solver tools Creating Data Tables Using the Scenario Manager Adding the Developer Tab to the Ribbon Recording and running macros Editing macros with the Visual Basic Editor Creating buttons to run macros (Quick Access Toolbar & worksheet buttons) Microsoft SkyDrive Overview Customizing the Ribbon
Sign up to view this video		Sign up to view this video

There are no prerequisites for this series.