Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Mastering Excel Formulas & Functions: Beginner to Advanced
Rating: 4.5 out of 5(267 ratings)
27,564 students

Mastering Excel Formulas & Functions: Beginner to Advanced

Advanced Microsoft Excel Formulas & Functions, Error, Logical, Index, Match, Vlookup, Xlookup, Pivot Table & Many More
Created byClick Learning
Last updated 1/2024
English
English [Auto],

What you'll learn

  • Understand the basic to advanced Formulas & Functions
  • Understand error handling techniques and troubleshooting common formula errors.
  • COUNT, COUNTA, COUNTIF, COUNTIFS, COUNTBLANK Function
  • AVERAGE, AVERAGEA, AVERAGEIF and AVERAGEIFS Function
  • VLOOKUP Function
  • HLOOKUP Function
  • XLOOKUP Function
  • Logical Function

Course content

1 section • 31 lectures • 4h 5m total length

  • What About Error Function8:30
  • SUM Function11:38

    In this lesson I  will discuss about SUM, SUMIF, SUMIFS, SUMPRODUCT Function's

  • AVERAGE Function8:40

    In this lesson I will discuss about AVERAGE, AVERAGEA, AVERAGEIF and AVERAGEIFS Function 's

  • COUNT Function10:47

    In this lesson I will discuss about COUNT, COUNTA, COUNTIF, COUNTIFS, COUNTBLANK Function's

  • ROUND Function8:54

    In this lesson I will discuss about ROUND, ROUNDUP, ROUNDDOWN, MROUND Function's

  • MIN and MAX Function7:05
  • Logical Functions9:00

    In this lesson I will discuss about  IF, AND ,OR and NOT Functions

  • Nested If with Max and Min Formula7:42
  • LEFT, RIGHT, MID Function9:53
  • LEN FUNCTION7:01
  • Find and Search Function6:54
  • Concatenate Function8:42

    Explore the concatenate function in Excel to combine names and text, add spaces, and format results with upper, lower, and proper case for clean reports.

  • TRIM, UPPER, LOWER and PROPER FUNCTIONS13:28

    Explore how to clean and extract text in Excel using the trim, upper, lower, proper, left, right, and mid functions, mastering common text manipulation tasks.

  • REPT FUNCTIONS7:50
  • HYPERLINK FUNCTIONS7:36
  • Now and Today Functions2:27

    Learn how the now and today functions display the current date and time in Excel, update automatically with worksheet changes, and help track data entry timing and durations.

  • DAY, MONTH and YEAR FUNCTIONS5:13
  • Date, Datevalue, Edate & Eomonth Functions8:09

    Explore Excel date and datevalue functions, convert text to dates, and use edate and eomonth to add months and find month ends.

  • TIME, HOUR, MINUTE and SECOND Functions4:18
  • VLOOKUP Function8:41
  • IF & VLOOKUP Functions7:20
  • VLOOKUP with Match Function6:30
  • VLOOKUP Exact Match with Column4:52

    Master vlookup with exact match and column reference to retrieve values from any column, using table array, range lookup false, and absolute references, plus iferror for errors.

  • VLOOKUP Approximate Match Function5:31
  • HLOOKUP Function6:12

    Explore the hlookup function, a horizontal lookup that searches the top row and returns a value from a row. Learn exact and approximate matching and how to build dynamic lookups.

  • XLOOKUP Function5:54
  • XLOOKUP and XMATCH Functions13:26

    Explore XLOOKUP and XMATCH in Excel to perform exact lookups and retrieve a student's score by name. Use data validation and tables to practice lookups and handle not found results.

  • Exact match vs Approximate match5:35

    Compare exact match and approximate match in Excel using VLOOKUP, and learn when to apply each for precise lookups and nearest value data analysis.

  • Drop Down List with Data Validation7:08

    Create drop down lists in Excel with data validation to enforce predefined options, configure input messages and error alerts, ensuring data consistency for months, designation, and names.

  • Multiple Dependent Drop Down Lists10:23

    Explore how to build multiple dependent dropdown lists in Excel that dynamically update based on continent, country, and city selections using data validation, index, and indirect functions.

  • Advanced Pivot Table Techniques9:54

    Master advanced pivot table techniques in Excel to group and analyze data, filter by shipping mode and customer, and customize layouts to summarize profit and shipping costs.

Requirements

  • No Prior Excel Knowledge is Needed.
  • Beginners and Experts Will Learn a Lot From The Course.

Description

Welcome to "Mastering Excel Formulas & Functions: Beginner to Advanced," a comprehensive course designed to empower you with the skills and knowledge needed to become a proficient Excel user. Whether you're just starting your journey with Excel or seeking to elevate your expertise, this course is your roadmap to mastering the intricate world of Excel formulas and functions.


Microsoft Excel is a powerhouse for data analysis, reporting, and decision-making, and at its core are formulas and functions that allow you to perform complex calculations with ease. From basic arithmetic to advanced statistical analysis, this course covers it all, providing you with a step-by-step guide to becoming a confident and efficient Excel user.


Key Learning Objectives:


  • Foundations of Excel Formulas: Understand the basics of formulas, cell references, and arithmetic operations to lay a solid foundation.

  • Logical and Lookup Functions: Dive into logical functions (IF, AND, OR) and lookup functions (VLOOKUP, HLOOKUP, INDEX, MATCH) for dynamic data manipulation.

  • Mathematical and Statistical Functions: Master mathematical functions (SUM, AVERAGE, COUNT) and statistical functions for data analysis.

  • Text and Date Functions: Explore text functions (CONCATENATE, LEFT, RIGHT) and date functions for efficient data handling.

  • Advanced Formulas: Delve into advanced formulas including array formulas, nested functions, and financial functions for complex calculations.

  • Error Handling and Troubleshooting: Learn error handling techniques and troubleshooting common formula errors for seamless data processing.


Why Choose This Course?


  • Comprehensive Learning: This course covers Excel formulas and functions from beginner to advanced levels, ensuring a deep understanding of their applications.

  • Expert Instruction: Benefit from the guidance of experienced instructors passionate about Excel and dedicated to your success.

  • Lifetime Access: Enroll once and enjoy lifetime access to course materials, allowing you to learn at your own pace and revisit concepts whenever necessary.

  • Career Advancement: Excel proficiency, especially in formulas and functions, is a sought-after skill in various professions, making this course a valuable asset for career growth.


Embark on your journey to mastering Excel formulas and functions. Enroll now in "Mastering Excel Formulas & Functions: Beginner to Advanced" and unlock the full potential of Microsoft Excel. Whether you're a student, business professional, or data enthusiast, this course equips you with the expertise needed to excel in data manipulation and analysis. Don't miss this opportunity to elevate your Excel skills to new heights!


Who this course is for:

  • Anyone Who Work with Excel Formulas and Functions.
  • Anyone Curious to Master Excel in Short Span of Time.

Report abuse