Tag

Excel

Macro to convert Excel to PDF file and Email it using Outlook | Excel Tips

Which of these tasks is part of your daily work life? To Convert Excel to PDF Sending PDF attachments via email Mostly every one of us has to do these tasks daily. You may recall that sometimes you have to convert data in Excel to PDF and then attach it to Outlook mail. It doesn’t...
Read More

VBA Code to password protect excel for a shared Excel file

In this blog, we will try to cover how to password protect Excel Sheet based on the User as part of excel VBA tutorial. For Example, you have a master excel sheet in your centralized location. Now everyone can access the same file and if someone changes something on that it is very difficult or hard to...
Read More

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

How to Update and Delete Using Excel 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...
Read More

Remove Password from Excel Using VBA [Macros] Tutorial

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 very clearly shown to us that how to...
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. How to search data in Google using Excel VBA: For example: Write “Apple” in Google search box Press Enter↵ It will show you the statistics that how many records it has populated and also how...
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

How to 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 find duplicates in Excel. Now, you will learn how to find duplicates in excel and remove it. Use the Remove Duplicates command in the...
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
1 2 3 4
Tricks to create Hyperlink in Excel
December 6, 2017
How to Calculate Profit margin in Excel
December 6, 2017
How to Calculate a Percentage Increase in Excel
November 30, 2017
How to add Error Bars in Excel: Standard Deviation
November 30, 2017
How to convert invalid date formats into valid data formats?
November 29, 2017
Converting trailing minus sign into negative numbers. (Text to Column)
November 29, 2017
Text to Columns in Excel | Transfer Single Columnar Data into Multiple Columns.
November 29, 2017
4Excelshorcuts-workingwithformulas
Working with Excel Formula Shortcuts | Excel tips & tricks
September 27, 2017
Top 10 keyboard shortcuts that will help you master Microsoft Excel
September 26, 2017
freeze-panes-excel
Freeze row and column in Excel “How to”
August 26, 2017
How to Copy Text from Image
Copy Text from Image Using Microsoft OneNote
August 17, 2017
Excel VBA Macro Tutorial | What is VBA Macros in Microsoft Excel ?
July 26, 2017
online-courses
Improve Office Productivity with Online Courses
July 26, 2017
Add APA Page number in MS Word with 3 Easy Steps
July 26, 2017
googlecalneder
4 Super Productive Google Calendar Hacks
July 26, 2017
Chrome and Excel Shortcuts
July 26, 2017
Finalnancial
Create Financial Models For Business
July 26, 2017
Microsoft Excel Go To Data Cleaning Trick
July 26, 2017
SUMIFS Excel Formula
Working with Excel Sumif Formula
July 26, 2017
Data-Sort-Option-Sort Option
Realign your data by sorting in Excel | Excel tips and Tricks | Excel shortcut
July 26, 2017