Excel E2E Bootcamp

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:

  1. Familiarize yourself with the Excel Interface
  2. Discuss Worksheets, Workbooks, Cells, Rows, and Columns
  3. Learn how to Save, Close and Open Worksheets
  4. Learn how to Enter Values, Manipulating Ranges, and Use Autofill
  5. Use Formulas for Computations
  6. Basic Commands and Formatting

Intermediate:

  1. Update multiple worksheets with 3D Formulas
  2. Advanced Formatting
  3. Outlining and Subtotals
  4. Use Tables and Charts
  5. Create Pivot Tables and Charts

Advanced:

  1. Use Logical Functions
  2. Use Arrays
  3. Use Lookup Functions
  4. Data Validation
  5. Use Database functions

Macros and VBA:

  1. Discuss the Developer Tab
  2. Introduce Objects, Methods, and Properties
  3. Discuss the VBA Environment
  4. Discuss Objects – Application, Workbooks, Worksheets
  5. Discuss Ranges
  6. Use Conditions and Loops
  7. Discuss Message Box, Input Box, and Other Objects
  8. Learn more about Arrays
  9. Use Functions and Events
  10. Introduce User Forms

Course Modules

Basic:

Lesson 1 – The Excel Interface

  1. Excel Screen
  2. Backstage View

Lesson 2 – Worksheets, Workbooks, Cells, Rows, and Columns

  1. Worksheets
  2. Workbooks
  3. Cells
  4. Rows
  5. Columns

Lesson 3 – Save, Close and Open Worksheets

  1. Saving Workbooks
  2. Closing Workbooks
  3. Opening Workbooks

Lesson 4 – Entering Values and Use Autofill

  1. Enter Values
  2. Inserting and Deleting Ranges
  3. Defining Named Ranges
  4. Using Autofill
  5. Changing Column Width and Row Height

Lesson 5 – Using Formulas

  1. SUM
  2. AVERAGE
  3. COUNT
  4. Using Absolute vs. Reference

Lesson 6 – Basic Commands Formatting

  1. Using the Clipboard Group
  2. Using the Font Group
  3. Using the Alignment Group

Intermediate:

Lesson 1 – Multiple Worksheets

  1. Moving from one workbook to another
  2. Calculating multiple worksheets using 3-D Formulas

Lesson 2 – Advanced Formatting

  1. Number Formats
  2. Using Functions to Format Texts
  3. Styles and Themes

Lesson 3 – Outlining and Subtotals

  1. Outlining and Consolidating Data
  2. Using Subtotals

Lesson 4 – Tables and Charts

  1. Sorting and Filtering
  2. Using Charts

Lesson 5 – Pivot Tables and Charts

  1. Pivot Tables
  2. Pivot Charts

Advanced:

Lesson 1 – Logical and PMT Functions

  1. IF, AND, OR, NOT
  2. Nested IF
  3. SUMIF, AVERAGEIF, COUNTIF
  4. PMT

Lesson 2 – Arrays

  1. Creating Array Formulas

Lesson 3 – Lookup Functions

  1. VLOOKUP
  2. HLOOKUP
  3. MATCH, INDEX
  4. WhatIf Analysis– 1Variable and 2Variable Data Table

Lesson 4 – Data Validation

  1. Settings
  2. Input
  3. Error Alert

Lesson 5 – Database Functions

  1. DSUM
  2. DAVERAGE
  3. DCOUNT

Macros and VBA:

Lesson 1 – Developer Tab

  1. Visual Basic
  2. Macros
  3. Record Macro
  4. Absolute vs. Reference
  5. Macro Security

Lesson 2 – Introduction to Objects, Methods, and Properties

  1. Objects
  2. Methods
  3. Properties

Lesson 3 – VBA Environment

  1. Ribbon
  2. Project
  3. Properties
  4. Code
  5. Immediate

Lesson 4 – Primary Objects

  1. Application
  2. Workbooks
  3. Worksheets

Lesson 5 – Range Object

  1. Range Object
  2. Cells Property

Lesson 6 – Conditions and Loops

  1. IF-THEN-ELSE-ENDIF
  2. SELECT-CASE-END SELECT
  3. FOR-NEXT
  4. WITH-END WITH

Lesson 7 – Other Objects

  1. Message Box
  2. Input Box
  3. Other Useful Objects

Lesson 8 – Arrays

  1. Introduction to Arrays
  2. Lower and Upper Bounds
  3. Dynamic Arrays

Lesson 9 – Functions and Events

  1. Introduction to Functions
  2. Introduction to Events

Lesson 10 – User Forms

  1. Buttons
  2. Text Box
  3. Input Box
  4. List Box
  5. 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.