Advanced Microsoft Excel (Lahore)

MS Excel / IT

Advanced Microsoft Excel (Lahore)

Teachers
Muhammad Aleem Habib
Category:
Courses/ Courses at Lahore/
₨31,000.00
4 Reviews

₨31,000.00

Duration: Three Full Days (9:00 AM to 4:00 PM)
Lectures: All Hands-on
PIM Certificate

November 18 – 20, 2024

@ PIM, Lahore.



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 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 from Basic to advanced.
  • 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!

Note: The Fee is Exclusive of GST.

About Instructors

Muhammad Aleem Habib
Working as a Deputy General Manager at PIM. His areas of specialization are IT, Project and General Management.

Reviews

Average Rating

5
₨31,000.00
2 Ratings

Detailed Rating

Stars 5
0
Stars 4
0
Stars 3
0
Stars 2
0
Stars 1
0
  • 5 out of 5

    want to learn Advanced Microsoft excel.Can u please tell me the timing of classes.

    • Duration: Three Full Days (9:00 AM to 4:00 PM). For more information please contact +92 332 4353820

  • 5 out of 5

    Willing to Join, pls share the starting date.

    • December 20 – 22, 2021

Add a review

This site uses Akismet to reduce spam. Learn how your comment data is processed.