Excel Introduction
Days 1 Code EX131
This course introduces the skills necessary for productive development of workbooks.
Course Details
This course introduces the skills necessary for productive development of workbooks. It includes tasks to explore Excel, create simple formulas, copy and move data, and print worksheets. The student will also learn how to work with ranges and use basic workbook skills and page set up. Also included are some of the new features that appear in Excel 2013.
Prerequisites
Before attending this course, students must have:
-
Knowledge and experience in using a Windows environment
Examination
- There is currently no examination associated with this course
Course Outline
Lesson 1: Exploring Excel
- Using the Ribbon
- Working with Worksheets
- Backstage View
- Hiding the Ribbon
- Using the Mini Toolbar
- Customising the QAT
Lesson 2: Using Basic Workbook Skills
- Opening,Closing and Saving
- Coompatibility Mode
- Selecting a Cell
- Scrolling
- Entering Text and Numbers
- Data Entry Shortcuts
Lesson 3: Working with Ranges
- Using Ranges
- Selecting Ranges and Non-adjacent Ranges
- Using Autofill Features
Lesson 4: Creating Simple Formulas
- Entering Formulas
- Using Functions
- AutoSum
- Checking Errors
Lesson 5: Copying and Moving Data
- Copying/Cutting and Pasting
- Using the Clipboard
- Creating an Absolute Reference
- Flash Fill Feature
Lesson 6: Printing
- Previewing A Worksheet
- Printing a Range
Lesson 7: Using Page Set up
- Setting Margins
- Creating Headers and Footers
- Using Built in Haaders and Footers
- Repeating Row and Column Labels
- Scaling and Page Breaks
Lesson 8: Formatting Numbers
- Using Number Formats
Lesson 9: Formatting Text
- Formatting Cell Text
- Wrapping Text
- Aligning Text
Lesson 10: Working with Columns and Rows
- Changing Width and Height
- Adjusting Automatically
- Inserting and Deleting Rows and Columns
- Hiding Rows and Columns
Lesson 11: Formatting Cells
- Merging and Splitting Cells
- Formatting Borders and Colours
- Clearing Formats
- Using the Format Painter
Lesson 12: Using Automatic Formatting and Styles
- Using the Auotmatic Formatting Features
- Extending List Formats and Formulas
- Applying a Pre-defined Style
Lesson 13: Using Large Worksheets
- Increasing Magnification
- Splitting the Window
- Freezing Panes