Advanced Excel Course With Shortcuts Tips and Tricks for JOB

Discover Microsoft Excel from beginner to expert, mastering fundamental abilities and advanced function formulas, and apply sophisticated Excel techniques with guided support to boost your skills.

Explore five advanced excel formulas, including offset with match, data validation, text function, nested date function, xlookup with wildcards, and sort and filter to enhance practical workflows.

Create a professional entry bill in Microsoft Excel from scratch, building an itemized invoice with company name, location, rate, quantity, totals, GST, and payment method.

Master date functions in Excel, including today function, now function, and date function, to extract year, month, and day, concatenate values, and add or subtract months, years, and days.

Master essential Excel formulas for job interviews, including roundup, round down, sum and sum if, autosum, count, count if, VLOOKUP, concatenate, and average, with practical demonstrations.

Record and run Excel macros via the Developer tab, save them in VBA modules, apply formatting and formulas across sheets, and assign shortcut keys.

Master the most useful Excel shortcut keys and navigation keys, covering about 20 shortcuts like ctrl+n, ctrl+s, ctrl+p, ctrl+f, ctrl+c/x/v, ctrl+z/y, and alt+f4.

Explore VBA in Excel, learning what VBA is, how it works, and how to record and run macros to automate formatting and data tasks.

Learn to calculate present value and future value in Excel using PV and FV, with rate, nper, payment, and type to model cash inflows and outflows.

Learn how to create an audit report in Excel by calculating amounts, using sum product, balance, and availability to track purchases, sales, and returns.

Create a salary slip in Excel using page layout and merged cells for a professional look. Calculate earnings, deductions, and net salary with sum, subtraction, data validation, and xlookup options.

Learn to use index and match together in Excel to retrieve values from a table using the array form and the reference form, and build a data validation table.

Explore using Excel's IRR function to compute internal rate of return from cash flows, compare to cost of capital, and connect to NPV.

Master the offset and match functions in Excel to locate values and return dynamic results. Combine match with offset to reference cells and navigate rows and columns.

Master the PMT function to build a complete loan schedule in Excel, calculating payments, end balances, interest, cash flows, PV, NPV, and IPMT steps.

Learn to use VLOOKUP and HLOOKUP to search values in vertical and horizontal data. Master specifying a table array, column or row index numbers, and locking references for robust results.

Learn to use vlookup to retrieve data from a table by lookup value and column index, and apply the choose function to map indices to values, with examples in Excel.

Learn to use VLOOKUP and the column function together to fetch data from a table array using lookup values, and the column index number.

Learn how to use vlookup and match together to retrieve data from tables, including exact and approximate matching, and understand the table array, column index number, and lookup value.

Learn how net present value (NPV) and IRR in Excel evaluate investment ROI, using negative cash outflows, positive inflows, and a discount rate or cost of capital.

Master VLOOKUP and INDIRECT in Excel by learning their individual use, and exploring how to combine them for exact lookups with table arrays, column indexes, and false for exact matches.

This lecture guides a Microsoft Excel project to build a student marksheet, computing total, average, rank with rank.eq, pass/fail, and status with formulas, including distinction, good, and poor.