Complete Microsoft Office Diploma (Excel, Word, PowerPoint, and Microsoft 365) - Royal Open College

Back

Home
Courses
Team Training
Blog
About Us
Contact Us

Home
Courses
Team Training
Blog
About Us
Contact Us
- Register Login
- 0

Curriculum

35 Sections
136 Lessons
Lifetime

Expand all sectionsCollapse all sections

Getting Started
4
- 1.1
  Introduction
- 1.2
  Getting started on Windows, macOS, and Linux
- 1.3
  How to ask great questions
- 1.4
  FAQ’s
Excel : Basics
7
- 2.0
  Excel Overview
- 2.1
  Start Excel Spreadsheet
- 2.2
  Enter Text and Numbers
- 2.3
  Relative References
- 2.4
  Working with ranges
- 2.5
  Save and Save as Actions
- 2.6
  File Extensions, Share, Export, and Publish files
Excel : Rows, Columns, and Cells
2
- 3.0
  Adding Rows and Columns
- 3.1
  Modifying Rows and Column lengths
Excel : Data Handling
2
- 4.0
  Copy, Cut, and Paste
- 4.1
  Copying Formulas
Excel : Page Setting Up and Print
3
- 5.1
  Page Setup Options
- 5.2
  Fit to Print on One Page
- 5.3
  Print Workbooks
Excel : Sorting and Filtering
3
- 6.0
  Sorting Data Ascending Order
- 6.1
  Sorting Data Descending Order
- 6.2
  Filter Data
Excel : Writing Formulas
4
- 7.0
  Creating Basic Formulas
- 7.1
  Datetime Formulas
- 7.2
  Mathematical formulas phase 1
- 7.3
  Mathematical formulas phase 2
Excel : Advanced Formulas
2
- 8.0
  VLOOKUP formula
- 8.1
  HLOOKUP formula
Excel : XLOOKUP only for 2021 and Office 365
2
- 9.0
  XLOOKUP
- 9.1
  Handling and Approximates match in XLOOKUP
Excel : Data and Tools
6
- 10.0
  Split Text into columns
- 10.1
  Flash Fill
- 10.2
  Data Validation
- 10.3
  Remove Duplicates
- 10.4
  Import Data from Text files
- 10.5
  Import Data from .CSV files
Excel : Formatting data and tables
5
- 11.0
  Formatting Font
- 11.1
  Formatting Alignment
- 11.2
  Formatting Numbers
- 11.3
  Formatting Date
- 11.4
  Formatting Tables
Excel : Pivot Tables
2
- 12.0
  Pivot Tables
- 12.1
  Pivot Charts
Excel : Charts
7
- 13.0
  Excel Charts – Categories
- 13.1
  Elements of a chart
- 13.2
  Creating Charts
- 13.3
  Column or Bar charts
- 13.4
  Line Charts
- 13.5
  Formatting charts
- 13.6
  Pie and Doughnut charts
PowerPoint : Course Introduction
3
- 14.0
  Overview
- 14.1
  Start PowerPoint Presentation
- 14.2
  Screen setting and Views
PowerPoint : Basics
5
- 15.0
  Presentation Tips and Guidelines
- 15.1
  Creating a New Presentation
- 15.2
  Working with Slides
- 15.3
  Save a Presentation
- 15.4
  Print Slides
PowerPoint : Text and Bullet Options
4
- 16.0
  Formatting Text
- 16.1
  Slide Text Alignments
- 16.2
  Multi-Column Text Alignments
- 16.3
  Adding Bullets and Numbered List Items
PowerPoint : Adding Graphic Assets
5
- 17.0
  Insert Shapes
- 17.1
  Insert Icons
- 17.2
  Insert Graphics
- 17.3
  Add 3D Models
- 17.4
  Insert Pictures
PowerPoint : Picture Formatting
3
- 18.0
  Picture Options
- 18.1
  Picture Cropping
- 18.2
  Applying Built-in Picture Styles
PowerPoint : SmartArt Graphics
3
- 19.0
  Add SmartArt Graphic
- 19.1
  Modifying SmartArt
- 19.2
  Creating a Target Chart using SmartArt
PowerPoint : Working with Tables
4
- 20.0
  Create a Table on Slide
- 20.1
  Formatting Tables
- 20.2
  Inserting Tables
- 20.2
  Table Layouts
PowerPoint : Working with Charts
3
- 21.0
  Add a Chart
- 21.1
  Formatting Charts
- 21.2
  Insert Chart from Microsoft Excel
PowerPoint : Adding Multimedia
3
- 22.0
  Adding Video to a Presentation
- 22.1
  Adding Audio to a Presentation
- 22.2
  Screen Recording and Adding
PowerPoint : Working with Transition
1
- 23.0
  Applying Transitions to Presentation
PowerPoint : Animation
4
- 24.0
  Object Animation
- 24.1
  Effect Options
- 24.2
  Advanced Animation
- 24.3
  Triggers to control animation
PowerPoint : Slideshow Effects
4
- 25.0
  Onscreen Presentation
- 25.1
  Hiding Slides
- 25.2
  Changing Order of Slides
- 25.3
  Copying Slides
Word : Introduction
2
- 26.0
  Overview of MS Word
- 26.1
  Start MS Word
Word : Basics
6
- 27.0
  Create a new blank document
- 27.1
  Creating a paragraph text
- 27.2
  Non-printing characters
- 27.3
  Save a document
- 27.4
  Open a document
- 27.5
  Find and replace
Word : Word Formatting
8
- 28.0
  AutoCorrect options
- 28.1
  Formatting text
- 28.2
  Copy cut and paste
- 28.3
  Character formatting
- 28.4
  Format painter
- 28.5
  Work with numbers
- 28.6
  Add bullets
- 28.7
  Outline creation
Word : Tables
10
- 29.0
  Creating a table
- 29.1
  Adding rows and columns to a table
- 29.2
  Formatting table data
- 29.3
  Borders and shading
- 29.4
  Sorting in a table
- 29.5
  Draw a table
- 29.6
  Convert text to table
- 29.7
  Convert table to text
- 29.8
  Insert a spreadsheet
- 29.9
  Quick tables – readily available formats
Word : Styles
3
- 30.0
  Working with styles
- 30.1
  Creating styles
- 30.2
  Clear formatting
Word : Page Layout
7
- 31.1
  Margins
- 31.2
  Orientation
- 31.3
  Page Size Settings
- 31.4
  Adding columns
- 31.5
  Page break section break
- 31.6
  Adding watermark
- 31.7
  Headers and footers
Word : Envelops and Lables
2
- 32.0
  Create envelops
- 32.1
  Creating labels
Word : Mail Merges
1
- 33.0
  Creating a mail merge document
Word : Review and Printing
5
- 34.0
  Thesaurus and spell check
- 34.1
  Word count
- 34.2
  Speech – read aloud
- 34.3
  Language – translate
- 34.4
  Tracking
Order Certificate
1
- 35.0
  Certificate

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

Picture Options

Applying Built-in Picture Styles

Royal Open College

info@royalopencollege.org
+447441476435

Facebook Twitter Linkedin

Navigation

Blog
About Us
Contact Us
Privacy Policy
Terms & Conditions

Importants Links

FAQs
Certificate
Transcript
Redeem Voucher
Become an Instructor

Copyright © Royal Open College. All Rights Reserved.

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