4.25 out of 5
56 reviews on Udemy

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
Jeff Knowlton
308 students enrolled
English [Auto]
Clean / Scrub large data sets with many different types of Excel functions
Import text files into Excel, both delimited and fixed width files.
Work with text strings, to parse data, format text strings, clean/trim text data, join/concatenate text strings, and split text into columns.
Make Excel dates from text strings and values; calculate duration (like net work days), parse dates, and work with international dates
Build complex logical expressions with IF, AND, OR
Use VLOOKUP to harmonize data with cross-reference and mapping tables.
Summarize data with pivot tables and filters; remove duplicates from data sets
Visualize data with pivot charts

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!

You can view and review the lecture materials indefinitely, like an on-demand channel.
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don't have an internet connection, some instructors also let their students download course lectures. That's up to the instructor though, so make sure you get on their good side!
4.3 out of 5
56 Ratings

Detailed Rating

Stars 5
Stars 4
Stars 3
Stars 2
Stars 1
30-Day Money-Back Guarantee


2 hours on-demand video
Full lifetime access
Access on mobile and TV
Certificate of Completion
Excel: Learn 47 Functions via a Business Services Case Study
$40.98 $30


For Professionals

For Businesses

We support Sales, Marketing, Account Management and CX professionals. Learn new skills. Share your expertise. Connect with experts. Get inspired.


Partnership Opportunities

Layer 1
Register New Account
Compare items
  • Total (0)