Excel 2013 Intermediate

Course Overview

This course is for you if you want to build on the skills you have acquired after attending our Excel 2013 Foundation course or if you now have a need to use more complex formulae in you day-to-day work

Course Duration

Excel 2013 Intermediate is a 1 day course, starting at 9.00 to 17:00, with 1 hour for lunch.

Course Objectives

After the course, you will be able to:
  • Use Logical Functions, Financial and Statistical Functions
  • Nest Functions
  • Multiple Worksheet Management and Formulae
  • Create Charts
  • Protect Worksheets & Workbooks

Prerequisites

You will benefit most from Excel 2013 Intermediate if you have either attended our Excel 2013 Foundation course or if you are able to perform basic Excel actions and create formulae and functions.

Course Location

All our courses are available as public courses either Onsite or at our training facility here at Westpark Business Campus, Shannon.

Course Outline

Do you remember These?

  • Absolute references
  • Basic function creation methods
  • Formulae
  • Data entry and formatting
  • Date, Text, Number principles

Range Names

  • Concept and Purpose
  • Naming individual or range cells
  • Deleting and amending named ranges
  • Using named cells/ranges in formulae
  • Create Named Ranges and Cells
  • Manage Names (Setting Scope, Deleting, Renaming)
  • Navigate Named Ranges
  • Use names to Calculate
  • Use ranges in Functions
  • Paste Names
  • Filter Names

Formula Auditing Tools

  • Revealing Formulae
  • Tracing Precedents/Dependents
  • Goto Special
  • 3D Calculations
  • Linking sheets in the same file
  • Linking different Excel files
  • Using Edit, Links
  • Viewing different files at once
  • Saving a workspace
  • Viewing different sheets at once
  • Window Split
  • Data consolidation

Conditional Functions & Formats and Date Calculations

  • Work with Styles
  • Use If Statements, Nested If
  • Use And, Or, Not
  • Nesting If, And, Or, Not
  • Use the Sumif , Countif, Averageif
  • Use the Sumifs, Countifs, Averageifs
  • Use the Iserror, Iferror functions
  • Apply Conditional Formatting
  • Date Calculations
  • Calculate working days
  • Use the DAY(),MONTH(),YEAR() functions
  • Create and use Time calculations

Formulae Auditing

  • Use the Formula Auditing Tools
  • Reveal Formulae (in a cell)
  • Trace Precedents/Dependents
  • Setting a Watch
  • Goto Special

Worksheet Management & Linking

  • Link sheets in the same workbook
  • Link cells in different Excel files
  • Manage and edit Links
  • View different files at same time
  • Saving a workspace
  • View different sheets at same time
  • Data consolidation (within same file)
  • Data consolidation (across workbooks)

Data List Management

  • Create an Excel data list
  • Use the Excel List Tools
  • Use Autofilter
  • Sort the Data
  • Use the Advanced Filter
  • Add Subtotals to a list
  • Apply Data Validation to keep data clean
  • Group and Outline your data
  • Use the Data Form

Excel Charts / Graphs

  • Create a Chart with keyboard
  • Use the Chart Wizard
  • Edit and Format a chart
  • Change the Chart source Data
  • Apply Trendlines
  • Use Sparklines
  • Change Charts from objects to sheets
  • Add labels and axes to chart
  • Show specific Data Points
  • Save custom chart types
  • Change the default chart type
  • Using the Chart Wizard
  • Editing and Formatting charts
  • Saving custom chart types
  • Setting a default chart type

Click here to book a place on this course

Web Design and Search Engine Optimisation SEO by IDF Marketing
Robe De Mariée Bröllopsklänningar