Name: Mastering Microsoft Office: Word, Excel, PowerPoint, and 365
Price: 25 GBP

GET THIS COURSE AND 2500+ OTHERS FOR ONLY £49 FIND OUT MORE

Home
Curriculum

Overview:

Welcome to “Mastering Microsoft Office: Word, Excel, PowerPoint, and 365,” your gateway to becoming proficient in the essential tools for productivity and data management. This course provides a comprehensive exploration of Microsoft Office applications, empowering you with the skills needed to create professional documents, analyze data effectively, and deliver compelling presentations. With hands-on exercises and practical guidance, you’ll unlock the full potential of Word, Excel, PowerPoint, and the collaborative features of Office 365.

Interactive video lectures by industry experts
Instant e-certificate and hard copy dispatch by next working day
Fully online, interactive course with Professional voice-over
Developed by qualified first aid professionals
Self paced learning and laptop, tablet, smartphone friendly
24/7 Learning Assistance
Discounts on bulk purchases

Main Course Features:

Detailed tutorials covering Word, Excel, PowerPoint, and Office 365
Practical exercises to reinforce learning
Tips and tricks for efficient document creation, data analysis, and presentation design
Guidance on leveraging advanced features and functionalities
Real-world examples and case studies for practical application

Who Should Take This Course:

Detailed tutorials covering Word, Excel, PowerPoint, and Office 365
Practical exercises to reinforce learning
Tips and tricks for efficient document creation, data analysis, and presentation design
Guidance on leveraging advanced features and functionalities
Real-world examples and case studies for practical application

Learning Outcomes:

Master document creation and formatting in Microsoft Word
Excel in data analysis and visualization using Microsoft Excel
Design compelling presentations with Microsoft PowerPoint
Utilize collaborative features of Office 365 effectively
Automate tasks and workflows using advanced features
Create professional reports, spreadsheets, and presentations
Improve productivity through efficient use of Office applications
Gain practical skills applicable to various industries and professions

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.

Assessment

At the end of the Course, there will be an online assessment, which you will need to pass to complete the course. Answers are marked instantly and automatically, allowing you to know straight away whether you have passed. If you haven’t, there’s no limit on the number of times you can take the final exam. All this is included in the one-time fee you paid for the course itself.

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:06: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:04: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:02: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:02: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
	Format painter	00:04: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