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

    13

    Lesson 13: Intro to Formulas in Excel 2016

    14

    Lesson 14: Creating more Complex Formulas

    15

    Lesson 15: Relative and Absolute Cell Reference

    16

    Lesson 16: Functions in Excel 2016

    17

    Lesson 17: Basic Tips for Working with Data

    18

    Lesson 18: Freezing Panes and View Options

    19

    Lesson 19: Softing Data in Excel 2016

    20

    Lesson 20: Filtering Data

    21

    Lesson 21: Groups and Subtotals

    22

    Lesson 22: Tables

    23

    Lesson 23: Charts

    24

    Lesson 24: Conditional Formatting

    25

    Lesson 25: Track Changes and Comments

    26

    Lesson 26: Inspecting and Protecting Workbooks

    27

    Lesson 27: Intro to PivotTables

    28

    Lesson 28: Doing More with Pivot Tables

    29

    Lesson 29: What-if Analysis

    30

    Lesson 30: Microsoft Excel Quiz