Free Excel Tutorial Lessons, Free Excel study guides
Part 1 - Excel Basics
Lesson 1 - Introduction to Excel
Lesson 2 - How to open and close Excel application in Windows 10
Lesson 3 - Excel Start Screen in detail
Lesson 4 - How to use Excel window controls to Maximize, Minimize and Restore Excel Window
Lesson 5 - How to resize and move the Excel window
Lesson 6 - Difference between Excel Workbook and Worksheet
Lesson 7 - Different components of Excel Workbook User Interface
Lesson 8 - Excel Backstage View
Lesson 9 - Excel Options Dialog Box Window
Lesson 10 - Excel Ribbon explained in detail
Lesson 11 - Responsive Nature of Excel Ribbon
Lesson 12 - Different types of Buttons in Excel Ribbon
Lesson 13 - How to collapse Excel Ribbon
Lesson 14 - How to customize Excel Ribbon
Lesson 15 - How to create and add a Custom Tab in Excel Ribbon
Lesson 16 - How to create and add Custom Group in Excel Ribbon's Tab
Lesson 17 - How to add a command button to Excel Ribbon's Group
Lesson 18 - How to reset Excel Ribbon customizations
Lesson 19 - How to Import/Export Excel Ribbon customizations
Lesson 20 - How to add a Macro to Excel Ribbon
Lesson 21 - How to change default Macro button icon in Excel Ribbon
Lesson 22 - How to change the position of Tabs on Excel Ribbon
Lesson 23 - How to change the position of Group on Excel Ribbon's Tab
Lesson 24 - How to change the position of command button in Excel Ribbon's Group
Lesson 25 - What is Excel Ribbon Contextual Tab (Excel Ribbon Tool Tab)
Lesson 26 - Excel Formula Bar explained in detail
Lesson 27 - How to hide or show Excel Formula bar
Lesson 28 - Excel Status Bar in brief
Lesson 29 - Excel Status Bar explained in detail
Lesson 30- How to customize Excel Status Bar
Lesson 31 - Excel Quick Access Toolbar (QAT)
Lesson 32 - How to customize Excel Quick Access Toolbar (QAT)
Lesson 33 - How to change the default location of Excel Quick Access Toolbar (QAT)
Lesson 34 - How to Add or Remove a Command to Excel Quick Access Toolbar (QAT) quickly
Lesson 35 - How to Add a Command which is not in Ribbon to Excel Quick Access Toolbar (QAT)
Lesson 36 - How to add a Macro to Excel Quick Access Toolbar (QAT)
Lesson 37 - How to change default Macro button icon in Excel Quick Access Toolbar
Lesson 38 - How to group Commands on Excel Quick Access Toolbar by adding Separator
Lesson 39 - How to change the position of commands on Excel Quick Access Toolbar (QAT)
Lesson 40 - How to reset Excel Quick Access Toolbar (QAT) Customizations
Lesson 41- How to Import/Export Excel Quick Access Toolbar (QAT) Customizations
Lesson 42 - Different file formats in Excel
Lesson 43 - Difference between xls, xlsx and xlsm file formats
Lesson 44 - How to Open an Excel Workbook file
Lesson 45 - How to Save an Excel Workbook file to Computer's Hard-disk
Lesson 46 - How to configure password for Excel file to prevent unauthorized file open
Lesson 47 - How to password protect an Excel file from unauthorized modification
Lesson 48 - How to change the default Excel file save folder location
Lesson 49 - How to change default save file format type xlsx in Excel
Lesson 50 - How to configure the number of worksheets in a new Excel workbook file
Lesson 52 - How to recover an Excel file using AutoRecover
Lesson 53 - How to recover new unsaved Excel files
Lesson 54 - How to recover previous versions of Excel file
Part 2 - Excel Worksheet
Lesson 1 - Important Excel Worksheet Navigation keys
Lesson 2 - Excel Cursor and Mouse Pointer Shapes
Lesson 3 - Row, Column and Cell in Excel worksheet
Lesson 4 - How to change the Row height in Excel worksheet
Lesson 5 - Excel AutoFit Row Height
Lesson 6 - How to change the Column width in Excel worksheet
Lesson 7 - Excel AutoFit Column Width
Lesson 8 - How to hide or unhide Rows in Excel worksheet
Lesson 9 - How to hide or unhide Columns in Excel worksheet
Lesson 10 - Maximum rows and columns in Excel Worksheet
Lesson 11 - How to insert Rows in Excel worksheet
Lesson 12 - How to insert Columns in Excel worksheet
Lesson 13 - How to insert new blank Cells in Excel worksheet
Lesson 14 - How to delete Rows from Excel worksheet
Lesson 15 - How to delete Columns from Excel worksheet
Lesson 16 - How to delete Cells from Excel worksheet
Lesson 17 - What is Active Cell in Excel and How to identify Active Cell
Lesson 18 - What is Range in Excel Worksheet and How to form a Range Address
Lesson 19 - Examples of Range Addresses in Excel worksheet
Lesson 20 - Types of Ranges in Excel Worksheet
Lesson 21 - How to select Range in Excel worksheet
Lesson 22 - How to select Multiple Range in Excel worksheet
Lesson 23 - What is Group mode in Excel, How to exit Group edit mode
Lesson 24 - How to select all worksheets to Excel group
Lesson 25 - How to select Ranges from different worksheets using Excel Group edit mode
Lesson 27 - How to hide or show Excel Worksheet Gridlines
Lesson 28 - How to change the color of Excel worksheet Tabs
Lesson 29 - How to change the color of Excel Gridlines
Lesson 30 - How to change the default font and size in Excel
Lesson 31 - How to Move or Copy entire worksheet within an Excel workbook
Lesson 32 - How to Move or Copy entire worksheet to another Excel workbook
Lesson 33 - How to insert a new worksheet to Excel workbook
Lesson 34 - How to rename an Excel worksheet
Lesson 35 - How to delete a worksheet from Excel workbook
Lesson 36 - How to hide worksheets in Excel
Lesson 37 - How to unhide worksheets in Excel
Lesson 38 - How to add Comment to an Excel worksheet Cell
Lesson 39 - How to edit a Comment in Excel worksheet Cell
Lesson 40 - How to show or hide Comments in Excel worksheet Cell
Lesson 41 - How to hide or show comment indicator red triangles from Excel worksheet Cells
Lesson 42 - How to Resize a Comment box in Excel
Lesson 43 - How to format Excel Comment text
Lesson 44 - How to change the shape of Excel Cell Comment box
Lesson 45 - How to insert a picture inside Excel Cell Comment box
Lesson 46 - How to copy and paste Comments in Excel
Lesson 47 - How to delete Comment from Excel worksheet Cell
Lesson 48 - How to Freeze Pane at Rows in Excel worksheet
Lesson 49 - How to Freeze Pane at Columns in Excel worksheet
Lesson 50 - How to Freeze Pane Rows and Columns in Excel worksheet
Lesson 51 - How to unfreeze frozen Rows or Column in Excel worksheet
Lesson 52 - How to split panes an Excel worksheet at a Row horizontally
Lesson 53 - How to split panes an Excel worksheet at a Column vertically
Lesson 54 - How to split Excel worksheet horizontally and vertically into four panes
Lesson 55 - Difference between Freeze Panes and Split Panes in Excel worksheet
Lesson 56 - Excel Cell Modes - Ready, Edit and Enter and Point
Lesson 57 - Data Types in Excel
Lesson 58 - Difference between Text and Number in Excel
Lesson 59 - 1900 and 1904 date systems in Excel
Lesson 60 - How to change Excel date system from 1900 date system to 1904 date system
Lesson 61 - How to add or subtract dates in Excel
Lesson 62 - Negative date in Excel
Lesson 63 - How Excel stores time values
Lesson 64 - How to add or subtract time in Excel
Lesson 65 - How Excel stores date and time values together
Lesson 66 - Negative time in Excel
Lesson 67 - Difference between Excel date systems
Lesson 68 - Copying dates between 1900 and 1904 date system workbooks
Lesson 69 - What is clipboard in Excel
Lesson 70 - How to clear Excel clipboard
Part 3 - Excel Formulas and Functions
Lesson 1 - What are Excel formulas
Lesson 2 - How to write formulas in Excel
Lesson 3 - How to find an Excel Cell contains a formula or value
Lesson 4 - How to see all formulas in Excel sheet
Lesson 5 - Mathematical operators in Excel
Lesson 6 - Comparison operators in Excel
Lesson 7 - Concatenate (&) text operator in Excel
Lesson 8 - Cell or range reference operators in Excel
Lesson 9 - Union and Intersection of Excel ranges
Lesson 10 - Operator Precedence in Excel
Lesson 11 - How to change the operator precedence in Excel
Lesson 12 - Error messages in Excel Formulas
Lesson 13 - Hash error in Excel (#### in excel)
Lesson 14 - Multiple parenthesis in Excel formulas
Lesson 15 - Trace error in Excel formulas
Lesson 16 - How to remove trace error arrows in Excel
Lesson 17 - Relative and absolute reference in Excel
Lesson 18 - F4 key in Excel formula
Lesson 19 - Mixed Cell reference in Excel
Lesson 20 - Difference between Excel formulas and functions
Lesson 21 - What are Excel Function arguments
Lesson 22 - How to open Excel Insert Function dialog box
Lesson 23 - Excel Function arguments dialog box