Mastering Excel 365 - Expert (2023)

Focused View

Bigger Brains

3:45:31

59 View

1. Sharing

1.1 Mastering Excel 365 - Expert (2023) Practice Files.zip

1. Introduction.mp4

02:09

2. Collaborating and Co-Authoring.mp4

05:29

3. Digital Signatures.mp4

04:20

4. Get and Transform Data.mp4

03:14

2. Charts

1. Map Charts.mp4

03:01

2. 3D Maps.mp4

08:38

3. Waterfall, Treemap, and Funnel Charts.mp4

04:04

3. PivotTables

1. PivotTable Options.mp4

07:34

2. Summarize Data in a PivotTable (Part 1).mp4

06:28

3. Summarize Data in a PivotTable (Part 2).mp4

07:33

4. PivotCharts.mp4

08:28

5. Data Models.mp4

04:44

4. Functions

1. Named Ranges.mp4

07:41

2. Creating Internal Links.mp4

07:41

3. Creating External Links.mp4

08:25

4. INDEX, MATCH, and Sparklines.mp4

09:00

5. Date Functions.mp4

09:33

6. Information Functions.mp4

08:09

7. LAMBDA and LET.mp4

09:57

8. Financial Functions.mp4

04:35

9. Watch and Evaluate Formulas.mp4

06:52

5. What-If Analysis

1. Forecast Data Trends.mp4

04:27

2. Using Scenarios.mp4

08:28

3. Use Solver.mp4

09:21

4. Data Analysis ToolPack.mp4

05:08

6. Macros and Forms

1. Record a Macro.mp4

09:58

2. Run a Macro.mp4

05:42

3. Edit a Macro.mp4

07:20

4. Forms.mp4

09:22

7. Customizing Excel

1. Customize the Ribbon.mp4

05:32

2. Excel Options.mp4

04:39

3. Custom Lists.mp4

05:24

4. Linked Data Types.mp4

06:02

5. Add-ins.mp4

06:33

Description

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

What You'll Learn?

Share a workbook with other users
View and restore previous workbook versions using Version History
Insert and sign a digital signature line in a workbook
Get and transform external data

Who is this for?

This course is intended for advanced Excel 365 users who want to learn expert level features.

What You Need to Know?

Knowledge in Excel 365 is required

More details

Description
Learn to enhance both communication and data analysis by expertly utilizing the advanced features of Excel 365.
Being able to use Microsoft Excel skillfully is crucial for all business professionals who use, analyze, and apply data. Since Excel is the most popular data analysis tool in the workplace, increasing your ability to utilize its advanced features is vital for professional development and success.
Excel expert Kathy Jones will show you how to share workbooks, create digital signatures, and restore a previous version of your workbook. She will demonstrate how to utilize functions to find data, calculate dates, and determine rates and payments. Youâ€™ll also learn how to streamline complex functions with LAMBDA and LET. In addition, youâ€™ll learn how to summarize data with PivotTables and how to create and modify PivotCharts.
Because the visual display of data greatly enhances communication and understanding, Kathy will demonstrate how to create and modify waterfall, treemap, and funnel charts to illustrate your information in multiple ways. Youâ€™ll learn how to use data map charts and 3-D maps to compare and analyze data. Kathy will also show you how to create a forecast timeline to look at trends in your data.
Finally, you will learn how to record, run, and edit macros so that you can automate repetitive tasks and save valuable time when formatting your worksheets!

Topics covered include:
Sharing a workbook with other users
Viewing and restoring previous workbook versions using Version History
Inserting and signing a digital signature line in a workbook
Getting and transforming external data
Comparing and analyzing data using data map charts and 3D maps
Creating and modifying waterfall, treemap, and funnel charts
Formatting and changing the data source for a PivotTable
Creating and modifying PivotCharts
Creating and managing internal and external links in your workbooks
Using functions to find data and calculate dates
Streamlining complex functions with LAMBDA and LET
Creating a forecast timeline
Using Add-ins such as Solver, the Data Analysis ToolPack, and Visio
Recording, running, and editing macros

Enjoy over three and a half hours of high-quality HD content high-quality HD content in the â€œUniquely Engagingâ€TM Bigger Brains Teacher-Learner style!
Who this course is for:
This course is intended for advanced Excel 365 users who want to learn expert level 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.