Project Based Excel Course + Practice Tests

Name: Project Based Excel Course + Practice Tests
Rating: 4.5 (505 reviews)

Sharpen and test your Excel skills

Created byBrandon Brown

Last updated 1/2022

English

English [Auto],

What you'll learn

Simulate a work environment by working various projects to sharpen your Excel skills
Test your Excel skills with problem solving practice tests

Coding Exercises

This course includes our updated coding exercises so you can practice your skills as you learn.

Course content

11 sections • 25 lectures • 1h 59m total length

Introduction0:53
Explore Microsoft Excel through projects, exercises, and practice tests to master navigation and the most important functions for solving complex tasks.

RESOURCES (Excel Training)0:03
Excel Training - Introduction1:59
Kick off the project-based Excel course with an introduction to basics, V lookups, and pivot tables, while emphasizing learning by doing, using resources, and mastering keyboard shortcuts.
Excel Training - Basics28:11
Learn to build and test Excel basics using if statements, logical tests, and true/false outcomes, while mastering relative and absolute references, formula copying, and using find and iserror.
Excel Training - VLOOKUP Part 114:45
Excel Training - VLOOKUP Part 2 (INDEX MATCH)17:26
Excel Training - Pivot Table18:21
Learn to use pivot tables in Excel to quickly summarize and aggregate large data by grouping with rows and columns, applying filters, and choosing sums, averages, or counts.
Excel Training - The Other Functions27:22
Master essential Excel functions across aggregation, conditional, text, and date categories, including sum, min, max, count, if with and/or, index, find, trim, date, and today.
Excel Training - Standards and Tips0:11

Requirements

Microsoft Excel

Description

This Excel course shows you just enough training and practice problems to get a feel for Excel, then supplies you with exercises, projects, and practice tests.

I do not spend much time going over things like the menus, basic arithmetic, or charts. My course is aimed at giving you the core skills needed to do analysis in Excel and projects to get you business ready.

Who this course is for:

Beginner Excel Users
Intermediate Excel Users

Project Based Excel Course + Practice Tests

What you'll learn

Explore related topics

Coding Exercises

Course content

Introduction1 lecture • 1min

Excel Training8 lectures • 1hr 48min

Exercises5 lectures • 9min

Project 1 (Medium) - Cable Provider Tool2 lectures • 1min

Project 2 (Hard) - Task List2 lectures • 1min

Project 3 (Hard) - NBA Scores Data2 lectures • 1min

Excel Test 1 - Car Sales2 lectures • 1min

Excel Test 2 - NBA Steph Curry2 lectures • 1min

Excel Practice Test - just questions0

Outro1 lecture • 1min

Requirements

Description

Who this course is for: