Excel Maven
Excel Maven provides high-quality, applied analytics training and consulting to 100k+ students and clients across more than 180 countries. Services include award-winning online courses, personalized on-site workshops, and project-based consulting.
Visit courses.excelmaven.com for a full list of courses, which currently include:
- ADVANCED EXCEL FORMULAS & FUNCTIONS
- DATA VISUALIZATION WITH EXCEL CHARTS & GRAPHS
- DATA ANALYSIS WITH EXCEL PIVOT TABLES
- EXCEL VBA & MACROS
- INTRO TO POWER QUERY, POWER PIVOT & DAX
- EXCEL PRO TIPS FOR POWER USERS
- UP & RUNNING WITH POWER BI DESKTOP
To learn more, head to www.excelmaven.com
EXCEL PRO TIP: Formula Line Breaks
EXCEL PRO TIP: CTRL Shortcuts
EXCEL PRO TIP: Pivot Slicers & Timelines
EXCEL PRO TIP: Combining INDEX & MATCH
EXCEL PRO TIP: Snap to Grid
EXCEL PRO TIP: Splitting Text to Columns
EXCEL PRO TIP: PivotTable Solve Order
EXCEL PRO TIP: Real-Time Tools with TODAY & NOW
EXCEL PRO TIP: Hiding Workbook Elements
EXCEL PRO TIP: Extracting Unique Values
EXCEL PRO TIP: CUBE Functions
EXCEL PRO TIP: PivotTable Value Calculations
EXCEL PRO TIP: Hidden Chart Source Data
EXCEL PRO TIP: Many-to-Many Lookups
EXCEL PRO TIP: Color & Border Design
EXCEL PRO TIP: Data Validation Drop-Down Lists
EXCEL PRO TIP: Enabling Multiple PivotTable Filters
EXCEL PRO TIP: Customizing Charts to Add Insight
EXCEL PRO TIP: Random List Selection with OFFSET & RANDBETWEEN
EXCEL PRO TIP: Zip Codes & Phone Numbers
EXCEL PRO TIP: "Go To" Special Options
EXCEL PRO TIP: Connect & Transform with Power Query
EXCEL PRO TIP: Autofit PivotTable Column Width
EXCEL PRO TIP: Interactive Form Controls
EXCEL PRO TIP: Pivot-Style Reports with Formulas
EXCEL PRO TIP: Formatting Shortcuts
EXCEL PRO TIP: Customizing the Ribbon
EXCEL PRO TIP: Quick Analysis Tools
EXCEL PRO TIP: PivotTable Errors & Empty Rows
EXCEL PRO TIP: Goal Pacing with Gauge Charts