MASTERING MICROSOFT OFFICE ESSENTIALS

2^nd– 6^th March, 2026                                                                                                              8^th-12^th June, 2026

24^th-28^th August, 2026                                                                                                          23^rd-27^th November, 2026      

Introduction

Microsoft Office is a suite of applications designed to help with productivity and completing common tasks on a computer. You can create and edit documents containing text and images, work with data in spreadsheets and databases, and create presentations and posters. The Microsoft Office Specialist is considered an integral part of many businesses as they skillfully use an office suite to perform essential daily duties like written correspondence through MS- word, email programs, analyzing data sets, presentation among others.

MS Word- First launched in 1983, its main function is to create text files.

MS Excel-First launched in 1985, its main function is to create spreadsheets.

MS PowerPoint-First launched in 1987, its main function is to create presentations.

MS Access- First launched in 1992, its main function is Database Management.

This workshop will walk the participants through the nitty gritty of Microsoft Excel, PowerPoint and word document.

 Course Contents

 Day One: Basic Excel Skills

• Introduction to Excel: Understanding the interface, navigating worksheets, and using basic shortcuts.
• Data Entry and Formatting: Entering
  text, numbers, and dates, formatting cells (font, size, color), and using basic data types.
• Simple Calculations and Formulas: Performing
  basic arithmetic operations, using AutoSum, and understanding relative and absolute cell references.
• Working with Worksheets: Creating,
  saving, opening, and managing multiple worksheets, basic print settings.
• Basic Data Formatting: Formatting
  cells (numbers, dates, currency), adjusting column width and row height, and adding borders.
• Basic Charts and Graphs: Creating simple charts (bar, line, pie), and formatting them.
• Sorting and Filtering: Sorting data and using simple data filters. 

Day Two: Intermediate Excel Skills

• Advanced Formulas and Functions: Using logical functions (IF, AND, OR), text functions (LEFT, RIGHT, MID, LEN, CONCATENATE), and lookup functions (VLOOKUP, HLOOKUP). 
• Data Analysis: Analyzing data using techniques like sorting, filtering, and subtotals. 
• Pivot Tables and Charts: Creating and manipulating pivot tables and charts for data summarization and analysis. 
• Conditional Formatting: Applying conditional formatting rules to highlight data based on specific criteria. 
• Data Validation: Implementing data validation rules to control the type of data entered into cells. 
• Advanced Formatting: Using more advanced formatting options, such as creating custom number formats and using cell styles. 
• Working with Dates and Times: Using date and time functions and formatting. 
• Data Import and Export: Importing data from other sources and exporting data to different formats. 
• Goal Seek and Scenario Analysis: Using Goal Seek to find the input needed to achieve a desired result, and exploring different scenarios. 

 Day Three: Basic Features of PowerPoint Presentation

 I. Introduction to PowerPoint:

• Getting Started: Familiarizing yourself with the PowerPoint interface, including the
  ribbon, Quick Access Toolbar, and status bar. 
• Creating a New Presentation: Opening PowerPoint, creating a new presentation, and
  choosing a template or theme. 
• Working with Slides: Adding, deleting, and rearranging slides, and understanding different slide layouts. 
• Text Formatting: Adding and formatting text, using bulleted and numbered lists, and
  utilizing outline view. 
• Basic Text Editing: Inserting and deleting text, using the mini toolbar for formatting, and exploring autocorrect features. 

II. Adding Visual Elements:

• Inserting Pictures and Graphics: Adding pictures, cropping photos, and adjusting image properties. 
• Working with Shapes: Creating and editing shapes, using lines and arrows, and creating graphics using shapes. 
• Adding Tables and Charts: Creating and designing tables, creating and designing charts, and importing data from other sources like Excel. 
• Using SmartArt: Creating and editing SmartArt graphics to visually represent information. 

Day Four: A deep Dive into PowerPoint (Intermediate)

III. Enhancing Presentations:

• Applying Design Themes: Choosing and customizing design themes to give your
  presentation a consistent look and feel. 
• Adding Animations and Transitions: Creating animations for text and objects, and adding transitions between slides. 
• Using the Slide Master: Understanding and customizing the slide master for consistent formatting across the presentation. 
• Adding Multimedia: Inserting and formatting audio and video. 
• Working with Hyperlinks and Actions: Adding hyperlinks to navigate within the presentation or to external resources. 

IV. Delivering Presentations:

• Presentation Views: Understanding different presentation views (Normal, Slide Sorter, Reading View, etc.). 
• Starting a Slide Show: Running the presentation in full-screen mode. 
• Using Presenter View: Utilizing presenter view to manage the presentation with notes and other tools. 
• Rehearsing and Delivering the Presentation: Practicing the timing and flow of the presentation. 

 V. Advanced Features:

• Customizing the Quick Access Toolbar: Adding frequently used commands for easy
  access. 
• Linking and Embedding Data: Linking or embedding data from other sources, such as Excel spreadsheets. 
• Creating Custom Slide Shows: Creating specific slide sequences for different audiences or purposes. 
• Securing and Distributing Presentations: Protecting the presentation
  with passwords and sharing it with others. 

Day Five: Microsoft Word for Professional Document

Word interface, short cut and formatting, customized ribbon-In an ideal world, every element in your document would have a style assigned to it. But if you’ve relied on local formatting, it’s still easy to make global changes.     Translate, Spelling and grammar, Thesaurus.
 
Introducing the professional ways of doing table of contents, references, footnotes, endnotes, bibliography and index. Inserting bookmarks, hyperlinks, headers and footers, cover page, number pages,  tables, excel table in word, clip art, pictures and chart Ms-word Alignment tricks, random text generation, lines generation, section breaks, page break, track changes.

Duration: Five (5) days                                                                                                                                                     Fee: N350,000