Excel 2010 Training

Excel 2010 Training

CustomGuide Excel 2010 Demo

Course Description

Turn unorganized data into useful information and quickly make spreadsheets your friends. CustomGuide’s Microsoft Excel 2010 course lets people of any technical level learn exactly what they need to know at their own pace. It starts with Excel fundamentals and then moves on to advanced topics like functions, PivotTables, and macros.

Lessons: 78
Duration: 3h 15m
Start a Demo Today.

  • Course Outline:
  • Getting Started
  • Understanding the Excel Screen
  • Creating a Workbook
  • Navigating a Worksheet
  • Opening and Saving a Workbook
  • Working with Multiple Windows
  • Printing a Workbook
  • Getting Help
  • Closing and Exiting
  • Editing a Workbook
  • Selecting Cells and Cell Ranges
  • Entering Cell Data
  • Editing Cell Data
  • Cutting, Copying, and Pasting
  • More Pasting Options
  • Using AutoFill
  • Inserting, Moving, and Deleting Cells
  • Checking Spelling
  • Finding and Replacing Text
  • Hiding Rows and Columns
  • Formatting Worksheets
  • Formatting Text
  • Cell Alignment and Merging Cells
  • Formatting Numbers and Dates
  • Borders and Background Colors
  • Copying Formatting
  • Row Heights and Column Widths
  • Applying Conditional Formatting
  • Applying and Removing Cell Styles
  • Creating and Modifying Cell Styles
  • Find and Replace Formatting
  • Inserting an Image
  • Building Formulas
  • Formula Basics
  • Working with Sums and Averages
  • Referencing External Worksheets
  • Absolute and Relative Cell References
  • Working with Range Names
  • Financial Formulas
  • IF Formulas
  • Text Formulas
  • Lookup Formulas
  • Understanding Formula Errors
  • Viewing and Managing Worksheets
  • Viewing Worksheets
  • Moving and Copying Worksheets
  • Insert, Rename, and Delete Worksheets
  • Freezing Rows and Columns
  • Hiding Worksheets and Gridlines
  • Working with Charts
  • Creating a Chart
  • Moving, Resizing, and Deleting a Chart
  • Understanding Chart Types
  • Changing Chart Layout and Style
  • Working with Titles and Legends
  • Gridlines, Labels, and Data Tables
  • Formatting Chart Elements
  • Add, Rename and Reorder Chart Data
  • Filtering Charts
  • Creating Sparklines
  • Printing Worksheets
  • Changing Page Size and Scale
  • Setting the Print Area and Viewing Page Breaks
  • Adding Titles, Gridlines and Headings
  • Creating Headers and Footers
  • Adjusting Page Margins and Orientation
  • Working with Data and Tables
  • Sorting Data
  • Filtering Data
  • Using Quick Analysis
  • Working with Tables
  • Remove Duplicates and Total
  • Using Data Validation
  • Filtering with Slicers
  • Using Flash Fill
  • Grouping and Outlining Data
  • Importing and Exporting Text Files
  • Collaborating with Excel
  • Working with Cell Comments
  • Sharing Workbooks
  • Tracking Changes in Workbooks
  • Protecting a Worksheet
  • Password Protecting a Workbook
  • Saving Worksheets as Web Pages
  • Working with PivotTables
  • Creating a PivotTable
  • Adding Multiple Fields to a PivotTable
  • Specifying PivotTable Data
  • Changing a PivotTable’s Calculation
  • Filtering a PivotTable
  • Working with Timelines
  • Working with PivotTable Layout
  • Grouping PivotTable Values
  • Refreshing a PivotTable
  • Formatting a PivotTable
  • Creating a PivotChart

What’s Included:

CustomGuide Tutorials
Interactive Tutorials
CustomGuide Quizzes
Interactive Quizzes
CustomGuide Courseware
Training Manuals
CustomGuide Cheat Sheets
Cheat Sheets
SocialU Learning Platform
Learning Platform

Related Courses: