Microsoft Excel Super User - Advanced Formulae

Focused View

Suhail Gangaram

2:06:26

21 View

1. Calculation

1. RANDARRAY, RANDBETWEEN, SEQUENCE.mp4

11:56

2. SUMIF & SUMIFS.mp4

06:06

3. AVERAGEIF & AVERAGEIFS.mp4

03:00

4. COUNTIF & COUNTIFS.mp4

02:15

5. SUMPRODUCT.mp4

03:12

2. Indexing, Matching and Lookups

1. INDEX.mp4

05:43

2. MATCH.mp4

09:07

3. XMATCH.mp4

08:19

4. Vlookup & Hlookup.mp4

07:32

5. Xlookup.mp4

08:14

3. Handling errors and Smart referencing

1. IFERROR.mp4

04:40

2. INDIRECT.mp4

09:51

3. CHOOSE.mp4

05:32

4. SMALL.mp4

02:05

5. ROWS.mp4

02:37

4. Offsetting, Sorting and Filtering

1. OFFSET.mp4

18:04

2. SORT.mp4

05:50

3. SORTBY.mp4

03:23

4. UNIQUE.mp4

02:24

5. FILTER.mp4

06:36

Description

For any Excel user (Beginner to Advanced) wanting to enhance their calculation efficiency and productivity

What You'll Learn?

Learn efficient use and application of advanced Excel formulae
Learn basic tips and tricks to enhance productivity
Learn how to apply advanced formulae for use in dashboard-like scenarios
Learn how to apply advanced formulae for quick and efficient calculations

Who is this for?

Anyone interested in improving Excel calculation efficiency and productivity

Anyone ranging from a Beginner to Advanced Excel user

What You Need to Know?

Know how to operate a personal computer

Has a basic understanding and has worked with Excel calculations and formulae before

More details

Description
Welcome to Microsoft Excel Super User - Advanced Formulae
In this course, any Excel user (Beginner to Advanced) will learn and improve on their existing Excel proficiency.
They will have the opportunity to learn Excel in a simple manner with the aim of enhancing calculation efficiency and productivity.
By the end of this course, learners will know:
How to efficiently use and apply advanced Excel formulae.
Basic tips and tricks to enhance productivity.
How to use and apply advanced formulae for dashboard-like scenarios.
How to use and apply advanced formulae for quick and efficient calculations.
My name is Suhail Gangaram and I will be your teacher for this course.
I have a BSc. (Hons) Mechanical Engineering degree with a higher certificate in Production/Operations and Productivity Management.
My Excel journey began when I first started working in a process improvement role, where my work involved improving operational processes and efficiencies within industrial production environments.
Currently, I am working as a Senior PMO Analyst and the work I have done up until now, involved and continues to involve the use of Excel, where I mainly use it for analyses and designing interactive reports and dashboards from scratch.
I want learners to learn Excel in a manner which is simple. Therefore, I have designed this course in a way that is easy to follow and understand.
If you are interested in leveling up your Excel knowledge, then you have found the right course!
Looking forward to learning with you in your Excel journey. Good luck!
Who this course is for:
Anyone interested in improving Excel calculation efficiency and productivity
Anyone ranging from a Beginner to Advanced Excel user

User Reviews

Rating

average 0

Total votes0

Focused display

Senior PMO Analyst with a Bachelor's degree in Mechanical Engineering and higher certificate in Production/Operations and Productivity Management. Has a keen interest in optimizing process flows, analyzing and visualizing data, and building dashboards to simplify KPI reporting.Love's to teach and share knowledge learned in a clear and simple manner.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.