Advanced Features of Ms-Excel. Advanced Excel course also enables the student and working professional to utilize, the advanced features taught in this course in an office environment with maximum efficiency.
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