Microsoft 365: Excel Desktop Level 4
- Learn to create macros, protect data, analyze and consolidate data in Excel.
- Course aims to enhance Excel skills for data manipulation.
- Target students are those seeking advanced Excel skills.
- Course covers creating and using macros, collaborating, analyzing data.
- Import and export data, use new functions, and edit the ribbon.
Overview
The Online Microsoft 365 Excel Training Course is designed to help participants gain advanced skills in Excel data manipulation. The course covers creating and using macros, collaborating and analyzing data, using form controls, and editing the ribbon. Participants will learn how to automate work, protect data, import and export data, and utilize new Excel functions. The course aims to enable delegates to handle complex Excel components effectively. Prior knowledge of Excel Level 2 and/or Level 3 is recommended.
Who should attend
Data Analysts, Excel Users
Course Content
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, use the security features, import and export data, use some useful new functions, and edit the ribbon.
Course Aim
Enable delegates to examine the more complex components of Excel 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 Level 2 and/or Excel 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
Duration: 1 Day
Cost:£175 + Vat
