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;
- Analys data using PivotTable and PowerPivot;
- Create simple dashboard for management.
- Clean Data
» 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
- Analyse Data
» 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
|30 & 31 Jul 18||Confirmed|
|16 & 17 Aug 18||Confirmed|
|08 & 09 Oct 18||Tentative|
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 Excel courses