Excel Financial Modeling and Business Modeling Course

Learn to apply basic and advanced Excel skills to create accounting, employee, and inventory management systems, including an employee database that auto-fills details and photos from codes.

Learn data cleaning and reformatting in Excel, including clearing formats, fixing dates, autofilling gaps, replacing blanks with not available or Islam, resizing columns, and converting to a formatted table.

This video explains the portal's review prompt after finishing a video, guiding you to rate the experience by selecting stars, adding a brief note, and saving feedback.

Use the today function to compute an employee's age in years, months, and days, then join the results with text and format the data as a table.

Create an 'employee picture' column in the main data file and automatically insert and fit each photo into its cell with one click using the Q Tools add-on.

Create an auto search box in Excel using a combo box from the developer tools to auto-complete employee names. Link it to the named range 'employees' to pull details.

Learn to extract an employee's joining date automatically using v lookup and the match function, by setting up a searchable employee list, named ranges, and dynamic headings.

Use a single lookup formula in Excel to fill all fields by fixing the employee name as the primary lookup value and using match to retrieve column data.

Learn to create picture lookups in excel by linking employee names to their pictures with index-match, named ranges, and a defined name for picture lookup.

Learn how to format cells and set currency defaults, and use Excel–Word mail merge to generate personalized salary notices and supplier checks with rupee formatting.

Learn to convert amounts from figures to words in Excel using a custom spelled number formula, automate with a VBA macro, and apply it to a check printing workflow.

Connect the macro-enabled Excel file with a word check template using mail merge, adjust field alignment for different banks, preview and finish the merge to print checks.

Edit fields by inserting before and after slash or dash to secure amounts; perform mail merge and print checks with Word connected to Excel.

Learn to toggle field codes in Word to apply comma style to currency figures copied from Excel, ensuring thousands formatting and optional rupees labeling.

Configure a Gmail account in Outlook 2016 to send bulk emails via mail merge, including enabling forwarding, two-step verification, and linking Gmail to Outlook.

Master database management with advanced excel to clean raw sales data, format columns, and extract prices using VLOOKUP, named tables, and exact-match formulas.

Apply tiered discounts using vlookup with approximate matching on sealed amounts, name the range, then compute net sales, cost of goods sold at 40 percent of gross price, and profit.

Format data into a table to improve the sheet, enabling filters and sorting with auto-recognized headings. Ensure no empty rows or gaps; fill with zeros to keep the table intact.

Transform raw data into pivot table reports to regionalize contributions to total sales in percentage, analyze beverage sales by month and region, and identify top salespeople.

Create and manage multiple pivot tables on the same sheet, customize date grouping to months and years, and summarize data by region to reveal total sales and transaction counts.

Extract regional contribution as a percentage of grand total to reveal the top performing region. Learn to add a calculated field and refresh the pivot table for dashboard reporting.

Create charts from pivot tables and consolidate them on a static dashboard. Learn to use line, bar, and pie charts, format sheets, and name pivot tables for clarity.

Master power pivot and the data model to handle millions of rows, load tables, build relationships, and use the related function to pull prices and discounts.

Learn to use Power Pivot to build a multi-table data model with relationships across sheets, enabling pivot tables that analyze cost of sales and units by product and sales representative.

Learn to build budgeting and forecasting scenarios in Excel with the scenario manager, compare multiple expense scenarios as revenue percentages, and save and switch between scenarios.

Collect bulk data from customers with Google Forms, automatically compile responses into an Excel sheet, and publish shareable links with validation for quality data.

Customize Google forms with color schemes, header images or logos, and templates, then organize questions into sections, set navigation, and tailor end messages for professional surveys.

Learn how to email Google Forms professionally to vendors or customers by turning links into clear clickable buttons, customizing link text, and using image buttons for a polished invitation.

Automatically back up desktop Excel files to Google Drive with Drive for desktop, enabling cloud sync of online files and two-way updates across devices.

Build an automated monthly EMI schedule in Excel to manage car, business, and personal loan payments, tracking 15 payments and ensuring funds five days before due dates.

Split the first payment into monthly installments starting 28 May 2020. Copy fields and fill 36 installments by pattern, freeze headings, and apply filters.

Master funds management in Excel by applying filters, adding a field that uses today() to compute days left on installments, and display only upcoming payments with conditional formulas.

Apply conditional formatting in Excel to highlight the days left column when days left are greater than zero and less than or equal to grindy, enabling funds management visibility.

Learn to automate depreciation schedules in Excel for a motor vehicle using straight-line and declining balance methods, with dynamic row extension, above-cell formulas, and error handling for varying useful lives.

Build a depreciation calculation using a step-by-step formula that adapts to the asset’s useful life, drags across years, and handles blanks and errors with fixed references.

Automate year-end depreciation calculations in Excel using a 2013-01-01 acquisition date, applying 360-day and end-of-month methods. Utilize IF logic to handle blanks and dynamic year updates as the horizon changes.