Corporate Training By Zack Academy - Fast as Hell at Excel

Why Should You Take This Fast as Hell at Excel Course?

The Fast as Hell at Excel course will make you much faster in Excel. By the end of the Excel training course, you will have the skills to become up to 35-60% faster while working in Excel, use Excel without every touching your mouse and expose you to all of Excel’s shortcuts. This Excel class is perfect for those who are using Excel more than a few hours a day and would benefit from being faster.

Materials included:

• Custom Printed Manual
• Multiple XLS and XLT examples for in class and after class
• Shortcut sheets
• After class resources

The Following Topics Will Be Covered:

• Navigation the spreadsheet and large amounts of data
• Advanced Selecting Selecting
• Selecting, deleting and adding contiguous areas, rows, columns
• Navigation shortcut combinations
• Navigating between spreadsheets
• Practice with creating Excel Tables with subtotals
• How to access every Excel shortcut
• Navigating in Pivot Tables

Course Outline:

• Navigation the spreadsheet and large amounts of data
• Advanced Selecting Selecting
• Selecting, deleting and adding contiguous areas, rows, columns
• Navigation shortcut combinations
• Navigating between spreadsheets

Practice with creating Excel Tables with subtotals:

• Shortcut to drop down menus.
• Absolute referencing and locking with vlookups

How to access every Excel shortcut:

• Fastest way to insert formulas
• Using auto completes
• Alt+= for autosum
• Sorting
• All Formatting shortcuts
• Autofill shortcut sequences

Navigating in Pivot Tables:

• Practice, Practice, Practice