Solving business challenges with Microsoft Excel

Let's change the paradigm in an Excel training! Learn MS Excel common functions with real business scenarios.
You will be able to use basic MS Excel functions, like IF(), Networkdays(), Workday() and how to apply them in a real case scenario
You will be able to use a pre-defined MACRO and an Array function
You will learn how to use different nested MS Excel functions

This module is part of a series of training aiming to change the paradigm in MS Excel training. We will start with the end in mind, with the business challenge and then we will build a scenario and we will see how to use an Excel function to solve it !

Introducere

1
Introducere

Introduction and a short presentation of your trainer

Agenda

1
Agenda

About this training and the agenda

The scenario based training

1
Employment Contract - Scenario 1

After this lesson you will know how to properly use the WorkDay() date function in an employment scenario.

2
Employment Contract - Scenario 2

After this lesson you will know how to properly use the NetworkDays() date function in an employment scenario.

3
Penalties Estimation - Scenario 3

After this lesson you will know how to properly use the IF() logical function in a complex penalties estimation scenario.

Bonus Track

1
Using MACROS for find and replace

After this lesson you will know how to properly use a MACRO in a find (a numerical value grater than x) and replace scenario.

2
Using an Array Function to find the number of text / number cells within a range

Final words

1
Final words
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!

Be the first to add a review.

Please, login to leave a review
898f5c680474416964d789fca883f87b
30-Day Money-Back Guarantee

Includes

1 hours on-demand video
Full lifetime access
Access on mobile and TV
Certificate of Completion