Event description:
This course will enhance the user's prior knowledge of Microsoft Excel, creating a more efficient user.
Topics to be covered include:
- Working with Multiple Worksheets and Workbooks
- Using links and external references
- Grouping
- 3-D references
- Functions and Formulas
- Cell or range names
- Financial
- Logical
- Date and time
- Text
- Lookups
- Data Management
- Sorting
- Filtering
- Subtotals "feature" instead of the function
- Conditional formatting
- Charting
- Review of the basics
- Chart templates
- Sparklines
Course Materials Needed by Participants:
- Windows or Mac OS Laptop
- Microsoft Office Applications (i.e. Word, Excel, PowerPoint)
- Pen/Pencil
- Notebook
-
