Microsoft Excel: From Beginner to Expert

Master quick sum and product calculations in Excel, advancing from beginner toward expert level, for efficient spreadsheet work.

Master calculating the average and percentage increase in Excel, advancing from beginner to expert with practical techniques.

Use the vlookup function to bring product group data from a reference table into the main table, using exact and approximate matches for sku lookups.

Learn to use the max and min functions in Excel to identify the largest and smallest values. Create rankings and charts from rank data using large and small functions.

Learn to perform frequency analysis in Excel using the frequency function, build a frequency distribution and histogram, and visualize results with data bars and percentage calculations.

Explore Excel's logical functions, including if, and, or, not, and nested formulas, to automatically test conditions, return true or false values, and handle multi-condition scenarios with IFS.

Learn to use Excel's logical functions, including and, or, not, and nested formulas to automatically calculate employee bonuses based on sales targets and contracts, with practical examples.

Explore how to use what-if analysis in Excel to model forecasts and business scenarios with data tables, predicting profits under different sales volumes and identifying the break even point.

Learn to use goal seek and scenario manager in Microsoft Excel to solve what-if analyses and pick the best restaurant for a 23-person corporate party within a $5,000 budget.

Learn to enable the Excel solver add-in and use it to optimize linear profit across three stores, distributing stickers, papers, and folders within stock constraints for maximum profit.

Learn to insert symbols in Excel via keyboard shortcuts, using fonts to create check marks and crosses, adjust colors and sizes, and center-align symbols to make lists more visual.

Discover how the flash fill function in Excel fills patterns from adjacent columns, introduced in Excel 2013, and learn to enable it and insert an apostrophe to avoid formulas.

Learn to record and edit macros in Excel using VBA to automate repetitive tasks without programming skills, including setting up the developer tab, recording, and running macros.

Learn to create a vacation calendar in Excel with a template, start/end dates, and conditional formatting to highlight vacations, overlaps, weekends, and extra days using color codes.

Learn to apply Excel conditional formatting to highlight dates by urgency, using dynamic current date and color rules (gray, red, green, orange) with a checkbox to toggle highlighting.

Learn to create an overlapping histogram in Excel to compare two data sets on the same chart, using a secondary axis and adjusted bar gap for budget versus actual spend.

Learn to build a diverging stacked bar chart in Excel to visualize survey percentages around a center, using buffer columns and color cues for agree and disagree.

Learn to visualize data in Excel with a lollipop chart, a modified scatter plot using dots connected to the y-axis and ranked values.

Create back to back histograms from two data samples to compare easily, then align on a shared x-axis, mirror one dataset, and adjust the legend and formatting for clarity.

Learn to create spark lines in Excel to track trends in a single cell, format high points in green, and use autofill to apply to multiple data ranges.

Forecast the airline catering division's revenue by meals served times price per meal, using passenger volumes from Turkish Airlines and other carriers, and compute EBIT and EBITDA from segment data.

Forecast the airline catering division's costs by reconstructing historical cost items from consolidated PNL, then project materials and services, personnel, depreciation, and other expenses as a percentage of revenue.

Forecast the airline catering division costs and P&L in Excel by linking personnel and average wage to meals and revenue, then project depreciation and margins.

Forecast the events catering division revenue from major, classic, and extraordinary events using growth assumptions and a cost structure based on revenue percentages.

Forecast the RLH division's revenue by analyzing outlet counts, revenue per location, and new openings, then project costs, margins, and growth.

Learn to model cash flow statements by adjusting net income with depreciation and change in working capital, forecast operating, investing, and financing activities, and analyze free cash flow and dividends.

Model balance sheets and cash flow in Excel, covering intangible assets. Forecast capex, depreciation, and working capital.

Compute net debt, net debt to gdp, roic, ebitda, and cash earnings to prepare for dcf valuation. Connect p&l, balance sheet, and cash flow, and perform a balance check.

Forecast six-year unleveraged free cash flow, discount to obtain enterprise value, adjust for net debt to derive equity value, and compute WACC from risk-free rate, equity premium, and beta.

Use the weighted average cost of capital to set discount rates, compute present value of cash flows, apply perpetuity growth model for terminal value, and estimate equity value per share.

Calculate implied multiples and a sum of the parts valuation across airline catering, events catering, and restaurants, using P/E, EV/EBITDA, and cash flow with peer discounts for 2013 and 2014.

Refine financial modelling and valuation as both science and art. Update models with quarterly results, forecast deviations, CapEx, and working capital, keeping income statements, cash flows, and balance sheets aligned.