Excel 2007 Training

Learn iT! Anytime's 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 advanced 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, and skill enhancement.

beginner | intermediate | advanced

Excel 2007 Training: Beginner
Module 1: Introduction to Excel		Module 2: Working with Formatting and Functions
Introduction to Excel Navigating Worksheets Quick Access Toolbar Customize Quick Access Toolbar Interactive Guide to the Ribbon Navigating a spreadsheet Save-As choices Convert 2003 to 2007 format Select multiple cells Undo Review Numbers vs Math New Workbook file Build New Workbook Entering Data Format #s and text Bad Formulas Autofill formulas Functions Compatibility Checker Save the file Relative vs Absolute References Auto Fill Tricks Fill several cells at once		Sum, Max, Min Entering Formula Autofill Functions Function vs. Formula Insert row, fix formulas Columns Move & copy data Copy & Paste Insert Sheet Autofill a Series Autofill Numbers Cell Formatting Number Formats Formatting Text Format as Table Templates Formatting Multiple Sheets Copying Entire Sheets Spell-check Convert Table to Range Freeze Panes More Freezing Panes Page Layout View Repeating Rows Page Setup
Sign up to view this video		Sign up to view this video
Excel 2007 Training: Intermediate
Module 3: Data and Charts		Module 4: Additional Queries, & Importing/Exporting Data Data
Well Defined List Sorting Sort by Multiple Fields Auto Filters Checkbox Filters Removing Duplicates Subtotal by One Field Subtotal 2nd field Subtotals at top Format as Table Color to Table Total Row Column Chart Row Vs. Column Format Series vs. Point Color Gradient Add Chart Title Deleting Columns Line chart Data labels Making pie charts Saving Chart Template Using Chart Template Printing Charts		Import from Access Update in Access Update in Excel MS Query Import Link to Text Pivot Table Multiples in pivot table Formatting Pivot Tables Report Filter Table and Pivot Table Filtering in Pivot Tables Linking cells between Workbooks Link by formula Link by pasting Totals From Other Workbook Custom views Finding Top 3 Thresholds Color Scales Traffic Light Icons Data Validation Validation Boundaries Conditional Format Protect sheet Password protect the Excel file
Sign up to view this video		Sign up to view this video
Excel 2007 Training: Advanced
Module 5: Formulas and LookUp Actions		Module 6: Creating Reports
Named Ranges Create Names from Selection IF  Function Formula auditing arrows If with number answers Date functions The TODAY function VLookup Adjust for other columns VLookup with TRUE HLookUp D-functions for databases Changing Criteria DAverage Text parts Concatenation Formula that Concatenates Paste as Values/Tex to Columns		Open Template Goal Seek Goal Seek with Percent Install the Solver Constraints Maximum Shipping Exact Solution Data Table 2-Variable Data Table Scenarios Consolidate Consolidations
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.

beginner | intermediate | advanced

Excel 2007 Training: Beginner
Module 1: Introduction to Excel		Module 2: Working with Formatting and Functions
Introduction to Excel Navigating Worksheets Quick Access Toolbar Customize Quick Access Toolbar Interactive Guide to the Ribbon Navigating a spreadsheet Save-As choices Convert 2003 to 2007 format Select multiple cells Undo Review Numbers vs Math New Workbook file Build New Workbook Entering Data Format #s and text Bad Formulas Autofill formulas Functions Compatibility Checker Save the file Relative vs Absolute References Auto Fill Tricks Fill several cells at once		Sum, Max, Min Entering Formula Autofill Functions Function vs. Formula Insert row, fix formulas Columns Move & copy data Copy & Paste Insert Sheet Autofill a Series Autofill Numbers Cell Formatting Number Formats Formatting Text Format as Table Templates Formatting Multiple Sheets Copying Entire Sheets Spell-check Convert Table to Range Freeze Panes More Freezing Panes Page Layout View Repeating Rows Page Setup
Sign up to view this video		Sign up to view this video
Excel 2007 Training: Intermediate
Module 3: Data and Charts		Module 4: Additional Queries, & Importing/Exporting Data
Well Defined List Sorting Sort by Multiple Fields Auto Filters Checkbox Filters Removing Duplicates Subtotal by One Field Subtotal 2nd field Subtotals at top Format as Table Color to Table Total Row Column Chart Row Vs. Column Format Series vs. Point Color Gradient Add Chart Title Deleting Columns Line chart Data labels Making pie charts Saving Chart Template Using Chart Template Printing Charts		Import from Access Update in Access Update in Excel MS Query Import Link to Text Pivot Table Multiples in pivot table Formatting Pivot Tables Report Filter Table and Pivot Table Filtering in Pivot Tables Linking cells between Workbooks Link by formula Link by pasting Totals From Other Workbook Custom views Finding Top 3 Thresholds Color Scales Traffic Light Icons Data Validation Validation Boundaries Conditional Format Protect sheet Password protect the Excel file
Sign up to view this video		Sign up to view this video
Excel 2007 Training: Advanced
Module 5: Formulas and LookUp Actions		Module 6: Creating Reports
Named Ranges Create Names from Selection IF  Function Formula auditing arrows If with number answers Date functions The TODAY function VLookup Adjust for other columns VLookup with TRUE HLookUp D-functions for databases Changing Criteria DAverage Text parts Concatenation Formula that Concatenates Paste as Values/Tex to Columns		Open Template Goal Seek Goal Seek with Percent Install the Solver Constraints Maximum Shipping Exact Solution Data Table 2-Variable Data Table Scenarios Consolidate Consolidations
Sign up to view this video		Sign up to view this video

There are no prerequisites for this series. However, Excel training is reccomended through advanced levels. Access is an advanced database application. Excel training will introduce you to concepts and working in tables.