Advanced MS Excel (Lahore)

Augsut 19 – 20, 2019

Venue: PIM, Lahore.

COURSE DESCRIPTION

Microsoft Excel is one such application which 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 the 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 a comprehensive training on Excel’s most powerful features. Promising 18 hours of hands-on learning in 2 days, the course is aimed to train participants from Basic to an Expert!

COURSE CONTENTS

• Essential Functions: Mathematical, Logical, Date & Time, Text. Database
• Using Excel Power Functions
• Working With Arrays & Multi-sheet Formulas
• What-If Analysis with Goal Seek. Data Table, Solver ,& Scenario Manager
• Data Analysis & reporting with Pivot Tables Charts & Reports
• Data Visualization with Charts, Sparkline & Conditional Formatting
• Subtotaling & Data Filtering
• Automating Recurring Tasks with Macros
• Protecting Worksheets & Workbooks
• and Lots of Excel Master 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