Microsoft Excel Office 365 Advanced Training Course Outline

Audience: This course is aimed at experienced Excel users wishing to further their Excel skills. Majoring on Pivot Tables and recorded macros we explore many other of Excel’s great productivity features like auditing, protecting and linking workbooks and What-If analysis.

Course Duration: 1 day

Course Availability: Monday – Saturday

Course Types: Group bookings, public courses, 1-2-1 sessions, bespoke tailored courses and office migrations.

Course Location: This Microsoft Excel 365 Advanced Training Course can be delivered either at our London training venue or at your offices. 

Tailored Course Content: Course content can be customised to meet your specific requirements, with scheduled dates to suit you.

At Course Completion

After completing this course, students will be able to:

  • Audit a worksheet
  • Link worksheets and workbooks
  • Perform What if Analysis
  • Protect and Outline Excel documents
  • Collaborate with other Excel users
  • Import and Export Data
  • Filter and summarise worksheet data
  • Analyse worksheet data with Pivot Tables
  • Record macros

Course Outline

Module 1: Auditing a worksheet

  • Tracing precedents and dependents
  • Tracing errors in the worksheet
  • Error checking
  • Watch window

Module 2: Linking worksheets and workbooks

  • Setting up related worksheets within a workbook
  • Entering a formula to link related worksheets and workbooks
  • Creating a workspace
  • Consolidate worksheets and workbooks

Module 3: What if Analysis

  • Goal seek
  • 1 way and 2 way Data Tables
  • Scenario Manager

Module 4: Protection and Outlining

  • Protecting worksheets and workbooks
  • Grouping and outlining a worksheet

Module 5: Working with other Excel users

  • Create a shared workbook
  • Tracking changes in a shared workbook
  • Responding to proposed changes and comments in a shared workbook
  • Working with version History (new)

Module 6: Importing and Exporting Data

  • Importing data from a text or web based file
  • Working with other applications such as Access
  • Get and Transform (new)

Module 7: Filtering and summarising worksheet data

  • Use the Quick analysis tool
  • Autofilter and advanced filter
  • Adding a criteria range with advanced filter
  • Database functions
  • Using subtotals and nested subtotals
  • One click forecasting
  • 3D Maps (new)
  • Ink Equations (new)

Module 8: Pivot Tables

  • What is a Pivot Table?
  • Best practice on setting up Pivot Tables
  • Creating a Pivot Table
  • Resetting the summary function in a Pivot Table report
  • Grouping Pivot Table data
  • Search in the Pivot Table (new)
  • Formatting a Pivot Table
  • Charting a Pivot Table
  • Printing the Pivot Table
  • Normalising Pivot Table data sources
  • Convert Ranges to Tables
  • Using other Microsoft data sources with Pivot Tables
  • Using Slicers and TimeLines to filter Pivot Table data (new)
  • Power Pivot and Power View (new)

Module 9: Recording macros

  • Macro guidelines
  • Macro security settings
  • Recording and deleting macros
  • Running macros
  • Assign a macro to the QAT, ribbon or shortcut keys
  • Recording relative and absolute cell selection

Microsoft Excel Training Courses London

excel advanced

Microsoft Excel, this is the world’s most popular spreadsheet application. With over 750 million users worldwide, Excel is the tool of choice for presenting and analysing data. Having a good understanding of Excel is an essential key skill for any office worker today, it is the one application that the business world cannot live without.

Our Microsoft training courses take you on a journey from being a complete beginner through to an advanced user, able to make full use of the application’s capabilities and beyond.

Taught by highly efficient, expert Microsoft Certified trainers with many years of experience our hands-on courses mean that you will gain practical experience as well as useful tips and tricks. Full access to our extensive library of software help guides is included in the price.

Call us now for further information Tel:08001601666

If you know the basics of Excel, including entering data, formatting cells, using functions and formulae and inserting charts and graphs, this Advanced-Excel course will really unlock the power of the programme and its advanced functionality. Microsoft Excel is a very powerful spreadsheet application designed to save you time and make easy work of calculating, displaying and sharing data. This Advanced excel learning course will introduce you to some of Excel’s more powerful features. We also provide private and in-company Microsoft Excel courses.

 

Have you taken a look at Power Bi. PowerBI Desktop

