Complete Microsoft Office Diploma (Excel, Word, PowerPoint, and Power BI) - Learnera

Courses
Blog
About Us
Contact Us

Login

38 Sections
143 Lessons
Lifetime Access

Expand all sectionsCollapse all sections

Getting Started
4
- 1.1
  Introduction
  3 Minutes
- 1.2
  Getting started on Windows, macOS, and Linux
  2 Minutes
- 1.3
  How to ask great questions
  2 Minutes
- 1.4
  FAQ’s
  2 Minutes
Excel : Basics
7
- 2.1
  Excel Overview
  6 Minutes
- 2.2
  Start Excel Spreadsheet
  5 Minutes
- 2.3
  Enter Text and Numbers
  8 Minutes
- 2.4
  Relative References
  7 Minutes
- 2.5
  Working with ranges
  4 Minutes
- 2.6
  Save and Save as Actions
  8 Minutes
- 2.7
  File Extensions, Share, Export, and Publish files
  6 Minutes
Excel : Rows, Columns, and Cells
2
- 3.1
  Adding Rows and Columns
  3 Minutes
- 3.2
  Modifying Rows and Column lengths
  5 Minutes
Excel : Data Handling
2
- 4.1
  Copy, Cut, and Paste
  7 Minutes
- 4.2
  Copying Formulas
  3 Minutes
Excel : Page Setting Up and Print
3
- 5.1
  Page Setup Options
  6 Minutes
- 5.2
  Fit to Print on One Page
  3 Minutes
- 5.3
  Print Workbooks
  3 Minutes
Excel : Sorting and Filtering
3
- 6.1
  Sorting Data Ascending Order
  4 Minutes
- 6.2
  Sorting Data Descending Order
  3 Minutes
- 6.3
  Filter Data
  4 Minutes
Excel : Writing Formulas
4
- 7.1
  Creating Basic Formulas
  6 Minutes
- 7.2
  Datetime Formulas
  7 Minutes
- 7.3
  Mathematical formulas phase 1
  20 Minutes
- 7.4
  Mathematical formulas phase 2
  13 Minutes
Excel : Advanced Formulas
2
- 8.1
  VLOOKUP formula
  12 Minutes
- 8.2
  HLOOKUP formula
  4 Minutes
Excel : XLOOKUP only for 2021 and Office 365
2
- 9.1
  XLOOKUP
  8 Minutes
- 9.2
  Handling and Approximates match in XLOOKUP
  11 Minutes
Excel : Data and Tools
6
- 10.1
  Split Text into columns
  7 Minutes
- 10.2
  Flash Fill
  7 Minutes
- 10.3
  Data Validation
  7 Minutes
- 10.4
  Remove Duplicates
  8 Minutes
- 10.5
  Import Data from Text files
  6 Minutes
- 10.6
  Import Data from .CSV files
  4 Minutes
Excel : Formatting data and tables
5
- 11.1
  Formatting Font
  4 Minutes
- 11.2
  Formatting Alignment
  6 Minutes
- 11.3
  Formatting Numbers
  5 Minutes
- 11.4
  Formatting Date
  4 Minutes
- 11.5
  Formatting Tables
  5 Minutes
Excel : Pivot Tables
2
- 12.1
  Pivot Tables
  7 Minutes
- 12.2
  Pivot Charts
  2 Minutes
Excel : Charts
7
- 13.1
  Excel Charts – Categories
  3 Minutes
- 13.2
  Elements of a chart
  4 Minutes
- 13.3
  Creating Charts
  2 Minutes
- 13.4
  Column or Bar charts
  4 Minutes
- 13.5
  Line Charts
  3 Minutes
- 13.6
  Formatting charts
  4 Minutes
- 13.7
  Pie and Doughnut charts
  4 Minutes
PowerPoint : Course Introduction
3
- 14.1
  Overview
  4 Minutes
- 14.2
  Start PowerPoint Presentation
  5 Minutes
- 14.3
  Screen setting and Views
  5 Minutes
PowerPoint : Basics
5
- 15.1
  Presentation Tips and Guidelines
- 15.2
  Creating a New Presentation
- 15.3
  Working with Slides
- 15.4
  Save a Presentation
- 15.5
  Print Slides
PowerPoint : Text and Bullet Options
4
- 16.1
  Formatting Text
  5 Minutes
- 16.2
  Slide Text Alignments
  3 Minutes
- 16.3
  Multi-Column Text Alignments
  2 Minutes
- 16.4
  Adding Bullets and Numbered List Items
  3 Minutes
PowerPoint : Adding Graphic Assets
5
- 17.1
  Insert Shapes
  4 Minutes
- 17.2
  Insert Icons
  3 Minutes
- 17.3
  Insert Graphics
- 17.4
  Add 3D Models
- 17.5
  Insert Pictures
  3 Minutes
PowerPoint : Picture Formatting
3
- 18.1
  Picture Options
- 18.2
  Picture Cropping
  3 Minutes
- 18.3
  Applying Built-in Picture Styles
  4 Minutes
PowerPoint : SmartArt Graphics
3
- 19.1
  Add SmartArt Graphic
  3 Minutes
- 19.2
  Modifying SmartArt
  3 Minutes
- 19.3
  Creating a Target Chart using SmartArt
  3 Minutes
PowerPoint : Working with Tables
4
- 20.1
  Create a Table on Slide
  4 Minutes
- 20.2
  Formatting Tables
  2 Minutes
- 20.3
  Inserting Tables
  2 Minutes
- 20.4
  Table Layouts
PowerPoint : Working with Charts
3
- 21.1
  Add a Chart
- 21.2
  Formatting Charts
  2 Minutes
