logo
Avail of 10% to 20% Scholarship on All Our Courses. ANIMATION, WEB DESIGNING, GRAPHIC DESIGNING, ARCHITECTURAL DESIGNING, VFX, FILM & VIDEO EDITING, ACCOUNT & FINANCE, TALLY, HARDWARE & NETWORKING, PHP, JQUERY, MYSQL, C C++, JAVA, .NET

Advance Excel

Advanced Excel Applications


Course Content
Fundamental :
  • Creating, editing, saving and printing spreadsheets
  • Working with functions & formulae
  • Graphically representing data : Charts & Graphs
  • Analyzing data : Data Menu, Subtotal, Filtering Data
  • Formatting worksheets , Securing & Protecting spreadsheets
    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
  • 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 Programming
    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:
  • harts , Enhance charts, Drawing toolbar features


  • Request
    Info