Blog

Pivot Table and Pivot Chart in PowerPoint… Are You Serious?

Excel is a member of a big family called the Microsoft Office Suite of Applications, which includes among other members, PowerPoint and Word… Accordingly, they share a common Interface (the Ribbon and...

Recording Macros… Totally with Shortcuts

Uniquely Shortcuts… Recording Macro We all have Excel tasks that we perform repetitively. Each task may require tens of steps… Why waste your time, redoing the same steps, while you can record a macro...

Protect Your Data without any Codes… VERY Hidden is Much More Than Just Hidden

You can Download the Exercise File  by Clicking on the Button       The most valuable thing in your Excel Files is the data you create and store. sometimes, if it is viewed without auth...

Splitting Text at the Second Uppercase letter… Functions, Power Query and More

If you have a string of text, like a full name without spaces, and you want to split it into 2 columns: one for the first name and another one for the last name, you look for a pattern, like the chang...

Color Hundreds of Sheet Tabs in One Step in Different Colors

To Download the  exercise File and Follow along click Here       Here is the Code Sub ChangeColors() Dim WS As Worksheet Dim IndexColor As Long IndexColor = 50000 For Each WS In Workshe...

Create a Retirement Report using Functions, Advanced Filter, Dynamic Arrays or Power Query

Retirement Report using Functions, Dynamic Arrays and Power Query To get the best out of Excel, you need to combine the different functionalities together in achieving your goal. In this project, We h...

Create Banded Rows or Columns

Conditional Formatting Conditional formatting is a special type of formatting stored in memory. It pops up whenever a condition is met. This condition is a formula that returns in memory a TRUE. Today...

XLOOKUP vs INDEX & MATCH for a Dynamic Chart

Xlookup to create a Dynamic Chart First time ever… Chart Title drop List In this tutorial I show you how to use the new XLOOKUP function to create a dynamic chart in Excel that switches data depending...

Powerful Pivot Tables Hacks

A Common Pivot Table Problem The basic concept which led to today’s Pivot Tables, was invented by the American engineer Pito Salas in 1987. Since they were introduced into Excel 1993, Pivot Tables bec...