My Account Log in

1 option

Excel for the Web Tips and Tricks (Office 365/Microsoft 365)/ with Joshua Rischin.

LinkedIn Learning Available online

View online
Format:
Video
Author/Creator:
Rischin, Joshua, speaker.
Contributor:
linkedin.com (Firm)
Language:
English
Genre:
Instructional films.
Educational films.
Video recordings.
Physical Description:
1 online resource
polychrome
Place of Publication:
Carpenteria, CA: linkedinchescom, 2021.
System Details:
Latest version of the following browsers: Chrome, Safari, Firefox, or Internet Explorer. Adobe Flash Player Pluginches JavaScript and cookies must be enabled. A broadband Internet connection.
Summary:
Learn how to get more out of Excel for the web (also known as Excel Online), the browser version of the spreadsheet app from Microsoft.
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.
Participant:
Presenter: Joshua Rischin
Notes:
3/02/2021
Access Restriction:
Restricted for use by site license.

The Penn Libraries is committed to describing library materials using current, accurate, and responsible language. If you discover outdated or inaccurate language, please fill out this feedback form to report it and suggest alternative language.

My Account

Shelf Request an item Bookmarks Fines and fees Settings

Guides

Using the Library Catalog Using Articles+ Library Account