11. November 2019 - 9:30 till 16:30
Microsoft Excel Data Analysis Course | Sydney Campus, Room to be advised | Monday, 11. November 2019
Learn to work smarter with your data with our Microsoft Excel courses in Excel is one of the world’s most popular spreadsheet software applications. Learn Microsoft Excel with our Microsoft Excel courses in Sydney - short courses open to Microsoft Excel data analysis course is an advanced Excel course where you will learn how to use the data analysis add-ins of Microsoft Excel, including:using Power View to create interactive data visualisationsusing Power Pivot to create a data model for use with Microsoft Excel tools such as pivot tables and pivot chartsusing Get & Transform to import and combine data from a variety of sources such as databases and web sites and using Power Map to visualise geographic Microsoft Excel course is designed for those already familiar with Microsoft Excel or those who have completed Microsoft Excel Course: Level 3 (Advanced) or have equivalent knowledge and are seeking a more in-depth understanding of data analysis techniques using Microsoft OutcomesAt the completion of this Microsoft Excel data analysis course you should be able to:Use Power View to examine and analyse a variety of analytical tasks using Power and refine data with Get & create and work with data in Power ContentMicrosoft Excel Power ViewUnderstanding Power Power Power View to the a Power View With a Power View With Power View and Sorting With Measure Power View Data in Power in Power More Power Titles and a Power View Excel Power PivotUnderstanding Power Relational Power to a Data With the Data With Data Model a Power Pivot a Data Model Related Power Pivot a Calculated a Concatenated Data Model Calculated a Slicers.Get & Transform in Microsoft ExcelUnderstanding Get & the Navigator a New Query From a a New Query From the the Query the Query Data Data a Data Query With Merged and Sharing Queries.The Advanced Excel Power MapUnderstanding Power a Power Map With Location With Mapping With Height and Category a Data the With With With Scene With Time and Editing a a Tour as a AudienceProviding comprehensive and thorough coverage of data analysis add-ins, this Microsoft Excel course is ideal for anyone who has completed Microsoft Excel Course: Level 3 (Advanced) or for existing Excel users seeking a more in-depth understanding of data analysis StyleThis Microsoft Excel data analysis course is presented as a practical, instructor-led computer-based course in a Microsoft Windows environment. You’ll have dedicated access to a computer exclusively for your use so you can follow instructor training and work through PrerequisitesThis Microsoft Excel data analysis course assumes fluency with Microsoft Excel and the creation of workbooks. You should be familiar with the basic functions of a computer operating system. This includes navigating the environment using a mouse and keyboard, starting applications, copying and pasting objects, formatting text, creating folders, opening and saving files, familiarity with the accessing the Internet and use of common web browsers. If you do not have these skills, we recommend attending the Basic Computer Skills Course before attempting this DatesAdditional instances of this course may be available and published on our website. See Microsoft Excel Data Analysis Course for more information, or to join the waiting list and be advised when we schedule more.