Microsoft Excel Basics – Creating a Sales Report

Learn how to create a great looking sales report in under an hour in this project based course!

If you use Microsoft Excel in your professional life, or even personal life, then this class will be perfect for you.

What you’ll learn

  • Designing a sales report.
  • Basic data analysis.
  • How to use Excel in the workplace.
  • Formatting data.
  • Absolute and relative cell references.
  • Moving and amending data.
  • Creating basic bar charts and line charts.
  • Printing a worksheet.
  • Basic functions, such as SUM, AVERAGE, MIN, MAX and COUNT.
  • How to improve the design of charts and graphs so that they stand out.

Course Content

  • An Overview of Microsoft Excel –> 1 lecture • 5min.
  • Working with Text and Formulas –> 1 lecture • 11min.
  • Using Basic Functions –> 1 lecture • 3min.
  • Amending Data –> 1 lecture • 4min.
  • Formatting Data –> 1 lecture • 5min.
  • Creating Basic Charts and Graphs –> 1 lecture • 14min.
  • Printing a Worksheet –> 1 lecture • 2min.
  • Congratulations! Your Assignment! –> 0 lectures • 0min.

Microsoft Excel Basics – Creating a Sales Report

Requirements

  • Have access to Microsoft Excel.

If you use Microsoft Excel in your professional life, or even personal life, then this class will be perfect for you.

This class is a project based class in which we will work together from beginning to end to create a sales report in Microsoft Excel. It is designed as if we were in the workplace and have been assigned a new task.

You do not need any knowledge of Microsoft Excel to follow along with this course as we will start with the basics and work our way up to creating a nicely presented sales report.

After taking this class, you should feel confident in your ability to present financial data in an appealing visual format.