Looking for Global training? Go to https://firebrand.training/en or stay on the current site (Belgium)
Part of the BPP Education Group
(0)2 234 77 05
Logical Operations - Data Analysis and Visualisation with Microsoft® Excel®
Overview
On this accelerated Logical Operations Data Analysis and Visualisation with Microsoft Excel course, you’ll learn to analyse data sets to find issues, insights and opportunities. You will then learn how to effectively present and communicate the findings in visually compelling ways using Microsoft Excel.
In just 2 days, you’ll analyse and visualise data utilising the tools provided by Microsoft Excel and associated products, among other skills you’ll learn to:
- Present visual insights with dashboards in Excel
- Perform statistical analysis
- Model and analyse data with Power Pivot
Through Firebrand’s Lecture | Lab | Review methodology, you’ll get access to official courseware and learn in a distraction-free environment.
Audience
This course is ideal for those who already have a foundational knowledge of Microsoft Excel who wishes to learn:
- Advanced data and statistical analysis with Microsoft Excel using PivotTables
- To use tools such as Power Pivot and the Data Analysis ToolPak to analyse data
- To visualise data and insights using advanced visualisations in charts and dashboards in Excel
Benefits
Other accelerated training providers rely heavily on lecture and independent self-testing and study.
Effective technical instruction must be highly varied and interactive to keep attention levels high, promote camaraderie and teamwork between the students and instructor, and solidify knowledge through hands-on learning.
Firebrand Training provides instruction to meet every learning need:
- Intensive group instruction
- One-on-one instruction attention
- Hands-on labs
- Lab partner and group exercises
- Question and answer drills
- Independent study
Curriculum
- Module 1: Data Analysis Fundamentals
- Module 2: Visualising Data with Excel
- Module 3: Analysing Data with Formulas and Functions
- Module 4: Analysing Data with PivotTables
- Module 5: Presenting Visual Insights with Dashboards in Excel
- Module 6: Creating Geospatial Visualisations with Excel
- Module 7: Performing Statistical Analysis
- Module 8: Getting and Transforming Data
- Module 9: Modeling and Analysing Data with Power Pivot
- Module 10: Presenting Insights with Reports
Exam Track
There is no exam for this accelerated course.
What's Included
Your accelerated course includes:
- Accommodation *
- Meals, unlimited snacks, beverages, tea and coffee *
- On-site exams **
- Exam vouchers **
- Practice tests **
- Certification Guarantee ***
- Courseware
- Up-to 12 hours of instructor-led training each day
- 24-hour lab access
- Digital courseware **
- * For residential training only. Accommodation is included from the night before the course starts. This doesn't apply for online courses.
- ** Some exceptions apply. Please refer to the Exam Track or speak with our experts
- *** Pass first time or train again free as many times as it takes, unlimited for 1 year. Just pay for accommodation, exams, and incidental costs.
Prerequisites
Before attending this accelerated course, you should have:
- Baseline skill using Excel worksheets
- Knowledge of creating Excel workbooks with formulas and functions
- Additional workplace skill with Excel (highly recommended, not necessary)
Unsure whether you meet the prerequisites? Don’t worry. Your training consultant will discuss your background with you to understand if this course is right for you.
Reviews
Here's the Firebrand Training review section. Since 2001 we've trained exactly 134561 students and asked them all to review our Accelerated Learning. Currently, 96.53% have said Firebrand exceeded their expectations.
Read reviews from recent accelerated courses below or visit Firebrand Stories for written and video interviews from our alumni.
"I recommend Firebrand Training Sessions since it is concentrating on the core information and save precious time for attendees."
Anonymous (20/6/2022 (Monday) to 24/6/2022 (Friday))
"I recommend Firebrand Training Sessions since it is concentrating on the core information and save precious time for attendees."
Anonymous (20/6/2022 (Monday) to 24/6/2022 (Friday))
"A great learning experience."
Alan Crowdy, GNS . (5/12/2019 (Thursday) to 7/12/2019 (Saturday))
"Firebrand is providing me with a condensed training always fitting my tight timetable with a high success rate on the certification."
Anonymous (5/12/2019 (Thursday) to 7/12/2019 (Saturday))
"Good training. I have learned very much in a short time."
Frank Lute. (19/11/2018 (Monday) to 21/11/2018 (Wednesday))