Advanced Microsoft Excel by CFS Creative Training & Management - SpeedyCourse Philippines
We've noticed this is not your region.
Redirect me to my region
What do you want to learn today?

Details

“Advanced Microsoft Excel”                                          

August 25, 2022 from 9:00 p.m. to 5:00 p.m.

 

Course Description        

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

Oct 20, 2022
Fri 09:00 AM — 05:00 PM
No. of Days: 1
Total Hours: 8
No. of Participants: 10
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.

Sending Message
Please wait...
× × Speedycourse.com uses cookies to deliver our services. By continuing to use the site, you are agreeing to our use of cookies, Privacy Policy, and our Terms & Conditions.