Though many professionals use Excel on a daily basis, Excel has many undiscovered functions that can increase productivity even further. In this course, we will explore one of the relatively new tools brought by Excel to help professionals in cleaning up and preparing data for further analysis and reporting: Power Query. This tool is available as an "Add-in" on Excel 2013 but comes readily available on Excel 2016 and newer versions. In addition, we will cover many features of pivot tables which is the main reporting tool in Excel. We will also take a look at PowerPivot, another powerful tool in Excel that will put your pivot tables on turbo. While pivot tables have some limitations, PowerPivot can be used when you have significantly big data. The last part of the course is dedicated to automating your Excel reports and reconciliation through the use of macros.
This course aims to teach a suite of algorithms and concepts to a diverse set of participants interested in the general concept of fitting data to models. It starts with mostly simple linear algebra and computational methods, and introduces some more difficult mathematical concepts towards the end. This method also, by design, fits in with our approach of morning lectures and afternoon practice on personal computers. The combined teaching system provides opportunities for much hands-on learning and participants leave the course with practical knowledge of the basic algorithms.
A high-level overview of key Data Science disciplines is provided in this course. Along with an overview of frequent advantages, difficulties, and adoption problems, a fundamental grasp of data science from both a commercial and technological standpoint is given.
This interactive, applications-driven 5-day course will highlight the added value that data analytics can offer a professional as a decision support tool in management decision-making. It will show the use of data analytics to support strategic initiatives; inform policy information; and direct operational decision-making. The course will emphasize applications of data analytics in management practice; focus on the valid interpretation of data analytics findings; and create a clearer understanding of how to integrate quantitative reasoning into management decision-making. Exposure to the discipline of data analytics will ultimately promote greater confidence in the use of evidence-based information to support management decision-making.
In this course, we will explore how businesses can leverage digital technologies to improve their operations, enhance customer engagement, and drive growth. By the end of this course, you will have a better understanding of the various digital strategies and tools available to transform your business.
Learn how to scope, plan, and implement a data center design to meet the ever-expanding demands of today’s modern business environment. Utilising current best practices and applicable standards across the key data center infrastructures.
In this course, you will learn the skills to enable you to use the Visual Basic for Applications (VBA) programming language to simplify or automate activities and tasks using the Microsoft Office 2007 - 2019 (365) applications. The course covers examples in Excel, Access, Word, and PowerPoint 2007 - 2019 (365).
Though many professionals use Excel on a daily basis, Excel has many undiscovered functions that can increase productivity even further. In this course, we will explore one of the relatively new tools brought by Excel to help professionals in cleaning up and preparing data for further analysis and reporting: Power Query. This tool is available as an "Add-in" on Excel 2013 but comes readily available on Excel 2016 and newer versions. In addition, we will cover many features of pivot tables which is the main reporting tool in Excel. We will also take a look at PowerPivot, another powerful tool in Excel that will put your pivot tables on turbo. While pivot tables have some limitations, PowerPivot can be used when you have significantly big data. The last part of the course is dedicated to automating your Excel reports and reconciliation through the use of macros.
The corporate ethos which demands continual improvement in workplace efficiencies and reduced operating, maintenance, support service, and administration costs means that managers, analysts, and their advisors are faced with ever-challenging analytical problems and performance targets. To make decisions that result in improved business performance it is vital to base decision making on appropriate analysis and interpretation of numerical data.