How to retrieve an Excel file crashed due to System Shut down
If you are in a situation where your computer suddenly switched off and the Excel file you were working on got closed …
Showing posts from 2020
What are the limits if the row header and column header in Excel sheet?
With Microsoft Excel 2016 the total rows an Excel worksheet can have is 1048576 rows. In terms of columns, you can hav…
In which tab hyperlink option is available in Microsoft Excel?
Hyperlink in excel. Text in a cell can be hyperlinked to either a webpage or to a place in the same document or email.…
How is Data "Analysis" different from plain reporting : AKA Synopsis writing
When we send out reports. We are more often than not in “URGENT” mode. Unless or until mentioned we never send any insi…
Is there a free database solution?
Yes. Oracle Database XE is free for fall and supports a database of 12GB. Its is easy to install and hassle free exper…
ROLLUP function: How to get sub total row in a Oracle SQL query as output
In oracle SQL query when you query for any data, the output is table of columns and rows selected. But there is not to…
How to unhide all the hidden sheets at once - Microsoft Excel
When working with big dashboards we hide lots of backend sheets so that final dashboard is clean. The easy part if hid…
How to get contents from a Hidden sheet in a Protected workbook - Microsoft Excel
When you have a Excel file which is protected and you have forgotten the password. Now how do you retrieve the content…
How to filter for multiple values in Microsoft Excel dashboard
When it comes to dashboards in Excel, we rely on the data validation list predominantly to act as user inputs based on…