Excel Array Formulas - Capsule Training
Are you struggling and spending too much time on creating Excel Array Formulas? Or you don't have enough Array skills as your friends and colleagues have?
Then, I invite you to my Capsule Training on Excel Array Formulas where you are going to learn to work on Excel Arrays that you never did before.
Knowing Excel array formulas will transform you to Excel Guru in your office and I'll do my best to make this painless, but you might need to get a capsule. 💊💊
Gone are the days that you were impressed with Excel's ability to return the result from a simple SUM function! By now you are probably ready to face the challenge of being able to get virtually any result from any data, and so you should be! In this training we will teach you how you can easily write those mega formulas that you have seen elsewhere.
As with all our training we are not satisfied with simply showing' advanced array formulas, we will also teach you how to understand them. By taking this approach you will be armed with the knowledge and confidence to tackle almost any array formula problem.
The topics that we are going to cover in this training are:
💡 Introduction to Array
💡 Array Basics
💡 Why Arrays?
💡 When to use Array?
💡 The Power of Array Formulas
💡 Array and Range?
💡 Types of Arrays
💡 Creating Array Constant
💡 Array name management
💡 Using Intersect and Union Methods?
💡 Working with Logic gates - OR, NOT, NAND, NOR
💡 The Truth Table
💡 The CSE Method
💡 IF with Arrays
💡 Working with Conditional Logic
💡 Building Array Algorithm
💡 Basic examples of Array Formulas
💡 Replacing current Functions with ARRAY
💡 Creating Array Series with ROW, COLUMN Function
💡 Array Formula Lookup Example
💡 Array with Wildcards
💡 Array with Dates
💡 Array with Series of Instructions
💡 Array Formula Complex Example
💡 The SUMPRODUCT and its array capabilities
💡 Array with Data Validation
💡 Working with complex Array Formulas
💡 Challenges in Array Formula
💡 Working with Dynamic Arrays (NEW)
By the end of the session, you will be more confident on Array Formulas. Capsule training is designed to give you in-depth knowledge of topics. As the name.. So its effect.
As it is a certification course, therefore participants will get the Course Completion Certificate (Soft Copy) after the training.
My brief profile:
An MCA Professional and a Microsoft Certified Microsoft Office Specialist working as a Chief Mentor and currently heading Future in Hands. I worked with the Top corporates like Mphasis, Motherson Group with 15+ years of industry exposure. I have received several Best Trainer Awards from corporates for Microsoft Office based workshops. I facilitated 98000+ professionals from 500+ companies like Taj Group, ICAI, British Council, BSI, NIIT, IndiaMart, MetLife, Mahindra and lots more from Executive level to Sr. Management. Learners says my sessions are like magic shows.
You can also refer to my LinkedIn profile.
So, if you are serious about being a master in Excel, then you should not miss this capsule training. Eventually, your BOSS will become your FAN.
In case of any queries, please contact me @ +918744007662.
See you at the training!