Course information

Study type Study Tier Start Date Duration Course Contact

Part Time

  • N/A
28 March 20191 weekJanet Stevens

Course Fee(s)

Fee BandsTuition FeeMaterials FeeExam Fee
Full Cost£80N/AN/A

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.

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.

Last updated 22 mins ago.

Find out about