Get $1 credit for every $25 spent!

The Complete Excel Bundle: Startup Toolbox

Ending In:
Add to Cart - $39
Add to Cart ($39)
$2,800
98% off
wishlist
Courses
14
Lessons
311
Enrolled
619

What's Included

Intro to Excel
$200 Value
Advanced Excel & VBA for Financial Modeling
$200 Value
Microsoft Excel Data Analysis & Dashboard Reporting
$200 Value
Excel Advanced Functions & Formulas Course Introduction
$200 Value
Manage Large Excel Spreadsheets
$200 Value
Discover Excel Formulas
$200 Value
Excel Logic Functions for Beginners
$200 Value
Explore Conditional Excel Formatting
$200 Value
Lookup Functions for Excel
$200 Value
Intro to Excel Data Tools & Data Management
$200 Value
Statistical Formulas for Excel Data Analysis
$200 Value
Working with Excel Text Functions
$200 Value
Visualize Data with Excel Charts
$200 Value
Microsoft Excel Master Class for Business Managers
$200 Value

Product Details

Access
Lifetime
Content
0.5 hours
Lessons
9

Intro to Excel

Master the Foundations of Excel & Learn How to Gain Valuable Insights From Your Data

By ZENVA | in Online Courses

Get started with Excel, the industry-standard in spreadsheet tools. With Excel, you will boost your business data processing with one of the world's most popular productivity tools. Used for storing, organizing, and analyzing your data, Excel allows you to turn your data into insights, making it highly useful in your professional life. This course covers the foundations of Excel – from creating your first spreadsheet and visualizing your data, to the shortcuts that will help you to increase your productivity.

  • Access 9 lectures & less than an hour of content 24/7
  • Create, format & group new spreadsheets
  • Visualize your data on tables & charts
  • Use shortcuts to speed up your work
  • Master autofill functions
  • Paste data dynamically in multiple ways

Instructor

Trusted by 400,000+ learners and developers, Zenva provides world-class training on in-demand programming skills covering game development, machine learning, virtual reality, and full-stack web development. Their e-learning platform Zenva Academy is the leading place to upskill, learn and gain key tech skills for the innovation economy.

Important Details

  • Length of time users can access this course: lifetime
  • Access options: web & mobile streaming
  • Certification of completion included
  • Redemption deadline: redeem your code within 30 days of purchase
  • Updates included
  • Experience level required: beginner

Requirements

  • Microsoft Excel
  • PC or Mac

Course Outline

  • Introduction
    • Introduction - 1:12
    • Source Files
  • Excel Basics
    • Creating your First Spreadsheet - 9:36
    • Formatting Cells - 6:48
    • Keyboard Shortcuts - 10:20
    • Autofilling - 8:20
    • Mouse Shortcuts - 8:47
    • Grouping Worksheets - 4:54
    • Pasting Options - 9:57

View Full Curriculum

Access
Lifetime
Content
11 hours
Lessons
97

Advanced Excel & VBA for Financial Modeling

Perform Risk Modeling, Optimization, Factor Analysis & Regression with Excel

By Loonycorn | in Online Courses

Excel is a programming language in and of itself. In this power-packed course, you'll use Excel and Visual Basic for Apps (VBA) for some serious financial number-crunching. You'll cover risk modeling, factor analysis, numerical optimization, and linear and logistic regression in your quest to become a competent financial modeler.

  • Access 97 lectures & 11 hours of content 24/7
  • Model risk using covariance matrices & historical returns
  • Understand principal components, Eigen values & Eigen vectors
  • Apply PCA to explain the returns of a technology stock like Apple
  • Study various extensions to the Simplex method, including K-of-N constraints & quadratic objective functions
  • Interpret regression results & avoid common pitfalls

Instructor

Loonycorn is comprised of two individuals—Janani Ravi and Vitthal Srinivasan—who have honed their respective tech expertise at Google and Flipkart. The duo graduated from Stanford University and believes it has distilled the instruction of complicated tech concepts into funny, practical, engaging courses, and is excited to be sharing its content with eager students.

Important Details

  • Length of time users can access this course: lifetime
  • Access options: web & mobile streaming
  • Certification of completion included
  • Redemption deadline: redeem your code within 30 days of purchase
  • Updates included
  • Experience level required: beginner

Requirements

  • PC or Mac
  • Internet access required

