Mastering Excel 365 - Basics (2022)

Focused View

Bigger Brains

2:59:01

104 View

1. Editing

1.1 Mastering Excel 365 Basics (2022) Practice files.zip

1. Introduction.mp4

01:50

2. Open and Save a Workbook.mp4

06:12

3. Modifying Rows and Columns, Part 1.mp4

06:11

4. Modifying Rows and Columns, Part 2.mp4

06:55

5. Managing Worksheets, Part 1.mp4

04:29

6. Managing Worksheets, Part 2.mp4

08:58

2. Functions

1. Using Absolute References.mp4

07:42

2. Creating Named Ranges.mp4

07:05

3. Using Named Ranges in Functions.mp4

06:44

4. Working with IF Functions.mp4

08:19

5. Working with Logical Functions.mp4

04:41

6. Creating Functions Based on Conditions.mp4

07:00

7. Tracing Formulas.mp4

06:21

8. Addressing Formula Errors.mp4

09:51

3. Formatting

1. Aligning Cell Contents.mp4

09:17

2. Adding Borders and Shading.mp4

08:06

3. Applying Number and Date Formats.mp4

09:04

4. Using Format Painter.mp4

04:46

5. Applying Cell Styles and Themes.mp4

07:38

4. Charts and Tables

1. Changing Chart Types.mp4

06:21

2. Changing Chart Source Data.mp4

05:20

3. Creating a Table.mp4

05:05

4. Creating a PivotTable.mp4

06:34

5. Printing

1. Setting Page Layout Options.mp4

07:35

2. Changing Page Breaks and Scaling.mp4

09:36

3. Configuring Headers and Footers.mp4

07:21

Description

Go beyond the basics of data entry to analyze your data and create visually appealing workbooks.

What You'll Learn?

Open and save existing workbooks
Manage rows, columns, and worksheets
Create and use named ranges
Add logical and conditional functions
Address formula errors
Apply cell and number formats, including cell styles and themes
Modify charts
Create Tables and PivotTables
Configure page settings and headers/footers for printing

Who is this for?

People who have a basic knowledge of Microsoft® Windows® and want to learn beginner Excel 365 skills to create and modify spreadsheets.

What You Need to Know?

Office 365 License

More details

Description
Learn how to use the worldâ€™s most popular software tool for organizing and analyzing data.

When you master Excel, you have one of the most practical and valuable skillsets in modern business. You can work wondersâ€”from organizing lists; to creating multi-layered, interactive reports; to answering critical business questions like ROI, budget allocations, expense tracking, and more. This course is your first step towards becoming an expert at using Excel.

Topics covered include:
Navigating the interface
Creating and saving workbooks
Selecting and entering data
Performing calculations
Formatting data
Managing multiple worksheets
Customizing your options

Over four hours of high-quality HD content in the â€œUniquely Engagingâ€TM Bigger Brains Teacher-Learner style!

Objectives. You will be able to:
Navigate the interface including creating and saving workbooks, quickly accessing commands, and selecting and entering data
Perform calculations using formulas and functions
Insert and delete rows and columns
Apply formatting to text, numbers, and cells including using Cell Styles and Conditional Formatting
Control how your worksheets print using Page Layout options, Page Breaks, and Headers and Footers
Manage multiple worksheets within a workbook including adding, removing, renaming, reordering, copying, and color-coding worksheets
Use View features to compare workbooks, compare worksheets, or save Custom Views
Customize Excel by adding Groups to the Ribbon and modifying the Quick Access Toolbar

Over four hours of high-quality HD content in the â€œUniquely Engagingâ€TM Bigger Brains Teacher-Learner style!
Who this course is for:
People who have a basic knowledge of MicrosoftÂ® WindowsÂ® and want to learn beginner Excel 365 skills to create and modify spreadsheets.

User Reviews

Rating

average 0

Total votes0

Focused display

Let's face it, no online training courses are "fun." But some (like Bigger Brains) are engaging and better to spend time on than others! Bigger Brains courses are built in a unique Teacher/Learner style, featuring two people on camera to recreate some of the interactivity and physiological benefits of classroom training, including dialogue, humor, and practical use case examples. This uniquely engaging video-based format is more enjoyable and, more importantly, more effective than traditional eLearning formats. Bigger Brains courses are popular with both learners and training professionals around the world. Because we use experienced teachers and subject matter experts with real-world experience, we have the most realistic and comprehensive online training courses possible.There are also resources to help you learn along with the way. Most Bigger Brains courses include handouts and practice files. Some even include free post-training reinforcement through the BrainBot learning retention app.Join the hundreds of thousands of learners around the world and upskill, reskill, and stay in the know with Bigger Brains!

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.