Offer Price at just Rs. 999/- Limited Period Offer
!!!
Offer Price at just Rs. 999/- Limited Period Offer
!!!
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
LIVE SESSION - Get access to Live Seminar + Online Course + Recorded Session at Just Rs. 999/_
Rs.1999/_
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
Register for Free Demo Course
Register
LIVE SESSION - Get access to Live Seminar + Online Course + Recorded Session at Just Rs. 999/_
Rs.1999/_
Address: 102, Panchali Shopping Center, Above Nagrik Stores, Near Ashok Cinema, Thane West
Email : hr@apt-resources.com
Contact us @ 8655040102/ 8355987442
Copyright @ 2020
Digital Marketing Consultant
All rights reserved.