Tags
Language
Tags
March 2024
Su Mo Tu We Th Fr Sa
25 26 27 28 29 1 2
3 4 5 6 7 8 9
10 11 12 13 14 15 16
17 18 19 20 21 22 23
24 25 26 27 28 29 30
31 1 2 3 4 5 6

Excel: Basic Excel and Business Analytics

Posted By: naag
Excel: Basic Excel and Business Analytics

Excel: Basic Excel and Business Analytics
MP4 | Video: 1280x720 | 79 kbps | 48 KHz | Duration: 3 Hours | 639 MB
Genre: eLearning | Language: English

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

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.

Excel: Basic Excel and Business Analytics