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.
Overview
Syllabus
- Manage workbook options and settings
- Apply custom data format and layouts
- Create advanced formulas
- Create advanced charts and tables
Taught by
ECA Online