I find working with Macros quite fun. I have automated many of my repetitive, manual and really really boring tasks with Excel VBA Macros. Once I got a task of copy-pasting more than 10,000 lines of items one-by-one from Excel to one of our ERP system and print these items. Usually, it would have taken me several days to finish this task but with macros, … Continue reading Two Easy Ways to Stop or Interrupt a Running Macro Command Without Closing Your Excel File?
Most of the time you may not need to cancel a command or interrupt your ongoing calculations in Excel as it carries out swiftly. But many times if you have got a very big file with lots of formulas and you have given a command or started any calculation say filtering any data then it may take a while to finish the action depending on … Continue reading Two Easy Ways to Cancel a Command or Interrupt Any Ongoing Calculations in Excel?
You want to change your Google Adsense account’s country to receive your website earnings in new country’s bank. When you go to Google Adsense account settings to change the address then you find that you can only change the address but not the country. Can you really change the country? Answer: No, You Can’t Google AdSense only allows you to change your address within the … Continue reading How To Change Country In Adsense
One of the common queries that I receive is “how I can clear cookies?” Probably they want to keep their browsing tracks clean. Before we start, let’s talk about Cookies; these are text files written by web browser like Google Chrome when you browse certain website. It stores your browsing information such as your login details, forms filled in the website and other information that … Continue reading How To Clear Cookies In Chrome Browser
Sometimes, when you copy the texts from website to excel then you may find extra spaces that you may like to remove it. If you have few texts then you can easily manually remove it but if you have got zillions of cells then it becomes quite a challenge. Simple Fix Luckily Excel have a simple solution for it. If your excel cells have got … Continue reading How To Remove Extra Spaces In Cells In Excel
If you encounter this error while attempting to login too many times then you may have to wait for 10-20 minutes in order to get your login page back. It’s a hosting server specific error that prevents your website against hackers. Next time, when you get your login page back, try to reset your password and login again instead of trial and error. Continue reading WordPress “Unused” Error When Login Password Entered Incorrectly
I work with large data in spreadsheet and pivot table comes very handy in summarizing the data. However, often I encounter with an error when I try to group the multiple sets of date. Types of Pivot Table Date Grouping errors Pivot Table does not Group dates properly – It gets grouped into just one Group namely ‘Group 1.’ Sometimes it gives an error that … Continue reading Excel Error – Pivot Table Does Not Group Dates Properly or Give Errors
If your Macbook Pro or MacBook Air is giving you hard time with issues like : The battery is not charging. The cooling fan has suddenly started making non-stop loud noise and it won’t go no matter how many times you restart the system. MacBook get frequently hanged and you lost all your work. There is a simple fix to all these problems. You just … Continue reading How to Fix – Macbook’s Battery Not Charging? Fan Problems? Overheating?
Lately, my Excel file started popping-up an error messages. It’s so annoying as it pops-up every time I save the file which I do like every 30 seconds. “Be careful parts of your document may include personal information that cannot be removed by the document inspector.” I fixed this error as below – Step 1 – Open your spreadsheet and go-to File Step 2 … Continue reading How to Fix – “Be careful parts of your document may include personal information” Error Message in Microsoft Excel
Yesterday one of my friends Whatsapped me for finding a suitable job for one of her friend. We had a brief chat and I suggested her that going through Recruitment Agencies would open a door for her friend. As per my personal experience, in Australia, there are only four prominent ways of landing to any job and they are – 1) Personal Network The fastest … Continue reading Top 14 Recruitment Agencies In Australia To Find Your Dream Job
These days we tend to watch more videos on Facebook over Youtube. Mostly, they are shared by our friends or are related to our interest area. Many times, we come across videos that we would like to keep it for future use. One way of doing that is saving the link or sharing it in our own timeline. However, what if, we would like to share outside the … Continue reading How To Download Facebook Videos
In last post I mentioned about how to find if someone has blocked you on WhatsApp. Today, lets find out how to unblock yourself. It’s a simple trick that can come handy if you want to reach out to someone to clarify any sort of misunderstandings. Following steps will unblock you, if someone has blocked you – Go to WhatsApp settings Click account and then click on delete … Continue reading How To Unblock Yourself on WhatsApp If Someone Has Blocked You