How To Remove Extra Spaces In Cells In Excel

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

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 … Continue reading Excel Error – Pivot Table Does Not Group Dates Properly or Give Errors

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 … Continue reading How to Fix – “Be careful parts of your document may include personal information” Error Message in Microsoft Excel

Interactive Excel Graph

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 … Continue reading Interactive Excel Graph – How to create?

How to open a CSV file if you don’t have MS Excel installed?

When I joined my new company, I was given a Mac and was asked to do all my works with that. That Mac didn’t have MS office and it was not allowed to install as well. So I was finding it very difficult since I had to deal with MS excel and CSV files. Ultimately I found the solution of my problem, I am sure … Continue reading How to open a CSV file if you don’t have MS Excel installed?