Live Virtual Training (Most Popular!) > Microsoft Excel Intermediate

Microsoft Excel Intermediate

All versions available. Outline version below is Microsoft Excel 2019. If you need assistance just chat with us LIVE.

Course Objectives

Create simple to complex formulas and functions, like:

COUNTA & COUNTIFS Function
AVERAGEA &AVERAGEIFS Function
SUMIF & SUMIFS Function
IF Functions
Nested Functions
Database Function

Validate data in a Worksheet
Filter data using Auto & Advanced Filters
Advanced Chart Formatting
Clean Duplicate Records
Visualizing Data as a Graphics

Target Audience

This course is designed for Clerks, Officers, Executives, Supervisors, Administrators, Managers of all levels; and personnel who already know and understand and want to further enhance their knowledge and practical uses of Microsoft Excel.

Have attended Microsoft Excel – Foundation Level; OR
Able to switch between task applications
Able to create a spreadsheet with simple formatting
Able to create a basic chart
Able to print a spreadsheet with headers and footers added
Able to use Auto Filter command
Able to apply Freeze Pane command
Able to create basic formulas – Addition, Subtraction, Multiplication and Division
Able to use basic functions – AutoSum, Count, Max, Min and Average functions.

Methodology

This program will be conducted with interactive lectures, PowerPoint presentation, discussions and practical exercise.

Course Modules

Module 1: Referencing Calculations
Topic A: Formula Reference
Topic B: Apply Range Names
Module 2: Working with Functions
Topic A: Data Summary with Function
Topic B: Conditional Data Summary 1
Topic C: Conditional Data Extraction
Topic D: Conditional Data Summary 2
Module 3: Organizing Dynamic Data Range with Tables
Topic A: Create and Modify Tables
Topic B: Sort and Filter Data
Topic C: Use Subtotal to Calculate Data
Topic D: Data Validation
Module 4: Data Visualization
Topic A: Conditional Formatting
Topic B: Create Charts
Topic C: Modify and Format Charts
Topic D: Adding Sparklines
Topic E: Editing Sparklines
Module 5: Setting Up Reports as Pages
Topic A: Working with Different Views
Topic B: Managing Multiple Windows

Get To Know The Trainer

Trainer Jarina

4.5

Managing and maintaining a Microsoft Windows Server 2003 Environment - educate the IT professionals who implement, manage, and troubleshoot existing network and system environments based on the Windows Server 2003 platform. Implementation responsibilities include installing and configuring parts of systems. Management responsibilities include administering and supporting systems

VIEW PROFILE

Trainer Shalina

4.5

Shalina has 20 years of experience in IT related fields including 11 years in conducting public courses. She specializes in Corporate IT infrastructure planning (networking, troubleshooting and system integration), conducts applications training programs such as Microsoft, Adobe, Lotus and COMPtia products as well as organizes and conducts exhibitions and seminars.

VIEW PROFILE

Trainer Izham

4.5

Izham has 14 years of teaching background with 4 years in the academic department of a public university followed by corporate clienteles in the later years. Since becoming a corporate trainer, Izham has been helping office workers all over cope with data and document volumes in digital form to become efficient and come out being smart office workers.

VIEW PROFILE

Trainer Slyvia

Sylvia has been in the IT Training Industry for the past 20 years She began her career as a Corporate Trainer and her personal areas of expertise are wide; encompassing Microsoft and Adobe applications. In addition to that; she also specializes in corporate coaching for government, multi-national companies to local SMEs

VIEW PROFILE

Trainer Beatrice

4.5

Beatrice has been in the training industry for the past 27 years being one of the pioneer trainers of Microsoft Office training programs. She has vast experience having trained many people from various corporate sectors. She is a certified Microsoft Office training consultant and is accredited by Pembangunan Sumber Manusia Berhad (PSMB/HRDF).

VIEW PROFILE

View more trainers