Advanced Excel EDGE

Prerequisites

The course is suitable for individuals with a basic understanding of Excel concepts. However, prior knowledge of Excel is recommended.

Course Outline

Week 1-2: Formatting Sheets and Cells

. Introduction to Formatting Sheets and Cells
. Formatting Cells
. Using Conditional Formatting
. Custom Formatting

Week 3-4: Views and Control the Display and Print Settings

. Introduction to Views and Control the Display and Print Settings
. Custom Views
. Page Setup
. Print Settings

Week 5-6: Text and Conditional Function

. Introduction to Text and Conditional Function
. Common Text Function
. Combining and Nesting Function
. Conditional Function

Week 7-8: LOOKUP, VLOOKUP, and HLOOKUP

. Introduction to LOOKUP, VLOOKUP, and HLOOKUP
. LOOKUP Function
. VLOOKUP Function
. HLOOKUP Function

Week 9-10: WHAT-IF Analysis and Data Tables

. Introduction to WHAT-IF Analysis and Data Tables
. Creating and Editing Scenarios
. Data Tables
. Report Creation

Week 11-12: Goal Seek and Solver, Outlines and Subtotals

. Introduction to Goal Seek and Solver
. Goal Seek
. Solver
. Outlines and Subtotals

Week 13-14: Macros and VBA

. Introduction to Macros and VBA
. Creating Macros
. Editing Macros
. VBA Programming
.

Week 15-16: Analyzing Data with Pivot Tables

. Introduction to Pivot Tables
. Creating Pivot Tables
. Defining Source Range
. Grouping and Ungrouping Fields

Week 17-18: Formatting and Refreshing Pivot Tables, Projects

. Formatting Pivot Tables
. Refreshing Pivot Tables
. Projects

Week 19-20: Custom Application

. Introduction to Custom Application
. Creating Custom Applications
. Editing Custom Applications
. VBA Programming for Custom Applications