Excel V Managing Sheets & Summaries
Scheduled Dates
| This class is scheduled on an as-needed basis. Please choose an available day and time or call us at (909) 981-6331 for more information. |
Topics Include:
Working with Workbooks
- Viewing, Renaming, and Color-coding Worksheets
- Grouping Spreadsheets
- Moving or Copying sheets
Working with Multiple Worksheets and Workbooks
- Creating Linked Formulas
- Using 3-D References
- Viewing Multiple Worksheets
- Viewing Worksheets in Different Workbooks
- Creating Linked Formulas between Workbooks
Macros
- Recording and running
- Creating a macro button
- Adding custom menu to a toolbar
- Assign a macro to a custom menu
- IFERROR Function
=VLOOKUP
- When To Use Exact Match
- 6 Tips For Writing Better Vlookups
- Creating A Dynamic Data Range
- Making Vlookup Formulas Go Wild
- Comparing 2 Lists With A Vlookup
- Range Lookup In Excel [Formulas]
- COUNT
- COUNTA
- COUNTBLANK
SUMIF
- Sumifs Function
- Using the =COUNTIF function
- Countifs Function
- Averageifs