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.
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.
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?
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.
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.
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..
Gain insights from your data
Position the dataOrganize your text or numeric data into spreadsheets and workbooks. Seeing it in context helps you make better decisions.
Rearrange and reformat itWhen 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 dataExcel 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.
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
Office 365 Excel
This is a version designed to work in a browser and is similar to Excel 2016.