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 Manage Your Excel Formulas: Copy, Paste and Autofill

    How to Manage Your Excel Formulas: Copy, Paste and Autofill

    Tutorial Beginner

    Get started with managing Excel formulas. Learn quick workflows to write formulas, copy them, use autofill, and more. It's time to take control of your...

  2. How to Insert an Excel File into PowerPoint in 60 Seconds

    How to Insert an Excel File into PowerPoint in 60 Seconds

    Tutorial Beginner

    In this quick-fire video, learn how to take your spreadsheet file and copy it from Excel over to embed in PowerPoint. Also, control how you style your data.

  3. How to Start Using COUNTIF, SUMIF, and AVERAGEIF in Excel

    How to Start Using COUNTIF, SUMIF, and AVERAGEIF in Excel

    Tutorial Intermediate

    In this tutorial, learn how to use three conditional Excel math functions to add logic to your spreadsheets. Get started with COUNTIF, SUMIF, and AVERAGEIF.

  4. How to Work With Date and Time Formulas in Excel

    How to Work With Date and Time Formulas in Excel

    Tutorial Intermediate

    Master key formulas for working with dates and times in Microsoft Excel. Learn how to properly format dates/times and put Excel date formulas to good use.

  5. How to Use Simple IF Statements in Excel

    How to Use Simple IF Statements in Excel

    Tutorial Intermediate

    Do you want to build smart options into your spreadsheets? Then, learn how to use IF statements in Microsoft Excel to make your spreadsheets much smarter.

  6. How to Concatenate in Excel to Combine Text Strings

    How to Concatenate in Excel to Combine Text Strings

    Tutorial Intermediate

    In this quick lesson, learn how to use Excel's concatenation feature to join text into strings. Skip the work of manually retyping data into your spreadsheets.

  7. How to Work With Excel Math Formulas (Guide to the Basics)

    How to Work With Excel Math Formulas (Guide to the Basics)

    Tutorial Beginner

    Never use a calculator again! In this tutorial, learn the essential Excel Math formulas for working with numbers and making calculations in Microsoft Excel.

  8. How to Find and Remove Duplicates in Excel Quickly

    How to Find and Remove Duplicates in Excel Quickly

    Tutorial Beginner

    Learn how to find duplicates in Excel and then clean them up. Delete messy, repetitive Excel spreadsheet fields with Microsoft's Remove Duplicates function.

  9. How to Use the Excel VLOOKUP Function - With Useful Examples

    How to Use the Excel VLOOKUP Function - With Useful Examples

    Tutorial Beginner

    Need to match elements from two spreadsheet lists? Discover what VLOOKUP is, how to use VLOOKUP in Excel (with proper written formulas), and fix common issues.

  10. How to Calculate Percentages in Excel With Formulas

    How to Calculate Percentages in Excel With Formulas

    Tutorial Intermediate

    In this tutorial, learn how to calculate percentages in Excel with step-by-step workflows. Get the formulas, functions, and techniques to help you work with...

  11. Excel What-If Analysis: How to Use the Scenario Manager

    Excel What-If Analysis: How to Use the Scenario Manager

    Tutorial Intermediate

    Learn how to compare multiple sets of data in Excel with the What if Analysis Scenerio Manager. It helps you find a solution or make a decision based on data...

  12. How to Use Excel: 12 Techniques for Power Users

    How to Use Excel: 12 Techniques for Power Users

    Tutorial Intermediate

    Learn how to use Excel more efficiently. With the powerful Excel techniques and tips in this article, you’ll get your work done faster and without a lot of...