Excel
-
How pre-attentive processing, Gestalt theory, and visual data encoding inform data design decisions
9 min read -
5 practical use cases that prove Power Query is worth exploring.
8 min read -
Reporting in Excel Could Be Costing Your Business More Than You Think – Here’s How to Fix It…
Data ScienceDiscover how you can save hours, eliminate costly data errors, and free up your team…
7 min read -
Why single metrics in isolation fall short and how Weighted Composite Scoring can transform your…
7 min read -
Save precious hours by automating working with pivot tables and charts using VBA
10 min read -
Learning about arrays through simple examples
9 min read -
-
Three simple steps to track project updates in Excel and log them
8 min read -
Introducing an ExcelHelper class which allows you to encrypt Excel files with a strong password…
7 min read