Advanced MS Excel Training (Cebu)

This course aims to provide learners with a foundation for MS Excel knowledge and skills, which they can build upon to eventually become an expert in data manipulation. 

Upon successful completion of this course, you will be able to create and develop Excel worksheets and workbooks in order to work with and analyze the data that is critical to the success of your organization.

Day 1: Fundamental MS Excel Functions

I. Basic Excel Functions

1. Text Functions
   1. Changing Cases of Text Values
   2. Extracting Parts of a Text
   3. Combining Values into one Columm
2. Logical Functions
   1. Constructing Basic Logical Statements
   2. Embedding Formulas in Logical Statements
3. Math Functions
   1. Review of Basic Arithmetic Functions
   2. Using Basic Conditional Math Statements
   3. Naming Ranges
4. Performing VLOOKUP

II. Data Management

1. Separating a Value into Separate Columns using Text-to-Columns
2. Creating Dropdown Menus using Data Validation
3. Applying Conditional Formatting
   1. Basic Conditional Formatting
   2. Data Bars, Color Scales, Icon Sets
4. Using the Subtotal Tool
5. Consolidating Worksheets

III. Basic Charts

1. Creating Basic Charts
2. Editing Chart Elements

IV. Basic PivotTable Features

1. Creating a Basic PivotTable
2. Changing Value Field Settings
3. Grouping Columns

Day 2:

I. Review of Basic Excel Functions

1. Text Functions
2. Logical Functions
3. Performing VLOOKUP
4. Date Functions

II. Advanced Excel Functions

1. Advanced Text Functions
   1. Using TRIM and LEN
   2. Using SUBSTITUTE
2. Advanced Logical Statement
   1. Creating Nested and Series IFs
   2. Using AND and OR
3. Array Formulas
4. Advanced Lookup Functions
   1. INDEX Function
   2. MATCH Function
   3. Combining INDEX and MATCH
5. Creating Complex Formulas

III. Advanced Data Management

1. Review of Basic Data Management Features
   1. Conditional Formatting
   2. Data Validation
2. Formula-Based Conditional Formatting
3. Advanced Data Validation

IV. Advanced PivotTable Features

1. Changing the PivotTable Design
2. Using Tables with PivotTables
3. Creating Calculated Fields

V. Macros

1. Preparing to Record Macros
2. Recording and Executing Macros
3. Assigning Macro to Buttons

Microsoft Certification ID: 15447524

Donnie has been in the professional Learning & Development field for over 10 years, with experience in both administrative, executive, and managerial roles.  His experience with the Business Process Outsource industry exposed him to various levels of training needs, including Communication Skills, Customer Service, Technical, Sales, Collections, and Leadership Development.

Working with one of the top IT schools in the Philippines and other training providers, he has developed his expertise on MS Office applications, designing training modules for various corporate clients.

He also conducts training on leadership and professional skills.  He had written several ebooks on various topics and had ghostwritten some leaning materials for clients locally and abroad.