How to achieve inner peace in chaos: Work from Home drama

Its chaotic, really chaotic when you are working from home and yes when you have a pandemic to add to the recipe its like adding salt on the wound. AND the last straw is if you have kids who are aged between 0 to 4 years old. 

I bet life is a CIRCUS with the above configuration in you life's circuit. Consider this:

1. You have a zoom meeting.
2. Your kid has done poop.
3. Your spouse is busy in the kitchen dealing with the critical phase of her cooking (which if disturbed will leave you hungry for the rest of the day).
4. Your parents are not in a position to help.
5. AND to add the icing on the cake there is a relative who is arriving in 30 mins.

Ok how do I deal with this now? There is no alternative and no respite.

F**K you just cant ignore any of the above situations. After cursing yourself for a moment. You will have to put off your video on Zoom, get to your messy kid first with your headphones ON like a astronaut. Carefully maneuver through the stuff when on mute in Zoom.

Once your kid is glittery clean and dressed up. Clean the shit, throw the shit, clean your hands and all through this hope you are not asked to present anything on the Zoom call.

As soon as you give a sign "Yes, I accomplished". There comes another task from your spouse to go to the nearest provision store and get few important items needed to prepare "extravagant feast" (which you will never get for life) for the in the incoming souls-from-hell aka. guests.

How do you find some "me-time" or rather some inner peace? A MILLION DOLLAR QUESTION

Every moment you feel like what-if the offices re-open and my boss calls me to office RITE-THIS-MOMENT? but no that never happens.

Firstly, stop cursing yourself. sink in the experiences you just went through. To give deeper thoughts to what is happening at this moment. You may hate few people, you may feel like killing self. But no you are not supposed to do that. Instead, find opportunities of peace. While walking to the provision store you have me-time, utilize it!

Me-time need not be in hours. It comes in a very tiny bits since the pandemic hit us!! When I say tiny-bits its in minutes!!! Organize yourself in these tiny moments of bliss to enhance your mood. No point in taking out your frustration at family or colleagues. Use this frustration to fuel your vehicle to reach life goals, be it personal or professional.

Just by doing this simple routine in your mind for few instances. You have began the process of re-wiring you brain to be less unhappy and more organized.

Stay tuned! More to come in Work home Home mental health series

How to show a value in Millions in Excel

Update 2025: If you are looking for the best hardware to handle this kind of analysis, check out my new guide on the Top 5 Tools Every Data Analyst Needs

 In Excel, when are designing a dashboard with big figures like  number which runs into Millions. Its not a good idea to show all the digits in the cell as this might make the dashboard look very busy and doesn't make any sense to the executives who would review it.

In these cases you can use the "Custom" Format to mask the value into showing in millions. As shown above enter "#0.0,, "M" without quotes and the value will be shown in Millions. Observe the formula bar the value is not modified but the way it is represented is masked in the cell. 

How to retrieve an Excel file crashed due to System Shut down

Update 2025: If you are looking for the best hardware to handle this kind of analysis, check out my new guide on the Top 5 Tools Every Data Analyst Needs

 If you are in a situation where your computer suddenly switched off and the Excel file you were working on got closed without saving.

Now for the below method to work your need to have "Auto Save" feature turned on in Microsoft Excel 

To check if Auto Save is turned on follow the below path in your Excel

File-->Options-->Save, now on the right hand side tick the "Save AutoRecover information every X minutes and also tick the "Keep the last autosaved version if I close without saving" option.

Now whenever you excel crashes, the most recent version which was autosaved despite you not saving it will be available when you open a blank excel workbook.

If you want see other versions of the crashed workbooks which are not saved. follow below path.

File-->Open-->Scroll till bottom and click on "Recover Unsaved Workbooks"

 

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 have 16384 columns.

Well, that's a huge number of rows and columns to play with but, remember, if you fill each cell in these rows and columns the performance of the workbook will not be optimal. Yes Microsoft has provided avenue for entering data but to processing should also be supported by a good chip and board.

Probably, you can go for the cloud version of Microsoft Office (365) which should perform with a good internet connection.

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. Hyperlink option is found under the "Insert" tab in the ribbon at the top.

Once you select the desired cell and click on the hyperlink it would present with the following window.

Here you can customize the link based on your needs.