Back to Courses

Live Webinar: Maximizing Microsoft Excel for Basic & Intermediate Users

ENDED

by Businessmaker Academy

Inquire Now

Online / Webinar

Ended last Jan 15, 2021

View this Course

PHP 4,256.00 (VAT incl.)

Inquire Book Now

RESPONSE RATE

Details
Outline
Schedules
About the Provider

Book Now

Inquire

Details

Conducted by a Certified Microsoft Trainer, this Microsoft Excel Basic to Intermediate training course is meant for students who want to advance their skill set by learning to work with advanced formulas, lists, and illustrations. Students will also work with charts and advanced formatting including styles.

Outline

TRACK 1: EXCEL DATA REFERENCE
a. Introduction to Excel Spreadsheet Intermediate Level
b. Defining Names in Excel

TRACK 2: APPLYING EXCEL FUNCTIONS
a. Functions within Excel
b. Text Related Functions
c. Understanding Date and Time Function
d. Logical Functions
e. Database Functions

TRACK 3: EXCEL FORMATTING TOOLS
a. The Format Cells Dialogue Box
b. Conditional Formatting
c. Formula Based formatting

TRACK 4: DATA VISUALIZATION
a. Principles of Data Visualization
b. Creating Basic Charts and Dashboard
c. Application of Different Chart Types in Microsoft Excel

TRACK 5: REPORT CONSOLIDATION IN MS EXCEL
a. Using Basic Sort and Filter Methods
b. Application of Basic Subtotal
c. Consolidate Feature of Microsoft Excel

TRACK 6: WHAT IF ANALYSIS METHODS
a. The use of Goal Seek
b. Creating Scenario Manager
c. Applying Data Tables

Special Offer

Click this link for more info:
https://businessmaker-academy.com/live-webinar-microsoft-excel-basic-intermediate/

or Contact us through:
(632) 7957-7937, 7219-1039
(0917) 572-1713, (0917) 637-2471
[email protected]

Schedules

Jan 14, 2021 - Jan 15, 2021

ENDED

1:30PM — 5:30PM

Add to Calendar

No. of Days:	2
Total Hours:	8
No. of Participants:	50

Reviews

Be the first to write a review about this course.

Write a Review

Businessmaker Academy is an Education Center for Business, Finance, Livelihood and Corporate Skills Development. We offer a simple, direct and practical approach to business fundamentals. Our primary purpose is to teach people how to improve their professional, personal and financial lives through experience-based learning.

Aware that not many people can afford to spend 2 to 4 years of their lives in formal study, Businessmaker Academy has created practical, straightforward and direct short-course seminars in line with our Core Educational Thrusts:

Forex & Investing

Business Management

Corporate Training

Crafts & Livelihood

Businessmaker Academy delivers high-impact education through several educational formats to suit the needs of our various clients:

Public Seminars

Corporate Training & In-house Group Seminars

Since 2003, Businessmaker Academy has conducted numerous seminars and has served over 50,000 highly satisfied clients and counting...

Online Webinars

Human Resource Management

View Complete Profile

Businessmaker Academy