MBA in Excel- Master Business Analytics in Excel

Get a preview of the modules in the MBA in Excel course, outlining how business analytics in Excel will be covered to build mastery.

Apply filters in Excel to drill down data, then use the subtotal formula to sum visible data and compare each product’s contribution to the grand total.

Explore sumif to calculate monthly totals for quantity and value, then compute average price, locking references with F4 and dragging formulas, and visualize trends with a line chart.

Master advanced sumifs in excel by building multi-criteria array formulas with ctrl+shift+enter, summing sales by product, region, and date.

Explore advanced count and sum techniques in Excel, including countif, sumproduct, large, and max, to analyze transactions, unique sales reps, top three 2019 sales, and January Dubai maximums.

Learn to apply conditional formatting in Excel to color dates by day of week, highlight sales above a threshold with formulas and data bars, and format positive and negative changes.

Explore how to use slicers in pivot tables to filter data by salesman, city, and category, and switch the report layout to tableau form for a cleaner, slicer-driven view.

Learn to use slicers and a date timeline in Excel pivot tables to filter by category and period, build a dynamic chart, and identify key contributors with running totals.

Record and store multiple macros to automate pivot table analyses. Assign macros to shapes for quick use, covering top five sales reps, SKUs, categories, and customers.

Explore excel lookup techniques using VLOOKUP and INDEX-MATCH to retrieve SKU names, barcodes, and sales values, handle text versus number formats, and validate results across sheets.

Learn to build dynamic lookups with offset and indirect, using match and named ranges to retrieve year-to-date sales across multiple sheets, with multi-criteria sumifs and sheet-name handling.

Master margin and selling price calculations in Excel, including gross profit and margin on selling price; explore weighted average cost, dynamic formulas, and scenario analysis with what-if and solver.

Convert your data into a table for dynamic updates and easier formulas, then build an end-user dashboard where date-driven charts auto-update, showing category, sales by period, and customer type comparisons.

Record a macro to remove unique dates starting from June 1, 2020 using an advanced filter, and paste results for calculating the previous month and the previous year sales.

Build category totals in Excel using a sales data table and sumifs for current period, previous month, and year-ago values, then compute percentage change and category weight.

Learn to use shapes with named ranges in Excel to display up or down indicators. Build dynamic visuals with an if statement, indirect function, and Name Manager.

Create a dynamic sales analysis header from start to end date using the text function, and illustrate current vs. year-ago performance with conditional formatting and a donut chart.

Update a macro-enabled dashboard by appending July data to a table, expanding the dataset, and sorting dates for a seamless macro run via the form control.

Record and compare macros in absolute and relative mode in Excel, using Visual Basic Editor to capture actions, understand hard coded references, and store macros in the personal macro workbook.

Explore the range object in VBA, learn how to select and resize cells, loop through ranges with for each, and sum totals with offset and message box feedback.

Lock formulas using VBA by prompting a password with an input box, locking cells with formulas on the active sheet, and protecting the sheet for reuse via a personal workbook.

Record and edit VBA macros to extract unique salespeople with an advanced filter, then generate dynamic totals per salesperson using sumif, building a reusable summary report in Excel.

Record macros and write VBA to generate a monthly sales report using sumifs by salesman and month. Prepare data with advanced filter and dynamic ranges.

Learn to format an Excel report with color formats and borders, remove formulas by pasting values, and automate with a macro named format sales to create the report.

Extract unique brand names with an advanced filter, then use the GetPivotData function in a pivot table to compute shares, balances, and dynamic totals.

Link eight category shapes to sales data and update charts automatically when chips are clicked, using application color code to recolor shapes and pass the shape name to a macro.