How To
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 moreExcel
Insights, tips, and best practices for modern FP&A
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
How To
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
Excel
Excel Volatile Functions and Performance
Excel expert and solutions architect Dany Hoter discusses how to improve spreadsheet performance by avoiding volatile functions.
Read more
Excel
Improving Calculation Speed in Excel
Learn how to improve your Excel calculation speed with the help of Datarails Excel expert and solutions architect Dany Hoter.
Read more
Excel
Why Google Sheets Can’t Compete With Microsoft Excel
Microsoft Excel will likely continue to be the industry standard for a long time, particularly among enterprise companies. Here are...
Read more
Excel
5 Reasons Using Spreadsheets in Finance is Risky
Finance departments rely on data accuracy to perform critical process, and many organizations use Microsoft Excel spreadsheets despite the warnings...
Read more