- 21.3
  Insert Chart from Microsoft Excel
  3 Minutes
PowerPoint : Adding Multimedia
3
- 22.1
  Adding Video to a Presentation
  3 Minutes
- 22.2
  Adding Audio to a Presentation
  2 Minutes
- 22.3
  Screen Recording and Adding
  3 Minutes
PowerPoint : Working with Transition
1
- 23.1
  Applying Transitions to Presentation
PowerPoint : Animation
4
- 24.1
  Object Animation
- 24.2
  Effect Options
  2 Minutes
- 24.3
  Advanced Animation
  2 Minutes
- 24.4
  Triggers to control animation
  2 Minutes
PowerPoint : Slideshow Effects
4
- 25.1
  Onscreen Presentation
  2 Minutes
- 25.2
  Hiding Slides
  2 Minutes
- 25.3
  Changing Order of Slides
  2 Minutes
- 25.4
  Copying Slides
  2 Minutes
Word : Introduction
2
- 26.1
  Overview of MS Word
  4 Minutes
- 26.2
  Start MS Word
  5 Minutes
Word : Basics
6
- 27.1
  Create a new blank document
  5 Minutes
- 27.2
  Creating a paragraph text
  5 Minutes
- 27.3
  Non-printing characters
  3 Minutes
- 27.4
  Save a document
  3 Minutes
- 27.5
  Open a document
  2 Minutes
- 27.6
  Find and replace
  4 Minutes
Word : Word Formatting
8
- 28.1
  Auto Correct options
  3 Minutes
- 28.2
  Formatting text
  4 Minutes
- 28.3
  Copy Cut and paste
  4 Minutes
- 28.4
  Character formatting
  3 Minutes
- 28.5
  Format painter
  4 Minutes
- 28.6
  Work with numbers
  2 Minutes
- 28.7
  Add bullets
  3 Minutes
- 28.8
  Outline creation
  4 Minutes
Word : Tables
10
- 29.1
  Creating a table
  3 Minutes
- 29.2
  Adding rows and columns to a table
  3 Minutes
- 29.3
  Formatting table data
  3 Minutes
- 29.4
  Borders and shading
  2 Minutes
- 29.5
  Sorting in a table
  4 Minutes
- 29.6
  Draw a table
  4 Minutes
- 29.7
  Convert Text to Table
  3 Minutes
- 29.8
  Convert Table to Text
  2 Minutes
- 29.9
  Insert a Spreadsheet
  2 Minutes
- 29.10
  Quick tables – Readily Available Formats
  2 Minutes
Word : Styles
3
- 30.1
  Working with styles
  2 Minutes
- 30.2
  Creating styles
  2 Minutes
- 30.3
  Clear formatting
  2 Minutes
Word : Page Layout
7
- 31.1
  Margins
  2 Minutes
- 31.2
  Orientation
  2 Minutes
- 31.3
  Page Size Settings
  1 Minute
- 31.4
  Adding columns
  4 Minutes
- 31.5
  Page break section break
  2 Minutes
- 31.6
  Adding Watermark
  3 Minutes
- 31.7
  Headers and footers
  3 Minutes
Word : Envelops and Lables
2
- 32.1
  Create envelops
  3 Minutes
- 32.2
  Creating labels
  2 Minutes
Word : Mail Merges
1
- 33.1
  Creating a Mail Merge Document
  4 Minutes
Word : Review and Printing
5
- 34.1
  Thesaurus and Spell Check
  1 Minute
- 34.2
  Word count
  1 Minute
- 34.3
  Speech – Read Aloud
  1 Minute
- 34.4
  Language – Translate
  1 Minute
- 34.5
  Tracking
  1 Minute
Power BI
5
- 35.1
  Module 01: Introduction to Power BI
  10 Minutes
- 35.2
  Module 02: Data Modelling
  12 Minutes
- 35.3
  Module 03: How To Analyse Data Building Part 1
  6 Minutes
- 35.4
  Module 04: Tables Structure In Data Analysis
  10 Minutes
- 35.5
  Module 05: Measure Explicit and Implicit
  6 Minutes
Leave a Review
1
- 36.1
  Leave a Review
Order Your Certificate
1
- 37.1
  Order Your Certificate
Assessment
2
- 38.1
  MCQ Assessment
  50 Minutes40 Questions
- 38.2
  Written Assignment

This content is protected, please login and enroll in the course to view this content!

Order Your Certificate

Written Assignment

Learnera provides high-quality online courses covering a variety of topics along with certificates issued by top organisations.

info@learnera.co.uk
+447478023018

Facebook Instagram Linkedin X-twitter Youtube

Explore

Blog
FAQs
About Us
Contact Us
Privacy Policy
Terms & Conditions

Blog
FAQs
About Us
Contact Us
Privacy Policy
Terms & Conditions

Important Links

Order Your Certificate
Redeem Voucher
Become an Instructor
Claim Your Pre-ordered Certificate

Order Your Certificate
Redeem Voucher
Become an Instructor
Claim Your Pre-ordered Certificate

Payment methods possible

Copyright © 2026 Learnera. All Right Reserved.

Privacy Policy | Terms & Conditions

Summer Sale

GET ANY COURSE FOR £10.99 Off ONLY !

Offer Ends In!

02 Hours 37 Minutes 00 Seconds

Copy Your Coupon

Added to cart

Your Cart Is Empty

0

Check out our shop to see what's available

Cart Total: Total£0.00

Your cart is empty. Shop now →

£424.99£19.99

Login with your site account

Lost your password?

Remember Me

Not a member yet? Register now

Register a new account

Want to become an instructor?

Are you a member? Login now

Modal title

Main Content