Microsoft Excel Simulator
Master Excel with the first-ever Excel Simulator—hands-on, interactive, and fun! 🚀
Master Excel with the first-ever Excel Simulator—hands-on, interactive, and fun! 🚀
Forget boring theoretical videos! Master Microsoft Excel with the first-ever Microsoft Excel Simulator—a fully interactive, hands-on, and guided learning experience. This step-by-step platform ensures practical mastery of Excel, making learning engaging, effective, and fun!
How to select one cell
How to move around in a worksheet
How to select multiple cells - using the mouse
How to select multiple adjacent cells - using Shift + Arrows
How to select multiple adjacent cells - using Ctrl + Shift + Arrows
How to select multiple adjacent cells - using the Name Box
How to select a row or column
How to AutoFill complete days - Method #1
How to AutoFill complete days - Method #2
How to AutoFill abbreviation days - Method #1
How to AutoFill abbreviation days - Method #2
How to AutoFill complete months - Method #1
How to AutoFill complete months - Method #2
How to AutoFill abbreviation months - Method #1
How to AutoFill abbreviation months - Method #2
How to AutoFill complete quarters - Method #1
How to AutoFill complete quarters - Method #2
How to AutoFill abbreviation quarters - Method #1
How to AutoFill abbreviation quarters - Method #2
How to insert a new worksheet - 3 Methods
How to rename a worksheet - Method 1
How to rename a worksheet - Method 2
How to color a worksheet tab - 2 Methods
How to hide a worksheet - Method #1
How to hide a worksheet - Method #2
How to unhide a worksheet - Method #1
How to unhide a worksheet - Method #2
How to delete a worksheet - Method #1
How to delete a worksheet - Method #2
How to move a worksheet within the same workbook - Method #1
How to move a worksheet within the same workbook - Method #2
How to copy a worksheet from one workbook to another workbook
How to move a worksheet from one workbook to another workbook
How to view 4 worksheets in one window
How to duplicate a worksheet within the same workbook - Method #1
How to duplicate a worksheet within the same workbook - Method #2
How to add a formula or function from one sheet to another
How to add a formula or function from one workbook to another
How to rename a worksheet - Method 3
Introduction to Conditional Formatting
How to add conditional formatting - greater than
How to add conditional formatting - less than
How to add conditional formatting - between numbers
How to add conditional formatting - between dates
How to add conditional formatting - equal to number
How to add conditional formatting - equal to text
How to add conditional formatting - text that contains
How to add conditional formatting - a date occurring
How to add conditional formatting - duplicate values
How to add conditional formatting - unique values
How to add conditional formatting - top 10 items
How to add conditional formatting - bottom 10 items
How to add conditional formatting - above average
How to add conditional formatting - below average
How to add conditional formatting - data bars
How to add conditional formatting - color scales
How to add conditional formatting - icon sets
How to edit conditional formatting
How to clear conditional formatting from selected cells
How to delete conditional formatting
How to apply the SUM Function
How to apply the AVERAGE Function
How to apply the COUNT Function
How to apply the MAX Function
How to apply the MIN Function
How to apply a function to non adjacent cells
How to apply the IF Condition
Introduction to VLookup
How to apply the VLookup function - basic
How to apply the VLookup function - intermediate
How to apply the VLookup function - Advanced
Important rules to make VLookup work perfectly
How to fix a cell in a formula using Defined Names
How to print a worksheet
How to print all worksheets
How to print selection
How to print a small table on the whole page
How to change the page orientation
How to change the page scaling
How to change the page margins
How to add headers and footers - logo image
How to add headers and footers - page number
How to add headers and footers - page number out of number of pages
How to print titles - rows to repeat at top
How to print titles - columns to repeat at left
How to add page breaks
How to remove page breaks
How to add a background to a worksheet
How to delete a background from a worksheet
Introduction to Table
How to create a Table - Basic
How to create a Table - Intermediate
How to add data to a Table
How to change the Table name
How to Insert Table row - 3 Methods
How to delete Table row - 3 Methods
How to insert Table column - 2 Methods
How to delete Table column - 2 Methods
How to change the Table Style
How to enable the Total Row
How to write a custom formula in a Table
How to create a new pivot table on a new worksheet
How to create a new pivot table on an existing worksheet
How to add a field to the pivot table
How to rearrange a field in the pivot table
How to remove a field from an area in a pivot table
How to clear all fields from all areas in a pivot table
Understanding the Values area in a pivot table - SUM
Understanding the Values area in a pivot table - AVERAGE
Understanding the Values area in a pivot table - COUNT
Understanding the Values area in a pivot table - COUNT DISTINCT
Understanding the Rows area in a pivot table
Understanding the Columns area in a pivot table
Understanding the Filters area in a pivot table
How to apply a currency format in the pivot table
How to apply the TOP filter in a Pivot Table
How to apply the BOTTOM filter in a Pivot Table
How to remove the Grand Total from a Pivot Table
How to clear the filter from a Pivot Table - Method 1
How to clear the filter from a Pivot Table - Method 2
How to clear all filters from a Pivot Table
How to work with a date field in a Pivot Table
How to group a date field in a Pivot Table
How to expand a field in a Pivot Table
How to collapse a field in a Pivot Table
How to show values as percentage
Why the Pivot Table Analyze tab and the Pivot Table Fields menu are not showing
Why the Pivot Table Fields menu is not showing
How to refresh the Pivot Table data
How to make the Pivot Table data refresh automatically
How to move a Pivot Table on a new worksheet
How to move a Pivot Table on an existing worksheet
How to delete a Pivot Table
Admin
English
Certificate Course
522 Students
00h 00m
92 Students
5 Courses
1 Review
Buy Now
