Microsoft Excel: Data Management & Analysis
This course is for those conducting modelling and analysis using Microsoft Excel and are now looking to expand their knowledge. In this course you will learn tips and shortcuts to aid you in achieving efficient and effective analysis while improving your proficiency in Excel.
Description
Microsoft Excel is the most commonly used analytics software. Many analysts will have used Excel at some point in their education or careers, but most will not have had a systematic introduction to managing data and conducting analysis. This course is designed to provide the vital skills to plan data input, conduct data validation and effectively model in excel. Attendees will learn hints, tips, and shortcuts for efficient and effective analysis to improve their proficiency in Excel.
2023 Online Platform and Software Requirements
Computer with video camera, speakers and microphone
Stable internet connection
Mains power
Zoom - This course can only be accessed via the desktop version of Zoom, so if necessary please submit a request with your IT team to download Zoom in advance. Alternatively, use a personal computer to attend this course.
Microsoft Excel 365
2023 Prior knowledge
There are no pre-requisites for this course.
2023 Topics
The topics covered on day one concern Excel data input:
Planning data input in Excel
Advanced data validation in Excel
Conditional formatting and dates
Present a worksheet for data input in excel
The topics covered on day two concern Excel data analysis:
Foundational skills and concepts in data analysis in excel
Applying frequency to continuous data and creating a column chart
Sorting and filtering data in Excel
Single criteria analysis in Excel
Multiple criteria analysis in Excel
Powerful data analyses with database formulae
2023 Course goals and outcomes
Data analysis in the latest version of Excel
How to plan data input in Excel
Data validation within Excel
Foundational skills and concepts in data analysis in Excel
Conducting a range of analyses within Excel
Hints, tips, and shortcuts for efficient and effective analysis
2023 Audience
The course is designed for analysts or anyone who is conducting modelling and analysis using Microsoft Excel. Attendees might have previous experience with Excel and are now looking to expand their knowledge.
2023 Other related courses to continue your development...
Microsoft Excel: Familiarisation & Modelling
Microsoft Excel: VBA Automation
2023 Learning objectives
By learning tips and shortcuts you will achieve efficient and effective analysis in a shorter space of time.