Course Outline

  • You, This Course and Us
    • Promo_CareerInFintech - 3:16
  • Introducing Risk management
    • Risk Management - Slides and Source Code
    • Introduction - 12:30
    • Factor Risk Models - 10:26
    • Case Studies - 12:52
    • Mean Variance - 11:52
    • Correlations - 12:58
  • Outlining an Approach to Risk Management
    • Overall Approach - 12:53
    • Portfolio Mean Variance - 9:24
    • Factor Models - 9:17
    • Factor Variance Calc - 10:29
    • VaR - 11:34
    • VaR - Pros and Cons - 10:28
  • RIsk Modeling in Excel/VBA
    • Yahoo Finance - 10:33
    • Returns - 10:38
    • VBA Cov - 7:36
    • Factor Regressions - 10:12
    • Factor Model Risk - 5:56
    • Scenario Risk - 9:23
    • Va R Calc - 6:46
  • Factor Analysis and PCA
    • Factor Analysis and the Link to Regression - 8:05
    • Factor Analysis and PCA - 7:02
  • Basic Statistics Required for PCA
    • Mean and Variance - 6:05
    • Covariance and Covariance Matrices - 11:47
    • Covariance vs Correlation - 3:20
  • Diving into Principal Components Analysis
    • The Intuition Behind Principal Components
    • Finding Principal Components - 7:12
    • Understanding the Results of PCA - Eigen Values - 4:07
    • Using Eigen Vectors to find Principal Components - 2:31
    • When not to use PCA - 2:26
  • PCA in Excel
    • Setting up the data - 6:52
    • Computing Correlation and Covariance Matrices - 3:27
    • PCA using Excel and VBA - 5:51
    • PCA and Regression - 2:56
  • Introducing Numerical Optimisation
    • Optimisation - Slides and Source Code
    • Introduction - 6:51
    • Balance - 3:33
    • Framing the Problem - 8:27
    • Solving the problem - 10:19
    • Applications - 6:46
    • PortfolioAllocation - 5:58
    • Regression - 6:57
    • Gradient Descent - 5:54
  • Linear Programming and the Simplex Method
    • Wyndor - 7:27
    • Standard Dual - 7:04
    • Micro Econ - 6:13
    • Graphical - 7:37
    • Simplex Intuition - 7:47
    • Simplex Mechanics - 8:48
    • Simplex Extensions - 7:43
  • Implementing Linear Programming in Excel
    • Outlining our Approach - 3:55
    • Assembling Data - 3:52
    • Linear Estimations - 6:51
    • Solver - 5:28
    • VBA for Covariance - 5:49
    • Quadratic Optimization - 7:30
  • Understanding Integer Programming
    • Integer Programming - 6:03
    • LP Relaxation - 4:53
    • Flaws Naive LP - 7:00
    • Applications - 7:23
    • Either Or Constraints - 5:42
    • Unusual Forms - 7:18
  • Implementing Integer Programming in Excel
    • Integer Constraints - 4:29
    • Leverage and Long-bias Constraints - 3:29
    • Solver for Integer Programming - 4:45
  • Connect the Dots with Linear Regression
    • Using Linear Regression to Connect the Dots - 9:06
    • Two Common Applications of Regression - 5:26
    • Extending Linear Regression to Fit Non-linear Relationships - 2:37
  • Basic Statistics Used for Regression
    • Understanding Mean and Variance - 6:05
    • Understanding Random Variables - 11:27
    • The Normal Distribution - 9:31
  • Simple Regression
    • Setting up a Regression Problem - 11:38
    • Using Simple regression to Explain Cause-Effect Relationships - 4:59
    • Using Simple regression for Explaining Variance - 8:09
    • Using Simple regression for Prediction - 4:06
    • Interpreting the results of a Regression - 7:27
    • Mitigating Risks in Simple Regression - 7:58
  • Applying Simple Regression
    • Applying Simple Regression in Excel - 11:57
  • Multiple Regression
    • Introducing Multiple Regression - 7:05
    • Some Risks inherent to Multiple Regression - 10:08
    • Benefits of Multiple Regression - 3:49
    • Introducing Categorical Variables - 7:00
    • Interpreting Regression results - Adjusted R-squared - 7:04
    • Interpreting Regression results - Standard Errors of Co-efficients - 8:14
    • Interpreting Regression results - t-statistics and p-values - 5:34
    • Interpreting Regression results - F-Statistic - 2:53
  • Applying Multiple Regression using Excel
    • Implementing Multiple Regression in Excel - 8:54
  • Logistic Regression for Categorical Dependent Variables
    • Understanding the need for Logistic Regression - 9:26
    • Setting up a Logistic Regression problem - 6:04
    • Applications of Logistic Regression - 9:57
    • The link between Linear and Logistic Regression - 8:15
    • The link between Logistic Regression and Machine Learning - 4:18
  • Solving Logistic Regression
    • Understanding the intuition behind Logistic Regression and the S-curve - 6:23
    • Solving Logistic Regression using Maximum Likelihood Estimation - 10:04
    • Solving Logistic Regression using Linear Regression - 5:34
    • Binomial vs Multinomial Logistic Regression - 5:23
  • Applying Logistic Regression
    • Predict Stock Price movements using Logistic Regression in Excel - 9:52

View Full Curriculum

Access
Lifetime
Content
3 hours
Lessons
40

Microsoft Excel Data Analysis & Dashboard Reporting

Build Dynamic, Interactive Microsoft Excel Dashboards with Best-Selling Excel Instructor Kyle Pew

By Kyle Pew | in Online Courses

By participating in this Microsoft Excel Data Analysis and Dashboard Reporting course you'll gain the widely sought after skills necessary to effectively analyze large sets of data using Excel. Once the data has been analyzed, clean and prepared for presentation, you will learn how to present the data in an interactive dashboard report. This 3-hour course will also cover some of the most popular data analysis Excel functions and Dashboard tools including VLOOKUP, INDEX/MATCH, TEXT functions, and more. This course comes with over 30 videos to follow along, downloadable exercise files, instructor support, and a real-world Excel dashboard.

  • Access 40 lectures & 3 hours of content 24/7
  • Understand & identify the principles of data analysis
  • Use effective design principles when creating & presenting data
  • Build interactive dashboard reports
  • Learn Data Mine using Excels array functions
  • Streamline & analyze data w/ Excel PivotTables and Pivot Charts

