Microsoft Office Suite: Office 365 – Excel, Powerpoint & Word

[course_video id=”901752748″]

Nitty Gritty

• 9 hours on-demand video
• Certificate of completion
• Access on mobile, tablet and TV

Learning Outcome

• Understand the layout and functions of Microsoft Office 2021, including the essential tools for Excel, PowerPoint, and Word.
• Gain proficiency in Excel for data entry, organising data, and performing calculations using formulas and functions.
• Learn to handle large data sets in Excel, using sorting, filtering, and advanced tools like XLOOKUP and Pivot Tables.
• Master Excel’s charting tools to create visually appealing and informative data visualisations.
• Develop skills in creating professional PowerPoint presentations, including text formatting, graphic assets, and multimedia.

• Learn how to add Transitions and Animations in PowerPoint for engaging and dynamic presentations.
• Create and format documents effectively in Word, using features such as Styles, Tables, and Page Layout.
• Understand Mail Merges, Envelopes, and Labels in Word for efficient document creation.
• Enhance your ability to work with data in Word, Excel, and PowerPoint, improving overall productivity.
• Apply the knowledge gained from this course to complete real-world tasks and professional projects effectively.

Course Overview

The Mastering Microsoft Office 2021 course is designed to equip learners with in-depth knowledge and practical skills in Microsoft Office applications, including Excel, PowerPoint, and Word. This comprehensive course is ideal for anyone looking to enhance their skills in Microsoft Office, whether you’re a beginner or an intermediate user aiming to refine your abilities for personal or professional use.

The course begins with a Getting Started section, introducing you to the layout and features of Microsoft Office 2021. From there, you will dive into Excel 2021, where you will start by learning the basics, such as navigating rows, columns, and cells. You’ll explore Data Handling, which includes tasks like data entry and organization, and learn how to set up pages and print from Excel. The course also covers advanced techniques, such as Sorting and Filtering, Writing Formulas, and Advanced Formulas, equipping you with the tools to manipulate and analyze data effectively.

A major highlight of Excel 2021 is the introduction of XLOOKUP, a powerful tool for data lookup, which is only available for 2021 and Office 365 versions. You’ll also cover Data and Tools, Formatting Data and Tables, and Pivot Tables, enabling you to manage large data sets efficiently. The section concludes with Charts, where you will learn to visualize data with professional charts, ensuring that your presentations are both informative and visually appealing.

Next, the course transitions to PowerPoint 2021, where you will begin with an Introduction and then explore the basics of creating slides. The course covers Text and Bullet Options, guiding you on how to format text for impact. You’ll also learn how to add Graphic Assets, Picture Formatting, and SmartArt Graphics to make your presentations more engaging. Further, you’ll explore working with Tables and Charts in PowerPoint, learn to add Multimedia, and understand Transitions and Animations. By the end of the PowerPoint section, you will be equipped to create professional and dynamic presentations that leave a lasting impression.

The course concludes with the Word 2021 section, where you’ll learn the basics of Word Formatting and working with Tables. You will discover how to use Styles to maintain consistency in your documents and master Page Layout for effective document design. The course also covers Envelopes and Labels, Mail Merges, and Review and Printing, making you proficient in document creation, editing, and printing.

With each section, you’ll gain practical skills that can be applied immediately, from managing data in Excel to creating impactful presentations in PowerPoint and writing professional documents in Word. The course concludes with the option to Order Your Transcript, allowing you to showcase your new skills.

By the end of the Mastering Microsoft Office 2021 course, you will be confident in using Excel, PowerPoint, and Word, enabling you to work efficiently and effectively with Microsoft Office 2021 in any professional or personal setting.

Who This Course Is For

• Aspiring professionals who wish to enhance their skills in Microsoft Office 2021.
• Students and employees who require advanced Excel, PowerPoint, and Word skills for their career development.
• Small business owners or entrepreneurs looking to improve their office software skills for efficiency.
• HR professionals who need to create, manage, and present data and documents using Microsoft Office tools.
• Educators who want to design high-quality lessons, presentations, and administrative documents.
• Freelancers who want to use Microsoft Office for creating and managing professional client documents and reports.
• Anyone interested in mastering Microsoft Office to become more efficient in their personal or professional tasks.

Requirements

• No prior knowledge of Microsoft Office is required, although familiarity with basic computer operations is helpful.
• A computer with Microsoft Office 2021 installed is recommended for optimal learning.
• An internet connection is needed to access the course content and interactive materials.

Course Instructor

Sudha Sekhar Metla

Mr. Sudha Sekhar Metla is an expert IT Specialist and Co-Founder of Harisystems, with over 15 years of experience in web development technologies, including Excel, PowerPoint, and Word. He brings profound knowledge in various technologies like Python, PHP, JavaScript, and database systems like MS-SQL and MySQL. Mr. Sekhar’s ability to simplify complex concepts and teach hands-on, practical applications makes him an ideal instructor for mastering Microsoft Office 2021.

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.

What Students say about us

See All Reviews

Frequently Asked Questions

Everything you need to now about he product billing.

Is there a free version of Microsoft Office?

Yes, Microsoft offers free online versions of Word, Excel, and PowerPoint via Office.com with limited features.

How to get Microsoft Office for free in the UK?

You can use Office Online for free or access a free trial of Microsoft 365 from Microsoft’s official website.

How do I install Microsoft Office on my laptop for free?

Download Office Online apps for browser use, or use the free 1-month Microsoft 365 trial to install on your laptop.

How to get MS Office for free legally?

Use Office.com online apps, student/educational licenses, or Microsoft 365 free trial; avoid pirated copies.

Are old versions of Microsoft Office free?

No, older versions require a valid license to install and use legally.

Can I get Microsoft Office as a one-time purchase?

Yes, Microsoft Office Home & Student or Home & Business editions can be bought as a one-time purchase without subscription.

Can Microsoft Office be purchased outright?

Yes, certain editions like Office 2021 allow a permanent license instead of a subscription.

How much does Microsoft Office cost in the UK?

Office Home & Student 2021 is around £119.99, while Microsoft 365 Personal subscription costs £69.99/year.

Can I have Microsoft Office without a subscription?

Yes, the one-time purchase versions provide lifetime access to the core Office apps.

What is the difference between Microsoft Office and Office 365?

Microsoft Office refers to one-time purchase apps, while Office 365 (Microsoft 365) is subscription-based with cloud features and regular updates.

How to get Microsoft Office for free?

Use Office.com, download the free apps on mobile, or start a Microsoft 365 free trial.

What does the Microsoft Office consist of?

It includes Word, Excel, PowerPoint, Outlook, OneNote, Access (PC only), and Publisher (PC only).

What is included in the Microsoft Office package?

Core apps: Word, Excel, PowerPoint, Outlook; some editions also include OneNote, Access, and Publisher.

View All FAQS