Microsoft Excel - Advanced Formulas And Functions
- 0.0
-
![]()
![]()
![]()
![]()
![]()
Brief Introduction
Advanced Microsoft Excel Formulas And Functions - Take Your Excel Skills To The Next LevelDescription
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.
Requirements
- Requirements
- Microsoft Excel 2010 or Excel 2013
- Windows
Learn Financial Modelling in MS Excel
- 4
-
![]()
![]()
![]()
![]()
![]()
Prepare How to Prepare Financial Models in MS Excel - Beginners to Advanced OVERVIEW Financial Modeling is an essential skill for accounting and finance professional....
MS Excel For Beginners: Fast Track Training
- 0.0
-
![]()
![]()
![]()
![]()
![]()
Learn how to master MS Excel methods quickly and easily for yourself or business MS Excel For Beginners: Fast Track Training:...
Microsoft Excel Beginner & Intermediate Training w/ Projects
- 0.0
-
![]()
![]()
![]()
![]()
![]()
A Beginners and Intermediate Guide to Using Microsoft Excel in the Real World Course Highlights: 80+ Individual, Bite-Sized Lessons 9 Real-World Mini-Projects...
Analyze Data to Answer Questions
- 4.6
-
![]()
![]()
![]()
![]()
![]()
This is the fifth course in the Google Data Analytics Certificate. These courses will equip you with the skills needed to apply to introductory-level data analyst jobs....
