- Full Price
- 1970 QR
- You Save
- 1925 QR
Fine Print
- Valid from 15 Sep – 15 Nov 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 15 Nov 2024 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.
