1 Day Microsoft Excel 365 Course – Intermediate
1 Day Microsoft Excel 365 Intermediate Course" is tailored for learners who want to build upon their foundational Excel skills and dive into more advanced features:
Course Outline:
Manage Data Cells and Ranges
Lesson 1 – Manipulate Data in Worksheets
Use Special Paste Options
Use AutoFill to Fill Cells
Insert and Delete Rows and Columns
Insert and Delete Cells
Lesson 2 – Format Cells and Ranges
Merge and Unmerge Cells
Alignment, Orientation, and Indentation
Use the Format Painter
Wrap Text Within Cells
Apply Number Formats
Apply Cell Formats
Apply Cell Styles
Clear Cell Formatting
Lesson 3 – Define and Reference Named Ranges; Summarize Data Visually
Define a Named Range
Name a Table
Insert Sparklines
Apply Built-In Conditional Formatting
Remove Conditional Formatting
Post Assessment and Feedback
Manage Tables and Table Data
Lesson 1 – Create and Format Tables
Create Excel Tables
Apply Table Styles
Convert Tables to Cell Ranges
Additional Details
Administrator - Wanza, Mrs. Mandy
Sub Category -
Audience - It’s ideal for people comfortable with basic Excel operations and ready to tackle more advanced features, such as PivotTables, intermediate formulas, or enhanced data visualization tools.
Objectives - These objectives aim to prepare learners to tackle more advanced tasks and use Excel as a powerful tool in both professional and personal contexts.
Success Criteria -
Duration -
Course ID - 333569
Event ID - 1227864
Composite ID - 3335691227864
Total Cost - 1250
Total Duration - 1 Day(s)
Course Owner - Wanza, Mrs. Mandy
Course Owner Email - mandyw@sun.ac.za
Course Owner Phone - 0218084525