In this intermediate Excel class, you’ll learn functions such as VLOOKUP and SUMIF; summarize data with PivotTables; sort and filter databases; and split or join text. The course comes with our revolutionary Excel video suite, so you can review the materials anytime after the class. Take this cla...
Overview
Syllabus
- Tips and Fundamentals
- Navigation
- Paste Special
- Paste Special Values
- Splitting Text
- Joining Text
- Named Ranges
- Data Validation
- Remove Duplicates
- VLOOKUP
- HLOOKUP
- Sort and Filter
- Pivot Tables New
- Pivot Grouping Timelines
- Multiple Pivot Tables
- If Statements
- And Or
- COUNTIFS and SUMIFS
- Combo Charts
