Start Free Trial
As Seen On Social Media

Excel Xpert Lesson Library

Excel Xpert: Every Lesson. Every Video.

All 206 videos from the 188-lesson Excel Xpert workbook, on YouTube, TikTok and Instagram.

No login required
•
206 videos
•
YouTube, TikTok & Instagram
Follow along

Grab the Lesson Workbook

Each card below matches a tab in the workbook. The lesson number on the card is the tab name. Open the workbook beside this page, find the matching tab, and follow along as you watch.

Download the Lesson Workbook
Excel Foundations
32 videos · The basics: math, cell references, formatting, tables and text tricks.
Get Started - Excel Xpert tutorial video
Start Here · Part 1
Get Started
Get Started - Excel Xpert tutorial video
Start Here · Part 2
Get Started
4 Things to never do in Excel tips - Excel Xpert tutorial video
Lesson 1
4 things not to do
Mistakes. These are some of the biggest of all time, make sure you watch to avoid these. - Excel Xpert tutorial video
Lesson 2
Mistakes
Beginner math, cell references, select all, and sizing rows and columns. Learn the symbols to perform basic math like addition, subtraction, multiplication and division. Additionally, see why you use different cell references. - Excel Xpert tutorial video
Lesson 3 · Part 1
Beginner Math
Beginner math, cell references, select all, and sizing rows and columns. Learn the symbols to perform basic math like addition, subtraction, multiplication and division. Additionally, see why you use different cell references. - Excel Xpert tutorial video
Lesson 3 · Part 2
Beginner Math
Cell reference 101. Learn the difference between an absolute and relative reference. This is foundational to understanding excel. - Excel Xpert tutorial video
Lesson 4
Cell ref
Find the active cell. When you lose your place, it can be difficult to find without losing your formula you were typing. Use this trick to find your place. - Excel Xpert tutorial video
Lesson 5
Find active cell
Fill blanks down. When you need data in cells to drag down, but it’s different every few rows, this trick can fill down for you in seconds. - Excel Xpert tutorial video
Lesson 6
Fill blanks
Formatting. Various Excel tips to create a document like an invoice. Removed gridlines and learn orders, fill color, bold, autosum. - Excel Xpert tutorial video
Lesson 7
Formatting Invoice sample
Automatic formatting. Learn how to apply this shortcut and avoid manual formatting. - Excel Xpert tutorial video
Lesson 7b
Auto format
Row and column adjustment. Shortcut to adjust row and column height. - Excel Xpert tutorial video
Lesson 8
HOI HOA
Switch function. This is how you can translate words. For example, let’s say we used priority 1, 2, 3 but we want it to be high, medium low, this is how to change that quickly. - Excel Xpert tutorial video
Lesson 9
Switch
Lesson 10
Freeze row and column
Table. You will need to turn your data into a table to maximize use of several Excel functions. This is how to do it. - Excel Xpert tutorial video
Lesson 11
Table
Untable a table. As much as you will need table, there are times when you will need to untable and it’s not as easy as it would seem. - Excel Xpert tutorial video
Lesson 12
Untable
Lesson 13 · Part 1
Paste special values
Lesson 13 · Part 2
Paste special values
Flash fill down to make updates in a second vs having to manually type out the changes. - Excel Xpert tutorial video
Lesson 14
Flash
Rounding. Excel has various options for when you need to round and what better number to test it out on than with Pi. - Excel Xpert tutorial video
Lesson 15
Rounding
Protect Cells. Learn how to prevent unwanted edits. - Excel Xpert tutorial video
Lesson 16
Protect
Tenure or age. Get the age of something by using this formula rather than having to figure it out in your head. - Excel Xpert tutorial video
Lesson 17
Tenure or age
Flash fill. Split a column like a full address with flash fill. - Excel Xpert tutorial video
Lesson 18
Flash fill
Hide digits. This is how to replace something you want hidden with an asterisks as an example. Our example is phone numbers. - Excel Xpert tutorial video
Lesson 19
Hide Digits
Join text from multiple cells using the & sign, this is how. - Excel Xpert tutorial video
Lesson 20
Join with &
Fill right. Use this trick to fill to the right quickly. - Excel Xpert tutorial video
Lesson 21
Fill RIght
Separate names from a cell, adding the name to a new cell. - Excel Xpert tutorial video
Lesson 22
Separate names
Find and replace. Replace something like a company name inside of various cells with this quick trick. It works on one tab or on multiple at once. - Excel Xpert tutorial video
Lesson 23
Replace (2)
Copy paste only the visible rows with this shortcut. - Excel Xpert tutorial video
Lesson 24
Alt ;
Iferror. There are errors you need to fix, then there are errors you may want to hide or blank out. An example is a divide by zero error when you just don’t have the data yet. It doesn’t mean it’s wrong, it’s just not there yet so add iferror to your formula like this to cover that. - Excel Xpert tutorial video
Lesson 25
IFERROR
Lesson 26
Data validation drop down
Folders. Learn how to make a large group of folders at once. - Excel Xpert tutorial video
Lesson 27
Folders
Sorting & Filtering
6 videos · Auto sort, custom sort, filters, timelines and text-string filters.
Auto sort. Set up your spreadsheet to automatically sort as you type in new values. - Excel Xpert tutorial video
Lesson 28
Sort Auto
Custom sort. There are times like with shirt sizes where an alphabetical sort isn’t going to do the job. This is how you can set up a custom sort with a predetermined way of sorting. - Excel Xpert tutorial video
Lesson 29
Custom Sort
Sort the top 3. Using take, sort only the top three or however many results you specify vs. the entire list. - Excel Xpert tutorial video
Lesson 30
Filter Images
Filtering and filtering images images. This is how to not only do a basic filter but filter with images so it’s doesn’t get smashed looking. - Excel Xpert tutorial video
Lesson 31
Sort top 3
Project timeline filter. Learn how the timeline filter function works to review various elements like due date or status by clicking the button. - Excel Xpert tutorial video
Lesson 32
Project timeline
Text string filter. Use filter and vstack to set up a search box that returns customer feedback. - Excel Xpert tutorial video
Lesson 33
Text string filter
Formulas & Calculations
17 videos · SUMIF, SUMIFS, COUNTIF, averages, payments, goal seek and time math.
Min max. Learn how to find the lowest and highest value. - Excel Xpert tutorial video
Lesson 34
Min Max
Budget math. Learn the product function to multiply quickly. - Excel Xpert tutorial video
Lesson 35
Budget
Averageif. Get the average of value when you have criteria like North region and greater than 200,000 in sales. - Excel Xpert tutorial video
Lesson 36
Averageif
Sumif. Get the totals by a criteria. Show the total only if the data meets the criteria you set. - Excel Xpert tutorial video
Lesson 37
SUMIF
AutoSum. Using this shortcut, you can get the totals on several areas at once, no need to click each cell or use sum multiple times. - Excel Xpert tutorial video
Lesson 38
AutoSum
Sum with criteria. Use this formula to determine things like paid vs. unpaid. Find the totals of paid invoices compared to the totals of unpaid. - Excel Xpert tutorial video
Lesson 39
Sum with critera
Sum with criteria. Use this formula to determine things like paid vs. unpaid. Find the totals of paid invoices compared to the totals of unpaid. - Excel Xpert tutorial video
Lesson 39b
Sum with critera checkbox
Sum by visible cells only using the aggregate function. - Excel Xpert tutorial video
Lesson 40
Slicers + Visible Cells Sum
Sumifs. Create a drop down list in Excel that is dependent on another. Our example is various departments, and we want to only see the people in those departments in the drop down list. - Excel Xpert tutorial video
Lesson 41
SUMIFS
Running totals. Use a pivot table trick to see your running totals. - Excel Xpert tutorial video
Lesson 42
Run total pivot
Word count with Countif. Use this along with the wildcard to get counts of letters in words. In our example, we need the number of times a name appears with ER in it. - Excel Xpert tutorial video
Lesson 43
Countif wildcard
Countif to count colors. - Excel Xpert tutorial video
Lesson 43b
Countif colors
Payment calculator. See the payment example for a vehicle. - Excel Xpert tutorial video
Lesson 44
Payment
Payment calculator. Learn with a house example how to input interest rate, number payments and price to get your estimated monthly payment. - Excel Xpert tutorial video
Lesson 45
Payment house
Goal Seek. Determine what a value needs to be based on the result that you need. - Excel Xpert tutorial video
Lesson 46
Goal Seek
Weighted average. Use sumproduct to get a weighted average when you have some things that shouldn't be treated equal. - Excel Xpert tutorial video
Lesson 47
Weighted Average
Adding time. This is how you can have a start time, a duration in minutes, and get an end time. - Excel Xpert tutorial video
Lesson 48
Time
Formatting & Cleanup
14 videos · Trim spaces, fix caps, merge, wrap, number formats and outlines.
Formatting. Formatting shortcuts to know to make your spreadsheet presentable and easy to read. Additionally, learn how to add a logo to really look nice. Go over navigating to select, borders, size adjustment, freezing rows, bold, fill color, change to currency, and alignment. - Excel Xpert tutorial video
Lesson 49 · Part 1
Formatting
Formatting. Formatting shortcuts to know to make your spreadsheet presentable and easy to read. Additionally, learn how to add a logo to really look nice. Go over navigating to select, borders, size adjustment, freezing rows, bold, fill color, change to currency, and alignment. - Excel Xpert tutorial video
Lesson 49 · Part 2
Formatting
Lesson 50
Correct CAPS
Trim spaces. This cleans up your data quickly when there are erroneous spaces. - Excel Xpert tutorial video
Lesson 51
Trim spaces
Trim spaces. This cleans up your data quickly when there are erroneous spaces. - Excel Xpert tutorial video
Lesson 51b
Find and replace
Text to columns. Sometimes numbers are all in the same column and you need to split them out by a delimter. - Excel Xpert tutorial video
Lesson 51c
Text to columns
Alignment icons. These make it so easy to change your cell alignment. Learn what each one does. - Excel Xpert tutorial video
Lesson 52
Alignment icons
Rotate headers. Change the angle or direction of the text in your cells. - Excel Xpert tutorial video
Lesson 53
Rotate headers
Merge and center. You will often hear why you shouldn’t use this, so learn that but also how to correct issues. This is how to center across cells to avoid issues later. - Excel Xpert tutorial video
Lesson 54
Merge Center
Remove blanks. Delete the blank rows from your spreadsheet with this handy trick. - Excel Xpert tutorial video
Lesson 55
Remove blanks
Rename column headings. You can enter your own headings, and then use this trick to store your custom headings so that when you create a formula, you will find your headings to add. - Excel Xpert tutorial video
Lesson 56
Rename headings
Change number formats. Learn how to change from number to currency, add decimals, remove decimals, change font color, size. - Excel Xpert tutorial video
Lesson 57
Number format
Wraprows. Take data in a column and move it over to columns quickly. - Excel Xpert tutorial video
Lesson 58
Wraprows
Break out rows. Learn to use the table function and get data to break a single row into multiple rows. - Excel Xpert tutorial video
Lesson 58b
Row break out
Lookups & Searching
15 videos · VLOOKUP, XLOOKUP, HLOOKUP, MATCH, search bars and databases.
Xlookup. Learn how to use this lookup function to return matches like the email address of an agent. - Excel Xpert tutorial video
Lesson 59
Xlookup
Vlookup. The classic lookup function in Excel. Learn how to use this to match data from one spreadsheet to another with a unique identifier. - Excel Xpert tutorial video
Lesson 60
Vlookup
Advanced vlookup. Learn how to add curly brackets to return more columns. - Excel Xpert tutorial video
Lesson 60b
Advanced Vlookup (2)
Advanced vlookup search. More advanced vlookup practice to use practically as a search function and adding a PDF button. - Excel Xpert tutorial video
Lesson 60c · Part 1
Adv vlookup + PDF
Advanced vlookup search. More advanced vlookup practice to use practically as a search function and adding a PDF button. - Excel Xpert tutorial video
Lesson 60c · Part 2
Adv vlookup + PDF
V vs. Xlookup. See how these differ with actual examples and decide for yourself which one you need. - Excel Xpert tutorial video
Lesson 61
V vs Xlookup
Xlookup. These lookups can be challenging to get so let’s do another example with hours worked. - Excel Xpert tutorial video
Lesson 62
Xlookup
Hlookup. Not all lookups need to be like the X or V. Try this when it’s horizontal. - Excel Xpert tutorial video
Lesson 63
Hlookup
Lookup. Lookup values in buckets. This example uses buckets of being minutes late to work to return an action that needs to be taken. - Excel Xpert tutorial video
Lesson 64
Lookup
Lookup. This time we use the lookup to find grades associated with scores. - Excel Xpert tutorial video
Lesson 65
Lookup fxn
Lesson 66
Vlookup and Match
Search a list with drop downs. Filter a list and use a drop down as the search method. - Excel Xpert tutorial video
Lesson 67
Actual List
Add a search box to your spreadsheet and type item ids or any other search in and highlight the results. - Excel Xpert tutorial video
Lesson 68
Search
Search bar. Learn how to add a search bar or box to Excel to type in what you need and highlight the row. This is a second example of this. - Excel Xpert tutorial video
Lesson 69
Search bar
Get data from a database. If you have a long list of data, this is how you can set up a search at the top and find the information quickly with DGET. - Excel Xpert tutorial video
Lesson 70
Get from Database
Comparing Data
8 videos · Duplicates, unique lists, forms, list comparison and splitting columns.
Assign values from an available list. This works well when assigning things like teams and you have a single list that needs to be split among a number of columns. - Excel Xpert tutorial video
Lesson 71
Assign Teams
ID duplicates. Use conditional formatting to identify duplicates in your column. - Excel Xpert tutorial video
Lesson 72
Dup Cond Format
Compare lists. Identify duplicates OR unique values. - Excel Xpert tutorial video
Lesson 72b
Compare dup and unique
Unique and VStack. Start with two lists, and they may have duplicates. Using Unique and VStack, you can get a single list with no duplicates or overlap. - Excel Xpert tutorial video
Lesson 73
Unique and Vstack
Forms. Excel is the better choice when it comes to forms over Word. Learn how the form function can be added from the top ribbon and how it works. - Excel Xpert tutorial video
Lesson 74
Form
Line formatting for printable forms. Trick to add lines instead of using underscore - Excel Xpert tutorial video
Lesson 74b
Printable form
Split a column into multiple. Learn how to use filter to split out your one column across multiple by a criteria. - Excel Xpert tutorial video
Lesson 75
Split out columns
List comparison. Find what was on the original list and not on the second list. - Excel Xpert tutorial video
Lesson 76
List comparison
Pivot Tables
3 videos · Building pivots, calculated fields and everything they can do.
All about pivot tables. Learn how to insert them, how to arrange the data, how to make it look nice, and how to use the math functions. - Excel Xpert tutorial video
Lesson 77
Pivot
Pivot table. This is one example of how to use a pivot table to group and summarize your data. I would argue this is a top Excel function you have to know. - Excel Xpert tutorial video
Lesson 78
Pivot Table
Pivot table calculated fields. Learn how to create custom formulas within a pivot table to avoid manually typing in formulas and it updates as your data updates. - Excel Xpert tutorial video
Lesson 79
Pivot table calc fields
Conditional Formatting & Logic
8 videos · Colour coding, indicators, check marks and nested IF statements.
Thumbs up and down indicator. Use this to clearly show the great things and the not so great. - Excel Xpert tutorial video
Lesson 80
Grades
Green Red format. Use custom format to change numbers to words. - Excel Xpert tutorial video
Lesson 80b
Green red
Up down indicators. Quickly see if your values are above or below target. - Excel Xpert tutorial video
Lesson 81
Up down indicators
Over under goal. Set up charts by cell that show green to the right for being over and red to the left for being under. - Excel Xpert tutorial video
Lesson 82
Over Under Goal
Color coded approval status and permanent timestamp. Learn how to conditional format to change the color of a row based on the status. This works for approval or any type of status. Additionally, add a permanent timestamp when approval was changed. - Excel Xpert tutorial video
Lesson 83 · Part 1
Color Coded Approvals
Color coded approval status and permanent timestamp. Learn how to conditional format to change the color of a row based on the status. This works for approval or any type of status. Additionally, add a permanent timestamp when approval was changed. - Excel Xpert tutorial video
Lesson 83 · Part 2
Color Coded Approvals
Color coding status. More practice using conditional formatting and data validation. - Excel Xpert tutorial video
Lesson 83b
Color Coded Status
Check box timestamps. Learn how to use the new check box and get a permanent time stamp with this sign in template. - Excel Xpert tutorial video
Lesson 83c
Check box timestamp
Checkmark. Add check marks to show items are completed as in the example we have of marking something as approved by our initials. - Excel Xpert tutorial video
Lesson 84
Check mark
Charts & Dashboards
66 videos · Every chart type plus full dashboards, slicers, gauges and progress bars.
Dashboard shapes. Turn your typical charts into a nicer looking 3D or beveled-edge chart with this trick. - Excel Xpert tutorial video
Lesson 86
Dashboard Shapes
Linking shapes. Link a result or summary like the quarter’s revenue in a shape to make your presentation of the result stand out. - Excel Xpert tutorial video
Lesson 87
Shapes
Chart template. You can set up a template with your preferred formatting and choose that every time you need a chart. This is how. - Excel Xpert tutorial video
Lesson 88
Chart Template
Radial bar chart. Learn how to make this type of chart common among top consulting companies. - Excel Xpert tutorial video
Lesson 88b
Radial bar chart
Color scales. This is a heat map of where the hottest house prices are, or the highest prices and lowest. You don’t even have to look at the numbers with this trick. - Excel Xpert tutorial video
Lesson 89
Color scales
Progress bars. This is another example of using progress bars to show a comparison of items and how far along they are. - Excel Xpert tutorial video
Lesson 90
Dyn Progress Bars
Multi Stage Progress Bar. Create a bar showing progress among various stages in the project. - Excel Xpert tutorial video
Lesson 90b
Multi Stage Progress Bar
Color changing bar dashboard. Learn how to apply color changes to bars with conditional formatting and how to use rept. - Excel Xpert tutorial video
Lesson 90c
Progress Bar Dash
Box plot. Learn how to create a chart to show the minimum, 25%, median, 75% and max values. - Excel Xpert tutorial video
Lesson 90d
Box plot
Quadrant chart. Learn how to make a scatterplot quadrant chart to show things with multiple variables like who you’re spending the most with for ads, compared to the revenue generated. Quickly see what needs to be cancelled. - Excel Xpert tutorial video
Lesson 91
Scatterplot
Bubble dashboard. Use the bubble chart and Xlookup to create a handy dashboard with min max. - Excel Xpert tutorial video
Lesson 91b
Bubble dash data
Data bars. Add data bars in the background of your values to quickly see the variance. - Excel Xpert tutorial video
Lesson 92
Data Bars
Advanced Bar Chart. This bar chart lets you compare two data sets at the same time. - Excel Xpert tutorial video
Lesson 92b
Adv Bar Chart
Conditional format color scale. Create a chart from high to low using conditional formatting to color scale. - Excel Xpert tutorial video
Lesson 92c
Cond format color scale
Bullet chart. This is a cool chart for when you have low, med, high values along with a target and actual. You can see all of these in one single column for each region as an example. - Excel Xpert tutorial video
Lesson 93
Bullet Chart
Circular bullet chart. Learn how to create a rounded bullet chart with a target. - Excel Xpert tutorial video
Lesson 93b
Circular Bullet
Speedometer. Make a guage chart just like a speedometer to show things like customer satisfaction level. - Excel Xpert tutorial video
Lesson 94
Speedometer
Speedometer project dashboard. Use a speedometer on the existing dash instead of a pie chart to show completion. - Excel Xpert tutorial video
Lesson 94b
Speedometer Dashboard
Donut progress chart. Make a donut progress chart to show the percentage completed compared to incomplete. - Excel Xpert tutorial video
Lesson 95
Donut Chart
Progress charts. Learn how to make color changing progress donut charts. - Excel Xpert tutorial video
Lesson 95b
Progress donut charts
Weekly 1:1 progress chart. Learn how a donut chart can be used to show progress on a meeting agenda. - Excel Xpert tutorial video
Lesson 95c
Weekly 1 on 1 progress
Check box controlled chart. Learn how to check a box to remove and add the various metrics. - Excel Xpert tutorial video
Lesson 96
Check box chart
Sales dashboard. Learn how to use pivot charts and slicers to create a dashboard with buttons. - Excel Xpert tutorial video
Lesson 97
Dash 2
Sales rep dashboard. Use slicers to filter and see trends over time by rep and all categories. - Excel Xpert tutorial video
Lesson 97b
Sales Rep Dashboard
Project progress dashboard. Learn how to use progress bars, percentage, pie charts, and checkboxes to clearly show the progress of projects. - Excel Xpert tutorial video
Lesson 98
Full Dashboard
Calls dashboard. Learn how to use data bars in conditional formatting, column charts, shapes and pivot tables together to create a dashboard. - Excel Xpert tutorial video
Lesson 98b · Part 1
Call Dash Data
Calls dashboard. Learn how to use data bars in conditional formatting, column charts, shapes and pivot tables together to create a dashboard. - Excel Xpert tutorial video
Lesson 98b · Part 2
Call Dash Data
Slicer dashboard. Learn how to use pivot tables, pivot charts, bar charts, and slicers together to create a dashboard. - Excel Xpert tutorial video
Lesson 98c
Slicer dash
Project tracker. Use the checkbox function to track projects. - Excel Xpert tutorial video
Lesson 98d
Project Progress
Job tracker. Learn how to use data bars and if statements to show progress and status. - Excel Xpert tutorial video
Lesson 98e
Job tracker
Employee Dashboard. Use data from time cards or anything you want to track to create this interactive dashboard using slicers and renaming pivot tables. - Excel Xpert tutorial video
Lesson 98f · Part 1
Pivots
Employee Dashboard. Use data from time cards or anything you want to track to create this interactive dashboard using slicers and renaming pivot tables. - Excel Xpert tutorial video
Lesson 98f · Part 2
Pivots
Population Dashboard. Use donut, treemap, icon, bar, and butterfly charts to create a dashboard. - Excel Xpert tutorial video
Lesson 98g
Dashboard
Dashboard with links to tabs. - Excel Xpert tutorial video
Lesson 98h
Dashboard with tabs
Project Dashboard. Show assignee count, milestone and overall completion. - Excel Xpert tutorial video
Lesson 98i
Project dash
Excel Dashboard. Learn how to use line charts, pie and bar with 3-D effects. - Excel Xpert tutorial video
Lesson 98j
Excel dashboard
Shades of blue dashboard. More ways to show progress. - Excel Xpert tutorial video
Lesson 98k
Blue Dashboard
Purchase Order Dashboard. Use pivotcharts to create a visual representation of data. - Excel Xpert tutorial video
Lesson 98l
PO Dashboard
Revenue Expense Dashboard. Use pivotcharts to create a clear visual. - Excel Xpert tutorial video
Lesson 98m
Rev Exp Dashboard
Customer Dashboard. Use shapes, slicers, 3D images to create a visual. - Excel Xpert tutorial video
Lesson 98n
Customer Dashboard
Sales Dashboard. More practice in dashboarding. - Excel Xpert tutorial video
Lesson 98o
Sales Dashboard
Sparklines. Add line charts to each row of data with sparklines. Quickly see the trends. In this example, it’s sales by month. - Excel Xpert tutorial video
Lesson 99
Sparkline
Actual to variance chart. Create a vertical or horizontal chart with actual, budget, forecast, max and min to determine by region how good your budgeting skills are. - Excel Xpert tutorial video
Lesson 100 · Part 1
Act Var Chart
Actual to variance chart. Create a vertical or horizontal chart with actual, budget, forecast, max and min to determine by region how good your budgeting skills are. - Excel Xpert tutorial video
Lesson 100 · Part 2
Act Var Chart
Actual to goal chart. Quickly see the actuals compared to your goals, target, budget. - Excel Xpert tutorial video
Lesson 100b
Actual to goal chart
Custom bar chart. Learn how to further use images with bar charts to make this custom one. - Excel Xpert tutorial video
Lesson 100c
Custom image bar
Project timeline chart. Using a chart, turn it into a timeline showing major project milestones. - Excel Xpert tutorial video
Lesson 101
Project timeline chart
Gantt chart. Make a Gantt chart with conditional formatting that automatically updates the cells with the filled color to manage project timelines. - Excel Xpert tutorial video
Lesson 102
Gantt
Gantt chart. More practice making a Gantt chart, full tutorial. - Excel Xpert tutorial video
Lesson 102b
Gantt
Advanced Gantt chart. Kick up the Gantt chart a notch with additional considerations. - Excel Xpert tutorial video
Lesson 102c
Gantt Adv
Waffle chart. Here’s an example of how a waffle chart can be used. This is collecting survey counts and how many have been received. - Excel Xpert tutorial video
Lesson 103
Waffle Charts
Waffle chart. Use a waffle chart to show your weekly progress by totaling the tasks you had, and the total that are done. - Excel Xpert tutorial video
Lesson 104
Waffle Chart
Count tracker. Track count of attendees or something related using this waffle chart. - Excel Xpert tutorial video
Lesson 104b
Attendance Waffle
Busy time chart. Use heat maps to determine where the highs and lows are or the busy times. - Excel Xpert tutorial video
Lesson 105
Busy Time Chart
Likert Chart. Learn how to present survey results with a Likert Chart. - Excel Xpert tutorial video
Lesson 105b
Likert Scale
Milestone chart. This is similar to the timeline example, using project milestones on a timeline. - Excel Xpert tutorial video
Lesson 106
Milestone chart
Budget to actual. Create a chart that has a marking for our goal or budget, and then we can see actual compared to plan or budget. - Excel Xpert tutorial video
Lesson 107
Budget to actual
Sparklines. Add mini charts to your Excel rows showing the highs and lows and update the colors. - Excel Xpert tutorial video
Lesson 108
New Sparklines
Lesson 109 · Part 1
Progress completion bar
Progress completion bar. Watch how to create the bar along with percent for tasks marked as done. You can leave the bar a solid black or watch the other video to add color like red, yellow, green. - Excel Xpert tutorial video
Lesson 109 · Part 2
Progress completion bar
Progress completion bar. Watch how to create the bar along with percent for tasks marked as done. You can leave the bar a solid black or watch the other video to add color like red, yellow, green. - Excel Xpert tutorial video
Lesson 109 · Part 3
Progress completion bar
Learn to create a budget that shows you how money is spent per category and priority. - Excel Xpert tutorial video
Lesson 110
Full Budget
McKinsey Chart. Use rept for in-cell bar charts. - Excel Xpert tutorial video
Lesson 110b
McKinsey chart
Treemap vs. pie chart. Using a treemap is much easier to read, see how to use one. - Excel Xpert tutorial video
Lesson 110d
Pie Chart vs Tree Map
KPI scorecard chart. Learn how to use icons and bar charts to show KPIs with a check, X and dash. - Excel Xpert tutorial video
Lesson 110e
KPI Scorecard
7 chart types. Learn the basics of seven types of charts and typical uses. - Excel Xpert tutorial video
Lesson 110g
Scatter Line Chart
Scatter line chart. Learn how to customize a scatter chart with lines, low and high value. - Excel Xpert tutorial video
Lesson 110h
General Charts
Images, Calendars & Diagrams
16 videos · QR codes, org charts, photos in cells, calendars, fishbone and RACI.
QR Codes and Bar Codes. Add QR codes to your spreadsheet for free. - Excel Xpert tutorial video
Lesson 111 · Part 1
QR Codes
QR Codes and Bar Codes. Add QR codes to your spreadsheet for free. - Excel Xpert tutorial video
Lesson 111 · Part 2
QR Codes
QR Codes and Bar Codes. Add QR codes to your spreadsheet for free. - Excel Xpert tutorial video
Lesson 111 · Part 3
QR Codes
Bingo. Make a fun bingo card and play a game after all this work. - Excel Xpert tutorial video
Lesson 112
Bingo
The traditional org chart. Using SmartArt, make an org chart with name and title. - Excel Xpert tutorial video
Lesson 113
Org Chart
Photo org chart. Create an org chart and add all of the photos of employees to it using Excel SmartArt. - Excel Xpert tutorial video
Lesson 114
Picture Org Chart
Photo inside cells. Add photos in cells to make filtering easy. - Excel Xpert tutorial video
Lesson 114b
Photo in cell
Perspective photo. Add a photo that’s in perspective to fit your presentation. - Excel Xpert tutorial video
Lesson 115
Side image
Image in a graph. Add your image right on top of the bar in a bar chart. - Excel Xpert tutorial video
Lesson 116
Image Graph
Country map. Insert the map of each country for something like a sales report. - Excel Xpert tutorial video
Lesson 116b
Country Map
Signature. Add your handwritten signature to an Excel file. - Excel Xpert tutorial video
Lesson 117
Signature
Camera. Take a snapshot of your data in Excel and paste it elsewhere. Watch it update dynamically as you update the original data set. - Excel Xpert tutorial video
Lesson 118
Camera 2
Dynamic calendar. Create a calendar that pulls in events based on a list. - Excel Xpert tutorial video
Lesson 119
Dynamic calendar
Calendar. Create a quick dynamic calendar in Excel using the sequence function. As you change the month with the drop down, the calendar changes. - Excel Xpert tutorial video
Lesson 120
Calendar
Create an annual calendar list of days and dates. - Excel Xpert tutorial video
Lesson 121
Annual Calendar
RASIC chart with dashboard. Learn how to make a RASIC or RACI chart with a dash to show tasks counts. - Excel Xpert tutorial video
Lesson 121c
RACI Matrix
VBA & Custom Functions
7 videos · User-defined functions, change notifications and active-cell highlighting.
Lesson 122 · Part 1
Custom Fxn
User defined custom function. Use VBA to create a function that you design. - Excel Xpert tutorial video
Lesson 122 · Part 2
Custom Fxn
Lesson 122 · Part 3
Custom Fxn
Change notifications. Use VBA to get a pop up when a change happens so you know if something is updated. - Excel Xpert tutorial video
Lesson 123
Change Notice VBA
Add Notes. Don't use a note column when you can use this trick to add a note within the cell. - Excel Xpert tutorial video
Lesson 123b
Notes within formula
Inventory Dashboard. Use a fun example like closet inventory to create a dashboard showing counts and dollar value. - Excel Xpert tutorial video
Lesson 123c
Closet inventory
Highlight the active cell to show exactly where people should be looking. This is very helpful when sharing screen or presenting your spreadsheet. - Excel Xpert tutorial video
Lesson 124
Active Cell Highlight
Autofit rows and columns. Set your spreadsheet up to automatically adjust width and height. - Excel Xpert tutorial video
Lesson 125
AutoFit R C
Buttons, Checkboxes & Macros
8 videos · Counters, checkboxes, radio buttons and recorded macros.
Button counter/spinner. Use this up down counter to do things like track votes or scores. The video on how to get the developer tab is here as well. - Excel Xpert tutorial video
Lesson 126 · Part 1
Button counter + dev tab
Button counter/spinner. Use this up down counter to do things like track votes or scores. The video on how to get the developer tab is here as well. - Excel Xpert tutorial video
Lesson 126 · Part 2
Button counter + dev tab
Button counter and speedometer dashboard - Excel Xpert tutorial video
Lesson 126b
Button counter + speed
Checkboxes. Learn how to add checkboxes to a to do list. - Excel Xpert tutorial video
Lesson 126c
Checkboxes
Crossed off checkboxes. Learn conditional formatting to mark items as done. - Excel Xpert tutorial video
Lesson 126d
Cross it off
New check boxes. The latest version no longer requires the developer tab. - Excel Xpert tutorial video
Lesson 126e
New check boxes
Radio buttons. Cool way to filter your data by the click of a button. - Excel Xpert tutorial video
Lesson 127
Radio Buttons
Macros. Learn how to record repetitive steps to automate your work. - Excel Xpert tutorial video
Lesson 128
Macros
Quick Tips
9 videos · Short fixes: merge issues, shortcuts, split screen, errors and more.
Merge and center issues - Excel Xpert tutorial video
Lesson 129
Merge and center issues
Aligning charts - Excel Xpert tutorial video
Lesson 130
Aligning charts
Shortcuts list - Excel Xpert tutorial video
Lesson 131
Shortcuts list
Split your screen - Excel Xpert tutorial video
Lesson 132
Split your screen
Import data from pic on phone - Excel Xpert tutorial video
Lesson 133
Import data from pic on phone
List of excel errors and how to correct - Excel Xpert tutorial video
Lesson 134
List of excel errors and how to correct
Finding your tab - Excel Xpert tutorial video
Lesson 135
Finding your tab
Combine files - Excel Xpert tutorial video
Lesson 136
Combine files
Get the developer tab - Excel Xpert tutorial video
Lesson 137
Get the developer tab
No videos match that search. Try a different word.

Ready to automate what you just learned?

The software does everything these templates do, automatically. Time tracking, invoicing, PTO, projects and more.

Start Your 14-Day Trial →