Learn the fundamentals of creating and managing spreadsheets in Microsoft Excel. This course covers data entry, formula creation, formatting techniques, and printing procedures for professional workbooks.
Target Student:
This course is designed for individuals whose responsibilities involve creating, entering data into, and printing basic spreadsheets.
Prerequisites:
Basic Windows familiarity, keyboarding skills, and mouse proficiency.
Course Outline:
Getting Started with Excel
- Start Excel and open workbooks
- Understand the display screen layout and interface
- Work effectively with the ribbon toolbar
- Explore the file tab menu options
- Customize and use the quick access toolbar
- Monitor the status bar for worksheet information
- Switch between open workbooks efficiently
- Access and use Excel help resources
Entering Data
- Navigate the cell pointer through worksheets
- Select and work with ranges of cells
- Create new workbooks from scratch
- Insert, rename, and delete worksheets
- Enter constant values and data
- Use auto-fill to enter data patterns
- Save workbooks with appropriate naming
- Edit cell contents after entry
- Clear cell contents and formatting
- Use undo and redo functions
- Close workbooks properly
Working with Formulas
- Enter formulas into cells correctly
- Apply auto fill to copy formulas
- Use the SUM function for calculations
- Automatically sum columns or rows
- Apply statistical functions to data
- Use the range finder for formula review
- Check formulas for errors
Copying, Cutting, and Pasting Data
- Copy and paste constant values and formulas
- Cut and paste values and formulas
- Use special paste options
Formatting Worksheets
- Format numbers with appropriate styles
- Change fonts and font formatting
- Align cell contents horizontally and vertically
- Merge cells for visual organization
- Add borders to cells and ranges
- Apply predefined cell styles
Modifying Columns and Rows
- Adjust column width to fit content
- Modify row height for readability
- Insert and delete columns or rows
- Hide columns or rows from view
Editing Workbooks
- Customize AutoCorrect settings
- Check spelling throughout worksheets
- Use find and replace functions
Printing Worksheets
- Preview worksheets before printing
- Adjust print settings for different needs
- Use page setup tools for formatting
- Work in page layout view
- Create headers and footers
- Use page break preview
- Print worksheets and exit the application
