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