Excel 365 - The Ultimate Excel Updates Course

Focused View

Paula Guilfoyle CPA

1:49:38

37 View

1. Collaboration & Communications

1. Course Overview.mp4

02:26

2. Quick note.html

3. Module 1 Introduction.mp4

02:41

4. Improved Collaboration - What are the changes.html

5. Sharing.mp4

03:53

6. What are notes.html

7. Comments and Mentions.html

8. Notes Comments and Mentions.mp4

03:58

9. Translations in Excel.html

10. Natural Language Search.html

11. Help and Natural Language Search.mp4

03:10

12.1 explore.xlsx

12. Activity.html

13. Quiz.html

2. Performance Improvements

1. Module 2 overview.mp4

01:59

2. What changes have been made to Saving and Restoring files.html

3. Restoring files.mp4

01:38

4. What improvements have been made to Accessibility.html

5. Accessibility.mp4

03:53

6. What other Other general performance improvements have been made.html

7. What are Ideas.html

8. Ideas.mp4

02:28

9. How to deselect extraneous cells.html

10. the Left Click trick.mp4

01:27

11. test your knowledge.html

12. Activity.html

13. Activity solution.html

3. Working with Functions

1. Module 3 Introduction.mp4

02:20

2. Understanding IFS.html

3. IFS.mp4

06:41

4. How to use SWITCH.html

5. SWITCH.mp4

06:29

6. How to use TEXTJOIN.html

7. TEXTJOIN.mp4

03:12

8. TEXTJOIN nested IF.mp4

07:47

9. 8 limitations of VLOOKUP removed with XLOOKUP.mp4

02:18

10. How to use XLOOKUP.html

11. XLOOKUP - Exact Match.mp4

06:29

12. XLOOKUP - Match modes.mp4

04:53

13. XLOOKUP - Search mode.mp4

04:54

14. test your knowledge.html

15.1 Explore 1.xlsx

15.2 Explore 2.xlsx

15. Activity.html

16. Activity solution.html

4. charting, visualizations

1. Module 4 Introduction.mp4

01:41

2. What enhancements have been made to images and graphics.html

3. 3D images and SVG icons.mp4

03:02

4. Funnel charts.html

5. How to insert a funnel chart.mp4

02:53

6. Inserting and working with Filled Map Charts.mp4

06:11

7. How do I create and understand Box and Whisker charts.html

8. Box and Whisker plots.mp4

04:17

5. Pivot Tables and Excel Power Tools

1. What are rich data types.html

2. Using Rich data types.mp4

07:52

3. Changes and Improvements to Pivot tables.mp4

04:24

4. Adding columns by example.mp4

05:05

5. Course Conclusion.mp4

01:37

Description

Stay in tune with with the latest updates in Excel From Excel 2016 to Latest Release of Excel 365

What You'll Learn?

You will learn what changes have been made in Excel Since Excel 2016 to date. This includes changes rolled out within Excel 365
You will learn about VLOOKUP successor XLOOKUP
Coming Soon.......Dynamic Arrays Functions
You will learn about changes and improvements to collaboration and communications
You will learn about general improvements
You will learn about new charts and visualizations improvements
You will learn about changes in Power Tools, and Pivot tables

Who is this for?

Excel users moving from Excel 2016 or 2019 to Excel 365

Excel users that just want to know what has changed in Excel to keep their skills up to date

Experienced Excel users looking to keep up to date with changes

This course is not for you if you are not experience and familiar with Excel

What You Need to Know?

Have experience in using Excel

It is preferable that you have an Excel 365 subscription

This course is not for beginner excel users or those that need a deep dive into excel use.

More details

Description
This course aimed at keeping you informed on the latest and greatest improvements to Excel as they are rolled out.Â
Excel 365 keeps improving and to stay ahead of the game, you need to know what changes, additions and improvements are made in each rollout.

This course is an evolving course, as new releases happen, I will update this course with new material. If you just need to stay up to date, then with this course, you will never need to buy another Excel course again.
There are 5 modules in this course
Â· Communications and collaboration
Â· General feature improvements
Â· New Functions
Â· Charts and Visualizations
Â· Power tools and data
Each module will have articles and videos. The topics of the article and videos overlap however it is important that you complete both. This will help reinforce the learning and will give you different application examples. Each module also has a quiz and activities for which all workbooks and solutions will be provided.
.Many people donâ€™t need full functions and formulas course, or beginner to advanced course. They just need to know whats changes and how to use the changes. And thatâ€™s what this course is all about. This course is aimed at experienced Excel users looking to stay up to date and it is not designed for beginner Excel users or those looking for a deep dive into Excel.
Who this course is for:
Excel users moving from Excel 2016 or 2019 to Excel 365
Excel users that just want to know what has changed in Excel to keep their skills up to date
Experienced Excel users looking to keep up to date with changes
This course is not for you if you are not experience and familiar with Excel

User Reviews

Rating

average 0

Total votes0

Focused display

Paula is a qualified CPA with over 25 years of experience in the fields of Accountancy, Business Management, Operations Management, and Training. All across a broad range of industries and sectors. Paula has been Key Speaker at many Accounting Events where her talks on Excel are received very positively. Taken from her experiences in Accounting and business fields, Paula began teaching on Udemy in the area of Spreadsheets, Bookkeeping and Accounting. In 2020 & 2021 Paula was awarded Microsoft MVP for her dedication to Excel and the Excel community.In 2022 after Paula pivoted her training and consultancy to focus on Web3, Blockchain, Digital assets, and cryptocurrency and is excited to bring new courses on these topics to Udemy

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.