How to Fix – Macbook’s Battery Not Charging? Fan Problems? Overheating?

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 need to reset your PRAM and SMC.

Before you go further, it is highly recommended to take back-ups of your important files and photos.

How to reset the PRAM?

  1. Shut down your MacBook by pressing power button for longer period. 
  2. Once your system is completely shut down. Press the Power button.
  3. Then, Press Command Option P R at the same time and keep holding these keys until the grey screen appears.
  4. After sometime, you will hear the Macbook’s Start-up sound. You can now release the keys, and let your MacBook do the rest of the work.
  5. You are done.
1) Press the Power button.
2) Then, Press Command Option P R at the same time.

How to reset the SMC of your MacBook Pro or MacBook Air?

  1. Shut down your MacBook by pressing power button for longer period.
  2. Keep the power cord of your MacBook plugged in.
  3. Press Shift-Option-Control Power Button at the same time and then let go
  4. Now, turn your MacBook on.
Press Shift-Option-Control Power Button at the same time and then let go

Excel Error – Pivot Table Does Not Group Dates Properly or Give Errors

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 that data set can’t be grouped.

Various reason for not grouping dates

  • Dates are in text format or non-date format
  • There are extra characters hidden in some of the cells of date column
  • Date locale issue – your locale (PC) uses DMY date format and the text date is using MDY date format (or the other way around)
  • Selection Issue

How to fix this error?

a) Convert Text Formatted Dates into Real Date Format

  • Select the date column
  • Hit Ctlr + H to open ‘Find and replace’
  • Type / (forward slash) in ‘Find what’ and in ‘Replace with’
  • Hit Replace All
  • All Text formatted date will be converted into Real date format

Type / (forward slash) in ‘Find what’ and in ‘Replace with’

b) Remove extra characters in some of the cells of date column

  • Select the date column
  • Hit Ctlr + H to open ‘Find and replace’
  • In Find what space, Type Alt key, and then type 0160. Nothing will type in space and it will remain empty. Also, Keep Replace with space blank.
  • Hit Replace All
  • All Text formatted date will be converted into Real date format
  • Also, make sure to manually remove any visible funny characters, words, alphabets.

1) Type Alt key 2) Type 0160, Nothing will type in space 

C) Fix Date Locale Issue

  • Select the date column
  • Go to menu >  Data > Text to Columns, select Delimited options and hit next
  • Keep everything blank in this window and hit next
  • Select date and in drop down menu select the date type that your system is using. You can use trial and error method by selecting different format and see what works for you.
  • Hit finish
Go to Data> Text to Columns, select Delimited and hit next.
Keep everything blank in this window and hit next
Select date and in drop down select the date type that your system use. You can do trial error by selecting different format and see what works for you.

D) Fix Selection Issue

After creating Pivot table if you do not select date properly then also it may not group as per month and year.

Sometimes, if you select dates not properly then it will get grouped into just ‘Group1’

To fix this selection issue. All you need to do is select any cell and take your cursor to lower part of selected cell until a downward arrow appears and then click to select all other cells.

1) Select any cell 2) Take your cursor at lower part of the cell until downward arrow forms 3) Click to select rest of the cells
All cells will selected like this then right click and hit Group

Please let me know if all these tricks solves your Pivot table date grouping issue or not.

How to Fix – “Be careful parts of your document may include personal information” Error Message in Microsoft Excel

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 – Click Options


Step 3 – Go-to Trust Center


Step 4 – Click Trust Center Settings

Step 5 – Click Privacy Options and Un-check the box that says “Remove personal information from file properties on save” and click OK.


Done. That annoying message will now stop bothering you.

Top 14 Recruitment Agencies In Australia To Find Your Dream Job

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 way to land into any job in Australia is via a personal network. If you know someone in that workplace then you may get that job in no time or at least you’ll be called for an interview. The reason why this method works so flawlessly is that 80% of the jobs are not advertised anywhere and hiring through personal network builds the trust factor. You can build a personal network by going to various networking programs like by joining Meetup groups, or Toastmasters events, or your industry specific events. You can also expand your network through Linkedin.

2) Recruitment Agencies

