79,749 views
In Chapter 2 of this Excel course we would like to focus on the core topic of Excel: functions and formulas. I will show you the most important functions and their structure. Using examples, you will learn what is important when using these functions. Enjoy watching! ▒▒▒ online Excel course ▒▒▒ ► my paid Excel course for beginners - 12 hours of video material - practice files - certificate http://tiny.cc/excel-kurs ► Brochure with over 200 Excel keyboard shortcuts on a laminated card - work more efficiently with keyboard shortcuts. Available on Amazon: http://tiny.cc/excel-shortcuts ► Chapter 1 (basics) for this Excel course • Learn Excel for beginners - basics... ► Complete playlist for this Excel course • Excel course for beginners - basic course, ... ► Download practice files for this video https://drive.google.com/file/d/1Jip-... Sections 00:00:00 Intro 00:00:57 SUM 00:09:06 Cell references 00:14:26 Arithmetic operators 00:16:23 ROUND, ROUND UP, ROUND DOWN, ROUND BY, LOWER LIMIT, UPPER LIMIT 00:24:28 AVERAGE, MIN, MAX, COUNT, COUNT2 00:26:43 Nesting functions 00:28:29 Comparison operators 00:33:25 Text concatenation operator 00:35:20 XLOOKUP 00:47:08 VLOOKUP 00:50:30 HLOOKUP 00:51:43 IF and IFRS 01:00:30 Error messages 01:04:54 IFNR and IFERROR 01:06:51 SUMIF(S), AVERAGEIF(S), COUNTIF(S), MAXIFS, MINIFS 01:13:37 FILTER 01:18:23 SORT 01:19:41 Formula monitoring 01:22:19 Conclusion ► Save taxes through advertising costs in the income tax return (my paid course) http://tiny.cc/steuern-sparen ► Excel 2021: The big Excel manual. Introduction, practice, professional tips - the compendium for all Excel users. Also suitable for Microsoft 365* https://amzn.to/356gf9R The links marked with * are so-called affiliate links. If a purchase is made via such a link, I will receive a commission. There are no additional costs for you. Where, when and how you buy a product is of course up to you. This video is interesting for you if you are looking for the topics excel course online free, excel course online with certificate, excel course with certificate, excel course vhs, excel course for beginners, excel course nearby, excel courses ihk, excel course costs, excel exercises for beginners, excel for beginners pdf, excel for beginners free, excel formulas, learn excel exercises free, excel for beginners youtube, excel basics free, online course excel for beginners, excel introduction, create formulas, advanced, crash course, basic course, basics, learn excel, basic computer knowledge for beginners, count if, count ifs and multiple criteria. #excel #excelkurs #msexcel