Financial Services, Consulting and BusinessMarketing, Sales and CommunicationsSocial Impact, Education and Government

Nano Tips and Shortcuts for Using Excel with Kat Norton

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.

Learn More