Second best chance of landing your dream job is through a recruitment agency. They act as a mediator between employer and job seeker. Hiring a good candidate for any company is an expensive affair. Therefore many companies outsource this task to third-party recruiting agencies. You can submit your resume to these agencies and wait for their call. Also, you can even fix a meeting with them for personal meeting and look for suitable openings or guidance. Also, you can attend their Meetup group events for networking. I have provided 14 of such recruiting agencies. The list is not limited to what I have provided, you can Google for more.

Top 14 Recruitment Agencies In Australia (in no order)

  1. Robert Half
  2. Morgan Consulting
  3. Hudson Australia
  4. Smaart Recruitment
  5. Horner Recruitment
  6. Hays Recruiting Experts
  7. Dixon Appointments
  8. Manpower Australia
  9. Michael Page
  10. Adecco
  11. Randstad
  12. Recruit Saver
  13. Superior People Recruitment
  14. First Personnel
  15. Find more at>>

3) Job Hunt Websites

I am really not sure if these websites really work or not. As per my rough estimate, if you apply for 200 jobs, you may or may not get a call for an interview for one job. But there is no harm in trying. You really need to tailor-made your resume, cover letter, and email as per job opening to increase the chance of getting interview call.

4) Cold Calls

It is nothing but visiting directly to various companies and dropping your resume. It may work for small businesses like tax firm but it may not work for bigger entities.

Picture Credit: PXhere.com

How to convert an URL/html to PDF?

Many times we need to convert an URL to PDF, reasons might be different, the solution is pretty easy. You do not need any tool (if you Google, you will get many), you don’t need any software. This can be done right from your browser, see the process below.

  1. Open the URL you want to convert
  2. Now press Control+P (the one which is used for printing)
  3. Now click on the change button
  4. Now you would get a box like this, click on save as PDF
  5. And TA DA…. you are done

Not to mention, the same process can also be followed for any html file you have. All you have to do is to open that html file in your browser and follow the same process.

Thank you accepted with a welcome note 🙂

Is Cell Phone Monitoring Technology Worthwhile?

There’s no doubt that the coming of cell phone spying app technology has made life so much easier. Business owners have a lesser risk of losing potential business opportunities if they keep their cell phones close. Moreover, now employers can keep track of the whereabouts of their employees and track their internet usage while they are at work, with the sole purpose of increasing productivity at the workplace. In personal life too, cell phone technology has come as a solution to so many problems. Spouses can keep in touch through the day, coordinate and plan daily activities, keep in touch with their children while they are away, and make sure their loved ones are safe.

Who are the Most Users of a Cell Phone Spying App?

Apart from the reasons for using cell phones, with technological advances, the online gaming experience has changed drastically. Children and adults alike become addicted to online games and download the apps into their cell phone for easy access. These sorts of cell phone activities prove to be major distractions and the cause of decreased productivity. Not just gaming, but excessive use of social media sites has also become a major concern for business owners.

Another side to the big picture is that while the majority of people are using modern technology and the internet to improve their lifestyles, some wicked people behind the scenes are using it to cause harm. Hacking has become one of the greatest threats online, espionage and cheating have become part of the competitive ideology, and at the same time, sexual predators, kidnappers, and blackmailers are using technology.

Who are the most vulnerable people with the most to lose because of technology? The answer is mind boggling, but Sarsonline confirms that everyone is at great risk, not just children, adult women, or adult men. The reason for this is that the majority cell phone users are android and iOS smartphones users.

Android and iOS Smartphone Users Stats

Here’s a graphical representation of the number of android smartphone users in the world from 2014 until 2019, according to statista. Based on the statistical facts below, there will be approximately 2,082.7 million expected Android device users in the world by the end of 2016.

On the other hand, it seems there are fewer iPhone users, with the figures being as low as 150.26 million. Based on this comparison, it is obvious that Android smartphone users are quite many, which explains why Google Play Store offers a larger number of apps. Due to increasing online security threats, a majority of cell phone users have been downloading monitoring apps.

Why Monitoring Apps are Worthwhile

Xnspy and similar monitoring apps allow users to remotely access the target’s emails, text messages, browsing history, internet messengers, installed apps, call logs, make screenshots, lock the device remotely, track the device and hence the target person’s current location through GPS tracking. This can help keep people safe and make sure they use their cell phones responsibly without letting it affect productivity at workplaces and at schools in the case of children.

Potential Victims of Online Threats

