How to use Excel Faster
0.0 (0 ratings)
12 students enrolled
Wishlisted Wishlist

# How to use Excel Faster

Learn how to use Excel faster with this course that focuses on shortcuts and methods to improve your speed in your work
0.0 (0 ratings)
12 students enrolled
Last updated 2/2014
English
Current price: \$10 Original price: \$20 Discount: 50% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
• 2.5 hours on-demand video
• Access on mobile and TV
• Certificate of Completion
What Will I Learn?
• Learn Excel Basics
• Increase your speed at using Excel
View Curriculum
Requirements
• Microsoft Excel 2010 (preferably Windows)
Description

This online course teaches you all the basic functions and shortcuts of MS Excel to make you get quicker at using this versatile software.

You can use MS Excel to manage everything from mundane household tasks to the most complicated reports at work.

• Learn to sort through data and apply reality checks on data
• Learn to apply powerful text functions to database for analyses
• Learn Basics, best practices, common mistakes, and when to apply
• Make visually appealing tables and charts quickly
• Learn to dynamically highlight /sort data to make business decisions
• Learn to analyze data according to pre-determined criteria

At the end of the class you will be confident, proficient and quick in using Excel for a large variety of business purposes.

Who is the target audience?
• Anybody who wants to learn Excel or improve their skills
Students Who Viewed This Course Also Viewed
Curriculum For This Course
38 Lectures
02:28:14
+
Introduction
1 Lecture 02:17
Preview 02:17
+
Getting Started: The Basics
9 Lectures 47:23
Preview 02:36

Preview 08:32

Paste Special
07:41

Preview 01:52

Grouping and Hiding
01:38

Data Editing, Anchoring and Commenting
06:08

Autosum and naming
03:12

Worksheets
03:13

Exercises
12:31
+
Filters
5 Lectures 18:12
Data Filter
07:23

03:02

03:08

03:09

01:30
+
Text and Conditional Functions
6 Lectures 19:13
Text Functions
05:39

IF Function
05:24

COUNTIF Function
03:17

SUMIF Function
01:17

SUMIF Exercise
01:41

SUMPRODUCT
01:55
+
Goal Seek
2 Lectures 06:19
Goal Seek Function
02:01

Goal Seek Exercise
04:18
+
LOOKUP and MATCH
5 Lectures 27:40
VLOOKUP Function
04:51

VLOOKUP Exercise 1
07:02

VLOOKUP Exercise 2
09:52

MATCH Function
03:24

HLOOKUP Function
02:31
+
Managing Data
3 Lectures 10:09
Data Validation
03:56

Pivot Tables
01:09

Datatables
05:04
+
Conditional Formatting
3 Lectures 06:51
Conditional Formatting Exercise 1
04:04

Conditional Formatting Exercise 2 Part 1
00:44

Conditional Formatting Exercise 2 Part 2
02:03
+
Applications
3 Lectures 09:18
Aggregation
05:10

Conditional Format
02:27

Lookup
01:41
+
Conclusion
1 Lecture 00:52