Advanced Dashboard Masterclass: Building Interactive and Automated Dashboards

Olygenis aknowledge and business networking company. We create platforms for the larger companies to be updated on the latest trends and acquire the latest best practices. Olygen’s small group trainings are conducted by world-renowned experts focusing on the latest business issues and best practices. Olygen’s large-scale conferences cover the latest business trends and present industry leaders to share their latest insights, experience and case studies.Olygen’s growth rides on the increasingly knowledge-driven and globalized economy. As the world’s economy and business environment become more connected, businesses are subjected to greater competition. On the bright side, there are more opportunities as well. The key to survival and growth is continuous innovation to create new competitive advantages. The keys to continuous innovation are knowledge acquisition and business network. This is Olygen’s business. The potential is huge and it will keep growing.Olygen’s aim is to be the most recognized brand globally in the provision of senior executive master-classes and conferences.• Senior Executive Master-Classes – Quality small group training conducted by top global expert. Recognized for program quality, in terms of content and delivery, and service quality, i.e. it is a delightful experience attending our master-classes.• Corporate In-House Trainings – Workplace training consultation is conducted to assess the specific training needs of our clients. Top global experts are then selected to best fit the assessment. Olygen provides the project management, program design and flexible delivery.• Senior Executive Conferences – Conferences that address the most current and pertinent issues faced by top level executives. Speakers are key movers and thinkers, presenting views and experience most sought after in the relevant industries. Conferences also present the best platform to get to network with key decision-makers. I.e. if anyone can only go for one conference, it will be a Olygen conference.

OLYGEN

