Excel 2016 Functions Bootcamp With 150+ Examples & 1 Project
Excel 2016 Functions Bootcamp With 150+ Examples & 1 Project
"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:
- Logical Functions
- Text Functions for joining, extracting and data cleaning
- Date & Time Functions
- Lookup & Reference Functions
- Dynamic Formulas
- Math & Statistical Functions
- Array Formulas
- Database Functions for complex criteria
- Formula-Based Conditional Formatting
- Data Validation Pick Lists and Combo Box
- Defined Names
- Wildcard Characters
New: Master the biggest part of Excel with lots of engaging practice problems, assignments and one comprehensive project
Url: View Details
What you will 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
Rating: 4.7
Level: All Levels
Duration: 4.5 hours
Instructor: Sam Esmaeili
Courses By: 0-9 A B C D E F G H I J K L M N O P Q R S T U V W X Y Z
About US
The display of third-party trademarks and trade names on this site does not necessarily indicate any affiliation or endorsement of coursescompany.com.
View Sitemap