Excel Expert
Curriculum
- 6 Sections
- 81 Lessons
- 8 Hours
Expand all sectionsCollapse all sections
- Getting Started2
- Advanced Formulas and Macros31
- 2.0Objective Domain Intro
- 2.1Fixed vs. Relative References
- 2.2Explicit vs. Structured References
- 2.3Logical Operations
- 2.4The IF Function
- 2.5Nested IF Functions vs. The IFS Function
- 2.6The NOT & “” Operators
- 2.7The AND/OR Operators
- 2.8The SWITCH Function
- 2.9The COUNTIF/SUMIF/AVERAGEIF Functions
- 2.10COUNTIFS/SUMIFS/AVERAGEIFS for Multiple Criteria
- 2.11The MINIFS & MAXIFS Functions
- 2.12Excel Date Values & Formatting
- 2.13PRO TIP: Converting Text to Dates
- 2.14The TODAY & NOW Functions
- 2.15YEAR/MONTH/DAY & HOUR/MINUTE/SECOND
- 2.16WEEKDAY, WORKDAY & NETWORKDAYS
- 2.17Recording a Macro
- 2.18Modifying & Deleting Macros
- 2.19PRO TIP: Adding Form Controls
- 2.20Lookup Functions
- 2.21The VLOOKUP & HLOOKUP Functions
- 2.22The INDEX Function
- 2.23The MATCH Function
- 2.24Combining INDEX and MATCH
- 2.25Approximate Match Lookups
- 2.26The PMT & NPER Functions
- 2.27Scenario Manager
- 2.28Consolidate Data
- 2.29Goal Seek
- 2.30Formula Auditing
- Managing and Formatting Data12
- 3.0Objective Domain Intro
- 3.1Custom Number Formats
- 3.2Data Validation
- 3.3Group & Ungroup Data
- 3.4Subtotals & Totals
- 3.5Removing Duplicates
- 3.6Auto Fill & Flash Fill
- 3.7Advanced Fill Series Options
- 3.8Conditional Formatting
- 3.9Formula-based Conditional Formatting
- 3.10Managing Conditional Formatting Rules
- 3.10PRO TIP: Hiding Values to Create Heatmaps
- Advanced Charts and Pivot Tables25
- 4.0Objective Domain Intro
- 4.1Box & Whisker Chart
- 4.2Histogram
- 4.3Filled Map
- 4.4Combo Chart
- 4.5Tree Map & Sunburst Chart
- 4.6Waterfall Chart
- 4.7Funnel Chart
- 4.8Creating a Pivot Table
- 4.9Modifying Pivot Table Views
- 4.10“Summarize Values By” Options
- 4.11“Show Values As” Calculations
- 4.12Analyze & Design Tabs
- 4.13Report Layouts & Options
- 4.14Number Formatting
- 4.15Sorting & Filtering
- 4.16Slicers & Timelines
- 4.17Grouping Text Fields
- 4.18Grouping Numerical Fields
- 4.19Grouping Date Fields
- 4.20Calculated Fields
- 4.21Calculated Items
- 4.22Pivot Charts
- 4.23Pivot Chart Formatting
- 4.24Expanding & Collapsing Pivot Charts
- Workbook Options & Settings10
- Wrapping Up1
Setting Expectations
The lesson content is empty.