Microsoft Excel 365 Essentials

Focused View

Simon Sez IT

3:25:36

0 View

1 - Excel Overview

1 - Course Welcome.mp4

02:06

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

02:11

3 - Course-Files.zip

4 - Exercise-Files.zip

5 - Ribbon Overview.mp4

04:08

6 - Cursor Options.mp4

02:11

7 - Data Entry Basics.mp4

03:12

8 - Layout Options.mp4

05:17

2 - Formatting

9 - Intro to Formatting.mp4

05:56

10 - Number Formatting.mp4

07:06

11 - Formatting with Styles.mp4

07:07

12 - Formatting with Tables.mp4

12:24

13 - Exercise 1.mp4

01:39

3 - Formulas

14 - Intro to Formulas.mp4

08:05

15 - Relative and Absolute References.mp4

05:13

16 - Exercise 2.mp4

00:57

4 - AutoFill

17 - AutoFill.mp4

14:17

18 - Creating Custom Lists.mp4

05:18

19 - Exercise 3.mp4

01:08

5 - Conditional Formatting

20 - Conditional Formatting Intro.mp4

07:40

21 - Conditional Formatting Blank Cells.mp4

03:41

22 - Conditional Formatting Icons and Color Scales.mp4

07:13

23 - Exercise 4.mp4

01:31

6 - Sorting and Filtering

24 - Sorting Data.mp4

07:15

25 - Filtering Data.mp4

05:15

26 - Text to Columns.mp4

04:29

27 - Conditional Formatting Sorting and Filtering.mp4

03:24

28 - Exercise 5.mp4

00:37

7 - Working with Large Workbooks

29 - Freeze Panes.mp4

03:36

30 - Splitting.mp4

03:50

31 - Printing.mp4

04:10

32 - Print Titles.mp4

03:53

33 - Page Break Settings.mp4

03:14

34 - Center Align Sheets.mp4

01:52

35 - Headers Footers.mp4

11:51

36 - Exercise 6.mp4

01:12

8 - Charts

37 - Intro to Charts.mp4

04:09

38 - Column Charts.mp4

07:26

39 - Chart Elements.mp4

06:33

40 - Chart Formatting.mp4

03:50

41 - Pie Chart.mp4

10:16

42 - Inserting Charts into PowerPoint.mp4

07:00

43 - Exercise 7.mp4

00:48

9 - Course Close

44 - Course Close.mp4

02:36

Description

Master Excel's essential functions and formatting tools, empowering you to organize, analyze, and present data.

What You'll Learn?

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.

Who is this for?

Microsoft Excel novice.

No previous knowledge of Excel required. This course is created for absolute beginners.

Those who need an Excel refresher and want to improve their knowledge.

Users who have a foundation of Microsoft Excel and seeking to advance their Excel 365 knowledge.

What You Need to Know?

An active Microsoft 365 account to access Excel is beneficial to follow along.

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

More details

Description
This course includes downloadable course instructor files and exercise files to work with and follow along.

This Microsoft Excel 365 Essentials course will teach you the fundamental skills to use Excel efficiently and effectively. Starting with an overview of Excel, you will get comfortable with the ribbon, cursor options, and basic data entry techniques. This course is designed to help you master Excel's powerful formatting features, formulas, and data management.

You will discover how to format numbers, styles, and tables to make your data visually appealing and easy to read. The course will introduce you to essential formulas, including how to use relative and absolute references. You will also learn about AutoFill and creating custom lists to speed up your work.

Conditional formatting will teach you to highlight important data using icons and color scales. Sorting and filtering techniques will help you organize and analyze large datasets effectively. You will also learn to manage large workbooks with tools like freeze panes, splitting, and printing options.

Charts are a vital part of data presentation, and you will learn how to create and format different types of charts, including column and pie charts. Additionally, you will practice inserting charts into PowerPoint for professional presentations.

By the end of this course, you should have a solid foundation in Excel 365, enabling you to handle various data-related tasks confidently. Each section includes practical exercises to reinforce your learning and ensure you can apply what you've learned. This course is perfect for beginners and those looking to refresh their Excel skills.

In this course, you will learn how to:
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.

This course includes:
3+ hours of video tutorials
41 individual video lectures
Course and exercise files to follow along
Certificate of completion
Who this course is for:
Microsoft Excel novice.
No previous knowledge of Excel required. This course is created for absolute beginners.
Those who need an Excel refresher and want to improve their knowledge.
Users who have a foundation of Microsoft Excel and seeking to advance their Excel 365 knowledge.

User Reviews

Rating

average 0

Total votes0

Focused display

Excel

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.