Excel Training UK

Excel - Part 1

This course is intended for those who wish to gain a foundation and understanding of Excel that is necessary to create and work with electronic spreadsheets. Excel can help you organise, calculate, analyse, revise, update, and present your data.

Excel - Part 2

Designed for students who already have foundation knowledge and skills in Excel 2016 and who wish to begin taking advantage of some of the higher-level functionality in Excel to analyse and present data.

Excel - Part 3

This course is for students desiring to gain skills necessary to create macros, collaborate with others, audit and analyse data, incorporate multiple data sources, and import data.

VBA with Microsoft® Excel®

In this course, you will develop and deploy VBA modules to solve business problems. You will:

Programming and Data Wrangling with VBA and Excel

In this course, you will develop and deploy VBA modules to solve business problems. You will:

• Identify general components of VBA and their appropriate use in solving business solutions.
• Record VBA macros to automate repetitive tasks.
• Use reference tools built into Excel to get help on VBA programming language and objects used in the Excel VBA environment.
• Write VBA code to create a custom worksheet function.
• Eliminate, avoid, or handle errors in VBA code, and optimize its performance.
• Control how and when macros run.
• Develop UserForm objects to create custom dialog boxes and windows.
• Use VBA to read and write data from local files and cloud services.
• Use VBA to clean and transform data.
• Run programs and commands outside of Excel and share VBA projects with other users.

Excel for Office 365 - Data Analysis with PivotTables

In this course, you will use the advanced PivotTable functionality in Excel to analyze your raw data.

You will:

• Prepare data for PivotTable reporting and create PivotTables from various data sources.
• Analyze data by using PivotTables.
• Work with PivotCharts.

Data Analysis and Visualization with Microsoft Excel

In this course, you will analyze and visualize data using Microsoft Excel and associated tools. You will:

• Perform data analysis fundamentals.
• Visualize data with Excel.
• Analyze data with formulas and functions.
• Analyze data with PivotTables.
• Present visual insights with dashboards in Excel.
• Create geospatial visualization with Excel.
• Perform statistical analysis.
• Get and transform data.
• Model and analyze data with Power Pivot.
• Present insights with reports.