Building Excel Formulas From Scratch Год выпуска: 2015 Производитель: Udemy Сайт производителя: udemy.com Автор: Mr. Deep Dave Продолжительность: 2:00 Тип раздаваемого материала: Видеоурок Язык: Английский Описание: A step-by-step video series that will help you get familiar with basics to intermediate concepts of Formula Building. Highly sophisticated Formulas can be built using Excel to get results most users might not even imagine. This course aims at helping students develop that logical thinking that would guide them in the right direction when it comes to Excel Formulas The course starts with clarifying basics along with some Do's & Dont's while using Excel. It also spends some quality time to make students understands the power of Excel functions by themselves. It then moves ahead to teach how these functions can be used together to build Powerful Excel Formulas to derive some pretty complicated results. Составление формул в экселе.
Содержание
Section 1: Basics Of Excel 1 Course Introduction 2 Parts Of an Excel Workbook, Functions Library & Functions Vs Formulas 3 Absolute, Relative & Mixed References Section 2: Logical Functions & Error Handling 4 Boolean Logic & Basic Logical Functions 5 Error Handling Section 3: Text Functions 6 Types Of Cell References 7 Text Functions Section 4: Lookup Functions 8 Lookup Functions Section 5: Math and Stats Functions 9 Math and Stats Functions Section 6: Date & Information Functions 10 Date Functions 11 Information Functions Section 7: Important Things To Know 12 Important Things To Know 13 Find Vs Search Section 8: Building Formulas 14 Separate 1st & Last Names 15 Vlookup with Dynamic Column Header 16 Index & Match 17 Indirect & Vlookup 18 SumIfs with 4 Criteria & Vlookup with Approximate Match 19 Search & Iserror 20 Find Last Occurrence Of Minimum Value Using Lookup 21 Match & Index with 0 for Col_Num Argument 22 Count Unique Names 23 Sumproduct With Multiple Criteria 24 Value Of Boolean Expressions Section 9: Array (CSE) Formulas 25 Max Sales Figures Based On Criteria Section 10: Conclusion 26 Conclusion
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum You cannot attach files in this forum You can download files in this forum
![[Quote]](./templates/default/images/lang/en/icon_quote.gif "Reply with quote"){kind=icon}
![[Profile]](./templates/default/images/lang/en/icon_profile.gif "View user's profile"){kind=icon}
![[PM]](./templates/default/images/lang/en/icon_pm.gif "Send private message"){kind=icon}
