Microsoft Excel Training Courses

Microsoft Excel Training Courses
  • Microsoft Excel 2016, 2013, 2010, 2007 for Windows
  • Microsoft Excel 2016, 2011, 2008 for Mac
  • Office 365: Excel
  • All levels of course: Introduction, Intermediate, Advanced, VBA and Macros
  • Standard course outlines and customisation
  • Power Pivot, Dashboards and Finance
  • VBA Development and Templates

Choose your course level.

Excel Introduction - 1 day

Our beginners' Microsoft Excel course. This one day course is ideal for users new to Excel and assumes no knowledge of Excel. You will learn how to use the Excel user interface, enter data, use formulas and functions, format your work to look attractive and print and save your worksheets.

Excel Intermediate - 1 day

This course will extend your Excel knowledge and skills. If you have been using Excel for some time it'll take your skills to the next level and streamline your work. This course shows you how to use advanced formulas, organize worksheet and table data, create advanced charts and graphics and analyze data using Pivot Tables, Slicers and PivotCharts. You will insert and modify graphic objects and customize and enhance workbooks. Why not find out what Excel can do for you?

Excel Advanced - 1 day

In our advanced Excel course we will show you how to use Excel's most powerful functions. You'll skills that let you: Enhance productivity by streamlining workflow, Collaborate with others, Audit worksheets and analyze data. In addition you'll: Work with multiple worksheets, Import and export data, Integrate Excel data with the web and Structure workbooks with XML.

Excel VBA - 2 days

On our 2 day Excel VBA course, you'll learn Applying Macros, Developing using Procedures and Functions, Using Objects, Controlling Program Flow, Utilising Variables and Expressions, Debugging the code, Handling Errors and Employing Forms and Controls.

Excel Dashboards - 1 day

This 1 day course will prepare you to create advanced workbooks and worksheets that you can use to produce dashboards. The ability to analyze large amounts of data, extract actionable intelligence from it, and present that information to decision makers is the key to operating a successful organization that is able to compete at a high level..

Excel PowerPivot - 1 day

Upon successful completion of this one day Microsoft Excel training course, you will be able to use Power Pivot to analyze data from a variety of sources.

Excel User

Gain insights from your data

Position the data

Organize your text or numeric data into spreadsheets and workbooks. Seeing it in context helps you make better decisions.

Rearrange and reformat it

When you look at different versions of the data, Excel learns and recognizes your patterns and auto-completes the rest of the data. No macros or formulas are required.

Analyze the data

Excel will carry out complex analyses for you. You can summarize your data with previews of pivot-table options in order to compare them and choose the most appropriate.

Microsoft Excel is a spreadsheet application program developed by Microsoft for Windows, Apple Mac, Android and iOS. It provides calculation, graphing tools, pivot tables and Visual Basic for Applications which is a macro programming language. It used extensively across all types of organizations and is the industry standard for spreadsheets. Excel is a key component of Microsoft Office, which also includes Access, Word, PowerPoint and Outlook.

Microsoft Excel has all the standard features spreadsheets and then some. It uses a grid of cells arranged in numbered rows and letter-named columns to display and store your data and to organize automatic calculations on that data, for example to sum a list of values to provide a total. It has a wide array of supplied functions to meet financial, statistical and engineering needs.

Numerical data can also be displayed as graphs, such as pie-charts, bar charts, line graphs and histograms. It has powerful tools that allow users to analyse data using sectioning with pivot tables and to examine dependencies on various factors with scenario manager.

The Visual Basic for Applications (VBA) programming language allows the development of automatic execution of calculations and user interactions can be hidden to produce fully developed applications for specific purposes such as decision support systems, stock analyzers and dashboards.

Excel can also retrieve data from external databases and then analyze that data and present the results in various ways such as pivot tables or graphs. Excel can be part of a business intelligence solution to help manage organizations.

Microsoft Excel Advanced Training Courses

History of Excel Versions

Excel 2003

Excel 2007

Excel 2010

Excel 2013

Excel 2016

Office 365 Excel

Microsoft Excel Training Related Links