Skip to the content
STL - Blog
Best in-class training – Be delighted, not just satisfied
  • STL Home
  • Blog home
  • Professional & Management
    • Leadership Development
    • Management Training
    • Professional Development
    • Project Management
    • Sales & Customer Service
    • Soft Skills
  • Application
    • Artificial Intelligence
    • Hints & Tips
    • Microsoft Office
      • Access
      • Copilot
      • Excel
      • Excel Data Visualisation
      • MS Project
      • Office 365
      • Outlook
      • PowerPoint
      • VBA
      • Visio
      • Word
    • Microsoft Office Resources
    • Power BI
  • Misc
    • Infographic
    • Technology
    • Fun
    • Company News
  • About us
  • Contact us
  • STL Home
  • Blog home
  • Professional & Management
    • Leadership Development
    • Management Training
    • Professional Development
    • Project Management
    • Sales & Customer Service
    • Soft Skills
  • Application
    • Artificial Intelligence
    • Hints & Tips
    • Microsoft Office
      • Access
      • Copilot
      • Excel
      • Excel Data Visualisation
      • MS Project
      • Office 365
      • Outlook
      • PowerPoint
      • VBA
      • Visio
      • Word
    • Microsoft Office Resources
    • Power BI
  • Misc
    • Infographic
    • Technology
    • Fun
    • Company News
  • About us
  • Contact us

Data Visualisation Resources

