Start by learning the basics of Data Analysis with Excel, such as formulas, functions, and PivotTables. Then, explore how to effectively convey data insights through visual aids.
This intensive 1 day, hands-on course is part 3 days Data Analysis and Visualisation with Excel PRO course and will introduce you to basics of Data Analysis and will help you gain comprehensive, practical understanding of Data Analysis using Excel.
Analysing data to find issues, insights, and opportunities is now a critical part of many job roles. Beyond the analysis, data analysts in all job roles must be able to effectively present and communicate their findings in visually compelling ways.
You will gain a fundamentals of performing data analysis, visualise data with Excel, analyse data with formulas and function, and PivotTables.
This course is suitable for anybody wanting to learn any version between 2007 and latest 2021. Our courses cover all differences between the versions.
£218.00
Data Analysis and Visualisation with Microsoft Excel Introduction Course Content:
Upon successful completion of this course, students will be able to:
Instructor led, group-paced, virtual classroom-delivery learning model with structured hands-on activities.
This course is designed for students who already have foundational knowledge and skills in Excel and who wish to perform robust and advanced data and statistical analysis with Excel using PivotTables, use tools such as Power Pivot and the Analysis ToolPak to analyse data, and visualise data and insights using advanced visualisations in charts and dashboards in Excel.
To ensure success in Data Analysis and Visualisation course with Excel Introduction, you should have baseline skill using Microsoft Excel worksheets, particularly in creating workbooks with formulas and functions.
To meet this prerequisite, you can take any one or more of the following courses:
This course is one of a series of courses that addresses Microsoft Certified Application Specialist (Microsoft Business Certification) skill sets.
The Microsoft Certified Application Specialist program is for individuals who use Microsoft’s business desktop software and who seek recognition for their expertise with specific Microsoft products. Certification candidates must pass one or more proficiency exams in order to earn Microsoft Certified Application Specialist certification.
Don’t know which level you need to enrol?
We offer quick and free Excel assessment which you can find “here”. It would tell you your Excel level, as well as recommend courses you may take. You may also go by course pre-requisites section on each course page.
Yes, all of our courses come with certificate of completion. After you finish the course, we will send you your certificate through e-mail in 2-3 working days.
Of course, we pride ourselves in interactive and hands-on courses, so questions are welcome and encouraged during the course.
Yes, after the course we provide a variety of post-course support documents so you may revisit the content in your own time, as well as providing 12 months support via e-mail.
Our company prides itself on quality of our courses, and that would not be possible with exceptional trainers! We employ tutors with both practical and teaching experiences, making sure they have specialist knowledge. We are happy to provide references and their profiles on demand.
For Microsoft Office courses you would need a computer with full version of the software you are training in. We also strongly recommend having access to a second screen for the training. This will allow you to do the exercises on your primary laptop or computer and see the virtual whiteboard on a secondary device. That device can be anything from a separate computer screen, to something like a tablet or phone.
