Excel: Learn 47 Functions via a Business Services Case Study

Online Course

Udemy

Go to Udemy

Start Learning

What is the course about?
Prerequisites & Facts
Cost, Certificate & Degree
Reviews & Experiences

What is the course about?

Excel: Learn 47 Functions via a Business Services Case Study

The course Excel: Learn 47 Functions via a Business Services Case Study is an online class provided by Udemy. It may be possible to receive a verified certification or use the course to prepare for a degree.

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

Course description

Excel: Learn 47 Functions via a Business Services Case Study

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

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.

2 hours on-demand video
36 downloadable resources
Full lifetime access
Access on mobile and TV
Certificate of Completion
Jeff Knowlton

Start Learning

Prerequisites & Facts

Excel: Learn 47 Functions via a Business Services Case Study

Course Topic

Excel Formulas and Functions, Microsoft, Office Productivity

University, College, Institution

Udemy

Course Skill Level

see course summary

Course Language

English

Place of class

Online, self-paced (see curriculum for more information)

Degree

Certificate

Start Learning

Degree & Cost

Excel: Learn 47 Functions via a Business Services Case Study

To obtain a verified certificate from Udemy you have to finish this course or the latest version of it, if there is a new edition. The class may be free of charge, but there could be some cost to receive a verified certificate or to access the learning materials. The specifics of the course may have been changed, please consult the provider to get the latest quotes and news.

Udemy

Excel: Learn 47 Functions via a Business Services Case Study

provided by Udemy

Start Learning