Search result for Formulas and functions Online Courses & Certifications
Get Course Alerts by Email
Excel Data Analysis and Problem Solving
by Mofeed Abouseafa- 0.0
4.5 hours on-demand video
- Dealing with formulas and functions in Excel - Dealing with tables and charts and plot math functions - Using Power Query and Power pivot table - Using what-if tools and Solver to solve problems - Record a macro and make a button to use it - Use the analysis ToolPak such as ANOVA test, descriptive statistics and histogram chart...
$12.99
Microsoft Excel Advanced Functions with INDEX and MATCH
by Kyle Pew- 4.8
3.5 hours on-demand video
Develop Dynamic Excel Worksheets by Mastering Excel's INDEX and MATCH functions (Excel 2007, 2010, 2013, 2016) After you master these building block concepts we will then dive into several real world scenarios, where I'll take you step by step through the finer points of creating dynamic and robust formulas using Excel's INDEX() and MATCH() functions....
$14.99
The Complete Google Sheets Course: Beginner to Advanced!
by Evan Ramsey- 4.6
8 hours on-demand video
A crash course in basic and advanced functions: Learn VLOOKUP, QUERY & MORE! Use many of these skills in Excel too! But you will also learn valuable advanced formulas like VLOOKUP, INDEX(MATCH()MATCH()), and IMPORTRANGE. Arithmetic Functions like SUM, COUNT, and AVERAGE Shortcuts like filling formulas across THOUSANDS of cells Advanced functions like INDEX MATCH MATCH and IMPORT RANGE...
$23.99
Excel : 2019 Microsoft Excel Beginner to Expert level course
by Omer Aftab- 0.0
1 hour on-demand video
Excel 2007, 2010, 2013, 2016, and Office 365. Excel Shortcut, Excel VBA, Excel Macros, Excel Charts, Excel Formulas and Functions, Excel Analytics . Getting in and understanding what excel is all about. Discuss more about VLOOKUP, Database Functions and Text Functions. Excel Shortcut, Excel VBA, Excel Macros, Excel Charts, Excel Formulas and Functions, Excel Analytics ....
$12.99
Master Excel Functions in Office 365 - Excel Dynamic Arrays
by Leila Gharani- 4.7
7 hours on-demand video
We have NEW Excel functions like XLOOKUP, FILTER, SORT, UNIQUE, SEQUENCE and MORE! Use VLOOKUP, IF and SUMIFS together with Excel Dynamic Arrays formulas How Excel's calculation engine has changed and how this impacts all existing formulas The new functions are well explained with business examples, and the course notes will be a great reference!" Jennifer...
$14.99
Microsoft Excel tricks (MacBook & Windows) beginner-advanced
by Denis Kulikov- 0.0
3 hours on-demand video
Excel functions and formulas, Microsoft Excel Functions & formulas - XLOOKUP, FILTER, CONVERT, UNIQUE, CHOOSE, PMT (and a lot more) Microsoft Excel Functions and Formulas Microsoft Excel Functions & formulas - XLOOKUP, FILTER, CONVERT, UNIQUE, CHOOSE, PMT (and a lot more) Learn the most common Excel functions and formulas used in the Office...
$12.99
Best Excel Course: Data Cleaning - For further Data Analysis
by Yoda Learning- 0.0
1.5 hours on-demand video
In order to make it useful to analyse, we have to clean this and put them in a structured format. In order to save time and effort on cleaning and put the structure in place, We need few important data cleaning techniques as mentioned below which are part of this course....
$12.99
Related searches
Zero to Hero in Microsoft Excel: Complete Excel guide 2021
by Start-Tech Academy- 4.5
6.5 hours on-demand video
Mathematical Functions - This lecture covers Mathematical formulas such as SUM, AVERAGE,RAND, MIN & MAX, SUMPRODUCT. Logical Formulas - This lecture covers Logical formulas such as AND & OR, IF, COUNTIF, SUMIF Date-time (Temporal) Formulas - This lecture covers Date-time related functions such as TODAY & NOW, DAY, MONTH & YEAR, DATEDIF & DAYS...
$12.99
Excel 2016 Foundation Training Course | Video Tutorial
by David Murray- 4.7
2 hours on-demand video
We start by looking at the various Excel Selection Techniques and then see how to use these techniques for Manipulating Rows and Columns and also for Manipulating Cells and Cell Content Then then examine Formulas and Functions. Next we see how to create and format Charts within Excel 2016...
$12.99
Excel 2010 Introduction
by Intellezy Trainers- 0.0
4 hours on-demand video
Specifically you will understand how to create, save, enter data and print spreadsheets in addition to learning how to create formulas and use functions to calculate in Excel. You will learn how to format spreadsheets, manipulate columns and rows, add headers and footers and use page setup options to prepare them for printing....
$12.99