MS Excel 2016 – Level 2 – Online Course
- Course focuses on advanced Excel functions, formulas, data analysis, and visualization.
- Delegates learn to manipulate complex Excel components effectively.
- Prerequisites include basic Excel knowledge or completion of Level 1 course.
- Students will use advanced formulas, organize data, create charts, and apply filters.
- Course covers topics like Conditional Formatting, Charts, Sorting, Filtering, and Tables.
Overview
The Online MS Excel Training is a one-day course focusing on advanced Excel 2016 features to manipulate and analyze data effectively. The course aims to enhance delegates' skills in using advanced functions, creating charts, sorting, filtering, and applying conditional formatting. Prerequisites include basic Excel knowledge or completion of Excel 2016 Level 1. Objectives include using advanced formulas, organizing data, creating charts, sorting and filtering, and applying conditional formatting techniques. The course covers topics such as working with range names, logical functions, charts, data analysis, Excel tables, and conditional formatting.
Who should attend
Data Analysts, Financial Analysts, Business Analysts
Course Content
Online MS Excel Training
Course Duration: 1 day
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 2016 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 2016 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 2016
• 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
Cost:£150 + Vat