Complete Microsoft Office Diploma Online Course: Word, Excel, PowerPoint & 365!

45 QR 1970 QR
Full Price
1970 QR
You Save
1925 QR
No longer
available
The deal ended at:
09/12/23
11:59PM
9 bought
limited quantity available

Fine Print

  • Valid from 20 Nov 2023 – 20 Jan 2024
  • Redemption period: 2 months from the deal’s start date
  • Limit of ONE voucher per person; may buy multiple vouchers as gifts
  • Lifetime access to course content & materials
  • Vouchers not redeemed by 20 Jan 2023 will NOT be refunded
  • No mandatory completion deadline; learners can take & finish the course anytime, at their own pace
  • Upon completion, you will have the option to choose the type of certificate you would like to receive; the PDF certificate is priced at $7.99 per certificate, while the hard copy certificate is $14.99 per certificate; please keep in mind that there will be an additional delivery charge for the hard copy of your certificate
  • To be eligible for the certificate, you need to complete the course & pass each course module
  • For more information visit: Complete Microsoft Office Diploma or write to [email protected]
  • Internet access and audio required
  • You’ll get access to detailed video tutorials, practical examples, and useful tips
  • Not valid with other offers
  • No cash value/No cash back/No refunds

 

How to Redeem:

To activate your voucher and assign your course:

  • Click through this link
  • At the redemption page, you will be prompted to fill in the necessary information such as Name, Email Address, Phone Number, Voucher Code, & Course Name
  • Click Submit
  • Your access to the course will be approved within 24 hours

 

Please see the terms for all deals here

Highlights

 

Complete Microsoft Office Diploma Online Course: Word, Excel, PowerPoint & 365
Pay QR45 instead of QR1970

 

  • Learn everything you need to know to become proficient in Word, Excel, PowerPoint, and Office 365!

  • Microsoft Excel

    • A powerful spreadsheet program that is essential for analyzing data and making informed decisions
    • In this course, you’ll learn how to use Excel to create and format worksheets, perform calculations and functions, and create charts and graphs

  • Microsoft PowerPoint

    • The premier program for creating dynamic presentations that grab your audience’s attention
    • In this course, you’ll learn how to create and format slides, add multimedia elements, and use animations and transitions to bring your presentation to life

  • Microsoft Word

    • The go-to word-processing program for businesses and individuals alike
    • In this course, you’ll learn how to create and format documents, use styles and templates, work with tables and images, and more

  • Finally, you’ll learn about Office 365 access, the cloud-based suite of productivity tools that includes Word, Excel, PowerPoint, and more; you’ll discover how to collaborate with others in real-time, access your files from anywhere, and take advantage of the many benefits of cloud computing
  • No formal qualifications are required! This course is perfect for people who want to learn new skills, start a new career, or enhance their knowledge about their chosen field 
  • Lifetime access to course materials
  • Full tutor support is available Monday through Friday
  • Access informative video modules taught by expert instructors
  • 24/7 assistance & advice are available through email & live chat

 

See below for the full course outline!

Maximize Productivity with Microsoft Office!

 

Getting Started

  • Introduction
  • Getting started on Windows, macOS, and Linux
  • How to ask great questions
  • FAQ’s

Excel: 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

Excel: Rows, Columns, and Cells

  • Adding Rows and Columns
  • Modifying Rows and Column lengths

Excel: Data Handling

  • Copy, Cut, and Paste
  • Copying Formulas

Excel: Page Setting Up and Print

  • Page setup options
  • Fit to print on One Page
  • Print Workbooks

Excel: Sorting and Filtering

  • Sorting Data Ascending Order
  • Sorting Data Descending Order
  • Filter Data

Excel: Writing Formulas

  • Creating Basic Formulas
  • DateTime Formulas
  • Mathematical formulas phase1
  • Mathematical formulas phase2

Excel: Advanced Formulas

  • VLOOKUP formula
  • HLOOKUP formula

