Comprehensive Microsoft Excel
4.5 (339 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
2,898 students enrolled

Comprehensive Microsoft Excel

Discover how to use Microsoft Excel with an easy to follow tutorial series that focuses on project based learning.
4.5 (339 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
2,898 students enrolled
Created by Jordan Hudgens
Last updated 10/2013
English
English [Auto-generated]
Current price: $11.99 Original price: $19.99 Discount: 40% off
1 day left at this price!
30-Day Money-Back Guarantee
This course includes
  • 2.5 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to Udemy's top 3,000+ courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • By the end of this course you will be able to quickly and masterfully utilize Microsoft Excel, including how to: design and template worksheets, manipulate text, build complex financial models, apply conditional formatting, and be able to utilize shorts that will make using Excel an efficient process.
Requirements
  • Basic understanding of how to use a computer.
Description

Learning Microsoft Excel has never been more important. No matter what industry you may work in, being able to create functional spreadsheets is no longer optional, it's required.

Upon completing the course you will receive an official certificate of completion.

Some of the benefits to this Edutechional course are:

Project based tutorials - This means that you won't be wasting time on the theory behind spreadsheet development, you will be able to jump right in and learn how to build practical worksheets.

Comprehensive series - Whether you are a beginning level student or you have been using Excel for years, this course offers a full suite of tutorials that can supply you with tools that will help you in your job immediately.

Experienced instructor - The instructor for this course, Jordan Hudgens, has been teaching users all over the world how to design, manage and improve Excel worksheets for the past decade, and in this course you will get access to a wealth of knowledge!

Who this course is for:
  • This course can be utilized by beginner through advanced Excel students alike.
Course content
Expand all 31 lectures 02:33:39
+ Excel Basics
12 lectures 50:06
Sorting and Filtering Data in Excel
04:58
Text Formatting
06:31
Connecting Text Columns in Excel
04:44
Managing Tabs
05:34
How to Pull Data from Tabs in Excel
04:30
How to Use the Format Painter
02:58
How to Freeze the Top Row in Excel
04:09
How to Add a Header and Footer
03:34
How to Print an Excel Spreadsheet on One Page
02:47
+ Intermediate Excel Techniques
9 lectures 36:48
Excel Tips, Tricks and Shortcuts
11:49
How to Use Math Formulas
03:58
How to Use Formulas - Creating Sums
03:28
How to Create Tables Automatically in Excel
03:42
How to Round in Excel
01:57
How to Calculate Averages
01:53
How to Calculate Ages
03:29
How to Use Themes
02:03
Splitting Text Fields in Excel Automatically
04:29
+ Advanced Excel Techniques
10 lectures 01:06:45
How to Add and Manage Sparklines
05:09
How to Use Conditional Formatting
05:35
How to Use the Count Formula
01:17
How to Use If Then Statements
04:02
How to Add and Design Charts
11:49
Adding Comments
03:49
How to Create Financial Scenarios
15:38
How to Add SmartArt
05:32
How to Pull in Data from a Website into an Excel Spreadsheet
04:05
How to Create and Customize Pivot Tables
09:49