course-premium

Excel level 2 (intermediate)

Act Training
5.0
1 review
  • I’ve learnt a lot and enjoyed the training. I would recommend this course to anybody that wants to be better at using excel and be more efficient dealing with tasks. After this course, you considerably reduce your errors thanks to the formulas you learned to use.
    ← | →

Course

In Coventry

Price on request

Improve your career prospects with this course!

  • Type

    Course

  • Location

    Coventry

  • Class hours

    7h

  • Start date

    Different dates available

Students will learn the skills and concepts necessary to create charts and to use the list-management capabilities of Excel.

Facilities

Location

Start date

Coventry (West Midlands)
See map
127-129 New Union Street, CV1 2NT

Start date

Different dates availableEnrolment now open

About this course

Excel Level 1 or equivalent knowledge.

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

5.0
  • I’ve learnt a lot and enjoyed the training. I would recommend this course to anybody that wants to be better at using excel and be more efficient dealing with tasks. After this course, you considerably reduce your errors thanks to the formulas you learned to use.
    ← | →
100%
4.7
excellent

Course rating

Recommended

Centre rating

Christina

5.0
16/02/2017
What I would highlight: I’ve learnt a lot and enjoyed the training. I would recommend this course to anybody that wants to be better at using excel and be more efficient dealing with tasks. After this course, you considerably reduce your errors thanks to the formulas you learned to use.
What could be improved: Nothing
Would you recommend this course?: Yes
*All reviews collected by Emagister & iAgora have been verified

Subjects

  • Excel
  • MS Excel
  • Worksheets
  • Formatting
  • Excel Sheet
  • Excel Formula
  • Microsoft Office
  • Styles
  • Themes
  • Tables

Course programme

Lesson 1: Managing workbooks and worksheets

  • Viewing large worksheets
  • Printing large worksheets
  • Working with multiple worksheets
  • Linking worksheets with 3D formulas
  • Using multiple workbooks
  • Linking workbooks

Lesson 2: Advanced formatting

  • Using special number formats
  • Using functions to format text
  • Working with styles
  • Working with themes
  • Other advanced formatting

Lesson 3: Outlining and subtotals

  • Outlining and consolidating data
  • Creating subtotals

Lesson 4: Cell and range names

  • Creating and using names
  • Managing names

Lesson 5:Tables

  • Sorting and filtering data
  • Advanced filtering
  • Working with tables

Lesson 6: Web and Internet features

  • Saving workbooks as Web pages
  • Using hyperlinks
  • Sharing workbooks

Lesson 7: Documenting and auditing

  • Auditing features
  • Comments in cells and workbooks
  • Protection
  • Workgroup collaboration

Lesson 8:Templates and settings

  • Application settings
  • Built-in templates
  • Creating and managing templates

See related categories

Excel level 2 (intermediate)

Price on request