Skip to Main Content

Microsoft Excel Advanced Features

Hours: 3.00 | Estimated Cost: $79.00

In this seminar, you will learn the more advanced features of Microsoft Excel and discover macros that are easy to create, store and use.

Additional Information

Learn About
  • Advanced features of Microsoft Excel
  • Creating and executing a macro
  • Organizing and consolidating data
  • Conditional formatting
Benefits & Outcomes
  • Reduce the number of keystrokes required to perform common commands by learning macros
  • Make complex computations easier to perform
Training Outline

**Advanced Features**

  • Organizing with Grouping
  • Hiding Columns, Rows or Sheets
  • Consolidating Data
  • Freezing or Splitting Rows/Columns
  • Using the Selection Pane
  • Conditional Formatting
  • Goal Seek
  • Scenarios
  • Converting Text to Data
  • Intercepting Entry Errors with Data Validation
  • Preventing Changes (Protecting)
  • Analyzing Data Quickly


  • Recording Workbook Actions
  • Running a Macro
  • Executing Macros Automatically
  • Saving a Macro
  • Showing the Developer Tab
Business and Industry Services

Fox Valley Technical College
Business & Industry Services (BIS)
D. J. Bordini Center
5 N. Systems Drive
Appleton, WI 54914-1655
View BIS Calendar

P: 888-458-0449
P: 920-735-2525
F: 920-735-4771

Join us on LinkedIn