Description

Objectives:Business Intelligence (BI) is what you get when you analyze raw data and turn that information into actionable knowledge. BI can help your organisation uncover new business opportunities, recognize changing business environments, identify cost-cutting opportunities, identify data anomalies, and create widely accessible reports.The course objective is to equip participants with the requisite skills needed to make better business decisions by using excel tools to analyze data. The benefits of additional MS Excel training for your employees will give you a more efficient visibility into your operations as well as improve your bottom line.

Expected Learning Outcomes:At the end of the program, participants will be able to

• Analyze large amount of data and report those results in a meaningful way

• Get better visibility into data from different perspective.

• Add interactive control to show various views

• Automate repetitive task and processes

• Create eye-catching visualizations

• Create impressive Dashboard and What-If analysis

• Access external data sources to expand your message

• Be able to communicate the results of models clearly and concisely

COURSE CONTENTMODULE ONE

Introduction to basic excel techniquesFormulasCountIfSumIfIf, Nested If, ChooseVlookup, HlookupMatchIndexOffsetSumProductRows, ColumnsSumIfs, CountIfsIfError, IsError, IsNASmall, LargeMax, MinText FormulasFormula Debugging

Table structure, filtering, sorting AND advanced filteringAdvanced chartingExcel chart typesColumn ChartBar ChartLine ChartPie ChartScatter ChartArea ChartDoughnut ChartRadar ChartSurface ChartBubble ChartStock ChartGauge ChartComparative HistogramCombination ChartTrendlineHandling Missing DataUsing Excel Chart Tools

MODULE TWOUsing Pivot Tables and Pivot ChartsAnatomy of Pivot TableCustomizing Pivot TableFiltering your DataUsing Pivot ChartsUsing Excel SparklineChartless Visualization TechniquesConditional formattingAdvanced Dashboard and ReportDeveloping your Data ModelBuilding data modelData model best practiceExcel functions for your data modelThe VLOOKUP functionThe HKOOKUP functionThe SUMPRODUCT functionThe CHOOSE functionWorking with Excel tablesDashboardsWhat are Dashboards?Establish the user requirementsDashboard design principlesKey questions to ask before distributing your dashboard

MODULE THREECreating dashboard componentsComponent that show trendingComponent that group dataComponent that show performance against targetMacro-charged reportingAdding interactive Controls to your DashboardWorking with outside worldGet External dataWeb QueryMicrosoft QuerySet up your data source connectionCreating the link between Excel and PowerPointDistributing your Dashboard via PDF