Learn the fundamental skills needed to effectively use Microsoft Excel 2016 through this comprehensive 10-hour course. Master the creation and management of worksheets and workbooks, understanding how to organize and structure your data efficiently. Develop proficiency in working with data cells and ranges, including data entry, formatting, and manipulation techniques. Explore table functionality to better organize and analyze your information with built-in sorting and filtering capabilities. Build expertise in creating and using formulas and functions to perform calculations and automate data processing tasks. Discover the power of Quick Analysis tools to rapidly generate insights from your data, and learn to create professional charts and incorporate various objects to enhance your spreadsheets' visual appeal and functionality.
Overview
Syllabus
- Create and manage worksheets and workbooks
- Data cells and ranges
- Tables
- Formulas and functions
- Quick analysis, charts, and objects
Taught by
ECA Online