Mastering Data for Business: Leverage Excel for Strategic Insights, Drive Growth
  • Case Studies
  • Data Challenge
  • Our Courses
  • Our Customers
  • Testimonies
  • Contact Us
  • Case Studies
  • Data Challenge
  • Our Courses
  • Our Customers
  • Testimonies
  • Contact Us
  • New year 2021 resolution starts now

    #business #sales #marketing

    read more

    You May Also Like

    What is Business Data?

    February 12, 2020
    3-Major-Difference-between-Pivot-Table-and-Power-Pivot-Table

    3 Major Difference between Pivot Table and Power Pivot Table

    February 27, 2020

    Is it worth it?

    June 1, 2020
  • Easy to create

    read more

    You May Also Like

    Finding a Public Health Preparedness Clinic near you with an interactive map

    February 19, 2020

    3 reasons why I created an interactive map chart

    February 20, 2020
    re-certification report

    How to create a re-certification report

    May 14, 2020
  • Checkpoints are important

    read more

    You May Also Like

    New year 2021 resolution starts now

    December 22, 2020
    3-types-of-bgr-you-can-find-in-databases

    3 Types of BGR you can find in Databases

    March 2, 2020

    One Step to Data Analytics from Excel

    October 6, 2020
  • What is a good visual

    This visual is good to look at. But it is not practical. In fact, it is disruptive to analysis because the flow of information “jumped”. A good visual should be easy and quick to understand, within a few seconds of looking at it. The visual should flow with the analysis. In this visual, even though the presentation is to show the distribution of the views among the different age groups, the 2 bar charts (represented by 2 different colours) are drawn with different scales. By presenting them together, it gives the impression that the purple bar is more than the green bar. But in actual fact, it is less than…

    read more

    You May Also Like

    3 New Ways to present a Hair Salon Sales Dropped by 50% in Excel

    February 25, 2020

    High Expectation

    June 2, 2020
    3-Major-Difference-between-Pivot-Table-and-Power-Pivot-Table

    3 Major Difference between Pivot Table and Power Pivot Table

    February 27, 2020
  • Pivot Table with Percentage of Sales

    I was reviewing the video recording of our course “Grow Your Profit Through Data Analytics and Data Modelling” and this feature was highlighted. Do you know that you can present the Monthly Sales and % of Sales side by side as you see in the picture? Not many people know of this function. If you know, that’s good. If you don’t, you can learn about it in our course “Grow Your Profit Through Data Analytics and Data Modelling“.

    read more

    You May Also Like

    Easy to create

    December 10, 2020

    Arrow or Dart?

    October 6, 2020

    You have 3 options

    February 21, 2020

Our Courses

Unleash the Power of Excel in Procurement and Supply Chain Management. Join our Masterclass to Drive Growth and Gain Strategic Insights.
Learn Excel with a goal in mind. With a specific goal, it is easier to remember what you learn and apply the functions to your work. This is how we have designed Hidden Secrets of Data Analysis in Excel
© 2007-2025 everydayExcel Business Lab Pte Ltd
ashe-child Theme by Jason Khoo.