Excel V Managing Sheets & Summaries
Scheduled Dates
| Course Name | Date | Time | Open Seats In-Person | Open Seats Online | Price | |
|---|---|---|---|---|---|---|
| Excel V Managing Sheets & Summaries | 1/18/2021 (Mon) | 9AM - 12PM | 3 | 4 | $75.00 | Register |
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