Power BI is a business analytics service provided by Microsoft. It provides interactive visualizations with self-service business intelligence capabilities, where end users can create reports and dashboards by themselves, without having to depend on any information technology staff or database administrator

 

Microsoft announced April 2017 update for Power BI Mobile apps. This new update comes makes the app experience smoother and faster. Phone reports allow you to use Power BI Desktop to specifically tailor a portrait view of your existing report for mobile viewers. With this update, Microsoft has added support for different report background colors on mobile. If you define a background color in Power BI Desktop, the phone layout will maintain the same color. Power BI iOS app now supports right-to-left languages like Hebrew and Arabic.

Power BI iOS app now allows you to use the microphone button in your iOS device to ask questions about your data, in your own words. Tap the microphone button above your keypad to ask questions about your data, in your own words. And finally, Microsoft now allows developers to create Power BI custom visuals that are optimized for mobile consumption.

Download Power BI apps using the below links,

Training Courses

Mouse Training London LTD  is a certified Microsoft training Centre as well as a Microsoft testing station.

 

Syllabus can be delivered from our extensive range of Standard courses outlines as well as the official Microsoft Certified training course are designed for those people wishing to become Microsoft Accredited by sitting the office specialist exams.

 

We offer a range of flexible training courses, Microsoft Office, Microsoft Office 365, Adobe, Apple and Google Gsuite

 

Course Types

1-2-1, Group Training, Bespoke Training,, Public Courses, Office Migrations

 

Venues

Training courses can be delivered at your premises, Complimantry laptop hire phone for details or one of our training offices. Locations

 

Our Course Approach

Microsoft Accredited IT Training Provider
Microsoft Certified Training Materials
IT Training Courses delivered by Microsoft Accredited Facilitators
Microsoft MOS Test Centre London

 

Our courses are focused on ensuring that we make you a faster and more relaxed Office user. Given how widely Office is used in business today we believe that being a comfortable and capable Office user is a key career skill for everyone.

 

Regardless of the application you are using Access, Excel, Project or Visio just to name a few Office 365 or SharePoint we have you covered. Our friendly team of trainers will do their best to make you feel relaxed and confident with the application you choose to learn.

Our range of excel learning courses has been designed to support everyone from complete beginners with our Level 1 training courses, through to those who need to develop advanced Excel skills using Macros and VBA. We also offer a choice of intensive courses – courses that are slightly longer and faster paced than our standard courses, focusing on a specialist area.

All of our courses are available for private groups, either held at your workplace or at our training centre in , London. All courses include two years of free access to our IT helpline, staffed by our IT trainers to give you unlimited support after your course.

 

The Different Versions Of Excel


Excel is the spreadsheet function contained within the Microsoft Office suite of products. It is available within both Microsoft Office for Windows and also Office for Mac.

It has been used incredibly widely since it took over from Lotus 1-2-3 in the mid 90’s.

The recent most used versions of Excel are:

Excel 2003:

This was the last version of Excel before the ribbon system was introduced. It is becoming increasingly rare to see Excel 2003 these days.

This update to Excel (from Excel 2000) introduced new Tables functionality and also allowed information to be saved and modified using the XML data format. This made Excel 2003 far more useful as it made importing data from other sources far simpler.

Excel 2007:

This version of Excel introduced the ribbon. This was a major change to the appearance of Excel and many users struggled with the changes initially.

The other key change was making individual spreadsheets larger so that they could contain over a million rows (previously 65,536 rows) and up to 16,384 columns (previously 256). Other smaller changes were made to Table to make them more easily configurable.

Excel 2010:

Excel 2010 was a refinement of Excel 2007.

The changes while meaningful were far less radical than the changes between the 2003 and 2007 versions. The key improvement was to security given the increasing use of Excel to distribute malware and viruses. Excel 2010 allowed you to preview a document using “Protected View’.

Changes were also made to the ribbon functionality to increase its flexibility and to pivot tables to make them more user-friendly. The number of formulas included within the program was also increased substantially.

Excel 2013:

This version is again more of a refinement and expansion of 2010 than a wholesale change.

There are multiple small changes and improvements throughout the program. Examples of new functionality include Quick Analysis, which creates tables very quickly and simply, and PowerPivot, which is a substantial expansion of the old pivot table functionality. PowerPivot allows very large externally held datasets (often held in Access or SQL databases) to be analysed using Excel. In doing this it moves to being a Business Intelligence (‘BI’)