Explore

Excel: Learn 47 Functions via a Business Services Case Study

2 hours on-demand video

$ 12.99

Save Course

Go to Course

Brief Introduction

Build a bridge to better Excel skills. Learn advanced date, text and logical functions, with pivot tables and charts

Description

One of the world’s leading consulting firms, the McKinsey Global Institute, has identified a huge gap between the demand for people with deep analytical skills, and the supply of qualified candidates. They call it a “critical shortage”, totaling more than 150,000 people by 2018. They’re not only talking about careers in computer programming. They’re saying that these skills will be required for almost all middle-class careers, from HR to sales, accounting to purchasing, and even factory production workers.

Where do you start, to improve your analytical skills and increase your opportunities for a good career? Start by learning Excel. Excel is the primary analytical tool used in business today. How do I know? I’m a senior business executive, with over 25 years of experience across several different industries.

Excel is the perfect foundation on which to build your analytical skills.

There are many Excel courses – why take one of mine? Because I’m a business executive, I know how Excel is used in business. I know the analytical skills needed. And don’t just take my word for it.

Here's more proof

A local university uses my Udemy courses to teach pivot tables. And my courses are recommended by the Oregon Business Education Association.

What do they like about my courses? They like the realistic case studies. One case study is followed throughout the entire course, showing how business uses Excel to solve real-world problems.

Students learn about Excel more deeply, and the knowledge “sticks”, because the course is more than just a list of commands and menu paths. The course is based on a real business problem that you solve during the course.

This course covers these topics in Excel:

Importing Text Files
Date Functions
Text Functions
Logical Functions (IF, OR, AND)
The VLOOKUP function, to make cross-reference tables
Table Functions, including pivot tables and pivot charts

Learn and master more than 47 Excel functions

The course is targeted at people who have some familiarity with Excel. You should know how to edit data, create formulas, and use the copy / paste functions, like Control-C and Control-V.

Content and Overview

There are 27 lessons, comprising about 2 hours of video. The course is based on a case study, to evaluate the performance of two service companies. Each company has sent a text file with their repair history, thousands of records each. The data is dirty: there are duplicate records, the dates are encoded in text fields,and the product codes are not harmonized. Just like real life. Students will learn how to use Excel functions to import the data and clean up the files.

Most lessons have a practice session. I provide two Excel files: the starting point and the finish point. I also provide the written script for each lesson. There's a quiz at the end, to ensure that you’ve mastered the topics. I make it easy for you to succeed.

Let's get started!

Requirements

Requirements
You should have a copy of Excel that you can use, preferably Excel 2013 or Excel 2016, but Excel 2010 will work.
You should be able to enter data into Excel, create formulas, copy/paste data, and use some basic short-cuts, like Control-C and Control-V.
This is not a beginner's course! But if you've been using Excel for several months, either at work or in school, you'll do fine.

Recommended for you

Excel: Learn 47 Functions via a Business Services Case Study

Build a bridge to better Excel skills. Learn advanced date, text and logical functions, with pivot tables and charts They’re not only talking about careers in computer programming....

Save Course