Microsoft Excel Level 2 Managing Data (Onsite & Online)

Summary

• Certificate of Completion - Free

• Tutor is available to students

Location & dates

Overview

Master popular Excel spreadsheet functions. Learn how to manage your data efficiently and present it effectively using Excel's visualization tools. ‘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

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:

• Find and replace a specific entry in a worksheet
• Create and apply a style
• Apply conditional formatting to a worksheet
• Use options in the Paste Special dialog box
• Use alignment options in the Format Cells dialog box
• Enter an absolute cell reference into a formula
• Use the IF, SUMIF and COUNTIF functions
• Use the PMT and FV functions
• Use the DATE and NOW functions
• Plot a chart
• Modify and enhance a chart
• Insert Sparklines
• Insert a new worksheet in a workbook
• Delete a worksheet from a workbook
• Enter a formula to link related worksheets in a workbook
• Format multiple worksheets in one operation
• Use the VLOOKUP and XLOOKUP functions
• Create a new workbook template
• Insert a diagram into a worksheet
• Insert a hyperlink into a worksheet
• Linking Excel to other applications

Who is this course for?

This course is for people who wish to become skilled at managing and presenting data in Microsoft Excel.

Requirements

Microsoft Excel Level 1 or introductory level skills.

Career path

Microsoft Office Specialist (MOS) Excel.