Learn the fundamentals of Microsoft Excel.
You should be comfortable with the windows environment.
After completing this course, students will be able to:
• Open Microsoft Excel and identify the components of the Excel interface; identify spreadsheet areas and terminology; create and save a workbook; navigate worksheets; and enter and edit text and values.
• Create simple mathematical formulas; move and copy formulas using AutoFill and use Paste Link; view formulas in a spreadsheet; work with relative and absolute references; and use the SUM function, AutoSum, and other common functions to perform calculations in a worksheet.
• Modify a worksheet by inserting and deleting ranges, rows, and columns; find and replace text and data; check spelling and use the other research and proofing tools.
• Format text, cells, rows, and columns; apply colour and borders; format numbers; apply conditional formats; use the Format Painter; and create and use templates.
• Preview and print a worksheet; set page orientation and margins; create and format headers and footers; and print gridlines.
• Manage worksheets by inserting, renaming, deleting, moving and copying sheets; navigate Excel views and set workbook properties.
Anyone new to Microsoft Excel or those with limited experience.
Getting started
• Spreadsheet terminology
• The Excel environment
• Navigating a worksheet
• Using a template
Entering and editing data
• Entering and editing text and values
• Entering and editing formulas
• Saving and updating workbooks
Modifying a worksheet
• Moving and copying data
• Moving, copying, and viewing formulas
• Absolute and relative references
• Inserting and deleting ranges, rows, and columns
Functions
• Entering functions
• AutoSum
• Other common functions