Instructor

Kyle Pew is a Microsoft Certified Trainer (MCT) and a certified Microsoft Office Master Instructor and has been teaching and consulting for the past 10+ years on various computer applications, including:

  • Microsoft Office Suite 1997, 2000, XP, 2003, 2007, 2010, 2013
  • Excel, Word, PowerPoint, Outlook, Access & Visio
  • SharePoint End-User 2007, 2010, 2013
  • VBA (Excel & Access)
  • Adobe Suite
  • Photoshop, Illustrator, InDesign
  • Maya (Modeling & Animation)
  • Unity3d (Game Design)
  • HTML, CSS & JavaScript
  • Crystal Reports

Important Details

  • Length of time users can access this course: lifetime
  • Access options: web & mobile streaming
  • Certification of completion included
  • Redemption deadline: redeem your code within 30 days of purchase
  • Updates included
  • Experience level required: beginner

Requirements

  • Experience working w/ Microsoft Excel on a Windows system
  • Excel 2010, 2013, 2016

Course Outline

  • Getting Started
    • Welcome to the Course - 2:01
    • Dealing with Raw Data - 4:03
    • The Magic of an Excel Dashboard - 5:18
    • Let's get Started! - 0:58
  • Analyzing Data Effectively with Microsoft Excel
    • DOWNLOAD THIS FILE FIRST - 1:14
    • Using Excels PROPER() Function on Text - 4:41
    • Create Consistency with Excels UPPER() Function - 2:54
    • Microsoft Excels Paste Special Feature - 3:52
    • Replace Meaningless Data with Excels CHOOSE() Function - 9:14
    • Extract Date Values Using Excels TEXT() Function - 6:30
  • Building the Excel Dashboard - LOOK UP DATA - Part 1
    • Looking Up Customer Info - 2:14
    • Preparing the Data Using Format As Table - 4:54
    • Creating a Drop Down Menu with Data Validation - 3:53
    • Looking Up Data with Excels VLOOKUP() Function - 7:55
    • Cleaning Up Data with Excels IF() Function - 7:15
    • INDEX() and MATCH() an Alternative to VLOOKUP() - 15:05
  • Building the Excel Dashboard - FILTERING DATA - Part 2
    • Adding the Order History Table - 5:46
    • Formatting Orders as a Table - 4:19
    • Using Excels Advanced Filter Feature - 7:30
    • Record Macro for Advanced Filter - 9:11
    • Filter Order Records On Change of Customer (VBA) - 6:25
    • Modify the VBA Filter Code - 8:25
  • Building the Excel Dashboard - SUBTOTALS - Part 3
    • Why Use Excels SUBTOTAL() Function - 7:00
    • Implementing the SUBTOTAL() Function - 6:40
  • Building the Excel Dashboard - PivotTables and Pivot Charts - Part 4
    • Why Use PivotTables - 6:43
    • Summarizing Order Info with PivotTables - 7:52
    • Prepare PivotTable for Customer Filter - 5:20
    • Creating the VBA Procedure - 3:54
    • Declaring VBA Variables - 4:27
    • Assigning Values to VBA Variables - 7:27
    • Connecting the Filter to the PivotTable - 5:08
    • Update Pivot Chart Based on Customer Selected (VBA) - 4:41
    • Customers with No Orders Error - 5:57
  • Building the Excel Dashboard - Interactive Buttons - Part 5
    • Creating Interactive Charts with Slicers - 4:22
    • Modifying the Chart Slicer - 1:54
  • Building the Excel Dashboard - Final Touches - Part 6
    • Hiding Extra Worksheets and Columns - 4:50
    • Cleaning Up the Excel Default Settings - 2:23
    • Hiding the Chart and Resetting the Slicer (VBA) - 7:53
    • Protecting the Dashboard - 5:18
  • Congratulations and Bonus!
    • Congratulations You Finished the Course - 1:21

View Full Curriculum

Access
Lifetime
Content
3 hours
Lessons
42

Excel Advanced Functions & Formulas Course Introduction

Develop Dynamic Excel Worksheets by Mastering Excel's INDEX & MATCH functions

By Kyle Pew | in Online Courses

Microsoft Excel contains hundreds of built-in functions, such as SUM, AVERAGE, MIN, IF, VLOOKUP and many more. As you participate in this course, you'll go through a series of exercises tailored to give you the greatest exposure and step-by-step instruction as you learn to harness the power of Excel's INDEX() and MATCH() functions. After you master these building block concepts, you'll then dive into several real-world scenarios and the finer points of creating dynamic and robust formulas.

  • Access 42 lectures & 3 hours of content 24/7
  • Understand the fundamental building blocks of creating complex calculations
  • Learn & implement the INDEX and MATCH functions
  • Create dynamic LOOKUPS by combining functions
  • Create ARRAY functions w/ INDEX & IF functions
  • Combine INDEX/MATCH & MIN to return associated data points
  • Build complex conditional formatting w/ calculations

