Select Page

Exploring Excel Blog

Stay up to date with our most recent tutorials and articles

Turn Negative Numbers into Zero

One of the simplest Excel Hack. The question was very simple. Sometime Excel Formula calculation fetches negative value and due to that negative value it affects your presentation. What if your statement does not accept negative value? , Your statement requires only 0...

read more

Data Validation to Reject Invalid Dates

Hate Invalid Data Entry ? Then you need to check this out to prevent incorrect data to be entered in Excel. Here where the data Validation comes into existence. In this example, we are going to restrict data entry for Next 7 days. i.e I don't want a user to enter data...

read more

Easiest Way to create a Funnel Chart

Funnel Chart is one of the types of data visualization chart which helps to analyze data. Funnel chart can be used for sales data reporting or Departmental profits reporting (like I have done in this demo). The most important thing which is needed is that the data...

read more

Calculation of ROI (Return of Investment)

ROI means return on Investment. Return on investment is an important indicator which is used to measure the efficiency in business. Its calculation is similar to that of calculation of interest on Fixed Deposit. For Example, if I want to invest $10000 in Fixed deposit...

read more

Mess up with SUM Faster

Never mess up with sum function as it can make your easier work tough, Here in this comprehensive article i would show you different ways to make your sum faster and different methods in different situation. Follow the table of content to go straight to the method...

read more

Get Your Macros to work faster – Event Handling

In the series of Blog posts we are going to make you will find various tips and tricks regarding how to speed up calculation of macros in Excel VBA. This is the first among the other articles. Most of the time we make a great automation, great program and great...

read more

Recording a Simple Macro

Introduction You must have heard the term "Macro" in some or the other places. If you are using Photoshop or i would say that you are master of Photoshop then you must be aware regarding the term Macros. Macros basically means automation of the activities. If you are...

read more

Custom List in Excel Explained

Introduction You must be aware that when you write Monday in a cell and you click and drag it you could see that all the names of the days are populated in those cells which you have selected and even if you drag more than 7 it again starts the list from Monday. Do...

read more
Page 2 of 3123

Stay Updated!

Join our newsletter to stay updated with new excel content, get rewarded with member's only video lessons and courses

Free Courses

Duis egestas aliquet aliquet. Maecenas erat eros, fringilla et leo eget, viverra pretium nulla. Quisque sed augue tincidunt, posuere dui tempor.

Premium Courses

Duis egestas aliquet aliquet. Maecenas erat eros, fringilla et leo eget, viverra pretium nulla. Quisque sed augue tincidunt, posuere dui tempor.

Premium Courses

Duis egestas aliquet aliquet. Maecenas erat eros, fringilla et leo eget, viverra pretium nulla. Quisque sed augue tincidunt, posuere dui tempor.

Ready to get started?

Get in touch for queries, or create an account

ExploringExcel.com

Learn Excel Dashboards, VBA, Advance Excel, Charts, Tips tricks and more. Exploring Excel is one stop learning point for all Excel Needs. 

SUPPORT

Pin It on Pinterest