Microsoft Excel Level 3 Analysing Data (Onsite & Online)

Summary

• Certificate of Completion - Free

• Tutor is available to students

Location & dates

Overview

Spot patterns and trends in 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.

Certificates

Certificate of Completion

Digital certificate - Included

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
• Import data into Excel
• Export 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.