Microsoft Excel - Advanced Formulas And Functions (Udemy.com)
Advanced Microsoft Excel Formulas And Functions - Take Your Excel Skills To The Next Level
Created by: Infinite Skills
Last updated January 2017
What you will learn
- Take Your Excel Skills To The Next Level
How it compares
Against the other 355 rated Udemy courses in Excel on CourseDuck:
- Rating4.5 out of 5higher than 39% of them
- Reviews263#276 of 356 by number of reviews
- Length5.6 hoursshorter than 49% of them
- Last updatedJanuary 2017earlier than 90% of them
Course Description
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. Who this course is for:
- Intermediate To Advanced Users
Instructor Details
- 4.5 Rating
263 Reviews
Infinite Skills
Infinite Skills is a Canadian based company who offer a huge and ever growing range of high quality eLearning solutions that teach using studio quality narrated videos backed-up with practical hands-on examples and comprehensive working files. All courses are created by trained educators and experts in video based education.
The emphasis is on teaching real life skills that are essential for progressing in today's commercial environment.
More courses by Infinite Skills
Learning Windows PowerShell (2017)
4.4 (6,500 Reviews)
Provider: Udemy
Time: 5.1h
$19.99
Original priceMicrosoft Excel 2013 Advanced. Online Excel Training Course
4.6 (3,848 Reviews)
Provider: Udemy
Time: 9.9h
$15.99
Original priceMaster SketchUp - A Definitive Guide From Infinite Skills (2017)
4.5 (3,824 Reviews)
Provider: Udemy
Time: 5.4h
$22.99
Original priceAdobe InDesign Made Easy. A Beginners Guide To InDesign (2017)
4.5 (3,719 Reviews)
Provider: Udemy
Time: 11h
Free
Microsoft SQL Server 2012 Certification Training Exam 70-461
4.7 (3,538 Reviews)
Provider: Udemy
Time: 12.3h
$11.99
Original price
Reviews
The lesson is well done in the sense of not too fast, not too slow and not too elementary. Well done.
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.
Quality Score
Overall Score : 90 / 100









