• +44 01379 671280
  • training@computertrainingsuffolk.co.uk
Microsoft Certified profesional

Microsoft Excel Advanced Training Courses.

Excel Introduction

Excel Intermediate

Excel Advanced

Excel VBA

Our Excel Advanced Training Course

we offer a range of Microsoft Excel training courses in the uk at your office.in europe online We provide Word courses from beginner to advanced levels. Our Excel courses can be tailored to best suit your requirements and can be provided in a variety of delivery styles, including group bookings and 1-2-1, at your location or via video link

Microsoft Excel Advanced course outline.

COURSE OBJECTIVES

  • 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
Audience

Majoring on Pivot Tables and recorded macros Our Microsoft Excel Advanced training course is aimed at experienced Excel users wishing to further their Excel skills. 

Locations

Our Microsoft Excel Introduction course can be run at your offices  or any preferred location in the UK or Via video link online.

online training

Course Content
Auditing a worksheet
  • Tracing precedents and dependents
  • Tracing errors in the worksheet
  • Error checking
  • Watch window
Linking worksheets and workbooks
  • Setting up related worksheets in a workbook
  • Entering a formula to link related worksheets and workbooks
  • Creating a workspace
  • Consolidate worksheets and workbooks
What if Analysis
  • Goal seek
  • 1 way and 2 way Data Tables
  • Scenario Manager
Protection and Outlining
  • Protecting worksheets and workbooks
  • Grouping and outlining a worksheet
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
Importing and Exporting Data
  • Importing data from a text or web based file
  • Working with other applications such as Access
  • Get and Transform
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
  • Ink Equations
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
  • 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
  • Power Pivot
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

TRAINING SERVICES

Microsoft Office Specialist Courses ( MOS ) courses – Office 2010, 2013, 2016, 365 and 2019 As well as accredited courses we deliver over 200 standard courses covering Microsoft, Apple and Adobe Delivery Styles – Group bookings, 1-2-1, Public courses, Tailored and Office Migrations. Complimentary Training Materials for delegates – We have a dedicated site with a wide range of Microsoft manuals available, new titles are released regularly.

Microsoft Computer training

Accredited and Experienced Trainers

– All our trainers are Microsoft accredited and experienced. You will have peace of mind knowing that our trainers have been personally interviewed and assessed by us for their product knowledge, communication and delivery skill

 

 

On-site Courses – our courses can be delivered on-site at your business premises. we adhere to strict covid guidance Live

Online Courses – our training courses can be delivered on-line with a live tutor via Zoom, Microsoft Teams or Web-ex virtual classroom software. COVID-19: Whilst the

Need to up-skill, re-skill or simply develop your digital skills for the workplace or personal use? We have a huge range of courses to support you in your learning covering all Microsoft Office packages including Word, Outlook, Excel, PowerPoint and MS Project and also offering courses in social media, Apple Macs, computer maintenance and much more.

we are an independent team of training providers in suffolk that are dedicated to helping you to build successful and profitable businesses. Our professionals have a wealth of expertise and knowledge in this field and can be sure to cater to all of your specific needs, no matter how big or small your business may be. So you can have peace of mind knowing that you are in the most capable of hands. We are confident that you won’t find a service quite like ours, anywhere else. Our training providers in suffolk will be on hand to help with all of your requirements whether you are a small establishment or large commercial company.