MS Excel Essentials-Formulas & Functions

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.

Please Login.. 50
10 Student's Enrolled
Best Selling

Write to us for more information

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

Hours

Start Date

Self paced

Course Provider:

APG Learning

Rs.600.00 Rs.1,000.00

Enroll Now Save to Wishlist

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

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.