GAIT ICTL, The Best Training Center for Skill based learning in INDIA

Advance Excel

Corporate Training on Advanced Excel Course


Course Contents: Ms-Excel & Advanced Excel
Course Benefit: You will learn how to Use Advance Features of Excel with 35+ LIVE PROJECTS. This is the course that will bring you up to speed with all the essential MS-Excel functions that one must know as a business user.
Fees: Rs: 4000 /- [Corporate Discount Applicable, depending on number of students]
Duration: 1 Months or 30 hour
We undertake Individual & Group & Individual Training in our Institute

Topics Covered
Advance Features of Ms-Excel. Advanced Excel course also enables the student to utilize, the advance features taught in this course in an office environment with maximum efficiency.


BASIC Microsoft Excel:

  • Spreadsheet basics
  • Creating, editing, saving and printing spreadsheets
  • Working with functions & formulas
  • Graphically representing data : Charts & Graphs
  • Analyzing data : Data Menu, Subtotal, Filtering Data
  • Formatting worksheets , Securing & Protecting spreadsheets

ADVANCED Excel Contents:

  • 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

DATA Analysis:

  • Sub Total Reports, Auto Filter
  • Password Protecting Worksheets
  • Linking Multiple Sheets
  • Sheet Referencing
  • Linking Between Word/Excel/Ppt
  • Functions:- LOOKUP, VLOOKUP, HLOOKUP,  COUNTIF, SUMIF
  • What-if-analysis, GOAL SEEK, Scenarios & Tables
  • PIVOT Tables, NESTED IF
  • Reporting
  • Character Functions
  • Date Functions
  • Age Calculations
  • Consolidation of Data
  • Data Validation
  • MACRO’S

Macros:

  • Definition and use , Record a macro
  • Assign a macro , Run a macro
  • Store a macro, Introduction to VBA Prog.

Develop the Worksheet:

  • Plan a worksheet , Row and Column labels
  • Split worksheet /box /bar, Copy data and formulas
  • Display /move toolbars , Enhance worksheet Appearance

Special Operations:

  • Use multiple windows : Copy/ paste between Worksheets
  • Link worksheets , Consolidate worksheets
  • Import and link from other Applications
  • Use AutoFormat : Create, use and modify styles and templates
  • Print features : Create /edit an outline

Graphic Operations:

  • Create charts , Enhance charts, Drawing toolbar features

Advances Excel Techniques