This one day course will provide you with a thorough understanding of the analysis, format and presentation of data using excel via pivotal tables, formulae, lookups and graphics.
This course is designed for individuals who already have foundational knowledge and skills in Excel and are ready to advance their data analysis skills and abilities through the application of advanced Excel functionality such as advanced formula creation, tables, charts, PivotTables and PivotCharts.
Prerequisites Before taking this course, students are recommended to take the following course, or have equivalent knowledge: • Microsoft Excel Introduction
Instructor led, group-paced, classroom-delivery learning model with structured hands-on activities.
Upon successful completion of this course, students will be able to:
• Create advanced formulas.
• Analyse data with logical and lookup functions.
• Organize worksheet data with tables.
• Visualize data by using charts.
• Analysing data with PivotTables, slicers, and PivotCharts.
• Insert graphic objects.
• Enhance workbooks
DATE: 5th JULY 2019
LOCATION: whitehaven, CUMBRIA
The Course fee includes, Excel manual (2016 edition), Lunch and other refreshments.
There are no exams or qualification associated with Excel for Managers
All delegates will be issued with an attendance certificate