Outcomes
Getting Started | • Navigate the Excel user interface • Use Excel commands • Create and save a basic workbook • Enter cell data |
Performing Calculations | • Create worksheet formulas • Insert functions • Reuse formulas |
Modifying a Worksheet | • Insert, delete, and adjust cells, columns, and rows • Search for and replace data • Use proofing and research tools • Work with macros |
Formatting a Worksheet | • Modify fonts • Add borders and colours to worksheets • Apply number formats • Align cell contents • Apply styles and themes • Apply basic conditional formatting • Create and use templates • Use formulas and functions to apply conditional formatting |
Printing Workbooks | • Preview and print a workbook • Define the page layout |
Managing Workbooks | • Determine potential outcomes using data tables • Manage worksheets • Manage workbook and worksheet views • Manage workbook properties • Appendix: Microsoft Excel common keyboard shortcuts |