Excel Introduction

Days 1    Code EX131   Fee £195

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

Request a Call Back

WebExcel Introduction