Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Advanced Excel Function and Formula
Rating: 4.4 out of 5(21 ratings)
4,014 students

Advanced Excel Function and Formula

Learn Project Based Advance Excel Functions and Formulas
Created byAustin Morris
Last updated 1/2023
English
English [Auto],

What you'll learn

  • Advanced Excel Funtions
  • Sumifs, Countifs, Averageifs To Account For Exceptions
  • Vlookup & Hlookup For Dynamic Lookups
  • Advanced Formula

Course content

1 section • 17 lectures • 3h 11m total length

  • Introduction1:50

    Explore how Microsoft Excel saves time with formulas and functions for data management and financial analysis. Create charts, forecasts, and templates in Microsoft 365 to visualize data and streamline tasks.

  • IFS Functions25:32

    Learn to use sum ifs, count ifs, and average ifs to sum, count, and average with multiple criteria, and convert data into dynamic tables and pivot tables.

  • Nested IF9:42

    Master nested ifs in Excel by building multi-criteria tests to label revenue as good, exceptional, or flag, using if, and, and ifs functions with fill handle.

  • IFERROR5:12

    Learn to trap and handle errors in Excel with Iferror, returning a custom value like no data or zero when formulas fail.

  • V anv H Lookup Dynamic7:35

    Learn to make hlookup dynamic by replacing the row index with a match function, enabling exact matches and automatic updates when data changes.

  • Index and Match5:04

    Explore how to combine index and match in Excel to retrieve revenue and profit for any program, using a dynamic dropdown and exact-match lookups across large datasets.

  • Textual Most Used Functions7:35

    Explore six essential text functions in Excel, including left, right, mid, len, find, and text join, to extract, measure, locate, and combine text efficiently.

  • Textual Functions11:04

    Explore advanced textual functions in Excel, including char, trim, exact, contact (concatenate), text formatting, lower, upper, proper, and repeat, with practical examples.

  • Excels Top DATE functions7:31

    Explore excel's top date functions, including now, today, date, time, weekday, text, day, month, year, and end-of-month calculations, to format and analyze dates efficiently.

  • Project: Invoice19:18

    Create an invoice in Excel by merging cells, applying alignment, fonts, colors, headers, borders, and a formatted table with price, quantity, amount, total amount, and signature fields.

  • Project: Monthly Salary Slip12:51

    Learn to build a monthly salary slip in Excel by merging cells, applying borders, and formatting income and deductions like basic salary, DA, HRA, provident funds, tax, and net salary.

  • V anv h lookup dynamic part 17:37

    Master dynamic vlookup and hlookup by turning data into an adjustable table, using match to feed the row index, and validating with a dropdown list for seamless growth.

  • Monthly salary slip12:51

    Design a monthly salary slip in Excel by merging cells, applying borders, and formatting income and deductions such as basic salary, DA, HRA, Provident Funds, and tax.

  • Auditing tool6:59

    Learn to build an auditing tool in Excel and use key formula auditing features to trace precedents and dependents, show formulas, and evaluate formulas.

  • Credit debit14:17

    Learn to build a professional debit and credit sheet in Excel, format as accounting, and calculate cash balance using a formula with previous year balance, debit, and credit.

  • Excel power query tool9:42

    Explore the Excel Power Query tool to prepare a working days list by excluding holidays and weekends, merging total dates with holidays, and loading results as connections.

  • Dashboard26:57

    Create dynamic Excel dashboards that consolidate key performance indicators in one visual hub using pivot tables, charts, and slicers to display region-wise sales and revenue by sales rep.

Requirements

  • Basic Excel Knowledge Required

Description

If you're a business professional, who uses (or will be using Microsoft Excel) on a daily basis, this is the course for you!

The Course will Help You Build a Strong Foundation in Excel & Solve Complex Problems Fast - This is How:

  • Use my top 10 tips to save time

  • Learn the top 10 formulas for quick and dynamic analysis

Advanced Excel skills are highly relevant in business. No matter which role you’re currently in or you’re planning to take on. Whether you’ll be in Finance, consulting, IT, in project management, your advanced Excel skills will set you apart from the competition.

What is the difference between an Advanced Excel and Average Excel user?

An advanced Microsoft Excel user is aware of the tools and features available and can apply the right tools for the right task, instead of relying on their go-to tools and making them work for every situation. Advanced Excel users, always find the optimal solution for every task, and they find it fast!

What differentiates this Microsoft Excel course from the others?

The reason I created this specific Advanced Excel course, is because there are many advanced Excel users who are unaware of key features & formulas in Excel. I understand that when you take an Excel training it can be so broad, and a lot of courses cover too many topics. It’s easy to get lost. You might also not immediately appreciate why some features are useful and how you can practically apply them. We are creatures of habit and it’s difficult to get our head around learning new techniques. As a result you might be missing out on some features that can majorly simplify the way you use Excel.

Differentiation factor #1

Focus - The top 10 brings focus to the key Excel features which will provide you with a solid & a strong foundation in Excel.

Differentiation factor #2

Learn by doing - This Advanced Microsoft Excel course is well structured and organized. You can download my Excel Demo workbook which I use to demonstrate each feature and practice along with me. You can then do an exercise from the Excel Exercise workbook to test your knowledge. Real learning happens when you attempt to solve problems on your own. Answers are provided, but do ask any questions if you get stuck. Your questions will always be answered.

Differentiation factor #3

Engaging - I have made every attempt to keep the course interesting and engaging by mixing talking head explanations with screencast demos. Each course is split by topic & feature. This allows you to easily pick what you want to learn now or review later.

Summary

My main goal in this training is to increase your awareness of the top tools and formulas in Excel to help you solve complex problems. Users are not aware of what they don’t know. Only when you know the extent and possibilities Excel offers you, only then are you able to handle any type of analysis with the best method.

Becoming advanced in Excel takes practice, readiness to learn new methods and willingness to apply these to practical cases. Take this course to get a head start!

Who this course is for:

  • Who want to learn Advance Use of Excel

Report abuse