Skip to content
Data Insight Consulting
Finance, Operations and Business Intelligence Solutions
  • Home
  • About
    • Contact
    • Special
  • Data Strategy
  • T-SQL
  • Excel VBA
  • Tableau
  • Power BI
  • Blog

Tag: Excel 2016

VBA to Automate Reporting from Multiple Files

Excel VBA to Consolidated Reporting with a Single Easy Click

2d Comments

Lots of staff, lots of work… lots of spreadsheets. This does not need to be a mess. Excel VBA to…

Continue Reading →

Posted in: Excel VBA Filed under: Data insight, Data Tactics, Excel 2016, Excel VBA, Process Automation
Excel VBA - Dynamically Creating Files

Watch Excel VBA create complex Excel files, reduce risk and improve quality

2d Comments

VBA can build tailored Apps As businesses evolve and develop, the need to track different information for clients, projects or…

Continue Reading →

Posted in: Excel VBA Filed under: Data Tactics, Excel 2016, Excel VBA, Process Automation, SME Businesses
Dynamic Dropdowns in Excel and VBA

Amaze your boss with dynamic cascading dropdowns in Excel

4d Comments

To improve the quality of data and reduce the likelihood of errors dropdowns in Excel can be a good choice.…

Continue Reading →

Posted in: Excel VBA Filed under: Data Tactics, Excel 2016, Excel Dropdowns, Excel VBA
Excel VBA to load CSV Files

Learn how to automate the loading and formatting of CSV files with clever Excel VBA

18d Comments

We’ve all seen countless .csv files.  They’re great… sometimes.  But many times the .csv file is not quite what is…

Continue Reading →

Posted in: Excel VBA Filed under: Automating CSV, Excel 2016, Excel VBA

Recent Posts

  • 3 Practical Tips using TSQL Windows Functions
  • A two-step Guide to making FP&A Awesome
  • Unlock T-SQL Merge Statements with this Worked Example

Recent Comments

  • Robyn on 3 Practical Tips using TSQL Windows Functions
  • Hasan on Turn boring survey results into powerful interactive visualizations with Tableau
  • Tim on Learn how to automate the loading and formatting of CSV files with clever Excel VBA

Join the Data Insights Newsletter

Copyright © 2025 Data Insight Consulting