Excel: XLOOKUP

  • XLOOKUP
  • Handling #NA and Approximates match in XLOOKU

Excel: Data and Tools

  • Split Text into columns
  • Flash Fill
  • Data Validation
  • Remove Duplicates
  • Import Data from Text files
  • Import Data from .CSV files

Excel: Formatting data and tables

  • Formatting Font
  • Formatting Alignment
  • Formatting Numbers
  • Formatting Date
  • Formatting Tables

Excel: Pivot Tables

  • Pivot Tables
  • Pivot Charts

Excel: Charts

  • Excel Charts – Categories
  • Elements of a chart
  • Creating Charts
  • Column or Bar charts
  • Formatting charts
  • Line Charts
  • Pie and Doughnut charts

PowerPoint: Course Introduction

  • Overview
  • Start PowerPoint Presentation
  • Screen setting and Views

PowerPoint: Basics

  • Presentation Tips and Guidelines
  • Creating a New Presentation
  • Working with Slides
  • Save a Presentation
  • Print Slides

PowerPoint: Text and Bullet Options

  • Formatting Text
  • Slide Text Alignments
  • Multi-Column Text Alignments
  • Adding Bullets and Numbered List Items

PowerPoint: Adding Graphic Assets

  • Insert Shapes
  • Insert Icons
  • Insert Graphics
  • Add 3D Models
  • Insert Pictures

PowerPoint: Picture Formatting

  • Picture Options
  • Picture Cropping
  • Applying Built-in Picture Styles

PowerPoint: SmartArt Graphics

  • Add SmartArt Graphic
  • Modifying SmartArt
  • Creating a Target Chart using SmartArt

PowerPoint: Working with Tables

  • Create a Table on Slide
  • Formatting Tables
  • Inserting Tables
  • Table Layouts

PowerPoint: Working with Charts

  • Add a Chart
  • Formatting Charts
  • Insert Chart from Microsoft Excel

PowerPoint: Adding Multimedia

  • Adding Video to a Presentation
  • Adding Audio to a Presentation
  • Screen Recording and Adding

PowerPoint: Working with Transition

  • Applying Transitions to Presentation

PowerPoint: Animation

  • Object Animation
  • Effect Options
  • Advanced Animation
  • Triggers to control animation

PowerPoint: Slideshow Effects

  • Onscreen Presentation
  • Hiding Slides
  • Changing the Order of Slides
  • Copying Slides

Word: Introduction

  • Overview of MS Word
  • Start MS Word

Word: Basics

  • Create a new blank document
  • Creating a paragraph text
  • Non-printing characters
  • Save a document
  • Open a document
  • Find and replace

Word: Word Formatting

  • AutoCorrect options
  • Formatting text
  • Copy cut and paste
  • Character formatting
  • Format painter
  • Work with numbers
  • Add bullets
  • Outline creation

Word: 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

Word: Styles

  • Working with styles
  • Creating styles
  • Clear formatting

Word: Page Layout

  • Margins
  • Orientation
  • Page size setting
  • Adding columns
  • Page break – section break
  • Adding watermark
  • Headers and footers

Word: Envelops and Labels

  • Create envelops
  • Creating labels

Word: Mail Merges

  • Creating a mail merge document

Word: Review and Printing

  • Thesaurus and spell check
  • Word count
  • Speech – read aloud
  • Language – translate
  • Tracking

Test

 

Company Profile

Royal Open College has gained a reputation for its exceptional track record in assisting numerous professionals in their growth and career advancement. Their team of extensively experienced experts, boasting over 10 years of industry expertise, diligently equips students with cutting-edge audio-visual technology, thus augmenting their learning journey. The committed course team at Royal Open College works tirelessly to optimize the online learning experience, striving to help students achieve the utmost excellence in their endeavors. Recognizing that an employee’s or professional’s triumph in the workplace or chosen career path hinges on possessing the requisite knowledge and skills, Royal Open College remains dedicated to providing the necessary tools for success.