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

Share Your Needs

Information Request (check all that apply - your information is private)
Areas of Interest (check all that apply)

(e.g., MS Excel on-site)

Business & Industry Services (BIS)
5 N. Systems Drive
Appleton, WI 54914-1655

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