Advanced Excel classes, Training Institute

Get a full course Details

NIDHI Computer Education, one of the leading IT, Computer Education Institutes in Nanded, is run under the great leadership of Mr. Mahendra Sawatkar.

Advanced Excel

What is Excel:
Using excel we can perform calculation, Organise and evaluate quantitative data which allows company senior staffs and manager's to take accurate decisions depending on this Data.

Using excel employee can better present information to the upper managment

Employees - Students can benefit from advanced Excel training in lots of ways, Benifits that you will get after learning Advanced Excel are asin

  • Sharpening Your Skill Set
  • You Wiil be Valuable Member of the Company
  • It will Make Your Job Easier
  • It Allows You to Grow Employee Knowledge

Weather you are Software Enginner / Doctor / Manager / CEO / Clerk in almost every field Excel is being used. so this is compulsary that you should have knwoledge of advanced excel

In Nidhi computer education we provide details training of each and every topic with oractice real time project/sheets, that will boost you confidence while working in any Organization or in any Company

Advanced Excel - Course Content
Module 1
BASIC Microsoft Excel
  • Spreadsheet basics
  • Creating, editing, saving and printing spreadsheets
  • Working with functions & formula
  • Graphically representing data : Charts & Graphs
  • Securing Worksheet and Data
Module 2
Formulas & Macros Formulas
  • Use the Function Wizard, Common functions
  • (AVERAGE, MIN, MAX, COUNT, COUNTA, ROUND, INT)
  • Nested functions , Name cells /ranges /constants
  • Relative, Absolute, Mixed cell references : >,<,= operators
  • Logical functions using IF, AND, OR, NOT
  • The LOOKUP function , Date and time functions , Annotating formulas
Module 3
DATA Analysis
  • Sub Total Reports, Auto Filter
  • Password Protecting Worksheets
  • Linking Multiple Sheets
  • Sheet Referencing
  • Linking Between Word/Excel/Ppt
Module 4
Functions : LOOKUP, VLOOKUP, HLOOKUP, COUNTIF, SUMIF , Index
  • What-if-analysis
  • NESTED IF
  • GOAL SEEK
  • Reporting
  • Character Functions
  • Date Functions
  • Data Validation
  • Consolidation of Data
  • Index
Module 5
Pivot tables & charts
  • PivotTables
  • Use Pivot Charts
Module 6
MACRO’S
  • Macros
  • Definition and use, Record a macro

What Students Are Saying

You can be also the part of the family

...
Anita Sontakke

Tally

"I am not from accounting background but after joining NCE , i learned basic to advance accounting concepts with Tally.

I highly recommend this Institute for anyone who wants to learn Tally."

...
Vaishnav Deshmukh

Java

"I joined NCE for my academic preparations. I learned all core concepts of Java Programming.

NCE will surely help you to be an expert in programming. "

...
Abhinandan

C/Python

"Mahendra Sir is a great teacher... In just one month, I learned all basic programming concepts.This institute is great for anyone who wants to be in Software Development, I highly recommend it."

...
Sachin Kondle

DTP

Thank you mahendra sir for teaching me DTP in very easy way.

Get a full course Details

NIDHI Computer Education, one of the leading IT, Computer Education Institutes in Nanded, is run under the great leadership of Mr. Mahendra Sawatkar.

Contact Us