Excel E2E Bootcamp
Course Description
Learn Excel from the most trusted and preferred training partner in the Philippines – ADVANCED LEARNING PROGRAMS!
This one-week training course will cover Basic, Intermediate, Advanced, and Macros & VBA.
Basic Excel Training will help the participants understand the different commands and functions available in Excel. The Intermediate Excel Training will focus on discussing how to manipulate multiple worksheets, use 3D formulas, define named ranges, discuss tables, and discuss pivot tables & charts.
Advanced Excel Training will concentrate on the different logical functions, lookup formulas, data validation, and database commands. The last part, Excel Macros & VBA, will show you how to create your procedures, functions, events, and forms for better manipulation.
Day 1 – Basic(AM) /Intermediate (PM)
Day 2 – Intermediate (AM) /Advanced (PM)
Day 3 – Advanced (AM/PM)
Day 4 and Day 5 – Macros and VBA (AM/PM)
Course Objectives
Basic:
- Familiarize yourself with the Excel Interface
- Discuss Worksheets, Workbooks, Cells, Rows, and Columns
- Learn how to Save, Close and Open Worksheets
- Learn how to Enter Values, Manipulating Ranges, and Use Autofill
- Use Formulas for Computations
- Basic Commands and Formatting
Intermediate:
- Update multiple worksheets with 3D Formulas
- Advanced Formatting
- Outlining and Subtotals
- Use Tables and Charts
- Create Pivot Tables and Charts
Advanced:
- Use Logical Functions
- Use Arrays
- Use Lookup Functions
- Data Validation
- Use Database functions
Macros and VBA:
- Discuss the Developer Tab
- Introduce Objects, Methods, and Properties
- Discuss the VBA Environment
- Discuss Objects – Application, Workbooks, Worksheets
- Discuss Ranges
- Use Conditions and Loops
- Discuss Message Box, Input Box, and Other Objects
- Learn more about Arrays
- Use Functions and Events
- Introduce User Forms
Course Modules
Basic:
Lesson 1 – The Excel Interface
- Excel Screen
- Backstage View
Lesson 2 – Worksheets, Workbooks, Cells, Rows, and Columns
- Worksheets
- Workbooks
- Cells
- Rows
- Columns
Lesson 3 – Save, Close and Open Worksheets
- Saving Workbooks
- Closing Workbooks
- Opening Workbooks
Lesson 4 – Entering Values and Use Autofill
- Enter Values
- Inserting and Deleting Ranges
- Defining Named Ranges
- Using Autofill
- Changing Column Width and Row Height
Lesson 5 – Using Formulas
- SUM
- AVERAGE
- COUNT
- Using Absolute vs. Reference
Lesson 6 – Basic Commands Formatting
- Using the Clipboard Group
- Using the Font Group
- Using the Alignment Group
Intermediate:
Lesson 1 – Multiple Worksheets
- Moving from one workbook to another
- Calculating multiple worksheets using 3-D Formulas
Lesson 2 – Advanced Formatting
- Number Formats
- Using Functions to Format Texts
- Styles and Themes
Lesson 3 – Outlining and Subtotals
- Outlining and Consolidating Data
- Using Subtotals
Lesson 4 – Tables and Charts
- Sorting and Filtering
- Using Charts
Lesson 5 – Pivot Tables and Charts
- Pivot Tables
- Pivot Charts
Advanced:
Lesson 1 – Logical and PMT Functions
- IF, AND, OR, NOT
- Nested IF
- SUMIF, AVERAGEIF, COUNTIF
- PMT
Lesson 2 – Arrays
- Creating Array Formulas
Lesson 3 – Lookup Functions
- VLOOKUP
- HLOOKUP
- MATCH, INDEX
- WhatIf Analysis– 1Variable and 2Variable Data Table
Lesson 4 – Data Validation
- Settings
- Input
- Error Alert
Lesson 5 – Database Functions
- DSUM
- DAVERAGE
- DCOUNT
Macros and VBA:
Lesson 1 – Developer Tab
- Visual Basic
- Macros
- Record Macro
- Absolute vs. Reference
- Macro Security
Lesson 2 – Introduction to Objects, Methods, and Properties
- Objects
- Methods
- Properties
Lesson 3 – VBA Environment
- Ribbon
- Project
- Properties
- Code
- Immediate
Lesson 4 – Primary Objects
- Application
- Workbooks
- Worksheets
Lesson 5 – Range Object
- Range Object
- Cells Property
Lesson 6 – Conditions and Loops
- IF-THEN-ELSE-ENDIF
- SELECT-CASE-END SELECT
- FOR-NEXT
- WITH-END WITH
Lesson 7 – Other Objects
- Message Box
- Input Box
- Other Useful Objects
Lesson 8 – Arrays
- Introduction to Arrays
- Lower and Upper Bounds
- Dynamic Arrays
Lesson 9 – Functions and Events
- Introduction to Functions
- Introduction to Events
Lesson 10 – User Forms
- Buttons
- Text Box
- Input Box
- List Box
- Combo Box

Download the course PDF now!
Download Course PDF
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.