{"id":1464,"date":"2019-10-19T13:01:41","date_gmt":"2019-10-19T10:01:41","guid":{"rendered":"https:\/\/www.dolphinsgroup.co.ke\/dolphins_training\/blogging\/?page_id=1464"},"modified":"2019-10-21T11:06:17","modified_gmt":"2019-10-21T08:06:17","slug":"financial-modeling-dashboards-advanced-excel-masterclass-skills-trainingnairobi-mombasa-kenya","status":"publish","type":"page","link":"https:\/\/www.dolphinsgroup.co.ke\/dolphins_training\/blogging\/financial-modeling-dashboards-advanced-excel-masterclass-skills-trainingnairobi-mombasa-kenya\/","title":{"rendered":"Financial Modeling and Dashboards With Advanced Excel Masterclass Skills Training,Nairobi and Mombasa Kenya"},"content":{"rendered":"<p><strong>Advanced Financial Modeling and Dashboards with Excel Skills Training <\/strong><\/p>\n<p><strong><a href=\"https:\/\/www.dolphinsgroup.co.ke\/dolphins_training\/training-schedule\/\" target=\"_blank\" rel=\"noopener noreferrer\"><img loading=\"lazy\" src=\"https:\/\/www.dolphinsgroup.co.ke\/dolphins_training\/images\/dolphins_group_online_booking.png\" alt=\"Dolphins Group - Book Now\" width=\"117\" height=\"31\" border=\"0\" \/><\/a><\/strong><\/p>\n<p><strong>Introduction<\/strong><\/p>\n<p>When it comes to advanced financial modeling (AFM) there are several important techniques that world-class financial analysts practice. This guide outlines the best, most advanced techniques financial modeler should use or considering using to perform industry-leading financial analysis.<\/p>\n<p><strong>Course Objectives<\/strong><\/p>\n<p>This course will develop the best practice approaches to structuring fully flexible and auditable models whilst cultivating the most efficient data analysis tools and solve other common modeling problems.<\/p>\n<p><strong>Key Learning Outcomes:<\/strong><\/p>\n<ul>\n<li>Harness Excels tools within a best practice framework<\/li>\n<li>Add flexibility to their models through the use of switches and flexible lookups<\/li>\n<li>Work efficiently with large data volumes<\/li>\n<li>Model debt effectively<\/li>\n<li>Approach modeling for tax, debt, pensions and disposals with confidence<\/li>\n<li>Build flexible charts and sensitivity analysis to aid the presentation of results<\/li>\n<\/ul>\n<p><strong>PROGRAM OUTLINE.. <\/strong><\/p>\n<table width=\"636\">\n<tbody>\n<tr>\n<td width=\"636\">Ice breaker<\/p>\n<p>House Rules<\/td>\n<\/tr>\n<tr>\n<td width=\"636\"><strong>Introduction<\/strong><\/p>\n<p><strong>Data management and Analysis<\/strong><\/p>\n<p>Big Data Management Tech<\/p>\n<p>Calculations validating<\/p>\n<p>&nbsp;<\/td>\n<\/tr>\n<tr>\n<td width=\"636\">Filters &amp; Auto Filters<\/p>\n<p>V &amp; H Look ups<\/p>\n<p>&nbsp;<\/td>\n<\/tr>\n<tr>\n<td width=\"636\"><strong>Data Modeling Techniques<\/strong>&#8211;<\/p>\n<p>Pivot Tables<\/p>\n<p>Power Query<\/p>\n<p>&nbsp;<\/td>\n<\/tr>\n<tr>\n<td width=\"636\">Data Model<\/p>\n<p>Visualization<\/td>\n<\/tr>\n<tr>\n<td width=\"636\"><strong>Dashboards Development:<\/strong><\/p>\n<p>Design Principles<\/p>\n<p>&nbsp;<\/td>\n<\/tr>\n<tr>\n<td width=\"636\">Developing simple dynamic Interactive Dashboard<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<table width=\"636\">\n<tbody>\n<tr>\n<td width=\"636\"><strong>Logical Functions<\/strong>&#8211;<\/p>\n<p>IF, IFNESTED, IFNA &amp; IFERROR<\/p>\n<p>AND &amp; OR<\/p>\n<p>ISBLANK<\/p>\n<p>Text Manipulative<\/p>\n<p>Concatenate<\/td>\n<\/tr>\n<tr>\n<td width=\"636\"><strong>Chart Formatting<\/strong>&#8211;<\/p>\n<p>Chart Types<\/p>\n<p>3D Formatting<\/p>\n<p>Review of Charts<\/td>\n<\/tr>\n<tr>\n<td width=\"636\">Introduction to interactive charts<\/p>\n<p>Pivot Charts<\/p>\n<p>Usage &amp; Limitation<\/td>\n<\/tr>\n<tr>\n<td width=\"636\"><strong>Advanced Visualization<\/strong><\/p>\n<p>Power Map<\/td>\n<\/tr>\n<tr>\n<td width=\"636\">Power View<\/p>\n<p>Dynamic Charts Using Filters &amp; Sparklines<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&nbsp;<\/p>\n<table width=\"636\">\n<tbody>\n<tr>\n<td width=\"636\"><strong>Excel Reports<\/strong>&#8211;<\/p>\n<p>Budget Preparation<\/p>\n<p>Financial Management Reports<\/p>\n<p>Growth Drivers<\/p>\n<p>Financial Gearing<\/p>\n<p>&nbsp;<\/td>\n<\/tr>\n<tr>\n<td width=\"636\"><strong>Developing Working Sheet<\/strong>&#8211;<\/p>\n<p>Working Capital<\/td>\n<\/tr>\n<tr>\n<td width=\"636\">Fixed Assets<\/p>\n<p>Modeling Taxes &amp; Equity<\/p>\n<p>Creating Inputs<\/p>\n<p>Reviewing Model<\/p>\n<p>&nbsp;<\/td>\n<\/tr>\n<tr>\n<td width=\"636\"><strong>Team Building Activities<\/strong><\/p>\n<p>&nbsp;<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&nbsp;<\/p>\n<table width=\"636\">\n<tbody>\n<tr>\n<td width=\"636\"><strong>Setting Up Model:<\/strong><\/p>\n<p>Layout for Scalable Financial Model, Growth Drivers, Asset &amp; Debt Schedule<\/p>\n<p>&nbsp;<\/td>\n<\/tr>\n<tr>\n<td width=\"636\"><strong>Forecasting &amp; Predictive Modeling<\/strong>&#8211;<\/p>\n<p>Projecting P&amp; L, Balance Sheet &amp; Cash flow Statement.<\/p>\n<p>&nbsp;<\/td>\n<\/tr>\n<tr>\n<td width=\"636\"><strong>Forecasting &amp; Predictive Modeling<\/strong>&#8211;<\/p>\n<p>Building &amp; Analyzing Financial Ratios<\/p>\n<p>&nbsp;<\/td>\n<\/tr>\n<tr>\n<td width=\"636\"><strong>Forecasting &amp; Predictive Modeling<\/strong>&#8211;<\/p>\n<p>Building &amp; Analyzing Financial Ratios<\/p>\n<p>&nbsp;<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&nbsp;<\/p>\n<p><strong>Dolphins Training &amp; Consultants ltd<\/strong><\/p>\n<p>View Park Towers ,10th Fl ,Utalii Lane &amp; L584-off UN Avenue, Gigiri<strong>.<\/strong><br \/>\nP O Box 27859 00100 Nairobi, Kenya Tel +254-20-2211362\/4\/5 or 2211382 Cell+254-712-636404<br \/>\n<a href=\"mailto:training@dolphinsgroup.co.ke\">training@dolphinsgroup.co.ke<\/a> <a href=\"http:\/\/www.dolphinsgroup.co.ke\">www.dolphinsgroup.co.ke<\/a><\/p>\n<p><strong>Your No.1 Corporate Training Partner DIT No.\/ 711<\/strong><\/p>\n<p>&nbsp;<\/p>\n<p><strong>We push the human race forward and so do you<\/strong><strong>&#8230;.. <\/strong> <a href=\"http:\/\/www.dolphinsgroup.co.ke\/dolphins_training\/training-schedule\/#.U0Y4EKKoFwk\"><strong><em>Unleash Your True Potential&#8230;.!<\/em><\/strong><\/a><\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Advanced Financial Modeling and Dashboards with Excel Skills Training Introduction When it comes to advanced financial modeling (AFM) there are several important techniques that world-class financial analysts practice. This guide outlines the best, most advanced techniques financial modeler should use or considering using to perform industry-leading financial analysis. Course Objectives This course will develop the [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":[],"yst_prominent_words":[],"_links":{"self":[{"href":"https:\/\/www.dolphinsgroup.co.ke\/dolphins_training\/blogging\/wp-json\/wp\/v2\/pages\/1464"}],"collection":[{"href":"https:\/\/www.dolphinsgroup.co.ke\/dolphins_training\/blogging\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.dolphinsgroup.co.ke\/dolphins_training\/blogging\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.dolphinsgroup.co.ke\/dolphins_training\/blogging\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dolphinsgroup.co.ke\/dolphins_training\/blogging\/wp-json\/wp\/v2\/comments?post=1464"}],"version-history":[{"count":2,"href":"https:\/\/www.dolphinsgroup.co.ke\/dolphins_training\/blogging\/wp-json\/wp\/v2\/pages\/1464\/revisions"}],"predecessor-version":[{"id":1601,"href":"https:\/\/www.dolphinsgroup.co.ke\/dolphins_training\/blogging\/wp-json\/wp\/v2\/pages\/1464\/revisions\/1601"}],"wp:attachment":[{"href":"https:\/\/www.dolphinsgroup.co.ke\/dolphins_training\/blogging\/wp-json\/wp\/v2\/media?parent=1464"}],"wp:term":[{"taxonomy":"yst_prominent_words","embeddable":true,"href":"https:\/\/www.dolphinsgroup.co.ke\/dolphins_training\/blogging\/wp-json\/wp\/v2\/yst_prominent_words?post=1464"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}