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) 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.
10 students enrolled
$20
Take This Course
  • Lectures 38
  • Contents Video: 2.5 hours
  • Skill Level All Levels
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 2/2014 English

Course 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.

What are the requirements?

  • Microsoft Excel 2010 (preferably Windows)

What am I going to get from this course?

  • Learn Excel Basics
  • Increase your speed at using Excel

What is the target audience?

  • Anybody who wants to learn Excel or improve their skills

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Introduction
Introduction
Preview
02:17
Section 2: Getting Started: The Basics
Navigation
Preview
02:36
Formatting
Preview
08:32
Paste Special
07:41
Selecting Data
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
Section 3: Filters
Data Filter
07:23
Advanced Filter Part 1
03:02
Advanced Filter Part 2
03:08
Advanced Filter Exercise 1
03:09
Advanced Filter Exercise 2
01:30
Section 4: Text and Conditional Functions
Text Functions
05:39
IF Function
05:24
COUNTIF Function
03:17
SUMIF Function
01:17
SUMIF Exercise
01:41
SUMPRODUCT
01:55
Section 5: Goal Seek
Goal Seek Function
02:01
Goal Seek Exercise
04:18
Section 6: LOOKUP and MATCH
VLOOKUP Function
04:51
VLOOKUP Exercise 1
07:02
VLOOKUP Exercise 2
09:52
MATCH Function
03:24
HLOOKUP Function
02:31
Section 7: Managing Data
Data Validation
03:56
Pivot Tables
01:09
Datatables
05:04
Section 8: Conditional Formatting
Conditional Formatting Exercise 1
04:04
Conditional Formatting Exercise 2 Part 1
00:44
Conditional Formatting Exercise 2 Part 2
02:03
Section 9: Applications
Aggregation
05:10
Conditional Format
02:27
Lookup
01:41
Section 10: Conclusion
All the best and contact us
00:52

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Noesis369 Learning, Online Instructor

Noesis369 aims to fill the skill gaps between graduation and employment by finding, organizing and promoting skill based workshops and classes designed to equip people with the know how to face the challenges of the modern day work environment.

Noesis369 runs and owns Gyaanexchange.com through which it has educated over 4000 students while empowering 1000s of teacher to find students online.

Ready to start learning?
Take This Course