Microsoft Excel Course Online

Introduction

Getting Started on Windows, macOS, and Linux

How to ask great questions

FAQ’s

Getting Started

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

Excel 2021: Basics

Adding Rows and Columns

Modifying Rows and Column lengths

Excel 2021: Rows, Columns, and Cells

Copy, Cut, and Paste

Copying Formulas

Excel 2021: Data Handling

Page setup options

Fit to Print on One Page

Print Workbooks

Excel 2021: Page Setting Up and Print

Sorting Data Ascending Order

Sorting Data Descending Order

Filter Data

Excel 2021: Sorting and Filtering

Creating Basic Formulas

Datetime Formulas

Mathematical formulas phase 1

Mathematical formulas phase 2

Writing Formulas

VLOOKUP formula

HLOOKUP formula

Excel 2021: Advanced Formulas

XLOOKUP

Handling #NA and Approximates match in XLOOKUP

Excel 2021: XLOOKUP only for 2021 and Office 365

Split Text into columns

Flash Fill

Data Validation

Remove Duplicates

Import Data from Text files

Import Data from .CSV files

Excel 2021: Data and Tools

Formatting Font

Formatting Alignment

Formatting Numbers

Formatting Date

Formatting Tables

Excel 2021: Formatting data and tables

Pivot Tables

Pivot Charts

Excel 2021: Pivot Tables

Excel Charts – Categories

Elements of a chart

Creating Charts

Column or Bar charts

Formatting charts

Line Charts

Pie and Doughnut charts

Excel 2021: Charts

Overview

Start PowerPoint Presentation

Screen setting and Views

PowerPoint 2021: Course Introduction

Presentation Tips and Guidelines

Creating a New Presentation

Working with Slides

Save a Presentation

Print Slides

PowerPoint 2021: Basics

Formatting Text

Slide Text Alignments

Multi-Column Text Alignments

Adding Bullets and Numbered List Items

PowerPoint 2021: Text and Bullet Options

Insert Shapes

Insert Icons

Insert Graphics

Add 3D Models

Insert Pictures

PowerPoint 2021: Adding Graphic Assets

Picture Options

Picture Cropping

Applying Built-in Picture Styles

PowerPoint 2021: Picture Formatting

Add SmartArt Graphic

Modifying SmartArt

Creating a Target Chart using SmartArt

PowerPoint 2021: SmartArt Graphics

Create a Table on Slide

Inserting Tables

Table Layouts

PowerPoint 2021: Working with Tables

Insert Chart from Microsoft Excel

Add a Chart

Formatting Charts

PowerPoint 2021: Working with Charts

Adding Video to a Presentation

Adding Audio to a Presentation

Screen Recording and Adding

PowerPoint 2021: Adding Multimedia

Applying Transitions to Presentation

PowerPoint 2021: Working with Transition

Object Animation

Effect Options

Advanced Animation

Triggers to control animation

PowerPoint 2021: Animation

Onscreen Presentation

Hiding Slides

Changing Order of Slides

Copying Slides

PowerPoint 2021: Slideshow Effects

Overview of MS Word

Start MS Word 2021

Word 2021: Introduction

Create a new blank document

Creating a paragraph text

Non-printing characters

Save a document

Open a document

Find and replace

Word 2021: Basics

AutoCorrect options

Formatting text

Copy cut and paste

Character formatting

Format painter

Work with numbers

Add bullets

Outline creation

Word 2021: Word Formatting

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

Word 2021: Tables

Working with styles

Creating styles

Clear formatting

Word 2021: Styles

Margins

Orientation

Page size setting

Adding columns

Page break – section break

Adding watermark

Headers and Footers

Word 2021: Page Layout

Create envelops

Creating Labels

Word 2021: Envelops and Lables

Creating a mail merge document

Word 2021: Mail Merges

Thesaurus and spell check

Word count

Speech - read aloud

Language - translate

Tracking

Word 2021: Review and Printing

