Excel MAXIFS MINIFS (MAX MIN with Multiple Criteria) Finding the largest or smallest value in a set is one of the first tasks beginning Excel users discover. Just after the SUM function, the MAX and MIN functions quickly become one of the
ALL YOU Need to Know About Excel HYPERLINKS (Function & Feature) Hyperlinks! They’re everywhere…even in Excel! “But Excel isn’t a Web browser. How can hyperlinks be of any value?” Here are the skills we will learn to take advantage of Excel hyperlinks:
LOOKUP ALL values b/w two dates (Excel Dynamic Arrays Filter Function to return many match results) Extracting records from a data set that matches defined criteria is a skill most users acquire early in their learning. This usually takes the form of
Excel IF Function with PARTIAL Text Match (IF with Wildcards) How can we look for an approximate match using wildcards with Excel’s IF Function? =IF(YouTu* THEN…) Can you use wildcards in the logical test portion of the IF Function? It seems like
Excel Formula to Convert Numbers to Words One of the most asked for Excel features is the ability to turn a number into words. Because many people need this ability, and Excel does not currently possess such a feature, the old saying
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