Ms Excel Professional Training

OBJECTIVES

Microsoft Excel is a powerful tool for handling data, automating tasks, and improving workplace efficiency. This training is designed to equip professionals with advanced Excel skills, enabling them to work smarter, analyze data effectively, and streamline processes.

By the end of this training, participants will be able to:

Work effectively with large volumes of text and numerical data in Excel with ease
Design Excel-based templates for data collection, analysis, and reporting
Exhibit mastery of key concepts, functions, techniques, and “power tips” in Excel
Automate various work activities and tasks in Excel for improved efficiency

OUTLINES

➢ Exploring the Microsoft Excel user
interface
➢ Setting up a Workbook
➢ Database concept in Microsoft Excel
➢ Reordering and summarizing data
➢ Focusing on specific data using filters
➢ Enhancing data integrity through data
validation
➢ Formatting
➢ Application of Excel Functions in work
activities
➢ Tackling text problems: manipulating and
formatting text as well as managing large
volumes of text data
➢ Protection
➢ Printing in Excel
➢ Use of conditional formatting in data analysis
➢ Advanced filter techniques
➢ Dependent (advanced) data
validation techniques
➢ More Excel Functions
➢ Named Ranges 1
➢ Combining data from multiple sources
➢ Use of Relative & Absolute
referencing
➢ Analyzing alternative data sets
(working with Goal Seek)
➢ Working with Pivot Tables
➢ Introduction to VBA and Macros
➢ Application of Form Controls: combo boxes,
scroll bars, check box, option box, etc
➢ Work-related case studies