Excel Training - VBA​

Advanced users of Excel wishing to improve efficiency and productivity working with external data, large data sets, and to automate time-consuming Excel tasks without VBA coding knowledge.

Also suitable for advanced users who would like to understand how Excel Power tools can change the way they use Excel and bring their spreadsheets into the future, and data analysts who want to explore analysis tools from the Excel analysis Toolpak and who need to create projection models.

Prerequisites

Attendance or familiarity with of our Excel Advanced course. It is important that you know how to work with PivotTables.

Excel Training - VBA​

Advanced users of Excel wishing to improve efficiency and productivity working with external data, large data sets, and to automate time-consuming Excel tasks without VBA coding knowledge.

Also suitable for advanced users who would like to understand how Excel Power tools can change the way they use Excel and bring their spreadsheets into the future, and data analysts who want to explore analysis tools from the Excel analysis Toolpak and who need to create projection models.

Prerequisites

Attendance or familiarity with of our Excel Advanced course. It is important that you know how to work with PivotTables.

Benefits

  • Learn how to fully automate tasks without complicated VBA coding
  • Learn how to connect live to external data sources
  • Get an understanding of how reports and dashboards in Excel can update automatically
  • Get knowledge about how Excel can handle huge data sets very efficiently
  • Learn how to create data models working with relationships in Excel to avoid memory issues with lookup and reference functions
  • Learn how Power Query can structure, clean, append and merge data efficiently
  • Use Excel forms to improve data input, speed up data selection and navigation Discover new ways to analyse your data using the Analysis ToolPak Add-In
  • This course constitutes a good introduction to our data analysis courses UK data analysis courses UK.
Enroll the course

Benefits

  • Learn how to fully automate tasks without complicated VBA coding
  • Learn how to connect live to external data sources
  • Get an understanding of how reports and dashboards in Excel can update automatically
  • Get knowledge about how Excel can handle huge data sets very efficiently
  • Learn how to create data models working with relationships in Excel to avoid memory issues with lookup and reference functions
  • Learn how Power Query can structure, clean, append and merge data efficiently
  • Use Excel forms to improve data input, speed up data selection and navigation Discover new ways to analyse your data using the Analysis ToolPak Add-In
  • This course constitutes a good introduction to our data analysis courses UK data analysis courses UK.
Enroll the course

Our Popular Courses

View All