Excel
10 Free Excel Budget Templates for Business Planning
Excel budget templates have been a cornerstone of business for decades. From a small business budget template to an annual...
Read moreExcel
Insights, tips, and best practices for modern FP&A
Excel
Running an SQL Query with Parameters, Part III
In the final article of this series, Excel expert Dany Hoter explains another way to import data into Excel from...
Read more
Excel
New Feature in Excel Supports Custom JavaScript Functions
This week, Microsoft announced that it was adding support for custom JavaScript functions in Excel. Read about what this means...
Read more
Excel
Running an SQL Query with Parameters, Part II
In part two of a series, Excel expert Dany Hoter explains another way to import data into Excel from an...
Read more
Excel
The Ultimate VLOOKUP Speed-Up Trick
Excel expert and solutions architect Dany Hoter reveals the secret to making the VLOOKUP function work faster and more efficiently.
Read more
Excel
Running an SQL Query with Parameters
In the first of a series of articles, Excel expert Dany Hoter explains different ways to import data into Excel...
Read more
Excel
How Does R1C1 Reference Style Improve Excel Performance?
Excel expert and Datarails solutions architect Dany Hoter discusses the little-known benefits of using R1C1 reference style in Excel.
Read more
Excel
Why Calculation Speed Matters
Excel expert and Datarails solutions architect Dany Hoter discusses what causes lengthy calculation time in Excel, and what you can...
Read more
Excel
3 Ways to Improve Excel Data Integrity
Maintaining accurate data in Excel can be challenging, but not impossible. Here are 3 ways for organizations to significantly improve...
Read more