SEARCH – Find the position of a text within another text (Case-insensitive).FIND – Find the position of a text within another text (Case-sensitive).CONCAT – Combine range of cells without delimiter.TEXTJOIN – Easily combine multiple cells using delimiter.HOT! – TEXTSPLIT – Split your text into multiple cells using this super powerful new function!.HOT! – TEXTBEFORE & TEXTAFTER – Extract text before or after a delimiter using Excel’s brand new powerful functions!.LEFT, MID, RIGHT – Basic Text Functions.Pivot Table – Quickly Analyze and Summarize your data using Excel’s most powerful tool!.Hot!!! XLOOKUP – Excel’s next generation lookup function which combines the best features from VLOOKUP, INDEX MATCH, HLOOKUP and IFERROR/IFNA.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!.New! Excel Online Cheat Sheet – A Quick Guide To Excel’s Web Version.New! Excel Self Assessment – Test your Excel skills and understand what to learn next to be even better!.HOT! – Excel Mortgage Calculator – Calculate your mortgage payments and get the payment schedule for the entire period of the loan – Step-by-step tutorial on how to build a Mortgage Calculator in Excel.Tip for mobile phone users – tap twice on the cell you want to edit in order to edit it. If you like this site please share it with your friends! □ The tutorials are sorted from beginner level to advanced level. Now you can practice Excel everywhere! You can even practice on your mobile phone!Įvery function and tool has an explanation followed by an online excel exercise which can be solved within the page itself, no need to download anything – All thanks to the amazing powers of Excel Online! On this website, you will learn and practice Excel functions and tools!
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |