Live Seminar: Maximizing Microsoft Excel for Basic & Intermediate Users
ENDED
Seminar by
Businessmaker Academy
Inquire Now
On-Site
/ Seminar
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.
Pre-requisites
-Participants must have basic computer skills.
-Participants use own laptop to apply lessons and work on exercises.
Hardware/Software Requirements
-Microsoft Excel 2016 / 2019 version
-Mac laptop/ Mac book version is not allowed
What you'll learn
By the end of the course you’ll be writing robust, elegant formulas and functions from scratch, allowing you to:
-Manipulate dates, times, text, logical functions
-Go rogue and design your own formula-based Excel formatting rules
-Create Dynamic Dashboards and reports using Excel Chart tools
-Analyze and consolidate your data using Excel reporting tools
Pre-requisites
-Participants must have basic computer skills.
-Participants use own laptop to apply lessons and work on exercises.
Hardware/Software Requirements
-Microsoft Excel 2016 / 2019 version
-Mac laptop/ Mac book version is not allowed
What you'll learn
By the end of the course you’ll be writing robust, elegant formulas and functions from scratch, allowing you to:
-Manipulate dates, times, text, logical functions
-Go rogue and design your own formula-based Excel formatting rules
-Create Dynamic Dashboards and reports using Excel Chart tools
-Analyze and consolidate your data using Excel reporting tools
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
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
Schedules
May 02, 2024 - May 03, 2024
ENDED
Thu, Fri | 09:00 AM — 05:00 PM |
No. of Days: | 2 |
Total Hours: | 16 |
Reviews
Be the first to write a review about this course.
Write a Review
Business maker Academy, Inc. is an Education Center for Business, Finance, Human Resources and Corporate Skills Development. We offer a simple, direct and practical approach to business training.
Our primary purpose is to teach people how to improve their professional, personal and financial lives through experience-based learning.
Our primary purpose is to teach people how to improve their professional, personal and financial lives through experience-based learning.
We are an Accredited Training Provider for the Civil Service Commission (CSC) & Philippine Government E-Procurement System (Philgeps). Since 2003, Business Maker Academy has conducted numerous seminars and has served over 100,000++ highly satisfied clients and counting…
Businessmaker Academy
1503A PSEC, West Tower, Ortigas Center Pasig City, Pasig, Metro Manila, Philippines 1605
86874445