I am sure, You don't know these Excel shortcuts !

Hi Friends welcome again, i am here with an another great topic.

We all uses many of shortcut keys for our daily tasks and we all knows very well all the basic shortcuts. But i have something that a am sure you don't know these shortcuts.What happens if we are writing these ™ ©  ♣  ♠  . So In this article we are going to discuss about the shortcut keys for entering Symbols in Excel. We can use these Shortcuts keys any where on windows platform like Excel, Word, Crome, IE, Notepad etc.

Pin this article to your workstations dashboards, note down in your notebook, or visit again to my blog for these shortcuts keys:

Alt + 0153   = ™ TradeMark

Alt + 0169   = © CopyRight

Alt + 0174   = ® Registerd TradeMark

Alt + 0176   = °  Degree

Alt + 0177   = ± Plus Or Minus

Alt + 0182   = ¶ Paragraph Mark

Alt + 0190   = ¾ Fraction, Three-fourths

Alt + 0215   = × Multiplication Sign

Alt + 0182   = ¢ Cent Sign

Alt + 0161   = ¡  upside down Exclamation

Alt + 0191   = ¿ upside down Question Mark

Alt + 1        = ☺ Smiley Face

Alt + 2        = ☻ Black Smiley Face

Alt + 3        =  ♥ Heart

Alt + 4        =  ♦ Diamond

Alt + 5        =  ♣ Club

Alt + 6        =  ♠ Spade

Alt + 7        =  • Dark Dot

Alt + 9        =  ○  Clear Dot

Alt + 15      = ☼ Bright Sun

Alt + 12      = ♀ Female Sigh

Alt + 11      = ♂ Male Sigh

Alt + 13      = ♪ Eighth Note/Music

Alt + 14      = ♫ Beamed Eighth Note

Alt + 8721  = ◄ Backward

Alt + 251    = √ Sqiure Root / Check Mark

Alt + 24      = ↑ Up Arrow

Alt + 25      = ↓ Down Arrow

Alt + 26      = → Right Arrow

Alt + 27      = ← Left Arrow

Alt + 18      = ↕  Up And Down Arrow

Alt + 29      = ↔ Left Right Arrow

And many more, try yourself and share if you find any other Symbol by Pressing Alt + (Numbers)


Happy Learning

Read More

Hack your Excel ! Creating - Editing your own Custom list

Today's topic is creating a Custom List

Today we are going to discuss about custom lists, first you need to know that what is a Custom List in Excel? When ever we write Sunday or any day name and after we drags down, the Excel simply creates a list of days like Sunday, Monday, Tuesday etc. Its also happens when we write and drag a Month name. Like below mentioned video.

So how its happens ? All these questions are comes into our mind.

Q1. What is a Custom List ?

Q2. Can we create a Custom List of ours?

Q3. How to Edit an Custom List ?

Q4. How a Custom List works ?

You don't worry. all these questions will be answered in this article.

"see the video for full example and and practice session"

Follow the below mentioned steps carefully

Step 1 - Click on files tab in (Excel 2010). If you are using Excel 2007 then click on Office Button (right-top button).

Step 2 - Click on Options. Excel option window will appear.

Step 3 - Click on the Advanced tab. Left sixth from top. And drag till last. You will able t see Edit Custom list button as shown below image. Click Edit Custom Lists.

Step 4 - Write your entries by separating commas. (Sun, Moon, Earth, etc)

Step 5 - Click Add and Then Click OK.

Congratulations Your custom list has been added

Let's check it, Close Excel and open a saved file then write any of the words of the list and drag. Smile if working and do let me know if any error occurs.

Check now.

You can also delete any custom list my click Delete (Down to OK)

Happy Learning

Read More

Excel Basics Class 1- Customising the Excel Interface as per our need

Customising the Excel Interface as per our need

As You all are asked and most of you registers for Basics of MS Excel, So we are starting from MS Excel basics. This course is designed for Excel beginners. We will discuss only basics and we will start from custom setting of Excel. You can also join the live classes by subscribing our email lists. We will discuses each and every single point witch we need to learn. You can also view the Full video of class.

Today's topic is Customising the Excel Interface as per our need

So lets start 

Go to Excel Option by clicking File Tab (left of the Excel Sheet) --> Option

Excel Option window will appear as shown below:-

this is for the excel 2010 user if you are using 2007 you can go by clicking Office button (read the article for Excel 2007 training)

In the Excel options tab there are 10 sections you will able to see.

• General
• Formulas
• Proofing
• Save
• Languages
• Advanced
• Custumize Ribbon
• Quick Access Toolbar
• Add ins
• Trust Center

So lets start with 

1. General Excel option

Simply click the General then you will be able to see a some options as shown in above picture.

• User interface option
• When creating new workbooks
• Personalise your Microsoft office

User interface option

Show Mini Toolbar- If we unchecked this option we will not able to see mini toolbar as shown in below image (please see the video for full clarification)

Enable live preview- when we do formatting we can see live effects by do checked this option.

I personally recommend Please do not Unchecked the both of options.

When creating new workbooks

when creating new workbooks as the point is saying itself, when we open the new workbook what we want in that. like witch font colour, which font style, and which font format you want a new sheet. we can customising these options as per our requirements. We can set that how many sheet we want in each new workbook, we can increase or decrease the sheets counts by minimum 1 to maximum 256.

Personalise your Microsoft office

You can write your name here  and Excel will change the property and set your name as the author for the each workbooks.

"Formulas and proofing we can skip because we do not need to discuss these point at this moment we will discuss it later in advanced Excel classes."

2. Save 

Click the save next to the Proofing and you will able to see the Save tab's area as shown in image below:-

in this option only two points are very important and we will discuss about only these. Please do not change any other option left as default except these.

• Save workbooks in this format
• Default file location

Save workbooks in this format

in this section we can set and change a the file Extensions (.xls, .xlsx, .csv) for our all new workbooks. Like we are working for a client and and our client operates Excel 2003. And we are using Excel 2010 or 2013. Then our files will save as .xlsx Format by default. Hence it will be not function fully and will be corrupt also some time. So by using this option we ca set a Default File type.

Default file location

In Ms Office default file save location is My Documents. But we can change it by pasting the required location in the bar.

"next is Languages tab and we can skip, we do not need to discuss about this because we all are using English language for Excel."

That's all for the First class next five options we will discuss in the next classes.
please join the live sessions  because in which i will try to answer your questions right there. You can also watch full class video on my Youtube channel by clicking here. join our mailing list to get each single information on your email.

Happy Learning

Read More