3.Planning a workbook | Myanmar Online School

Autoplay
Autocomplete

Previous Lesson Complete and Continue

Advanced Excel Formula and Functions Course

Chapter-1

1.Getting to know excel 2016 (7:51)
2.Introduction to Cloud Computing (25:08)
3.Planning a workbook (15:58)
4.Entering Data (18:14)
5.Using Sum Function (7:13)
6.Formatting the Worksheet (17:16)
7.How to use the name box and selection methods (6:39)
8.Insert a pie chart to the sheet (15:01)
9.Document Properties (5:10)
10.Printing a worksheet and a chart (21:43)
11.Apply your knowledge (16:15)
12.Extend your knowledge (5:44)
13.Analyze,Correct and Improve (17:48)
14.Sam Project 1a (15:19)
15.Sam Project 1b (11:39)
Game play with MS App (27:52)
Gamification with Excel (7:38)
Google Groups and MS Office Intro (22:31)
Lab-1_Fourth Quarter Revenue Analysis (14:28)
Lab-2_MPT Yearly Sales Analysis (15:02)
Lab-3.1_Travel Expense Report (12:50)
Email Marketing (1:07)

Unit 01_Introduction to the Course

1.About the Course (2:26)
Excel-Homework-Exercises

Unit 02_Excel Formula 101

1.Section Outlines (3:57)
2.Function Library and Auditing Tools (9:48)
3.Evaluate Formula (2:05)
4.Formula Syntex (5:55)
5.Reference Types (12:13)
6.Common Excel Errors (8:05)
7.IFERROR Function (4:01)
8.Useful Shortcuts (8:37)
9.Data Validation (8:24)
10.Volatile Functions (3:56)
11.Homework (1:48)

Unit 03_Conditional Statements

Section-3-Logical-Operators - Start
1.Introduction to Logical Functions (2:00)
2.Anatomy of the if statement (5:19)
3.Nested If Functions (16:07)
4.And OR Operators (10:18)
5.Not Operator (5:25)
6.IFERRORS (5:05)
7.IS Formulas (4:47)
8.Homework for Logical Functions (3:43)

Unit 04_Stat Functions

1.Outlines (1:46)
2.Basic Stat Functions (10:48)
3.Small,Large,Rank,PercentRank (10:20)
4.Random, Random Between (3:38)
5.Sumproduct Function (7:10)
6.Countif,Sumif,Averageif (5:43)
8.Homework (1:16)

Unit 05_Lookup Functions

1.Outlines (1:44)
2.Working with named arrays (5:16)
3.Row,Rows,Column,Columns Functions (7:19)
4.Vlookup and Hlookup Functions (9:11)
5.Vlookup and Hlookup Functions_Practice-1 (5:24)
6.Vlookup Function with Exact Match (5:54)
7.NestedVlookup (9:51)
8.LargeVlookupTable (5:09)
9.CHOOSE (4:47)
10.Index Function (2:59)
11.Match Function (2:40)
12.Index Function Practice (5:40)
13.Match Function Practice (4:46)
14.Combining INDEX,MATCH Function (8:02)

3.Planning a workbook

Complete and Continue

Discussion

0 comments