• LOGIN
  • No products in the basket.

Mastering Microsoft Office 2021

Master Microsoft Office 2021 with our comprehensive course. From Excel to PowerPoint and Word, learn essential tools and techniques for enhanced productivity and efficiency.

0 STUDENTS ENROLLED

Choose Your Plan

**Additional shipping charge will be added for international delivery outside UK
TAKE THIS COURSE

Learning Outcome

Sneak Peek

Course Overview

Unlock the full potential of Microsoft Office 2021 with our comprehensive “Mastering Microsoft Office 2021” course. Whether you’re a beginner or an experienced user, this in-depth training program covers all the essential tools and features of Excel, PowerPoint, and Word, empowering you to become a proficient user of the latest Office suite. From basic functionalities to advanced techniques, dive into each application’s intricacies through hands-on tutorials and practical exercises. Elevate your productivity and efficiency with the latest tips, tricks, and best practices in Microsoft Office 2021.

Begin your journey with an introduction to Microsoft Office 2021, understanding its interface and navigation. Master Excel 2021’s powerful data handling capabilities, from basic functions to advanced formulas and pivot tables. Delve into PowerPoint 2021, learning to create impactful presentations with multimedia, animations, and transitions. Finally, explore the features of Word 2021, from document formatting and styles to mail merges and review processes. By the end of this masterclass, you’ll be equipped with the skills and confidence to tackle any task in Microsoft Office 2021 with ease.

Course Description 

This course is an excellent learning opportunity for those who are passionate about the topic and who are interested in a successful career within the relevant industry. Professionals currently working in this field who wish to brush up on their knowledge and advance their careers may also enrol in this program.   

In the Mastering Microsoft Office 2021 Course, you will find a number of engaging, in-depth modules that will provide you with comprehensive theoretical knowledge that will enable you to succeed in your career. As proof of your completion, you will receive a free e-certificate from Learndrive.

Using computers, tablets, smartphones, and other internet-enabled devices, you can access the course modules at your own pace. Invest in your professional development today and learn skills that will lead to your dream job. Become a career leader by taking this course online.

What Do You Get With The Mastering Microsoft Office 2021 Course?

  • Premium Video Materials in bite-sized format for the most accessible learning experience
  • Free e-certificate after completing the course
  • Flexible study time and pace
  • Instructor-led Course

Course Design

Students can access the course using any internet-connected device through our online learning platform. You may study at your own pace since there are no formal deadlines or teaching schedules.

Certification

The learners who pass the course will receive a Learndrive Certificate as a badge of accomplishment. The e-certificate is free of charge. There is a small fee, however, if you want a hard copy of your certificate.

Who Is This Course For?

The course is right for you if you already work in this industry or want to make the transition. This Mastering Microsoft Office 2021 Course is designed to enhance your expertise and improve your CV. 

Requirements

Students from all backgrounds are welcome to participate in the online training. There are no requirements for participation. The only prerequisite for studying this Mastering Microsoft Office 2021 Course is an interest in learning and a good grasp of English, mathematics, and computer skills.

Course Instructor

Mr. Sudha Sekhar is a distinguished IT Specialist and Co-Founder of Harisystems. His expertise encompasses web development technologies such as Python, C# Asp.Net, PHP, HTML, CSS, and JavaScript, along with profound knowledge in database systems including MS-SQL, MySQL, and MongoDB. 

He is proficient in server administration across various operating systems like LINUX and Windows. At Harisystems, he has been instrumental in creating innovative, real-world based online courses targeting developers, engineers, and business professionals. 

His teaching philosophy focuses on simplifying complex concepts, providing high-quality course materials, and utilizing real-time examples to enhance learning. His dedication lies in guiding students and professionals towards making informed career decisions in the ever-evolving digital world.

Accreditation

This course is accredited by CPDQE. The demand for professionals to engage in Continuing Professional Development is escalating, irrespective of the industry, career stage, or job function. CPD serves as an impactful mechanism for skill enhancement, maintaining the relevance of academic credentials, and strategically advancing one’s career. 

This CPDQE Certified Course will ensure that you have obtained the required CPD trainings for your professional development.

Demo Certificate

Course Curriculum

Getting Started
Introduction 00:03:00
Getting started on Windows macOS and Linux 00:01:00
How to ask great questions 00:01:00
FAQs 00:01:00
Excel 2021: Basics
Excel Overview 00:05: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:06:00
Excel 2021: Row, Columns, and Cells
Adding Rows and Columns 00:03:00
Modifying Rows and Column lengths 00:05:00
Excel 2021: Data Handling
Copy Cut and Paste 00:07:00
Copying Formulas 00:03:00
Excel 2021: Page Setting Up and print
Page setup options 00:06:00
Fit to print on One Page 00:03:00
Print Workbooks 00:03:00
Excel 2021: Sorting and Filtering
Sorting Data Ascending Order 00:04:00
Sorting Data Descending Order 00:02:00
Filter Data 00:04:00
Excel 2021: Writing Formulas
Basic formula operations 00:06:00
Date time functions 00:06:00
Mathematical functions phase 1 00:20:00
Mathematical functions phase 2 00:12:00
Excel 2021: Advanced Formulas
VLookup formula 00:12:00
HLookup formula 00:04:00
Excel 2021: XLOOKUP Only for 2021 and Office 365
XLookup 00:08:00
Handling NA and Approximates match in XLookup 00:11:00
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:06:00
Import Data from .CSV files 00:03:00
Excel 2021: Formatting Data and Tables
Formatting Font 00:04:00
Formatting Alignment 00:06:00
Formatting Number 00:05:00
Formatting Date 00:04:00
Formatting tables 00:05:00
Excel 2021: Pivot Tables
Creating Pivot Table 00:07:00
Pivot charts 00:02:00
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
PowerPoint 2021: Introduction
Overview 00:04:00
Start PowerPoint Presentation 00:05:00
Screen setting and Views 00:05:00
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
PowerPoint 2021: Text and Bullet Options
Formatting Text 00:05:00
Slide Text Alignments 00:03:00
Multi-Column Text Alignments 00:02:00
Adding Bullets and Numbered List Items 00:03:00
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
PowerPoint 2021: Picture Formatting
Picture Options 00:04:00
Picture Cropping 00:03:00
Applying Built-in Picture Styles 00:04:00
PowerPoint 2021: SmartArt Graphics
Add SmartArt Graphic 00:03:00
Modifying SmartArt 00:03:00
Creating a Target Chart using SmartArt 00:03:00
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
PowerPoint 2021: Working with Charts
Add a Chart 00:02:00
Formatting Charts 00:02:00
Insert Chart from Microsoft Excel 00:03:00
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:03:00
PowerPoint 2021: Working with Transition
Applying Transitions to Presentation 00:04:00
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
PowerPoint 2021: Slideshow Affects
Onscreen Presentation 00:02:00
Hiding Slides 00:02:00
Copying Slides 00:02:00
Changing Order of Slides 00:02:00
Word 2021: Introduction
Overview of MS Word 00:04:00
Start MS Word 2021 00:05:00
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
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
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
Word 2021: Styles
Working with Styles 00:02:00
Creating Styles 00:02:00
Clear Formatting 00:01:00
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
Word 2021: Envelops and Levels
Create envelops 00:02:00
Creating labels 00:02:00
Word 2021: Mail Merges
Creating a mail merge document 00:03:00
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

Course Reviews

N.A

ratings
  • 5 stars0
  • 4 stars0
  • 3 stars0
  • 2 stars0
  • 1 stars0

No Reviews found for this course.

Choose Your Plan

**Additional shipping charge will be added for international delivery outside UK
TAKE THIS COURSE