Microsoft Power BI and Excel Business Modeling Combo Pack

Apply basic to advanced Excel skills to build management systems for accounting, employee, and inventory control, with data cleaning, filters, formatting, and synced employee database with form lookups and photos.

Master practical Excel data cleaning and reformatting tricks to standardize fields, fill blanks with not available, correct dates, autofill serials, and format tables for clean TSA employee data.

Calculate an employee's current age in years, months, and days using Excel's datedif and today functions, then format and concatenate results for clear display.

Learn to automatically insert and fit employee pictures into Excel cells in a one-click workflow using KuTools, with unmerged cells and size adjustments.

Learn to build an auto search box in excel using an ActiveX combo box, named range employees, linked cell, and macro-enabled workbook steps for autocomplete and dropdown.

Apply vlookup and match functions in Excel to automatically retrieve an employee's joining date by typing the name, using named ranges and dynamic column indexing.

Apply vlookup to all employee fields by fixing the lookup value to the employee name and dragging across cells, with match for column indexes in Excel.

Use index match to retrieve employee data and related pictures by naming ranges and creating a picture lookup defined name, replacing vlookup where needed.

Learn to use mail merge with Excel and Word to automate personalized salary notices and cheques, and format cells and currencies, including rupees, for bulk payroll and supplier payments.

Link an Excel cash book to a Word check template via mail merge, populate date, field name, amount in words, and amount in figures, and preview and print multiple checks.

Protect checks by automatically inserting symbols after the amount with Word’s edit field, using insert before equal to and insert after slash or dash.

Learn to toggle field codes in Word to apply comma style to currency values copied from Excel, using the merge field amount and hash format for thousands, lakhs, and millions.

Configure Gmail with Outlook 2016 to enable mail merge from Word using Excel data, sending personalized emails to hundreds of customers with a pending balance.

Configure Outlook with a Gmail account, link the Excel fields, and use finish and merge to send personalized payment reminder html emails to customers.

Master Excel-based database management by cleaning raw sales data, formatting dates, auto-fitting columns, and using Vlookup with a price table to compute sales amounts.

Apply VLOOKUP with approximate match to determine discounts from a slab table, naming the discount range, then compute discount amount, net sales, cost of goods sold (COGS), and profit.

Format the data as a table in Excel using Ctrl+T to auto select the range, ensuring no empty spaces, so headers enable filter and easy sorting.

Discover how pivot tables transform raw data into actionable insights, using rows, columns, and values to analyze region-wise sales, salespersons, and beverage items.

Insert multiple pivot tables on the same sheet, group date fields by months and years, and analyze region-wise sales with sum and count of transactions.

Explore pivot table techniques to analyze region wise sales contributions, convert figures to percentage of grand total, and add calculated fields and new columns to enhance dashboard reporting.

Create and format pivot tables and charts to build a static dashboard, visualizing monthly sales by region, regional contributions, and clear data insights.

Convert a static dashboard into a dynamic one by using a timeline and slicers to filter pivot charts and connect to pivot tables via report connections.

Power Pivot enables Excel to manage bulk data by building a data model from linked tables, using relationships to fetch prices and discounts quickly and compute sales amount.

Explore how Power Pivot enhances pivot tables by linking multiple sheets through a data model, establishing relationships and enabling cross-sheet analysis in a single pivot table.

Utilize Excel scenario manager to model budgeting and forecasting with multiple scenarios; save sets, compare results, and switch quickly using the quick access toolbar.

Discover how to collect bulk data from employees, customers, or students using Google Forms, design versatile surveys with radio, checkbox, and dropdown questions, and auto-compile responses into Excel sheets.

Change the theme color, header image, and logo to tailor Google Forms. Use templates, sections, and end messages to streamline data collection and present a professional survey.

Learn to craft a professional email for Google forms, create clickable links or image buttons, and send vendor registration forms while ensuring a polished, businesslike presentation.

Set up real time backup of desktop Excel files to the cloud with Google Drive for desktop, enabling seamless sync between desktop and online Google Sheets and Excel files.

Learn to manage monthly EMI payments for multiple loans by building an automated Excel schedule that reminds five days before due dates, handles intercompany transfers and post-dated cheques.

Learn to manage funds by splitting a loan into monthly installments in a detailed Excel schedule, setting date sequences per country requirements, and applying filters for 36 payments.

Learn to calculate days left on emi payments in Excel, using today(), subtraction, and if to show upcoming payments, filter out past due items, and set auto reminders.

Apply conditional formatting in Excel to highlight days left between 0 and 20 in red, and extend the rule to highlight entire rows for funds management.

Automate depreciation schedules in Excel using straight-line and reducing balance methods, applying formulas to extend years, link to useful life, and handle errors.

Apply and refine a depreciation calculation in Excel from scratch, using a yearly formula driven by useful life, handling blanks and errors, and fixing absolute references as you drag down.

Automate depreciation year-ends in Excel using a 364-day first year and EOMONTH for subsequent years. Learn to adapt dates automatically with IF logic.