Don't like banners? Log in and we will make sure you see no banners. For free.
No cover art

[ WebToolTip.com ] Udemy - Microsoft Excel Formulas and Functions - Comprehensive Guide

Size
1.1 GB
Seeders
3
Leechers
2
Files
26
Category
Added
at 7:11am GMT+1
Status
Not verified
Infohash
8d19be94a62d32c8baed5f131301a147cbf7affc
Don't like banners? Log in and we will make sure you see no banners. For free.

Description
Microsoft Excel Formulas and Functions: Comprehensive Guide


https://WebToolTip.com


Published 5/2025

Created by Bright Path

MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch

Level: All | Genre: eLearning | Language: English | Duration: 25 Lectures ( 3h 22m ) | Size: 1.1 GB


Learn every essential Excel formula and function, from basic calculations to advanced data analysis techniques.


What you'll learn

Understanding the Basics of Formulas in Excel

Cell References: Relative, Absolute, and Mixed

Basic Arithmetic Operations in Excel

Working with Text Functions (LEFT, RIGHT, MID, CONCATENATE)

Using Logical Functions (IF, AND, OR)

Basic Date and Time Functions (TODAY, NOW, DATE)

Using Mathematical Functions (SUM, AVERAGE, ROUND, COUNT)

Text Manipulation Functions (TRIM, LEN, SUBSTITUTE)

Advanced Lookup Functions (XLOOKUP, MATCH)

Advanced Statistical Functions (MEDIAN, MODE, STDEV)

Financial Functions (NPV, IRR, PMT)

Data Analysis with Logical Functions

Combining Multiple Functions in a Single Formula

Building Custom Functions with VBA

Creating Dynamic Ranges with OFFSET and INDIRECT

Advanced Charting Techniques with Formulas

Automating Data Visualizations with Dynamic Formulas


Requirements

No Excel Experience needed

File list
  • [ WebToolTip.com ] Udemy - Microsoft Excel Formulas and Functions - Comprehensive Guide
  • ~Get Your Files Here !/1 - Introduction to Excel Formulas and Functions/1 -Understanding the Basics of Formulas in Excel.mp4 50.2 MB
  • ~Get Your Files Here !/1 - Introduction to Excel Formulas and Functions/2 -Introduction to Excel Functions and Their Syntax.mp4 49.8 MB
  • ~Get Your Files Here !/1 - Introduction to Excel Formulas and Functions/3 -Cell References Relative, Absolute, and Mixed.mp4 38.9 MB
  • ~Get Your Files Here !/1 - Introduction to Excel Formulas and Functions/4 -Basic Arithmetic Operations in Excel.mp4 37 MB
  • ~Get Your Files Here !/2 - Essential Excel Functions for Beginners/1 -Working with Text Functions (LEFT, RIGHT, MID, CONCATENATE).mp4 54 MB
  • ~Get Your Files Here !/2 - Essential Excel Functions for Beginners/2 -Using Logical Functions (IF, AND, OR).mp4 51.5 MB
  • ~Get Your Files Here !/2 - Essential Excel Functions for Beginners/3 -Basic Date and Time Functions (TODAY, NOW, DATE).mp4 39.7 MB
  • ~Get Your Files Here !/2 - Essential Excel Functions for Beginners/4 -Introduction to Lookup Functions (VLOOKUP, HLOOKUP).mp4 53.5 MB
  • ~Get Your Files Here !/3 - Intermediate Excel Formulas and Functions/1 -Mastering Lookup and Reference Functions (INDEX, MATCH).mp4 45.3 MB
  • ~Get Your Files Here !/3 - Intermediate Excel Formulas and Functions/2 -Using Mathematical Functions (SUM, AVERAGE, ROUND, COUNT).mp4 35.1 MB
  • ~Get Your Files Here !/3 - Intermediate Excel Formulas and Functions/3 -Text Manipulation Functions (TRIM, LEN, SUBSTITUTE).mp4 35.8 MB
  • ~Get Your Files Here !/3 - Intermediate Excel Formulas and Functions/4 -Working with Nested Functions and Conditional Formulas.mp4 45.3 MB
  • ~Get Your Files Here !/4 - Advanced Excel Functions/1 -Advanced Lookup Functions (XLOOKUP, MATCH).mp4 40.7 MB
  • ~Get Your Files Here !/4 - Advanced Excel Functions/2 -Array Formulas and Dynamic Arrays (SORT, FILTER, UNIQUE).mp4 55.2 MB
  • ~Get Your Files Here !/4 - Advanced Excel Functions/3 -Advanced Statistical Functions (MEDIAN, MODE, STDEV).mp4 40.4 MB
  • ~Get Your Files Here !/4 - Advanced Excel Functions/4 -Financial Functions (NPV, IRR, PMT).mp4 42.9 MB
  • ~Get Your Files Here !/5 - Data Analysis with Excel Functions/1 -Data Analysis with Logical Functions (SUMIF, COUNTIF, AVERAGEIF).mp4 42.3 MB
  • ~Get Your Files Here !/5 - Data Analysis with Excel Functions/2 -Conditional Formatting with Formulas.mp4 39.9 MB
  • ~Get Your Files Here !/5 - Data Analysis with Excel Functions/3 -Introduction to What-If Analysis Tools (Goal Seek, Data Tables).mp4 53.1 MB
  • ~Get Your Files Here !/6 - Working with Complex Formulas/1 -Combining Multiple Functions in a Single Formula.mp4 28.9 MB
  • ~Get Your Files Here !/6 - Working with Complex Formulas/2 -Building Custom Functions with VBA (Introduction to User-Defined Functions).mp4 40.1 MB
  • ~Get Your Files Here !/7 - Excel Formulas for Data Visualization/1 -Creating Dynamic Ranges with OFFSET and INDIRECT.mp4 44 MB
  • ~Get Your Files Here !/7 - Excel Formulas for Data Visualization/2 -Using Formulas to Create Interactive Dashboards.mp4 60.3 MB
  • ~Get Your Files Here !/7 - Excel Formulas for Data Visualization/3 -Advanced Charting Techniques with Formulas.mp4 41.1 MB
  • ~Get Your Files Here !/7 - Excel Formulas for Data Visualization/4 -Automating Data Visualizations with Dynamic Formulas.mp4 51.4 MB
  • ~Get Your Files Here !/Bonus Resources.txt 70 B

Rating
Not rated yet
Log in to rate

Comments

No comments yet.


Similar torrents
NameSizeDate
1.4 GB41
2.5 GB42
5 MB20
539 MB20
1.2 GB11
20 MB12
1.6 GB10
23 MB01
1.8 GB00
2.7 GB01
1 MB01
2.6 GB00
9 MB01
23 MB01
5 MB01