Tutorialspoint

April Learning Carnival is here, Use code FEST10 for an extra 10% off

Microsoft Excel Course with Advanced Formulae

person icon Suhail Gangaram

4.4

Microsoft Excel Course with Advanced Formulae

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

updated on icon Updated on Apr, 2024

language icon Language - English

person icon Suhail Gangaram

category icon Excel Formulas and Functions

Lectures -20

Duration -2 hours

4.4

price-loader

30-days Money-Back Guarantee

Training 5 or more people ?

Get your team access to 10000+ top Tutorials Point courses anytime, anywhere.

Course 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!

Goals

What will you learn in this course:

  • 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

Prerequisites

What are the prerequisites for this course?

  • Know how to operate a personal computer
  • Has a basic understanding and has worked with Excel calculations and formulae before
Microsoft Excel  Course with Advanced Formulae

Curriculum

Check out the detailed breakdown of what’s inside the course

Calculation
5 Lectures
  • play icon RANDARRAY, RANDBETWEEN, SEQUENCE 11:56 11:56
  • play icon SUMIF & SUMIFS 06:06 06:06
  • play icon AVERAGEIF & AVERAGEIFS 03:00 03:00
  • play icon COUNTIF & COUNTIFS 02:15 02:15
  • play icon SUMPRODUCT 03:12 03:12
Indexing, Matching and Lookups
5 Lectures
Tutorialspoint
Handling errors and Smart Referencing
5 Lectures
Tutorialspoint
Offsetting, Sorting and Filtering
5 Lectures
Tutorialspoint

Instructor Details

Suhail Gangaram

Suhail Gangaram

e


Course Certificate

Use your certificate to make a career change or to advance in your current career.

sample Tutorialspoint certificate

Our students work
with the Best

Related Video Courses

View More

Annual Membership

Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses

Subscribe now
Annual Membership

Online Certifications

Master prominent technologies at full length and become a valued certified professional.

Explore Now
Online Certifications

Talk to us

1800-202-0515