General
Power Query Beyond the UI
Excel expert Dany Hoter discusses whether it's worthwhile to use M language, which is the script language behind Power Query.
Read more
Articles by Dany Hoter
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
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
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 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
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