![]() VLOOKUP – lookup value and return corresponding value from a table.ISBLANK – Check if a cell is blank or not Lookup.AND/OR – Check if multiple criteria are met (Works great when combined with an IF function!).MINIFS – Find minimum value in a range based on criteria.MAXIFS – Find maximum value in a range based on criteria.COUNTIFS – Count cells using multiple criteria.SUMIFS – Sum cells using multiple criteria.AVERAGEIF – Calculate the average of a range based on criteria.COUNTIF – Count cells in range which meet a certain criteria.Conditional Formatting – Format Excel Cells based on criteria.IF function – check if a condition is met.Remove Duplicates – Remove duplicate values in a single column or multiple columns! Intermediate Conditional. ![]() Flash Fill – Excel’s hidden gem for auto-completing data based on a pattern.Excel Sort – Learn how to sort your data in Excel.Filtering in Excel – Learn how to filter your data using Excel’s Filter Tool.AVERAGE – Calculate average of a range Tools.COUNTA – Count numeric and textual values.COUNT – Count numeric values in a range.MIN – find the minimum value in a range.MAX – find the maximum value in a range.SUM function – Sum multiple values in Excel.Excel Shortcuts for Mac – Learn how to make the most of Excel on your Mac! Formulas/Functions.Excel Shortcuts for Windows – Master Excel Shortcuts to save time and increase efficiency!.Excel Basics – Start here if you are new to Excel! Learn how Excel works, how to perform basic calculations, and how to use cell references to save time and increase efficiency!.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |