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

Month: March 2012

  • Home
  • 2012
  • March
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
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
October 14, 2023
Transforming the Tedious: Streamlining Reconciliation Process by Automating R Script
September 14, 2023
Text-to-Rows with Power Query
September 15, 2022
Process Capability Calculator: Leveraging the Power of R Language and…
July 30, 2022
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
My Library at LibraryThing
Copyright 2024 — Excellence Made Easy. All rights reserved. Sinatra WordPress Theme
Scroll to Top
Exit mobile version