Skip to content
Data Analytics Logo
  • Home
  • About Us
  • Course Portfolio
    • Microsoft Excel for Professionals
    • Microsoft Excel Advanced Master Class
    • Power BI
  • Blog
  • Photo Gallery
  • Register
  • Menu

Tag Archives: Loan Amortization Schedule

Dynamic Loan Amortization Schedule

Posted on December 15, 2019April 13, 2020 by Abiola David | No Comments

Welcome to Excel Jet Consult blog post. In this video tutorial, I demonstrated how to prepare dynamic loan amortization schedule. Do enjoy the short video

Continue reading→

Blog Posts

  • Part 2: Repeat All Products By Units Sold Frequency Distribution using Power Query
  • Repeat All Products By Units Sold Frequency Distribution using LET | INDEX MATCH & XLOOKUP Functions
  • Create Simple and Dynamic Charts in Excel
  • Count the Number of Names in Cells using TEXT Functions
  • Transform Data using Power Query Column From Examples
  • Combining the VSTACK & TAKE Functions
  • Advanced SQL Query in Power Query of Excel using ODBC.Query M Function
  • Top Botton Nth Products by Total using VSTACK LET SEQUENCE XLOOKUP and LARGE Functions
  • Combine Multiple Text File Data using Power Query
  • Retrieve Day From Date Values using Custom Formatting
  • Enabling Formula AutoComplete
  • Extract Top 5 Transactions By Units Sold
  • Extract Unique Values from Multiple Columns using VSTACK, HSTACK & UNIQUE Functions
  • Simultaneously Insert Blank Line after each rows and Sort Descending in Excel
  • Improved Recommended PivotTables in Excel

Copyright 2019 © Excel Jet Consult. All Rights Reserved

A SiteOrigin Theme