Skip to content (Press Enter)
  • Home
  • Services
  • Blog
  • Case Studies
  • About Me
Macrordinary

Macrordinary

  • Home
  • Services
  • Blog
  • Case Studies
  • About Me
Home>Blog>scripts

Category: scripts

Updated on September 21, 2020September 21, 2020/ Brent Allen

Ranges in Office Script – They are different than VBA!

Ranges in Office Script – They are different than VBA!

Most of the time that you are working in Excel, you will be working with ranges. And working with ranges in Office Script is very different than working with ranges in Visual Basic for Applications! Using a very simple macro, …

Read More
Updated on September 10, 2020September 9, 2020/ Brent Allen

Recording an Office Script in Excel Online

Recording an Office Script in Excel Online

The newest form of automation in Excel is Office Script; this uses the power of TypeScript and the web to automate spreadsheets! In this post, we’ll be recording an Office Script using the script recorder. This recorder provides an easy …

Read More
Updated on July 13, 2020July 13, 2020/ Brent Allen

VBA in 2020 – Where does it fit?

VBA in 2020 – Where does it fit?

Since 1993, Visual Basic for Applications has been the first choice for Excel automation. As a programming language that was available for business users, millions of macros have been created in VBA. But, is VBA still relevant in 2020? Popularity …

Read More
Updated on November 27, 2019October 20, 2019/ Brent Allen

Creating a Basic Loan Amortization Schedule Without Code

Creating a Basic Loan Amortization Schedule Without Code

An amortization schedule contains details with respect to a loan, including the following: The principal amount of the loan. The interest on the loan (typically reflected in annual terms). The length of the loan (typically reflected in years; except in …

Read More

Recent Posts

  • Unique Values from 2 Lists in Excel – Multiple Methods
  • LAMBDA() in Excel – Generating an Amortization Schedule
  • LET Function in Excel: A Name Parsing Example
  • Make a KPI Card like Power BI – In Excel!
  • Top N Results from Excel using Dynamic Arrays

Categories

  • dashboards
  • excel
  • financial formulas
  • formulas
  • M
  • office script
  • pivot tables
  • power apps
  • power bi
  • power pivot
  • power platform
  • power query
  • scripts
  • VBA
Copyright © 2022 Macrordinary. Software Company | Developed By Rara Theme. Powered by WordPress.