Excel (Beginner/Intermediate w. Shortcuts)

Learn basic and intermediate Excel, and its useful formulas with shortcuts
5.0 (1 rating) 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.
6 students enrolled
$19
$20
5% off
Take This Course
  • Lectures 32
  • Length 1.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/2015 English

Course 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

What are the requirements?

  • Nothing, this course assumes people have never used Excel before

What am I going to get from this course?

  • Use Excel in their daily work, educational and/or private lives
  • Learn how to manipulate data into meaningful information

What is the target audience?

  • Students, professionals and entrepreneurs

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: Part 1: Getting Started in Excel
Starting Excel, maneuvering in Excel via mouse and keyboard, entering data
Preview
01:45
Zooming in and out, saving, and printing Excel files
Preview
02:53
Formatting data (font type, font size, bold, italics, underline, highlighting)
Preview
03:25
Formatting numbers (custom formatting, percentages)
Preview
03:37
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
Section 2: Formulas in Excel
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
Section 3: Extra Features
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

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Momin Tariq, 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.

Ready to start learning?
Take This Course