• 703.368.4911
  • Manassas, VA
  • info@eidos-tek.com

Excel 2010

$99.00

This course is training for basic, intermediate, and advanced features of Microsoft Office Excel 2010 software. Excel is a spreadsheet program in the Microsoft Office system.

Save for later
Save for later
Category:

You can use Excel to create and format workbooks (a collection of spreadsheets) in order to analyze data and make more informed business decisions. Specifically, you can use Excel to track data, build models for analyzing data, write formulas to perform calculations on that data, pivot the data in numerous ways, and present data in a variety of professional-looking charts.

Course Outline

Excel 2010 Basic

  • ¬†Intro to Excel Basic
  • ¬†Interface and Functions
  • ¬†Cells
  • ¬†Entering Data Into Cells
  • ¬†Basic Formatting in Excel
  • ¬†Creating a Worksheet
  • ¬†The Intelligence Of Excel
  • ¬†Customizing Rows and Columns
  • ¬†Creating Formulas
  • ¬†Summary Pages and Moving Workbook to Workbook
  • ¬†The Function Builder
  • ¬†Conditional Formatting
  • ¬†Sorting and Filtering Data
  • ¬†Printing with Excel
  • ¬†Conclusion
  • ¬†Excel Basic Flashcards

Excel 2010 Intermediate

  • ¬†Intro to Excel Intermediate
  • ¬†Charts
  • ¬†Headers Footers and Layout Options
  • ¬†What If
  • ¬†Basic Tables in Excel
  • ¬†Pivot Tables
  • ¬†Manipulating Data Within the Pivot Tables
  • ¬†Pivot Table Charts
  • ¬†Data Validation
  • ¬†Conclusion
  • ¬†Excel Intermediate Flashcards

Excel 2010 Advanced

  • ¬†Intro to Excel Advanced
  • ¬†Customizing the Ribbon and Cells
  • ¬†Creating and Managing Ranges
  • ¬†More Formulas
  • ¬†Data Analysis
  • ¬†Data From an Outside Source
  • ¬†Spark Lines
  • ¬†Macros
  • ¬†Conclusion
  • ¬†Excel Advanced Flashcards

Reviews

There are no reviews yet.

Be the first to review “Excel 2010”

Your email address will not be published. Required fields are marked *