Using Excel Functions Effectively

Microsoft Excel offers a large variety of useful functions that can significantly improve work effectiveness, productivity and results. However many users can not take full advantage of Excel'sfunctions because they do not know what is available or they are not sure how to use them. This 6-hour course is designed to remedy this situation by introducing to you about 50 useful Excel functions with practical examples and hands-on practice.

Course Duration: 6 hours (1 day or 2 evenings)

Course Price: $960

You will Learn

  • Using Excel functions to process different types of data: numeric, text, date, time and Boolean
  • Summarizing data with advanced criteria
  • Using Lookup functions to link up data between data tables
  • Using IF statements effectively for decision-making, data validation and handling data in different ways based upon criteria
  • Performing statistical functions to consolidate and to forecast data
  • Using financial functions to process investment and accounting data
  • Handling formula errors

Course Schedule/Enrol

Course Title Duration Fee Outline/Schedules/Enrol
Using Excel 2013 Functions Effectively 6 hours $960 Outline Schedules/Enrol
Using Excel 2010/2007 Functions Effectively 6 hours $960 Outline Schedules/Enrol

© Welkin Systems Limited. All rights reserved.