onlineaway.blogg.se - Free excel courses for mac

#Free excel courses for mac how to#

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.

#Free excel courses for mac how to#

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!.New! Top 10 formulas and functions 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!