Data Skills specializes in providing comprehensive training services for Microsoft Excel, ranging from basic to advanced topics for expert analysts. We offer both face-to-face and virtual training courses to cater to your needs.
Introduction to Excel
This is the ideal course for beginners or those with limited Excel skills. If you need to know the absolute basics, this is the course for you. In this course, you will learn:
The layout of Excel
Navigating in a workbook
Using the toolbars in Excel
Formatting cells in Excel
Using shortcuts in Excel
Navigating, & selecting data quickly in Excel
Introduction to formulas
Introduction to functions
Autofill
Relative & absolute references
Sorting & filtering data
Using tables in Excel
Data Validation
Printing
Introduction to Excel
This is the ideal course for beginners or those with limited Excel skills. If you need to know the absolute basics, this is the course for you. In this course, you will learn:
The layout of Excel
Navigating in a workbook
Using the toolbars in Excel
Formatting cells in Excel
Using shortcuts in Excel
Navigating, & selecting data quickly in Excel
Introduction to formulas
Introduction to functions
Autofill
Relative & absolute references
Sorting & filtering data
Using tables in Excel
Data Validation
Printing
This is a 1-day course & can be delivered on-site or virtually.
Pricing for this course starts at £350 (day charge) and £35 (per delegate).
I really enjoyed the sessions. Although they are fast paced, the exercise afterward enables you to put into practice what you've learnt which helps the information to sink in. Just seeing Scott present data which I'm familiar with in a new way has helped me to think differently about how I summarise my data and present it to others.
Topcashback
Course: Excel Intermediate
I really enjoyed the sessions. Although they are fast paced, the exercise afterward enables you to put into practice what you've learnt which helps the information to sink in. Just seeing Scott present data which I'm familiar with in a new way has helped me to think differently about how I summarise my data and present it to others.
Topcashback
Course: Excel Intermediate
Advanced Excel
This course is designed to meet the requirements of people who use Excel regularly and are ready to learn more advanced skills.
Scott is really approachable, and very knowledgeable, especially all things Power BI & Excel. I personally found the course really useful, and although their is a lot of information to digest, Scott was more than happy to help, explain and take the time show the various processes needed to get you up, running and create some really great work.
Begbies Traynor Group
Carl Sims
Excel Power Query
Introduction to Excel Power Query
Importing data into Excel
Transforming data in Power Query
Merging and appending data
Filtering data
Handling errors
Scott is really approachable, and very knowledgeable, especially all things Power BI & Excel. I personally found the course really useful, and although their is a lot of information to digest, Scott was more than happy to help, explain and take the time show the various processes needed to get you up, running and create some really great work.
Begbies Traynor Group
Carl Sims
Excel Power Query
Introduction to Excel Power Query
Importing data into Excel
Transforming data in Power Query
Merging and appending data
Filtering data
Handling errors
This is a 1-day course & can be delivered on-site or virtually.
Pricing for this course starts at £390 (day charge) and £50 (per delegate).
This course is designed to help you automate repetitive tasks and create custom functions using Visual Basic for Applications (VBA). You will learn how to write macros that can accept user input, read and write data from cells, and manipulate data. Additionally, you will learn how to write custom functions and create user forms. This course is ideal for those who want to extend the functionality of Excel and work more efficiently. No prior programming knowledge is required.
Introduction to using macros
Using the macro recorder
Familiarising yourself with the visual basic editor
Running your first macro
Using buttons and menus to run macros
Object programming
The Object browser
Using variables
Using loops
Creating custom dialog boxes
Creating custom forms
Error handling and debugging
Macro security
This is a 1-day course & can be delivered on-site or virtually.
Pricing for this course starts at £390 (day charge) and £50 (per delegate).
This course is designed to help you automate repetitive tasks and create custom functions using Visual Basic for Applications (VBA). You will learn how to write macros that can accept user input, read and write data from cells, and manipulate data. Additionally, you will learn how to write custom functions and create user forms. This course is ideal for those who want to extend the functionality of Excel and work more efficiently. No prior programming knowledge is required.
Introduction to using macros
Using the macro recorder
Familiarising yourself with the visual basic editor
Running your first macro
Using buttons and menus to run macros
Object programming
The Object browser
Using variables
Using loops
Creating custom dialog boxes
Creating custom forms
Error handling and debugging
Macro security
This is a 1-day course & can be delivered on-site or virtually.
Pricing for this course starts at £390 (day charge) and £50 (per delegate).
