# Excel - beginner to HIRED!

Job seekers learn valuable skills to get hired faster and with greater pay!”
0.0 (0 ratings) 17 students enrolled
Instructed by Neil Parsont
\$15
\$50
70% off
• Lectures 43
• Length 5 hours
• Skill Level All Levels
• Languages English
30 day money back guarantee!
Available on iOS and Android
Certificate of Completion
Wishlisted Wishlist

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

Published 9/2015 English

### Course Description

Overview
Throughout the course, I use realistic business scenarios to show practical application for each technique. Furthermore, the learning style includes on screen visual tips and directions to better accommodate visual learners. The audio style is casual and laidback to provide a little extra entertainment and humor. I hope you enjoy my course!

Course Contents

• Practical Application
• Starter and Completed files
• On Screen Visual tips
• Entertaining audio style
Key Learning Areas
• Pivot Tables
• Formatting and Charts
• Data cleaning techniques

I look forward to teaching you

Sincerely,
Neil Parsont

### What am I going to get from this course?

• Apply Pivot tables to analyze data
• Manipulate text
• Lookup values with Vlookup, Index and Match functions
• Perform logical operations with IF, AND, & OR
• Understand which charts work with different types of data
• Navigate Excel faster with keyboard shortcuts

### Who is the target audience?

• This course is meant for beginners looking to learn Excel through experts seeking to enhance their knowledge to business level

### What you get with this course?

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

Forever yours.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

# Curriculum

Section 1: Getting Started
00:55
00:01
Section 2: Basic Skills
Formatting
06:49
Basic Formulas
05:22
Understanding Formula Notation
08:31
Cell Referencing - Absolute, Semi-absolute & Relative
12:59
Viewing and Printing
09:38
Section 3: Logic Functions
Basic IF function
05:18
Nested IF
04:12
AND OR Functions
04:16
IF AND OR combined
12:52
Section 4: Lookup Functions
Vlookup Approximate
06:14
Vlookup Exact
04:27
INDEX MATCH Lookup
07:30
Vlookup 2 way table (MATCH)
07:28
Vlookup 3 Way Table (MATCH, INDIRECT)
11:21
Multiple Criteria Lookup
19:11
Section 5: Text Functions
Combining Text Cells
08:22
Splitting Text
10:48
Substitute and Replace Text
08:21
Section 6: What If Analysis
Goal Seek
08:02
Scenario Manager
04:54
Data Tables
05:50
Section 7: Charts
Line Charts
09:20
Column Charts
13:24
Pie Charts
07:27
Stacked Charts
04:12
Scatter Charts
06:09
Formatting Raw Data
04:59
Calculations from Data
06:25
Database Calculation of Data Distribution
06:08
05:17
03:16
Section 9: Data Tables
Creating a Data Table - Sorting
05:14
Data Table Filtering
08:29
Section 10: Database Functions
Single Criteria
06:33
Multi Criteria
06:41
Section 11: Pivot Tables
Frequency Analysis
08:38
Percent Analysis
05:03
Filtering
04:28
Section 12: Multiple Sheets
Sheet Management Part 1
03:42
Sheet Management Part 2
04:40
Sheet Management Part 3
05:18