<H2><SPAN><SPAN><STRONG>Overview</STRONG></SPAN></SPAN></H2>
<DIV CLASS="page" TITLE="Page 4">
<DIV CLASS="section">
<DIV CLASS="layoutArea">
<DIV CLASS="column">
<P><SPAN STYLE="font-size: 12.000000pt; font-family: 'Roboto'; font-weight: bold; font-style: italic;">Leave the mundane world of static Excel charts! Impress your boss with “live” dashboards. Learn advanced techniques that give your dashboard users the power to interact with the data. They can compare by time frames, departments and product lines as well as compare multiple sets of data. Now, get dynamic with your Excel dashboards!</SPAN></P>
</DIV>
</DIV>
</DIV>
</DIV>
<P CLASS="page" TITLE="Page 2"><SPAN>There is valuable information hidden in the sea of data. A picture is worth a thousand words - use Excel dashboard to present information visually and beautifully within a single page that allows users to understand what is going on and make business decisions. Excel dashboard reports allow managers to have high-level overview of the business and help them make decisions. Excel is an excellent tool to make powerful dashboards that can provide analysis, insights and alert managers in a timely manner. A good Excel dashboard is:</SPAN></P>
<UL>
<LI><SPAN>visually appealing for decision makers to understand key information clearly</SPAN></LI>
<LI><SPAN>highly dynamic, allowing managers to easily dig into your data</SPAN></LI>
<LI><SPAN>easy to update</SPAN></LI>
</UL>
<P><SPAN><SPAN><STRONG>Key Takeaways</STRONG></SPAN></SPAN></P>
<P><SPAN>By the end of the course, participants will:</SPAN></P>
<DIV CLASS="page" TITLE="Page 2">
<DIV CLASS="section">
<DIV CLASS="layoutArea">
<UL>
<LI>Create dynamic interactive charts</LI>
<LI><SPAN>Gain visualisation tips and tricks</SPAN></LI>
<LI><SPAN>Learn how to build stunning and informative Excel dashboards.</SPAN></LI>
<LI><SPAN>Display key trends, comparisons and data graphically for greater clarity and faster insights</SPAN></LI>
<LI><SPAN>Learn different chart types to display data in the most meaningful way.</SPAN></LI>
<LI><SPAN>Learn smart techniques that make charting work fun and productive.</SPAN></LI>
<LI><SPAN>Create interactive controls that enable users to customise their view</SPAN></LI>
</UL>
</DIV>
</DIV>
</DIV>
<P CLASS="section"><SPAN><SPAN><STRONG>Prerequisites</STRONG></SPAN></SPAN></P>
<P CLASS="section"><SPAN>Participants should be comfortable with basic Excel tools and functions. At a minimum, participants should know how to navigate confidently in Excel, create and use simple formulas and link between workbooks</SPAN></P>
<P CLASS="section"><SPAN><SPAN><STRONG>Who Should Attend</STRONG></SPAN></SPAN></P>
<P CLASS="section"><SPAN>This workshop is crucial for analysts, managers, reporting professionals, business owners, executives, and anyone responsible for preparing Excel based dashboards, scorecards or KPI reports. This training is highly recommended for:</SPAN></P>
<DIV CLASS="page" TITLE="Page 2">
<DIV CLASS="section">
<DIV CLASS="layoutArea">
<DIV CLASS="column">
<UL>
<LI><SPAN>Directors</SPAN></LI>
<LI><SPAN>General Managers</SPAN></LI>
<LI><SPAN>Chief Financial Officers</SPAN></LI>
<LI><SPAN>FinanceManagers</SPAN></LI>
<LI><SPAN>Accountants</SPAN></LI>
<LI><SPAN>Marketing Managers</SPAN></LI>
<LI><SPAN>Sales Managers</SPAN></LI>
<LI><SPAN>HR Managers</SPAN></LI>
<LI><SPAN>BusinessOwners</SPAN></LI>
<LI><SPAN>Anyone who deals with business, management and financialreporting</SPAN></LI>
</UL>
</DIV>
</DIV>
</DIV>
</DIV>
<DIV CLASS="page" TITLE="Page 3">
<DIV CLASS="section">
<DIV CLASS="layoutArea">
<DIV CLASS="column">
<P><SPAN><SPAN><STRONG>Agenda</STRONG></SPAN></SPAN></P>
<P><SPAN>Session 1: PREPARING DASHBOARD DATA</SPAN></P>
<DIV CLASS="page" TITLE="Page 3">
<DIV CLASS="section">
<DIV CLASS="layoutArea">
<DIV CLASS="column">
<DIV CLASS="page" TITLE="Page 4">
<DIV CLASS="section">
<DIV CLASS="layoutArea">
<DIV CLASS="column">
<UL>
<LI>Understanding your data</LI>
<LI>Organising data</LI>
<LI>Data smoothing</LI>
<LI>Tools and tricks to clean data before using it to build a <SPAN STYLE="font-size: 9.000000pt; font-family: 'Roboto';">report or dashboard</SPAN></LI>
</UL>
<P>Session 2: NAMED RANGES AND EXCEL TABLE</P>
<UL>
<LI>Naming cells and ranges</LI>
<LI>Creating Excel tables</LI>
<LI>Applying table names</LI>
<LI>Using structured references in formula</LI>
<LI>Refreshing tables with new data</LI>
</UL>
<P>Session 3: AUTOMATING DASHBOARDS WITH FUNCTIONS</P>
<UL>
<LI>Learn to nest functions together to create robust formulas</LI>
<LI>Use IF, Nested IFs and IFS (Excel 2016) for logical test with single or multiple conditions</LI>
<LI>Embed AND or OR function in IF for robust logical tests</LI>
<LI>Trap and handle errors produced by other formulas or <SPAN STYLE="font-size: 9.000000pt; font-family: 'Roboto';">functions with IFERROR</SPAN></LI>
<LI>Use CHOOSE to return a value from an array based on <SPAN STYLE="font-size: 9.000000pt; font-family: 'Roboto';">index number</SPAN></LI>
<LI>Aggregate data with single criterion using SUMIF, <SPAN STYLE="font-size: 9.000000pt; font-family: 'Roboto';">COUNTIF, AVERAGEIF</SPAN></LI>
<LI>Tabulating information using multiple criteria with <SPAN STYLE="font-size: 9.000000pt; font-family: 'Roboto';">SUMIFS, COUNTIFS, AVERAGEIFS</SPAN></LI>
<LI>Lookup and retrieve data from a speci<SPAN STYLE="font-size: 9.000000pt; font-family: 'Roboto';">fi</SPAN><SPAN STYLE="font-size: 9.000000pt; font-family: 'Roboto';">c column in </SPAN><SPAN STYLE="font-size: 9.000000pt; font-family: 'Roboto';">table using VLOOKUP</SPAN></LI>
<LI>Use MATCH to <SPAN STYLE="font-size: 9.000000pt; font-family: 'Roboto';">fi</SPAN><SPAN STYLE="font-size: 9.000000pt; font-family: 'Roboto';">nd the relative numeric position of an </SPAN><SPAN STYLE="font-size: 9.000000pt; font-family: 'Roboto';">item in a range</SPAN></LI>
<LI>Use INDEX to extract a value from a table (or range)</LI>
<LI>INDEX and MATCH - powerful combo that has more <SPAN STYLE="font-size: 9.000000pt; font-family: 'Roboto';">flexibility and speed</SPAN></LI>
<LI>Why INDEX MATCH is better than VLOOKUP</LI>
<LI>Using ROW(S) and COLUMN(S) for indexing</LI>
<LI>Rank and sort your data using RANK, LARGE and <SPAN STYLE="font-size: 9.000000pt; font-family: 'Roboto';">SMALL</SPAN></LI>
<LI>Use ‘database functions’ DSUM, DCOUNT and <SPAN STYLE="font-size: 9.000000pt; font-family: 'Roboto';">DAVERAGE to </SPAN><SPAN STYLE="font-size: 9.000000pt; font-family: 'Roboto';">fi</SPAN><SPAN STYLE="font-size: 9.000000pt; font-family: 'Roboto';">lter information in a list or database </SPAN><SPAN STYLE="font-size: 9.000000pt; font-family: 'Roboto';">based on set criteria</SPAN></LI>
<LI>Using TEXT and CONCATENATE to string numbers and <SPAN STYLE="font-size: 9.000000pt; font-family: 'Roboto';">text together to show in a dashboard or chart.</SPAN></LI>
</UL>
<P>Session 4: BUILDING INTERACTIVE CHARTS AND DASHBOARDS CONTROLS</P>
</DIV>
<DIV CLASS="column">
<UL>
<LI>Using form controls: Button, Combo Box, Check Box, <SPAN STYLE="font-size: 9.000000pt; font-family: 'Roboto';">Spin Button, List Box, Option Button, Scroll Bar, Label </SPAN><SPAN STYLE="font-size: 9.000000pt; font-family: 'Roboto';">and Group Box</SPAN></LI>
<LI>Set up dynamic data validation list</LI>
<LI>Creating dynamic named range with OFFSET and <SPAN STYLE="font-size: 9.000000pt; font-family: 'Roboto';">COUNTA</SPAN></LI>
<LI>Creating dynamic named range with INDEX </LI>
<LI>Using the INDIRECT function</LI>
</UL>
<DIV CLASS="column">
<P>Session 5: BUILDING DYNAMIC CHARTS</P>
<UL>
<LI>Selecting data with a combo box (or data validation list) for dynamic Excel charting</LI>
<LI>Using a check box to show or hide data or trend lines</LI>
<LI>Scrolling a dynamic excel chart through time</LI>
<LI>Using helper columns to manipulate your data</LI>
<LI>Linked textbox for dynamic chart titles</LI>
<LI>Tricks to avoid crashing lines in line chart</LI>
<LI>Linking legends to cell contents</LI>
</UL>
<P>FINAL PROJECT: BUILDING INTERACTIVE AND AUTOMATED DASHBOARD</P>
</DIV>
<UL>
<LI>Create an executive-level interactive dashboard from <SPAN STYLE="font-size: 9.000000pt; font-family: 'Roboto';">start to </SPAN><SPAN STYLE="font-size: 9.000000pt; font-family: 'Roboto';">fi</SPAN><SPAN STYLE="font-size: 9.000000pt; font-family: 'Roboto';">nish</SPAN></LI>
<LI>Learn tricks and tips for building interactive dashboards </LI>
<LI>Linking charts to dynamic data</LI>
<LI>Automatically refresh your dashboards based on new <SPAN STYLE="font-size: 9.000000pt; font-family: 'Roboto';">data</SPAN></LI>
</UL>
</DIV>
</DIV>
</DIV>
</DIV>
</DIV>
</DIV>
</DIV>
</DIV>
</DIV>
</DIV>
</DIV>
</DIV>

1092 CK Amsterdam

Our {communityGuidelinesLink} describe the sort of content we prohibit on Eventbrite. If you suspect an event may be in violation, you can report it to us so we can investigate.

To report other categories of prohibited or illegal content, submit {link}