Quick Excel Tips and Tricks 2020

Quick Excel Tips and Tricks 2020

In this tutorial, we will learn 10 quick and very useful Excel tips that will help you improve productivity at work.

Please navigate through the content below:
– Content 0:34
– Format multiple sheets at the same time 0:48
– Use a table to enter formulas automatically 3:05
– Display all formulas at once 4:35
– Select all formulas in a worksheet at once 5:56
– Paste special 7:03
– Select an entire row/column 8:32
– Move or copy data between existing rows or columns 9:32
– Freeze and lock panel options 11:36
– Set document recovery options 12:54
– Create and manage dropdown lists 14:50

Data link: https://drive.google.com/file/d/1Gk5mtbNHrMo1G6-x-OHPFvyOQF2Y5OyL/view?usp=sharing

Please follow us on:
LinkedIn: https://www.linkedin.com/company/vizxlization
Facebook: https://www.facebook.com/vizxlization/
Instagram: https://www.instagram.com/nestoradria…

Leave your comments and questions below!
Don’t forget to subscribe!
Thanks so much!

#vizxlization #MsExcel #ExcelTips #Excelshortcuts

Leave a Reply

Close Menu