Microsoft

Advance Excel
Workshop

by Mr. Saqib Ansari

Microsoft Excel is becoming an indispensable tool in every workplace and core requirement almost in every job. It is a tool with vast potentials and therefore, its learning should be a continuous task. In effective application of Excel tools, generating information through cross tab reports and structured data model may leads to complexity.

Microsoft Advance Excel Workshop

What will you learn?

  • Easy Ways to use Commands.
  • Easy Ways to use Features.
  • Microsoft Excel “Power Suite” (known as Power Bi).

Target Audience?

 Excel Users who want to be on the leading edge with Excel’s Latest easy-to-use and powerful data analysis tool.

Pre requisite?

 Understanding of basic Excel Interface.

Venue

IPDR
Plot no. 11-M, PECHS Block-6, Karachi,

Timing

Slot 1
Sunday (9:30AM to 1:30PM)

Timing

Slot 2
Sunday (5PM to 9PM)

Timing

Slot 3
Sunday Tuesday and Thursday (5:30PM to 7:30PM)

Trainers Profile

Saqib Ansari

Speaker

About Speaker

 

Mr. Saqib Ansari

Head of Compensation & Benefits – Ideas by GulAhmed

 

Working experience of more than 12 years in different capacities from executive to leadership in IT organizations. Wide experience of transforming raw data into useful information for routine operation, analysis and decisive solutions, experience of business process reengineering and ERP implementation, developing SOP’s, operational and management reporting packs for finance, accounts, supply chain, production, logistics, projects sales and marketing.

 

As a corporate trainer, Mr. Saqib is passionate for helping people to develop and enhance their professional skills so they can become more productive, effective and efficient.

 

Technical Skills: Many in-house and open house Microsoft Excel & trainings to professionals from different sectors.

 

Soft Skill: several in-house trainings on lime management, Sales Techniques, Customer Management,

Communication and Leadership skills.

Course Outline

Get Data > Analyze > Publish > Consume

  • Getting Started with Excel
  • Excel Formula Basics
  • Excel Formula and Functions
  • Essential Formatting
  • Large Excel Projects
  • Excel Tables, Slicers and Timelines
  • Dashboard Reporting
  • Collaborating with Others
  • Exploring Excel’s Database Features
  • Analyzing Data
  • Advanced Analysis with Pivot Tables
  • Creating and Using Charts
  • Creating and Using Macros