Skip to Main Content
FVTC Logo

Microsoft Excel Advanced Features

Hours: 2.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

**Macros**

  • 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
1825 N. Bluemound Road
P.O. Box 2277
Appleton, WI 54912-2277

bi.services@fvtc.edu
www.fvtc.edu/bis
View BIS Calendar

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


Join us on LinkedIn