Excel 2007-2016-office 365 Intermediate

Taylor Mason Training

Course

Online

£ 949 VAT inc.

The best Excel courses

See all

See all

Description

  • Type

    Course

  • Level

    Intermediate

  • Methodology

    Online

  • Duration

    1 Day

  • Start date

    Different dates available

  • Online campus

    Yes

  • Delivery of study materials

    Yes

  • Support service

    Yes

  • Virtual classes

    Yes

Perfect for excel_logo-300x300users that have become reasonably proficient with the basic functions of excel, this Excel 2007-2010/2013 intermediate provides you with further knowledge of the application and enables you to use advanced formulas, manage database lists, create advanced charts and graphics and analyse data using Pivot Tables.

Facilities

Location

Start date

Online

Start date

Different dates availableEnrolment now open

About this course

This Excel 2007/2010/2013 intermediate course will teach the participants to:

Use multiple excel workbooks
Use advanced formatting
Outline and subtotal
Create and use names
Use filters and lists
Work with tables
Work with the web
Use advanced charting
Use group features such as auditing
Create and manage excel document templates

Questions & Answers

Add your question

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

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Subjects

  • Excel
  • Office IT
  • Ms Office
  • MS Excel
  • Multiple
  • Workbooks
  • Worksheets
  • Managing
  • Formatting
  • Advanced

Course programme

Course Outline

Microsoft Excel course content:

Using multiple excel worksheets and workbooks
  • Using multiple excel workbooks
  • Linking worksheets with 3-D formulas
  • Linking excel workbooks
  • Managing excel workbooks
Advanced formatting
  • Using special number formats
  • Using functions to format text
  • Working with styles
  • Working with themes
  • Other advanced formatting
Outlining and subtotals
  • Outlining and consolidating data
  • Creating subtotals
Cell and range names
  • Creating and using names
  • Managing names
Lists and tables
  • Examining lists
  • Sorting and filtering lists
  • Advanced filtering
  • Working with tables
Web and Internet features
  • Saving workbooks as Web pages
  • Using hyperlinks
  • Distributing workbooks
Advanced charting
  • Chart formatting options
  • Combination charts
  • Graphic elements
Documenting and auditing
  • Auditing features
  • Comments in excel cells and workbooks
  • Protection
  • Workgroup collaboration
Templates and settings
  • Application settings
  • Built-in templates
  • Creating and managing excel templates

See related categories

Excel 2007-2016-office 365 Intermediate

£ 949 VAT inc.

The best Excel courses

See all

See all