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?
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
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
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
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?
Here is a short video tutorial on how to easily copy Excel sheet table with rows and columns in word document. Continue reading How To Easily Copy Excel Sheet Table With Rows And Column Headings In Word Document?
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?