This Advanced Microsoft Excel training class is designed for students to gain the skills necessary to use pivot tables, audit and analyze worksheet data, utilize data tools, collaborate with others, and create and manage macros. ... Convert text and validate and consolidate data. This course has been designed for computer users who would want to have an advanced learning in MS Excel. The learners must know already how to create templates, formulas and table management.

Pre-requisites • Basic MS Excel

Course Objectives - Participants should be able to:

To understand why to study advanced excel
To learn the different advanced functions
To appreciate the purpose of conditional formatting
To understand the importance of data validations
To create formulas using advanced functions
To understand the use of pivot table and pivot chart
To understand the use of Macro

Course Outline:

1 Review of MS Excel

2 Advanced Excel

Creating Hyperlink
Customizing Tables

3 Advanced Functions

Logical Function
Lookup Function
String Functions
Date and Time Functions
Rank Function
IS Function
Database Function
Alternative Function

4 Grouping and Outlining Subtotals

Outlining and Grouping Data
Using the Subtotals Tool

5 Conditional Formatting and Data Validations

6 What If Analysis

Exploring Scenarios
Goal Seek and Data Tables
Using Solver

7 Pivot Table and Pivot Charts

Getting Started with PivotCharts
Using the PivotChart Tools Tabs
Formatting a PivotChart

8 Introduction to Macro

Recording and Playing Macros
Visual Basic and Macros

9 Importing and Exporting Files

10 Tips and Tricks in MS Excel

Schedules

Apr 19, 2024

ENDED

Bonifacio Residences Condominium 5/F Bonifacio Residences, Sikap St., Boni Avenue, Mandaluyong, Metro Manila, Philippines

View Map

Sat

09:00 AM — 05:00 PM

Add to Calendar

May 18, 2024

Bonifacio Residences Condominium 5/F Bonifacio Residences, Sikap St., Boni Avenue, Mandaluyong, Metro Manila, Philippines

View Map

Sat

09:00 AM — 05:00 PM

Add to Calendar

No. of Days:	1
Total Hours:	8

Reviews

Be the first to write a review about this course.

Write a Review

CFS Creative Training & Management is a Filipino-owned company which started in January 2001, tracing its roots to CFS Continental Technology established in September 1996. The company’s four (4) divisions (Editorial & Creative Design, Corporate Training, Events Management and Consultancy) are engaged in conducting effective communication and personal empowerment seminars and arranging packages designed for companies’ needs.

Editorial & Creative Design Division - (Editorial) handles editing (newsletter, brochures, flyers) and writing press releases; (Creative Design) specializes in layouting, photography, designing and conceptualizing corporate brochures, flyers, posters;

Corporate Training Division - offers success and motivation workshops;

Events Management Division - assists companies/institutions in organizing field trips, corporate outing, concerts and exhibits;

Consultancy Services Division - provides technical advice on various corporate concerns, particularly in the areas of Sales and Marketing, Labor Law, Purchasing and Human Resource.

View Complete Profile

CFS Creative Training & Management

86 Spain St., Better Living Subd., Paranaque City, Metro Manila, Philippines

8425 2905 / 8736 2785

Accounting Banking & Finance Inventory / Warehousing