Microsoft® 365 Essentials

Mastering Word, PowerPoint, Outlook, And Excel For Workplace Productivity

4 Day(s)

Face-To-Face Online

Maximum of 8 Delegates for Face-to-Face / 6 Delegates for Online

Who Should Attend?

This program is ideal for all professionals, regardless of role or department, who need to achieve a high level of proficiency and efficiency across the core Microsoft 365 applications: Word, PowerPoint, Outlook, and Excel. It is suited for users who have a basic understanding of these tools and are keen to further their working knowledge to save time, enhance document quality, improve presentations, and streamline communication.

About The Program

This intensive four-day program serves as a comprehensive training suite, combining the intermediate-to-advanced levels of Microsoft Word, PowerPoint, Outlook, and Excel. The goal is to move participants beyond basic usage to mastering the tools and techniques that drive maximum workplace efficiency. Delegates will gain practical knowledge to create professional documents, build impactful presentations, manage communications effectively, and perform advanced data analysis and reporting. This course is essential for anyone looking to significantly expand their M365 skill set and boost their daily productivity.

Course Objectives

To explore quick ways of enhancing the appearance of your documents in Word
To understand Macros as a tool and how it can be used to record and replay a frequently used command or series of commands in Word
To learn how to standardize slides with a consistent look and feel in PowerPoint
To explore the inbuilt tools that can help you reduce the text on a PowerPoint slides
To set appointments and schedule meetings with multiple participants in Outlook
To create rules to deliver inbox messages to specific folders in Outlook and minimize clutter
To be able to use Logical, Statistical, Lookup, and Reference functions in Excel
To proficiently use Advanced Charting and PivotTables/PivotCharts in Excel

What You Will Gain

A good working knowledge of Microsoft® 365 Word
The ability to perform Mail Merges to create ‘Mailing Labels’ and ‘Form Letters’ in Word
The ability to easily create, and apply, customized designs to all your PowerPoint slides
An increased speed by using the keyboard shortcuts for frequently used PowerPoint tools
A sound working knowledge of Microsoft® 365 Outlook
An understanding of how to create tasks and appointments in Microsoft® Outlook and share them with other users
Quick and easy ways of creating and formatting multiple Excel sheets
Knowledge of how to create various reports from your data using tools like PivotTables and PivotCharts

DAY ONE

Microsoft 365 Word

Document Setup and Customization
- Customizing the Quick Access Toolbar, using Templates, and using Headers & Footers
Enhancing Appearance
- Changing Font Type, Size, Color, Case, Styles, etc., and using Borders & Shading
Structure and Layout
- Customizing Paragraph Indents / Spacing, using Tabs for easy alignment, and changing Page Settings
Working with Tables
- Inserting, formatting, merging, splitting cells, and sorting data within a table
Graphics and Media
- Inserting and formatting Pictures, Icons, 3D Graphics, and working with SmartArt
Creating Mail Merge Documents
- Using your database to prepare, print, and email your Mail Merge Documents
Automation and Forms
- Recording Macros and designing a Word Form using Developer Tab controls

Microsoft 365 Outlook

Email Management
- Formatting Email Text, Adding Signatures / Attachments, and Applying Design Themes (Custom Font / Color Palette)
Automation
- Using Quick Parts / Building Blocks and Templates, automating repetitive tasks with Quick Steps, and setting up Out of Office/Automatic Replies
Inbox Organization
- Categorizing Messages with colors, flagging messages, and creating Message Rules to deliver messages to specific folders
Searching and Filtering
- Using Multiple Criteria Searches and Query Builder to locate Outlook items, and applying Conditional Formatting to messages
Calendar Management

DAY TWO

Microsoft 365 PowerPoint

Slide Standardization
- Working with Slide Master (Customizing Layouts, Setting a Master Theme) to standardize slides
Design and Layout
- Applying and Customizing Themes, building a custom Color / Font Set, and building a Custom Background
Graphics and Objects
- Inserting and Formatting Pictures, Clip Art, Shapes, SmartArt, and Aligning / Ordering / Grouping objects
Dynamic Visuals
- Customizing the Design Ideas feature and using the Zoom Feature to build dynamic slides
Animation and Interactivity
- Customizing Animation and Transition Effects and inserting Action Buttons
Media and Links
- Inserting and Editing Audio/Video Clips and creating Hyperlinks
Finalizing the Presentation
- Using the Notes Section (Creating, Notes Page View, Notes Master) and Reviewing the presentation (Grammar / Spelling, Protecting / Comparing)

