Arise SLG

Data Training Institute

Microsoft Excel Level 2 (Intermediate)

Live & online$250
Microsoft Excel Level 2 (Intermediate)

About This Course

Build on your Excel knowledge with our Level 2 course, where you’ll dive into more complex functions, data manipulation, and chart creation. Ideal for users with basic Excel experience who want to enhance their skills for more efficient data management and analysis.

What You'll Learn

  • Master advanced Excel functions for more efficient data manipulation and analysis.
  • Develop skills in creating and customizing complex charts.
  • Enhance your ability to manage and analyze data effectively using Excel.

Course Content

13 sections · taught live, step by step

1

Section 1: Working with Range Names

  • What are Range Names?
  • Apply Range Names using the Name Box
  • Editing Range Names
  • Using Range Names in Formulas
2

Section 2: Using Specialized Functions

  • Function Categories
  • The Excel Function Reference
  • Function Syntax
  • Function Entry Dialog Boxes
  • Using Nested Functions
  • Automatic Workbook Calculations
3

Section 3: Analyzing Data with Logical and Lookup Functions

  • The IF Function
  • The AND Function
  • The OR Function
  • The LOOKUP Function
  • The VLOOKUP and HLOOKUP Function
  • The XLOOKUP Function
4

Section 4: Using Financial Functions

  • The PMT Function
  • The FV Function
5

Section 5: Use Date Functions

  • The TODAY Function
  • The NOW Function
  • Serialize dates and times with functions
6

Section 6: Auditing Worksheets

  • The Trace Cells Feature
  • Show and Hide Formulas
  • Resolve Errors in Formulas
  • Using the Watch Window
7

Section 7: Organizing Worksheet Data with Tables

  • What Are Tables?
  • Table Components
  • The Create Table Dialog Box
  • The Table Tools – Design Contextual Tab
  • Table Styles
  • Customize Row Display
  • Table Modification Options
8

Section 8: Sorting and Filtering Data

  • The Difference Between Sorting and Filtering
  • Sorting Data
  • Filtering Data with Autofilters
  • Creating Advanced Filters
  • Filter Operators
  • Removing Duplicate Values
9

Section 9: Using Subtotal and Database Functions to Calculate Data

  • SUBTOTAL Functions
  • The Subtotal Dialog Box
10

Section 10: Visualizing Data with Charts

  • Chart Types
  • Create Charts
  • Chart Insertion Methods
  • Resizing and Moving the Chart
  • Adding Additional Data
  • Switching Between Rows and Columns
  • Chart Elements
  • The Chart Tools Contextual Tabs
  • Format the Chart with a Style
  • Add a Legend to the Chart
  • Add Data Labels to Charts
  • Create Custom Chart Templates
11

Section 11: Managing Themes

  • About Themes
  • Customize Themes
12

Section 12: Adding Trendlines

  • Types of Trendlines
  • Add a Trendline
  • Format a Trendline
13

Section 13: Create Sparklines

  • What is a Sparkline?
  • Types of Sparklines
  • The Sparkline Tools – Design Tab

Not sure this course is the right fit?

Tell us your goals and we'll recommend the right learning path — or build a custom corporate training for your team.

Talk To Us