Learn techniques for creating impactful and visually appealing data visualisations in Excel to communicate insights effectively.

  • Create Stunning Charts in Excel and Impress Your Clients

    Create Stunning Charts in Excel and Impress Your Clients

    Fri 17 May 2024

    Data can be a powerful tool for driving business decisions, but a ‘sea of totally unrelated data’, when presented, can confuse your audience. However,  you can make a huge impact by  presenting that data clearly, using captivating visuals that tell a compelling story. This guide will equip you with the skills to leverage the data […]

  • Streamline Data Analysis with Excel Dynamic Arrays Feature

    Fri 1 Mar 2024

    In Excel 365 and Excel 2021 Microsoft has provided Excel users with some new features which will fundamentally change the way worksheets are designed. Dynamic array formulas allow you to work with multiple values at the same time in a formula. Dynamic arrays solve some challenging difficulties in Excel and will be a feature which […]

  • Power BI – Dynamic Text for More Detailed Reports

    Tue 30 Jan 2024

    Visualising data is crucial for decision making in any industry. Power BI reports are a brilliantly efficient way to achieve this, as users have several useful visual options. In this blog post you will learn how Power BI can display dynamic text for more detailed reports. We will be using examples of sales data and […]

  • How to Use Sparklines in Excel to Visualise Data Trends

    Wed 10 Jan 2024

    Sparklines are a powerful tool in Excel that allow you to visualise data trends in a condensed chart format. Unlike normal Excel charts, Sparklines are embedded in a single cell, making them ideal for displaying trends in sales figures, website hits, and other data over a period of time. In this blog post, we’ll show […]

  • Power BI – Advanced options to make forecasting models

    Tue 4 Apr 2023

    Finally, there are new advanced options to create forecasting models in Power BI. Microsoft introduced the LINEST function and LINESTX function in the Power BI desktop February 2023 version. The LINEST function in Excel has always been an important tool for perform linear regression, leveraging the Least Squares method, to calculate a straight line that […]

  • Power BI – Quick Measures

    Thu 16 Mar 2023

    Microsoft has prepared Power BI to make it easier for users to perform DAX measures without a lot of DAX knowledge. To access the Quick Measures, click QUICK MEASURES on the Home tab. You will see a list of options to choose from. On the right side of the Quick Measure dialog box, you will […]

  • Let your Data tell the Story with Power BI

    Fri 25 Nov 2022

    Tired of interrupting your PowerPoint presentation just so that you can show the live version of your report in Power BI? You can now create interactive PowerPoint presentations which connect live to your Power BI reports! This blog will show how you can let your data tell the story with Power BI. Imagine that you […]

  • Maximise Data Performance with Data Modelling in Power BI

    Tue 27 Sep 2022

    Today, I’m talking with Martin, one of STL‘s outstanding Power BI trainers, about the importance of Data Modelling. I’m asking Martin how I can maximise my data’s performance with data modelling in Power BI. Hi Martin, thanks for taking the time to have a chat with me. My Power BI Reports often take ages to […]

  • Power BI AI Visuals Part 3 – Decomposition Tree

    Thu 22 Sep 2022

    Microsoft has created interesting and engaging AI (Artificial Intelligence) visuals for Power BI. The desktop app offers four AI visuals – Q&A, Key Influencers, Decomposition Tree, and Smart Narrative. This is Power BI AI Visuals Part 3 – Decomposition Tree, the third in a series which looks at all four AI visuals. AI visuals are […]

  • Power BI Artificial Intelligence Visuals Part 1 – Q&A

    Thu 15 Sep 2022

    Microsoft has created some very interesting AI (Artificial Intelligence) visuals for Power BI. Power BI offers four AI visuals – Q&A, Key Influencers, Decomposition Tree, and Smart Narrative. This article is Power BI Artificial Intelligence Visuals Part 1 – Q&A. It is the first in a series of 4 which will go through all four […]

  • Automate reports with Power Query M Coding

    Tue 13 Sep 2022

    This blog is for both Power BI and Excel users. In it, we demonstrate how you can automate reports with Power Query M coding What is Power Query? The Power Query tool in Excel and the Query Editor in Power BI are identical. They are important tools for both applications. In Excel, many tasks can […]

  • Comparing Power BI Desktop to the Power BI Service

    Tue 9 Aug 2022

    The different versions and configurations of Power BI can be confusing. In this blog, we are comparing Power BI Desktop to Power BI Service. This will shed light on how to use each of these apps. Power BI Desktop Power BI Desktop is a free application you can download and install on your local PC. […]

  • Create Field Parameters in Power BI

    Tue 26 Jul 2022

    Why is Power BI taking over the world? Why are so many organisations currently implementing Power BI? Power BI is the most efficient tool to manage business intelligence in a world where the data sets are getting bigger and bigger. The importance of making quick and correct decisions is a key factor in running a […]

  • How to Efficiently Cleanse and Reshape Data in Power BI

    Fri 22 Jul 2022

    You can improve efficiency and accuracy when pulling and transforming data from various sources by using the Query Editor Tool in Power BI. It’s a marked improvement on using macros in Excel for this function. Read on to see why. Why use the Query Editor The Query Editor is where data sourced from a variety […]

  • The Pros and Cons of Power Query

    Mon 11 Jul 2022

    In conversation with one of our Excel / Power BI trainers. In this post, we sit down with one of our training delivery team to look at the pros and cons of Power Query in Excel, as a new way of working with data. Jens, how would you describe Power Query in Excel in one […]

  • Increase Productivity with Power BI’s new Navigator Tools

    Mon 4 Jul 2022

    In this article we will introduce you to Power BI’s new Navigator tools used to enhance the functionality and appearance of your multi-page reports. If you use the app, this will help you increase productivity with Power BI’s new navigator tools. The scenario So, you’ve got your data all ready to be made into visuals […]

  • Excel or Power BI. Which is better for business reporting?

    Fri 11 Feb 2022

    (In conversation with Jens, one of our Excel/Power BI trainers) In this post we sit down with one of our training delivery team, Jens, to look at the pros and cons of Excel and Power BI when considering which reporting path is best for you and your organisation. Jens, you mentioned a frequently occurring question […]

  • Power BI usage

    Everybody should be using Power BI – 10 Reasons Why

    Mon 26 Apr 2021

    What is Power BI? Perhaps you have heard it said that everybody should be using Power BI. But what is it, exactly? Power BI is a collection of software services, apps, and connectors. These work together to turn unrelated data sources into coherent, visually immersive, and interactive insights. The application consists of several elements that […]

  • Maximising The Use Of Collected Business Data

    Fri 10 Jan 2020

    There’s a reason why firms spend millions investing in data sets or in curating their own data recovery and organisation methods. Maximising the use of collected business data is an important proofing system required at every stage of your decision-making process . Statistics and an informed look at results will always be your friends. If […]

  • 5 reasons to switch reporting from Excel to Power BI

    Thu 20 Jun 2019

    For many years, Microsoft Excel has been the tried and tested reporting tool for many businesses. In 2019. more and more organisations are turning to Power BI as an alternative with its strong analytics and reporting functions.     With faster visualisations, statistical functions and calculations across broad datasets, it’s obvious that Power BI can […]

  • 8 Major Benefits of Microsoft Power BI You Must Know

    Having the right business intelligence at your fingertips is crucial in the drive to become agile and competitive. As businesses grow, it becomes increasingly difficult to manage data being generated regularly. With a siloing effect and biased reporting structures, it leads to the decision makers in business to make their judgement on data that may […]

  • Benefits of Using Power BI 

    Wed 30 Jan 2019

    Power BI is Microsoft’s powerful business intelligence tool. It’s a fantastic tool for visualising data, offering a range of benefits for analysts who want to be able to present their information in a more digestible way. Of course, there are other tools for visualisation, so why should you choose to use Microsoft Power BI instead […]

  • Forecasting in Excel 2016

    Fri 29 Jan 2016

    Forecasting is important in many circumstances to be able to do effective and efficient planning. The future electricity needs forecast vital to planning building more power stations; scheduling employees in a call centre next week requires forecasts of call volume; just imaging how much forecasting the planners behind London 2012 Olympic Games must have done. Forecasts can be needed months or years […]

  • Charts from a dropdown list

    Mon 14 Dec 2015

    Charts from a dropdown list in Excel Many people who use Excel can generate a chart or two on their spreadsheets. This is a relatively easy task to perform in Excel. These charts will either sit in data sheets or in their own sheets. Don’t you sometimes wish you had a button to click in Excel […]

  • What’s New in Excel 2016?

    Thu 9 Jul 2015

      Here’s what’s New in Excel 2016 With the launch of Office 2016 in the Autumn of 2015, you may be wondering about the new features in 2016 and what’s changed. With Excel at the core of many businesses, it would help to have all of the new features explained. We have compared the different versions of […]

  • Data Visualisation in Excel

    Data Visualisation in Excel

    Thu 21 May 2015

    By Ann K. Emery With an estimated user base of 500 million people worldwide, many of us use Excel at work and personally for home budgets, projects, to-do lists, and more. It doesn’t take too much use of Excel before you reach the point of trying to express your data visually. This is where Excel charting […]

26 posts in this category.

 

Training courses

Blog Categories

Consent preferences

TrustPilot Score

TrustScore 4.9   |   2367 reviews

TrustPilot Testimonials

Trustpilot

© 2025 STL – Blog

Powered by WordPress

To the top ↑ Up ↑