MS Excel Essentials-Formulas & Functions - APG Learning
nav-closed

Register for interview

ms excel essentials-formulas & functions

Write to us for more information

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..review_star 50
  • student_enrolled 10 Student's Enrolled
  • best_selling 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

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

nav-closed

Download Brochure