Course Title: Microsoft Excel Level 2 (Intermediate)

Current Status:

Not Enrolled

Price:

$250

Get Started:

Book Your Live Class

Price: $250

You are not yet enrolled in this course.

Course Description:

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.

  • 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

  • What are Range Names?
  • Apply Range Names using the Name Box
  • Editing Range Names
  • Using Range Names in Formulas
  • Function Categories
  • The Excel Function Reference
  • Function Syntax
  • Function Entry Dialog Boxes
  • Using Nested Functions
  • Automatic Workbook Calculations
  • The IF Function
  • The AND Function
  • The OR Function
  • The LOOKUP Function
  • The VLOOKUP and HLOOKUP Function
  • The XLOOKUP Function
  • The PMT Function
  • The FV Function
  • The TODAY Function
  • The NOW Function
  • Serialize dates and times with functions
  • The Trace Cells Feature
  • Show and Hide Formulas
  • Resolve Errors in Formulas
  • Using the Watch Window
  • What Are Tables?
  • Table Components
  • The Create Table Dialog Box
  • The Table Tools – Design Contextual Tab
  • Table Styles
  • Customize Row Display
  • Table Modification Options
  • The Difference Between Sorting and Filtering
  • Sorting Data
  • Filtering Data with Autofilters
  • Creating Advanced Filters
  • Filter Operators
  • Removing Duplicate Values
  • SUBTOTAL Functions
  • The Subtotal Dialog Box

 

Section 10.1: Inserting Charts 

  • Chart Types
  • Create Charts
  • Chart Insertion Methods
  • Resizing and Moving the Chart
  • Adding Additional Data
  • Switching Between Rows and Columns

Section 10.2: Modifying and Formatting Charts

  • 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
  • About Themes
  • Customize Themes
  • Types of Trendlines
  • Add a Trendline
  • Format a Trendline
  • What is a Sparkline?
  • Types of Sparklines
  • The Sparkline Tools – Design Tab
Enroll Now