Advance Software systems are being deployed by organizations,
however, when meaningful reports are required, spreadsheet
tools are mostly used. Microsoft Excel dominates 90% of the
market, thus, employees use this tool to apply on business
scenarios and operations.
This course will help you to become more productive by learning
advance techniques in MS Excel 2013 and would cover
intermediate and advance level of Microsoft Excel.
Lookup & Information Functions:
Vertical Lookup & Horizontal Lookup
(Hlookup) Match and Index, IsText,
IsValue, IsDate, IsErr, Is Error, IsNa.
Advanced List Management:
Advanced Filters, Using List Features.
Dynamic Lists (Tables).
Using the Pivot Table Wizard.
Changing the pivot table layout &
Formatting Grouping items &
Inserting calculated fields Pivot Table
Options & Display and hide data in
fields Lay out reports directly on
worksheet & Pivot Chart.
What If Analysis:
Scenarios & Data Tables Goal Seek &
Protecting & Sharing Files:
Sharing a file and tracking changes
Accepting or rejecting changes.
Applying Data validation rules & Data
Introduction to Macros & VBA:
Purpose of Macros & recording Macros.
Where to save Macros
Absolute and relative record & running
macros: Custom buttons, menu items,
• Perform complex functions, lists analysis &
• Use outlines, range names, databases & the data
• Use AutoFilter & advanced FIlters
• Work with Data Series
• Use advanced functions including array functions
• Creating and Modify charts
• Use Scenarios & Goal Seek
• Use templates, data tables & solve problems
• Use automatic formatting & styles
• Work with views, consolidate worksheets
• Create & revise PivotTables
• Use, record & edit macros
Having 17 years of management consultancy
experience, Mr. Jamal is a Fellow member of
Institute of Cost & Management Accountants of
Pakistan (ICMAP) and currently working as
Director at a software house.
Mr. Jamal has conducted more than 100 open
and corporate workshops on national & international levels on
different topics including Financial Modeling, Designing
Dashboard Information Systems, Budgeting, ERP
Implementations, Practical Excel Application, etc. Mr. Jamal
conducts training for students and members of ICMAP & ACCA
(global professionals) since 2003 & 2013 respectively, which
includes Dashboard Reporting & Financial Modelling. He is a
prominent visiting faculty member and speaker in various
prestigious universities of Pakistan since last 15 years.
WHO SHOULD ATTEND?
Accountants, Business Managers, Business
Intelligence Professional, Business Analysts,
Reporting Analyst, Finance & Accounts Executives
You may also like the following events from Management Association of Pakistan:
Also check out other Workshops in Karachi
, Entertainment Events in Karachi
, Music Events in Karachi
Liked this event? Spread the word :