*#1 Most Popular Online Course & Internship in Office Productivity* You can enroll today & get certified from EasyShiksha & HawksCode.
Unlock the full potential of Microsoft Office with "Mastering Microsoft Office 2021-365: Word, Excel, PowerPoint"—a comprehensive course designed to empower you with advanced skills in the most essential productivity tools. Whether you're a student, professional, or entrepreneur, this course will take your abilities to the next level, enabling you to work smarter and more efficiently.
Start with Microsoft Excel, where you’ll transform raw data into actionable insights. Learn the fundamentals of data organization, calculations, and visualization. Progress to advanced topics like pivot tables, conditional formatting, and powerful functions such as VLOOKUP, HLOOKUP, and IF statements. Excel automation with formulas will also be introduced to save time and boost productivity.
Move on to Microsoft PowerPoint to create stunning presentations. Learn to design slides with impactful layouts, animations, and transitions. Discover how to embed multimedia, collaborate in real-time, and deliver presentations that leave a lasting impression.
Finally, dive into Microsoft Word, where you’ll learn to create polished, professional documents. Master essential features like formatting, styles, tables, and templates. Explore advanced capabilities like mail merge, collaboration tools, and integrating graphics and charts to make your documents stand out.
Throughout the course, you’ll engage with hands-on projects and real-world examples to reinforce your learning. By the end, you’ll be proficient in using Word, Excel, and PowerPoint, ready to tackle personal, academic, and professional tasks with confidence.
Introduction
Getting started on Windows, macOS, and Linux
How to ask great questions
FAQโs
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
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
Copying Slides
Changing Order of 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
The following course is fully online, and hence there is no need for any physical classroom session. The lectures and assignments can be accessed anytime and anywhere through a smart web or mobile device.
Anyone can choose a preferred course and start immediately without any delay.
As this is a purely online course program, you can choose to learn at any time of the day and for as much time as you want. Though we follow a well-established structure and schedule, we recommend a routine for you as well. But it finally depends on you, as you have to learn.
If you have completed the course, you would be able to have lifetime access to it for future reference too.
Yes, you can access and download the content of the course for the duration. And even have lifetime access to it for any further reference.
All the software/tools that you need for the course would be shared with you during the training as and when you need them.
No, only a soft copy of the certificate will be awarded, which can be downloaded and printed, if required.
You can try to make the payment through a different card or account (maybe a friend or family). If the problem persists, email us at info@easyshiksha.com
Due to some technical faults, this can happen. In such a case the amount deducted will be transferred to the bank account in the next 7-10 working days. Normally the bank takes this much time to credit the amount back into your account.
At times, there may be a slight delay in your payment reflecting on your EasyShiksha dashboard. However, if the problem is taking longer than 30 minutes, please let us know by writing to us at info@easyshiksha.com from your registered email id, and attach the screenshot of the payment receipt or transaction history. Soon after verification from the backend, we will update the payment status.
If you have enrolled, and are facing any technical problem then you can request a refund. But once the certificate has been generated, we shall not refund that.
Yes! You surely can. To begin this, just click the course of your interest and fill in the details to enrol. You are ready to learn, once the payment is made. For the same, you earn a certificate too.
Please contact us at: info@easyshiksha.com
Discover thousands of colleges and courses, enhance skills with online courses and internships, explore career alternatives, and stay updated with the latest educational news..
Gain high-quality, filtered student leads, prominent homepage ads, top search ranking, and a separate website. Let us actively enhance your brand awareness.
Download EasyShiksha Mobile Apps from Android Play Store, Apple App Store, Amazon App Store, and Jio STB.
1 million+ย learned on the EasyShiksha App
OUR GROUP
Hawkscode
The National TV
FoodNosher
Nutrivict
MoonDela
CodeGuru
