Advanced Excel Training for Managers

INTRODUCTION

Microsoft Excel training course will teach you how to use the tools in Excel to manage and expand your business. This course is intended for people who already have a basic understanding of Excel.

COURSE METHODOLOGY

This course is designed in the form of workshop which will includes a variety of learning tools to help participants function effectively and efficiently in a multifunctional environment through various methodologies including;

• Short lectures
• Brainstorming
• Case studies
• Group activities
• Role playing

COURSE OBJECTIVES

The attendees of this Certificate Program will be able to:

• Gain excellence in using command of Microsoft Excel
• Understanding of all key Excel formulae
• Learn how to use Excel data features such as sorting, filtering, data validation, and data importing.
• Learn how to use Excel’s most common lookup functions, including V-lookup, H-lookup, Index, and Match.
• Make the most of Excel by constructing Pivot tables with slicers.
• Use the Conditional and Table formatting tools to create outstanding presentations.
• Use visual tools such as bar charts, scatter plots, histograms, and waterfall charts to captivate your audience.
• Learn how to develop and use crucial Excel shortcuts to increase your efficiency.
• Learn how to use sophisticated analytics techniques in Excel such as regression, goal seeking, and Solver.
• Learn how to use Macros to automate tasks.

WHO SHOULD ATTEND THIS COURSE?

• Working Professionals Just Starting Out in Data
• Anyone interested in quickly progressing from beginner to advanced Excel skills.
• For students who are preparing to start their first corporate career
• Business professionals

TARGETED SKILLS

• Microsoft skills
• Data handling
• Analytical techniques