Change CASE of text in Excel (3 ways including NO Formulas) How do we change the case of text in Excel to normalize our data or to fix casing errors? Changing lower case text to upper case text, upper case text to
Excel RANK without Skipping Numbers (Top 3 Report with Duplicates) Let's look at Excel’s ranked function. How can you rank your values in descending or ascending order and how can you rank duplicate values without skipping numbers in the sequence?es.
Calculate Percentages the Right Way in Excel (% Change & Amount after % increase) Let’s look at calculating percentages. Seem simple enough, but there may be few tricks we can use to ensure everything works smoothly and displays properly. We will not
Quick Excel Trick to Unstack Data from one Column to Multiple Columns In this Excel tutorial, we'll take a look at the easiest method of unstacking data. The great thing about this method is that it's dynamic, so if your source data
Count Day of Week Between Dates in Excel (How many Fridays?) How can you figure out how many Friday's are included between two days? For example, if our start date is December 3, 2018 and our end date is December 22, 2018
Excel SUM based on Partial Text Match (SUMIFS with Wildcards) Learn how to SUM values in Excel based on a partial text match. This is great for cases when you need to sum a column based on "criteria contains" a specific value or
3 Ways to Transpose Excel Data (Rotate data from Horizontal to Vertical or Vice Versa) Check out 3 ways to Transpose your data in Excel. These are useful when you want to switch the orientation of your data from columns to rows
VLOOKUP & HLOOKUP for Dynamic Lookups These two functions are easy to write, understand, and they’re a major time-saver for simpler lookups. The VLOOKUP function can search for a specific category or value in a table and return the “opposing” value from adjacent columns.
Lookup 1 Value, Return Many Matches The VLOOKUP and INDEX & MATCH formulas are great for looking up a value in a large data table and returning a result from the adjacent columns. But how can you return multiple results? What if
How can you sum values between two dates in Excel? What if you wanted the sum for a specific month? And what if you decided to add in multiple criteria to your existing sum? For example get the sum by month AND division AND