Excel (Level 1)

Learning Objectives

In this course, you will create, edit, display and print Excel workbooks using new features and custom interface tools. You will:

• Enter, edit, and format data to create workbooks

• Enter data using time-saving tools like Flash Fill and Autocomplete

• Use functions and formulas to calculate data

• Understand Relative and Absolute Cell References

• Format worksheets and cells

• Manage larger workbooks

• Print workbooks

• Customize the interface by changing ribbon display options and customizing the Quick Access Toolbar

Course Outline

Section 1: Creating, Opening and Saving Workbooks

• What Is Excel?

• Create a New Blank Workbook

• Open Excel Files

• Save Workbooks

• Navigate a Workbook

• Selection Types

• Data Checkers

• Help

Section 2: Exploring the User Interface

• Backstage View

• Ribbon Overview

• Quick Access Toolbar

• Status Bar

• Shortcut Key Tips

• Contextual Tabs

Section 3: Working with Data

• Basic Data Types

• Enter, Edit and Delete Data

• Use Autocomplete and Autofill

• Resize Columns and Rows

• Insert and Delete Columns, Rows, Cells

• Hide and Unhide Columns and Rows

• Use Undo, Redo and Repeat

• Spellcheck and AutoCorrect

• Use Find, Replace and Go To

• Cut, Copy, Paste and Paste Special

• Use the Fill Handle

Section 4: Performing Calculations

• Use Basic Formulas

• Use Basic Functions

• Understand Absolute and Relative Cell References

Section 5: Using Time Saving Tools

• Flash Fill

• AutoCalculate

Section 6: Formatting A Workbook

• Work with Fonts and Font Attributes

• Apply Borders and Shading

• Use the Format Painter

• Change Text Alignment

• Wrap Text

• Apply Manual Line Breaks

• Rotate Text

• Merge and Centre Text

• Create and Modify Styles

• Apply Number Formats

• Clear Formatting

Section 7: Managing Large Workbooks

• Rename Worksheets

• Colour-code Worksheet Tab Colours

• Copy, Move, Delete, and Group Worksheets

• Work with Freeze Panes

Section 8: Printing and Viewing A Workbook

• Work with Page Breaks

• Work with Print Preview and Page Layout View

• Change Margins and Page Orientation

• Scale to Fit Worksheets

• Insert Headers and Footers

• Print Titles Across All Pages

• Review Print Options