COURSE CONTENT FOR ADV XL

• Introduction
• Overview: A hands-on introduction

• Lesson 1: Whatâ??s changed, and why
• Lesson 2: Get to work in Excel
• Lesson 3: A new file format
• Excel Options
• Exercise & Test
• Create your first workbook
• Overview: Where to begin?
• Lesson 1: Introduction to workbook
• Lesson 2: Enter data
• Lesson 3: Edit data and revise worksheets
• Lesson 4: Paste Special commands
• Lesson 5: Page layout commands
• Lesson 5: Workbook views
• Graphical Representation of Data
• Overview: Charts make data visual
• Lesson 1: Create a basic chart
• Lesson 2: Customize / Formatting charts
• Lesson 3: Inserting Word Art, Links, Picture Clip & Smart Arts
• Smart Art Graphics
• Design & Format
• Sort & Filter Commands
• Sorting & Filter
• Advanced Sorting & Filter Options
• Customization of Sorting & Filter

• Visual Analysis : Conditional Formatting
• Creating rules
• Managing the rules
• Working with pre-set conditions
• Get started with PivotTable Reports
• Overview: Make sense out of data
• Lesson 1: Make your data work for you
• Lesson 2: Generating report
• Mathematical / Statistical Functions
• Lesson 1: Get started
• Lesson 2: Use cell references
• Lesson 3: Formula Auditing
• Lesson 3: Simplify formulas by using functions
• Lesson 4: Logical Functions (only main commands will be discussed)
• Lesson 5: Lookup & Reference Commands (only main commands will be discussed)
• Working with Data Tools
• Text to Columns
• Consolidate
• What if Analysis (Goal Seek, Scenario Manager & Data Table)
• Data Validation
• Mathematical Functions
• Lesson 1: Get started
• Lesson 2: Use cell references
• Lesson 3: Simplify formulas by using functions
• Work Book Protection
• Lesson 1: Locking / unlocking data Cells
• Lesson 2: Worksheet Protection
• Introduction to Macros
• What is Macro?
• Recording a Macro
• Viewing and Editing Macro

Case study: Covers the above topic