Excel (Beginner/Intermediate w. Shortcuts)
5.0 (2 ratings)
8 students enrolled
Wishlisted Wishlist

# Excel (Beginner/Intermediate w. Shortcuts)

Learn basic and intermediate Excel, and its useful formulas with shortcuts
5.0 (2 ratings)
8 students enrolled
Created by Momin Tariq
Last updated 2/2015
English
Current price: \$10 Original price: \$20 Discount: 50% off
30-Day Money-Back Guarantee
Includes:
• 1.5 hours on-demand video
• 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
32 Lectures
01:36:27
+
Part 1: Getting Started in Excel
18 Lectures 53:11
Preview 01:45

Preview 02:53

Preview 03:25

Preview 03:37

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

Borders
02:29

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

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