This course has been designed specifically for individuals who are confident in Microsoft Excel and need to learn data analysis tools within their role. Positions include but are not limited to: Accountants, Administrators, Office Managers, HR Specialists, etc.
Having the ability to analyse data and present it visually is significant in organisations.
Excel holds powerful analysis tools to break down complex data and present it in a visually compelling way?
When working with large data sets, would you benefit from creating Pivot Tables? Designed to pick out specific content from your data set and allow you to manipulate and display it in a variety of ways.
Have Pivot Tables and Pivot Charts always been a mystery to you? Do you lack confidence in using them effectively? Have you tried to create them and struggled when the data didn’t come across and display as expected?
Pivot tables and charts help you display data effectively on shared spreadsheets; using charts, slicers, timelines and added calculated fields is an efficient way of helping others to draw out the data they need?
By the end of the session, you will be able to confidently check for data entry issues, analyse your data faster than ever before, take advantage of pivot tables to simplify the presentation of your data, and use subtotals to summarise complex sheets.
Applicants must have a basic understanding of Excel, including knowing how to navigate cell references, different styles, create formulas and various keyboard shortcuts.
Laptops will be required for this course along with the relevant software installed.
Monday 21st July – 9.30am – 11.00am
Free
By the end of this program of learning, you will know:
How to apply best practices associated with arranging data in a spreadsheet
How to find & fix inputting errors
How to create pivot tables to summarise & analyse data
How to use format, layout & design options within pivot tables and charts
How to utilise the power of slicers & timeline filters
How to insert a calculated fields in to a pivot table
Applicants must have a basic understanding of Excel, including knowing how to navigate cell references, different styles, create formulas and various keyboard shortcuts.
Laptops will be required for this course along with the relevant software installed.
ALX Training
We are a team of experienced IT Trainers & Software Adoption Specialists who deliver creative design-led learning to private & public sector organisations.
Driven by our clients’ needs, we help organisations realise the full potential of their IT investment.
ALX Training is part of BDO Jersey, working closely with BDO Advisory and C5 Alliance to help businesses and people succeed