Advanced Excel Course for Job and Real World

Learn Microsoft Excel from basic to advanced levels, building essential skills and mastering advanced functions and formulas to tackle real-world tasks.

Master five advanced Excel formulas: index, match, choose, indirect, correl, and forecast—to retrieve values, reference data, and forecast future trends in real-world work.

Master five interview-ready Excel formulas, including VLOOKUP, protect sheet, remove duplicates, chart creation, and data validation. Apply these concepts to real-world tasks in this advanced Excel course.

Explore date functions in Excel, using today and now for current dates and times, derive day, month, and year, then add or subtract days, months, and years in real-world worksheets.

Create a complete entry bill in Microsoft Excel by building an invoice layout, entering bill numbers, items, rates, quantities, amounts, and calculating totals and GST.

Master Excel navigation with shortcuts to jump to data using ctrl+down, select ranges with shift, switch sheets with ctrl+page up/down, and copy–paste with ctrl+c/v.

Learn how Excel macros automate repetitive tasks using VBA and the macro recorder. Save and run macros from the developer tab, recording formatting and formulas across worksheets.

Explore excel vba, the visual basics for applications, an object oriented programming language, and learn how macros automate tasks, enable the developer tab, and use modules in the vba editor.

Learn to use Excel's FV and PV functions to compute future value and present value from rate, periods, and payments, illustrating the time value of money and cash flows.

Learn how to build an Excel-based audit report that calculates purchases, sales, returns, and availability using sumproduct and sumif, and explains types of auditor opinions.

Design and print a monthly salary slip in Excel using page layout, merged headers, earnings and deductions sections, net salary calculations, and salary in words.

Learn index and match in Excel to locate data across ranges with row and column numbers, compare to VLOOKUP, and use arrays and references for exact and flexible lookups.

Understand the internal rate of return (IRR), how negative cash outflows and positive inflows determine it, and how to calculate IRR in Excel to evaluate investments.

Learn to calculate discount rates, present value, and net present value in Excel by applying cash flow sequences, PV formulas, and the NPV function.

Explore how offset and match work together to locate a value's position in a row or column and retrieve an ID from a lookup array using exact match.

Learn how to use Excel's PMT function to calculate monthly loan payments with a constant interest rate, and build a complete loan schedule showing beginning balance, interest, and principal.

Learn how to use VLOOKUP and HLOOKUP to find exact or approximate data in a table, specify table arrays, and understand vertical versus horizontal lookups.

Learn how to use vlookup and the choose function in Excel, combine them for lookup tasks, and apply colors and ratings with exact match examples.

Combine VLOOKUP with the column function to retrieve exact matches from a table, learn about column index numbers, and anchor references with absolute and relative approaches in Excel.

Master VLOOKUP and INDIRECT in Excel by combining them with IF for dynamic lookups, exploring table arrays, exact matches, and practical examples.

Explore vlookup and match functions in Excel, learn how to use vlookup with a match to find exact results, and understand match types and range references.