Skip to content

Microsoft Excel Level 3 Analysing Data - Onsite & Online
Media Tek Training Solutions

Maximize your data & gain valuable insights. Onsite training at your offices – convenient & cost-effective.

Summary

Price
£55 - £215 VAT exempt
Study method
Classroom
Duration
1 day · Part-time or full-time
Certification
Microsoft Office Specialist Excel Certification
Professional certification What's this?
Certificates
  • Certificate of Completion - Free
Additional info
  • Tutor is available to students

5 students enquired about this course

Add to basket or enquire

Location & dates

Sorry, we didn't recognise your location. Please try entering it again.
Showing classrooms near ''
Location
Address
33 King Street
Blackburn
Lancashire
BB22DH
United Kingdom
Address
Salts Mill Road Waterfront
Salts Mill Road, Shipley
Bradford
West Yorkshire
BD177TD
United Kingdom
Address
Empire Business Park
Liverpool Road
Burnley
Lancashire
BB126HH
United Kingdom
Address
12 Station Parade
Harrogate
North Yorkshire
HG11UE
United Kingdom
Address
1 Aire Street
LEEDS
West Yorkshire
LS14PR
United Kingdom
Address
82 King Street
Manchester
Lancashire
M24WQ
United Kingdom
Address
225 Denby Dale Road
Wakefield
West Yorkshire
WF27AJ
United Kingdom

Overview

Spot patterns and trends in Microsoft Excel spreadsheets. Analyse your data and gain an insight into Excel's powerful business intelligence features. Also covers Excel's security features. ‘Hands-on’ training. Gain confidence and develop skills that can be transferred immediately to the workplace.

Convenient and cost-effective training at your offices or online. The course is run by an experienced Data Analyst and Microsoft Master Instructor. Each participant will receive a manual and completion certificate.

"Egg used Media Tek Training Solutions recently to support with Excel training within the business. This training was very thorough but with a relaxed approach. Moulded the sessions around business requirement and allowed lots of time for questions and test data run throughs."

"My confidence using Excel has grown and I am thrilled I can produce a report at the click of a button. All our staff have benefited, you have a very calm and approachable manner. We highly recommend your services!"
Advanced Actuators Ltd

Certification

Microsoft Office Specialist Excel Certification

Awarded by Microsoft

Certificates

Course media

Description

This one day course has an emphasis on developing practical, real-world skills. It is suitable for people in any type of business.

Topics covered:

  • Restrict cell entries to specific numbers, dates or times
  • Restrict cell entries to specific entries in a list
  • Create a custom number format
  • Define a range name
  • Use a range name in a formula
  • INDEX and MATCH vs XLOOKUP
  • Use the DSUM and DAVERAGE functions
  • Trace precedents in a worksheet
  • Trace dependents in a worksheet
  • Trace errors in a worksheet
  • Watch and evaluate formulas in a worksheet
  • Consolidate data from multiple workbooks
  • Add subtotals to worksheet data
  • Group and outline data
  • Create a PivotTable report
  • Reset the summary function in a PivotTable report
  • Create a PivotChart report and Dashboard
  • Perform data analysis using scenarios
  • Excels Artificial Intelligence tools
  • Import data into Excel
  • Export Microsoft Excel data to other applications
  • Use the Data Consolidation feature
  • Protecting Excel files, workbooks and worksheets

Who is this course for?

This course is for people who wish to become skilled at analysing data in Microsoft Excel and are also interested in Excel’s business intelligence features.

Requirements

Microsoft Excel Level 2 or intermediate level skills.

Career path

Microsoft Office Specialist (MOS) Excel.

Questions and answers

Reviews

Currently there are no reviews for this course. Be the first to leave a review.

FAQs