Category: How-to's

Form Controls and ActiveX Controls - Part2

How-to's, Learn Excel

Hi there,

 Share on Facebook


 

We have learnt what is Form Controls and What is ActiveX controls and where are these controls available in Excel in "Form Controls and ActiveX Controls - Explained". However, we will dig into this topic to learn more about it.

Now, let's see

 

How many controls are available in Form Controls?

 There are 12 Form Controls. Here they are:

Full story »

Form Controls and ActiveX Controls - Explained

How-to's, Learn Excel

Hi there,

 Share on Facebook

 

 

 

This is the unknown topic for most of the excel users. Why I am saying this is these are rarely used controls but it works like an interactive way. Form and ActiveX controls make users to learn Excel features interactively. This is the good time to attempt to learn these controls. . 

Full story »

Cooked Dynamic Chart (3 Flavors)

Formulas, charts, How-to's

Hi there,

 Share on Facebook

 

 

 


We have learnt Cooked Dynamic Chart using Table. I promised for few more flavors but the priority posts made me little delay. However, I have taken some time now to complete this exercise before getting delay. 

Here we go:

 

Three more flavours that I want to share with you are 
 

  • Dynamic Chart Using Functions (Named Ranges)
  • Dynamic Chart Using Filter Option and 
     
  • Dynamic Chart Using Camera Tool

 

First, let us see how to prepare Simple 2D Column Chart before we go to Dynamic Chart using Formulas/Named Ranges.


Raw Data


We have a set of data and want to show the performance of the data through a chart.


Follow the below steps to prepare a normal 2D-column chart:

Full story »

Insert an Image in Comment (SHIFT + F2)

excel_usage, How-to's

Hi there,

 Share on Facebook



We all know how to insert a comment to a cell. Today we will learn how to insert an image into that comment.


Here how we go:

> Right Click the cell where you want to insert the comment.how to insert image in the comment using excel

> Click "Insert Comment" or

    • Use rightclick button using keyboard and type "m" and click OK or
    •  SHIFT + F2

> Comment is inserted now, then

> Right click on the border of the comment and select "Format Comment"

Full story »

Cooked Dynamic Chart

charts, How-to's

Hi there,

  



Today I want to attempt an interesting topic in Charts. Have you ever heard about Dynamic Charts?

Raise your hands if any of you have heard or know about Dynamic Charts. &#59;)  


Wow..! so many hands are flying in the air. Great!

 

 

 

For the benefit of those of you who did not raise your hand (:P), let me give you a brief explanation of dynamic charts.


 

Imagine you are in the middle of a fight with your wife, if you suddenly start praising her , you observe that her expression begins to go towards the pleasant side :p On the other hand you say negative things, Oh my god I don’t think scientists have invented a scale to measure that expression :D


 

The underlying concept I am trying to explain is, in real time the output (in our case expression :P) changes with input ( praise / curse :P) . That is the concept of Dynamic chart! Simple right? J

 

                                                                                                                           

 

Let us get started now. I will explain a simple method to prepare Dynamic Chart. Did you know that we can prepare Dynamic chart using Table? Option is available in INSERT TAB, if not here we go:


Full story »

Convert Number to Percentage

How-to's

Hi there,

 


Yet another post for all you perfectionists out there!

 

How would it be? If you could make the traffic in front of your car disappear at the press of a button? :D Well we haven’t advanced so much :p but what I can give you at the press of a button is as follows:

 

While working on huge reports we usually kill most of our time searching for necessary options. So, here is a nice tip which reduces most of your time and I believe you will definitely post the comment on how much time you have saved by using this tip. 

 

 

Here we go:

Full story »

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