Tag

Excel

Create a report in excel for sales data analysis using Pivot Table Techniques

Create a report in excel for sales data analysis is an important aspect of any business. Unless you are able to measure and analyse data, how can you improve your performance? It’s true that improving performance is a whole new story, but unless your data measurement isn’t accurate, you can never hope to reach the...
Read More

Create a Dependent Combobox in Excel and VBA

In this blog, we will discuss how to create a Combobox in Excel and as well as through VBA. List box & a Combobox are similar but have slightly different controls, to let users make multiple choices of items or to enter their own value in a list. Typical examples of items in these types...
Read More

Quarterwise Sales Comparison Dashboard with Charts in excel using VBA

Thanks for your feedback on our earlier blogs. We have already covered how to create a summary report quickly via Excel VBA. In this blog, we will cover the charts in excel. If you have not gone through the earlier blog, then please go through this link: Create Summary Reports Quickly via Excel VBA. In this...
Read More

“God Mode” trick to Unprotect Excel

Open password protected file from this simple excel tips & tricks. Learn how to unprotect excel or remove password from excel. Let me warn you up front – THE MOMENT you learn applying this trick on How to Unprotect Excel, you’ll JUMP in ecstasy. If you are ready, then read on… Almost ALL Excel users wish at...
Read More

How to Update and Delete Using Excel VBA Userform ? | VBA Userform

It’s useful for making a task easy in business areas like Banking Record, Personal Finance, Stock Reporting, Recordkeeping, Automate Training room booking, Hotel Room booking, Car Booking, booking IT resources and approval of business expenses such as refreshments, conveyance, stationery etc. This technique will help User access the data in the VBA Userform only and then if he\she...
Read More

Remove Password from Excel Using VBA [Macros] Tutorial

In this blog, we will try to cover how to remove password from Excel using VBA as part of our continued effort to give valuable resource of learning for Excel VBA Macros tutorial students. If you are following our blogs on a regular basis then probably you have gone through the blog where Rishabh have...
Read More

I was recently invited to hold a 1 day workshop on “Excel for Data Analysis”

I was recently invited to hold a One day Excel workshop on “Excel for Data Analysis” in Baroda Chapter of Institute of Chartered Accountants of India (ICAI). Baroda (Vadodara) is the third largest city in the western Indian State of Gujarat. I was almost half asleep while waiting to board a Sunday morning flight (6:35...
Read More

Find that rascal cells asap – IN EXCEL

  How many cells in your Financial Model have been left blank? Which cells have been fraudulently “modified” or hard-coded after you wrote the formula? How do I delete or color all error laden cells – all in one go? E.g. #N/A! How do I play FreeCell Solitaire? FreeCell Solitaire?! Ignore that. It’s a classic...
Read More

Life is full of What Ifs … (So is Excel!)

What If I were a Baseball Superstar… Also what If I could teleport myself from my office to Miami beach… What If I perform Excel What If Analysis with scroll buttons to do a collar-up in office… Price Sensitivity Analysis using Excel What if: We can’t fulfill the first two wishes. However, our latest course...
Read More

What can you do on a date… err… with a date in excel ?

Dates are one category of information that is found in ALMOST ALL Excel reports. You can maneuver with them like a Maverick (Read: Tom Cruise’s starrer movie – Top Gun) These are the things you can do with a date in excel: You can find which day of the week it is (e.g. Sunday, Monday…)...
Read More

Perform Google Search on Internet Explorer using Excel VBA | Excel VBA

First time in my life I have come across to create this type of automation and finally, I got success. The blog relates with how to search data in Google using Excel VBA and take how many search result it is fetching: For example: Write “Apple” in Google search box Press Enter↵ It will show...
Read More

How to protect cells and hide formula in excel ?

Investment banker protects the excel file by password and hide formula also hide formula in google spreadsheet, but anyone having access to the file can easily access the formulas used in the cell by having a cursor on the cell. As part of our continued Excel Training series,  you will learn how to protect cells...
Read More

How to unlock or lock cells in excel- Single or multiple

Objective of this article: In Microsoft Excel 2007 or later version, we want to protect few cells only in a worksheet, then how to do it? Solution: There are two situations to lock cells in excel depending on these reasons. If You Want the Majority of Cells Locked If You Want the Majority of Cells Unlocked...
Read More

Find or Remove Duplicates in Excel – 3 Simple Ways

Remove Duplicate in Excel with these 3 Simple Ways In Microsoft Office Excel 2007 and in any subsequent versions, you have several ways to filter for unique values or remove duplicates in Excel: Use the Remove Duplicates command in the Data Tools group on the Data To filter for unique values, use the Advanced Filter...
Read More

Error in excel when you Insert Column or Row in Excel (Solved)

Error in excel when you Insert Column or Row in Excel (Solved) Are you fed up with the Errors in Excel while entering a row or column? Then you have come to the right place. This blog will clear all your doubts and ensure that you will never have any errors next time you use...
Read More

Combine Text with Date or Time in Excel – Reporting Tips

Many time you prepare financial reports in multiple sheets where you have to mention the date of signing report along with the certain text. Combine text with a date by following these simple steps: Hence it increases responsibility to update the date in each sheet. What if you enter a proper date in one sheet and...
Read More

Calculate Elapsed Time in Excel

We want to calculate elapsed time in excel i.e. Add or Subtract hours, minutes and seconds to the time. How to calculate elapsed time? Use the following formula TIME (HOURS, MINUTES, SECONDS) to calculate elapsed time in excel. After entering the formula, you may require changing the cell format as per your requirement. In the elapsed...
Read More

Loop Through Multiple Sheets and Merge Data using Excel VBA

In this blog article, we will be covering how to loop through multiple sheets and merge data as per our requirement. Just imagine you have a lot of files in a folder and for each file, you have 3 sheets. Let me explain you how to merge data with an example. Now If I ask...
Read More

Text to Columns in Excel | Split cells in excel

Text to Columns in Excel or Split Cells in Excel is used in data cleaning and data re-arrangement. Excel text to columns formula technique is used for following: Splitting text of one cell in multiple columns (opposite of Concatenate) Changing the data format of a column (General, Text, Date) Converting numbers with trailing minus sign into negative numbers...
Read More

Top 10 keyboard shortcuts that will help you master Microsoft Excel

Top 10 keyboard shortcuts that will help you master Microsoft Excel Top 10 keyboard shortcuts that will help you master Microsoft Excel. Print and Pin it on your board. Stay speedy with these keyboard shortcuts all the time. It’s a good source of revision of shortcuts at once glance. Download it now! If you found...
Read More
1 2 3 4