Excel Xpert Lesson Library by Nicole Hullihen
Excel Xpert is the full video library for anyone who wants to actually master Excel, not just get by in it. It picks up where the basics leave off and walks through 212 short lessons covering formulas, lookups, pivot tables, conditional formatting, charts, dashboards, VBA and macros, organized into topic-based sections so you can jump straight to what you need.
Every video is matched to a tab in the free companion workbook, built by Nicole Hullihen, multi industry executive and multi year Microsoft MVP, who uses these exact tools to run a business, not a generic textbook example. Watch on YouTube, TikTok or Instagram, no login, no account and no credit card required.
Learn Excel Tricks to Visualize, Organize and Present Data Like No One Else
Everything else on this page assumes these 32 lessons. Math operators, absolute vs relative cell references, formatting and tables are the grammar of Excel, and shaky fundamentals are the reason advanced formulas break later. Even if you've used Excel for years, references and tables are worth a refresher.
Sorting and filtering is how you get from a thousand rows to the twelve you care about. These lessons cover custom sort orders, filtering on text patterns and timeline filters for dates, which is the fastest possible return on your time in a big sheet.
Updoot's hiring tools sort and score your candidates, its CRM sorts and scores your leads, both ranked and organized for you automatically.
This is the section that answers business questions. SUMIF and SUMIFS total only what matches your conditions, COUNTIF tells you how often something happened, and goal seek works a calculation backwards from the answer you need. Payment and time math round it out for anything involving loans, hours or schedules.
Updoot uses AI to handle the busywork Excel can't, so you get the summary, not the spreadsheet.
Data almost never arrives clean. Trimming stray spaces, fixing inconsistent capitalization and correcting number formats are the steps that make lookups and pivots work at all, so this section quietly prevents most of the errors people blame on Excel.
Lookups pull matching information from one table into another, which is how you stop copying and pasting between sheets. VLOOKUP, XLOOKUP and MATCH are among the most requested skills on any job description that mentions Excel, and the search bar and database lessons show what they enable once you're comfortable.
Updoot's AI-powered dashboards track your Goals and KPIs in real time, and that same data feeds straight into performance reviews, so nobody's flying blind.
Comparing two lists by eye is slow and unreliable. These lessons find duplicates, build unique lists, compare one list against another and split combined columns apart, which covers most reconciliation work: matching invoices to payments, rosters to sign-ups, exports to records.
Pivot tables summarize thousands of rows into a readable table in seconds, then let you rearrange that summary by dragging fields. Only three lessons here, but pivot tables are the single highest-leverage feature in Excel and calculated fields extend them to metrics your raw data doesn't contain.
Conditional formatting makes a sheet flag its own problems - overdue in red, on-target in green - so nobody has to remember what a number should be. Paired with nested IF statements, you get spreadsheets that apply your rules automatically instead of relying on whoever opens the file.
Every task's status color updates the moment work moves, on a live Kanban board your whole team can see.
The largest section here, because presenting results is usually what gets a decision made. You'll cover every chart type plus full dashboards with slicers, gauges and progress bars, which is how you turn a sheet of numbers into a one-screen view an executive can read without asking questions.
No more scrolling through tabs. Ask, and Updoot's AI pulls the answer from every corner of your business.
Excel does more than grids. QR codes, org charts, photos inside cells, calendars, fishbone diagrams and RACI charts all live here, which saves you buying separate software for planning documents and lets everything stay in one file your team already has.
When Excel doesn't have the function you need, VBA lets you write it. These lessons cover user-defined functions, change notifications and active-cell highlighting - the point where a spreadsheet stops waiting for input and starts responding to it.
Controls make a spreadsheet usable by people who didn't build it. Counters, checkboxes, radio buttons and recorded macros turn a multi-step process into a single click, which is what keeps a shared file from getting broken by its own users.
Short fixes for the things that waste minutes every day: merge problems, keyboard shortcuts, split screen for comparing distant rows, and decoding error messages. Nine quick lessons, and they'll probably save you more time per week than anything else here.
Yes. All 212 videos and the companion workbook are free to watch and download, no login or credit card required.
Excel Foundations covers the basics through four practical projects. Excel Xpert is the full library, 212 videos across topics including formulas, lookups, pivot tables, dashboards, VBA and macros, for anyone ready to go further.
Some comfort with the basics helps, but the lessons are organized from foundational topics like sorting and formatting up through advanced formulas, pivot tables and VBA, so you can start wherever you are.
You'll need access to Microsoft Excel or Google Sheets to follow along, but no paid add-ons or templates, just the free companion workbook.
Yes. Use the search bar at the top of the page to jump straight to a topic like VLOOKUP, pivot tables or conditional formatting.
Every business starts with a spreadsheet. Updoot is where you scale past it, automatically. Time tracking, invoicing, PTO, projects and more.
Start Your 14-Day Trial →
