How to use Excel Faster
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.
12 students enrolled
Wishlisted Wishlist

Please confirm that you want to add How to use Excel Faster to your Wishlist.

Add to 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)
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.
12 students enrolled
Last updated 2/2014
English
Learn Fest Sale
Current price: $10 Original price: $20 Discount: 50% off
2 days left at this price!
30-Day Money-Back Guarantee
Includes:
  • 2.5 hours on-demand video
  • Full lifetime access
  • 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
Expand All 38 Lectures Collapse All 38 Lectures 02:28:14
+
Introduction
1 Lecture 02:17
+
Getting Started: The Basics
9 Lectures 47:23


Paste Special
07:41


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

Advanced Filter Part 1
03:02

Advanced Filter Part 2
03:08

Advanced Filter Exercise 1
03:09

Advanced Filter Exercise 2
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
All the best and contact us
00:52
About the Instructor
Noesis369 Learning
3.3 Average rating
3 Reviews
36 Students
3 Courses
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.