Study Learn Grow
12 Advanced Excel Formulas

12 Advanced Excel Formulas


Here you will learn about some of the advanced Excel formulas that I've learnt and have been teaching for the past 20 years. It's really fun to learn Excel.

Overview

About this Course
Learn 12 useful advanced formulas in Excel from Bill Jelen - host of MrExcel.com.

Here you will learn about some of the advanced Excel formulas that I've learnt and have been teaching for the past 20 years. It's really fun to learn Excel.

Join me in the course and you will see the difference.

Enroll NOW.

Basic knowledge
This course is designed for someone who uses Excel 20+ hours per week. I assume you are already familiar with sorting, filtering, and pivoting data

Course Information

This course is designed for someone who uses Excel 20+ hours per week. I assume you are already familiar with sorting, filtering, and pivoting data

What you will learn
This course covers twelve topics:

Formula for the Total of Visible Cells After Applying a Filter
Spearing Formula to Create a 3D Reference Type
Formulas for the new Geography Data Types
How to Use Function Arguments with Nested Functions
VLOOKUP between worksheets
Using TRUE version of VLOOKUP
Find the Last Value in a Row or Column
Calculate Workdays for Non-Standard Work Weeks
When Would Anyone Actually Use GetPivotData Functions
Use INDIRECT to Always Point to a Particular Cell
Replace OFFSET with INDIRECT to Avoid Volatility
Create Business Diagrams Populated by Formulas
A bonus tip to make a Baker's Dozen!

Users who want to learn more advanced formulas and functions of Excel.
Students looking for a comprehensive, engaging, and interactive approach to Excel training.

• Lifetime Access to Each Course
• Certificate on Completion of Course
• No Extra Charges Or Admin Fees
• Easy Access to Courses
• High Priority Support After Sales.
• Big Discounts on Individual Courses

Course Specifications

IT and Computing courses are available to study on our learning platform. 

See All Courses

Adult education is the non-credential activity of gaining skills and improved education. 

See All Courses

Online education is electronically supported learning that relies on the Internet for teacher/student interaction. 

See All Courses

A short course is a learning programme that gives you combined content or specific skills training in a short period of time. Short courses often lean towards the more practical side of things and have less theory than a university course – this gives you a more hands-on experience within your field of interest.

See All Courses

Course duration is 24 hours.

See All Courses

Study Learn Grow

Related Jobs