1.1 Introduction to the Course | StackSkills

Autoplay
Autocomplete

Previous Lesson Complete and Continue

Excel Functions Mastery Course

Intro to Mammoth Interactive

00 About Mammoth Interactive (1:06)
01 How to Learn Online Effectively (13:39)

01. Introduction to the Course

1.1 Introduction to the Course (8:47)
1.2 Introduction of the instructor (3:30)
1.3 Course requirements (4:04)
1.4 How to get Excel (9:33)
01 Source Files

02. Excel Logic and Lookup Functions Projects

2.1 What will we learn in this section (1:33)
2.2 Create An If() Function (3:24)
2.3 Nest And() Andor Or() Functions Within Reference Functions (6:37)
2.4 Work With Choose(), Vlookup(), Index(), And Match() Functions (6:19)
2.5 Create A Vlookup() Function (3:32)
2.6 Section Summary (9:37)
02 Source Files

03. Excel Math and Finance Functions Projects

3.1 What will we learn in this section (2:23)
3.2 Aggregate Data Using Both The Sum And Subtotal Functions (5:15)
3.3 Calculate minimums, maximums and averages from data sets (3:39)
3.4 Use the Forecast function to forecast numbers along a trend (6:57)
3.5 Generate a net present value using a formula (6:13)
3.6 Section Summary (7:38)
03 Source Files

04. Excel Date and Time Functions Projects

4.1 What will we learn in this section (1:14)
4.2 Date manipulation (10:10)
4.3 Build a holiday date calculator (6:09)
4.4 Section Summary (4:43)
04 Source Files

05. Excel Text and Information Functions Projects

5.1 What will we learn in this section (3:46)
5.2 Split textual data apart (4:00)
5.3 Manipulate textual data (5:47)
5.4 Replace portions of textual data (4:42)
5.5 Put textual data back together with formulae (6:18)
5.6 Work with key informational functions (12:00)
5.7 Use the Hyperlink function to build navigational menus inside an Excel Worksheet (4:35)
5.8 Section Summary (6:26)
05 Source Files

06. Excel Lists

6.1 What will we learn in this section (4:08)
6.2 How to filter items in a list (8:24)
6.3 Sorting List without messing up the data (10:09)
6.4 How to freeze rows or columns (9:53)
6.5 Remove duplicates from a list (6:51)
6.6 Section Summary (6:32)
06 Source Files

07. Other Excel useful functions

7.1 What will we learn in this section (2:09)
7.2 COUNT, COUNTA and COUNTIF Functions (11:57)
7.3 Create a drop down list (11:38)
7.4 Work with ISNUMBER and SEARCH functions within text functions (11:18)
7.5 Format row based on a cell value (10:54)
7.6 Create an invoice template in Excel (24:17)
7.7 Section Summary (4:46)
07 Source Files

08. Course Summary

8.1 Course Summary and Next Steps (23:32)

1.1 Introduction to the Course

Complete and Continue

Discussion

0 comments