Learn how to work with spreadsheets easily. Create formulas to do calculations. Make charts to show data visually. Use functions to save time and effort. Format cells to make your spreadsheet look neat. Discover more tips to improve your skills. Simplify your work with these easy tools.



So what are you waiting for? Let's get started!

01

Lesson 1: Getting Started with Excel

  • Lesson 1.1 - Microsoft Excel 2016 Introduction
  • Lesson 1.2 - Getting to Know Ms Excel Interface
  • Lesson 1.3 - Working with the Excel Environment
  • Lesson 1.4 - The Quick Access Toolbar
  • Lesson 1.4 - How to use Tell Me Features
  • Lesson 1.5 - Worksheet View in Excel 2016
  • Lesson 1.6 - Backstage View in Excel 2016
    • 02

    Lesson 2: Understanding OneDrive

    03

    Lesson 3: Creating and Opening Workbooks

  • Lesson 3.1 - Understanding Excel Workbooks and OneDrive
  • Lesson 3.2 - How to Create New Blank Workbook
  • Lesson 3.3 - How to Open an Existing Workbook
  • Lesson 3.4 - How to Pin Workbook in Excel 2016
  • Lesson 3.5 - How to Using Templates in Excel 2016
  • Lesson 3.6 - What is Compatibility Mode in Microsoft Excel 2016
  • Lesson 3.7 - How to Convert a Workbook in Microsoft Excel 2016
    • 04

    Lesson 4: Saving and Sharing Workbooks

  • Lesson 4.1 - What is Save and Save As?
  • Lesson 4.2 - How to Save a Workbook?
  • Lesson 4.3 - How to Save As to make a copy?
  • Lesson 4.4 - How to Change the default save location?
  • Lesson 4.5 - What is AutoRecover in Excel?
  • Lesson 4.6 - How to Export Workbooks?
  • Lesson 4.7 - How Sharing Workbooks?
    • 05

    Lesson 5: Cell Basic in Ms Excel 2016

  • Lesson 5.1 - Understanding Cell in Excel 2016?
  • Lesson 5.2 - What Cell Content in Excel 2016?
  • Lesson 5.3 - How to access more paste options?
  • Lesson 5.4 - How to copy and paste cell content in Excel 2016?
  • Lesson 5.5 - How to drag and drop cells in Excel 2016?
  • Lesson 5.6 - How to use the fill handle in Excel 2016?
  • Lesson 5.7 - How to continue a series with the fill handle in excel 2016?
    • 06

    Lesson 6: Modifying Columns, Row and Cells

  • Lesson 6.1 - How to modify column width in Excel 2016?
  • Lesson 6.2 - How to AutoFit column width Excel 2016?
  • Lesson 6.3 - How to modify row height in Excel 2016?
  • Lesson 6.4 - How to modify all row or columns in Excel 2016?
  • Lesson 6.5 - How to Inserting, deleting, moving, and hiding in Excel 2016?
  • Lesson 6.6 - How to wrapping text and merging cells in Excel 2016?
  • Lesson 6.7 - How to merge cells using the Merge & Center Command in Excel 2016?

    • 07

    Lesson 7: Formatting Cells in Excel 2016

  • Lesson 7.1 - How to change the font size in Excel 2016?
  • Lesson 7.2 - How to change the font in Excel 2016?
  • Lesson 7.3 - How to change the font color in Excel 2016?
  • Lesson 7.4 - How to use the Bold, Italic, and Underline commands in Excel 2016?
  • Lesson 7.5 - How to do Cell boarders and fill colors?
  • Lesson 7.6 - How to use Cell Style in Excel 2016?
  • Lesson 7.7 - How to alignment text in excel 2016?
  • Lesson 7.8 - How to use Format Painter in Excel 2016?
    • 08

    Lesson 8: Understanding Numbering Formats

  • Lesson 8.1 - What are number formats?
  • Lesson 8.2 - Why use number formats?
  • Lesson 8.3 - How to Applying number formats?
  • Lesson 8.4 - How to use number formats correctly?
  • Lesson 8.5 - How to use Percentage Formats?
  • Lesson 8.6 - How to use Date Formats?
  • Lesson 8.7 - Numbering Formatting Tips.
  • Lesson 8.8 - How to Increase and Decrease Decimal?
    • 09

    Lesson 9: Working with multiple worksheets

  • Lesson 9.1 - How to Insert a new worksheet?
  • Lesson 9.2 - How to copy a worksheet?
  • Lesson 9.3 - How to rename worksheet?
  • Lesson 9.4 - How to move a worksheet?
  • Lesson 9.5 - How to change the worksheet tab color?
  • Lesson 9.6 - How to to delete a worksheet?
  • Lesson 9.7 - How to Switch between worksheet?
  • Lesson 9.8 - How to Grouping and ungrouping worksheet?
    • 10

    Lesson 10: Using Find and Replac in Excel 2016

  • Lesson 10.1 - How to Find Content in Excel 2016
  • Lesson 10.2 - How to Replace Cell Content in Excel 2016
    • 11

    Lesson 11: Checking Spelling in Excel 2016

    12

    Lesson 12: Page Layout and Pringing in Excel 2016

  • Lesson 12.1 - How to access the print pane in excel 2016?
  • Lesson 12.2 - How to print a workbook in excel 2016?
  • Lesson 12.3 - How to choosing a print area in excel 2016?
  • Lesson 12.4 - How to print the entire workbook in excel 2016
  • Lesson 12.5 - How to print a Selection in Excel?
  • Lesson 12.6 - How to Adjusting content in Excel 2016?
  • Lesson 12.7 - How to include print title in excel 2016?
  • Lesson 12.8 - How to adjust page breaks in excel 2016?
  • Lesson 12.9 - How to modify margins in the preview pane?
    • 13

    Lesson 13: Intro to Formulas in Excel 2016

  • Lesson 13.1 - Connecting to the Internet
  • Lesson 13.2 - Browing the Web
  • Lesson 13.3 - Navigating websites
  • Lesson 13.4 - Other things you can do on the Internet
    • 14

    Lesson 14: Creating more Complex Formulas

  • Lesson 14.1 - What is the Cloud?
  • Lesson 14.2 - Why use the cloud?
  • Lesson 14.3 - What is the web app
    • 15

    Lesson 15: Relative and Absolute Cell Reference

  • Lesson 15.1 - Keeping your computer physically clean
  • Lesson 15.2 - Cleaning the Monitor
  • Lesson 15.3 - Tips for cleaning other computer surfaces
  • Lesson 15.4 - How do computers stay cool?
    • 16

    Lesson 16: Functions in Excel 2016

  • Lesson 16.1 - Safeguarding against malware
  • Lesson 16.2 - Backing up your computer
  • Lesson 16.3 - Other Maintenance Technique
    • 17

    Lesson 17: Basic Tips for Working with Data

    18

    Lesson 18: Freezing Panes and View Options

  • Lesson 18.1 - Troubleshooting
  • Lesson 18.2 - Using the process of elimination
  • Lesson 18.3 - Simple solutions to common problems
  • Lesson 18.4 - Solving more difficult problems
    • 19

    Lesson 19: Softing Data in Excel 2016

    20

    Lesson 20: Filtering Data

    21

    Lesson 21: Groups and Subtotals

    23

    Lesson 23: Basic Computer Quiz