- Objective Domain Intro Free
- Fixed vs. Relative References Free
- Explicit vs. Structured References Free
- Logical Operations Free
- The IF Function Free
- Nested IF Functions vs. The IFS Function Free
- The NOT & “<>” Operators Pro
- The AND/OR Operators Pro
- The SWITCH Function Pro
- The COUNTIF/SUMIF/AVERAGEIF Functions Pro
- COUNTIFS/SUMIFS/AVERAGEIFS for Multiple Criteria Pro
- The MINIFS & MAXIFS Functions Pro
- Excel Date Values & Formatting Pro
- PRO TIP: Converting Text to Dates Pro
- The TODAY & NOW Functions Pro
- YEAR/MONTH/DAY & HOUR/MINUTE/SECOND Pro
- WEEKDAY, WORKDAY & NETWORKDAYS Pro
- Recording a Macro Pro
- Modifying & Deleting Macros Pro
- PRO TIP: Adding Form Controls Pro
- Lookup Functions Pro
- The VLOOKUP & HLOOKUP Functions Pro
- The INDEX Function Pro
- The MATCH Function Pro
- Combining INDEX & MATCH Pro
- Approximate Match Lookups Pro
- The PMT & NPER Functions Pro
- Scenario Manager Pro
- Consolidate Data Pro
- Goal Seek Pro
- Formula Auditing Pro
- QUIZ: Advanced Formulas & Macros Pro
- Objective Domain Intro Pro
- Custom Number Formats Pro
- Data Validation Pro
- Group & Ungroup Data Pro
- Subtotals & Totals Pro
- Removing Duplicates Pro
- Auto Fill & Flash Fill Pro
- Advanced Fill Series Options Pro
- Conditional Formatting Pro
- Formula-based Conditional Formatting Pro
- Managing Conditional Formatting Rules Pro
- PRO TIP: Hiding Values to Create Heatmaps Pro
- QUIZ: Manage & Format Data Pro
- Objective Domain Intro Pro
- Box & Whisker Chart Pro
- Histogram Pro
- Filled Map Pro
- Combo Chart Pro
- Tree Map & Sunburst Chart Pro
- Waterfall Chart Pro
- Funnel Chart Pro
- Creating a Pivot Table Pro
- Modifying Pivot Table Views Pro
- Summarize Values By Options Pro
- Show Values As Calculations Pro
- Analyze & Design Tabs Pro
- Report Layouts & Options Pro
- Number Formatting Pro
- Sorting & Filtering Pro
- Slicers & Timelines Pro
- Grouping Text Fields Pro
- Grouping Numerical Fields Pro
- Grouping Date Fields Pro
- Calculated Fields Pro
- Calculated Items Pro
- Pivot Charts Pro
- Pivot Chart Formatting Pro
- Expanding & Collapsing Pivot Charts Pro
- QUIZ: Advanced Charts & Tables Pro
- Objective Domain Intro Pro
- Enabling Macros Pro
- Copying Macros to Other Files Pro
- Linking Data Across Workbooks Pro
- Protecting Worksheets & Cell Ranges Pro
- Protecting & Encrypting Workbooks Pro
- Recovering Workbooks Pro
- Managing Comments Pro
- Formula Calculation Modes Pro
- Language Options Pro
- QUIZ: Workbook Options & Settings Pro