Category: Formulas

Count Words in a Cell - "5"

Formulas, How-to's

Hi there,

  Share on Facebook




Sometimes we get a requirement to count the number of words in a cell. This is not a difficult task, a simple logic works to get this done.

 

RERUIREMENTS:

  • LEN
     
  • TRIM
     
  • IF
     
  • SUBSTITUTE

  

Full story »

Information Functions are in Finger Tips Now (3 of 3)

Formulas

Hi there,


 

 

Tomorrow is a children's day. On behalf, exceltoxl is wishing a Happy Children's Day. On this day most of us would have recalled many sweet memories like parents will push the children to go to school or tutions, demanding parents for what others have which doesnot have with us, thefting others schools bags having pens, pencils, erasers, sharpners etc., thefting others lunch boxes and having in between the classes. In some cases like me, I was in the hostel since PRE KG. So, when I was @12 going to movies without informing our wardens, thefting watermilons, papayas, coconuts in the farms, playing cricket and volleyball with all my friends in the leisure time, going to watch television programs in the leisure time without knowing to our principal, off-course above all we were studying well and passed distinctions. In my opinion children who participate all curicular activities will definitely have good stand on studies too. So, my suggestion is to keep children to participate all the activities and make them to enjoy when ever required. Time is very Precious.

Full story »

Information Functions Week (2 of 3)

excel_usage, Formulas

Hi there,

 Share on Facebook

 

Let us celebrate the Information Functions Week from today 9th of Nov, 2013 till next 13th of Nov, 2013. Have a great Information Functions Week and happy learning. This complete week we will learn about the topics mentioned below: 

  • Where are these functions located in Excel?
     
  • How many Information Functions are available in Excel?
     
  • Explain the purpose of each Function?
     

EXPLAIN THE PURPOSE OF EACH FUNCTION?

Now, we will learn about each function and its usage in detail:

Pages: 1· 2· 3· 4· 5· 6· 7· 8· 9· 10· 11· 12· 13· 14· 15· 16· 17· 18

Information Functions Week (1 of 3)

Formulas

Hi there,

  Share on Facebook 


Let us celebrate the Information Functions Week from today 9th of Nov, 2013 till next 13th of Nov, 2013. Have a great Information Functions Week and happy learning. This complete week we will learn about the topics mentioned below: 

  • Where are these functions located in Excel?
     
  • How many Information Functions are available in Excel?
     
  • Explain the purpose of each Function?
      

WHERE ARE THESE FUNCTIONS LOCATED IN EXCEL?

Full story »

Text Cases Can be Changed; Before Changing UnderPants

Formulas

Hi there,

  Share on Facebook 

 


One great thing I have achieved in recent days is adding Dr. Excel (FORUM) to our blog. You can register and ask Excel questions here and expect results either from the registered members or from myself at the earliest. Click here to enter into the Dr.Excel. Finally, As promissed, Dr.Excel has reached to our community on 7th of Nov, 2013. To know more about my promise click on Dr.Excel is on the way

 


Now, let's talk about this topic. First we need to know how many ways we can change the text cases of the cell content. As we know, the most used text formats are 3.


1. UPPER case

2. LOWER case

3. PROPER case

With the same names, Excel has three functions which will satisfy our text formatting requirements using UPPER, LOWER and PROPER keywords.

Full story »

Excel Data Tables Are Awesome..!

Formulas, Tables

Hi there,

 

 

One of the most amazing features of Excel is Tables. As you all know I have compared Excel Tables functionality with Human Lungs of the human body. To know more check How Human Parts Resembles Excel Features. Tables are really a good feature to work with rather than just a range of data. There are many reasons which supports my statement here. Few of them are:

Full story »

Pages: 1· 2· 3· 4· 5· 6· 7· 8· 9· 10· 11· 12· 13

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