![]() ![]() VLOOKUP – lookup value and return corresponding value from a table.ISBLANK – Check if a cell is blank or not.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!.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.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!.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!.Can’t find what you’re looking for? Suggest a tutorial here!. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |