Apr 26, 2019 | Excel, Excel General
When you apply an autofilter to a table or a cell range, you can use the SUBTOTAL function to count just the visible rows. The SUBTOTAL function is multiple functions built in one function with different methods (AVERAGE, COUNT, COUNTA, MAX, MIN, SUM, etc). In this...
Apr 19, 2019 | Excel, Excel General
As we all know, Excel is a very useful application that has many features. You can use Excel to do things like a building a database, a data entry sheet, creating pivot table and more. Because there are way too many features in Excel sometimes it can get a little bit...
Apr 19, 2019 | Excel, Excel General
Sometimes when we perform data entry task, or copying data from somewhere, we occasionally encounter the issue where some data are duplicate. Unfortunately, In Excel, dealing work duplicate records aren’t that difficult.In this tutorial, I will show you 3 ways...
Apr 19, 2019 | Excel, Excel General
In Excel, there no built-in formatting that converts date as quarter (plus year). In this quick video, I will show you how you can easily format dates to quarter and year in Excel using simple formula. data-ad-layout="in-article" data-ad-format="fluid"...
Apr 15, 2019 | Excel, Excel General
By default, when you perform a look up (VLOOKUP or INDEX/MATCH) in Excel, you can only match a value either by exact match or approximate match. If you want to look up a value in a range or between two dates, you can use something called array formula. In this...