Course Content

Module 1: Course Introduction

09:32
1.1 Introduction

Module 2: Working with Arrays

08:45
2.1 What are Arrays in Excel
08:51
2.2 Using Arrays in Functions Part 1
08:10
2.3 Using Arrays in Functions Part 2
07:19
2.4 Multi-Cell Array Formulas
09:47
2.5 Complex Formulas with Arrays
05:32
2.6 Module 2 Recap and Exercise Guidelines

Module 3: Advanced Functions

11:18
3.1 Math Functions Part 1
25:44
3.2 Math Functions Part 2
16:28
3.3 Math Functions Part 3
10:34
3.4 Text Functions Part 1
11:56
3.5 Text Functions Part 2
07:54
3.6 Text Functions Part 3
09:40
3.7 Information Functions
08:10
3.8 Lookup Functions Part 1
08:55
3.9 Lookup Functions Part 2
05:47
3.10 Lookup Functions Part 3
05:18
3.11 Recap and Guidelines for Exercise

Module 4: Creating Macros

08:30
4.1 Types of Macros Part 1
04:07
4.2 Types of Macros Part 2
04:08
4.3 Types of Macros Part 3
04:43
4.4 Types of Macros Part 4
08:07
4.5 Variables in Macros
04:21
4.6 Using If-Then-Else Structure Part 1
05:42
4.7 Using If-Then-Else Structure Part 2
07:23
4.8 Loops Part 1
09:14
4.9 Loops Part 2
10:54
4.10 Using Complex Macros with Real-Life Problems Part 1
09:27
4.11 Using Complex Macros with Real-Life Problems Part 2
07:00
4.12 Using Complex Macros with Real-Life Problems Part 3
02:43
4.13 Using Complex Macros with Real-Life Problems Part 4
11:55
4.14 Using Complex Macros with Real-Life Problems Part 5
10:43
4.15 Using Complex Macros with Real-Life Problems Part 6
03:09
4.16 Module 4 Recap

Module 5: Importing Data From Other Programs

08:26
5.1 Importing from Spreadsheet Files Part 1
05:35
5.2 Importing From Spreadsheet Files Part 2
03:03
5.3 Importing Data From Worksheets
05:37
5.4 Importing Data From Databases
04:34
5.5 Importing Data From Web Pages
10:20
5.6 Manipulating and Fixing Data
02:13
5.7 Module 5 Recap

Module 6: Customizing Excel User Interface

03:52
6.1 Elements of Excel Interface
09:07
6.2 Customizing Quick Access Toolbar
07:38
6.3 Customizing Ribbon Part 1
05:35
6.4 Customizing Ribbon Part 2
08:11
6.5 Customizing Ribbon Part 3
04:05
6.6 Module 6 Recap

Module 7: Map Charts

09:18
7.1 Working with Map Charts Part 1
10:52
7.2 Working with Map Charts Part 2
10:05
7.3 Working with Map Charts Part 3
02:52
7.4 Module 7 Recap

Module 8: Complex Practical Examples

10:17
8.1 Creating Multi-Factor Calculation Using Forms Part 1
06:58
8.2 Creating Multi-Factor Calculation Using Forms Part 2
20:11
8.3 Creating Multi-Factor Calculation Using Forms Part 3
05:53
8.4 Creating Multi-Factor Calculation Using Forms Part 4
11:15
8.5 Creating a Test Part 1
13:00
8.6 Creating a Test Part 2
09:08
8.7 Creating an Athletic Competition Starting List Part 1
10:41
8.8 Creating an Athletic Competition Starting List Part 2
09:22
8.9 Creating an Athletic Competition Starting List Part 3
07:41
8.10 Creating an Athletic Competition Starting List Part 4

Module 9: Course Summary

05:44
9.1 Course Recap

Course Description

Prerequisites

For this course, completion of an introduction to Excel course or, for those who have already mastered basic use of Excel, understanding the following: basic Excel operations, managing workbooks, data formats and layouts, creating formulas and creating charts as well as pivot tables. Also, for the Macros module, some basic programming knowledge is required. Students will need access to Office 2019 in order to perform the exercises in this course.

Course Goals

By the end of the course, students should be able to:

❏ Use arrays in functions and formulas ❏ Know how to work with most of Excel functions ❏ Create Macros in Excel ❏ Import data from other files and programs ❏ Customize the Excel user interface ❏ Use map charts ❏ Create complex data analysis formulas and structures

Labs Used

There will be exercise worksheets at the end of some modules with clear task that has to be finished. If needed, step-by-step instructions (cheat sheet) will be provided in separate file.

Instructed By

Instructor Profile Image
Milan Cetic
Instructor

Provided By

Cybrary Logo

Certificate of Completion

Certificate Of Completion

Complete this entire course to earn a Intermediate Excel Certificate of Completion

Verticals