Excel - beginner to HIRED!
4.0 (1 rating)
17 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Excel - beginner to HIRED! to your Wishlist.

# Excel - beginner to HIRED!

Job seekers learn valuable skills to get hired faster and with greater pay!”
4.0 (1 rating)
17 students enrolled
Created by Neil Parsont
Last updated 10/2015
English
Current price: \$10 Original price: \$50 Discount: 80% off
30-Day Money-Back Guarantee
Includes:
• 5 hours on-demand video
• 1 Article
• Full lifetime access
• Access on mobile and TV
• Certificate of Completion
What Will I Learn?
• 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
View Curriculum
Requirements
• Access to Excel and a willingness to learn
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

• Business Scenarios
• Practical Application
• Starter and Completed files
• On Screen Visual tips
• Entertaining audio style
Key Learning Areas
• Pivot Tables
• Basic to advanced Functions
• Formatting and Charts
• Business Level Data Analysis
• Data cleaning techniques

I look forward to teaching you

Sincerely,
Neil Parsont

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
Students Who Viewed This Course Also Viewed
Curriculum For This Course
43 Lectures
04:58:43
+
Getting Started
2 Lectures 00:56
Meet your Instructor! Neil
00:55

File Download
00:01
+
Basic Skills
5 Lectures 43:19
+
Logic Functions
4 Lectures 26:38
Basic IF function
05:18

Nested IF
04:12

AND OR Functions
04:16

IF AND OR combined
12:52
+
Lookup Functions
6 Lectures 56:11
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
+
Text Functions
3 Lectures 27:31
Combining Text Cells
08:22

Splitting Text
10:48

Substitute and Replace Text
08:21
+
What If Analysis
3 Lectures 18:46
Goal Seek
08:02

Scenario Manager
04:54

Data Tables
05:50
+
Charts
5 Lectures 40:32
Line Charts
09:20

Column Charts
13:24

Pie Charts
07:27

Stacked Charts
04:12

Scatter Charts
06:09
+
Grade Analysis project
5 Lectures 26:05
Formatting Raw Data
04:59

Calculations from Data
06:25

Database Calculation of Data Distribution
06:08

Data Table of Grades
05:17

Column Chart of Grades
03:16
+
Data Tables
2 Lectures 13:43
Creating a Data Table - Sorting
05:14

Data Table Filtering
08:29
+
Database Functions
2 Lectures 13:14
Single Criteria
06:33

Multi Criteria
06:41
2 More Sections
About the Instructor
 4.0 Average rating 1 Review 17 Students 1 Course
Excel Tutor at Udemy

Neil Parsont began tutoring in 2004 at Florida Atlantic University. Over the past 10+ years, he developed a learning style focused on understanding, not memorizing. He teaches his students exactly how and why, providing a thorough understanding of concepts. In growing his tutoring business, Parsont employed and trained over 25 tutors personally. Furthermore, he created Owl Tutoring - a service dedicated to FAU students specializing in business courses. He subsequently founded Owl Tutors, a platform where students and tutors meet. Throughout his tutoring career, he has applied Excel to numerous business fields and learned through exposure to a myriad of both academic and business problems. Recently, he acquired ExcelTutor.com and decided to specialize in his best tutoring subject, Excel.