Microsoft Office Essentials Collection

Focused View

Simon Sez IT

6:40:10

0 View

1 - Excel 365 Excel Overview

1 -Course Welcome.mp4

02:05

2 -WATCH ME Essential Information for a Successful Training Experience.mp4

02:11

3 -Course Files.zip

3 -Excel 365 Essentials Exercise Files.zip

3 -Ribbon Overview.mp4

04:08

3 - DOWNLOAD ME Course Exercise Files.html

3 - DOWNLOAD ME Course Instructor Files.html

4 -Cursor Options.mp4

02:11

5 -Data Entry Basics.mp4

03:12

6 -Layout Options.mp4

05:17

2 - Excel 365 Formatting

1 -Intro to Formatting.mp4

05:56

2 -Number Formatting.mp4

07:06

3 -Formatting with Styles.mp4

07:07

4 -Formatting with Tables.mp4

12:24

5 -Exercise 1.mp4

01:39

3 - Excel 365 Formulas

1 -Intro to Formulas.mp4

08:05

2 -Relative and Absolute References.mp4

05:13

3 -Exercise 2.mp4

00:57

4 - Excel 365 AutoFill

1 -AutoFill.mp4

14:16

2 -Creating Custom Lists.mp4

05:18

3 -Exercise 3.mp4

01:08

5 - Excel 365 Conditional Formatting

1 -Conditional Formatting Intro.mp4

07:40

2 -Conditional Formatting Blank Cells.mp4

03:41

3 -Conditional Formatting Icons and Color Scales.mp4

07:13

4 -Exercise 4.mp4

01:31

6 - Excel 365 Sorting and Filtering

1 -Sorting Data.mp4

07:15

2 -Filtering Data.mp4

05:15

3 -Text to Columns.mp4

04:29

4 -Conditional Formatting Sorting and Filtering.mp4

03:24

5 -Exercise 5.mp4

00:37

7 - Excel 365 Working with Large Workbooks

1 -Freeze Panes.mp4

03:36

2 -Splitting.mp4

03:50

3 -Printing.mp4

04:10

4 -Print Titles.mp4

03:53

5 -Page Break Settings.mp4

03:14

6 -Center Align Sheets.mp4

01:51

7 -Headers & Footers.mp4

11:51

8 -Exercise 6.mp4

01:12

8 - Excel 365 Charts

1 -Intro to Charts.mp4

04:09

2 -Column Charts.mp4

07:26

3 -Chart Elements.mp4

06:33

4 -Chart Formatting.mp4

03:50

5 -Pie Chart.mp4

10:16

6 -Inserting Charts into PowerPoint.mp4

07:00

7 -Exercise 7.mp4

00:48

9 - Excel 365 Course Close

1 -Course Close.mp4

02:36

10 - Word 365 Word Overview

1 -Course Welcome.mp4

01:55

2 -WATCH ME Essential Information for a Successful Training Experience.mp4

02:11

3 -Ribbon Overview.mp4

07:21

3 - DOWNLOAD ME Course Exercise Files.html

3 - DOWNLOAD ME Course Instructor Files.html

4 -Quick Access Toolbar.mp4

08:08

5 -Saving and Opening Documents.mp4

06:12

11 - Word 365 Text Editing Tools

1 -Selecting and Inserting Text.mp4

02:47

2 -Cut, Copy, and Paste.mp4

04:55

3 -Spellcheck.mp4

06:23

4 -Thesaurus.mp4

02:30

5 -Find and Replace.mp4

05:24

6 -Exercise 1.mp4

01:28

12 - Word 365 Formatting

1 -Intro to Formatting.mp4

09:35

2 -Format Painter.mp4

03:23

3 -Styles - Part 1.mp4

10:20

4 -Styles - Part 2.mp4

12:07

5 -Exercise 2.mp4

01:32

13 - Word 365 Alignment & Layout

1 -Alignment, Tabs & Ruler.mp4

08:04

2 -Line Spacing.mp4

06:01

3 -Working with Columns.mp4

04:12

4 -Exercise 3.mp4

00:53

14 - Word 365 Bullets & Numbering

1 -Bullets and Numbering.mp4

07:29

2 -Custom Bullets and Numbering.mp4

08:46

3 -Exercise 4.mp4

01:14

15 - Word 365 Page Setup & Printing

1 -Page Setup Options - Part 1.mp4

09:02

2 -Page Setup Options - Part 2.mp4

02:34

3 -Printing.mp4

02:42

4 -Save as PDF.mp4

02:40

5 -Headers and Footers.mp4

05:18

6 -Exercise 5.mp4

01:27

16 - Word 365 Tables

1 -Creating Tables.mp4

03:31

2 -Formatting Tables.mp4

12:24

3 -Tables Layout.mp4

11:26

4 -Text to Tables.mp4

05:22

5 -Exercise 6.mp4

01:17

17 - Word 365 Working with Images

1 -Working with Images in Word.mp4

05:38

2 -Editing Images.mp4

06:03

3 -Working with Text Wrap.mp4

01:18

4 -Exercise 7.mp4

01:05

Description

Learn the essentials of Microsoft Office 365 and Copilot in this amazing value 5-course bundle.

What You'll Learn?

