Coupon & course info
Course Name: Microsoft Excel – Advanced Formulas And Functions
Subtitle: Advanced Microsoft Excel Formulas And Functions – Take Your Excel Skills To The Next Level
Instructor: Taught by Infinite Skills, High Quality Training
Category: Office Productivity
Provided by: Udemy
Price: $24 (before discount)
Free coupon code: See above (no charge for coupon)
Review info & popularity
As of March 19, 2016…
Students: 1919044 students enrolled
Ratings: 28 reviews
Rank: ranked #177 in Udemy Office Productivity Courses
Brief course 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.
(Read more about this course on the official course page.)
Infinite Skills bio
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.
(Learn more about this instructor on the official course page.)
If you like this course, you might also be interested in:
Learn SAP from zero. Main concepts, Navigation and different modules and funcionality that offers.
Taught by Ricardo Naya Arboleya, Freelance Consultant SAP
2. Mac Basics
Learn about your Mac in a fun step-by-step way with a former Applecare Senior Advisor. Your Mac is smart and so are you!
Taught by Mr. Justin Pierce, Instructional Designer, Apple Blogger, IT Specialist
A practical approach to using excel for organizing information, tracking trends over time, and performing calculations.
Taught by Andy Norris, Mechanical Engineer
Become a Powerpoint Guru and transform your presentations by learning the techniques and resources used by the Experts.
Taught by Curious Geek, Professional Instructor
Dominate Google Searches, increase your daily productivity and make your Google ride more effective and enjoyable.
Taught by Hugo Matos, Entrepreneur and Manager
Final details for this Udemy course
Skill level: All Levels
Lectures: 58 lessons
Duration: 5.5 Hours of video
What you get: Take Your Excel Skills To The Next Level
Target audience: Intermediate To Advanced Users
Requirements: Microsoft Excel 2010 or Excel 2013
Access: Lifetime access
Peace of mind: 30 day money back guarantee
Availability: available online, as well as on iOS and Android
Download options: check course to see if you can download lessons