$324 (USD)
SAVE $63

Add To Cart
excel-2019-series

Introduction to Microsoft Excel 2019/Office 365

1 Excel Basics
2 Creating a Worksheet
3 Time-Savers
4 Relative, Absolute, Mixed, and Circular References
5 3-Dimensional Workbooks
6 Sorting, Subtotaling, and Filtering
7 Charting Basics
8 Advanced Charting Techniques
9 Intro to Excel's Statistical Functions
10 Financial Functions
11 Worksheet Automation
12 Mastering Excel's IF Function

Intermediate Microsoft Excel 2019/Office 365

1 Excel Charts and Graphs
2 More Excel Charts
3 AutoFilter and Sorting
4 Goal Seeking
5 PivotTables
6 Advanced PivotTables
7 Solver
8 Sparklines
9 Macros
10 Introduction to Functions
11 Math/Trig Functions
12 VLOOKUP, INDEX, and MATCH Functions

Advanced Microsoft Excel 2019/Office 365

1 Customizing Excel
2 Table Management
3 Data Validation
4 Custom Controls
5 Conditional Formatting
6 Consolidating and Outlining
7 Excel Functions and Nesting
8 Import External Data
9 Data Tables
10 What-If Analysis Tools
11 Advanced PivotTables
12 Analysis ToolPak, Advanced Filter, Array Formulas, and More!

 
  Close Nav
  • Learn a new skill or enhance existing skills for professional development or personal enrichment.
  • New sessions starting monthly with lessons and assignments released weekly.
  • 2-4 hours a week in a convenient six-week format.
  • Interactive learning environment. Classroom built around discussion areas where you can engage with classmates and instructors.
  • Expert instructors develop, lead, and interact with students in each course.
  • Award of completion from your learning institution with passing score.
  • Gain the knowledge needed to move forward with your education.
  • Start anytime. Access Granted upon registration.
  • Courses are designed to be completed within 6-12 weeks.
  • Interactive multi-media instruction with integrated assessment, allowing you to work at your own pace.
  • Professional instructors support you throughout your learning experience.
  • Confirmation of successful course completion.
  • Build industry skills or earn continuing education credits in a variety of fields.
  • Start Anytime. Access to all course material and assessments from day one.
  • Many tutorials can be completed in just a few hours.
  • Quick independent study. Learn something new or expand your knowledge while working at your own pace.
  • Material developed by industry leaders and student support offered.
  • Certificate of completion awarded with passing score.

Forgot Password?