Blog

Blinking Conditional Formatting in Excel

Conditional Formatting is widely used in Excel and it enables us to change Font characteristics and Cell Fill color when a condition is met. In this tutorial I show you how I apply a Blinking Conditio...

Numbering Records Dynamically in Excel… 18 Different Work Situations

Unlike other Microsoft Office programs, Excel does not provide a button to number data automatically. Adding serial numbers manually is a pain. Moreover, they will be static and will not renumber auto...

Create a Stopwatch or a Countdown Timer in Excel… Step By Step

How to Create a Timer or a Countdown in Excel… Very Useful Creating a Timer/Stop watch in Excel Professionals who are used to organizing their lives in Excel at some point wish Excel could include a t...

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...