MS Excel 2016 – Level 4 – Online Course
- Course focuses on Excel 2016 advanced skills and data manipulation.
- Learn to create macros, collaborate, analyze data, and edit the ribbon.
- Targeted at those needing advanced Excel data skills.
- Prerequisites include Excel 2016 Level 2 or 3 courses or equivalent knowledge.
- Course aims to enable better data manipulation and understanding of Excel 2016.
Overview
The Online Excel 2016 Training is a one-day virtual course focusing on advanced Excel skills. The course aims to enable participants to explore complex Excel 2016 components for better data manipulation. Targeted at individuals seeking advanced Excel data skills, the course covers creating and using macros, collaborating and analyzing data, creating form controls, and editing the ribbon. Prerequisites include Excel 2016 Level 2 and/or Level 3 knowledge. Topics include macro creation, data analysis, import/export functions, and editing the ribbon interface.
Who should attend
Data Analysts, Excel Users
Course Content
Online Excel 2016 Training
Course Duration: 1 day
Course
In this virtual, Instructor-Led course, you will learn how to create macros to automate your work, use the security features to protect your data, use analytic tools and consolidate data, import and export data, use the Power Views option, create form controls and edit the ribbon.
Course Aim
Enable delegates to examine the more complex components of Excel 2016 and better manipulation of data.
Target Student: This course is meant for those desiring to gain advanced skills necessary for working with Excel data.
Prerequisites:Before starting this course, students are recommended to take the Excel 2016 Level 2 and/or Excel 2016 Level 3 course or have equivalent knowledge.
Objectives
create and use Macros
• learn how to collaborate and analyse data
• create and use form controls
• editing the ribbon
Creating Macros
• Macro Security
• Creating a Macro
• Comparing Relative and Absolute Macros
• Running a Macro
• Editing a Macro
• Assigning Shortcuts to Macros
Collaborating With Others
•Security Features in Excel
• Protecting Data
• Protected Views
• Tracking Changes
• Workbook Merging
Analysing Data
•Creating a Single Input Data Table
• Creating a Two-Variable Data Table
• Creating Scenarios
• What If Analysis using Goal Seek
• Consolidating Data
Import and Export Data
• Exporting Excel Data
• Importing Delimited Text
• Importing a Web Query
New Useful Excel Functions
• FILTER
• SORT
• SORTBY
• UNIQUE
• SEQUENCE
• LET
• LAMBADA
Editing the Ribbon
•Editing the Tab wording
• Adding a new Tab
• Adding a new Group
• Adding buttons to a group
• Adding Macro buttons
Cost:£150 + Vat
