Excel Intermediate
+3

Excel Intermediate

00021
$225.00
In stock
1
Product Details

Upcoming Classes

5/16/2024 - 9:00am to 4:00pm

7/17/2024 - 9:00am to 4:00pm

WE OFFER FLEXIBLE SCHEDULING, SO PLEASE REQUEST AN ALTERNATE CLASS DATE OR TIMEFRAME IF NEEDED!

Course Description

Excel Intermediate will take you deeper into the powers of the software. Training topics include using cell names, utilizing some of the most common built-in calculating functions, data list management like sorting and filtering, calculating within a data list with Subtotal functions and Pivot Tables, creating charts, and more!

Prerequisite

Excel Basics or equivalent experience

Software Version

Microsoft (Office) 365, 2021, 2019, 2016

Course Highlights

  • Creating and using cell names
  • Built-in calculating Functions - Logical, Math/Trig, Statistical, Date, Text
  • Sorting and Filtering data lists
  • Database Functions
  • Outlining Data
  • Generating Subtotals
  • Format as Table feature
  • Advanced Conditional Formatting
  • Charting
  • PivotTables and PivotCharts
  • Graphics and SmartArt (appendix)
  • Array formulas (appendix)
Save this product for later
Share by: