Mastering Microsoft Office: Word, Excel, PowerPoint, and 365
763 Students
Mastering Microsoft Office: Word, Excel, PowerPoint, and 365 teach you everything on the topic thoroughly from scratch so you can achieve a professional certificate for free to showcase your achievement in professional life. This Mastering Microsoft Office: Word, Excel, PowerPoint, and 365 is a comprehensive, instructor-guided course, designed to provide a detailed understanding of the nature of the related sector and …
Mastering Microsoft Office: Word, Excel, PowerPoint, and 365 teach you everything on the topic thoroughly from scratch so you can achieve a professional certificate for free to showcase your achievement in professional life. This Mastering Microsoft Office: Word, Excel, PowerPoint, and 365 is a comprehensive, instructor-guided course, designed to provide a detailed understanding of the nature of the related sector and your key roles within it.
To become successful in your profession, you must have a specific set of skills to succeed in today’s competitive world. In this in-depth training course, you will develop the most in-demand skills to kickstart your career, as well as upgrade your existing knowledge & skills.
The training materials of this course are available online for you to learn at your own pace and fast-track your career with ease.
- Accredited by CPD
- Instant e-certificate and hard copy dispatch by next working day
- Fully online, interactive course with Professional voice-over
- Self paced learning and laptop, tablet, smartphone friendly
- 24/7 Learning Assistance
- Discounts on bulk purchases
Who should take the course
Anyone with a knack for learning new skills can take this Mastering Microsoft Office: Word, Excel, PowerPoint, and 365. While this comprehensive training is popular for preparing people for job opportunities in the relevant fields, it also helps to advance your career for promotions.
Certification
Once you’ve successfully completed your course, you will immediately be sent a digital certificate. Also, you can have your printed certificate delivered by post (shipping cost £3.99). All of our courses are fully accredited, providing you with up-to-date skills and knowledge and helping you to become more competent and effective in your chosen field. Our certifications have no expiry dates, although we do recommend that you renew them every 12 months.
Accreditation
All of our courses, including this Mastering Microsoft Office: Word, Excel, PowerPoint, and 365, are fully accredited, providing you with up-to-date skills and knowledge and helping you to become more competent and effective in your chosen field.
Course Curriculum
The detailed curriculum outline of our Mastering Microsoft Office: Word, Excel, PowerPoint, and 365 Course is as follows:
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
Adding rows and columns to a table
Modifying Rows and Column lengths
Copy, Cut, and Paste
Copying Formulas
Page setup options
Fit to print on One Page
Print Workbooks
Sorting Data Ascending Order
Sorting Data Descending Order
Filter Data
Creating Basic Formulas
Datetime Formulas
Mathematical formulas phase1
Mathematical formulas phase2
VLOOKUP formula
HLOOKUP formula
XLOOKUP
Handling #NA and Approximates match in XLOOKUP
Split Text into columns
Flash Fill
Data Validation
Remove Duplicates
Import Data from Text files
Import Data from .CSV files
Formatting Font
Formatting Alignment
Formatting Numbers
Formatting Date
Formatting Tables
Pivot Tables
Pivot Charts
Excel Charts – Categories
Elements of a chart
Creating Charts
Column or Bar charts
Formatting Charts
Line Charts
Pie and Doughnut charts
Overview
Start PowerPoint Presentation
Screen setting and Views
Presentation Tips and Guidelines
Creating a New Presentation
Working with Slides
Save a Presentation
Print Slides
Formatting text
Slide Text Alignments
Multi-Column Text Alignments
Adding Bullets and Numbered List Items
Insert Shapes
Insert Icons
Insert Graphics
Add 3D Models
Insert Pictures
Picture Options
Picture Cropping
Applying Built-in Picture Styles
Add SmartArt Graphic
Modifying SmartArt
Creating a Target Chart using SmartArt
Create a Table on Slide
Formatting Tables
Inserting Tables
Table Layouts
Add a Chart
Formatting Charts
Insert Chart from Microsoft Excel
Adding Video to a Presentation
Adding Audio to a Presentation
Screen Recording and Adding
Applying Transitions to Presentation
Object Animation
Effect Options
Advanced Animation
Triggers to control animation
Onscreen Presentation
Hiding Slides
Changing Order of Slides
Copying Slides
Overview of MS Word
Start MS Word 2021
Create a new blank document
Creating a paragraph text
Non-printing characters
Save a document
Open a document
Find and replace
AutoCorrect options
Formatting text
Copy cut and paste
Character formatting
Format painter
Work with numbers
Add bullets
Outline creation
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
Working with styles
Creating styles
Clear formatting
Margins
Orientation
Page size setting
Adding columns
Page break – section break
Adding watermark
Headers and footers
Create envelops
Creating labels
Creating a mail merge document
Thesaurus and spell check
Word count
Speech – read aloud
Language – translate
Tracking
Original price was: $125.$20Current price is: $20. ex VAT
SAVE 84% - OFFER ENDS SOON
 |
Take All course
for $99-
01 Year of full Course access -
Intermediate
-
Endorsed Certificate of Compleiton
-
8 hours, 22 minutes of total Unit + Quiz duration -
10 CPD Points
