Search results for:
No result found! Try with different keywords!
Oh Snap, this is a past event! 😵

Do you want to get notified when this event happens again?

Advanced Excel Module -II


Advanced Excel Module -II

Two Days Workshop on "Advanced Excel Module -II"

Date: 03-04 October, 2018
Venue: NUST PDC H-12 Islamabad
Time: 0900 to 1700 hrs
Investment: Rs.21,500 per participant (includes lunch, tea, course material, certificates, networking opportunities)

Course Overview
This Advanced Excel course offers real, practical benefits in the general use of spreadsheets; making your spreadsheets more accurate and reliable, and more automatic and interactive. This course will enable the delegates to use spreadsheet in decision making.

Training Objectives
The aim is that delegates leave this course with a very thorough understanding of using Excel’s advanced functions. This course is really designed for people carrying out detailed, complex data analysis and manipulation tasks who would benefit from understanding all of the functionality that Excel can offer them.

Course Contents
Learn how Excel involve in Managerial Decisions
Solving problems using linear programming in excel
Recalling solutions for scenarios in future
Learn scenario management in excel
Understanding and creating different scenarios by changing the variables
Extracting reports under different circumstances without effecting the actual model.
Driving desired output by manipulating input
Learn to manage data professionally
Familiar with powerful database functions to fetch summary reports
Understand the formula based advance features in data validation and learn creating custom validations
Using excel to find where you need to start to get where you need to go
Using excel data table to calculate dozens of possible outcomes
Microsoft Business Intelligence Tools (For Excel Version 2010 or 2013)
Gain insight about business intelligence
An introduction to PowerPivot
Learn how PowerPivot helps to create powerful reports
Learn calculations in PowerPivot – An introduction to DAX
VBA and Macros
Learn where the essential tools are in the Visual Basic Editor (VBE) and explore the use of each
Coding and editing in VBA
Usage of Form controls
Understand anatomy of advance formulas and functions
Evaluating inputs logically
String Management
Dates Application
Looking Values
Maths in Action
Statistics in Excel
Financial Management
Learn how Conditional Formatting & advanced Charts
Learn application of advanced formulas based conditional formatting beyond simple conditional formatting
Create more dynamic charts using more advanced formulas and tools.

Who Should Attend
This workshop is designed for Excel users with moderate knowledge of spreadsheets. The participant could be a Chartered Accountant, Financial Analyst, Business Administrator or anyone who are keen to further their working knowledge of Microsoft Excel.�

Resource Person
Mr. Asif Rehman, a Chartered Certified Accountant by profession, has over 7 years of working experience in the area of Business Analytics & Optimization, Accounting, Financial Management and Taxation. He is also pursuing to earn CFA Charter. Mr. Asif is the founder of 12th Analytics; involved in data analytics consulting. Prior to this he has worked with world’s leading brands at different positions e.g. PwC and BBC World News. He has conducted multiple MS Excel, VBA & financial modelling trainings in different organizations / business schools for professionals. He is dealing with all aspects of Excel from basic competence to advanced data analysis. He is able to bring these years of practical experience to this training, ensuring that the course explains advanced concepts clearly and concisely, and with real and practical applications and even the occasional joke.�

You may also like the following events from Pdc-Nust:

Also check out other Workshops in Islamabad, Nonprofit Events in Islamabad.

Liked this event? Spread the word :

Map CIE Building, NUST Main Campus, Kashmir Highway Islamabad., Islamabad
Loading venue map..
Event details from Report a problem

Are you going to this event?