Learn Microsoft Excel 2010 Beginner Course
  • Introduction and Overview of Excel 2010 Course
  • READ ME: Essential Information for a Successful Training Experience
  • Overview of the Excel Window
  • Working with the Mouse
  • Excel Options
  • Entering Text and Numbers
  • Creating Basic Formulas
  • Relative References
  • Order of Operations
  • Working withe Ranges
  • Working with Save and Save As Commands
  • File Extensions
  • Opening a File
  • Working with Larger Files
  • Freeze Panes Options
  • Split Screen Option
  • Page Setup Options
  • Headers and Footers
  • Print Titles
  • Comments
  • Fit to Print on One Page
  • Printing Workbooks
  • Adding and Deleting Rows, Columns, and Cells
  • Changing Column and Row Widths
  • Cut, Copy and Paste
  • Copying Formulas
  • Overview of Formulas
  • Create Formulas using Functions - Part 1
  • Create Formulas using Functions - Part 2
  • Absolute Values
  • Adding, Deleting and Renaming Sheets
  • Additional Sheet Tab Options
  • 3-D Formulas
  • Cell Formatting
  • Number Formatting
  • Borders and Shading
  • Format as Table
  • Using Styles
  • Using Format Painter
  • Protecting Sheets
  • Fill Handle and Custom Lists
  • Creating Charts
  • Types of Charts
  • Editing Charts
  • Using Graphics to Enhance Charts
  • Creating Range Names
  • Managing Names
  • Using Names in Formulas
  • Removing Duplicates
  • Sort Data
  • Filter Data
  • Advanced Filters
  • Creating an Outline - Part 1
  • Creating an Outline - Part 2
  • Subtotals
  • New Window Option
  • Arrange File Options
  • Creating a Workspace
  • Custom Views
  • Scenarios
  • Creating Formulas Between Files
  • Working with Links
  • IF Statement
  • VLookups
  • Consolidating Data
  • Data Validation
  • Formula Auditing
  • Comments
  • Goal Seeker
  • Text to Columns Option
  • Watch Window
  • Closing Video
  • Excel 2010 Quiz
Learn Microsoft Excel 2010 Advanced Course
  • Introduction to Advanced Excel 2010
  • READ ME: Essential Information for a Successful Training Experience
  • Four Basic Steps When Creating Charts/Graphs
  • Additional Features to Help Create Charts/Graphs
  • Additional Features to Help Create Charts/Graphs Part 2
  • Detailed Formatting for Charts/Graphs
  • Formatting Legends within Charts/Graphs
  • Formatting Axes and Gridlines within Charts/Graphs
  • Trends within Charts and Graphs
  • Complex Trends within Charts and Graphs
  • Trends over Time within Charts and Graphs
  • Showing Differences Using Bar Charts
  • Showing Differences Using Pie Charts
  • Limitations with Pie Charts & How to Correct
  • Alternative Ways to Show Differences
  • Using Charts & Graphs to Show Relationships
  • Using Charts & Graphs to Show Relationships Part 2
  • Charting & Graphing Financial Information
  • Charting & Graphing Financial Information Part 2
  • Specific Charts for Finance Information
  • Setting Up Live Charts
  • Using Sparklines for Data Visualization
  • Using and Formatting Data Bars, Color Scales & Icon Sets
  • Setting Up Pivot Tables/Charts
  • Setting Up Pivot Tables/Charts Part 2