ADVANCE EXCEL TRAINING
Usefull for Entreprenuer and HR Professional
Learn excel concepts and forumla whcih are used in HR and day to day work for business.
ADVANCE EXCEL TRAINING
Usefull for Entreprenuer and HR Professional
Learn excel concepts and forumla whcih are used in HR and day to day work for business.
Detailed Content of Advance Excel Seminar
Introduction to excel and features
- Excel Introduction
- Cell Formatting
- Format Cell
- Custom List
- Conditional Formatting with Formula
- Fill Option
- Justify Data
- Protect Sheet/ Cell/ Workbook
- Calculation of Pension
- Font, alignment, table making, spell check, line removal
All Countable Functions
- count
- Counta
- Countblank
- Countif
- Countifs
- istext
- Today
- Now
Commonly used formula Formula
- SUMIF
- SUMIFS
- AVERAGE IF
- DSUM Formula
- Daverage
- Dget
- Match & Index
- Lookup
- Hlookup
- Pivot Table
- Query
- Vlookup with 7 Examples
- Mail Merge Excel data go into word
- Data Merge Jan to december in one sheet
Basic Formula
- Upper
- Lower
- LEN
- TRIM
- Concatenate Function
- Text to Column
- Hyperlink
- LEFT/RIGHT/MID FUNCTION
- Flash Fill
- SUM Formulas
- Average Formulas
- Min/ Max Formula
- SUM Product
- Conditional formatting
Logical Functions
- IF Function
- IF & "AND" Function
- IF AND & OR Function
Charts
- Charts
- Secondary Axis Chart etc…
Exam and Certificate (ISO 9001:2015)
- Online Exam and Certificate thereafter
Who Will Buy
HR Professional
Entreprenuers
Benefits
-
​Making You Better at Organizing Data.
-
​Career enhancement
-
​Get Mail & Telephonic support
-
​Use Excel to Grow a Business
-
​ Handle Small and Big Data Better with Excel
-
​ Assignment & Certificate
