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