Not using mobile monitoring can make people vulnerable to predators and other harmful activities online. According to the same research by Sarsonline.org mentioned above, no ethnicity in the U.S. is safe. Sexual predators attack as many as 80% of cell phone users who are whites, 18.8% victims are blacks, 6.8% are from Asian Pacific areas, 34.1% are Alaskans, 3% are American men, and 24.4% are mixed races. Every race living in the U.S. has a minimum of 17.6% sexual assault victims who become targets via cell phone activities.

What Makes People a Potential Target?

While using cell phones has become an integral part of modern lifestyle, many users ignore taking security measures like installing a cell phone spying app. Sharing personal information like home address, social security number, family details, etc. People who readily take the risk of going on blind dates with complete strangers are also an easy target. Children below the age of thirteen and teenagers are also an easy target for online predators, cyberbullies, and kidnappers. Anyone who uses internet messengers like WhatsApp, Facebook, Viber, Skype, Line, and Kik, who text frequently, and call random people too often are at risk.
To wrap things up, people who are constantly using emails via their cell phones and who use the browser on their cell phone for online transactions are also at risk. Saving personal banking details, passwords, and login details on the browser is not a good idea, especially while using a public or shared Wi-Fi connection, even at work. With monitoring apps installed on target cell phones, business owners and parents can make sure that their target people avoid being careless with online activity and use their cell phones in the right way.


How to Install and Play Pokemon Go in India

Are you looking for a way to download Pokemon Go on your Android or iOS phone in India?

Since this game is only available in few countries and India not being one of them, you might get disappointed that you can’t play this game. Well, don’t get disappointing, here ‘s how you can download, install and play this game in India, both in iOS and Android.

How to download, install and Play Pokemon Go in Android

  1. Visit this link
  2. Download the APK file
  3. Go to your settings>Security and check “installation of apps from unknown sources”
  4. Once downloaded. click on it to visit the APK file
  5. Click on Install and you are set to play Pokemon Go on your android phone in India

How to download, install and Play Pokemon Go in iOS

For iOS the installation is slightly different but good god its still possible and nowhere near as hard as the roblox hack. So you can do it in two ways, the first is to borrow an Apple id and the second one is creating a new apple id alogether

Borrow Apple ID

  1. Ask a friend to share his Apple id and password who lives in a country where Pokemon Go is available
  2. Log out from your Apple id and enter his ID and password
  3. Now search for the Pokemon Go game on App store and download and install it
  4. Since its not your ID,  you ill have to sign out and sign in again with your own ID
  5. Reinstall again Pokemon Go from your saved files from cloud

Create a new Apple ID

Here’s the process is almost same, the only difference is instead of borrowing an ID, you create one by yourself

  1. Sign out from your Apple ID
  2. Go to setting and select General>Language and Region>Change region to US or Australia and or Canada
  3. Open App store
  4. Create a new Apple ID
  5. Add billing as None and select an Address of the country which you mentioned earlier
  6. Now search and download Pokemon Go
  7. Install Pokemon Go and sign out from this fake Apple ID and sign in to your original Apple ID
  8. Your installation will be lost but since your data is saved on cloud, you can install the game again.

Hope this helps, do play the game and let us know how you enjoy this.

How To Download Facebook Videos

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 Facebook universe? For that, we do have various phone apps and websites which helps to download these videos. One such website which works well for downloading Facebook video is FBDown.net.

Steps to Download Facebook Videos

Step 1# You need the URL or link of the video. How to get that?

Right click on the date or time of the video and copy the link.


Step 2# Go to fbdown.net and Download

Enter the copied video URL or link in the input space provided in site and hit download

Select the video quality by clicking it and you are done.


How To Unblock Yourself on WhatsApp If Someone Has Blocked You

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 my account
  • Go ahead deleting your account by entering your phone number and delete your account.
  • Afterwards, uninstall WhatsApp from your mobile.
  • Then, restart your phone.
  • Now, again install WhatsApp with same old number.
  • Once installed, you’ll get unblocked from all other accounts.
  • However, you’ll be removed from all your existing groups. So choose this method sparingly.

How To Find If Someone Has Blocked You On WhatsApp?

Have you ever tried to find out if someone has blocked you in WhatsApp? I hope you don’t have to be in that situation. However, there are various indicators that may tell you that, you are blocked by someone:

  1. Firstly, you will not to see their ‘last seen’ or ‘online’ status.
  2. Also, you will no longer see any updates to their profile photo. You will always find same old photo.
  3. Moreover, if you try to send any message to them, you’ll always see one check mark which is a message sent indicator. You will never see the second check mark which is a message delivered confirmation.
  4. Lastly, if you try to call them then it will not go through.

