Back

Duration

3 hours

Price

Level

Beginner

Certification

Available

Instructor

Jeff Knowlton

Via an authentic case study, learn the basics, starting with entering data & formulas, up to pivot tables and charts.

Expected learning & outcomes

  • By the end of the course, you will be able to use Excel to analyze the sales results for a business, by making a pivot table and chart. You will also be able to explain the results in a written report.
  • In this course, you will learn basic Excel functions, and be introduced to same intermediate ones, like pivot tables and charts.
  • Watch the first video to learn more!

    Skills you will learn

    Analysis, Business Analytics, Invoicing, Microsoft Word, Printing, Reporting, Sales Analysis, Video

    About this course

    This course provides a basic introduction to Excel via a case study. In the case study, you will analyze the product sales from a business, Cowboy Business Machines. Like other Excel courses, you'll learn the basics: data and number formats, formulas, copy/paste, insert/delete, printing, data filtering, pivot tables and charts.

    This course is different from most other Excel courses because it focuses on the use of Excel to answer real business questions like "Who were the top customers for the year?" "What were the top-selling products?" "Did sales increase or decrease?" So you'll also learn about business topics like invoicing and sales.

    At the end of the course, there is a lesson on how to write a basic business report to summarize the results from the product sales analysis: what topics to include, and some formatting tricks in Microsoft Word. So this course is not just about Excel: it's about how to analyze business data and communicate the results with clarity.

    I provide all of the scripts from the lessons. I provide all of the worksheets, with detailed answers to the practice questions. At the end of the course, there is an additional practice worksheet so that you can master the topics covered in this course. I also provide the full text from the sample business report, so that you can use it as a template in your job.

    The course has three hours of video content. Expect to spend about 8 - 12 hours altogether, over four or five days, to complete the course.

    The course is recommended by the Oregon Business Education Association.

    LORE ADVANTAGE

    Lore delivers value at the intersection of learning, interests and skills.

    Learn from Domain Experts

    Access learning options recommended by industry experts, professionals and thought leaders.

    Search & Compare

    Quickly search, select and add learning options to your learning list.

    Personalize your feed

    Tell us more about yourself to access the latest learning options, curated just for you.