Professional Development Training of Advance Excel

150+
Trainees

10+
Organizations

in collaboration with

Previous participants

what you will learn

Introduction:

The primary aim of this training is to provide critical insights to Improve Productivity & Enjoy Work Getting more from data from Accounts, Finance, Inventory Management, Procurement, CRM, HRM, QC, Marketing & Sales, Imports, Exports Forecasting through Trends Quick Data linkage within Excel and with other sources.

Latest Features: Introduction to “Amazing Upcoming Functions in EXCEL”–a latest advancement in the history of MS Excel.
Securing your work through different Protection Levels, Backups, Printing work sheets etc.
Business on the Go: Spreadsheets on the Cloud–Excel Online& Google Sheets.
Exacting information using Look up functions (need of every manager, a time saving approach In audits and reconciliations or matching lists)
Business on the Go: Spreadsheets on the Cloud–Excel Online& Google Sheets.
Smart working approaches using Lists, Tables, Filters, Advance Filters, Sorting, Custom Lists, Outlines, Subtotals, D-Functions.

What-If Analysis-Goal Seeking, Scenarios, Solver by Optimizing Resources for Profit, Cost, & Wastage etc. under given constraints (a smart approach for Complex Problem-Solving with Simple Skills).
What-If Analysis-Goal Seeking, Scenarios, Solver by Optimizing Resources for Profit, Cost, & Wastage etc. under given constraints (a smart approach for Complex Problem-Solving with Simple Skills).
creating & working with Dynamic Charts, Fitting Trends for future forecasts, Dashboards.
Automating Tasks with Macros: Recording a Macro, Developing own Functions, Subroutines and Add-Ins with VBA, Bringing Add-Ins in action

Who Should Attend

top certification

Skills
for future

Want to shape the future ?

Jawad Mirza

trainers

Expert Trainer

Fee Details

Individual

PKR 16,500/-

Per Person
(+ 16% GST)

Group of Two

PKR 14,850/-

10% of Per Person
(+ 16% GST)

Group of Three

PKR 14,025/-

15% of Per Person
(+ 16% GST)

Group of Four

PKR 13,200/-

20% of Per Person
(+ 16% GST)

“THERE ARE ONLY TWO WAYS IN WHICH A MANAGER CAN IMPACT AN EMPLOYEE'S OUTPUT: MOTIVATION AND TRAINING.IF YOU ARE NOT TRAINING , THEN YOU ARE BASICALLY NEGLECTING HALF THE
JOB .” ― Andy grove

alumni comments

over all good experince

“

abdul jabbar

soorty denim

Enroll now!

training@aiia.com.pk

+92 332 8031009