Take a dive into advanced features of Excel’s navigation, functions, and custom formulas and become a power user!
Outlines
In this training you will:
Expand knowledge of notable functions in Excel.
Understand a wide variety of cell formatting to manipulate and interpret data.
Learn to create Pivot tables for data analyzation.
Understand options to restrict and protect data in Excel.
Utilize accessibility options in Excel using the Check Accessibility tool and how to add alternative text.
6 hours (1 day) or 3 hours (2 days)
Online or Onsite
English
Adults
Yes
Certificate
Awareness and accomplished attendance
Perquisites
–
Course Details
Course Outline:
Section 1: Working with Range Names What are Range
Section 2: Using Specialized Functions
Section 3: Analyzing Data with Logical and Lookup Functions
Section 4: Using Financial Functions
Section 5: Auditing Worksheets
Section 6: Organizing Worksheet Data with Tables What Are Tables?
Section 7: Sorting and Filtering Data
Section 8: Using Subtotal and Database Functions to Calculate Data
Section 9: Visualizing Data with Charts
Section 9.1: Inserting Charts
Section 9.2: Modifying and Formatting Charts
Section 9.3: Adding Trendlines