X
Search results for:
No result found! Try with different keywords!
Users
Organizers
Events
Advertisement

Advance Excel

Loading booking inquiry details...
Advertisement


Event Details

Advance Excel


OVERVIEW:
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.

COURSE CONTENT:
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 &
Solver.

Protecting & Sharing Files:
Sharing a file and tracking changes
Accepting or rejecting changes.
Applying Data validation rules & Data
Tables.
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.

LEARNING OUTCOMES:
• Perform complex functions, lists analysis &
What-If tools
• Use outlines, range names, databases & the data
form
• 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

FACILITATOR'S PROFILE:
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 :

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?

Yes

Organizer

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

More Events in Karachi

Explore More Events in Karachi
Create an Event