Certified MS Excel Professional – Lahore

Have you mastered the basics of Excel?? Now put the power of Excel’s advanced functions and features work for you! Excel is long standing powerhouse of spreadsheet software, is one of the most commonly used business application.  Excel has countless features and functions to make your job easier but only if you know how and when to use them.  This course will teach you all the must know features of Excel.

COURSE OBJECTIVES

• 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.

PROGRAM CONTENTS

• Understanding Excel’s Anatomy (Row, Columns, Cells)
• In-depth understanding of Cell References (Relative, Absolute & Mixed Cell References)
• Cell Formatting, Conditional Formatting.
• Name Manger, Data Validation, Data Sorting, Filter & Advanced Filter
• Essential Functions: Logical, Lookup, Date & Time, Text, Statistical, & Financial Functions
• Working With Arrays & Multiple-sheet Formulas
• Automating Recurring Tasks with Macros and VBA
• What-If Analysis with Goal Seek. Data Table, Solver & Scenario Manager
• Summarize, analyze, data comparisons, patterns, and trends in your data reporting with Pivot Table.
• Working with Charts: Pie, Bar, Line, Sparkline & Double Axis charts.
• Interactive visualizations and business intelligence using Microsoft Power BI to create your own reports and dashboards.
• Protecting Worksheets & Workbooks
• Lots of Excel Master Tips & Tricks.

COURSE METHODOLOGY

This is a 100% hands-on course that will be conducted using various techniques including. Demonstration of various Excel features, functions & tools by the instructor and practice exercises for participants.

PROGRAM DURATION/DAYS

This Program is of 2-months’ duration and classes are held twice a week on Friday (06;00 PM to 09;00 PM) & Saturday (05;00 PM to 08;00 PM) .

WHO SHOULD ATTEND

Anyone who is using MS Excel for data analysis, reporting and for other operational purposes and want to take their Excel skills to next level.

FOR DETAILS & REGISTRATION

Diploma Office, Management House, Management, 70-B/2, Gulberg-III, Lahore
Voice Dir: (+9242) 3576 1894 EPABX: (+9242) 9926 3133-35 Fax: (+9242) 9926 3138
Cell: 0300-4297217, E-mail: shahnaz@pim.com.pk, pimdiploma@pim.com.pk