Mastering Microsoft Office 2021-365: Word, Excel, PowerPoint
Microsoft Office 2021: Boost Your Productivity and Professionalism with Expert Instruction and Hands-On Practice
Office Productivity,Microsoft,Microsoft 365(Office)
Lectures -135
Duration -8 hours
Lifetime Access
Lifetime Access
30-days Money-Back Guarantee
Get your team access to 10000+ top Tutorials Point courses anytime, anywhere.
Course Description
The first part of the course covers Microsoft Excel, where you will learn how to make data from unprocessed raw data, everyday information that you can use for insights. This includes the basic principles of organizing data, calculating, and visualizing data. These principles will also take you into advanced topics that include pivot tables, conditional formats, 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. You will learn how to design slides using purposeful layouts, many types of animations and transitions. You will learn how to embed multimedia, collaborate in real time and present information which has an impact.
Finally, you will get into Microsoft Word and learn how to create cohesive, polished, professional documents. You will learn the basics including formatting, styles, tables and templates. Then, you will move on to advanced features such as mail merge, collaboration, graphics, and charts which will allow you to characterize your documents and make them visually engaging.
As you have been given hands-on projects and examples from the world of business, the learning process will help reinforce the objectives. You will either be able to use Word, Excel, and PowerPoint efficiently; or complete personal, academic, and professional tasks with confidence. Get more productive and get started, enrol for Microsoft Office 2021-365 today!
Who can benefit from this course:
- Business professionals creating professional-level documents, spreadsheets and presentations
- Students using Microsoft Office for projects or assignments.
- Job seekers using Microsoft Office as a way to advance their careers.
- Anyone wanting to learn Office 365 for productivity and collaboration.
- Freelancers, entrepreneurs, and small business owners using Word or Power point to create professional documents or presentations.
- Anyone wanting to increase their productivity and efficiency by using Microsoft Office tools.
Goals
- Learn the essential Microsoft Office Skills in these three courses: Word, Excel, and PowerPoint
- Apply new and improved features in Excel 2021 and Office 365
- How to use Microsoft Word to create, format, and edit documents
- Work with styles, templates, tables, and images in Word
- Learn to use Microsoft Excel to create, format, and analyze data in spreadsheets
- Effectively use formulas, functions, charts, and graphs in Excel
- Master of VLOOKUP, XLOOKUP, and Pivot table to create speedy Data Analytics
- Use to apply Microsoft PowerPoint to create dynamic and engaging presentations
- Add multimedia elements, animations, and transitions in PowerPoint
- Access and manage files from anywhere using Office 365, Gen AI
- Take advantage of the many benefits of cloud computing with Office 365
- Expert Tips and tricks to improve your productivity and efficiency in Microsoft Office.
- Learn time-saving techniques including how to copy slides, and set your presentation
- Control page appearance including using columns, indents, footers, borders, and watermarks.
- How to create a mail merge in Microsoft Word
- Learn how to correctly Print envelopes and labels in Word
- Make your Word documents look amazing by inserting and editing tables
- Participate in Practice test to test your learning skills
Prerequisites
- You will need a PC with Microsoft Office Suit installed or Office 365 Access
- No prior technical experience is required!

Curriculum
Check out the detailed breakdown of what’s inside the course
Getting started
4 Lectures
-
Introduction 02:58 02:58
-
Getting started on Windows, macOS, and Linux 01:21 01:21
-
How to ask great questions 01:14 01:14
-
FAQ’s 01:19 01:19
Excel 2021: basics
7 Lectures

Excel 2021: rows, columns, and cells
2 Lectures

Excel 2021: data handling
2 Lectures

Excel 2021: page setting up and print
3 Lectures

Excel 2021: sorting and filtering
3 Lectures

Excel 2021: writing formulas
4 Lectures

Excel 2021: advanced formulas
2 Lectures

Excel 2021: XLOOKUP only 2021 and office 365
2 Lectures

Excel 2021: data and tools
6 Lectures

Excel 2021: formatting data and tables
5 Lectures

Excel 2021: pivot tables
2 Lectures

Excel 2021: charts
7 Lectures

Powerpoint 2021: introduction
3 Lectures

Powerpoint 2021: basics
5 Lectures

Powerpoint 2021: text and bullet options
4 Lectures

Powerpoint 2021: adding graphic assets
5 Lectures

Powerpoint 2021: picture formatting
3 Lectures

Powerpoint 2021: smart art graphics
3 Lectures

Powerpoint 2021: working with tables
4 Lectures

Powerpoint 2021: working with charts
3 Lectures

Powerpoint 2021: adding multimedia
3 Lectures

Powerpoint 2021: working with transition
1 Lectures

Powerpoint 2021: animation
4 Lectures

Powerpoint 2021: slideshow effects
4 Lectures

Word 2021: introduction
2 Lectures

Word 2021: basics
6 Lectures

Word 2021: word formatting
8 Lectures

Word 2021: tables
10 Lectures

Word 2021: styles
3 Lectures

Word 2021: page layout
7 Lectures

Word 2021: envelops and lables
2 Lectures

Word 2021: mail merges
1 Lectures

Word 2021: review and printing
5 Lectures

Instructor Details

Skills Marathon
Course Certificate
Use your certificate to make a career change or to advance in your current career.

Our students work
with the Best


































Related Video Courses
View MoreAnnual Membership
Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses
Subscribe now
Online Certifications
Master prominent technologies at full length and become a valued certified professional.
Explore Now