The latest version of Microsoft Office is 2019/O365 but the earlier formats - 2016, 2013 are 2010 - are still very much to be found in offices and homes throughout the UK and abroad.  Microsoft, however, has now ceased to provide support for Office 2007, 2003 and Windows XP.  The table below displays the icons that represent the different applications available in Microsoft Office.  Click on an icon to see more details, such as course outlines and main features.

 

For the everyday user, each version provides all of the basics for that particular Office application but you will see the new releases add a little more functionality to its predecessor.  All course outlines can be download as a PDF file; simply click on the appropriate logo to open up a new window, read about the course and download the outlines.

Word with text.jpg
Excel with text.jpg
PowerPoint with text.jpg
Outlook with text.jpg
SharePoint with text.jpg
Visio with text.jpg
Publisher with text.jpg
OneNote with text.jpg
Access with text.jpg
Project with text.jpg

Microsoft Excel Data Analysis

Microsoft Excel training throughout the UK, including Manchester, Leeds, Birmingham, York, Carlisle, Newcastle, Sheffield, Glasgow, Edinburgh, Aberdeen, Derby, Norwich, Portsmouth, Swansea, Cardiff, Chester.  For overseas training and contracts, please call to discuss your requirements.

Microsoft Excel Data Analysis – Course Outline

 

About This Course

With Excel's Data Analysis features, you will work with the following topics: PowerBI, PowerPivot, PowerQuery, PivotChart, and DAX

Target Audience

Delegates who have good working knowledge with Microsoft Excel

Excel's Power Query

After completing this course, students will be able to:

  • Cover all aspects of PivotTables

  • Understand the advantages of Power Query

  • Linking to databases

  • Linking tables

  • Filter data

  • Create custom formulae

  • Combine multiple files

  • Create lookup files

Course duration: one day

Excel's PowerPivot - Working with DAX

After completing this course, students will be able to:

  • Understand the DAX formula tool

  • Understand DAX measures

  • Work with multiple data sets

  • Work with Time Intelligence

  • Use conditional functions

  • Work with X functions

  • Work with custom calendars

Course duration: one day

 

Word with text.jpg
Visio with text.jpg
Excel with text.jpg
Publisher with text.jpg
PowerPoint with text.jpg
OneNote with text.jpg
Outlook with text.jpg
Access with text.jpg
Project with text.jpg
M365.jfif