Excel 2011 Training

Excel 2011 Training

CustomGuide Excel 2011 Demo

Course Description

Turn unorganized data into useful information and quickly make spreadsheets your friends. CustomGuide’s Microsoft Excel 2011 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: 76

  • Course Outline:
  • Getting Started
  • One
  • Create Workbooks
  • Navigate Worksheets
  • Open and Save Workbooks
  • Multiple Windows
  • Print
  • Help
  • Close and Exit
  • Edit a Workbook
  • Select Cells and Ranges
  • Edit Cell Data
  • Cut
  • More Pasting Options
  • AutoFill
  • Insert
  • Check Spelling
  • Find and Replace Text
  • Hide Columns and Rows
  • Format Worksheets
  • Format Text
  • Align and Merge Cells
  • Format Numbers and Dates
  • Borders and Background Colors
  • Copy Formatting
  • Row Heights and Column Widths
  • Apply Conditional Formatting
  • Apply and Remove Cell Styles
  • Create and Modify Cell Styles
  • Insert an Image
  • Build Formulas
  • Formula Basics
  • Sums and Averages
  • Reference External Worksheets
  • Absolute and Relative References
  • Cell and Range Names
  • Financial Formulas
  • Logical Formulas
  • Text Formulas
  • VLOOKUP
  • Formula Errors
  • View and Manage Worksheets
  • View Worksheets
  • Move and Copy Worksheets
  • Insert
  • Freeze Rows and Columns
  • Hiding Worksheets and Gridlines
  • Charts
  • Create Charts
  • Move and Resize
  • Chart Types
  • Layout and Style
  • Titles and Legends
  • Gridlines
  • Chart Elements
  • Modify Chart Data
  • Sparklines
  • Print Worksheets
  • Page Size and Scale
  • Print Area and Page Breaks
  • Print Titles and Headings
  • Headers and Footers
  • Margins and Orientation
  • Data and Tables
  • Sort Data
  • Filter Data
  • Tables
  • Remove Duplicates and Total
  • Data Validation
  • Import and Export Data
  • Collaborate with Excel
  • Cell Comments
  • Share Workbooks
  • Track Changes
  • Protect a Worksheet
  • Password Protection
  • Save as Web Pages
  • PivotTables
  • Create PivotTables
  • Add Multiple PivotTable Fields
  • Change a PivotTable Calculation
  • Filter PivotTables
  • PivotTable Layout
  • Group Values
  • Refresh a PivotTable
  • Format a PivotTable

What’s Included:

CustomGuide Tutorials
Interactive Tutorials
CustomGuide Quizzes
Interactive Quizzes
CustomGuide Courseware
Training Manuals
CustomGuide Quick References
Quick References
SocialU Learning Platform
Learning Platform

Related Courses: