Excel (Beginner/Intermediate w. Shortcuts)
5.0 (2 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.
8 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Excel (Beginner/Intermediate w. Shortcuts) to your Wishlist.

Add to Wishlist

Excel (Beginner/Intermediate w. Shortcuts)

Learn basic and intermediate Excel, and its useful formulas with shortcuts
5.0 (2 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.
8 students enrolled
Created by Momin Tariq
Last updated 2/2015
English
Current price: $10 Original price: $20 Discount: 50% off
1 day left at this price!
30-Day Money-Back Guarantee
Includes:
  • 1.5 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Use Excel in their daily work, educational and/or private lives
  • Learn how to manipulate data into meaningful information
View Curriculum
Requirements
  • Nothing, this course assumes people have never used Excel before
Description

The course will be taught from a practical standpoint with an emphasis on real-life problems that business owners or professionals encounter on a daily basis. If your work, assignments or projects require a lot of Excel usage, regardless if you are a student, professional or business owner, then this course is for you!


Some of the topics that will be covered are the following:

  • if-statements
  • sumproduct
  • sumif
  • error handling
  • trace dependents and trace precedents
  • pivot tables
  • filters
  • vlookup
  • grouping and hiding rows and columns
Who is the target audience?
  • Students, professionals and entrepreneurs
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 32 Lectures Collapse All 32 Lectures 01:36:27
+
Part 1: Getting Started in Excel
18 Lectures 53:11




Formatting data (alignment, wrap text, merge & center and alt. to merge & center
04:29

Borders
02:29

Adding rows and columns
02:07

Changing row height and column width
02:20

Copy & paste, cut & paste and paste special
03:58

Excel sheets: adding, activating a sheet, hiding, naming, moving and coloring
02:53

Excel sheets: locking
02:32

Sort, custom sort and filters
04:43

Hiding and unhiding rows and columns
01:56

Grouping and ungrouping rows and columns
03:38

Freeze panes
02:54

Inserting comments
01:21

Work with ranges or multiple cells
01:53

Printing: Selecting a range, margins, page layout, and headers and footers
04:18
+
Formulas in Excel
10 Lectures 32:12
How to enter formulas, sum, product, quotient, average, median
04:35

Count, min, max
03:21

Sumif, countif
05:46

Sumproduct
03:24

Simple if statements
02:20

Nested if statements
02:29

Defining a name, vlookup
02:43

Replace and substitute
02:59

Left and right
01:53

Error handling
02:42
+
Extra Features
4 Lectures 11:04
Creating pivot tables
05:02

Updating data in pivot tables
02:20

Protection
01:11

Trace dependents and trace precedents (Excel shortcuts in downloadables)
02:31
About the Instructor
Momin Tariq
5.0 Average rating
2 Reviews
8 Students
1 Course
Computer Science and Finance Professional
  • Momin Tariq is a Finance and Computer Science professional with dual undergraduate degrees in each subject from the University of Maryland. He has 3 years of experience in the financial services industry where he focused on investment banking, equity research, corporate finance. Additionally, Momin has 1 year of experience in Computer Science where he mainly focused on software development in Java, C and Python.