2015
Startup Saturdays / Udemy
7:09
English

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

Download File Size:1.41 GB

---