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

Posts

  • Home
  • Posts
  • Page 5
Posted inData Science Power of Microsoft Office

Categorization of Students Grades using INDEX and XMATCH in Excel

Posted by By Mohammed Barakat October 14, 2023
Continue Reading
Posted inData Science R Programming

Transforming the Tedious: Streamlining Reconciliation Process by Automating R Script

Posted by By Mohammed Barakat September 14, 2023
Continue Reading
Posted inPower of Microsoft Office

Text-to-Rows with Power Query

Posted by By Mohammed Barakat September 15, 2022
Continue Reading
Posted inR Programming

Arithmetic and Variable Assignment in R

Do you know how arithmetic operations are performed in R? Watch this video that shows how to perform basic arithmetic operations in R and how to assign values to variables.…
Read More
Posted by By Mohammed Barakat June 7, 2020Posted inR ProgrammingNo Comments
Posted inR Programming

R Data Structures – Vectors

Vectors are one dimensional arrays that can hold numeric, character, or logical data. Watch this video that shows how to create different types of vectors in R and how to…
Read More
Posted by By Mohammed Barakat June 7, 2020Posted inR ProgrammingNo Comments
Posted inR Programming

Data Types in R

Do you know what data types are used in R? Watch this video that explains the basic data types in R,  how to check their classes, and how to convert…
Read More
Posted by By Mohammed Barakat June 7, 2020Posted inR ProgrammingNo Comments
Posted inR Programming

A Quick Tour of RStudio Interface

Now you have R and RStudio installed in your machine, get a quick tour on RStudio main screen. https://youtu.be/ObaxP2x-goQ Register for the "Learning R Programming for Data Science" course to…
Read More
Posted by By Mohammed Barakat June 7, 2020Posted inR ProgrammingNo Comments
Posted inR Programming

Installing R and RStudio

Ready to start your journey to be a Data Scientist? Start off by getting introduced to R Programming Language. Do you know what R Language is, anyways? Watch this video…
Read More
Posted by By Mohammed Barakat June 7, 2020Posted inR ProgrammingNo Comments
Posted inPower of Microsoft Office

Excel Tip: Using Paste Special to Perform Simple Calculations

You can perform a simple calculation (division, multiplication, addition, or subtraction) on a list of numbers without the need to write formulas. Is this possible?! With Paste Special tool in…
Read More
Posted by By Mohammed Barakat March 12, 2012Posted 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
Posted inPower of Microsoft Office

Excel Tip: Calculate Difference in Hours between Two Dates

From time to time, people approach me with an Excel problem that looks easy to calculate while, unfortunately, there’s no straightforward solution to it. The problem is calculating the difference…
Read More
Posted by By Mohammed Barakat March 7, 2012Posted inPower of Microsoft Office10 Comments
Posted inPower of Microsoft Office Six Sigma

Interrelationship Digraph: PART TWO

In this part of “Interrelationship Digraph: Demystifying Complex Relationships” video I explain how we can use the Interrelationship Matrix to reflect results of the Interrelationship Digraph. I also show how…
Read More
Posted by By Mohammed Barakat February 27, 2011Posted inPower of Microsoft Office, Six SigmaNo Comments
Posted inPower of Microsoft Office Six Sigma

Interrelationship Digraph: PART ONE

Interrelationship Digraph or Relations Diagram is one of the seven Management and Planning Tools that helps us analyze the cause-and-effect relationships among different issues in a complex situation. It also…
Read More
Posted by By Mohammed Barakat February 27, 2011Posted inPower of Microsoft Office, Six SigmaNo Comments

Posts pagination

Previous page 1 … 3 4 5 6 7 Next page
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