How To Extract Images From Excel In 1 Minute
February 22, 2021
When we have to archive the content, very often we also want to extract the photos out from Excel into separate files in a folder. How to do that?
Read More »
Every shortcut for sort and filter in Excel
February 3, 2021
In this article, I am going to show you every single shortcut for sort and filter commands.
2021 New Year Resolution List for Excel
January 26, 2021
Time to think about what to learn in Excel for 2021? We lay out 6 goals, divided by your level of expertise on what we think are great goals to further yourself in Excel!
5 Types of Graphs to Create with REPT function
January 20, 2021
Only a few Excel users know about that we can create graphs with REPT function. Most people use the REPT function simply to repeat characters but the REPT function actually does much more than that. Some people think the REPT
How to Show Zeros as Blank Cells In Excel
January 12, 2021
Background Zeros are almost inevitable in a workbook. Sometimes you may change the appearance of the zero. Do you have the following ask? Display zero as blank cells Show zero as dash Hide zero without actually deleting zero In this
How to Create Drop Down List with Color (Excel)
January 12, 2021
I have a drop-down list and I want the cell to be formatted to a specific color depending on the selected value. Numerous Excel users From time to time, I get this questions from my followers on Instagram. They want
Categories
.
- Array Formula (3)
- Data validation (3)
- Excel Formula & Functions (34)
- Excel Skills (37)
- Excel Tips and Tricks (38)
- Finance (5)
- Formatting (8)
- Option Pricing (3)
- Pivot table (3)
- Sharing (8)
- Shortcuts (13)
- Solver (1)
- Technical (6)
- VBA (18)
