Course not currently available

Microsoft Excel Intermediate

Short course

In Harpenden ()

Price on request

Description

  • Type

    Short course

  • Duration

    1 Day

On completion of this course, attendees will be able to use logical functions, manage workbooks and use database features. Suitable for: This course is designed for those delegates who wish to build on their basic knowledge of Excel to enhance their calculations and perform data analysis as well as apply enhanced Chart formatting.

Important information

Documents

  • Excel Intermediate

About this course

Attendees should have attended our Excel Foundation course or have equivalent knowledge.

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Fill in your details to get a reply

We will only publish your name and question

Reviews

Course programme

Microsoft Excel Intermediate Course Outline
Review of Excel Essentials

  • Creating a spreadsheet
  • Writing formulae
  • Using the AutoSum function
  • Absolute and relative cell references

Advanced Formatting/Editing

  • Creating custom number and date formats
  • Applying conditional formatting

Naming Cells and Ranges

  • Defining named cell ranges
  • Editing and deleting named ranges
  • Using named ranges in formulae

Linking and Consolidating

  • Linking cells and formulae between sheets and workbooks
  • Consolidating multi-worksheet data

Further Functions

  • Using MAX, MIN, AVERAGE COUNT functions
  • Using SUMIF and COUNTIF
  • Calculating with dates
  • Introduction to using the IF function

Database Features

  • Setting out a database list
  • Sorting data
  • Using AutoFilter
  • Using advanced filter
  • Adding subtotals
  • Using database functions
  • Using find and replace

Charting and Drawing

  • Creating Charts using the Chart Wizard
  • Editing and formatting Charts
  • Adding trend lines
  • Inserting error bars

Microsoft Excel Intermediate

Price on request