“Power Query and Power Pivot aka Get and Transform are the best thing to happen to Excel in 20 years”. Bill Jelen, Excel MVP How long would it take you to combine data from 15 workbooks into a single data set? A few minutes, an hour? If you’re using Get & Transform (previously known as […]
This advanced course looks at some of the data analysis tools and functions available in Excel 2010 and involves a range of practical exercises using different types of data. Participants will learn how to use a variety of what-if analysis tools that can be employed in data analysis and decision making, such as Data Tables, […]
Virtual Course offered via MS Teams This course (offered over two separate sessions - Part I (1 hour) and Part II (1 hour)) is aimed at staff who wish to become more familiar with M365 suite and how some of its cloud apps available can be used to enhance the delivery and communication of a […]
Microsoft Visio is a graphics application used to create a variety of drawings such as flowcharts, organisation charts, office layouts and network diagrams. Participants will be shown how to display data in a visually appealing manner in order to maximise its impact and will have the opportunity to practise creating a variety of diagrams. Topics […]
This course provides participants with an opportunity to learn about more advanced features in PowerPoint 2010 in order to incorporate interactivity and multimedia in presentations. Intended for staff who are already familiar with the basic concepts of creating PowerPoint presentations, this practical course will enable users to create sophisticated presentations that make full use of […]
