Excel Maven

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: "Go To" Special Options

EXCEL PRO TIP: Formula Calculation Modes

EXCEL PRO TIP: Relational Data Models

EXCEL PRO TIP: Color & Border Design

EXCEL PRO TIP: Enabling Multiple PivotTable Filters

EXCEL PRO TIP: Alt Key Tips

EXCEL PRO TIP: Counting Duplicates with SUMPRODUCT

EXCEL PRO TIP: PivotTable Date Grouping

EXCEL PRO TIP: Reviving Data from the Pivot Cache

EXCEL PRO TIP: Grouped Columns & Rows

EXCEL PRO TIP: Removing Blank Rows

EXCEL PRO TIP: Custom Sort Lists

EXCEL PRO TIP: Formula Line Breaks

EXCEL PRO TIP: Combining INDEX & MATCH

Using EOMONTH to calculate the first/last day of the month in Excel

EXCEL PRO TIP: Filled Map Visuals

EXCEL PRO TIP: Dynamic Chart Source Ranges

EXCEL PRO TIP: Extracting Unique Values

EXCEL PRO TIP: Advanced Optimization with Solver

Excel Quick Tip: Keyboard Shortcuts & Alt Key Tips

EXCEL PRO TIP: Customizing Charts to Add Insight

EXCEL PRO TIP: Many-to-Many Lookups

Pulling real-time data into Excel using WEBSERVICE & FILTERXML

Excel PivotTable Case Study: Analyzing Stock Market Data

EXCEL PRO TIP: Advanced Filter Criteria

EXCEL PRO TIP: Conditional PivotTable Formatting

EXCEL PRO TIP: Custom Number Formats

EXCEL PRO TIP: Multi-Level Row & Column Sorting

Troubleshooting common Excel error messages

EXCEL PRO TIP: Snap to Grid

EXCEL PRO TIP: Customizing the Ribbon

Power Pivot: Versions & Compatibility