Mastering Microsoft Excel For Advanced Users - Other Classified Ads in Pasig

SaleSpider Left Classified Main Image
Mastering Microsoft Excel for Advanced Users

Venue: Suite 1503A, West Tower, Philippine Stock Exchange Bldg., Exchange Road, Ortigas Center, Pasig City

Manila Schedule 2020: advanced/

Course Description

Conducted by a Certified Microsoft Trainer, this 2-day hands on
course will provide you with the knowledge of more specialized and advanced capabilities of Excel by automating some common tasks, applying advanced analysis techniques to more complex data sets, collaborating on worksheets with others, and sharing Excel data with other applications.

Participants must have attended Basic Microsoft Excel.
Participants must bring their own laptop to apply lessons and work on exercises.

What you'll learn

At the end of the course, participants will be able to:
Identify & Define the Essential Components of Excel Formulas
Perform Advanced Formulas
Identify how to format financial statements and other Excel-based Reports effectively
Perform Data Security and Validation
Create Excel-based Charts & Dashboards to aid in communicating financial data information
Manage Big Data in Excel
Use Data Analysis Tools and Pivot Features
Get introduced to Macro functions and features

Course Highlights

The Essential Componenets of Excel Formulas
Using Relative & Absolute value for cell reference
Using Name box to calculate data across worksheets
Performing Advanced Formulas
Create Solutions in TEXT data
Streamline aging report
Using IF condition and Logical functions
How to Format Financial Statements and other Excel-based reports
Performing Data Security and Validation
Creating charts and dashboards to aid financial data communication
Managing Big Data in Excel
Application of Advanced Filter with Name Manager and logical symbols
Data Consolidation from different References
Using Database Functions
Analysis Tools Using Pivot Features
How to merge database to PIVOT
Manage, Manipulate and re-define PIVOT data resources
Visual Basic Introduction
Macro with Excel Functions & Features
Macro Settings, Recording, Assignments, Execution

Who Should Attend?

This course is intended for novice information workers who want to learn advanced level Excel skills. Administrative Officers, Finance Officers, Department Managers, Assistants and all office workers who want to learn advanced functions of Microsoft Excel program must attend this course.

Seminar Duration: 2 day, 9am to 5pm

Seminar Rate: Early Bird Rate - Php 8,500 +VAT | Regular Rate - Php 9,500 +VAT

Contact Us:
(632) 8687-4645, 8687-3416, 8687-4445
(0917) 5699639, (0922) 8874445
February 10, 2020
Suite 1503A, West Tower, Philippine Stock Exchange Bldg., Exchange Road, Ortigas Center, Pasig City, Pasig, Philippines
Show Map

Share This Classified With Your Social Networks

Subscribe to this RSS Feed

Member Spotlight

Sherif Elias Icon
Sherif Elias
Global Abundance Program
Independent Business Owner/Founder

Business Spotlight

Counsel Me Vancouver Icon
Counsel Me Vancouver
Mastering Microsoft Excel for Advanced Users