Microsoft Excel 2019 Intermediate | IT Training & Certification | Info Trek
Respect Your Dreams
Follow through on your goals with courses

Microsoft Excel 2019 Intermediate

Location

Format What’s this?
Starting From
RM 250.00
  1. 1 Days
  1. HRDF SBL Claimable
  2. Lunch & refreshment provided
  3. Certificate of Attendance available
  1. 1 Days
  1. All of our private classes are customized to your organization's needs.
  2. Click on the button below to send us your details and you will be contacted shortly.

Microsoft Excel 2019 Intermediate

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.

PREREQUISITES

Basic knowledge of Microsoft Excel is essential with the following pre-requisites:

• 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, discussion and practical exercise.

COURSE OBJECTIVES

Upon completion of this program, participants should be able to:

• Create simple to complex formulas and functions, like:

o COUNTA & COUNTIFS Function

o AVERAGEA &AVERAGEIFS Function

o SUMIF & SUMIFS Function

o IF Functions

o Nested Functions

o Database Function



• Validate data in a Worksheet

• Filter data using Auto & Advanced Filters

• Advanced Chart Formatting

• Clean Duplicate Records

• Visualizing Data as a Graphics


Expand All

Modules

Module 1: Referencing Calculations

Topic A: Formula Reference

• Relative References
• Absolute References
• Mixed References

Module 2: Working with Functions

Topic A: Data Summary with Function

• COUNTA

• AVERAGEA


Topic B: Conditional Data Summary 1

• COUNTIF

• AVERAGEIF

• SUMIF


Topic C: Conditional Data Extraction

• IFERROR

• IF


Module 3: Organizing Dynamic Data Range with Tables

Topic A: Create and Modify Tables

• Create table

• Styles and Quick Style Sets

• Removing Duplicate Values


Topic B: Sort and Filter Data

• Sorting Data

• Filtering Data

• Advanced Filtering


Topic C: Use Subtotal to Calculate Data

• Total Row with SubTotal Functions


Module 4: Visualizing Data as a Graphics

Topic A: Conditional Formatting

• Highlight Cell Rules

• Using Data Bars

• Using Icon Sets

• Creating New Rules with Formula


Topic B: Create Charts

• Charts

• Chart Types

• Chart Insertion Methods

• Resizing and Moving the Chart

• Adding Additional Data

• Switching Between Rows and Columns


Topic C: Modify and Format Charts

• Difference Between Modifying and Formatting

• Chart Elements

• Minimize Extraneous Chart Elements

• The Chart Tools Contextual Tabs

• Formatting the Chart with a Style

• Adding a Legend to the Chart


Module 5: Setting Up Reports as Pages

Topic a: Managing Multiple Windows

• Arranging Workbooks

• Comparing Workbooks Side by Side

• Synchronous Scrolling and Resetting a Window


Azrulnizam Bin Ahmad

Azrulnizam Bin Ahmad

Azrulnizam Ahmad has been working in the business industry since 2004 and has been exposed to all the common challenges faced by business personnel. With his years of experience working with business and management, IT services and end users, he understands the importance of business value, infrastructure efficiency and user productivity.He shares his training passion in Microsoft Office 2007 Application - Excel, PowerPoint, and Word; Microsoft Office 2010 Application - Excel, PowerPoint, and Word and also emphasizes on the criticality of this aspect in any implementation.He is an energetic, independent, goal-oriented individual that has a high work standard and is committed to his work. He is also a good planner, is creative and resourceful, has great leadership charisma and works well with others. Read More

Jarina Muhamad Ismail

Jarina Muhamad Ismail

Since 2005, Jarina is involved in delivering learning programmes for Microsoft Excel, PowerPoint, Project, Outlook, Access, Word, Publisher and Visio. As a Microsoft Office Specialist (MOS) in all versions (2003-2013), she is using her expertise to provide timely solutions to the end-user which ranges from basic to advanced level including power users. She has experience in training and coaching various teams of professionals like executives, engineers, managers and directors to organize, analyze, create report and present business data more efficiently.
Read More

Course Reviews

No Remarks

0

0 Ratings