0:00 / 10:11
 
 
 
 
 
 

How to Plan & Create Excel Spreadsheets

27 CQ
6 Lessons
Course Info
  • Playing
    Free
    6 CQ
    1. How to Plan an Excel Spreadsheet
    A lesson with Geoff Hudson
    View lesson

    Follow along to learn how to plan a spreadsheet in Excel to calculate whether or not a bank will grant a loan, and complete the course for specific details.

    How to Plan an Excel Spreadsheet
    with Geoff Hudson

    Follow along to learn how to plan a spreadsheet in Excel to calculate whether or not a bank will grant a loan, and complete the course for specific details.

  • Playing
    4 CQ
    2. Goal Seek & Scenario Manager in Excel
    A lesson with Geoff Hudson
    View lesson

    Learn how to use what-if data analysis tools in Excel to customize the calculations and display of data, including Goal Seek and Scenario Manager.

    Goal Seek & Scenario Manager in Excel
    with Geoff Hudson

    Learn how to use what-if data analysis tools in Excel to customize the calculations and display of data, including Goal Seek and Scenario Manager.

  • Playing
    4 CQ
    3. Auto Fill, Charts & Format in Excel
    A lesson with Geoff Hudson
    View lesson

    You'll learn how to use various features of Excel, like Auto Fill to automatically calculate data, and creating a chart using a keyboard shortcut.

    Auto Fill, Charts & Format in Excel
    with Geoff Hudson

    You'll learn how to use various features of Excel, like Auto Fill to automatically calculate data, and creating a chart using a keyboard shortcut.

  • Playing
    4 CQ
    4. Creating a Table of Contents in Excel
    A lesson with Geoff Hudson
    View lesson

    Follow along to learn how to adjust the layout and tabs or sheets in a workbook, and how to create a table of contents in Excel.

    Creating a Table of Contents in Excel
    with Geoff Hudson

    Follow along to learn how to adjust the layout and tabs or sheets in a workbook, and how to create a table of contents in Excel.

  • Playing
    4 CQ
    5. How to Format Charts in Excel
    A lesson with Geoff Hudson
    View lesson

    In this lesson, learn how to format a chart in Excel, customizing everything from axis titles to the legend and more!

    How to Format Charts in Excel
    with Geoff Hudson

    In this lesson, learn how to format a chart in Excel, customizing everything from axis titles to the legend and more!

More...