Intermediate Excel

Tailored Training Solutions

Dates Available
BookingBook Online
Price Per Seat
£80

ENTRY REQUIREMENTS

No specific requirements.

WHAT ARE THE BENEFITS OF THIS COURSE?

Completion of this course will allow for improved efficiency, knowledge and skills when using Excel and its functions at an intermediate level.

WHO IS THE COURSE FOR?

The course is aimed at employees whose job role includes the regular use of Excel to complete sometimes complex work tasks.

WHAT WILL I LEARN?

The course will involve a wide variety of tasks within Excel including:

Financial Functions

  • FV.
  • PV.
  • NPV.
  • RATE.
  • PMT.

Lookup Functions

  • VLOOKUP.
  • HLOOKUP.

Database Functions

  • DSUM.
  • DMIN.
  • DMAX.
  • DCOUNT.
  • DAVERAGE.

Named Ranges

  • Naming Cell Ranges.
  • Removing a Named Range.
  • Named Cell Ranges and Functions.

Cell Formatting

  • Applying Styles to a Range.
  • Conditional Formatting

Selection Techniques

  • Selecting a Cell, cell range, row & column.

Manipulating Rows and Columns

  • Inserting Rows & Columns
  • Deleting Rows& Columns
  • Column Widths
  • Row Heights

HOW WILL I LEARN?

This one-day session will encompass learning through both theoretical and practical activity.

This course is delivered remotely via Microsoft Teams.

WHAT CAN THIS COURSE LEAD TO?

Completion of this course will lead to greater skills for using Excel and some of its more complex functions which can then lead onto the advanced Excel course.

Support Menu

Advice & Guidance

Contact

info@iwcollege.ac.uk
The Isle of Wight College
Medina Way
Newport
Isle of Wight
PO30 5TA
United Kingdom
The Isle of Wight College © 2020
Privacy PolicyTerms Of ServiceFeedback