Nano Tips and Shortcuts for Using Excel with Kat Norton
With Kat Norton
Liked by 3,393 users
Duration: 6m
Skill level: Beginner
Released: 3/6/2023
Course details
Welcome to our Nano Tips series, where LinkedIn Learning creators deliver impactful lessons in literally seconds. Here, Microsoft MVP and Miss Excel, herself, Kat Norton gives you the latest useful tips on getting the most out of Excel. Learn how to use the new VSTACK function and find a solution to volatile functions. Find out how to use sparklines in your cells to visualize data, and then master automatic list numbering with SEQUENCE and COUNTA functions. Go over shortcuts to remove empty columns, highlight duplicates in a data set, and flash fill to combine names. Discover which items are not on a list using FILTER and COUNTIF, and then learn to fill a series of cells in your data pivot table with the text above the cells. Practice adding a bar chart to your Excel cell. Plus, find out how to create a centered spreadsheet title without merging cells.
This course was created by Kat Norton. We are pleased to host this training in our library.
Skills you’ll gain
Earn a sharable certificate
Share what you’ve learned, and be a standout professional in your desired industry with a certificate showcasing your knowledge gained from the course.
-
Showcase on your LinkedIn profile under “Licenses and Certificate” section
-
Download or print out as PDF to share with others
-
Share as image online to demonstrate your skill
Meet the instructor
Learner reviews
Contents
What’s included
- Learn on the go Access on tablet and phone
Similar courses
Download courses
Use your iOS or Android LinkedIn Learning app, and watch courses on your mobile device without an internet connection.