Hidden Secrets of Data Analysis In Excel
Details
Managers and Executives who have to manage, analyse and prepare reports using data downloaded from systems. They must have some basic to intermediate knowledge of Excel i.e. navigate around a worksheet, format cells, auto-filter, sorting, create a simple template and enter simple formulas (e.g. SUM) into the worksheet.
Learning ObjectivesUpon completion of the course, participants will be able to:
- Apply useful built-in functions in Excel to process data and enhance the usefulness of the data.
- Apply the function learnt to consolidate records.
- Acquire skills to analyse the records for operations and reporting purposes.
- Employ new ways of tabulating and managing data.
Course Outline
- Manage The Use of Dates
»MONTH, YEAR, DAY, DATE, COUNTIF, SUBTOTAL, DATEDIF formula, Advanced Auto-Filter Function, Absolute and relative reference - Quick and Accurate Way to Select Records
»GOTO function - Building Complex formulas
»MID, SEARCH - Merging 2 Lists into One
»VLOOKUP formula, SUBTOTAL, REPLACE ALL function - Unleashing The Power of Formulas
»SUMIF Formula, TEXT TO COLUMN Function - Analyzing Business Data in Double Quick Time
»PIVOT TABLE function - Making Your Report Update Automatically
»MS Query Function - Consolidate Data From Multiple Workbooks
»MS Query Function - Tapping the Power of Pivot Chart
- Recording Macros to Speed Up Repetitive Tasks
Price and Duration
S$600 per pax for this 2 days course.
Our TrainersEverydayExcel' trainers are all experts in spreadsheets and databases. They are specially hand-picked by the Chief Trainer, Jason Khoo, based on their experiences in training and the business knowledge they possess. Jason has worked in local listed companies and foreign MNCs managing the companies' budgeting process and developed business models for forecasting. He was also a financial counsel for a Fortune 500 company's business unit which generated a total revenue of more than S$100 million per annum.
EverydayExcel has helped many companies save thousands of dollars by providing simple and yet powerful business solutions through the use of Microsoft® Excel. Examples of such solutions include budget planning and forecasting, customer segmentation program, personalized email broadcast to targeted customers, and sales lead generation program (mini CRM), etc.
In a typical Excel course, participants are just taught the A to Z on the formulas and functions, for the purpose of passing the certification tests. After attending these courses, the participants are left on their own to figure out how to apply the formulas and functions effectively in their unique work situations. Some took months and years to accomplish this, but many never ever discovered how. We decided to fill the gap by offering our courses tapping on our Excel experiences, from our Excel-related work experience accumulated over the years (since Lotus 1-2-3 days) and regular consulting work done with companies such as Discovery Asia, Johnson and Johnson, EQ Insurance, DP Architect, etc.
WHY SHOULD YOU CONSIDER OUR COURSES?Unlike the gamut of basic, intermediate and advanced Excel courses geared towards achieving high score for the test given at the end of the training, our solution-based Excel courses work through real-life business situations and problems that business users encounter daily in their jobs and share with them quality solutions aimed to improve their work productivity and efficiency. ...