Embedded Files
The world of business thrives on MS Excel. There are estimated 750 million users worldwide and Satya Nadella proclaims it as Microsoft's most important consumer product. It is being used by businesses across all Industry verticals. However, despite its popularity, a large percentage of Excel users are unaware of its true potential, often, failing to get the most out of this superbly powerful tool.
We are here to make sure it doesn’t happen to you.
In this training program, you'll be introduced to Advanced Excel Formulas & Functions which is surely going to increase your productivity 3X.
Lookup & Reference | Logical | Text | Date/ Time | Statistical | Information
Classroom Session + Practical Session with Challenges in Tap-DC's Certiport Authorized Computer Lab.
COURSE CONTENT
- Understand the concept of Relative/ Absolute/ Mixed References
- Using Simple IF, Compound IF, Nested If, Ifs function; Using AND/OR Functions
- Using the SUMIF, AVERAGEIF, and COUNTIF Functions
- Understand why Lookup is preferred over IF
- Using the LOOKUP/ VLOOKUP/ HLOOKUP Functions
- Using the CONCATENATE Function, TRANSPOSE Function, PROPER, UPPER, and LOWER Functions, TRIM Function, LEFT, RIGHT, and MID Functions
- Using Date Functions - DAY, DAYS, NETWORKDAYS, NOW, TODAY Functions, etc.
- Nested Formulas: Vlookup + Match + Index, If + And + Or
- How to create Lists in Excel
- Introduction to Name Manager: Using OFFSET function
- Excel Shortcuts, Tips & Tricks will be introduced
FACULTY - Best of Business Coaches
FACULTY - Best of Business Coaches
CHARU SMITA – PRODUCTIVITY COACH
I’m Charu. Founder CEO of Technology and Personality – Development Center (Tap-DC), which addresses the growing Skill Enhancement/ Skill Development needs of the Corporates/ Industries & Institutions.
I have over 16 years of experience designing & delivering solutions for Fortune 500 clients globally. I’m passionate about Data, Analytics, Information & Visualization. My constant endeavor is to train & engage professionals globally in Tools that justify the importance of Data & Information; Excel being one of the basic & the best.
Over the years of Advanced Excel & Office 365 trainings, I have trained thousands of corporate professionals (Business Owners (CXOs)/ Sales Team/ HR Team/ Marketing/ Finance & Accounts/ IT professionals) & have empowered them to increase their work productivity 5X and drastically reduce the time spent on excel operations.
PROGRAM FEES - AN INVESTMENT FOR YOUR GROWTH
PROGRAM FEES - AN INVESTMENT FOR YOUR GROWTH
- All half Day training programs are charged at 1000/- (Including 18% GST) and Full Day training programs are charged 2000/- (Including 18% GST)
- Training Manual, Certificate of Training Completion, Stationery is included.
- High Tea will be served in half day programs & Morning/Evening High Tea & Lunch will be served in all full day training programs.
GLIMPSES OF OUR TRAINING PROGRAMS
GLIMPSES OF OUR TRAINING PROGRAMS
VENUE
VENUE
ADDRESS:
I-18, 3RD FLOOR,
DLF INDUSTRIAL AREA,
PHASE-1, SECTOR - 32,
FARIDABAD - 121002
(4 mins walking distance from NHPC Metro Station)
Report abuse