data-analytics-reporting-in-excel-2016-course

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.

Learning Objectives

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.

Course Outline

  • 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

  • Reporting
    » Filter PivotTable using Timeline
    » Using Slicers to filter PivotTable
    » Creating PivotCharts
    » Auto update of PivotTables and Pivot Charts
Dates:
Excel 2016
30 & 31 Jul 18Confirmed
16 & 17 Aug 18Confirmed
08 & 09 Oct 18Tentative

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.

Our Trainers

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