Logical Operations Data Analysis and Visualisation with Microsoft Excel®

What you'll learn

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

Curriculum

10 modules

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

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)

Exam info

Although there is no exam for this accelerated course, delegates can achieve a Digital Badge by completing the Assessment for Digital Credential Online via the Logical Operations Choice Platform.

Course Dates

Sorry, there are currently no dates available for this course. Please submit an enquiry and one of our team will contact you about potential future dates or alternative options.

FAQs

4 question

Yes, we do provide courses suitable for beginners. However, Firebrand's accelerated courses aren't easy and it's essential that you are interested and actively pursuing a career in IT.

Traditional training providers usually run their courses from 9am to 5pm. At Firebrand Training we maximise the number of learning hours to minimise the number of training days, so you’ll be back to your job as quickly as possible. You don’t waste time travelling to several courses and finding an exam centre after that.

Firebrand's accelerated courses are constantly reviewed. We ask our delegates for feedback after every course. We are official partners with leading vendors and therefore, we're provided with certification changes and updates, which we can then implement in our course delivery at a very early stage. This feedback is then analysed in view of changes or discrepancies. We will then address the topics mentioned and have a panel of subject matter experts provide us with valuable suggestions for improvement and solutions.

If you need to learn new skills and you want to be able to put them into practice quickly, then Firebrand is the right training company for you.

Our unique accelerated training method means that we are your fastest way to learn. By delivering training for up to 12 hours per day, seven days per week, with exam centres on-site, we ensure that you are trained and certified quicker than anywhere else, having spent less time out of the office away from the day job.

Can't find the answer you're looking for?

Our expert learning advisors are ready to help. Whether you need course recommendations, have technical queries, or want to discuss your learning goals, we're just a message away.

Related courses

All Logical Operations Courses

Train your team

Since 2001 we've trained 134,561 employees from thousands of large and small organisations, saving them more than one million hours in training time.

Learn More