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 & formulaeFormatting 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
Duration – 1.5 Months