Hidden Secrets in Data Analysis with Excel 2007
Do you use Microsoft Excel to process data downloaded from ERP systems like SAP, ACCPAC? How about using power tools in Excel to get answers to the following questions:
How to reduce the time spent on manual copying and filtering of records?
How can I apply new and existing formulas in my work?
What are the short cuts to identify major customers, top products and top salespersons?
Detail
| Date: | |
| Duration: |
2, day(s) 9:00AM - 5:00PM |
| Fee: | $600.00 |
| Venue: | International Plaza, 10 Anson Road #26-02A |
Fees are subjected to prevailing GST of 7%
For more information, please contact JobsDB Learning at 65788111 or email to learning@jobsdb.com.sg
Payment must be made before the commencement of the workshop. No cancellation is allowed 7 days prior to workshop.
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 Two 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
Who Should Attend
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.
Testimonials
"I have always been clueless about the power of Excel, doing many things the manual way like counting amount in cells and doing manual layouts. To me Excel has always been just another program I layout my reports with. But after attending this Excel course, I realize that there is so much more power stored in Excel to help enhance and make efficient daily work reports that I have to do especially with ensuring accurate details in figures in big amounts. I'm sure as I continue to explore what has been taught, I will be able to save a lot more time and stop pulling my hair out while I face my reports again."
- Rachael Low, Trade Marketing Executive,
Johnson and Johnson Vision Care SG
Objectives
Upon 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.