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

Excel

  • Home
  • Posts
  • Excel
  • Page 5
Posted inPower of Microsoft Office

Summarize your data with PivotTables

A PivotTable report is an interactive way to quickly summarize large amounts of data. In this video I will show you how to create a summary report using PivotTable in Microsoft…
Read More
Posted by By Mohammed Barakat January 24, 2011Posted inPower of Microsoft Office2 Comments
Posted inPower of Microsoft Office

Best practice to VLookup values in Excel

Vlookup is a function that helps you search for a value in a range of cells and return the same or a different value from that range on the same…
Read More
Posted by By Mohammed Barakat September 16, 2010Posted inPower of Microsoft Office6 Comments
Posted inPower of Microsoft Office

Customize Excel Ribbon and make your macros default commands

I believe that efficient use of Microsoft Office Excel has a tremendous effect on office work efficiency. With this blog I start a series of powerful tips and tricks that…
Read More
Posted by By Mohammed Barakat September 14, 2010Posted inPower of Microsoft Office20 Comments

Posts pagination

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