Microsoft Excel 2013 Level 1

Excel 2013 Level 1

Course Aims:

This Microsoft Excel 2013 Level 1 course is aimed at people who want to learn how to use Microsoft Excel to carry out basic spreadsheet tasks including the creation of simple formulas and functions. The course is suitable for either beginners or people with limited experience of the product.

Course Pre-requisites:

No previous knowledge of Excel is required. Students must have experience, however, of using the Windows environment to launch programs and access files.

Course Objectives:

On completion of this course delegates will be able to:

  • Understand the concepts of Excel spreadsheets
  • Create, edit and format a worksheet
  • Use formulas for basic calculations
  • Copy and move data
  • Insert columns and rows
  • Format numbers, text and dates
  • Format cells
  • Preview and print worksheets
  • Use Page Setup to edit page margins, headers and footers
  • Apply automatic formatting

 

Course Content:

Introduction and Objectives

 Exploring Excel 2013

  • Launching & exiting Excel
  • Selecting a template
  • Working with Excel windows, worksheets & Ribbon commands
  • Excel 2013 ‘ Backstage’
  • The Quick Access Toolbar (QAT)

 

Basic Workbook Skills

  • Selecting cells, entering & editing data
  • Using data entry shortcuts (AutoComplete, Pick from List)
  • The ‘Mini Toolbar’ and ‘Shortcut Menus’
  • Saving and closing a new workbook
  • Version compatibility issues
  • Creating a new workbook
  • Opening an existing workbook
  • Renaming an existing workbook

 

Working with Ranges

  • Selecting adjacent & non-adjacent ranges
  • Entering values into a range (text, numbers, dates)
  • Using the AutoFill feature

 

Previewing Worksheets

  • Using Print Preview, Page Layout View
  • Viewing & hiding gridlines, headings and the Formula Bar
  • Adding & removing page breaks

 

Printing

  • Printing multiple copies
  • Printing pages or a selection

 

Using Page Setup

  • Page orientation
  • Scaling a worksheet
  • Editing margins
  • Centring on page
  • Headers & footers
  • Repeating row & columns labels
  • Setting & removing a print area
  • Using Page Break Preview to adjust pages and layout

 

Formatting Numbers & Text

  • Applying number styles & controlling decimal places
  • Character formatting

 

Copying & Moving Data

  • Copying/cutting & pasting data
  • Using Paste Options
  • Using the Paste List
  • Using the Clipboard
  • Drag & Drop editing
  • Using Undo & Redo

 

Working with Columns & Rows

  • Inserting, deleting & adjusting
  • Hiding & unhiding rows & columns

 

Creating Simple Formulas

  • Entering and editing simple mathematical formulas
  • Using range borders to modify formulas
  • Order of calculation
  • Relative references versus absolute references
  • Entering basic, built-in Excel functions
  • The AutoSum command
  • The Function Library
  • Using the AutoCalculate feature

  

Formatting Cells

  • Changing cell alignment
  • Merging cells & changing text indent
  • Rotating, wrapping & shrinking text in a cell
  • Creating cell borders
  • Using fills
  • Using the Format Painter
  • Inserting & deleting cells
  • Clearing formatting

 

Using Automatic Formatting

  • Cell styles
  • Themes

 

Sharing Data

  • Connecting and saving to SkyDrive
  • Sending a workbook as an email attachment
  • Creating PDF/XPS files

 

Appendix (if time)

  • Creating a simple chart
  • Moving and sizing a chart
  • Editing chart data
  • Changing chart type
  • Selecting a ‘Recommended Chart’

 

Action planning

Review of Programme

 

Related Courses

Access 2013 Foundation

Project 2013 Level 1

Finance for Non-Financial Managers

Presenting with Impact

Excel 2013 Level 2

Dates available on arrangement

WWP Training Limited can also create this course for you on arrangement either at your workplace or at one of their locations.

Book Now Make Enquiry

Write A Review Of Microsoft Excel 2013 Level 1

Face-to-face
£240.00
Book Now Make Enquiry Add To Wishlist
All prices include VAT where applicable