Summary
Excel 365 Part 102 – Excel Essentials
This half-day training is designed to enhance your Excel skills by covering key topics essential for productivity. You’ll learn how to create and manage worksheets effectively, with modules on data entry, formulas, functions, and reference types. We will explore advanced data manipulation techniques such as shortcuts for data entry, paste options, and managing cells. The final section focuses on creating impactful charts, understanding various chart types, and customizing chart elements to visualize data clearly. Whether you’re a beginner or looking to refresh your skills, this session offers practical tools to boost your efficiency in Excel.
Outline
-
Creating worksheets
- Module A: Entering data
- Module B: Formulas
- Module C: Functions
- Module D: Moving and copying data
- Module E: Reference types
-
Manipulating data
- Module A: Data entry shortcuts
- Module B: Paste options
- Module C: Inserting, deleting, and hiding
-
Charts
- Module A: Creating charts
- Module B: Chart types and elements