Advanced Excel

slider image

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.

Payonline-btn

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

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

  • Relative, Absolute, Mixed cell references : >,<,= operators

  • 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 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:
Formulas & Macros Formulas:

  • 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

It's only fair to share...Share on Google+Pin on PinterestTweet about this on TwitterShare on Facebook