Category: How-to's

Count "Mondays" Between Two Dates

Formulas, How-to's

Hi there,


In this post, we will discuss about "How to find the number of specific days between two given dates?". Specific days is nothing but weekdays. 

Eg: Howmany Sundays are there between two given dates? If you have a solution, stop reading this post and update your answers in the below given comments section.

If you have less time to explore here you go for a quick solution.

 

A great cartoon face is really exists..!
 

FUNCTIONS USED:

Full story »

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 reading next phrase and update your idea with us using below comments section. Rest all can continue with me.

 

Before get into the post, as mentioned here, I will demonstrate for one time zone and rest of them you can try at your work place, because same logics will be followed for the rest. I hope you will have a question now, How many TimeZones we Have? . This is your homework. &#59;)

Full story »

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?

 

How to Import/Export Favorited features in Quick Access Toolbar


We all know Quick Access Toolbar will help us to quickly identify the most used features once we add it to QAT. If we are using different systems like office / personal it is difficult to manage them once we are used to follow one method.

To avoid such instances, we can download and move the customized QAT to any other system using below route.

 

IMPORT/EXPORT QAT:

Full story »

How to Filter Bold Cells in Excel?

How-to's, Excel Tips

Hi there,

 


Today, I had a little logical challenge. That is, I have an excel sheet with few cells bolded. The client needs me to filter the data based on bold cells. Because client wants to analyze only bold items and provide some stats to his boss. He gave me very less time and the data is almost big.

 

I spent an expensive time on this report and came up with a simple logic. It might help you as well. So, sharing with you.


I find it very challenging, because this is the first time I came across. And, we do not have a direct feature to click and get it done. However, I cracked this challenge using ...

 

The logic used is FIND & REPLACE option.

 

HOW FIND & REPLACE WILL FILTER BOLDED CELLS?

Full story »

Microsoft Excel cannot open or save any more documents

How-to's, Applications

Hi there,


 


I have installed Office 365 in my professional laptop. And, I started opening the files which I prepared using Excel 2010. You don't believe, I was popped up with a very big dialog box like this.

 

Excel Error: Microsoft Excel Cannot Open or Save any more documents
 

I really felt very challenging to get rid of this message for almost 10 - 15 days. Finally, one day a spark happened in my professional life is that all the excel files started opening ( of-course one by one).

 

DID I DO ANYTHING ON THIS?

Full story »

Documentation for Excel Functions (2003, 2007, 2010, 2013)

Formulas, How-to's, Learn Excel, powerpivot

Hi there,

 


In my previous post, List of Excel Functions, I have listed all Excel Functions irrespective of versions (since 2013). But, I haven't provided description to all of the functions because there are almost 461 Excel Functions available. It is time consuming. So, I just found the descriptions in the microsoft website so thought it will be very useful for you (like me).

 

Before giving you the link, here are the number of functions available in each branch.


No of Functions Belongs to 
38 Compatible Functions
07 Cube Functions
12 Database Functions
24 Data and Time Functions
54 Engineering Functions
55 Financial Functions
20 Information Functions
09 Logical Functions
19 Lookup & Reference Functions
79 Math & Trigonometry Functions
104 Statistical Functions
37 Text Functions
03 Web Functions


 

 

 

 

 

 

 

 

 

 

 

 

Full story »

Contact / Help. ©2017 by Abhilash VK. Design & icons by N.Design Studio. Skin by Tender Feelings / Evo Factory.