Current Status
Not Enrolled
Price
$250
Get Started

Excel Formulas Masterclass

Live Training Event: October 24th, 2021: 9am-5pm EST

Learn Excel formulas like you never have before. This Masterclass is a comprehensive dive into taking your Excel formula skills to an advanced level.

This masterclass is perfect for Excel users who have an introduction/intermediate level Excel formula knowledge and want to take the next step and become advanced. Users who know how to do a SUM, IF, VLOOKUP and use absolute references and want to push on to the next level.

The masterclass begins by understanding the different methods of referencing values – ranges, defined names, tables, dynamic arrays and data types. This builds a solid foundation for everything else to be built on. How, why and when to utilise these different reference types in Excel.

Not all Excel functions are created equal. So, we will explore some of the best functions in Excel to analyse data and produce dynamic reports with ‘real world’ examples.

This full-day training takes you on a journey with the best functions in Excel to build dynamic reports. We will create dynamic top N list, PivotTable style reports (not PivotTables) and charts based on formulas.

Scheduled for October 24th, 9am-5pm EST. Seats are limited so sign up today!

Attending this course, you will also receive.

Course Instructor

Alan Murray

Alan Murray

Alan is an Excel trainer with a strong passion for Excel and well, training, and fortunately stumbled into this profession 20+ years ago.

He is best known for his Computergaga blog and YouTube channel and as the author of He is best known for his "Advanced Excel Success". The Computergaga YouTube channel has more than 540 video tutorials.

Alan is a Microsoft MVP and the organiser of the "London Excel Meetup", a place to learn, share and talk Excel. These meetups operate both online and in-person in London.

When Alan is not training Excel, he is spending time with his two children, trying to improve his half marathon run time, or finding a mountain to trek.

Can’t wait to action this!

I have carried out PowerBI training recently; however Parker is brilliant at really simplifying aspects of PowerBI and I picked up some great nuggets of information! Can't wait to action this! Thanks for creating it
BI Elite Training
5
2020-04-01T22:13:37+00:00
I have carried out PowerBI training recently; however Parker is brilliant at really simplifying aspects of PowerBI and I picked up some great nuggets of information! Can't wait to action this! Thanks for creating it

Looking forward to the next levels

Really nice go-through the basiscs. Looking forward to the next levels 😉
Cristian
BI Elite Training
5
2020-04-01T22:15:17+00:00
Cristian
Really nice go-through the basiscs. Looking forward to the next levels 😉

Thoroughly recommend!

Very easy to follow and absorb , not to mention fun! Thoroughly recommend!
BI Elite Training
5
2020-04-01T22:30:37+00:00
Very easy to follow and absorb , not to mention fun! Thoroughly recommend!

Cannot wait to introduce this platform to my clients.

Well done with this one Parker! Cannot wait to introduce your platform to my clients.

Lars

BI Elite Training
5
2020-04-01T22:31:41+00:00

Lars

Well done with this one Parker! Cannot wait to introduce your platform to my clients.

Amazing course for beginners.

Amazing course for beginners.
BI Elite Training
5
2020-05-21T16:47:08+00:00
Amazing course for beginners.

Excellent for the Beginners

The course is excellent for the beginners who wants learn Power BI. It gives basic idea about Power BI

Ramesh

BI Elite Training
5
2020-05-21T16:50:05+00:00

Ramesh

The course is excellent for the beginners who wants learn Power BI. It gives basic idea about Power BI

A good introduction to Power BI.

A good introduction to Power Bi.

Sue

BI Elite Training
5
2020-05-21T16:50:44+00:00

Sue

A good introduction to Power Bi.

Very Well Thought Out

Very well thought out. Covered the basics and glad you went into DAX. Would like to see more of the visuals explored for ideas but overall great, concise course. Thank you! Looking forward to next courses!
BI Elite Training
5
2020-05-21T16:51:42+00:00
Very well thought out. Covered the basics and glad you went into DAX. Would like to see more of the visuals explored for ideas but overall great, concise course. Thank you! Looking forward to next courses!

It was really great!

It was really great!!! i loved it and got to learn lot of things. Thanks

Shubham

BI Elite Training
5
2020-05-21T16:52:22+00:00

Shubham

It was really great!!! i loved it and got to learn lot of things. Thanks

Great for Beginners

"Great for beginners with practical exercise. Thank you!"

Khatereh

BI Elite Training
5
2020-05-21T16:53:31+00:00

Khatereh

"Great for beginners with practical exercise. Thank you!"

No Feedback Given

John

BI Elite Training
5
2020-05-21T16:55:47+00:00

John

No Feedback Given

BI Elite Training
5
2020-05-21T16:56:40+00:00

No Feedback Given

Sanju

BI Elite Training
5
2020-05-21T16:57:12+00:00

Sanju

No Feedback Given

Chaitanya

BI Elite Training
5
2020-05-21T16:57:48+00:00

Chaitanya

I am more than amazed

Kudos for the great work and I am more than amazed of what great teachings you will share next! Keep it up!

Juan

BI Elite Training
5
2020-05-21T16:59:37+00:00

Juan

Kudos for the great work and I am more than amazed of what great teachings you will share next! Keep it up!

Up to date, easy to follow along

Great course! up to date, easy to follow along and educational.

Stephen

BI Elite Training
5
2020-05-21T17:00:26+00:00

Stephen

Great course! up to date, easy to follow along and educational.

AWESOME

AWESOME

Richie

BI Elite Training
5
2020-05-21T17:01:59+00:00

Richie

AWESOME

Very good course!

Very good course!

Tomasz

BI Elite Training
5
2020-05-21T17:02:35+00:00

Tomasz

Very good course!

Fantastic Course

Fantastic Course

Anjan

BI Elite Training
5
2020-05-21T17:03:04+00:00

Anjan

Fantastic Course

Fun and useful

Fun and useful
BI Elite Training
5
2020-05-21T17:03:27+00:00
Fun and useful

Good introduction to Power BI

Good introduction to Power BI Desktop and Power BI com.

Vijay

BI Elite Training
5
2020-05-21T17:04:13+00:00

Vijay

Good introduction to Power BI Desktop and Power BI com.

Very well constructed course

"Very well constructed course that takes you through the fundamentals of power bi
Now i am looking forward to the second part of the power bi track 👍
Thank you Parker for a job well done"
BI Elite Training
5
2020-05-21T17:04:44+00:00
"Very well constructed course that takes you through the fundamentals of power bi Now i am looking forward to the second part of the power bi track 👍 Thank you Parker for a job well done"

Very useful and very well put together

This was excellent - very useful and very well put together.

Ashley

BI Elite Training
5
2020-05-21T17:05:49+00:00

Ashley

This was excellent - very useful and very well put together.

It’s really awesome

It's really awesome !! thank you i finally got to publish my first report

Hossam

BI Elite Training
5
2020-05-21T17:06:39+00:00

Hossam

It's really awesome !! thank you i finally got to publish my first report

The course is well-structured, covered all important areas

The course is well-structured, covered all important areas which I can now use to develop further my skills and knowledge.

Oksana

BI Elite Training
5
2020-05-21T17:07:33+00:00

Oksana

The course is well-structured, covered all important areas which I can now use to develop further my skills and knowledge.

The beginners course exceeded my expectations

The beginners course exceeded my expectations. The videos were to the point. The instructor was knowledgeable about Power BI. Really enjoyed the amazing insights he was able to provide on the different reports as well as the DAX expressions that he introduced.

Chintan

BI Elite Training
5
2020-05-21T17:08:12+00:00

Chintan

The beginners course exceeded my expectations. The videos were to the point. The instructor was knowledgeable about Power BI. Really enjoyed the amazing insights he was able to provide on the different reports as well as the DAX expressions that he introduced.
5
26
BI Elite Training