Download Training Directory (2021) Download Now

Aug 2021

Advanced Excel Skills For Business Analysis And Reporting

Course Information

Start Date 16 Aug 2021, Monday
End Date 17 Aug 2021, Tuesday
Time 09:00 am to 05:00 pm
Venue Concorde Hotel OR Holiday Inn Orchard City Centre
Fee $1,280 (Excluding GST)
Contact 6720 3333 (Ms Rina) training.aventis@gmail.com
Register Now
Get Group Quote
LIVE Stream

Course Schedule

22 & 23 Feb 2021 FULL HOUSE

06 & 07 May 2021 Confirmed Run

16 & 17 Aug 2021 (Mon & Tue)

22 & 23 Nov 2021 (Mon & Tue)

(Click on the dates above to register online)


Advanced Excel 2016 has powerful business analysis capabilities and dynamic reporting features that provide managers and business owners with the information and insights instantly.

  • If you require an efficient way to analyze and retrieve your data from Excel
  • If you deal with budgets, P&L, Sales or other administrative data and need to display the information using interactive Excel charts and reports
  • If you need to use the data for important decision-making and planning

Then this is the right course for you!

Discover useful shortcuts for creating and modifying reports, charts and graphs and overcoming the common errors and problems

Facilitated by Microsoft Certified Trainer, Ms. Valene Ang. This high impact 2 Days practical workshop will empower you with the skills, know-how and confidence to use excel and its functions with ease.

Whether you want to use Microsoft Excel to manage all your business data or just use it for a small aspect like maintaining customer lists and employee scheduling, this course will prepare you to start using Excel on your own. Throughout the course, you will learn interesting and useful tips and tricks to allow you work more efficiently with Excel. The trainer will also use real-world business examples to illustrate its application in real life.

Gain simple and practical tips on how to fully harness the hidden analysis power of Excel and its powerful modeling functions for decision making, analysis, marketing, accounting and finance.

Key Takeaways: Gain Mastery, Confidence and Improve Productivity

Using Simple Techniques to get the most out of Excel’s statistical and financial functions to save valuable time and effort on
• Formatting reports using conditional formatting rules and styles
• Import business data from other sources

Acquire Powerful Data Analysis Capability
Leverage Excel’s amazing tools, including PivotTables and PivotCharts capability which helps you analyze trends in data without having to worry about what formulas to be written and transform data into small, concise reports that tell you exactly what you need to know and identify patterns to enhance other research effort.

Prepare Visually Stunning Presentation and Report
Create interactive charts with business data and use visual tools to present information in the most convincing and simple to understand way for different stakeholders and partners. Create business dashboard to compare different information in one screen and analyze data using Advanced Excel functions for improved Business Decisions and Statistical Analysis skills

Other Sneaky Tricks, Tips and Tools
• Use Quick Analysis
• Use Slicer to Filter Excel Table
• Use Timeline to Filter PivotTable
• Connect Multiple PivotTables

Bonus Plus: Learn how to create charts, sparklines, tables and calculate totals in a flash with Quick Analysis

Who Should Attend?

This course is perfect for experienced Excel users who want to replace manual tracking of financial data with interactive Excel analysis and reports. It is intended for senior officers, executives and decision makers in government, corporate and private organisations.

  • Business owners who run a small to medium sized businesses will be able to replace manual business data tracking processes with interactive Excel analysis and reports
  • Managers or new employees who want to learn how to summarize business data and paves the way to put it into meaningful and useful reports.
  • Delegates who intend to increase their work productivity with effective and time saving data analysis skills
  • Experienced Excel users who wish to learn more about Excel’s business-analysis capabilities

This is a fast paced advanced level workshop; it is not suitable for beginners and those who uses Excel program occasionally. If you are new to Microsoft Excel, you may consider our Basic to Intermediate Excel Course instead.
This workshop is only for Windows version Microsoft Excel users. Participants are required to bring a laptop equipped with Windows version Microsoft Excel 2016. Participants need to have basic knowledge to create Pivot Table

Raving Testimonials

“Ms. Valene is very attentive & attends to every question that participants ask. Also guide participants step by step. Have gained more knowledge about Microsoft in this course. This course will be very effective for officers who are not proficient in Microsoft. This course had helped me in formatting more tables & saving time in finding accurate results.” Jeslyn, Urban Redevelopment Authority

“She is knowledgeable about the content and able to explain the steps clearly. This course is recommended to achieve efficiency using the formulas and features learnt when working on data.” Jiafang, Temasek International Pte Ltd

“Ms Valene Ang is knowledgeable and very approachable. This course will help in creating easy to understand graphs for business reporting.” Yongsheng, Senior Executive at National Environment Agency

