Microsoft Excel Training

Microsoft Excel is the most popular spreadsheet program available today. Most successful businesses take advantage of Excel’s usability and automated features.  

Formulas and functions are the heart and soul of Microsoft Excel. Without them, Excel would be just a static spreadsheet that contains dead data. Excel comes alive with the use of formulas and functions. Excel’s most powerful characteristic is its capability to automatically perform calculations. Once you enter a formula or function in a cell, data can be automatically calculated or recalculated by just entering values. Excel has many uses including performing financial analyses, creating charts, organizing lists, importing data from other sources, and automating repetitive tasks.

Master Instructors can help you learn how to use and incorporate Microsoft Excel to make your business more efficient and productive. Check with the Master Instructor in your area for class outlines and prices.

Microsoft has determined that learning the following skills will make you an Excel expert:

Organizing and Analyzing Data

  • Use subtotals
  • Define and apply advanced filters
  • Group and outline data
  • Use data validation
  • Create and modify list ranges
  • Add, show, close, edit, merge, and summarize scenarios
  • Perform data analysis using automated tools
  • Create PivotTable and PivotChart reports
  • Use Lookup and Reference functions
  • Use Database functions
  • Trace formula precedents, dependents, and errors
  • Locate invalid data and formulas
  • Watch and evaluate formulas
  • Define, modify, and use named ranges
  • Structure workbooks using XML

Formatting Data and Content

  • Create and modify custom data formats
  • Use conditional formatting
  • Format and resize graphics
  • Format charts and diagrams

Collaborating

  • Protect cells, worksheets, and workbooks
  • Apply workbook security settings
  • Share workbooks
  • Merge workbooks
  • Track, accept, and reject changes to workbooks

Managing Data and Workbooks

  • Import data to Excel
  • Export data from Excel
  • Publish and edit Web worksheets and workbooks
  • Create and edit templates
  • Consolidate data
  • Define and modify workbook propertie

Customizing Excel

  • Customize toolbars and menus
  • Create, edit, and run macros
  • Modify Excel default settings
Top of Page

Quick Links:

Check out our latest articles, tutorials, and tips about Excel!