Darpan Sharma

Hi Everyone,

Today lets discuss something worthwhile specially for those who are into mathematics and teaching it in a daily basis.

If you are in a teaching position specially Mathematics then it would really be hard for you to type a test paper that consist of a lot of equations or else you need to use some software which in turn might cost you a bit for signup facilities.

This blog is in reference to one of the most commonly faced problem of writing a mathematical equation in a question paper, and of course is also being published on request of one of my regular viewer.

So let see what comes next.....

Now a days most extensively used writing software i.e. MS Word can be fluently used in order to make these works easier just need a little bit of guidance along the path... (Guidance = My Blogs ;)  )

Let us suppose that the equation that we need to type in is (x^2-16)/(x^2+18x+81) in a mathematical view with proper stacked equation type.

First of all in an open MS Word file go to the insert tab which will look like the one shown below:


Next, Go to the equation button within the Insert tab to right corner of the screen.

Once you click on the equation button you can see a series of symbols and equations in the list which may confuse you by looking somewhat like this in the picture..


Once done with that, you can see a box which appears in the writing area, where now you can go and start writing the equation but wait...you are still confused as to how to go about writing it.... no worries just see how it goes...

Once the box appears you can now click on the box and then click on the option named "Fraction" and then go to the first option that gives the name as "Stacked Fraction".  This will look something like

Yeeeeaaaahh...its done now.......if you want any more information on any of these tricks and tacks....leave a comment of msg me on the Facebook page.....

Enjoy learning....

Hello Friends,

If you want to fasten you hands in MS Excel, then is good if you know the hot keys for some of the vital actions while using it. I have mentioned some of them in the list below.

Check if you can us all of these:

Formatting Text In Worksheet:

Formatting Cells:

Hellos Guys,

Yes you saw it write, Macros basic to learn is just a piece of cake if we understand the concept of it.

Let me put it this way: Have you ever recorded a video in a mobile or any camera, I bet you have....same thing applies in Macros (for beginners), so without wasting much of your time lemme explain it how.

When we open our excel the first view of it seems very confusing due to the boxes which spreads all across the screen. We can see various tabs in the top line among which few are "Home", "Insert", "Page Layout", "Formula", "Data", etc etc..

Now in order to start the lesson lets go to the tab named as ""View".

 Now, once you click on it, the other step is to click on the dropdown button named  as "Macros". This is placed in the extreme right end of the screen.
Now, as shown above you need to click on the "Record Macro" button to start recording the sequence which you want to use it time and again just by clicking a button.

This time lets start with the simplest of the sequence, lets say you want to automate an action (making the selected cell red in colour).

Once you click on the Record Macro button, it will ask you to name the macro before proceeding further to record. Lets name it as (makemered), as the name of the macro doesn't allow any spaces in between.

Now just click on "OK".

Be careful now, everything you do now is being recorded. So, lets just go and change the colour of the selected cell to Red. (do nothing else).

Once done with that, go back to the "View" tab and click the macro dropdown and select "Stop Recording"

Now comes the interesting part: Select any shape from the "Insert" and give it your own look and feel. As shown below and also write something that urges you to click it time and again.
Now right click in the shape that you have selected and click on "Assign Macro" button. Once you do that a pop up box asks you for which macro is to be assigned with the shape. Just select the macro that you want to assign with the shape and then click on "OK".

Now comes the Magical Moment: Select any cell or a group of cell and then click in the shape that you have assigned the macro to, and see what happens.

Hope you liked it!!!!!.

If you face any issues or have any queries regarding it please mention in the comment box below,,,will definitely try and solve it out for you.....

Enjoy Learning :)