Advanced Microsoft Excel (Islamabad)
Advanced Microsoft Excel (Islamabad)
₨25,000.00
Duration: Three Full Days (9:00 AM to 4:00 PM) |
Lectures: All Hands-on |
PIM Certificate |
COURSE DESCRIPTION
Microsoft Excel is one such application that does not require any preaching to be used. It is the choice of billions of corporate users due to its power, speed & simplicity of use. Most people have a basic understanding of Excel but a few really know where to find Excel’s most effective & efficient power features. This course contains everything you need to know & learn about Excel. It is designed to fill the void by providing comprehensive training on Excel’s most powerful features. Promising 24 hours of hands-on learning in 3 days, the course is aimed to train participants from Basic to Expert!
COURSE CONTENTS
- Essential Math/Stats Functions: SUM, AVERAGE, MIN, MAX, COUNT, LARGE, SMALL, FLOOR
- Essential Text Functions: UPPER, LOWER, PROPER, FIND, TEXT, LEFT, RIGHT, MID
- Date & Time Functions: NOW, DATEDIF, EDATE, NETWORKDAYS, WEEKDAYS, YEAR, MONTH, HOUR, MIN
- Using Logical Functions: IF, IFS, AND, NOT, ISNA, IFERROR, ISBLANK, ISNUMBER
- Using Excel Power Functions: SUMIFS, COUNTIFS, AVERAGEIFS
- Using D-Functions: DSUM, DAVERAGE, DMAX, DMIN, DGET
- Lookup Functions: VLOOKUP, HLOOKUP, INDEX, MATCH, CHOOSE
- Working with Name Ranges & Name Manager
- Working with Smart Tables
- Working with Array & 3D Formulas
- Using Flash Fill for Data Transformation & Separation
- Creating & Customizing Charts – Column, Line, Bar, Pie and Combo Charts
- Analyzing & Summarizing Data with Pivot Table Reports, Pivot Charts & Slicers
- Get & Transform Data: Power Query
- Automating Recurring Tasks with Macros
- Using Excel Business Modeling Tools: Goal Seek, Data Tables, Solver, Scenario Manager
- Conditional Formatting
- And loads of Excel Tips & Tricks
LEARNING OUTCOMES
After the workshop, you will be able to:
- Take your Excel proficiency form Basic to Advance.
- Become more efficient in data analysis and reporting.
- Apply complex Excel functions and tools confidently.
- Better able to solve business problems using Excel
TARGET AUDIENCE
If you want to be an Excel Power User, unleash the true potential of this application and efficiently automate your business processes then this course is for you!
About Instructors

Reviews
Average Rating
Detailed Rating
Stars 5 |
|
0 |
Stars 4 |
|
0 |
Stars 3 |
|
0 |
Stars 2 |
|
0 |
Stars 1 |
|
0 |
Add a review Cancel reply
This site uses Akismet to reduce spam. Learn how your comment data is processed.
₨25,000.00
Duration: Three Full Days (9:00 AM to 4:00 PM) |
Lectures: All Hands-on |
PIM Certificate |
mufassir hayat
can you please share whats app number
Amir Ali
+92 340 5118080
Farooq Omer
I am interested in Excel course to revive my knowledge.
When next class is planned.
Amir Ali
Please contact +92345118080
Samina shehzad
I’m interested to get training on advance Ms office and excel,
Aliya
IS IT POSSIBLE TO LEARN IT IN 3 DAYS?
siteadmin
its 21 hours of hands-on training. You will learn a lot IA.
Rehmat Ali
I and some of my team member around (6 members) working in MNC want to enhance our excel proficiency need your support for timing flexibility like evening time if possible
Shahbaz Ahmad
Knowledge learn
Firdous Ahmed
I am interested to get training on advanced MS office and Excel.
siteadmin
Most welcome. Please contact program office Islamabad at (9251)9260003–4 cell: 0340-5118080 or email at pimisb@pim.com.pk