Enter and format data effectively in Excel.
Use formulas with relative and absolute references.
Sort and filter data for better analysis.
Create and format various types of charts.
Save, open, and manage Word documents.
Use cut, copy, paste, and spellcheck tools.
Adjust alignment, line spacing, and column layouts.
Create and customize bullets and numbering.
Create, edit, and arrange slide decks in PowerPoint.
Apply and customize slide layouts and designs.
Use Presenter View to deliver slideshows and create and use custom slideshows.
Utilize SmartArt for creative visuals and apply animations and transitions to slides.
Create professional and visually appealing emails in Outlook.
Understand how to attach, preview, and manage files within emails.
Schedule and manage appointments, meetings, and events.
Create and manage contact lists and contact groups.
Utilize the Tasks feature to manage your to-do list.
Integrate Copilot Pro across the Microsoft Office suite for increased productivity.
Streamline tasks and workflows using Copilot Pro features across applications.
Generate custom graphics and enhance visual content in Image Creator/Designer using Copilot Pro.
Analyze data and create charts in Excel with Copilot Pro.

Who is this for?

Users new to Microsoft Office 365 and those upgrading from older stand-alone versions.

Anyone who wants to be more productive at work and organize their spreadsheets, documents, mail, calendar, meetings, or presentations.

Those who want to get the most out of Microsoft 365, including Outlook and Copilot.

Tech-savvy learners interested in AI integration.

What You Need to Know?

An active Microsoft 365 account and subscription to access the Office applications is useful.

No prior experience needed, the course is for complete beginners.

More details

Description
This bundle includes practice exercises, downloadable files, and LIFETIME access

Welcome to the Microsoft Office Essentials Collection, a comprehensive 5-course bundle designed to help you learn the fundamentals of MS Office 365 applications. With courses covering Microsoft Excel, Word, PowerPoint, Outlook, and Copilot, you'll learn the essential skills to excel in various professional settings.

Starting with Microsoft Excel 365 Essentials, you'll gain a solid foundation in spreadsheet creation and data analysis. Moving on to Microsoft Word 365 Essentials and Microsoft PowerPoint 365 Essentials, explore document creation and presentation design. Then, progress with Microsoft Outlook 365 Essentials to learn to manage your emails and Copilot Essentials in Microsoft Office to integrate Microsoft's AIÂ tool in Office 365.

Completing this course bundle will help equip you with versatile skills crucial for productivity and efficiency in today's workplace. Whether you're a student, professional, or entrepreneur, investing in this bundle can help ensure you have the knowledge to navigate Office 365 effectively and excel in your endeavors.

What's included?

Excel 365 Essentials
Navigate the Excel ribbon and cursor options.
Enter and format data effectively.
Apply number and style formatting to tables.
Use formulas with relative and absolute references.
Utilize AutoFill and create custom lists.
Implement conditional formatting based on cell content.
Sort and filter data for better analysis.
Create and format various types of charts.

Word 365 Essentials
Navigate the Word ribbon and customize the quick access toolbar.
Save, open, and manage Word documents.
Use cut, copy, paste, and spellcheck tools.
Apply and modify text formatting styles and use the format painter.
Adjust alignment, line spacing, and column layouts.
Create and customize bullets and numbering.
Set up pages and print or save documents.
Insert, format, and layout tables in documents.
Add and edit images with text wrapping.

PowerPoint 365 Essentials
Navigate and use the PowerPoint workspace effectively.
Create, edit, and arrange slide decks.
Apply and customize slide layouts and designs.
Use Presenter View to deliver slideshows.
Create and use custom slideshows.
Use master slides for consistent slide formatting.
Insert and enhance images and graphics.
Utilize SmartArt for creative visuals.
Apply animations and transitions to slides.

Outlook 365 Essentials
Create professional and visually appealing emails.
Understand how to attach, preview, and manage files within emails.
Flag important messages and set follow-up reminders.
Customize toolbars, ribbon, and quick access settings for increased efficiency.
Schedule and manage appointments, meetings, and events.
Create and manage contact lists and contact groups.
Utilize the Tasks feature to manage your to-do list.
Use search folders and filters to streamline your email management.

Copilot Essentials
Integrate Copilot Pro across the Microsoft Office suite for increased productivity.
Streamline tasks and workflows using Copilot Pro features across applications.
Write polished documents using Copilot Pro in Word.
Analyze data and create charts in Excel with Copilot Pro.
Design captivating presentations with Copilot Pro in PowerPoint.
Efficiently manage emails and compose professional messages in Outlook with Copilot Pro.
Generate custom graphics and enhance visual content in Image Creator/Designer using Copilot Pro.

This course bundle includes:
12 hours of video tutorials
150 individual video lectures
Course and exercise files to follow along
Certificate of completion
Who this course is for:
Users new to Microsoft Office 365 and those upgrading from older stand-alone versions.
Anyone who wants to be more productive at work and organize their spreadsheets, documents, mail, calendar, meetings, or presentations.
Those who want to get the most out of Microsoft 365, including Outlook and Copilot.
Tech-savvy learners interested in AI integration.

User Reviews

Rating

average 0

Total votes0

Focused display

Microsoft Office 365

Simon Sez IT

Instructor's Courses

Since 2008, individuals, small businesses, and Fortune 500 companies with thousands of employees have benefited from the easy and hands-on software training offered by Simon Sez IT. With over 8,000 video tutorials on a range of software programs, Simon Sez IT ensures stress-free eLearning and enhanced employee productivity - no matter whether you are implementing new software or a technological upgrade for your workplace. With over 630,000 Udemy students in over 180 countries, Simon Sez IT is the preferred online learning choice for individuals and businesses everywhere.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.