
Learn how dates are stored as serial numbers in Excel, perform date and time calculations, and format results as dates or times, including adding and subtracting dates.
Learn how to record and run macros in Excel, using absolute and relative referencing, and enable the developer tab to automate repetitive tasks with VBA.
Master data validation in Excel by creating dynamic dropdown lists from a unique product list, removing duplicates, turning it into a table, and using named ranges via the name manager.
Master advanced Excel charts by using combo charts with a secondary axis, highlighting top performers with max and if formulas, and grouping by gender for insights and data labels.
Master pivot table visuals by learning design options, conditional formatting with data bars, subtotals management, sorting, and spark lines to enhance readability.
Explore how to use show values as in pivot tables, including percent of column total and percent of row total, to analyze sales by city and salesperson.
Learn all about Show Values as in this lecture.
Master pivot charts in Excel by building pivot tables, converting to charts, and filtering with field buttons; compare with regular charts and use a range-based workaround to avoid bugs.
Tired of boring old Excel lessons?
Then you'll love Paul Ray's new style of teaching Excel. In this course, you'll learn advanced Microsoft Excel skills in a fun way using examples from a fictitious toy company. The humor might be cheesy, but make no mistake, the advanced Excel tutorials are extra meaty.
This course was specifically designed for students from Steve McDonald's beginning Excel courses to build on your existing skills. It's also perfect for any Excel user with a basic understanding of Excel who is ready to take their career to the next level. You'll learn awesome advanced functions, shortcuts, and data visualizations.
Here's what you'll learn in this course:
Advanced keyboard shortcuts
Powerful nested functions
Advanced table and cell referencing
Bad dad jokes
Scroll bars, check boxes and combo boxes
Conditional formatting
Combo charts
Pivot Tables
Stunning visuals with charts, pivot charts, slicers, timelines, and more
Here is our commitment to you with this advanced Excel course:
You won't be bored
You won't get left behind
You'll love what you're learning
We guarantee you'll love the course! If, for any reason, you don't, within 30 days of your purchase you can get a complete refund. You can keep the skills that you've learned, along with all of your new dad jokes and you've lost nothing. So, what are you waiting for? Jump in and learn some advanced Excel skills today.