Search

IF Statement Wished Me (happy new year)

Formulas
Howdy,   =IF(YEAR(TODAY())=2016,"A VERY HAPPY AND PROSPEROUS NEW YEAR","")   :)   Thanks and see you again more »

Count "Mondays" Between Two Dates

Formulas, How-to's
Hi there, FORMULA: =SUMPRODUCT(--(TEXT(ROW(INDIRECT(end_date&":"&start_date)),"DDDD")="specific_day")) EXPLANATION: more »

Show Invisible Cell Content ( its Advantages)

Excel Tips
Hi there,   In this post, we will discuss about how to make the cell content invisible from other users until the user activate that cell. The cell content is visible only through formula bar. more »

Converting Time Zones using Excel (Quick tip)

Formulas, How-to's
Hello Howdy's   How are you doing today? Hope you are doing awesome. In this post, we will discuss about converting one time zone to another by using simple logic in excel. If you already have an idea on how to achieve this results, please pause read… more »

Office 2016 Doesn't have PowerPivot (by default)

Excel 2016, powerpivot
This post explains which version of Office 2016 has PowerPivot excluded / included. There will a stop to assumption of PowerPivot in all versions more »

Import / Export Quick Access Toolbar

How-to's
Hi there,   In this post, we will discuss on how to import/export Quick Access Toolbar. I mean, we can use the same favorites that we kept in QAT in one system (might be personal system) and on the other system (Office system as well). Howto?   We a… more »
Contact / Help. ©2017 by Abhilash VK. Design & icons by N.Design Studio. Skin by Tender Feelings / Evo Factory.