DAY THREE & FOUR

Microsoft 365 Excel

Getting Familiar With Excel
- Customizing the Ribbon / QAT, AutoFill / FlashFill, and The Quick Analysis Tool
Working With Multiple Worksheets
- Grouping worksheets, arranging new windows, and switching workbooks
Formatting & Printing
- Setting the print area, inserting headers/footers, and repeating rows / columns on printed sheets
Advanced Data Manipulation
- Using Paste Special options (Transposing Data, Pasting Links) and Conditional Formatting (Rules using Formulas/Icon Sets)
Essential Formulas & Functions
- Understanding Absolute / Mixed / Relative References, Function Syntax, and working with Statistical (COUNTIFS, AVERAGEIF, SUMIF) and Logical (AND, OR, IF) functions
Advanced Functions
- Implementing Nested Functions and Lookup Functions (XLOOKUP, VLOOKUP, INDEX, MATCH)
Creating and Working with Tables
- Formatting, Customizing the Sort Function, and Applying Single/Multiple Filters
Data Reporting & Analysis
- Inserting and working with PivotTables and PivotCharts, using Slicers/Timelines, and the Drill Down Feature
Security
- Customised Protection for your Worksheet (selective editing) and Encrypting your Workbook with a password

Before the course each delegate will be asked to complete a Pre-Course Questionnaire to determine their individual objectives for attending the course. These objectives will be used by the Tutor to give on-target training that is focused on the individual delegates.

At the end of the course each delegate will be asked to complete a Personal Development Plan that can be used as part of future appraisals, and that will also be an important tool for management reference.

Total Investment: AED 5,200/- + VAT, which includes – Training Materials, Lunch and Refreshments. Discount available for multiple bookings.

Maximum of 8 Delegates for Face-to-Face / 6 Delegates for Online

Who Should Attend?

About The Program

Course Objectives

To explore quick ways of enhancing the appearance of your documents in Word
To understand Macros as a tool and how it can be used to record and replay a frequently used command or series of commands in Word
To learn how to standardize slides with a consistent look and feel in PowerPoint
To explore the inbuilt tools that can help you reduce the text on a PowerPoint slides
To set appointments and schedule meetings with multiple participants in Outlook
To create rules to deliver inbox messages to specific folders in Outlook and minimize clutter
To be able to use Logical, Statistical, Lookup, and Reference functions in Excel
To proficiently use Advanced Charting and PivotTables/PivotCharts in Excel

What You Will Gain

A good working knowledge of Microsoft® 365 Word
The ability to perform Mail Merges to create ‘Mailing Labels’ and ‘Form Letters’ in Word
The ability to easily create, and apply, customized designs to all your PowerPoint slides
An increased speed by using the keyboard shortcuts for frequently used PowerPoint tools
A sound working knowledge of Microsoft® 365 Outlook
An understanding of how to create tasks and appointments in Microsoft® Outlook and share them with other users
Quick and easy ways of creating and formatting multiple Excel sheets
Knowledge of how to create various reports from your data using tools like PivotTables and PivotCharts

DAY ONE

Microsoft 365 Word

Document Setup and Customization
- Customizing the Quick Access Toolbar, using Templates, and using Headers & Footers
Enhancing Appearance
- Changing Font Type, Size, Color, Case, Styles, etc., and using Borders & Shading
Structure and Layout
- Customizing Paragraph Indents / Spacing, using Tabs for easy alignment, and changing Page Settings
Working with Tables
- Inserting, formatting, merging, splitting cells, and sorting data within a table
Graphics and Media
- Inserting and formatting Pictures, Icons, 3D Graphics, and working with SmartArt
Creating Mail Merge Documents
- Using your database to prepare, print, and email your Mail Merge Documents
Automation and Forms
- Recording Macros and designing a Word Form using Developer Tab controls

Microsoft 365 Outlook

Email Management
- Formatting Email Text, Adding Signatures / Attachments, and Applying Design Themes (Custom Font / Color Palette)
Automation
- Using Quick Parts / Building Blocks and Templates, automating repetitive tasks with Quick Steps, and setting up Out of Office/Automatic Replies
Inbox Organization
- Categorizing Messages with colors, flagging messages, and creating Message Rules to deliver messages to specific folders
Searching and Filtering
- Using Multiple Criteria Searches and Query Builder to locate Outlook items, and applying Conditional Formatting to messages
Calendar Management

