How to freeze rows in excel
Ever have a report that is too big to fit in one screen but when you scroll you loose the context? Something like this.. Use FREEZE PANES option in Excel to “Freeze” top rows / columns We can use the excellent “Freeze panes” option in Excel to make the top few rows (and columns) sticky. […]
Automatically Format Numbers in Thousands, Millions, Billions in Excel [2 Techniques]
Ever wanted to automatically format values in thousands, millions or billions in Excel? In this article, let me show you two powerful techniques to do just that.
35 shortcuts & tricks to make you an #AWESOME Data Analyst
Analyst’s life is busy. We have to gather data, clean it up, analyze it, dig the stories buried in it, present them, convince our bosses about the truth, gather more evidence, run tests, simulations or scenarios, share more insights, grab a cup of coffee and start all over again with a different problem.
So today let me share with you 35 shortcuts, productivity hacks and tricks to help you be even more awesome.
#### in Excel cell
You open an Excel file and some cells show #### instead of the value. Here is a quick fix.
How to connect to a SINGLE file on SharePoint from Power Query (Fix Unable to Connect Error)
Want to connect SharePoint files to Power Query but keep getting “unable to connect” error? Here is a simple fix to the problem.
Filter one table if the value is in another table (Formula Trick)
I have an orders table and want to see only orders from a given list of products. We can use Excel’s FILTER function to do this.
Sorting values in Olympic Medal Table style [Quick Tip]
It is Olympic season. Everyone I know is tracking the games and checking their country’s performance. One thing that we notice when looking at medal tally is,
A single Gold medal is worth more than any number of Silver medals. Like wise, a single Silver medal is worth more than any number of Bronze medals.
So, when you look at the ranking of countries, you see countries with single Gold medal higher up than countries with lots of Silver and Bronze medals (but no Gold).