Excel – Beginner to Advanced in 4 Hours

Excel – Beginner to Advanced in 4 Hours, available at $39.99, has an average rating of 4.15, with 27 lectures, based on 149 reviews, and has 3619 subscribers.

You will learn about Microsoft Excel Excel Basics Advanced Functions Arrays Pivot Tables Charts and Graphs This course is ideal for individuals who are Beginner Excel Users It is particularly useful for Beginner Excel Users.

Enroll now: Excel – Beginner to Advanced in 4 Hours

Summary

Title: Excel – Beginner to Advanced in 4 Hours

Price: $39.99

Average Rating: 4.15

Number of Lectures: 27

Number of Published Lectures: 27

Number of Curriculum Items: 27

Number of Published Curriculum Objects: 27

Original Price: $39.99

Quality Status: approved

Status: Live

What You Will Learn

Microsoft Excel
Excel Basics
Advanced Functions
Arrays
Pivot Tables
Charts and Graphs

Who Should Attend

Beginner Excel Users

Target Audiences

Beginner Excel Users

This course will cover everything from Excel fundamentals to advanced tools and functions. Whether you’re just learning to navigate Excel or are already using it regularly but don’t quite have a grasp on all of its tools, this course will teach you so many things that will make your job easier and beef up your resume. For a complete breakdown of the course, check out the curriculum.

Course Curriculum

Chapter 1: Excel Basics

Lecture 1: Understanding the Excel Interface

Lecture 2: Cell and Formula Fundamentals

Lecture 3: Basic Arithmetic Formulas & Relative vs Absolute References

Lecture 4: Copy, Pasting, and Using Autofill

Chapter 2: Data Fundamentals

Lecture 1: Data 101

Lecture 2: Relational Data & Primary/Foreign Keys

Chapter 3: Formatting and Validating Data

Lecture 1: Formatting Cells

Lecture 2: Conditional Formatting

Lecture 3: Data Validation

Chapter 4: Cleaning Data

Lecture 1: Intro to Cleaning Data

Lecture 2: Text to Columns Feature

Lecture 3: Filtering Data

Lecture 4: Concatenation 101

Lecture 5: Left(), Right(), Mid(), Find(), and Len() Functions

Lecture 6: Substitute() and Replace() Functions

Lecture 7: Upper(), Lower(), and Proper() Functions

Lecture 8: Putting it all Together

Chapter 5: Advanced Functions

Lecture 1: Intro to Advanced Functions

Lecture 2: Vlookup() Functions

Lecture 3: Index() and Match() Functions

Lecture 4: If(), And(), & Or() Functions

Lecture 5: Iferror() Functions

Lecture 6: Sumif(), Countif(), Averageif(), Maxif(), & Minif() Functions

Lecture 7: Array Formulas

Chapter 6: Pivot Tables & Data Visualization

Lecture 1: Small() and Large() Functions

Lecture 2: Pivot Tables

Lecture 3: Graphs and Charts

Instructors

Adrian Pumariega
CPA with 13+ Years Experience in Excel

Rating Distribution

1 stars: 0 votes
2 stars: 1 votes
3 stars: 10 votes
4 stars: 56 votes
5 stars: 82 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu