Advanced Excel Course

Advanced Excel Course Near Me
0 student

Course Overview

Free Demo Download Brochure

    Request For Free Demo

      BASIC Microsoft Excel:

      • Spreadsheet basics
      • 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

      •  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
      Curriculum is empty

      0.00 average based on 0 ratings

      5 Star
      0%
      4 Star
      0%
      3 Star
      0%
      2 Star
      0%
      1 Star
      0%