Explore

Excel: Basic Excel and Business Analytics

3 hours on-demand video

$ 9.99

Save Course

Go to Course

Brief Introduction

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

Description

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.

Requirements

Requirements
A copy of Excel. Excel 2010, 2013, or Office 365 are preferred.
No math required!

Recommended for you

Microsoft Power BI - Business Intelligence for Beginners

Beginner Course on Power BI : Business Intelligence & Data/Business Analysis with Microsoft Power BI Do you want to build professional-quality Business Intelligence Reports from the ground up ?...

Save Course

Microsoft Excel Essentials (Bookkeeping & Accounting)

Microsoft Excel templates included. Microsoft Excel From Beginner to Professional. Microsoft Excel Tips and Tricks. In this course you will learn the basics of Microsoft Excel as quickly as possible....

Save Course