There is no direct way to know if someone has blocked you. But you see all these indicators then most likely that person has blocked you. And telling you that, he or she is really annoyed with you. However, often some people turn off all these four indicators for privacy issues. Hence, you may never know if someone has really blocked you or just avoiding answering your messages. But whatever is the reason, just try to get connected with the person through other ways to apologies, just in case, if any of your action has offended them.

Interactive Excel Graph – How to create?

This article will be very useful for people who work on excel and create a lot of reports and wants to create interactive excel graph. Often your clients or boss asks for details on a graph and then you have to go back and make changes and appear in front of them just to be asked for another change.

Story Behind Interactive Excel Graph

Very recently a client of mine was asking me to prepare few reports and every time I prepared something, she was asking for some other and it was taking a lot of time. So basically I was trying to find a solution to this and I came across this interactive excel graph which can present data on multiple levels and as you change your parameters or range, the graph will change simultaneously. The fun part is you don’t have to go back to your data and make changes there, you can make those changes right in the graph.


  1. Select your data set, Interactive Excel Graph
  2. Go to Insert tabInteractive Excel Graph
  3. Click on Pivot tableInteractive Excel Graph
  4. You will get a pivot table like this. Now select parameters that you want to show in your graph Interactive Excel Graph
  5. You should get a pivot table like this. Now select this pivot tableInteractive Excel Graph
  6. Go to insert tab and choose the graph you prefer. I have chosen column graph here Interactive Excel Graph
  7. You should get a graph like this Interactive Excel Graph
  8. But wait, the catch is here. At the left bottom side of the graph, do you see few tabs? Yes, these are your parameters of your graph which you can adjust right there. For example I have changed the parameter Category here and I have only taken Office supplies and the graph responds to that automatically Interactive Excel Graph

This is pretty fun. This tabs works like filters and you can filter out anything you want right there in the graph and there’s no need to come back to your data. So if you boss asks to show graph for a particular month and for a particular region and only sales number, you have a solution, your  interactive excel graph.

Hope this helps.

How To Fix Audible Charges with 888-283-5051 NJ USA and Get Your Refund

How To Fix Audible Charges with 888-283-5051 NJ USA and Get Your Refund I regularly buy Kindle books from Amazon.com. But I never bought Audio books as they are kind of over priced. However, few days back, I was simply browsing through audible site and looking for types of books they are offering. I went there while exploring panachedesai.com/book. I didn’t click anything apart from landing page of the book and definitely didn’t hit the purchase button. But next day when I checked my bank statement in my mobile. I found $19.27 deducted along with $0.58 international fee. First I thought, may be I accidentally clicked purchased button. But later when I checked my Amazon account purchase history (as Audible is part of Amazon) I didn’t find any new audio book. I thought it was either some kind of BUG or some kind of SCAM.

How I fixed it?

I went to their site and wrote them a simple request message explaining about my situation. And they agreed to refund back.


I recently browsed through audible website for Audio books. But I never purchased or subscribed anything.

But it has charged me $19.27 and $0.58 from my bank account on Wed 20 Apr 2016. My bank account is showing 888-283-5051 NJ USA as reference

Please help me to refund my money urgently.

Kind regards,

They replied as follows –

Hello Rajesh,

Thank you for contacting Audible!

My sincerest apologies for this upsetting situation. I have personally checked your account and I found out that the charges you have received, has come from an active Audible membership which started from a free trial membership.

We understand that this might have been accidental or, at the very least, you did not intend to continue with the regular paid membership. I am sorry our warnings were not clear or might have been bypassed.

Nonetheless, our job here at Customer Support is to remove such concerns from you or to make amends as best we can because, even if you do not want anything to do with Audible, we don’t want to leave you with a bad impression of us and we certainly do not want to be billing you for Audible products or services you do not want.

We have canceled your Audible membership and issued a refund back to your credit card. Depending on the bank, a refund can typically take about 7-10 days to appear in your account. Please rest assured that you will not receive any further charges from us since I have already cancelled your Audible Gold Monthly Membership.

Thank you again for contacting Audible. If you would like additional assistance, please do not hesitate to contact us. We are here to help 24 hours a day, 7 days a week.



Image Credits: investopedia.com