Excel

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

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

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

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

Consolidate Tens of Sheets in One Step

Consolidate Data from Multiple Sheets into one Consolidation is a common task we perform in Excel. By consolidation I mean, we have multiple worksheets and, in each sheet, we have a certain list with ...

Adding a Different Look To Your Interactive Dashboard

Code for Interactive Dashboard Course This code Changes the Background in 4 different colors Switch to the Visual Basic ALT + F11 Insert a Module ALT >I>M Copy and Paste the codes here below the...