course-img

Mastering Microsoft Office: Word, Excel, PowerPoint, and 365

₦120000 ₦50000
Take This Course

Overview:

Welcome to "Mastering Microsoft Office: Word, Excel, PowerPoint, and 365," your gateway to becoming proficient in the essential tools for productivity and data management. This course provides a comprehensive exploration of Microsoft Office applications, empowering you with the skills needed to create professional documents, analyze data effectively, and deliver compelling presentations. With hands-on exercises and practical guidance, you'll unlock the full potential of Word, Excel, PowerPoint, and the collaborative features of Office 365.
  • Interactive video lectures by industry experts
  • Instant e-certificate
  • Fully online, interactive course with Professional voice-over
  • Developed by qualified first aid professionals
  • Self paced learning and laptop, tablet, smartphone friendly
  • 24/7 Learning Assistance
  • Discounts on bulk purchases

Main Course Features:

  • Detailed tutorials covering Word, Excel, PowerPoint, and Office 365
  • Practical exercises to reinforce learning
  • Tips and tricks for efficient document creation, data analysis, and presentation design
  • Guidance on leveraging advanced features and functionalities
  • Real-world examples and case studies for practical application

Who Should Take This Course:

  • Detailed tutorials covering Word, Excel, PowerPoint, and Office 365
  • Practical exercises to reinforce learning
  • Tips and tricks for efficient document creation, data analysis, and presentation design
  • Guidance on leveraging advanced features and functionalities
  • Real-world examples and case studies for practical application

Learning Outcomes:

  • Master document creation and formatting in Microsoft Word
  • Excel in data analysis and visualization using Microsoft Excel
  • Design compelling presentations with Microsoft PowerPoint
  • Utilize collaborative features of Office 365 effectively
  • Automate tasks and workflows using advanced features
  • Create professional reports, spreadsheets, and presentations
  • Improve productivity through efficient use of Office applications
  • Gain practical skills applicable to various industries and professions

Certification

Once you’ve successfully completed your course, you will immediately be sent a digital certificate. All of our courses are fully accredited, providing you with up-to-date skills and knowledge and helping you to become more competent and effective in your chosen field. Our certifications have no expiry dates, although we do recommend that you renew them every 12 months.

Assessment

At the end of the Course, there will be an online assessment, which you will need to pass to complete the course. Answers are marked instantly and automatically, allowing you to know straight away whether you have passed. If you haven’t, there’s no limit on the number of times you can take the final exam. All this is included in the one-time fee you paid for the course itself.

We guarantee that all our online courses will meet or exceed your expectations. If you are not fully satisfied with a course - for any reason at all - simply request a full refund. We guarantee no hassles. That's our promise to you.

Go ahead and order with confidence!

money_back

Easy to Access
Let's Navigate Together

Course Curriculum

Section 01: Getting Started
Introduction
Getting started on Windows, macOS, and Linux
How to ask great questions
FAQ’s
Section 02: Excel 2021: Basics
Excel Overview
Start Excel Spreadsheet
Enter Text and Numbers
Relative References
Working with ranges
Save and Save as Actions
File Extensions, Share, Export, and Publish files
Section 03: Excel 2021: Rows, Columns, and Cells
Adding Rows and Columns
Modifying Rows and Column lengths
Section 04: Excel 2021: Data Handling
Copy, Cut, and Paste
Copying Formulas
Section 05: Excel 2021: Page Setting Up and Print
Page setup options
Fit to print on One Page
Print Workbooks
Section 06: Excel 2021: Sorting and Filtering
Sorting Data Ascending Order
Sorting Data Descending Order
Filter Data
Section 07: Excel 2021: Writing Formulas
Creating Basic Formulas
Datetime Formulas
Mathematical formulas phase1
Mathematical formulas phase2
Section 08: Excel 2021: Advanced Formulas
VLOOKUP formula
HLOOKUP formula
Section 09: Excel 2021: XLOOKUP only for 2021 and Office 365
XLOOKUP
Handling #NA and Approximates match in XLOOKUP
Section 10: Excel 2021: Data and Tools
Split Text into columns
Flash Fill
Data Validation
Remove Duplicates
Import Data from Text files
Import Data from .CSV files
Section 11: Excel 2021: Formatting data and tables
Formatting Font
Formatting Alignment
Formatting Numbers
Formatting Date
Formatting Tables
Section 12: Excel 2021: Pivot Tables
Pivot Tables
Pivot Charts
Section 13: Excel 2021: Charts
Excel Charts – Categories
Elements of a chart
Creating Charts
Column or Bar charts
Formatting charts
Line Charts
Pie and Doughnut charts
Section 14: PowerPoint 2021: Course Introduction
Overview
Start PowerPoint Presentation
Screen setting and Views
Section 15: PowerPoint 2021: Basics
Presentation Tips and Guidelines
Creating a New Presentation
Working with Slides
Save a Presentation
Print Slides
Section 16: PowerPoint 2021: Text and Bullet Options
Formatting Text
Slide Text Alignments
Multi-Column Text Alignments
Adding Bullets and Numbered List Items
Section 17: PowerPoint 2021: Adding Graphic Assets
Insert Shapes
Insert Icons
Insert Graphics
Add 3D Models
Insert Pictures
Section 18: PowerPoint 2021: Picture Formatting
Picture Options
Picture Cropping
Applying Built-in Picture Styles
Section 19: PowerPoint 2021: SmartArt Graphics
Add SmartArt Graphic
Modifying SmartArt
Creating a Target Chart using SmartArt
Section 20: PowerPoint 2021: Working with Tables
Create a Table on Slide
Formatting Tables
Inserting Tables
Table Layouts
Section 21: PowerPoint 2021: Working with Charts
Add a Chart
Formatting Charts
Insert Chart from Microsoft Excel
Section 22: PowerPoint 2021: Adding Multimedia
Adding Video to a Presentation
Adding Audio to a Presentation
Screen Recording and Adding
Section 23: PowerPoint 2021: Working with Transition
Applying Transitions to Presentation
Section 24: PowerPoint 2021: Animation
Object Animation
Effect Options
Advanced Animation
Triggers to control animation
Section 25: PowerPoint 2021: Slideshow Effects
Onscreen Presentation
Hiding Slides
Changing Order of Slides
Copying Slides
Section 26: Word 2021: Introduction
Overview of MS Word
Start MS Word 2021
Section 27: Word 2021: Basics
Create a new blank document
Creating a paragraph text
Non-printing characters
Save a document
Open a document
Find and replace
Section 28: Word 2021: Word Formatting
AutoCorrect options
Formatting text
Copy cut and paste
Character formatting
Format painter
Work with numbers
Add bullets
Outline creation
Section 29: Word 2021: Tables
Creating a table
Adding rows and columns to a table
Formatting table data
Borders and shading
Sorting in a table
Draw a table
Convert text to table
Convert table to text
Insert a spreadsheet
Quick tables – readily available formats
Section 30: Word 2021: Styles
Working with styles
Creating styles
Clear formatting
Section 31: Word 2021: Page Layout
Margins
Orientation
Page size setting
Adding columns
Page break – section break
Adding watermark
Headers and footers
Section 32: Word 2021: Envelops and Lables
Create envelops
Creating labels
Section 33: Word 2021: Mail Merges
Creating a mail merge document
Section 34: Word 2021: Review and Printing
Thesaurus and spell check
Word count
Speech – read aloud
Language – translate
Tracking