Excel 2016 Functions Bootcamp With 150+ Examples & 1 Project
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.
3 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Excel 2016 Functions Bootcamp With 150+ Examples & 1 Project to your Wishlist.

Add to Wishlist

Excel 2016 Functions Bootcamp With 150+ Examples & 1 Project

New: Master the biggest part of Excel with lots of engaging practice problems, assignments and one comprehensive project
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.
3 students enrolled
Created by Sam Esmaeili
Last updated 4/2017
English
Curiosity Sale
Current price: $10 Original price: $50 Discount: 80% off
30-Day Money-Back Guarantee
Includes:
  • 4.5 hours on-demand video
  • 12 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Master the most used functions of Excel
  • Create complex formulas such as advanced VLOOKUPs, INDEX/MATCH, INDIRECT, CHOOSE, OFFSET, SUMPRODUCT, Database Functions, Array Formulas, Complex Dynamic Formulas, Complex Summary Tables, etc.
  • Become comfortable with advanced formula-based conditional formatting
  • Have access to numerous practice problems and homework assignments
  • Combine different functions and create sophisticated formuals and tables to do better and more efficient analysis.
  • Have access to great datasets and more importantly AWESOME examples
  • Have access to very easy-to-understand and comprehensive guides (PDF)
View Curriculum
Requirements
  • This course is designed for students that have an introductory knowledge of Microsoft Excel environment.
  • You should have Microsoft Excel installed on your computer as there will be lots of exercises to do.
Description

"Learn By Doing and Doing and then Doing"

  • The only way to master Excel functions and formulas is to practice A LOT
  • Every chapter includes downloadable homework + answer
  • Every lecture contains numerous practice problems that you and I will solve together
  • All practice problems and homework are organized in downloadable, beautiful and clean layouts
  • At the end, most of what you’ll learn will be tested in a comprehensive project
  • I will explain all the functions, practice problems and the project clearly and step-by-step with no rush.
  • You will have access to really good examples and great datasets to practice on your own and review what you will learn throughout the course
  • The biggest part of Excel is its Functions so master it in only 4.5 hours

“This course is here to help you become the most comfortable person with Excel functions and formulas. At the end, you will have the confidence and ability to combine different functions and create sophisticated formulas to solve complex tasks.”

You will master:

  1. Logical Functions
  2. Text Functions for joining, extracting and data cleaning
  3. Date & Time Functions
  4. Lookup & Reference Functions
  5. Dynamic Formulas
  6. Math & Statistical Functions
  7. Array Formulas
  8. Database Functions for complex criteria
  9. Formula-Based Conditional Formatting
  10. Data Validation Pick Lists and Combo Box
  11. Defined Names
  12. Wildcard Characters


Who is the target audience?
  • Anyone who is interested in mastering the most powerful functions and formuals in Excel.
  • Business and engineering students, as proficiency in Excel is part of almost every job description.
  • Anyone who wants to get very comfortable with the biggest and very important part of Excel, which is its functions and formulas.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
42 Lectures
04:34:13
+
Logical Functions (Practice Problems + Homework)
3 Lectures 16:47
AND / OR / NOT
08:12

IF / IFS / IFERROR / IFNA
07:36

Homework Time
00:59
+
Text Functions (Practice Problems + Homework)
4 Lectures 20:51
Joining Tools (& / TEXTJOIN / CONCATENATE / Flash Fill)
04:23

Extracting Tools (LEFT / RIGHT / MID / SEARCH / LEN)
08:39

Data Cleaning Tools (PROPER / UPPER / TRIM / TEXT / SUBSTITUTE)
06:55

Homework Time
00:54
+
Date & Time Functions (Practice Problems + Homework)
5 Lectures 21:19
TODAY() / NOW() / WORKDAY
02:52

EOMONTH / DAYS / EDATE
05:48

DATE / MONTH
06:23


Homework Time
00:45
+
Lookup & Reference Functions (Practice Problems + Homework)
8 Lectures 01:09:05
CHOOSE
08:04

ROW / ROWS / COLUMN / COLUMNS
03:06

VLOOKUP / HLOOKUP
16:13

MATCH / INDEX
12:57

INDIRECT
10:45

OFFSET
15:17

TRANSPOSE
01:49

Homework Time
00:54
+
Math & Statistical Functions (Practice Problems + Homework)
12 Lectures 01:07:24

Summary Table with SUMIFS
04:03

Conditional Calculations with Array of Criteria
09:47

LARGE / SMALL
01:25

How To Populate Array of Results
07:47

Revisit of Problem 9 From Ch4
02:47

FREQUENCY
03:12

SUMPRODUCT
12:41

RAND / RANDBETWEEN / Rounding Functions
04:31

AGGREGATE / SUBTOTAL
05:52

Returning Multiple Values
07:20

Homework Time
01:08
+
More Subjects (Practice Problems + Homework)
5 Lectures 41:04
Database Functions: DSUM / DAVERAGE / DCOUNT / DMAX
13:23


Conditional Formatting
18:43

Wildcard Characters: ? * ~
05:20

Homework Time
01:53
+
Comprehensive Project
3 Lectures 35:07
What Is Your Project?
02:29

Project Answer Part1
14:18

Project Answer Part2
18:20
About the Instructor
Sam Esmaeili
0.0 Average rating
0 Reviews
3 Students
1 Course
Microsoft Office Specialist Expert, CSCP

Sam is a Certified Microsoft Excel Expert with 5 years of experience in Microsoft Excel. He is holding a Master's degree from New York University with engineering major. Sam is also a Certified Supply Chain Professional with experience in service and manufacturing industry. Sam believes in learning by doing, that’s why his courses are filled with practice problems and homework assignments.