Welcome to the ultimate Microsoft Office course! In this comprehensive program, you'll gain the skills needed to excel in Word, Excel, PowerPoint, and Office 365. Microsoft Excel: Master the powerful spreadsheet program essential for data analysis and informed decision-making. You'll learn how to create and format worksheets, perform calculations and functions, and develop charts and graphs to visualize your data effectively. Microsoft PowerPoint: Discover how to create captivating presentations that engage your audience. You'll learn to format slides, incorporate multimedia elements, and utilize animations and transitions to make your presentations dynamic and memorable. Microsoft Word: Explore the go-to word processing tool for businesses and individuals. This course will teach you how to create and format documents, use styles and templates, and work with tables and images to produce professional-quality content. Office 365: Get acquainted with the cloud-based suite of productivity tools, including Word, Excel, and PowerPoint. Learn how to collaborate in real-time, access your files from anywhere, and leverage the advantages of cloud computing. Additionally, you’ll discover how to apply Generative AI tools to enhance your work—whether it’s generating trending Excel data analysis formulas, creating stunning presentations, or crafting content in Word based on your prompts.<h4 id="78014450-c04a-4328-bb2a-0e9b65ec3d19" data-toc-id="78014450-c04a-4328-bb2a-0e9b65ec3d19">Who Should Enrol</h4><ul><li>Business professionals aiming to create high-quality documents, presentations, and spreadsheets.</li><li>Students need Microsoft Office skills for school projects or assignments.</li><li>Job seekers looking to enhance their Microsoft Office proficiency for career growth.</li><li>Individuals interested in using Office 365 for improved collaboration and productivity.</li><li>Freelancers, entrepreneurs, and small business owners require professional documents and presentations.</li><li>Anyone seeking to increase productivity and efficiency with Microsoft Office tools.</li></ul><h4 id="d848e9c9-8647-45d4-919b-f66994321f78" data-toc-id="d848e9c9-8647-45d4-919b-f66994321f78">Requirement</h4><ul><li>A PC or laptop with Microsoft Office Suite or Office 365 installed.</li><li>Basic familiarity with using a computer, such as navigating files and folders.</li><li>No prior experience with Microsoft Office is needed; this course is suitable for beginners.</li><li>Internet access is required for using Office 365 features and accessing course materials.</li><li>A willingness to learn and practice new skills to boost productivity and efficiency.</li></ul><h3 id="7be95171-539a-42f5-9d28-acd39bf98533" data-toc-id="7be95171-539a-42f5-9d28-acd39bf98533">Related Courses -</h3><table style="min-width: 50px"><colgroup><col><col></colgroup><tbody><tr><td colspan="1" rowspan="1"><ul><li><a target="_blank" href="https://growfast.indiatimes.com/course-detail/excel-essentials-to-expert-your-complete-guide/24052/">Excel Essentials to Expert: Your Complete Guide</a></li></ul></td><td colspan="1" rowspan="1"><ul><li><a target="_blank" href="https://growfast.indiatimes.com/course-detail/microsoft-word-mastery-from-beginner-to-expert/23803/">Microsoft Word Mastery: From Beginner to Expert</a></li></ul></td></tr><tr><td colspan="1" rowspan="1"><ul><li><a target="_blank" href="https://growfast.indiatimes.com/course-detail/zero-to-hero-in-microsoft-excel-complete-excel-guide-2024/23855/">Zero to Hero in Microsoft Excel: Complete Excel guide 2024</a></li></ul></td><td colspan="1" rowspan="1"><ul><li><a target="_blank" href="https://growfast.indiatimes.com/course-detail/mastering-google-sheets-unleash-the-power-of-excel-and-advance-analysis/23734/">Mastering Google Sheets: Unleash the Power of Excel and Advance Analysis</a></li></ul></td></tr></tbody></table>

1a Introduction.mp4

Enhance your efficiency and elevate your professional skills with Microsoft Office 2021 through comprehensive expert guidance and practical exercises. Gain mastery in essential tools, enabling you to work smarter, and improve productivity.

Mastering Microsoft Office: Word, Excel, PowerPoint, and 365

Course content

Course Description