Skip to content
Write a review
UdemyExcelPaid courseCertificate

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.

4.4
45 reviews

Created by: Jeff Knowlton

Produced in 2014

icon
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!

How it compares

Against the other 355 rated Udemy courses in Excel on CourseDuck:

  • Rating4.4 out of 5higher than 25% of them
  • Reviews45#349 of 356 by number of reviews
  • Length3 hoursshorter than 74% of them

icon
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.
Read More product length iconTime: 3h

icon
Udemy Discount

The discount is applied through our link. Open the course from here and Udemy's current promotional price is applied at checkout on most courses, no code to type.

Get the Udemy discount

Some courses are excluded from Udemy's promotions. If the price does not drop, clear your browser cookies and use the button again.

icon
Instructor Details

Jeff Knowlton

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!

Read More

icon
More courses by Jeff Knowlton

$11.99

All courses by Jeff Knowlton

icon
More Excel courses

$39.99

Free

$99.99

Free

$15.99

$119.99

All Excel courses

icon
Reviews

4.4

45 reviews in total

Select a bar to show only those reviews.Select the bar again to show every rating.

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.

Showing 12 of 45 reviews

icon
Quality Score

No CourseDuck member has rated this course yet. Taken it? Give each part a thumbs up or down.

Content Quality
/
Video Quality
/
Qualified Instructor
/
Course Pace
/
Course Depth & Coverage
/

Overall Score : 88 / 100

Excel: Basic Excel and Business Analytics
Visit course on Udemy Write a review
  • Video Duration: icon 3h
  • Price: See price on Udemy
  • Provider: icon Udemy
  • Year: icon 2014
  • Language: icon English
  • Certificate: icon Yes
30-day money-back guarantee on most paid courses

Udemy Coupon Price Tracker

Udemy price history

For any issues or feature requests please email CourseDuck's Co-Founder at mkuhlman12@gmail.com