unlock

Top 25 Excel 2016 Tips and Tricks

0:00
↔️ ↕️

Timecodes:

After years of using Excel in a corporate environment here are my top 25

Excel 2016 tips and tricks.

Welcome to Sele training. I'm about to show you some useful tips and tricks for

Excel 2016. They're in no particular order so be sure to watch all the way

through to the end of the video. These tips and tricks have made me more

productive and I'm sure they'll make you more productive as well. Take a moment

and click the Subscribe button on the bottom right of this screen or at the

end of the video click on my smiling face and as always like, share, comment,

ask me questions. I'm happy to answer every question that I receive. Now let's

get started. Number 1 - Quick Analysis Tool. Most people aren't aware of the

Quick Analysis tool. When you highlight any table, in the bottom right-corner is

an icon. This is the Quick Analysis tool menu. If you click on that it gives you a

wealth of options you can choose from. To modify your table for example, I can

click on Totals. Click Sum and it shows the sum of the columns. You can click

this sum and it sums the rows. You can also do formatting on the table, add

icons, create charts and insert them into your spreadsheet, turn it into a table,

and add sparklines. There's so much available here and it makes it quick and

easy to avoid going through the menus and manually inserting each one of these

different options onto your table. Number 2 - Filter.

if you're not using filter you should be. It's very simple. Just click anywhere

inside of a table of data, go to the Data tab, click this Filter icon, and it


Related queries:


how to open excel in excel online
how to unprotect excel sheet in excel online
how to open local excel file in excel online
how to unlock cells in excel online
how to unlock sheet in excel online
how to unlock tab in excel online
how to unlock excel online for editing
how to open excel in online mode
how to unlock excel online
how to unlock workbook in excel online