Logical Operations — Data Analysis and Visualisation with Microsoft Excel® and Power BI
Exam
Exam fees included
Course code
davepbi
Course pricing varies based on delivery method and location.
Why choose Firebrand
150,000 +
professionals trained worldwide
25+
years of delivering accredited IT training
Top 20
IT training company globally
70%
of learners return for another course
What you’ll learn
On this Logical Operations Data Analysis and Visualisation with Microsoft Excel® course, you’ll learn to analyse data sets to find issues, insights and opportunities, and to effectively present and communicate the findings in visually compelling ways using Microsoft Excel. In addition to this course, you will also learn to apply all the skills learnt to PowerBI.
You’ll analyse and visualise data utilising the tools provided by Microsoft Excel and associated products.
You’ll also learn to:
Present visual insights with dashboards in Excel
Perform statistical analysis
Model and analyse data with Power Pivot
Apply skills to PowerBI
At the end of this course, you’ll achieve your Logical Operations Data Analysis and Visualisation with Microsoft Excel® certification. Through Firebrand’s Lecture | Lab | Review method, you’ll access official courseware, learn from certified instructors, and train in a distraction-free environment.
Audience
This course is ideal for those who already have a foundational knowledge of Microsoft Excel and wish to learn:
Advanced data and statistical analysis with Microsoft Excel using PivotTables
Tools such as Power Pivot and the Data Analysis ToolPak to analyse data
How to visualise data and insights using advanced visualisations in charts and dashboards in Excel
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
Module 11: Applying the skills to PowerBI
Prerequisites
Before attending this course, you should have foundational knowledge of Microsoft Excel.
Exam info
Although this course doesn't have an exam, delegates can achieve a Digital Badge by completing the Assessment for Digital Credential Online via the Logical Operations Choice Platform.
70% of our customers return to book more training. Here's why.
Interested in this course?
Speak to one of our learning advisors for information on upcoming course dates, pricing, delivery options and team training.
No obligation • Free consultation
Talk to a Firebrand expert
Get personalised guidance from our learning advisors and discover the best way to achieve your training goals.
- Course recommendations
- Flexible training options
- Team and private delivery available
FAQs
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.
Train your team
Since 2001 we’ve trained 135,000+ employees from thousands of large and small organisations, saving them more than one million hours in training time.