Skip to Main Content

MS Excel Advanced Features: 4 hr

Hours: 3.00 | Estimated Cost: $79.00

In this seminar, you will learn some advanced features of Microsoft Excel and get introduced to macros that are easy to create, store and use.

Additional Information

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

**Advanced Features**

  • Organizing with Grouping Columns, Rows, Images and Worksheets
  • Consolidating Data
  • Freezing or Splitting Rows/Columns
  • Using the Selection Pane
  • Conditional Formatting
  • Goal Seek
  • Scenarios
  • Text to Columns
  • Intercepting Entry Errors with Data Validation
  • Preventing Changes (Protecting Worksheets and Workbooks)
  • Quick Analysis Button

**Recording Macros**

  • Recording Workbook Actions
  • Running a Macro
  • Executing Macros Using Keyboard Shortcuts and Buttons
  • Saving a Macro Enabled Workbook
  • 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