Excel: Basic Excel and Business Analytics
- 3 hours on-demand video
- 68 downloadable resources
- Full lifetime access
- Access on mobile and TV
- Certificate of Completion
Get your team access to 4,000+ top Udemy courses anytime, anywhere.Try Udemy for Business
- 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!
- A copy of Excel. Excel 2010, 2013, or Office 365 are preferred.
- No math required!
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.
- 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.
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!
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!
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:
- Who are the top customers?
- What are the best selling products?
- 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.
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.
This lesson shows conceptually how the data from an invoice is mapped into a spreadsheet for analysis.
This lesson shows you how to download the script for the lecture, the homework assignment accompanying the lectures, and the practice Excel files.
It's time to open Excel! This lesson begins the introduction to Excel. It provides a tour of the screen, naming the key elements.
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.
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:
- Who are the top customers?
- What are the top-selling products?
- Are sales trending upward or downward?
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.
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.
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.