Learn how to get the most out of Microsoft Excel & leverage this powerful tool. Achieve a good understanding of how Excel works/ thinks & progress from creating basic spreadsheets to advanced dashboards - store your data correctly, format it and then (i) Use formula/ functions (ii) Link sheets/ files, apply validation & conditional formatting (iii) Analyse using charts & pivot tables (iv) Create interactive dashboards with slicers & DAX
Reduce manual tasks to the click of a button by leveraging Excel functionality with macros - automate repetitive tasks and create interactive models to analyse, consolidate & report on data.
Create interactive dashboards that visualise your data, connecting directly for real time reporting or to downloads. Use single or multiple sources inc Excel, CSV, SQL, SharePoint, Online Databases, etc. Learn what Power BI can do for you and how to visualise, clean & consolidate data - where necessary, transform it to make ready for reporting. Share your dashboards with others via Teams, PDF or Power BI Online. Turn your data into information then your information into insights.
This is is a tool for authoring paginated reports that you can publish to the Power BI service:
Microsoft Project is a flexible tool that is used for creating project schedules, estimating resource requirements, analysing task dependencies & tracking project progress. During the course, delegates will learn how to create effective project plans and then update actual project progress - with emphasis on the Critical Path.
Learn how to write SQL (Structured Query Language) to access, extract, organise & manipulate the data stored in your relational database. Our SQL courses range from Introduction to Advanced levels and during the course you will interrogate a number of different datasets (Personnel Directory, Client Invoicing, Event Management, etc), providing the opportunity to demonstrate different ways to apply what you have learned.
In order to get the most out of your Microsoft 365, it is important to know:
Learn how to effectively use:
Create & deliver engaging PowerPoint presentations:
Manage Word documents efficiently:
Crystal Reports empowers the user to connect directly to data tables & create reports based on LIVE data. Where it was previously necessary to export to Excel & repetitively create PivotTables & PivotCharts to analyse, with Crystal you will learn how to connect directly to the live data, create a report and REFRESH to obtain the live & essential data.
Use this powerful report writer to:
mullanITtraining.co.uk: Crystal Reports - SAP
Communicate Information at a Glance - Process Maps/ Flowcharts, Organisational Charts, Swim Diagrams, etc
Microsoft Visio gives business and technical users the power to communicate information at a Glance - with Process Maps/ Flowcharts, Organisational Charts, Swim Diagrams, etc. Once created, they can then be distributed to a wider audience - internally & externally. Use the simple, flexible tools in Visio to easily create business and technical charts & graphics that capture workflows & communicate with impact: