Search results for:
No result found! Try with different keywords!

Advance Excel

Loading booking inquiry details...

Event Details

Advance Excel

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).

Pivot 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
Inserting comments.

Introduction to Macros & VBA:
Purpose of Macros & recording Macros.
Where to save Macros
Absolute and relative record & running
macros: Custom buttons, menu items,
keyboard shortcuts.

• Perform complex functions, lists analysis &
What-If tools
• 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.

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 :

Map The Royale Rodale Club Karachi, Karachi, Pakistan
Loading venue map..
Questions or Comments? Post them here.
Event details from Report a problem
This event is listed in

Are you going to this event?



Management Association of Pakistan
  • 4 Events
Who's going?
Login to see participants.

More Events in Karachi

Explore More Events in Karachi
Create an Event