Who Should Attend
Managers and Executives who have to clean, analyse and prepare reports. They must have be
frequent user of Excel and possess Excel version 2016 and PowerPivot.
Upon completion of the course, participants will be able to:
- Clean Data using Get and Transform function in Excel 2016;
- Analyse data using PivotTable and PowerPivot;
- Create simple dashboard for management.
» Identify unclean data that hinder your analysis
» Keep your raw data file as is during the entire cleaning process
» Store your steps in data cleaning and review them at any time
» Discard changes in data cleaning without worries
» Consolidate multiple sources into one
» Allocate cost to different cost centres
» Replay the data cleaning process step by step on demand
» Creating a pivot table using a source that adjust by itself
» Calculating unique customer/product count
» Presenting the top 5 results with PivotTable
» Sorting the products/customers in descending orders of sales
» Creating auto-highlights within PivotTable
» Calculating Variance within Pivot Table
» Present YTD numbers with PivotTable
» Measure Top 10 products as a percentage of total sales
» Running sub-total
» Filter PivotTable using Timeline
» Using Slicers to filter PivotTable
» Creating PivotCharts
» Auto update of PivotTables and Pivot Charts
Time: 9am - 5pm
Duration: 14 Hours (2 days)
Venue: International Plaza
10 Anson Road #26-02A
Course Fees: S$600 per pax
Price and Duration
S$600 per pax for this 2 days course.
EverydayExcel' 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.
Download Excel course Registration Form
« Back to