Microsoft Excel - Advanced Formulas And Functions

Advanced Microsoft Excel Formulas And Functions - Take Your Excel Skills To The Next Level

4.15 (247 reviews)
Udemy
platform
English
language
Microsoft
category
instructor
Microsoft Excel - Advanced Formulas And Functions
2,744
students
5.5 hours
content
Jan 2017
last update
$44.99
regular price

What you will learn

Take Your Excel Skills To The Next Level

Description

This Microsoft Excel Advanced Formulas and Functions training course from Infinite Skills takes you beyond the basics of Excel, and teaches you how to use the advanced formulas and functions in this spreadsheet program by Microsoft. This course is designed for users that already have a basic working knowledge of Excel.


You will begin by reviewing the basic operations, such as sum and count syntax, function processing order, and knowing the troubleshooting tools. You will explore extended formula usage with 3D referencing, naming cells and absolute referencing. Guy proceeds to instruct you on how to look up and reference type functions using VLookup and HLookup. Other features that are covered in this computer based training include; generating random numbers and values, locating data using text functions, and learning to use an array formula to count unique entries.

By the completion of this training course, you will be comfortable with using many of the advanced formulas and functions that this powerful spreadsheet software from Microsoft offers. Working files are included, allowing you to follow along with the author throughout the lessons.

Content

Welcome

Important - Excel - Working Files - Download These First
0101 How Advanced Is Advanced?
0102 Using The Excel Working Files
0103 When Is A Formula A Function?

Getting The Basics Right

0201 Excel - Sum And Count Syntax
0202 Accessing Unknown Function Syntax Within Excel
0203 Referencing Entire Rows/Columns
0204 Excel - Function Processing Order
0205 Convert Formulas To Values In A Split Second

Extend Your Formula Usage

0301 Naming Cells To Improve Formula Appearance
0302 Excel - 3D Referencing
0303 Full Absolute Referencing
0304 Making Only Part Absolute Formula

If And If Type Functions

0401 The If Logical Test
0402 Nested If Statements
0403 Using The And, Or, And Not Functions Within If
0404 CountIf, SumIf, And AverageIf
0405 Multiple Criteria With CountIfs, SumIfs, And AverageIfs

Lookup And Reference Type Functions

0501 Looking Up Information With VLookup
0502 Excel - HLookup
0503 Nearest Match With VLookup
0504 Nested Lookup Functions
0505 Choose And Match Functions For Locating Data
0506 Index And Match Functions For Retrieving Data

Mathematical Functions

0601 Varying Rounding Functions
0602 MRound, Ceiling, And Floor For Rounding Also
0603 Int And Mod For Integer And Remainder Values
0604 Generating Random Numbers And Values In Excel
0605 Password Generating Workbooks
0606 Display Different Number Types With Roman And Arabic

Statistics

0701 The Middle Value With Median
0702 Ranking Data Without Sorting
0703 Large And Small For Retrieving Biggest And Smallest Values
0704 A Choice Of Count Functions

Text Functions

0801 Extracting Data With Left, Right And Mid
0802 Locating Data With Find, Search, Exact
0803 Use Trim And Clean To Remove Unwanted Gaps
0804 Combine Data From Different Cells
0805 Changing The Case Of Text Using Proper, Upper, And Lower
0806 Replace And Substitute In Action
0807 Format Number Content Within Strings With Text

Date And Time Functions

0901 Using Today And Now Functions
0902 How Does Excel Deal With Dates And Time
0903 What Day Of The Week Is It?
0904 Difference Between Network Days And Work Day
0905 DatedIf For Time Differences
0906 EDate And EOMonth
0907 DateValue And TimeValue Functions

Information And Referencing Functions

1001 Extracting Information With Cell And Info Functions
1002 Using IsBlank, IsOdd, IsEven, IsText, And IsNumber
1003 IsErr, IsError, IfError, IsNA, And IfNA For Error Checking
1004 The New IsFormula Function And FormulaText
1005 Use Offset To Obtain Data From Related Cells
1006 InDirect And Its Uses

Array Formulas And Functions

1101 What Is An Array Formula?
1102 Use An Array Formula To Count Unique Entries
1103 Flipping Rows Or Columns With Transpose

Conclusion

1201 Excel - Advanced Formula Summary

Reviews

Janet
September 28, 2023
I would add some practice exercises into each section to let them get hands-on experience during without having to come up with ways to test and use their knowledge on their own.
Claire
September 26, 2023
I am really enjoying this so far, I have already picked up some tips and tricks that will help me daily.
Sylvia
December 1, 2022
Excellent course! The instructor explains all formats so concisely. I purchased another course from a different instructor, and I had a lot of difficulty understanding the format and concept and had to go to YouTube to look it up. The same formats this instructor taught - I got it right away! Highly recommend!
Talat
August 21, 2016
very basic level but detailed introduction. it will help build strong foundation but anyone who looses interest at this stage would rate this course as mid / average
Paul
July 1, 2016
This tutorial is very well prepared. He is articulate, the pace is perfect and the material presented is structured well. He is also easy to follow and the examples chosen do actually have real-world applications. Thanks chap!
Kieran
May 16, 2016
This is a good course and every one will learn something. What more do you need to know ! If you want to put a value on knowledge, Udemy courses are generally very good value you just need to select the course that is right for your knowledge level. This is course is up there with the best of them.
Naveed
May 15, 2016
I consider myself to be an advanced Excel user and found the material including the basics to be thorough, concise and great as a refresher. None of the sections were verbose at all and communication was very clean. I did not find it difficult and believe even for a novice to intermediate, the lecturer would succeed in teaching, especially with the Excel files that are included as course material. There were many areas/tools of Excel that I was unaware of so very happy for the exposure.
Betty
March 28, 2016
It's early in the course, but what I've seen so far is very basic formulas. If you're looking for advanced, hopefully you will just have to be patient and they'll get more involved further into the course. The instructor is very easy to listen to, goes at a steady pace and is thorough in explanation.
Kelly
January 8, 2016
Very informative and useful. I wouldn't hesitate to take any of this instructor's courses. I have learned so much!
Bob
September 19, 2015
I don't use Excel everyday at work, but I want my Excel skills to remain strong. So, I scour the Internet looking for inexpensive or free Excel courses that systematically cover basic, intermediate, and advanced techniques. I try to do something in Excel every day. This course is great for that purpose. It provided a great review and I also picked up a few very helpful tricks.
Boon
September 13, 2015
Like few courses lectured by Guy, this one also has a lot of practical examples. Moreover, the content is informative and comprehensive.
Adriel
September 9, 2015
The videos are very clear and concise and the presenter has an excellent way of speech. Highly recommended.
Davis
June 29, 2015
A great way to learn the syntax and application of those pesky formulas, lots of real-world tips and tricks....
Scott
September 2, 2014
Clearly laid out course - complexity is built upon each lesson. I took another by Infinite skills - they are FAR superior to some of the other courses I've signed up for. Great instructor. I have used so many of the advanced functions at work now. Super helpful!
John
November 6, 2013
Guy Vaccaro is perhaps the most knowledgible presenter of Microsoft Excel, I have enjoyed each of the course that I have undertaken and he was the presenter. This course has helped me to gain further knowledge of the many functions available in Excel.

Charts

Price

Microsoft Excel - Advanced Formulas And Functions  - Price chart

Rating

Microsoft Excel - Advanced Formulas And Functions  - Ratings chart

Enrollment distribution

Microsoft Excel - Advanced Formulas And Functions  - Distribution chart
94268
udemy ID
9/18/2013
course created date
8/26/2021
course indexed date
Bot
course submited by