0
  • LOGIN

  • No products in the basket.

Overview

Overview

Grasp the science of Microsoft Office Skills: Mastering Excel, Word & PowerPoint and how it relates to launching a lucrative career. Prepare for future Microsoft Office Skills: Mastering Excel, Word & PowerPoint needs by looking beyond the ongoing Microsoft Office Skills: Mastering Excel, Word & PowerPoint impact with Discover Training’s up-to-date Microsoft Office Skills: Mastering Excel, Word & PowerPoint course .

Discover Training’s Microsoft Office Skills: Mastering Excel, Word & PowerPoint course gives you a solid foundation in Microsoft Office Skills: Mastering Excel, Word & PowerPoint in many settings of human development. With industry expert interviews, you’ll gain a greater understanding of Microsoft Office Skills: Mastering Excel, Word & PowerPoint‘s applications and limitations, as well as how it’s already been efficiently used in the field. Discover Training’s Microsoft Office Skills: Mastering Excel, Word & PowerPoint course will help you obtain facts and knowledge to strengthen your abilities on both standard Microsoft Office Skills: Mastering Excel, Word & PowerPoint techniques.

As you progress through the interactive modules of this online program, you will have a strong grasp of Microsoft Office Skills: Mastering Excel, Word & PowerPoint to identify new opportunities for innovation and drive digital growth within your organization. Enrol in the Microsoft Office Skills: Mastering Excel, Word & PowerPoint course today and leverage your knowledge tomorrow. 

Description:

Industry professionals developed the content of this online Microsoft Office Skills: Mastering Excel, Word & PowerPoint course, combining their expertise and in-depth knowledge. The curriculum was developed by Discover Training to assist you in growing in your current role by providing you with the necessary information and concepts. As you progress through the modules of this course, you’ll learn the fundamentals of  Microsoft Office Skills: Mastering Excel, Word & PowerPoint and explore the essential concepts.

Who is this course for?

This Microsoft Office Skills: Mastering Excel, Word & PowerPoint course is for you if you want to learn about the revolutionary potential of Microsoft Office Skills: Mastering Excel, Word & PowerPoint. Whether you are a newbie or a seasoned veteran, a grasp of challenges that Microsoft Office Skills: Mastering Excel, Word & PowerPoint techniques can tackle would benefit anyone working in the Microsoft Office Skills: Mastering Excel, Word & PowerPoint sector. This Microsoft Office Skills: Mastering Excel, Word & PowerPoint training covers crucial subjects that will help you overcome challenges and improve your practices.

Requirements:

  • Prerequisites: None
  • Age Limit: 16+
  • Gadgets: Smart devices and internet

Certification

Once the Microsoft Office Skills: Mastering Excel, Word & PowerPoint course is successfully completed, the learner can obtain the PDF certificate without any cost. The hardcopy version of the certificate is also available for only £9.99. However, anyone ordering the hardcopy certificate from outside the United Kingdom may need to pay an additional delivery charge.

Course Curriculum

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

FAQS

We intend to inspire and encourage everyone to seek and receive a top-notch education. We have brought together the finest and most visionary experts to help you through your learning period. Our courses are open to anyone and everyone looking for a new objective, a career changeover, or a promotion.

Yes, of course, you can. After you’ve enrolled on our site, you’ll frequently get special offers and exclusive deals. You are free to take whatever courses that suit your needs.

We will provide you with a Certificate (with an added cost) depending on the course genre you ended up taking after completing all of the mandatory tasks. Point to be noted; you must obtain a passing grade by the course’s completion date.

You will have 14 days to revoke your Course purchase from your purchase date. Regrettably, refunds are not allowed after your purchase have been approved, and materials have been posted to the student’s dashboard or accessed.

We offer various payment options depending on the country and region of your account. When you wish to acquire a course, you could look at the several payment options:

  • • Go to the course home page and click ‘Take This Course’ after selecting the course you wish to take.
  • • You’ll end up on the Checkout page, where you can choose from a number of different payment choices (credit card, debit, deposit, or bank transfer).

There are no time constraints for starting or completing any course. You are free to begin any course at any time. Furthermore, as long as your account is in good standing and we own the copyright to the course, you’ll have access to it even after you’ve finished it.

COPYRIGHT © 2021 One Education

Oops! We could not locate your form.