Mastering Excel 365 - Intermediate (2022)

Focused View

Bigger Brains

3:32:47

149 View

1. Editing

1.1 Practice Files (1).zip

1. Introduction.mp4

02:14

2. Flash Fill.mp4

08:23

3. Text to Columns.mp4

05:32

4. Find and Replace.mp4

09:08

5. Sort and Filter.mp4

06:09

6. Proofing and Researching Tools.mp4

07:22

7. Group Mode.mp4

04:08

8. Workbook Properties.mp4

04:22

2. Workbook Views

1. Freeze and Split Windows.mp4

06:47

2. Workbook Views.mp4

05:36

3. Custom Views.mp4

04:47

3. Formatting

1. Custom Number Formats.mp4

09:32

2. Conditional Formatting for Text and Dates.mp4

04:40

3. Comparative Analysis with Conditional Formatting.mp4

05:02

4. Customizing Conditional Formatting.mp4

07:55

5. Functions in Conditional Formatting.mp4

04:59

4. Functions

1. Nested Functions.mp4

09:37

2. Logical Functions.mp4

05:28

3. Statistical Functions.mp4

07:36

5. Charts and Graphics

1. Chart Elements.mp4

09:16

2. Chart Formats.mp4

07:36

3. Sparklines.mp4

02:15

4. Graphics.mp4

03:10

5. SmartArt.mp4

04:00

6. Tables and PivotTables

1. Creating Tables.mp4

04:25

2. Table Styles.mp4

04:22

3. Summarizing Data in Tables.mp4

04:36

4. Managing PivotTables.mp4

08:43

5. Web Queries.mp4

03:18

7. Sharing

1. Hyperlinks.mp4

05:09

2. Compare and Merge.mp4

04:01

3. Track Changes.mp4

05:53

4. Share a Workbook.mp4

04:21

5. Comments.mp4

08:44

8. Data Analysis

1. Goal Seek.mp4

05:30

2. Forecasting with Data Tables.mp4

05:44

3. Analyze Data Tool.mp4

02:27

Description

Learn many of Excel’s tools for analyzing and sharing your data.

What You'll Learn?

Use Flash Fill, Text to Columns, and Group Mode to work with your data
Use editing features such as Find and Replace, proofing options, and research tools to refine your workbook
Modify workbook views
Apply conditional formatting to text, numbers, and dates
Apply custom number formatting
Use nested, logical, and statistical functions
Modify and format charts
Add sparklines, pictures, and SmartArt
Modify Tables, PivotTables, and web queries

Who is this for?

Users who are comfortable performing basic tasks in Excel and want to learn additional features.

More details

Description
Learn many of Excelâ€™s tools for analyzing and sharing your data.
Microsoft Excel is the most popular data analysis tool in the workplace, so using it effectively is a crucial skill for any business professional. In this course youâ€™ll learn great tools to modify your data and refine your workbook. Excel expert Kathy Jones will also show you how to nest functions and modify and format charts. Youâ€™ll even learn to enhance your visualizations by adding sparklines, pictures, and SmartArt. And if you need to work with others, youâ€™ll learn some of the tools available when sharing your workbooks, including comments, hyperlinks, track changes, and share options.
And if you need to know more about forecasting, youâ€™ll learn how to conduct What-If analysis using Excelâ€™s special features.
Topics covered include:
Using Flash Fill, Text to Columns, and Group Mode to work with your data
Using editing features such as Find and Replace, proofing options, and research tools to refine your workbook
Modifying workbook views
Applying conditional formatting to text, numbers, and dates
Applying custom number formatting
Using nested, logical, and statistical functions
Modifying and formatting charts
Adding sparklines, pictures, and SmartArt
Modifying Tables, PivotTables, and web queries
Sharing workbooks
Using tools to enhance sharing such as hyperlinks, track changes, and comments
Analyzing data with Goal Seek and Data Tables
Over three and a half hours of high-quality HD content in the â€œUniquely Engagingâ€TM Bigger Brains Teacher-Learner style!
Who this course is for:
Users who are comfortable performing basic tasks in Excel and want to learn additional features.

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.