Search

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 51 - What is AutoRecover - How to configure AutoRecover time interval and AutoRecover file location

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 26 - How to hide or show Excel Worksheet Row and Column headings (Column Letter and Row Number)

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

 

Related Tutorials