DAY TWO

Microsoft 365 PowerPoint

Slide Standardization
- Working with Slide Master (Customizing Layouts, Setting a Master Theme) to standardize slides
Design and Layout
- Applying and Customizing Themes, building a custom Color / Font Set, and building a Custom Background
Graphics and Objects
- Inserting and Formatting Pictures, Clip Art, Shapes, SmartArt, and Aligning / Ordering / Grouping objects
Dynamic Visuals
- Customizing the Design Ideas feature and using the Zoom Feature to build dynamic slides
Animation and Interactivity
- Customizing Animation and Transition Effects and inserting Action Buttons
Media and Links
- Inserting and Editing Audio/Video Clips and creating Hyperlinks
Finalizing the Presentation
- Using the Notes Section (Creating, Notes Page View, Notes Master) and Reviewing the presentation (Grammar / Spelling, Protecting / Comparing)

DAY THREE & FOUR

Microsoft 365 Excel

Getting Familiar With Excel
- Customizing the Ribbon / QAT, AutoFill / FlashFill, and The Quick Analysis Tool
Working With Multiple Worksheets
- Grouping worksheets, arranging new windows, and switching workbooks
Formatting & Printing
- Setting the print area, inserting headers/footers, and repeating rows / columns on printed sheets
Advanced Data Manipulation
- Using Paste Special options (Transposing Data, Pasting Links) and Conditional Formatting (Rules using Formulas/Icon Sets)
Essential Formulas & Functions
- Understanding Absolute / Mixed / Relative References, Function Syntax, and working with Statistical (COUNTIFS, AVERAGEIF, SUMIF) and Logical (AND, OR, IF) functions
Advanced Functions
- Implementing Nested Functions and Lookup Functions (XLOOKUP, VLOOKUP, INDEX, MATCH)
Creating and Working with Tables
- Formatting, Customizing the Sort Function, and Applying Single/Multiple Filters
Data Reporting & Analysis
- Inserting and working with PivotTables and PivotCharts, using Slicers/Timelines, and the Drill Down Feature
Security
- Customised Protection for your Worksheet (selective editing) and Encrypting your Workbook with a password

Please contact us for specific details on the courses we are running. Our Business Development Team will be happy to provide you with further details.

Before the course, each delegate will be asked to complete a Pre-Course Briefing Form to determine their individual objectives for attending the course. These objectives will be used by the Tutor to give on-target training that is focused on the individual delegates.

At the end of the course, each delegate will be asked to complete a Personal Development Plan that can be used as part of future appraisals, and that will also be an important tool for management reference.

Microsoft® 365 Essentials

Mastering Word, PowerPoint, Outlook, And Excel For Workplace Productivity

4 Day(s)

4 Day(s)

Select Date & Location

Select Date

Maximum of 8 Delegates for Face-to-Face / 6 Delegates for Online

Who Should Attend?

About The Program

Course Objectives

What You Will Gain

Maximum of 8 Delegates for Face-to-Face / 6 Delegates for Online

Who Should Attend?

About The Program

Course Objectives

What You Will Gain

Reviews

More Courses

Goal Setting

1 Day(s)

Office Management & Administration

3 Day(s)

Leading High Performance Teams For Stronger Business Performance

2 Day(s)

Strategic Thinking & Planning

2 Day(s)

Event Management

2 Day(s)

Professional Sales Skills – The Key Elements Of Successful Selling

3 Day(s)

Microsoft® 365 Essentials

Mastering Word, PowerPoint, Outlook, And Excel For Workplace Productivity

4 Day(s)

4 Day(s)

Select Date & Location

Select Date

Additional Dates

Maximum of 8 Delegates for Face-to-Face / 6 Delegates for Online

Who Should Attend?

About The Program

Course Objectives

What You Will Gain

Maximum of 8 Delegates for Face-to-Face / 6 Delegates for Online

Who Should Attend?

About The Program

Course Objectives

What You Will Gain

Reviews

More Courses

Goal Setting

1 Day(s)

Office Management & Administration

3 Day(s)

Leading High Performance Teams For Stronger Business Performance

2 Day(s)

Strategic Thinking & Planning

2 Day(s)

Event Management

2 Day(s)

Professional Sales Skills – The Key Elements Of Successful Selling

3 Day(s)

In-Company Inquiry