“The trainer is very knowledgeable with the topics and she goes beyond to provide additional functions knowledge that does not covered in the topics. She is approachable and responds heartily to question. Knowing the use of the function can enhance the efficiency of the work. Compliment to the service manager, warm and heartily and prompt service provided.” Susan, Manager at Canon Medical Systems Asia Pte ltd

MS Excel Expert and Microsoft Certified Trainer: Valene Ang

Valene Ang is a Microsoft Certified Trainer and Master Instructor of Microsoft Office Specialist (MOS). She brings with her 20 years’ experience in corporate training and consultancy. Valene has a broad experience in customizing Microsoft Office training programs, developing customized course outline and course material, assisting corporate clients in business data analysis and providing dynamic report solutions.

She had conducted many Microsoft Office workshops in Singapore and Malaysia. Her training focuses on providing practical solutions to real life Excel problems. As a Certified Trainer, Ms Ang has trained hundreds of executives, managers and directors from across medium sized organisations, government offices and multinational companies. Some of her high profile clients including PSA International, DFS Galleria Singapore, Neptune Orient Lines Limited (NOL), National Environment Agency (NEA), Inland Revenue Authority of Singapore (IRAS), CPF Board, Public Utility Board (PUB), Canadian High Commission, British High Commission, Temasek Polytechnic, Republic Polytechnic, Baxter Healthcare Pte. Ltd, and many more.

Program Outline

Chapter 1: Calculating With Formulas And Functions
1.1 Create Formulas Using Names
1.2 Manage Names Using The Name Manager
1.3 Date And Time Functions
1.4 Logical Functions
1.5 Conditional Logical Functions
1.6 Database Functions
1.7 Lookup Functions
1.8 Use The Convert Text To Columns Wizard

Chapter 2: Visualizing Data With Charts
2.1 Overview Of Excel Chart
2.2 Create Chart With Quick Analysis
2.3 Align Chart Axis Labels
2.4 Display Value Axis In Millions
2.5 Using Recommended Chart Tool
2.6 Display Percentage On Pie Chart
2.7 Create Chart With Multi Line Labels
2.8 Create Combo Chart
2.9 Use The Chart Tools
2.10 Create Chart Template For Sharing
2.11 Create Waterfall Chart
2.12 Create Histogram
2.13 Create Treemap Chart
2.14 Create Sunburst Chart
2.15 Insert Automatic Subtotals
2.16 Create Auto Outline
2.17 Create Charts With Subtotal And Outlined Data

Chapter 3: Analyzing Data With Table
3.1 Format Data Range As Table
3.2 Use The Table Tools
3.3 Create Table With Quick Analysis
3.4 Remove Duplicate Records
3.5 Add Total Row To Table
3.6 Insert Calculated Columns
3.7 Filter Table Data With Custom Filter
3.8 Build Dynamic Chart With Table
3.9 Use Slicer To Filter Data
3.10 Overview Of Conditional Formatting
3.11 Apply Conditional Formatting
3.12 Sort Data By Color
3.13 Filter Data By Color
3.14 Create In-Cell Chart With Sparklines

Chapter 4: Analyzing Data With PivotTables
4.1 Overview Of PivotTable And PivotChart
4.2 Create PivotTable From Table
4.3 Insert Recommended PivotTables
4.4 Change Report Layouts
4.5 Show And Hide Report Totals
4.6 Format PivotTable
4.7 Refresh PivotTable Data
4.8 Filter And Sort Data
4.8.1 Using Report Filter
4.8.2 Using Label Filters And Value Filters
4.8.3 Sorting PivotTable Data Automatically
4.8.4 Sorting PivotTable Data Manually
4.9 Create Custom Calculations
4.9.1 Summarize Values With Functions
4.9.2 Show Values In Percentage
4.10 Group Fields In A PivotTable
4.10.1 Grouping Dates Field
4.10.2 Grouping Numeric Field
4.10.3 Grouping Text Field
4.11 Filter Pivot Data With Slicer And Timeline
4.12 Create Calculated Fields In PivotTable
4.13 Edit PivotTable Formulas
4.14 Create PivotChart From Excel Table
4.15 Creating A PivotChart From PivotTable
4.16 Use The PivotChart Tools
4.17 Create Relationships Between Tables
4.18 Create PivotTable using Data Model

Chapter 5: Creating Dashboard Reports
5.1 Overview Of Dashboard
5.2 Prepare Source Data for PivotTable
5.3 Create PivotTable And PivotChart
5.4 Hide Field Buttons From PivotChart
5.5 Create Combo Chart
5.6 Format Chart Axis And Align Charts
5.7 Use Slicer To Filter PivotTable
5.8 Use Slicer To Connect PivotTables
5.9 Use Timeline to Filter PivotChart