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

Advanced Formula

  • Home
  • Posts
  • Advanced Formula
Convert Numbers to Words in Excel
Posted inPower of Microsoft Office

Convert Numbers to Words in Excel

NumberToWords is a significant custom Excel function in the toolbox of Accounting and Finance folks. It helps them to write numeric monetary values in words.
Read More
Posted by By Mohammed Barakat March 19, 2022Posted inPower of Microsoft OfficeNo Comments
Building a Custom WeekdayName Function in Excel
Posted inPower of Microsoft Office

Building a Custom WeekdayName Function in Excel

Building a custom WeekdayName function in Excel using the Advanced Formula Environment.
Read More
Posted by By Mohammed Barakat February 26, 2022Posted inPower of Microsoft OfficeNo Comments
Count a Weekday between Two Dates in Excel
Posted inPower of Microsoft Office

Count a Weekday between Two Dates in Excel

Building a custom function in Excel's Advanced Formula Environment to count a specific weekday between two dates.
Read More
Posted by By Mohammed Barakat February 26, 2022Posted inPower of Microsoft OfficeNo Comments
Excel Tip: Count a Weekday between Two Dates
Posted inPower of Microsoft Office

Excel Tip: Count a Weekday between Two Dates

How many Sundays are there between 2/19 and 5/22/2022? Have you ever been faced with such a question during one of your data analysis tasks? Unfortunately, there’s no native function…
Read More
Posted by By Mohammed Barakat February 20, 2022Posted inPower of Microsoft OfficeNo Comments
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 2025 — Excellence Made Easy. All rights reserved. Sinatra WordPress Theme
Scroll to Top
Go to mobile version