MASTERING MICROSOFT EXCEL FOR ADVANCED USERS

Mastering Microsoft Excel for Advanced Users


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

Manila Schedule 2020: https://businessmaker-academy.com/microsoft-excel-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 ****ysis techniques to more complex data sets, collaborating on worksheets with others, and sharing Excel data with other applications.

Pre-requisites

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 ****ysis 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
****ysis 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

[email protected]

Visit: www.businessmaker-academy.com