Course details

Participants on this course should have a good working knowledge of the basic features of Excel, gained from day-to-day usage or from prior attendance on an "Introduction/Intermediate Excel" course.

Number of Participants
Minimum 6 - maximum 10

Programme Methodology & Process:

  • Linking Worksheets / Workbooks
  • If Statements
  • Vlookup Tables
  • Using Databases
  • Subtotals
  • Database Forms
  • Creating Database
  • Functions
  • Creating Templates
  • Auditing
  • Data Consolidation
  • Goal Seek
  • Scenario Manager
  • Pivot Tables & Pivot Charts
  • Customising Toolbars and Menus
  • Recording Macros
  • Creating & Editing Charts
  • Review & Close

Assumed Knowledge

A working knowledge of Microsoft Excel basics, Windows and file management is assumed.

Updated on 08 November, 2015

Course Location

About Positive2Work Skillnet

The Positive2Work Skillnet is made up of small, medium & large companies from all sectors of the Irish Economy. The member companies of Positive2Work Skillnet have come together to explore how the intervention of effective strategies, supported by training solutions and people development, can positively impact on the quality of employees working lives and the competitive environment within which network member companies operate. The aim of the project is to create a Positive2Work environment for all employees within the member companies of the Skillnet.
To date the Skillnet has delivered training that support the areas of:
  • Building Resilience / Stress Management
  • Conflict Management / Building Constructive Relations
  • Change Management / People Management
While also working directly with member companies to deliver training that both incorporates the Positive2Work objective and meets their individual needs.
Positive2Work has approved funding until the end of 2013.
Positive2Work Skillnet provides subsidised training to member companies and offers free training for job-seekers. Members can also influence what courses are provided by the network.
See all Positive2Work Skillnet courses
Are you from Positive2Work Skillnet ? Claim your course!
Courses you can instantly connect with... Do an online course on Microsoft Office starting now. See all courses

Is this the right course for you?

Rate this page

Didn't find what you were looking for ?

or