Microsoft Excel Level 1 EXL-01

Module 1Getting Around in Excel

• Opening Excel
• Exploring the Excel Window
• Exploring the Excel Environment
• Using the Excel Tell Me Feature
• Opening and Viewing a Workbook
• Navigating a Workbook

Module 2Creating an Excel Workbook

• Closing a Workbook
• Starting a New Workbook
• Entering Data
• Saving and Naming a Workbook
• Using AutoFill

Module 3Editing a Worksheet

• Selecting Cells, Rows and Columns
• Editing and Deleting Data in Cells
• Using Undo and Redo
• Moving and Copying Data in Cells
• Adding and Deleting Rows and Columns
• Using Find and Replace
• Using Spellcheck and Smart Lookup

Module 4Calculating Data

• Using Basic Formulas
• Copying and Pasting Formulas
• Multiplying Cells
• Adding More than Two Cells
• Dividing Cells
• Calculating with Functions
• Using Absolute and Relative References

Module 5Formatting Cells

• Modifying Fonts
• Adding Borders and Colors to Cells
• Using the Format Painter
• Formatting Numbers
• Adjusting Cell Alignment
• Using Cell Styles
• Adjusting Row Height and Column Width

Module 6Creating Page Setup and Printing Options

• Setting Page Breaks
• Setting Page Orientation
• Setting Margins
• Inserting Headers and Footers
• Setting Printing Options
• Freezing and Unfreezing Panes
• Splitting a Worksheet

Module 7Working With Multiple Sheets

• Formatting Worksheet Tabs
• Inserting and Deleting Worksheets
• Moving and Copying Worksheets
• Hiding a Worksheet
• Arranging Worksheets