MS Excel Level 3: Advanced

Wise

Short course

In Gatwick

£ 201-500

The best Excel courses

See all

See all

Description

  • Type

    Short course

  • Location

    Gatwick

  • Duration

    1 Day

Upon completion of this presentation, the participant should be able to use advanced formulas and functions to customise spreadsheets and create templates. Additionally, the delegate should be aware of security implications when sharing workbooks with other users.

Facilities

Location

Start date

Gatwick (London)
Regus Centre, First Point, Buckingham Gate, London Gatwick Airport, RH6 0NT

Start date

On request

About this course

Completion of our course MS Excel Level 2 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

Subjects

  • MS Excel

Course programme

Advanced Formulas & Functions

  • IF and related functions
  • Nested functions/formulas
  • Array formulas
  • Date arithmetic
  • Financial functions
  • Locating and interpreting errors

Analysing Data

  • Create a PivotTable
  • Create a PivotChart
  • Create Scenarios
  • Use Goal Seek

Macros

  • Record and run a macro
  • Relative vs. absolute recording
  • Edit a macro
  • Macro security

Customising Excel

  • Creating templates
  • Customising toolbars/menus
  • Create custom keyboard shortcuts
  • Create custom views

Protecting Workbooks/Worksheets

  • Lock cells
  • Hide formulas, rows, columns
  • Password protect worksheet/workbook
  • Share workbook options

Additional information

Comments: For more information: http://www.wiselimited.com/OFFEX3.htm

See related categories

MS Excel Level 3: Advanced

£ 201-500

The best Excel courses

See all

See all