Excel - beginner to HIRED!

Job seekers learn valuable skills to get hired faster and with greater pay!”
0.0 (0 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.
17 students enrolled
$19
$50
62% off
Take This Course
  • Lectures 43
  • Length 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 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

  • 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

What are the requirements?

  • Access to Excel and a willingness to learn

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

What 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.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Getting Started
Meet your Instructor! Neil
00:55
File Download
Article
Section 2: Basic Skills
Formatting
Preview
06:49
Basic Formulas
Preview
05:22
Understanding Formula Notation
Preview
08:31
Cell Referencing - Absolute, Semi-absolute & Relative
Preview
12:59
Viewing and Printing
Preview
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
Section 8: Grade Analysis project
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
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

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Neil Parsont, 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.

Ready to start learning?
Take This Course