Category: Learn Excel

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 »

Create Dynamic DropDown using Excel DataValidation

Formulas, Learn Excel

Hi there,

 

Today, you will be mastering on how to create dynamic dropdown's using data validation feature in Excel. First question your mind throws out is what is Dynamic Drop Down (DDD) right? Yes, let me start answering to it, first.

 

Say, we have 3 countries with few number of states for each country. This data needs to be updated in an Excel when you are working on country wise data or state wise data. So, updating the matching states to each country is quite a tidious process and lot of remembering power is required. 

Full story »

How to do Chatting in Excel? WOW!

Learn Excel, Applications

Hi there,

 

Do you know we can interact or chat in Excel? A group of members can chat in Excel application and share ideas with each other and do trainings online and bla bla blaa.... We can do many things using this feature. If you know what I am speaking about then please do post your valuable answers using the below comments section before proceeding to the post. 

Funny Chatting!!! :)


If you are done posting your comments then, step with me to see what exactly I am speaking about. If you do not know, no issues, just follow with me.

Full story »

FACEBOOK in EXCEL

Learn Excel, Applications

Hi there,



Firstly, I want to ask, Are you a fan of FACEBOOK?

or

Are you a fan of EXCEL?

or

Are you a fan of both FACEBOOK and EXCEL?


that's great if you are a fan of both like me. I am crazy about both. For all who loves either of them or both will have a DOUGHNUT today. And, after revealing this trick you will definitely post back to me in the below comments saying "Awesome".


Let's see how many of them will do. Now, we will proceed to see what I am speaking about.

I will reveal the trick now.

now..

now....

now......

now........

Full story »

PIVOT TABLE WEEK (5 of 5)

Learn Excel, Pivot Tutorial

Hi there,

 


This complete week, we will learn about few inner techniques of Pivot Table. These are few of my learnings in near days so thought of sharing to power your skills on Pivot. In my previous post, I spoke about How Human Parts Resembles Excel Features where Pivot is compared with Kidney. So, we will do some cleansing to our Kidney. :)


In this week we will learn about:
 

1. Adding few points to a Simple Pivot Table

2. Grouping data from months and years

3. Grouping data for words

4. About GETPIVOTDATA and its Advantages

5. How to avoid displaying the removed items in the pivot table

Full story »

PIVOT TABLE WEEK (4 of 5)

Learn Excel, Pivot Tutorial

Hi there,

 


This complete week, we will learn about few inner techniques of Pivot Table. These are few of my learnings in near days so thought of sharing to power your skills on Pivot. In my previous post, I spoke about How Human Parts Resembles Excel Features where Pivot is compared with Kidney. So, we will do some cleansing to our Kidney. :)


In this week we will learn about:

1. Adding few points to a Simple Pivot Table

2. Grouping data from months and years

3. Grouping data for words

4. About GETPIVOTDATA and its Advantages

5. How to avoid displaying the removed items in the pivot table

Full story »

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