
Register for interview

ms excel essentials-formulas & functions

Course Detail
Format:
Full Time
Duration:
1 Year
Accreditation:
TISS SVE
Course Provider:
APG Learning
Start Date:
01 August 2019
Fees:
₹1,75,000/-
Duration
Self-Placed
Modules
4
Hours
4
Start Date
Self paced
Course Provider:
APG Learning
Rs.600.00 Rs.1,000.00
Address:Sakal Nagar,
Gate No. 1, Baner Road,
Aundh, Pune 411 007
Training 5 or more people?
Get your team access to APG Learning top 200+ courses anytime, anywhere.
Try APG Learning for Business
About Course
In this course you will learn all the tips, tricks, shortcuts, functions and formulas you need to be an Excel power user. Learn dynamic formulas with IF, VLOOKUP, INDEX, MATCH functions and many more.
Modules
Module 1
- Introduction: Excel Formulas
- Excel Formula Syntax
- Writing Efficient Formulas with Fixed & Relative References.
- Basic Excel formulas
- Common Excel Error Types
- Navigating Excel Worksheets with Ctrl Shortcuts
- Saving Time with Function Shortcuts
- Accessing Tools with Alt Key Tips
- Creating Drop-Down Menus with Data Validation
- Conditional formatting
Module 2
- Lookup and Reference Functions: VLOOKUP, HLOOKUP, INDEX, ADDRESS, MATCH, TRANSPOSE
- Logical Function: IF / ELSE, AND, OR, NOT, TRUE, NESTED IF/ELSE etc.
Module 3
- Text Functions: LEFT, RIGHT, TEXT, TRIM, MID, LOWER, UPPER, PROPER, REPLACE, REPT, FIND, SEARCH, SUBSTITUTE, TRIM, TRUNC, CONVERT, CONCATENATE, DOLLAR EXACT ,CONCATENATE
- Date Function : DATE,DATED IF,DATE VALUE,DAY,DAYS 360,EDATE,EMONTH,HOUR,MINUTE,MONTH;NETWORKDAY S,NOW,TIME, TIME VALUE,SECOND,TODAY,WEEK DAY,WORK DAY,YEAR,YEAR FRAC
Module 4
- Math and Trigonometry Functions: RAND, ROUND, CEILING, FLOOR, INT, LCM, MOD, EVEN, SUMIF, UMIFS, ABS, CEILING, COUNTIF, EVEN,FACT,FLOOR,GCD,INT,LCM,MOD,MROUND,ODD,PI,PRODUC T,POWER,QUTIENT,RAND,ROMAN,ROUND,ROUND DOWN,ROUND UP,SIGN ,SUBTOTAL.
- Formatting Excel sheets.
Learning Outcomes
- Participants will learn ms- excel from scratch.
- 3 months full access to this course and study material to practice it to perfection.
Who Should Attend
Anyone who wants to learn MS-Excel
Certificate
Digital Certificate will be issued after completion of the course
SIMILAR COURSES
Financial Analyst Program
Course Provider - APG Learning
Self paced
BUSINESS COMMUNICATION AND BUSINESS WRITING
Course Provider - APG Learning
Self paced
1
MPSC CSAT (Civil Services Aptitude Test) Prelim Preparation
Course Provider - APG Learning
Self paced
Digital Marketing Advanced Program
Course Provider - APG Learning
Self paced
MS Excel Essentials-Formulas & Functions
Course Provider - APG Learning
Self paced
50
Certificate Course in Business Accounting and Taxation
Course Provider - APG Learning
Self paced
1550
Competency Mapping – Harvard certification
Course Provider - APG Learning
Self paced
700
Import-Export Management
Course Provider - APG learning
Self paced
409

Contact us for Course
