Excel: Basic Excel and Business Analytics (Udemy.com)

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

( 45 Reviews )

Created by: Jeff Knowlton

Produced in 2014

What you will learn

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!

Quality Score

Content Quality

Video Quality

Qualified Instructor

Course Pace

Course Depth & Coverage

Overall Score : 88 / 100

Course 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. Who this course is for:
Recent graduates looking for work, especially those from non-business majors.
College students, especially those starting a program in business. The course is recommended by the Oregon Business Education Association. People starting their career, who wish to accelerate their promotion path.
People returning to work in the business world, after an extended absence. Anyone curious about using Excel to summarize data to find valuable information.

Time: 3h

Instructor Details

Jeff Knowlton

4.4 Rating
45 Reviews

I am a senior business executive, a data scientist, and a former university instructor. And I've been using Excel, and tools like it, for more than 30 years!
In addition to my current role as VP Information Business Services, I've been a global project manager for the deployment of very large IT systems, a senior statistician/data scientist, a university instructor and a corporate trainer.
I bring a unique perspective to Excel and business analytics. I know how Excel is used in business, and I know what hiring managers are looking for. All of my courses are built on authentic case studies, using real data to show how Excel functions are used today in business. I can help you prepare for interviews, and excel in your first job as a business analyst.
I have two degrees from Stanford University, one in English with Honors in Humanities, and a graduate degree in Statistics (now called data science). I explain technical concepts in non-technical terms.
You can see more detail on my linked in page. Send me a connection request!

Excel Quick Start Tutorial: 36 Minutes to Learn the Basics

Excel Quick Start Tutorial: 36 Minutes to Learn the Basics (2016)

- Provider: Udemy
- Time: 36m

$11.99

All courses by Jeff Knowlton

More excel courses

Excel Skills for Business: Essentials (2017)
5.0 (432 Reviews)

- Provider: Coursera
- Time: 4h

Free

Excel Skills for Business: Intermediate I
4.9 (463 Reviews)

- Provider: Coursera
- Time: 22h

Free

Excel Dynamic Arrays - Beginner to Expert (Microsoft 365)

Excel Dynamic Arrays - Beginner to Expert (Microsoft 365) (2021)
4.9 (216 Reviews)

- Provider: Udemy
- Time: 7h

$11.99

Visually Stunning Microsoft Excel Dynamic Dashboard Course

Visually Stunning Microsoft Excel Dynamic Dashboard Course (2021)
4.9 (193 Reviews)

- Provider: Udemy
- Time: 7h

$11.99

Excel with Top Microsoft Excel Hacks (2016)
4.9 (95 Reviews)

- Provider: Udemy
- Time: 2h

$11.99

Microsoft Excel Complete Excel Guide (Excel 2007 2021)

Microsoft Excel Complete Excel Guide (Excel 2007 2021) (2021)
4.9 (62 Reviews)

- Provider: Udemy
- Time: 21h

$11.99

All excel courses

Reviews

4.4

45 total reviews

5 star 4 star 3 star 2 star 1 star

Write a Review

By Vasudeva Reddy G on 10/15/2020

I liked the section 6 more than others as this chapter gives practical knowledge on printing and reporting.

By Jonathan F. Jackson 2nd on 9/18/2020

Dude is pretty chill and straight to the point.

By Augusto on 8/5/2020

cant download the files

By Raghav Sharma on 8/1/2020

explanation is very good and also helpful for the beginner to learn quickly

By Kallagunta sai sri saha pradhitha on 6/19/2020

It's quite interesting and informative

By Mohammed Hasan Haider ALhashdy on 6/16/2020

normal !

By Vikas Jatav on 6/11/2020

good

By Veenashree on 5/4/2020

it was simple and understanding

By Alan Guda on 4/20/2020

basic and very learner friendly. thank you.

By Profeta on 4/20/2020

Really short, but explanatory enough!

By Alpar Mozes on 4/14/2020

Very good! Clear explanations, lots of practice. Recommended 100%.

By Ana Limon on 9/20/2019

Good Course, but it truly is for someone that has never use excel. For people for are already somewhat familiar with excel I recommend they opt for a bit more advance course.