Crash Course Excel for Beginners
0.0 (0 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
0 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Crash Course Excel for Beginners to your Wishlist.

Add to Wishlist

Crash Course Excel for Beginners

A Beginner Excel Course for Busy People
0.0 (0 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
0 students enrolled
Created by Zhenmao Wan
Last updated 7/2017
English
Curiosity Sale
Current price: $10 Original price: $20 Discount: 50% off
30-Day Money-Back Guarantee
Includes:
  • 2 hours on-demand video
  • 5 Articles
  • 20 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • All the fundamentals of Excel to become an effective Excel user
  • Work with text and numerical data
  • Work with formulas and functions
  • Work with charts
  • 7 sets of the most popular and useful Excel functions to perform powerful calculation and text manipulation
  • 7 tips and tricks to make tedious tasks easy and save you tons of time
View Curriculum
Requirements
  • You should have a PC with Microsoft Excel
Description
  • You want to learn Excel, but...

Don't know where to start and overwhelmed by all the information and tutorials online.

Most of tutorials out there cover way too many advanced or specific contents that are not relevant to beginners.

You have a busy schedule, and you get discouraged when some courses' first getting started with Excel chapter is more than an hour long.

  • Different learning formats to make sure you learn better and faster

Bite-size video lectures and step-by-step demonstration to help you easily follow along.

After video quizzes to reinforce your understanding of concepts.

Hand-on exercises to strengthen your skills and increase your retention of what you've learned. 

  •  Mix and match your own learning path to meet your learning needs

3 core lessons of easy-to-follow Excel fundamentals to get you jumpstart Excel in just one hour.

3 accompanying hands-on Excel exercises to practice the materials from the 3 core lessons

7 of the most popular and useful Excel functions covering tasks from data calculation to text manipulation

7 time-saving and wow-inducing Excel tricks and tips to boost your productivity.

Once you enroll, you will have lifetime access to this course and future updates are included.

You can watch the preview videos to see if the course is a fit for you. Because we are confident about our course, your satisfaction is guaranteed or you get your money back. Are you ready to take the challenge and start learning with us to become an Excel master.

Who is the target audience?
  • Beginners who want to learn Excel essentials fast and effectively.
  • Intermediate users who want to brush up their Excel skills, and learn a few tricks and tips to wow their bosses and co-workers.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
51 Lectures
02:00:34
+
Lesson 0: Starting with Excel
2 Lectures 05:35

Starting with Excel
03:25

Starting with Excel
3 questions
+
Lesson 1: Working with Text and Data
11 Lectures 20:50
Add Text and Data
04:12

Resize Rows and Columns, Wrap Text
01:52

Select, Copy and Paste Cells
02:06

Copy Cell Formating with Format Painter
00:57

Number Formats
00:55

Autofill
01:03


Format Cells, Colors and Borders
02:32

Insert and Delete Rows and Columns
01:50

Working with Text and Data
8 questions

Exercise 1
00:03

Exercise 1 Solution
04:14
+
Lesson 2: Working with Formulas and Functions
9 Lectures 19:55
Use Formulas
03:32

Use Functions 1: SUM Function
02:14

Absolute and Relative References
05:25

Use Functions 2: AVERAGE Function
01:06


Filter Data
01:25

Conditional Formatting
01:44

Working with Formulas and Functions
7 questions

Exercise 2
00:03

Exercise 2 Solution
03:07
+
Lesson 3: Working with Charts
6 Lectures 11:06
Create Line Chart
02:22

Format Line Chart
03:06

Create Column Chart
00:46

Format Column Chart
01:59

Working with Charts
4 questions

Exercise 3
00:03

Exercise 3 Solution
02:50
+
Bonus Lesson: 7 Powerful Excel Functions to Master
15 Lectures 41:21

You can download individual files used in the bonus lesson, or you can download the zip file containing all the individual files.

Downloads for 7 Powerful Excel Functions to Master
00:05


PROPER/UPPER/LOWER/TRIM Exercise Solution
00:24

CONCATENATE
02:07

CONCATENATE Exercise Solution
00:37

COUNT/COUNTA
03:48

COUNT/COUNTA Exercise Solution
00:34

MAX/MIN
02:10

MAX/MIN Exercise Solution
01:18

IF
05:38

IF Exercise Solution
01:31

COUNTIF/SUMIF
06:48

COUNTIF/SUMIF Exercise Solution
01:27

VLOOKUP
08:55

VLOOKUP Exercise Solution
01:31
+
Bonus Lesson: 7 Excel Tricks and Tips to Impress
8 Lectures 21:46

You can download the zip file containing all files used in this lesson here. You can also choose to download the individual files from each video lecture later.

Downloads for 7 Excel Tricks and Tips to Impress
00:07


How to Work with Multiple Worksheets
02:05

How to Paste without Formatting
01:58

How to Turn Columns into Rows (and Vice Versa)
01:10

How to Split Text into Multiple Columns
03:21

How to Use Flash Fill
06:27

How to Use Mail Merge with Word and Excel for Bulk Mailings
04:16
About the Instructor
Zhenmao Wan
0.0 Average rating
0 Reviews
0 Students
1 Course
Teacher and Scientist

Dr. Zhenmao Wan is a physicist by training, and an engaging teacher with passion. He has been teaching undergraduates since 2009. He has developed a teaching style of breaking complex topics into easy-to-digest bite size pieces so that students get a better understanding of the materials. He also incorporates good learning and memory techniques into his teaching so that students can retain their learnings.