Home >> Courses >> Office Tools >> Top 25 Microsoft Excel Advanced Formulas Hands on Tutorial

Top 25 Microsoft Excel Advanced Formulas Hands on Tutorial

Learn Excel 2013 advanced formulas in this hands-on tutorial. Become an expert and show your skills!

3.7 (3 ratings) Last Updated:11/2019 English (US) Instructor: Syed Raza

Lectures: 20
|
Videos: 3.5 hours
|
Level: All
|
Language: English
|
Last Updated: 11/2019

Skills: Microsoft Excel

Eduonix Infiniti Subscription Plan

Access this and 2000+ courses for free

Free with Infiniti

Offer Price:

$2.00

Our Price:

$4.00

Original Price:

~~$20.00~~

You Save:

$16.00 (50%)

Free with Infiniti

Ends in:

00D 00H 00M 00S

20 lectures 3.5 hours English

Learn Risk Free

30 day money back guarantee

$4.00 ~~$20.00~~

About this Course

The old 80/20 rule for softwarethat 80% of a program users use only 20% of a program is featuresdoesnot apply to Microsoft Excel. Instead, this program probably operates under what could be called the 95/5 rule: Ninetyfive percent of Excel users use a mere 5% of the program power!

On the other hand, most people know that they could be getting more out of Excel if they could only get a leg up on building formulas and using functions. Unfortunately, this side of Excel appears complex and intimidating to the uninitiated, shrouded as it is in the mysteries of mathematics, finance, and impenetrable spreadsheet jargon.

Here is the good news!

I have designed this practical course to give you the ability to master the Top 25 Microsoft Excel formulas with real world examples, by demystifying the building of worksheet formulas, and presenting the most useful Excel functions in an accessible and jargonfree manner. In this tutorial, you will be able to learn important functions such as:

Financial
Logical
Text
Lookup & Reference, and many more

I have included few bonus tutorials at the end of the course as well:

Modifying templates and styles
Copying macros between workbooks
Working with external data
Tracking changes in Excel 2013

The entire objective of this course is to dive deep into the Excel 2013 environment with regards to formulas in in order to make you more productive, efficient, and achieve a greater skill set!

To top it off: If you would like me to explain a particular formula of your choice, I would be delighted to create a handson tutorial just for you!

With that said, this course will enhance your comfort level working with advanced formulas in Excel 2013. The concepts learned in this course apply to Excel 2010, and 2016 versions of Microsoft Excel as well. So, enroll now and take your skills to the next level.

Join thousands of happy students!

See you in class!

Syed and Team ClayDesk

Who this course is for:

This tutorial is designed for Excel power users, and for those who are up to the challenge! It is not for students who are beginning to learn Microsoft Excel

People interested in this course also viewed

Course Content

Prerequisites

About the Instructor

Syed Raza

CEO

Courses...

As an Enterprise Architect and Senior Project Manager, and CEO of ClayDesk.com, I specialize in making complex material real easy to follow and understand. ClayDesk is one of the fastest growing and leading provider of cutting edge technology and training solutions. Our on-demand learning division provides latest courses with hands-on tutorials.

Providing technical and training solutions using AWS, Azure, Google Cloud, Red Hat OpenShift, Python, Java, JavaScript, React JS, GCP, Kubernetes, Jenkins, Ansible, and Docker.

Reviews and Ratings

Top Reviews

View More Reviews

Frequently Asked Questions

It is an online tutorial that covers a specific part of a topic in several sections. An Expert teaches the students with theoretical knowledge as well as with practical examples which makes it easy for students to understand.

A Course helps the user understand a specific part of a concept. While a path and E-Degrees are broader aspects and help the user understand more than just a small area of the concept.

A Course will help you understand any particular topic. For instance, if you are a beginner and want to learn about the basics of any topic in a fluent manner within a short period of time, a Course would be best for you to choose.

We have an inbuilt question-answer system to help you with your queries. Our support staff will be answering all your questions regarding the content of the Course.