Advanced Excel

Create Advanced Excel Filters using Excel VBA

In this blog, I will try to cover how to use a custom VBA autofilter in excel. This Advanced Excel filter technique is meant for Advanced Excel users.  We all know how to use a custom filter or advanced filter in Excel. Here we will discuss creating custom Excel VBA autofilter: For example, you have a huge...
Read More

Advanced Excel Formula Auditing

Microsoft Excel has a lot of features. It has a variety of powerful tools that allow checking what is happening in your spreadsheet. Today we will discuss on Advanced Excel formula. It helps you to get the relations between formula and your cells. Which cells are using the information in the cell and from which...
Read More