Event Information:
BUSINESS ANALYTICS AND REPORTING USING EXCEL

Microsoft Excel is a very powerful spreadsheet application designed to save you time and make easy work of calculating, displaying and sharing data. This Excel advanced training course will provide you with an understanding of the most advanced features of MS Excel.

It provides the participant with a strong foundation to build more sophisticated financial models to make effective business decisions.  The participant will also have the knowledge to build automated systems that drives performance dashboards in the organization. 
 
     
 

Program Outline:

Cell Addressing                   

  • Using Relative, Absolute & Mixed Cell References
  • Working with advanced tools: Advanced Excel ToolPak, Analysis ToolPak

Naming Cells and Ranges

  • Using the Create Method to Name Cells
  • Using the Names Box to Name Cells
  • Using Insert Name Define
  • Working with Named Ranges

Data Consolidation

  • Working with External Databases
  • Consolidating Data across Worksheets
  • Consolidating Data across Workbooks
  • Working with Pivot Table

Using Formulae & Functions

  • How to Enter a Formula
  • Working with Formulae
  • What are Functions
  • Working with Complex Formulas

Conditional Functions

  • Introduction to IF
  • Using Nested IF’s
  • Using SumIF and CountIF

Lookup Functions       

  • Using Vlookup
  • Using Hlookup    

Data Validation            

  • Using the Data Validation feature
  • Finding Invalid Data

Conditional Formatting

  • Setting Up Conditional Formats
  • Using Formulae in Conditional Formats

Working with Data Lists

  • Sorting
  • Subtotals
  • Filtering

Data Tables

  • Creating Data Tables
  • One Way and Two Way Tables

UserForms

  • Designing & Creating Forms
  • Working with Controls
  • Creating Custom Dialog Boxes  
 
     
 

Objectives

At the end of this programme, you will learn the following:

  • Working with more effective and efficient advanced formulae
  • Enhancing business management with logical functions
  • Application of logistics performance, costs, and value measures
  • Building effective manufacturing models & business performance dashboards
  • Acquiring external information
  • Quick graphing and illustration of data for board meetings
  • Applying worksheet security  
  
     
     
 

Trainer/Speaker Profile:

Mr Lim Thou Tin, MKM, MInfSys,BBA is a business graduate with the National University of Singapore. Heholds double masters in information systems and knowledge management with further
postgraduate qualifications in systems analysis, intelligent systems, marketing,management consulting and training.

He is also a fellow of the American Academy of
Financial Management and a certified ITIL/BS7799 lead auditor. He is currently in theprocess of completing his doctoral research in knowledge management with Southern Cross University.

Thou Tin ’s work experience includes working for   large local companies to MNCs in senior corporate,   IT and project management position, with a background in IT, banking and finance. He currently runs his own consulting practice involving in both general and IT consulting with local and multinational firms in Singapore.

He has served and continued serving in positions as corporate advisor, chief information officer and chief operating officer in local startup companies. His area  of involvement includes helping organizations to plan their corporate IT management strategies to managing decision support systems, corporate knowledge portal and E-Commerce architecture, development and implementation.

His consulting works also include working with both the financial and services industry   to help them to develop corporate, financial and knowledge models to address their decision making needs.
  
   
       
  Details:
Date :

30th June - 1st July 2008, (Monday - Tuesday)

   
Time : 9am - 5pm
   
Fee :

SMa Member S$ 480 / Non-SMa Member S$ 540
* Fees quoted are subjected to GST at the prevailing rate
   
Venue : SMa City Campus, 410 North Bridge Road, Singapore 188726     
*Subject to change
   
Seating Capacity : Max 20 pax
   
Closing Date of Registration : 18 June 2008

Contact Details:

Singapore Manufacturers’ Federation

Contact : Ms Perryn Khoo

Tel.: (65) 6826 3055

Email: perrynkhoo@smafederation.org.sg or enquiries@seminars.com.sg

Website: http://www.smafederation.org.sg

 
 
     

Be Our Partner!
List Events With Us!
Have a seminar or event to conduct but not sure where to announce it? We can help you in those area.

Just email us your request & contact details and our friendly consultant will assist you in no time!

 
 
Copyright © 2007 Seminars.com.sg. Powered by Cambridge Networks Pte Ltd