Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

OpenLearning

Microsoft Excel 2016 Expert

via OpenLearning

Overview

Master advanced Excel 2016 functionality through this comprehensive 10-hour course covering workbook customization, data formatting, complex formulas, and sophisticated visualization techniques. Learn to configure workbook options and settings to optimize your workflow and collaboration capabilities. Develop skills in applying custom data formats and creating professional layouts that enhance data presentation and readability. Build expertise in constructing advanced formulas using complex functions, nested statements, and array formulas to perform sophisticated calculations and data analysis. Create dynamic and visually compelling charts that effectively communicate insights, and design advanced tables with enhanced formatting, filtering, and analytical capabilities to manage and present large datasets professionally.

Syllabus

  • Manage workbook options and settings
  • Apply custom data format and layouts
  • Create advanced formulas
  • Create advanced charts and tables

Taught by

ECA Online

Reviews

Start your review of Microsoft Excel 2016 Expert

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.