Free up your time by making the data work for you! Excel formulas for data, such as merit increases and tax tables, can be extremely long and complex, but they don't have to be. You can save hours or even days of time by simplifying complex formulas.
In this two-hour virtual classroom, Dianne Auld will demonstrate time-saving and often unknown tips in Excel. Learn how to read data from merit increase tables, tax tables, commission tables and more without writing complicated, nested IF formulas. You'll find charts have never been easier with shortcuts such as keystrokes and templates. You'll also learn to use ASAP Utilities to apply a single command to multiple worksheets quickly and efficiently.
After this class, you will know how to:
- Write more efficient lookup formulas in place of complex nested formulas
- Create combo charts for impactful market comparisons
- Format, separate and combine increase allocation files in minutes using ASAP Utilities
Extra value! Take home session files and instructions on how to replicate the functions demonstrated in class.
What You Will Learn:
Section 1 — Create More Efficient LOOKUP Formulas
- Use VLOOKUP without False at the end to read in between values to look up merit increases, tax tables, commission rates or ranges of any kind
- Use INDIRECT and named ranges to look up different tables, or combine INDIRECT with an ARRAY formula to bring in different tables
Section 2 — Create Charts in Less Time
- Use a keyboard shortcut to create a chart
- Use the combo chart option to create effective market comparison charts
- Save the chart you like as a template, then change chart type to your template to create the chart you want in two steps
- Discover shortcuts to link your heading to the worksheet and paste data into the chart
Section 3 — Use ASAP Utilities to:
- Round numbers or change case in place
- Protect, unprotect or unhide multiple worksheets at one time
- Select data down to the last used row
- Copy values to empty cells below filled cells in a selection
- Detect and visualize adjacent data
- Break increase data into worksheets
- Create an index of all your worksheets
- Export the worksheets as separate files
- Import and merge separate files into one worksheet
All tips will be demonstrated using one example in sequence.