Instructor

Kyle Pew is a Microsoft Certified Trainer (MCT) and a certified Microsoft Office Master Instructor and has been teaching and consulting for the past 10+ years on various computer applications, including:

  • Microsoft Office Suite 1997, 2000, XP, 2003, 2007, 2010, 2013
  • Excel, Word, PowerPoint, Outlook, Access & Visio
  • SharePoint End-User 2007, 2010, 2013
  • VBA (Excel & Access)
  • Adobe Suite
  • Photoshop, Illustrator, InDesign
  • Maya (Modeling & Animation)
  • Unity3d (Game Design)
  • HTML, CSS & JavaScript
  • Crystal Reports

Important Details

  • Length of time users can access this course: lifetime
  • Access options: web & mobile streaming
  • Certification of completion included
  • Redemption deadline: redeem your code within 30 days of purchase
  • Updates included
  • Experience level required: beginner

Requirements

  • PC or Mac
  • Internet access required

Course Outline

  • Excel Advanced Functions and Formulas Course Introduction
    • Introduction - 4:05
    • Course Exercise Files - 1:34
  • Advanced Excel Formula Fundamentals
    • Advanced Excel Formula Fundamentals Exercise File (DOWNLOAD) - 0:50
    • Excel Absolute vs. Relative Cell References - 4:48
    • Excel Absolute vs. Relative Cell References CONTINUED - 5:37
    • Variations on Excel's Absolute References - 10:55
    • Excel Name Ranges - 6:28
    • Creating Powerful Formulas by Nesting Functions - 8:44
  • Evaluating and Debugging Excel Formulas
    • Evaluating Excel Formulas Exercise File (DOWNLOAD) - 1:13
    • Evaluate Formulas - 7:03
    • Locating Errors in a Formula - 7:10
    • Using Excel's IFERROR() Function - 5:05
  • Excel Array Formulas
    • Array Formulas Exercise File (DOWNLOAD) - 0:52
    • What are Arrays? - 5:34
    • Nesting Array Formulas - 8:08
    • Using Arrays to SUM Data - 5:14
    • Streamline Conditions Using Arrays - 5:35
  • Fundamentals of Using Excel's INDEX() and MATCH() Functions
    • Index and Match Functions Exercise File (DOWNLOAD) - 1:29
    • Excels INDEX() Function - 7:20
    • Excels MATCH() Function
    • Nesting INDEX() and MATCH() - 7:52
  • Excel Index() and Match() Exercises
    • Intro to Return an Assoicated Value Using INDEX() and MATCH() - 2:33
    • Exercise File (DOWNLOAD) - 2:33
    • Intro to Creating a Dynamic SUM() Using INDEX() - 3:56
    • Creating a Dynamic SUM() Using INDEX() Continued - 6:06
    • Intro to Combine Multiplication with INDEX() and MATCH() - 3:33
    • Combine Multiplication with INDEX() and MATCH() Continued - 9:34
    • Intro to Create a Dynamic VLOOKUP() with MATCH() - 8:08
    • Create a Dynamic VLOOKUP() with MATCH() Continued - 7:42
    • Create a Dynamic VLOOKUP() with MATCH() Continued - 5:51
    • Intro to Turn INDEX() and MATCH() into an ARRAY - 3:44
    • Turn INDEX() and MATCH() into an ARRAY Continued - 7:03
    • Intro to Returning Multiple Values with INDEX() - 5:28
    • Returning Multiple Values with INDEX() Continued - 8:24
    • Returning Multiple Values with INDEX() Continued - 9:12
    • Returning Multiple Values with INDEX() Continued - 3:26
    • Intro to Adding Criteria to INDEX() and MATCH() - 4:02
    • Adding Criteria to INDEX() and MATCH() Continued - 5:44
    • Return an Assoicated Value Using INDEX() and MATCH() Continued - 4:43
    • Intro to Conditional Formatting Using MATCH() - 2:10
    • Conditional Formatting Using MATCH() Continued - 4:10
  • Congratulations
    • Congratulations - 1:03

View Full Curriculum

Access
Lifetime
Content
0.5 hours
Lessons
9

Manage Large Excel Spreadsheets

Develop Your Basic Excel Skills & Work with Any Amount of Data in Seamless, Simple Ways

By ZENVA | in Online Courses

Learn the ins and outs of data manipulation for large spreadsheets in Excel. With one of the world's most popular productivity tools, you can impress those in your professional life by handling any amount of data with ease. This course will walk you through how to view your massive quantities of data easily and how to manage your data for quick comparisons. Further your Excel skills and manipulate your data like a professional.

  • Access 9 lectures & less than an hour of content 24/7
  • Freeze & split panes to compare data across large distances
  • Sort list data by single & multiple columns
  • Filter lists by a variety of criteria
  • Hide & unhide columns
  • Set up your spreadsheet for printing based on your needs

Instructor

