4 Weeks Advanced Microsoft Excel training is a 4 weeks long Instructor-led and guided training with Practical Hands-On Lab exercises to be taught over 16 hours, 2 sessions per week, 2 hours per session.
1. Basic Excel
• Introduction
• Basic Calculations
• Microsoft Office Button
• Using worksheets effectively
• Formatting text and numbers
• Saving Excel 2007 files
• Saving an Excel file as a PDF file
• Inbuilt Functions
• Sort Function
• More on sort data
• Formatting data as tables
• Absolute and relative cell reference
• Page layout and print preview
• Printing: display grid lines
• Conditional Formatting
• Charts
• Text to columns
• Auto-filter
2. Intermediate Excel
• Library functions use
• How to avoid auto hyperlinks
• Fill data across worksheets
• How to use comments
• How to remove duplicates
• Template based workbook
• Themes and smartart diagrams
• ‘IF’ function
• Countif
• Nested IF functions
• Advanced filter
• Named ranges
• Subtotals
• Formatting in-cell graphs(conditional format)
• Data validation
• Custom Data Validation
3. Advanced Excel
• Pivot Tables
• Vlookup/Hlookup
• Absolute range calculations
• Goal Seek
• Get external data – text files
• Import data from databases
• Import data from an Excel file
• Array Formulas
• Calculations in Word
• Data tables and sensitivity analysis
• Printing: Repeat specific rows
• Excel Help – Vlookup