Microsoft 365: Excel Desktop Level 2
- Course focuses on advanced Excel formulas, data analysis, charts, and conditional formatting.
- Aims to enhance Excel skills for data manipulation and analysis.
- Targeted at those needing advanced Excel skills for data calculation and visualization.
- Prerequisites include basic Excel knowledge or completion of Level 1 course.
- Objectives include using advanced formulas, organizing data, creating charts, and applying Conditional Formatting.
Overview
The Online Microsoft 365 Excel Training Course is designed to help participants enhance their Excel skills by using advanced formulas, analyzing data, creating charts, and applying tools like Conditional Formatting, Sorting, and Filtering. The course aims to enable delegates to manipulate data more effectively. Targeted at individuals seeking advanced data calculation skills, the course requires prior knowledge of basic formulas. Participants will learn to use advanced formulas, organize data, create and modify charts, sort and filter data, and apply Conditional Formatting.
Who should attend
Data Analysts, Financial Analysts
Course Content
Course
In this virtual, Instructor-Led course, you will use advanced formulas and work with various tools to analyse data in spreadsheets. You will also organize table data, present data as charts, along with applying Conditional Formatting, Sorting and Filtering.
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 calculating data using advanced functions and formulas, charting your data, use filter and sorting techniques, use conditional formatting to change the look of cells.
Prerequisites:Before starting this course, students are recommended to take the Excel Level 1 course or have equivalent knowledge. Delegates will be expected to be able to perform simple formulas prior to attending this course.
Objectives:
• use advanced formulas.
• organize worksheet and table data using various techniques.
• create and modify charts
• sort and filter data
• apply Conditional Formatting
Calculating with Advanced Formulas
• Use Excel’s Quick Analysis Tools
• Work with Range Names
• Calculating across Worksheets (3D)
• Using Logical Functions (IF, AND, OR)
• IFS and SWITCH
• Applying Lookup Functions
Charts
• Understanding Charts
• New Charts in
• Create a Chart
• Modify and Format a Chart
• Add and Remove Chart Data
• Add a Trendline to a Chart
• Analyse Data Using Sparklines
Organising Worksheet Data
• Apply Basic Sorting to a Data Range
• Advanced Sorting
• Summarise Data with Subtotals
Analysing Selected Data
• Applying Basic Filters
• Advanced Filters
Mastering Excel Tables
• Introducing Excel Tables
• Formatting a Table
• Creating Calculated Columns
• Using Slicers
• Converting Tables to Ranges
Apply Conditional Formatting
• Conditional Formatting
• Customising Conditional Formatting
• Sorting and Filtering by Conditional Formats
Duration:1 Day
Cost:£175 + Vat
