Excel Training—choose your course level.

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.

Course Levels


Introduction

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.

Intermediate

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?

Advanced

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

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.

Dashboards
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.

Power Pivot
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.

Pivot Tables
Upon successful completion of this course, you will be able to use Excel’s advanced PivotTable functionality to analyze your raw data.

Classic Microsoft Excel PDF Outlines

History of Excel Versions


This was the last version of Excel that did not have the ribbon system. It is still in use but Excel 2003 has almost disappeared these days. Excel 2003 introduced new Tables functionality and also allowed data to be saved and modified using the XML data format. This increased compatability of Excel 2003 as importing data from other sources was simpler.
This was Included in Microsoft Office 2007. It was a major upgrade from the previous version. Similar to other updated Office products, Excel in 2007 introduced the new Ribbon menu system. This was different from what users were used to, and was met with mixed reactions. The Ribbon has helped less experienced users get to grips with Excel.
Excel 2010 was a refining of Excel 2007. The changes were far less contentious than the changes between the 2003 and 2007 versions. Improvements included:
In-cell charts called sparklines
New Conditional Formatting Features in Excel 2010
Making your own ribbon in Excel 2010
Office 2010 backstage feature for document-related tasks
Many new formulas, most highly specialized to improve accuracy
Improved pivot tables
Once more this is a refinement and extension of 2010 rather than a complete change. There are many small changes and advances throughout the program. For example:

Excel’s new Start Screen helps you get to work more quickly
Enjoy a new Backstage View which is accessible from the File menu
Make Flash Fill magic – Its predictive data entry can detect patterns and extract and enter data that follows a recognizable pattern.
Simplify choices with Recommended Charts
Quickly analyze your data using the Quick Analysis tool
Answer questions instantly with Recommended Pivot Tables
Make quick reports with Power View
Share files and work with other people
Share work to your social networks

Included in Office 2016, along with a lot of new tools included in this release:

Major database enhancements with Power Pivot and Power Query
Read-only mode for Excel
Keyboard access for Pivot Tables and Slicers in Excel
New Chart Types such as Pareto and Waterfall
Excel forecasting functions
Support for multi-selection of Slicer items using touch
Time grouping and Pivot Chart Drill Down
Excel data cards

Microsoft Excel Training Related Links

Microsoft Excel Support
Wikipedia Microsoft Excel