Course objectives

Manage worksheets and workbooks

• Import data into workbooks from external sources.

• Navigate, format, and customize worksheets and workbooks.

• Manage workbook options, properties, and versions.

Manage data cells and ranges

• Insert, format, and organize data in cells and ranges.

• Summarize data using conditional formatting and filters.

• Validate and restrict data entry in cells.

Manage tables and table data

• Create and format tables to organize data.

• Sort and filter table data efficiently.

• Use structured references to calculate and analyze table data.

Perform operations with formulas and functions

• Use basic and advanced formulas to perform calculations.

• Apply functions like VLOOKUP, HLOOKUP, and IF to analyze data.

• Troubleshoot and audit formulas for accuracy.

Create charts and objects

• Create and format charts to visualize data trends.

• Insert and format objects like images, shapes, and SmartArt.

• Use sparklines and data bars to enhance data visualization.