Excel: Basic Excel and Business Analytics
4.0 (22 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
324 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Excel: Basic Excel and Business Analytics to your Wishlist.

Add to Wishlist

Excel: Basic Excel and Business Analytics

Via an authentic case study, learn the basics, starting with entering data & formulas, up to pivot tables and charts.
4.0 (22 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
324 students enrolled
Created by Jeff Knowlton
Last updated 8/2014
English
Learn Fest Sale
Current price: $10 Original price: $20 Discount: 50% off
3 days left at this price!
30-Day Money-Back Guarantee
Includes:
  • 3 hours on-demand video
  • 1 Supplemental Resource
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I 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!
View Curriculum
Requirements
  • A copy of Excel. Excel 2010, 2013, or Office 365 are preferred.
  • No math required!
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 is the target audience?
  • 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.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 27 Lectures Collapse All 27 Lectures 02:57:52
+
Course Introduction
3 Lectures 10:28

In this lesson, I answer three questions:

    1.Why should you learn Excel?

    2.What is business analytics?

    3.And of the many courses in Excel, why should you take this one?

Watch the video and find out!

Preview 04:17

In this lesson, I introduce myself. I am the VP of Global Services at a mid-size manufacturing firm. Previously, I was a vice-president of Information Technology, with 15+ years of experience. Earlier in my career, I was a corporate trainer and a university professor, so I have relevant teaching experience. And I've been using spreadsheet tools like Excel since 1983.

Look me up on Linked In!

Preview 01:50

This lesson covers the pre-requisites (you need a copy of Excel you can use - that's it), and provides the course map. I also provide you with some strategies so that you can learn the most from this course.

Let’s get started!

Preview 04:21
+
Business Basics
4 Lectures 14:48

The examples in this course are based on a fictitious company, Cowboy Business Machines. This lesson introduces the company and their products. By the end of this course, you will be able to answer these questions about the sales for Cowboy Business Machines:

  1. Who are the top customers?
  2. What are the best selling products?
  3. Through the year, did sales trend up, trend down, or stay about the same?

These are the types of real questions that businesses ask everyday.

Preview 02:58

The examples in this course are based on sales reporting for Cowboy Business Machines. Each sale is documented in an invoice. This lesson introduces the main elements of a business invoice, the basis of sales reporting.

Preview 07:56

This lesson shows conceptually how the data from an invoice is mapped into a spreadsheet for analysis.

Preview 03:54

This lesson shows you how to download the script for the lecture, the homework assignment accompanying the lectures, and the practice Excel files.

Preview 1 page
+
Excel Basics
6 Lectures 54:02

It's time to open Excel! This lesson begins the introduction to Excel. It provides a tour of the screen, naming the key elements.

Preview 06:10

This lesson covers basic file management: creating new files, opening files, and saving files. If you’ve used other computer applications, then this lesson should be very easy for you, since Excel uses the same basic commands as most every other computer desktop application.

File Management
03:58

In this lesson, I explain how to enter data into the spreadsheet and move around from cell to cell. I also explain some of the different data formats, like texts, numbers, accounting/currency, and dates. Finally, I introduce basic cell formatting, like centering, wrapping texts, and aligning the data to the left, right, or center.

Entering Data
15:40

This lesson introduces formulas, one of the most powerful Excel features.

Formulas
06:52

In this lesson, I show you how to copy /paste data and formulas, and insert / delete columns and rows. These are some of the most commonly used functions in Excel. They help you work faster and more accurately.

Copy/Paste, Insert/Delete
11:50

In this lesson, I introduce some tips and tricks for working faster and smarter, like using the "context-sensitive menu" and the undo command to correct errors.

Some Tips and Tricks
09:32
+
Summarizing Data with Pivot Tables
6 Lectures 39:16

Now the fun begins! In this section, I provide the list of all invoice line items from Cowboy Business Machines for the year 2013. By the end of this section, you will be able to make pivot tables to answer three important questions:

  1. Who are the top customers?
  2. What are the top-selling products?
  3. Are sales trending upward or downward?
Introduction to Pivot Tables
01:40

In this lesson, I provide the file with the un-formatted data (often called raw data). Your job is to format it and prepare it for the pivot table.

Preparing the Data for Pivot Tables
06:51

In this lesson, I show you how to convert the data into an Excel table, providing filters on each of the columns, so that you can quickly find data and sort data.

The Table Command and Data Filters
08:07

Time to make the pivot table to summarize the data!

Making a Pivot Table
11:10

This lesson provides a few tips and tricks for formatting pivot tables.

Formatting Pivot Tables
07:06

In this lesson, I review what we've learned so far about pivot tables.

Review of Pivot Tables
04:22
+
Charting Data with Pivot Tables
2 Lectures 13:08

In this lesson, I provide an overview of the main elements of a chart in Excel, like the title, axes, and legends.

An Introduction to Charts
01:50

In this lesson, I show you how to make a chart based on the data in the pivot tables. We'll make a chart of the top customers and top products. I also show you how to perform a top 10 analysis, showing only the top 10 (or top 12) customers and products.

The Pivot Chart
11:18
+
Presenting the Results - Printing and Reporting
5 Lectures 37:19

The analysis is complete, but the job is not yet done. The results of the analysis must be clearly explained, and it's best done in writing. In this section, the lessons will cover how to print from Excel, and some tips on writing a good business and sales report.

Preview 02:02

In this lesson, I show you how to format the data in the workbook to prepare it for printing. Some examples include the orientation of the output (portrait or landscape) and how to scale the output so that it fits on one page wide.

Page Setup
08:05

In the last lesson, I showed you how to format the worksheet to print it. In this lesson, I show you how to print.

Print Dialog Box
04:30

This lesson provides several printing examples, primarily focusing on setting the print area in a spreadsheet to print a chart, print a pivot table, or print any region of a spreadsheet.

Some Printing Examples
05:12

This is not just an Excel course. It's important to be able to explain the results of your analysis in writing and with clarity. This lesson covers these topics:

    ·Some suggestions for topics to include in a written business report.

    ·Techniques for copying pivot tables and charts from Excel to Word.

    ·Some formatting tips and tricks for Microsoft Word.

Preview 17:30
+
Course Review
1 Lecture 07:51

Congratulations! You've worked very hard and finished this course.

This lesson provides a course review, and also provides a practice file of rawdata, so you can work from start to finish. I recommend that you work through the practice file, making the pivot tables and charts, to ensure that you've mastered the concepts and techniques from this course.

Try it Yourself! A course review with practice file.
07:51
About the Instructor
Jeff Knowlton
4.5 Average rating
389 Reviews
4,396 Students
5 Courses
Senior Executive. Data Scientist. Teacher.

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 Global Services, I've been a VP of Information Technology, 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 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!