Trusted by 400,000+ learners and developers, Zenva provides world-class training on in-demand programming skills covering game development, machine learning, virtual reality, and full-stack web development. Their e-learning platform Zenva Academy is the leading place to upskill, learn and gain key tech skills for the innovation economy.

Important Details

  • Length of time users can access this course: lifetime
  • Access options: web & mobile streaming
  • Certification of completion included
  • Redemption deadline: redeem your code within 30 days of purchase
  • Updates included
  • Experience level required: beginner

Requirements

  • PC or Mac
  • Microsoft Excel
  • Basic familiarity with Excel

Course Outline

  • Introduction
    • Introduction - 0:54
    • Source Files
  • Large Spreadsheet Management
    • Freezing Panes - 4:43
    • Split Panes - 4:32
    • Sorting Data in a List - 4:02
    • Sorting by Multiple Columns - 3:43
    • Filtering a List - 10:50
    • Hide and Unhide Columns - 4:34
    • Useful Print Settings in Excel - 11:12

View Full Curriculum

Access
Lifetime
Content
1 hours
Lessons
10

Discover Excel Formulas

Become an Expert on Excel Formulas & Improve Your Productivity with Automatic Calculations

By ZENVA | in Online Courses

Study new Excel skills by implementing formulas and functions for automatic calculations. With these simple techniques in this immensely popular productivity tool, you can make more time for your business and let Excel handle all the math work for you. This course will get you started in manipulating your data in more dynamic, calculative ways, whether you need to work with numerical values or dates. Make Excel work for you and analyze your data fast and efficiently.

  • Access 10 lectures & 1 hour of content 24/7
  • Set up basic & advanced mathematical operations, including working w/ percentages
  • Use absolute references for easy auto-filling
  • Access basic functions, such as averaging values
  • Reference other sheets for formulas & functions
  • Manipulate dates using formula logic
  • Deal w/ named ranges when setting up formulas

Instructor

Trusted by 400,000+ learners and developers, Zenva provides world-class training on in-demand programming skills covering game development, machine learning, virtual reality, and full-stack web development. Their e-learning platform Zenva Academy is the leading place to upskill, learn and gain key tech skills for the innovation economy.

Important Details

  • Length of time users can access this course: lifetime
  • Access options: web & mobile streaming
  • Certification of completion included
  • Redemption deadline: redeem your code within 30 days of purchase
  • Updates included
  • Experience level required: beginner

Requirements

  • Microsoft Excel
  • Windows or Mac

Course Outline

  • Introduction
    • Introduction - 1:22
    • Source Files
  • Excel Formulas
    • Basic Mathematical Operations - 5:41
    • Multiple Operations - BODMAS - 3:33
    • Calculating Percentages - 8:40
    • Using Absolute References - 6:37
    • Using Functions in Excel - 11:08
    • Reference Other Sheets within Formulas - 11:50
    • Date Formulas - 9:58
    • Named Ranges in Formulas - 6:41

View Full Curriculum

Access
Lifetime
Content
0.5 hours
Lessons
9

Excel Logic Functions for Beginners

Learn Advanced Logic Functions in Excel & Automatically Display Your Data Based on Set Criteria

By ZENVA | in Online Courses

Learn smart decision making with Excel and analyze your data with increased speed and efficiency. Not only will you increase the productivity of data handling in your professional life, but you'll step further into the world of Excel and master this immensely popular tool. Through this course, you will learn how to use a variety of advanced logic functions that let Excel decide how to display your data and cells.

  • Access 9 lectures & less than an hour of content 24/7
  • Implement “if” functions to test number, text & date values for conditions
  • Use “and” & “or” to increase or decrease passing conditions
  • Nest “if” functions to create even more complicated formulas
  • Set up switch functions to easily test multiple criteria

Instructor

Trusted by 400,000+ learners and developers, Zenva provides world-class training on in-demand programming skills covering game development, machine learning, virtual reality, and full-stack web development. Their e-learning platform Zenva Academy is the leading place to upskill, learn and gain key tech skills for the innovation economy.

Important Details

  • Length of time users can access this course: lifetime
  • Access options: web & mobile streaming
  • Certification of completion included
  • Redemption deadline: redeem your code within 30 days of purchase
  • Updates included
  • Experience level required: beginner

Requirements

  • Microsoft Excel
  • Basic familiarity with Excel
  • PC or Mac

Course Outline

  • Introduction
    • Introduction - 1:31
    • Source Files
  • Excel Logic Functions
    • IF Function - Testing Numeric Values - 4:54
    • IF Function - Testing Text Values - 3:40
    • IF Function - Testing Date Values - 3:25
    • AND and OR Functions with IF - 9:09
    • Nested IF Formulas - 8:32
    • IFs Function - 5:46
    • Switch Function - 7:43

View Full Curriculum

Access
Lifetime
Content
0.5 hours
Lessons
10

Explore Conditional Excel Formatting

Master Conditional Formatting & Let Excel Automatically Format the Appearance of Your Spreadsheet

By ZENVA | in Online Courses

