How To Change The Default Number Of Sheets In Excel
January 2, 2021
In this article, I will show you how to change the default number of sheets in Excel. I will also introduce you a great tool to create as many sheets as you want.
Read More »
How to Hide Excel Sheet so it can’t be Found easily
December 24, 2020
In this article, I will show you 3 ways to make Excel sheets very hidden. They are Manually Hiding Sheets, Tweaking Page Properties and Disabling “Show sheet tabs”, respectively.
xlSheetVeryHidden VS xlSheetHidden in Excel
December 24, 2020
In this article, I will show you how to use the “Visible” property and VBA script to play around with it. There are 3 options for “Visible” property.
How to Enable Developer tab in Excel?
December 23, 2020
In this article, I will show you one of the VBA 101 skills – enabling Developer tab. With Develop tab, you get access to a bunch of new commands that allows you to work with VBA.
How to Get Unique Values Without Unique function?
December 23, 2020
I will show you how to get unique values without unique function, by a standard formula or an array formula. Here is the perfect substitute for Unique.
How to Compute IRR in Excel (Basic to Advanced)
December 22, 2020
Excel comes with great tools to compute the IRR on an investment. We are going to show you 3 methods in computing IRR and their limitations.
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)
