Microsoft Excel Courses in London and UK

We are an Official Microsoft Partner. All Seven Institute trainers are Microsoft Certified.

Choose your Excel Training Course

Introduction

By the end of this course you will know how to create spreadsheets, input data, understand how to print documents, how to perform simple calculations, you will learn basic formulas and functions, spreadsheet editing for a professional and presentable look. You will be introduced to using charts, copying, formatting and exploring the excel environment.

Intermediate

By the end of this course you will be comfortable using Excel functions and Excel formulas to calculate data over multiple worksheets and workbooks. You will learn to use Excel tables, in particular working with data (sorting, protecting, filtering, updating themes), data consolidation, conditional formatting, fixing formula errors, working with IF functions, how to view data in a variety of formats and printing complex documents.

Advanced

By the end of the Excel Advanced course you will learn to use What-if analysis tools, advanced spreadsheet analysis tools including PivotTables, PivotCharts, Look Up funtions, advanced list functions, nested functions, and Excel macros for spreadsheet automation. You will be able to make the most of your date using the Excel PowerPivot add in for advanced data analysis.

Advanced Excel Formulas and Functions

The course will take your already elevated excel skills to the next level. You will be exposed to a variety of excel functions including financial functions, logical functions, time and date functions, text functions, lookup functions, reference functions, math functions, and other advanced formulas to perform complex operations and solve common problems. The Advanced Excel formulas and functions course is highly practical and focuses on creating Nested functionality.

Advanced Excel Data Analysis and Management

By the end of the course you will know how to work with form controls and active x controls, be efficient working with advanced analysis tool, an introduction to excel PowerPivot and PowerView, solving advanced Excel tasks, you will also be introduced to VBA coding.

VBA-Introduction

You will learn Visual Basic Programming within the Excel application. By the end of the course you will be able to create and edit your own automated procedures. The course covers objects, variables, VBA editor Window, Developing with procedures and functions, procedure core structures, forms and controls, program execution, using pivot table object, debugging and handling errors.

VBA-Advanced

After attending VBA Advanced course you will know how to use arrays efficiently, understand and create class modules, know how to use ADO objects to import data from MS Access, Macro security application, distributing macros by saving as an Add-in, writing code that will allow you to interact with other Microsoft Office Applications such as Microsoft Word, writing and using code to interact with Microsoft Access Database an analysing this data in Excel.

Excel Course for Executive and Personal Assistants

This course is ideal for Executive Assistants, Personal Assistants, Administrative Assistants or anyone that is in a role which requires information to be organised, analysed, protected and professionally presented in Microsoft Excel. The course is specifically designed to combine all the necessary Excel knowledge that assistants are required to have in one place. This is a convenient way to acquire or refresh your Microsoft Excel skills.

Excel Charting

Learn main Excel Charting Concepts: such as chart elements and charting related elements on the ribbon. You will be able to display data as a chart and master an advanced degree of editing the charts: inserting objects, scaling, adjusting positions, working with legends, axes and gridlines, designing tab configuration, formatting, using templates efficiently, working with chart types, changing chart’s data source and more.

Excel PivotTables

By the end of this course you will know how to describe and create a PivotTable, how to efficiently work with PivotTable data, how to format PivotTables, apply a style as well as manually format a PivotTable, how to use a classic PivotTable layout. After this course you will also know how to work with advanced PivotTable tasks, use a calculation, a PowerPivot, Pivot Charts and how to use Macros with Pivot Tables.

Excel Introduction to PowerPivot

By the end of the Excel PowerPivot add in Training you will know how to connect to and import data from a variety of formats including notepad, CSV, copy/paste, Microsoft Access and other databases. You will learn how to manipulate data in the data model, how to manage relationships in PowerPivot including the ability to create PivotTables based on multiple tables. You will also be able to create a PowerPivot chart from a PowerPivot data model and be introduced to DAX formulas for PowerPivot.

Excel DAX for PowerPivot

After this course you will know what is DAX for PowerPivot and what it is used for, how to write DAX formulas, how to use calculated columns, operations and operator precedence, how to use DAX aggregate functions in PowerPivot, how to use DAX fundamental functions for PowerPivot. The course covers DAX date and time functions, DAX text functions, DAX math functions AND TRIG functions as well as many other powerful DAX functions.


On-Site Training Courses Include

Instructor Led Training Icon
  • Microsoft Certified Trainers
  • Coverage throughout the UK and International
  • Trainers Independently Reviewed
Course Manual Icon
  • Colour In-Course Workbook
  • Substation Step by Step Post Course Manual
  • Practice Exercise Files
Desktops Provided Icon
  • Computer Hire Available (PC Only)
  • Microsoft Program’s Pre-Loaded
  • All-In-One 21” Desktop Computers
Course Completion Certificate Icon
  • Seven Institute Completion Certificate
  • Bespoke Organisation Certificate Available
  • Microsoft Business Partner
Post Course Support Icon
  • Post Course Support Available
  • Email Questions 24-hour response
  • Phone Support Can Be Purchased in 15 Minutes Slots

Our Public Schedule or Closed Company Courses Include

Instructor Led Training Icon
  • Microsoft Certified Trainers
  • Coverage throughout the UK and International
  • Trainers Independently Reviewed
Training Facilities Icon
  • Standard and Executive Rooms Available
  • Comfortable Environments with Breakout
  • All Disabilities Catered for Upon Request
Course Manual Icon
  • Colour In-Course Workbook
  • Substation Step by Step Post Course Manual
  • Practice Exercise Files
Desktops Provided Icon
  • Computers Provided
  • Microsoft Program’s Pre-Loaded
  • All-In-One 21” Desktop Computers
Lunch Provided Icon
  • Complementary Lunch Provided
  • Coffee, Tea, Biscuits Provided Through the Day
  • All Dietary Requirements Catered for Upon Request

New Public Schedule Microsoft Excel Courses in Hertfordshire