Add more clarity and aesthetic appeal to your spreadsheets by using conditional formatting. Through one of the world's most popular productivity tools, Excel, you can efficiently make professional-looking spreadsheets while saving time with automation. With this course, you will learn how to apply rules against your data so Excel can automatically format the appearance of your spreadsheet. Make Excel work for you and increase your productivity with these techniques.

  • Access 10 lectures & less than an hour of content 24/7
  • Create & manage conditional formatting rules
  • Highlight, change colors, bold text & more through established rules
  • Set up data bars, heat map & icon sets for more advanced visual aids
  • Automatically format entire rows w/ your rulesets
  • Utilize multiple sets of criteria for your conditions

Instructor

Trusted by 400,000+ learners and developers, Zenva provides world-class training on in-demand programming skills covering game development, machine learning, virtual reality, and full-stack web development. Their e-learning platform Zenva Academy is the leading place to upskill, learn and gain key tech skills for the innovation economy.

Important Details

  • Length of time users can access this course: lifetime
  • Access options: web & mobile streaming
  • Certification of completion included
  • Redemption deadline: redeem your code within 30 days of purchase
  • Updates included
  • Experience level required: beginner

Requirements

  • asic understanding of Excel formulas & general Excel tasks

Course Outline

  • Introduction
    • Introduction - 2:02
    • Source Files
  • Formatting with Excel
    • Basic Conditional Formatting Rules - 6:59
    • Manage Existing Formatting Rules - 7:06
    • Highlight Due Dates - 7:20
    • Data Bars to Compare Values - 6:18
    • Create a Heat Map - 2:59
    • Using Icon Sets - 8:01
    • Testing Multiple Criteria - 6:39
    • Apply Conditional Formatting to a Row - 4:28

View Full Curriculum

Access
Lifetime
Content
0.5 hours
Lessons
10

Lookup Functions for Excel

Locate & Store Spreadsheet Data Cleanly & Professionally by Mastering Excel’s Lookup-Related Functions

By ZENVA | in Online Courses

Explore your Excel spreadsheet data professionally by learning to use lookup functions. With these tools, you will be able to look up any data of your choosing through a variety of methods and store that data easily in cells. Additionally, you will also master one of the world's most popular productivity tools and learn skills to benefit your business's large amount of data. Level-up your knowledge of Excel, manage your data efficiently and learn even more functionality for your needs.

  • Access 10 lectures & less than an hour of content 24/7
  • Use VLOOKUP & HLOOKUP to lookup data in columns and rows
  • Match data in various ways, including exact match
  • Handle errors gracefully & in more user-friendly ways
  • Utilize column index numbers for better lookup functionality
  • Pair INDEX & MATCH functions for combined lookup efforts

Instructor

Trusted by 400,000+ learners and developers, Zenva provides world-class training on in-demand programming skills covering game development, machine learning, virtual reality, and full-stack web development. Their e-learning platform Zenva Academy is the leading place to upskill, learn and gain key tech skills for the innovation economy.

Important Details

  • Length of time users can access this course: lifetime
  • Access options: web & mobile streaming
  • Certification of completion included
  • Redemption deadline: redeem your code within 30 days of purchase
  • Updates included
  • Experience level required: beginner

Requirements

  • General familiarity with Excel
  • Intermediate understanding of Excel formulas

Course Outline

  • Introduction
    • Introduction - 1:58
    • Source Files
  • Excel Lookup Functions
    • VLOOKUP Exact Match - 9:18
    • Using VLOOKUP for a Range - 3:55
    • Handling Errors - 8:05
    • VLOOKUP Column Index - Part 1 - 5:45
    • VLOOKUP Column Index - Part 2 - 6:28
    • The HLOOKUP Function - 6:42
    • The Index Function - 6:27
    • Index and Match Functions for Lookups - 6:05

View Full Curriculum

Access
Lifetime
Content
1 hours
Lessons
12

Intro to Excel Data Tools & Data Management

Learn the Fundamentals of Excel’s Data Tools to Manage, Manipulate & Organize All Your Spreadsheet Data Efficiently

By ZENVA | in Online Courses

Master advanced data management and boost your productivity with Excel’s data tools. With Excel, one of the world's most popular productivity tools on the market, you can master a variety of skills to handle data for your business or professional life. From dynamically organizing your data, to simplifying your methods for data processing and analysis, you will learn techniques that will help you to gain invaluable insights into your projects.

  • Access 12 lectures & 1 hour of content 24/7
  • Set up data validation rules to prevent bad data
  • Separate text in a column
  • Quickly remove duplicate data from a list
  • Utilize flash fill to fill in data w/ a single click
  • Seek values by testing what-if scenarios for formulas
  • Utilize data tables & data types for more complex analysis

Instructor

Trusted by 400,000+ learners and developers, Zenva provides world-class training on in-demand programming skills covering game development, machine learning, virtual reality, and full-stack web development. Their e-learning platform Zenva Academy is the leading place to upskill, learn and gain key tech skills for the innovation economy.

Important Details

  • Length of time users can access this course: lifetime
  • Access options: web & mobile streaming
  • Certification of completion included
  • Redemption deadline: redeem your code within 30 days of purchase
  • Updates included
  • Experience level required: beginner

Requirements

  • Basic working knowledge of Excel

