Microsoft Excel 2013 - Intermediate (Onsite Course)

This 1 day Excel training course provides delegates with a brief review of Excel basics and introduces them to more features, functions and data handling techniques within Excel 2013.  It is designed for those computer users who use spreadsheets on a regular day to day basis.

More details

More info

Pre-requisites

Excel Introduction

 

Course Objectives

This Excel course provides delegates with a brief review of Excel basics and introduces them to more features, functions and data handling techniques within Excel 2013.  It is designed for those computer users who use spreadsheets on a regular day to day basis.

These course objectives familiarise delegates with the topics to be covered and also provide a means for them to evaluate their learning.  Upon successful completion of this course delegates will be able to:-

  • Finding Your Way Around the Excel 2013 Interface
  • Use relative, mixed & absolute cell references
  • Manage & navigate worksheets in a workbook
  • Sort & filter information held in tables
  • Create & use custom cell formats
  • Use conditional formatting to highlight results
  • Use logical, mathematical, statistical, date/time & text functions
  • Use Named cell ranges in formulas
  • Customise charts & control chart options

Contents

Introduction

  • Backstage View & the Office 2013 Ribbon
  • Using Absolute & Relative Addresses
  • Managing Worksheets
  • Using Custom Cell Formats

Using Miscellaneous Tools

  • Using the Format Painter
  • Using Conditional Formatting
  • Add Data Bars, Colour Scales & Icon Sets to cells
  • Using Sparklines to add mini-charts
  • Hiding/Unhiding Rows & Columns
  • Clearing Cell Contents and Formats
  • Jumping to a Cell

Working with Excel Data Tables

  • Sorting Data
  • Multiple Level Sorting
  • Filtering Information
  • Format cells as Excel 2013 Tables
  • Finding and Replacing Data
  • Linking Worksheets & Workbooks

Working with Functions

  • Defining Names for Ranges
  • What are Functions?
  • Using Math and Trigonometric Functions
  • Using Statistical Functions
  • Using Logical Functions
  • Using Date and Time Functions
  • Using Text Functions

Charts & Graphs

  • Customising a Chart
  • Modifying Chart Options
  • Adding New Data
  • Changing Chart Type
  • Changing Chart Location
  • Adding Trendlines
  • Working with more than one Axis

Controlling the View

  • Freeze headings when scrolling a Worksheet
  • Using Comments

£ 895.00 ex.vat

Data sheet

Course Duration 1 Day
Location Various