Excel to Excellence

Muhammad Waqas

5.0(1k)

 5/5

Course Description

Candidates who complete the Microsoft Excel certification course successfully, would be familiar with essentials of the Excel user-environment and would be able to complete various tasks independently. Our graduates will have in depth knowledge and would be able to demonstrate the advanced application of the essential features of MS Excel. At the end of the course, candidates will be examined to create and edit an Excel workbook including multiple sheets, and prove data visualization skills using graphic elements. Workbooks may come from a range of topics like corporate level budgets, financial statements, engineering charts, sales invoices, and data-entry logs etc.

Lecture-01: Introduction and Interface of MS Excel

Create & Navigate in Worksheets and Workbooks
Format Worksheets and Workbooks
Customize Options and Views for Worksheets and Workbooks

Lecture -02: Filter and Functions (IF, AND, OR)

Filter and sort a table, Advance filter, Custom Auto filter
Number, Date, color and Text filter, Copy and paste formula
Formula and Cell reference, form filter, and Subtotal, IF, AND,
OR Function in detail
Equal to, Greater than, Less than function, Relative and absolute
cell reference

Lecture -03: VLOOKUP, INDEX, MATCH, Goal Seek

What If analysis (Goal Seek and Solver parameter)
VLOOKUP, HLOOKUP, Index, and Match
Relationship between Index, Match & VLOOKUP and
why do we use each of them

Lecture -04: : IFERROR, ISBLANK, Protect Sheet, SUMIF(S)

IFERROR, Types of error, the reason for each error &
how to remove them
Protect the worksheet, Locked and Unlocked cells, Password protection
SUMIF(S), COUNTIF(S) & their applications, ISBLANK Function

Lecture -05: : Pivot Tables

Pivot tables fields and function of each field, Formatting of
pivot tables, value field setting
Filter in Pivot table, Grouping, and Ungrouping, Design of
Pivot tables and Pivot charts
Expand and Collapse different fields, Moving between fields
Calculated field and calculated items

Lecture -06: Conditional and Custom Format

Find duplicate values and Shades alternate rows
Highlight cell rules, Top bottom rules, manage rules
and icon sets
Data bars, colors scales, Formatting through formulas
Custom formatting rules and application of each rule

Lecture -07: Basic Dashboard

Purpose of dashboard and key rules to remind
How to format data set, Slicers, and make Pivot Charts
for dashboards

Mentor

Engr Waqas Ahmad

About Mentor

I am an Entrepreneur and International Seasoned Project Management Consultant & Trainer (UAE, KSA, QATAR, PAKISTAN) with 10 years of Successful exposure of project management and conducted process development to enhance profit and gain targets.

Living in modern era I follow enthusiastic pattern to learn from each passing moment and train organization employees to follow project management rules as per process industry standard to gain productivity. My Coaching sessions are full of energy, Brain storming, Personal development oriented with Advanced Software knowledge to lead in the Industry.

My TOP Ranked Trainings are as follows
Project Management with Primavera-6 in following Industry
EPC Projects
Delay Analysis & Claims Management
Plant Shut-down
Up-Stream Oil & Gas Operations
Career Development
Personal Development
Presentation Skills

TheSkillsAge