Excel Online Tips and Tricks (Microsoft 365)

Focused View

Joshua Rischin

1:00:50

0 View

01 Introduction

001 Be more productive with Excel for the web.mp4

01:31

002 Exercise files.mp4

01:11

02 Working with Data

001 Get started with data.mp4

02:42

002 Data cleanse using Remove Duplicates.mp4

02:08

003 Add data quickly with Flash Fill.mp4

02:06

004 Simplify views with Groupings.mp4

01:56

005 Think ahead by using Tables.mp4

03:20

006 Control inputs with Data Validation.mp4

03:34

03 Formatting Tips

001 Distinguish information with custom formatting.mp4

03:05

002 Interact with the web using hyperlinks.mp4

02:37

003 Identify standouts with conditional formatting.mp4

02:21

04 Customizing Workbooks

001 File naming on the fly.mp4

01:39

002 Get organized by customizing tabs.mp4

02:41

05 Working with Charts and PivotTables

001 Create PivotTables in just a few clicks.mp4

01:27

002 Create PivotCharts in just a few clicks.mp4

02:05

06 Collaborating with Excel for the Web

001 Engage with collaborators by assigning tasks.mp4

02:38

002 Customize your view of a file with Sheet View.mp4

02:31

003 Share files with collaborators.mp4

01:29

004 Protect your work by setting permissions.mp4

02:13

005 Coauthor in real time.mp4

01:53

07 When to Work in Excel Desktop

001 Use Excel desktop to enhance charts.mp4

01:59

002 Use Excel desktop to add slicers to PivotCharts.mp4

02:23

003 Set up range names in Excel desktop.mp4

03:42

08 Using Advanced Features

001 Unlock the power of AI using Excel Ideas.mp4

02:08

002 Find out even more with Workbook Statistics.mp4

01:04

003 Save time with scripts.mp4

03:13

09 Conclusion

001 Put your learnings into action.mp4

01:14

Description

Excel for the web offers many powerful features, but because its interface differs from the interface of the desktop tool, most users only use its basic spreadsheet functionality. In this course, instructor Joshua Rischin shows you how to get more out of Excel for the web. Joshua explains some basics of data, including how to cleanse data and use Flash Fill to add data quickly. He gives several useful tips for using custom formatting, hyperlinks, and conditional formatting in Excel for the web. Joshua goes over how to customize your workbooks, as well as create Pivot Tables and Pivot Charts. He covers ways to collaborate, while still protecting your work, and discusses how to use Excel Desktop to get even more from your Excel for the web experience. He steps you through some advanced features, like Excel Ideas and scripts, then concludes with advice on how to apply what you’ve learned from the course.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Excel

Joshua Rischin

Instructor's Courses

Linkedin Learning

View courses Linkedin Learning

LinkedIn Learning is an American online learning provider. It provides video courses taught by industry experts in software, creative, and business skills. It is a subsidiary of LinkedIn. All the courses on LinkedIn fall into four categories: Business, Creative, Technology and Certifications. It was founded in 1995 by Lynda Weinman as Lynda.com before being acquired by LinkedIn in 2015. Microsoft acquired LinkedIn in December 2016.