Learn Microsoft Excel

Learn how to use Microsoft Excel with these step-by-step tutorials. From charts and graphs to invoices and macros, you'll learn everything you need to know.
  1. How to Protect Cells, Sheets, and Workbooks in Excel

    How to Protect Cells, Sheets, and Workbooks in Excel

    Tutorial Intermediate

    Use these steps to protect Excel cells, sheets, and workbooks. Make sure your Excel data doesn't fall into the wrong hands or edited without your knowledge.

  2. How to Add Slicers to Pivot Tables in Excel in 60 Seconds

    How to Add Slicers to Pivot Tables in Excel in 60 Seconds

    Tutorial Beginner

    Slicers make it easy to change views inside of pivot tables. Learn how to add slicers to Excel pivot tables fast and control your unique spreadsheet views.

  3. How to Freeze Panes and Rows in Excel in 60 Seconds

    How to Freeze Panes and Rows in Excel in 60 Seconds

    Tutorial Beginner

    With large Excel spreadsheets, it helps to freeze a row or column so that it's always in a view. Discover how to quickly freeze panes in Microsoft Excel.

  4. How To Make Use of 5 Advanced Excel Pivot Table Techniques

    How To Make Use of 5 Advanced Excel Pivot Table Techniques

    Tutorial Advanced

    Take your skills a level deeper with these 5 advanced Excel PivotTable techniques. Learn how to control and master your data with these helpful features.

  5. How to Insert, Delete & Hide New Sheets in Excel in 60 Seconds

    How to Insert, Delete & Hide New Sheets in Excel in 60 Seconds

    Tutorial Beginner

    In this tutorial, learn how to insert and then delete sheets in Excel. Also, how to hide sheets in your Excel workbook as needed, so you can work quickly.

  6. How to Use PivotTables to Analyze Your Excel Data

    How to Use PivotTables to Analyze Your Excel Data

    Tutorial Intermediate

    Learn how to use PivotTables to analyze your data. Make better sense of your spreadsheets using these easy drag and drop PivotTable techniques in Excel.

  7. How to Create Your First PivotTable in Microsoft Excel

    How to Create Your First PivotTable in Microsoft Excel

    Tutorial Beginner

    With a PivotTable, you can point Excel to a list of data and summarize it in a few clicks. Learn how to create a PivotTable in Excel with this powerful tool.

  8. How to Add Links to Excel in 60 Seconds

    How to Add Links to Excel in 60 Seconds

    Tutorial Beginner

    The cells of a spreadsheet can hold a variety of things including hyperlinks. Let's look at two types of links in Excel that we can add to a spreadsheet.

  9. How to Use Conditional Formatting in Microsoft Excel

    How to Use Conditional Formatting in Microsoft Excel

    Tutorial Beginner

    Learn how to use conditional formatting in Microsoft Excel to format cells based upon what's inside of them. Change their color and style automatically.

  10. How to Use AutoSum in Excel in 60 Seconds

    How to Use AutoSum in Excel in 60 Seconds

    Tutorial Beginner

    AutoSum is a one-click tool in Excel to run functions on a list of data in your spreadsheets. Learn how to use AutoSum in Excel in this quick tutorial.

  11. Quick Start: How to Make a Basic Formula in Excel

    Quick Start: How to Make a Basic Formula in Excel

    Tutorial Beginner

    Formulas drive the usefulness of spreadsheets. Learn how to make and work with your first formula in Microsoft Excel, as well as how to use basic functions.

  12. How to Use the Excel Format Painter in 60 Seconds

    How to Use the Excel Format Painter in 60 Seconds

    Tutorial Beginner

    Excel's Format Painter is a key time saving tool. Learn how to work with Excel Format Painter—using it to quickly apply styles from one table to another.