Course Content
Creating and Manipulating Data
• Insert data by using AutoFill.
• Ensure data integrity.
• Modify cell contents and formats.
• Change worksheet views.
• Manage worksheets.Formatting Data and Content
• Format worksheets.
• Insert and modify rows and columns.
• Format cells and cell content.
• Format data as a table.
Creating and Modifying Formulas
• Reference data in formulas.
• Summarize data by using a formula.
• Summarize data by using subtotals.
• Conditionally summarize data by using a formula.
• Look up data by using a formula.
• Use conditional logic in a formula.
• Format or modify text by using formulas.
• Display and print formulas.
Presenting Data Visually
• Create and format charts.
• Modify charts.
• Apply conditional formatting.
• Insert and modify illustrations.
• Outline data.
• Sort and filter data.
Collaborating on and Securing Data
• Manage changes to workbooks.
• Protect and share workbooks.
• Prepare workbooks for distribution.
• Save workbooks.
• Set print options for printing data, worksheets, and workbooks.