Course Outline

  • Introduction
    • Introduction - 3:02
    • Source Files
  • Excel Data Tools
    • Data Validation Rules to Prevent Bad Data - 8:39
    • Drop Down Lists for Data Entry - 5:31
    • Custom Validation Messages and Alerts - 6:08
    • Splitting Data into Different Columns - 3:42
    • Splitting Data of a Fixed Width - 3:14
    • Remove Duplicate Rows from a List - 3:57
    • The Flash Fill Tool - 8:17
    • Goal Seek to Reach your Result - 6:16
    • Data Tables to Test Multiple Values - 7:24
    • The New Rich Data Types - 6:28

View Full Curriculum

Access
Lifetime
Content
0.5 hours
Lessons
10

Statistical Formulas for Excel Data Analysis

Boost Your Data Analysis Techniques in Excel by Mastering Statistical Formulas

By ZENVA | in Online Courses

Add a variety of statistics to your spreadsheets using Excel’s statistical formulas. Whether you need to find the average of a product’s sales or the count of certain items, this course will teach you all the functions needed to automatically calculate these values. Not only can you increase your business' productivity through automated calculations, but you can delve further into the popular productivity tool of Excel to increase the efficiency of your professional life. Take the next step in your career and improve your data analysis techniques.

  • Access 10 lectures & less than an hour of content 24/7
  • Use the SUMIF, COUNTIF & AVERAGEIF functions for basic, statistical calculations
  • Reference cell values for criteria
  • Handle multiple conditions within the formulas
  • Utilize wildcards to dynamically match data
  • Implement the SUMPRODUCT function
  • Combine SUMPRODUCT w/ arrays & other statistical formulas

Instructor

Trusted by 400,000+ learners and developers, Zenva provides world-class training on in-demand programming skills covering game development, machine learning, virtual reality, and full-stack web development. Their e-learning platform Zenva Academy is the leading place to upskill, learn and gain key tech skills for the innovation economy.

Important Details

  • Length of time users can access this course: lifetime
  • Access options: web & mobile streaming
  • Certification of completion included
  • Redemption deadline: redeem your code within 30 days of purchase
  • Updates included
  • Experience level required: beginner

Requirements

  • Basic working knowledge of Excel

Course Outline

  • Introduction
    • Introduction - 2:44
    • Source Files
  • Excel Formulas for Statistics
    • Using SUMIF, COUNTIF and AVERAGEIF - 5:46
    • Reference Cell Values to Create Criteria - 4:09
    • Testing Multiple Conditions - 4:50
    • Using Wildcards with Formulas - 5:10
    • The SUMPRODUCT function - 7:18
    • Sum the Values for a Specific Month - 3:55
    • Count Unique Values Only - 4:44
    • SUMPRODUCT and SUMIF Together - 6:05

View Full Curriculum

Access
Lifetime
Content
0.5 hours
Lessons
12

Working with Excel Text Functions

Discover How to Manipulate Text Data in Microsoft Excel Using Text Functions that Work with Both Numbers & Strings

By ZENVA | in Online Courses

Begin manipulating text data within Microsoft Excel using native functions. With one of the world's most popular productivity tools, you can learn to handle any sort of data with ease and impress those in your professional life with your newfound skills. Whether you need to combine, split, or analyze various text-based values from different columns, this course will help you to implement text functions that work with both numbers and strings. Through these, you will transform your text-based worksheets and more efficiently manage your addresses, dates, order information, and more.

  • Access 12 lectures & less than an hour of content 24/7
  • Merge multiple columns w/ text content into one column
  • Use the TEXTJOIN function for advanced concatenation
  • Extract & alter text data from a cell
  • Manipulate text from irregular strings w/ FIND & SEARCH
  • Use the SUBSTITUTE function to dynamically replace text
  • Convert a string/text value into a number value

Instructor

Trusted by 400,000+ learners and developers, Zenva provides world-class training on in-demand programming skills covering game development, machine learning, virtual reality, and full-stack web development. Their e-learning platform Zenva Academy is the leading place to upskill, learn and gain key tech skills for the innovation economy.

Important Details

  • Length of time users can access this course: lifetime
  • Access options: web & mobile streaming
  • Certification of completion included
  • Redemption deadline: redeem your code within 30 days of purchase
  • Updates included
  • Experience level required: beginners

Requirements

  • Basic knowledge of using Microsoft Excel & formulas

Course Outline

  • Introduction
    • Introduction - 2:22
    • Source Files
  • Excel Text Functions
    • Concatenating Cell Values - 4:39
    • The TEXTJOIN Function - 5:13
    • Extracting Text from a Cell - 4:01
    • Removing Excess Spaces from Cells - 3:03
    • Extracting Text from Irregular Strings - Part 1 - 4:46
    • Extracting Text from Irregular Strings - Part 2 - 5:31
    • SUBSTITUTE - Count the Number of Words - 4:21
    • SUBSTITUTE - Extract from Nth Occurrence of Character - 5:31
    • Convert Text to a Number - 2:33
  • Conclusion
    • Conclusion - 1:27

View Full Curriculum

Access
Lifetime
Content
0.5 hours
Lessons
11

Visualize Data with Excel Charts

Get New & Meaningful Insights Into Your Data by Mastering Chart Creation in Microsoft Excel

