Microsoft Excel Beginner and Intermediate with Certificate Год выпуска: 2015 Производитель: Startup Saturdays / Udemy Сайт производителя: udemy.com Продолжительность: 7:09 Тип раздаваемого материала: Видеоклипы Язык: Английский Описание: This is a beginner and intermediate Microsoft Excel training class that requires no prior knowledge of Excel. The training provided in this class covers MAC and PC. Ideal for students who use a MAC and just as applicable to students who use a PC. The class starts be describing the interface and then explains different functions a user can utilize to perform a variety of analysis. This is a beginner and intermediate level class, no prior excel experience necessary. Курс по Экселю для начинающих и пользователей со средним уровнем подготовки.
Содержание
Section 1: Introduction 1 Class intro 2 Before we start - Text Section 2: Excel Layout: Standard Tool Bar 3 Standard Tool Bar 4 Standard Tool Bar Quiz - 5 questions Section 3: Excel Layout: Formatting Toolbar 5 Formatting Toolbar 6 Formatting Toolbar Quiz - 5 questions Section 4: Excel Layout: Home Tab 7 Home Tab 8 Home Tab Quiz - 5 questions Section 5: Excel Layout: Layout Tab 9 Layout Tab 10 Layout Tab Quiz - 5 questions Section 6: Excel Layout: Tables Tab 11 Tables Tab 12 Tables Tab Quiz - 4 questions Section 7: Excel Layout: Charts Tab - Part 1 13 Charts Tab - Part 1 14 Charts Tab - Part 1 Quiz - 4 questions Section 8: Excel Layout: Charts Tab - Part 2 15 Charts Tab - Part 2 16 Charts Tab - Part 2 Quiz - 5 questions 17 Connect with us - Text Section 9: Excel Layout: Smart Art, Formulas, Data and Review 18 Smart Art, Formulas, Data and Review 19 Smart Art, Formulas, Data and Review Quiz - 5 questions Section 10: Functions: Sum, Average, Max, Min and Count 20 Sum, Average, Max, Min and Count 21 Sum, Average, Max, Min and Count Quiz - 5 questions Section 11: Functions: Vertical and Horizontal Lookup 22 Vertical and Horizontal Lookup 23 Vertical and Horizontal Lookup Quiz - 5 questions Section 12: Functions: Vertical and Horizontal Lookup with Index 24 Vertical and Horizontal Lookup with Index 25 Vertical and Horizontal Lookup with Index Quiz - 4 questions Section 13: Functions: SumIf and AverageIf 26 SumIf and AverageIf 27 SumIf and AverageIf Quiz - 5 questions Section 14: Functions: The IF Statement 28 The IF Statement 29 The IF Statement Quiz - 4 questions Section 15: Functions: Nested IF Statement 30 Nested IF Statement 31 Nested IF Statement Quiz - 4 questions Section 16: Functions: Vlookup nested inside an if statement 32 Vlookup nested inside an if statement 33 Vlookup nested inside an if statement Quiz - 4 questions Section 17: Using Microsoft Excel for Personal Finance - Example 34 Using Microsoft Excel for Personal Finance:51 Section 18: Connect with us 35 Connect: - Text Section 19: Excel 2013 - Add Subtract Multiply Divide 36 Add Subtract Multiply Divide Section 20: Excel 2013 Home Tab Clipboard 37 Home Tab Clipboard 38 Home Tab Clipboard Copy Paste Section 21: Excel 2013 Fonts and related features 39 Fonts and related features Section 22: Excel 2013 Alignment 40 Excel 2013 Alignment Section 23: Excel 2013 Currency Feature 41 Excel 2013 Currency Feature Section 24: Excel 2013 Conditional Formatting 42 Excel 2013 Conditional Formatting 1 43 Excel 2013 Conditional Formatting 2 44 Excel 2013 Conditional Formatting 3 Section 25: Excel 2013 Format Table and Cells Features 45 Excel 2013 Format Table and Cells Features Section 26: Excel 2013 Edit Options in Home Tab 46 Excel 2013 Edit Options in Home Tab Section 27: Pivot Table 47 Pivot Table 48 Insert Table and recommended Pivot Table Section 28: Excel 2013 Illustrations 49 Excel 2013 Illustrations
[Startup Saturdays / Udemy.com] Microsoft Excel Beginner and Intermediate with Certificate [2015, ENG] download torrent for free and without registration
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}
