Excel to Excellence

Muhammad Waqas
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.
- Create & Navigate in Worksheets and Workbooks
- Format Worksheets and Workbooks
- Customize Options and Views for Worksheets and Workbooks
- 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
- 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
- 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
- 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
- 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
- Purpose of dashboard and key rules to remind
- How to format data set, Slicers, and make Pivot Charts
for dashboards
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
Courses We Offer:
- Plant Shutdown Management using Primavera 6
- Planning Engineer For EPC/Construction Management Industry
- Delay Analysis and Claims Management :
- Excel to Excellence
- Microsoft Project Management