Advanced Excel

Duration – 1.5 Months

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  Working with functions & formulae Formatting worksheets , Securing & Protecting spreadsheets

ADVANCED Excel Course 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
 NESTED IF
 Reporting
 Character Functions
 Date Functions
 Age Calculations
 Consolidation of Data
 Data Validation

PIVOT TABLES :

 Enter the Pivot Table Data
 Create the Pivot Table
 Adding Data to the Pivot Table
 Filtering the Pivot Table Data
 Change the Pivot Table Data
 Analyze Data Columns in Pivot Tables
 Adjust Data to Analyze

MACRO’S ( Int ) :

 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