The course will be 1 hour daily course. The course will include following content. The content may be added or removed based on requirement.

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