Excel Maven

EXCEL PRO TIP: Advanced Optimization with Solver

Combining VLOOKUP & MATCH functions in Excel

Excel Quick Tip: Formula Reference Types

EXCEL PRO TIP: Center Across Selection

EXCEL PRO TIP: Go To Special Options

EXCEL PRO TIP: Visualizing Patterns with Sparklines

Custom Chart Templates in Excel 2016

EXCEL PRO TIP: Simple Optimization with Goal Seek

Excel Quick Tip: Conditional Formatting with PivotTables

Master Data Analysis with Excel Pivot Tables

EXCEL PRO TIP: PivotTable Date Grouping

EXCEL PRO TIP: Invisible Text Formatting

Microsoft Excel - Data Visualization with Excel Charts & Graphs

EXCEL PRO TIP: Custom Number Formats

EXCEL PRO TIP: Conditional PivotTable Formatting

Excel Maven Session #2: Custom Gauge Charts

Excel Quick Tip: Keyboard Shortcuts & Alt Key Tips

EXCEL PRO TIP: Customizing the PivotTable Field List

EXCEL PRO TIP: CTRL Shortcuts

EXCEL PRO TIP: PivotTable Errors & Empty Rows

EXCEL PRO TIP: Quick Analysis Tools

EXCEL PRO TIP: Pivot Slicers & Timelines

Master Advanced Excel Formulas & Functions

Excel Maven Session #7: Advanced Text Functions

EXCEL PRO TIP: Converting Text to Date Values

EXCEL PRO TIP: Chart Properties (Move & Size)

EXCEL PRO TIP: Charting Date Ranges

Enabling Multiple Filters with Excel PivotTables

EXCEL PRO TIP: Hidden Chart Source Data

EXCEL PRO TIP: Goal Pacing with Gauge Charts

EXCEL PRO TIP: Formatting Shortcuts

EXCEL PRO TIP: CUBE Functions

EXCEL PRO TIP: PivotTable Value Calculations

EXCEL PRO TIP: Pivot-Style Reports with Formulas

EXCEL PRO TIP: Synchronous Scrolling

Excel Quick Tip: Automating Charts & Graphs

EXCEL PRO TIP: Customizing Charts to Add Insight