By ZENVA | in Online Courses

Master data presentation and learn to create functional and beautiful charts in Microsoft Excel. Through one of the world's most popular productivity tools, you can not only increase your business efficiency but make good first impressions with professional colleagues. Using sales data, you will create bar charts, combo charts, interactive charts, and more – all while learning to expertly format them in various layouts. This knowledge will allow you to benefit from the comprehensive and meaningful insights that can be gained through data visualization.

  • Access 11 lectures & less than an hour of content 24/7
  • Create basic charts from data in a spreadsheet
  • Format chart elements, labels & overall appearance
  • Utilize chart templates to speed up chart creation
  • Combine chart types into a single chart
  • Build a dropdown to interactively display different charts
  • Use Sparklines to quickly analyze data trends

Instructor

Trusted by 400,000+ learners and developers, Zenva provides world-class training on in-demand programming skills covering game development, machine learning, virtual reality, and full-stack web development. Their e-learning platform Zenva Academy is the leading place to upskill, learn and gain key tech skills for the innovation economy.

Important Details

  • Length of time users can access this course: lifetime
  • Access options: web & mobile streaming
  • Certification of completion included
  • Redemption deadline: redeem your code within 30 days of purchase
  • Updates included
  • Experience level required: beginner

Requirements

  • Basic working knowledge of Excel

Course Outline

  • Introduction
    • Introduction - 2:41
    • Source Files
  • Excel Chart Creation
    • Creating your First Charts - 9:37
    • Adding and Removing Chart Elements - 7:46
    • Formatting Charts - 7:45
    • Chart Templates - 3:28
    • Creating Combo Charts - 8:29
    • Interactive Charts - 5:42
    • Dynamic Labels - 6:01
    • Using Sparklines for Quick Insights - 5:38
  • Conclusion
    • Conclusion - 1:17

View Full Curriculum

Access
Lifetime
Content
3 hours
Lessons
30

Microsoft Excel Master Class for Business Managers

Get a Solid Understanding of Microsoft Excel & Master Efficient Excel Tools for Increased Productivity

By Start-Tech Academy | in Online Courses

Whether you're new to Excel or you've played around with it but want to get more comfortable with its advanced features, this course will be great for you. This course covers everything you need to crack Excel in the professional workplace from mathematical functions and formulas up to tables and charts. By the end of this course, your confidence in using Excel will soar. You'll have a thorough understanding of how to use Microsoft Excel for study or as a career opportunity.

  • Access 30 lectures & 3 hours of content 24/7
  • Become proficient in Excel data tools like Sorting, Filtering, Data validations & Data importing
  • Visually enchant viewers using Bar charts, Scatter Plots, Histograms, Waterfall charts & more
  • Become competent in using advanced Analytics techniques in Excel such as Regression, Goal Seek & Solver
  • Make great presentations using the Conditional & Table formatting options

Instructor

Abhishek Bansal worked as an Acquisition Process owner in a leading telecom company before moving on to learning and teaching technologies like Machine Learning and Artificial Intelligence.

Pukhraj Parikh worked as an Acquisition Process owner in a leading telecom company before moving on to learning and teaching technologies like Machine Learning and Artificial Intelligence.

Important Details

  • Length of time users can access this course: lifetime
  • Access options: web & mobile streaming
  • Certification of completion included
  • Redemption deadline: redeem your code within 30 days of purchase
  • Updates included
  • Experience level required: beginner

Requirements

  • PC or Mac
  • Internet access required
  • Any version of Excel

Course Outline

  • Introduction
    • Introduction - 2:22
    • Course Resources
  • Essential Formulas
    • Mathematical Functions - 6:50
    • Exercise 1/12: Mathematical Formulas
    • Textual Formulas - 7:47
    • Exercise 2/12: Textual Formulas
    • Logical Formulas - 11:23
    • Exercise 3/12: Logical Formulas
    • Date-time (Temporal) Formulas - 7:07
    • Exercise 4/12: Date-Time Formulas
  • Lookup Formulas
    • Lookup Formulas - 8:46
    • Exercise 5/12: Lookup Formulas
  • Data Tools
    • Data Tools - 19:07
    • Exercise 6/12: Data Tools
  • Formatting data and tables
    • Formatting data and tables - 18:00
    • Exercise 7/12: Formatting
  • Pivot Tables
    • Pivot Tables - 8:25
    • Exercise 8/12: Pivot tables
  • Charts
    • Charts-Part 1 - 9:59
    • Charts-Part 2 - 12:00
    • Exercise 9/12: Charts
  • Excel Shortcuts
    • Excel Shortcuts - 12:33
    • Exercise 10/12: Shortcuts
  • Analytics in Excel
    • Analytics in Excel - 15:48
    • Exercise 11/12: Analytics
  • Macros
    • Macros - 10:04
    • Exercise 12/12: Macros
  • Bonus Lectures
    • Waterfall chart - 12:00
    • Infographics 1: Cool charts - 14:12
    • Infographics 2: Cool charts - 6:51

View Full Curriculum

Terms

  • Unredeemed licenses can be returned for store credit within 30 days of purchase. Once your license is redeemed, all sales are final.
See More Reviews