In Addworth Solutions, people matter process matters
Call Us at: +60 3 7713 3239

Hands-on Excel 2007 – intermediate

The program is designed for Excel users have a working knowledge in Excel and who need to know the some advance features of Excel. The objective of this program is to equip participants with skills to customise the Excel environments for office automation. Hands-on exercises related to the areas of data management or budgeting will be used to reinforce concepts & features covered.

Why in Excel? Excel is a spreadsheet that can help the user collate a lot of data and analyse the results, and present them. It is widely available in all companies and the skill learnt is easily transferred to any other work situation.

In house training available. Contact us for a quote or register your interest with us for the next Excel workshop.

Addworth Solutions's Excel training workshop

 

Brief course outline  
  • Entering data & formatting worksheets
  • Using formulae
  • Linking  worksheets & updating formula
  • Condition formatting
  • Working with ranges
  • Formula : Logical functions
  • Sorting, filtering, totalling and grouping
  • Ensuring validity of data collected
  • Managing and analysing data using pivot tables

Read more about preparing a company budget

Follow Us On Twitter