Skip to content
Excellence Made Easy

Start your journey towards excellence in the workplace by embracing process improvement and digitalization

  • Home
  • About
    • Mohammed Barakat
    • Projects Portfolio
    • Gallery of Achievements
  • Products & Services
    • Process Improvement in Practice
    • Learning R Programming for Data Science
    • Six Sigma Green Belt Examiner
    • Digitalization Services
  • Posts
    • Lean
    • Six Sigma
    • Power of Microsoft Office
    • Data Science
    • R Programming
    • Project Management
    • Personal Growth
  • Resources Hub
    • Six Sigma Cheat Sheets
    • Six Sigma Exam Paper
    • Six Sigma Body of Knowledge (BoK)
    • Researches with R Language
    • Top 20 R Libraries for Data Science
    • Process Capability Calculator
  • Glossary
  • Contact Us

Conditional Formatting

  • Home
  • Posts
  • Conditional Formatting
Creating a Heatmap using XLOOKUP and Conditional Formatting
Posted inPower of Microsoft Office

Creating a Heatmap using XLOOKUP and Conditional Formatting

Using XLOOKUP and Conditional Formatting to create a heatmap that gives a quick insight and a story to tell about COVID during 2021 around the globe.
Read More
Posted by By Mohammed Barakat March 4, 2022Posted inPower of Microsoft OfficeNo Comments
Posted inPower of Microsoft Office

Excel Tip: Using Conditional Formatting to Warn on Deadlines

Suppose that you manage a set of suppliers’ agreements which start and expire on specific dates. You need to be warned on the expiry of any agreement, say, 10 days…
Read More
Posted by By Mohammed Barakat March 8, 2012Posted inPower of Microsoft Office1 Comment
Categories
  • Data Science
  • Lean
  • Personal Growth
  • Power of Microsoft Office
  • Project Management
  • R Programming
  • Six Sigma
Categorization of Students Grades using INDEX and XMATCH in Excel
Categorization of Students Grades using INDEX and XMATCH in Excel
October 14, 2023
Transforming the Tedious: Streamlining Reconciliation Process by Automating R Script
Transforming the Tedious: Streamlining Reconciliation Process by Automating R Script
September 14, 2023
Text-to-Rows with Power Query
Text-to-Rows with Power Query
September 15, 2022
Process Capability Calculator: Leveraging the Power of R Language and Shiny Apps in Six Sigma
Process Capability Calculator: Leveraging the Power of R Language and…
July 30, 2022
Build Interactive Graphs with Pivot Charts in Excel
Build Interactive Graphs with Pivot Charts in Excel
July 24, 2022
Archives
  • October 2023
  • September 2023
  • September 2022
  • July 2022
  • May 2022
  • April 2022
  • March 2022
  • February 2022
  • July 2020
  • June 2020
  • March 2012
  • February 2011
  • January 2011
  • December 2010
  • September 2010
  • February 2010
  • April 2009
  • March 2009
  • February 2009
Follow me on Twitter
My Tweets
Reading List
Copyright 2024 — Excellence Made Easy. All rights reserved. Sinatra WordPress Theme
Scroll to Top
Go to mobile version