test535435

Hi friends hope you are doing well !

Thanks for your Suggestions and enquiries, It is nice to answering you.

As I have so many questions, so I am thinking to start some free MS Excel training courses. Course will start from 5 July 2016.

These training courses are free of cost and i will also provide a document of completion the course. Any one can register and take course for free. Course will be online. I will Publish chapters on the web, videos on youtube and also share links with you on your emails. I will also available Live on web on Saturdays And Sundays via Go To Meeting for answer your questions practically, and i will share meeting codes on your email ids. So please register if you wish to get course materials on your emails and take this course.

Click here to Register for Free

Courses descriptions are mentioned below :-

1. MS Excel basics 

       This course is for excel beginners. For whom they are not familiar with excel, And don’t know more about the MS Excel, its uses and benefits. We will discuss about Customising the Excel as per our need and requirements.

2. MS Excel level 2        

         In this course I am planning to put all type of basic formula like (text, date and time, lookup and references and mathematical). General Usage of all Menu Tabs. 

3. MS Excel level 3

         In this module we will discuss about formatting, number, text, cell and conditional formatting. We also discuss about the Charts, Graphs and Dashboards.

4. Advanced MS Excel

          Nested if formula, functions, formula merging and other advanced tricks. All formula in details. All Menu tabs In details. Advanced protection methods. Sheet sharing methods.

5. Basics of Excel Macros

         In this Module we will cover basics of MS Excel Macros, VBA coding, and all macro creation methods.

                                   Click here to Register for Free

After taking these courses you will able to manage MS Excel Easily. You can create your own functions formula. I am providing this for free because i also need improvement as a trainer

If you think it will be helpful for you, you can register for free by clicking here. Course will start from 5 July 2016.

Thanks for reading.

test post 7

Hi friends hope you are doing well !

Thanks for your Suggestions and enquiries, It is nice to answering you.

As I have so many questions, so I am thinking to start some free MS Excel training courses. Course will start from 5 July 2016.

These training courses are free of cost and i will also provide a document of completion the course. Any one can register and take course for free. Course will be online. I will Publish chapters on the web, videos on youtube and also share links with you on your emails. I will also available Live on web on Saturdays And Sundays via Go To Meeting for answer your questions practically, and i will share meeting codes on your email ids. So please register if you wish to get course materials on your emails and take this course.

Click here to Register for Free

Courses descriptions are mentioned below :-

1. MS Excel basics 

       This course is for excel beginners. For whom they are not familiar with excel, And don’t know more about the MS Excel, its uses and benefits. We will discuss about Customising the Excel as per our need and requirements.

2. MS Excel level 2        

         In this course I am planning to put all type of basic formula like (text, date and time, lookup and references and mathematical). General Usage of all Menu Tabs. 

3. MS Excel level 3

         In this module we will discuss about formatting, number, text, cell and conditional formatting. We also discuss about the Charts, Graphs and Dashboards.

4. Advanced MS Excel

          Nested if formula, functions, formula merging and other advanced tricks. All formula in details. All Menu tabs In details. Advanced protection methods. Sheet sharing methods.

5. Basics of Excel Macros

         In this Module we will cover basics of MS Excel Macros, VBA coding, and all macro creation methods.

                                   Click here to Register for Free

After taking these courses you will able to manage MS Excel Easily. You can create your own functions formula. I am providing this for free because i also need improvement as a trainer

If you think it will be helpful for you, you can register for free by clicking here. Course will start from 5 July 2016.

Thanks for reading.

test post 6

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

test post 5

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

test post 4

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

test post 3

In this Article you will learn

• A Brief History About Spreadsheets.
• Journey of Spreadsheet ! Evolution of Excel.
• Why Excel is favourite of Developers.

A Brief History About Spreadsheets.

Spreadsheets have been used by accountants for hundreds of years. Nowadays we all are using Spreadsheet software for calculations ind its easy and quick also. There was really a era where modern spreadsheet were not available, would you able to think, how people are doing their job. This is a really tough task. Back then people relied on clumsy calculators and spend hours  doing what now takes only minutes.

The First Electronic spreadsheet of the history The VisiCalc.

Professor Richard Mattessich pioneered the development of computerised spreadsheets for use in business accounting in 1961. But The world’s first electronic spreadsheet, VisiCalc, was came in to the picture by Dan Bricklin and Bob Frankston in 1978. Back then personal computers are unheard and out of reach of most professionals. Visicalc was developed for the Apple II. But VisiCale was just like nothing if we compare today's standard. VisiCalc essentially laid the foundation for future spreadsheets, and you can still find its row-and-column-based layout and formula syntax in modern spreadsheet products like Microsoft Excel, LibreOffice Calc, Kingsoft Spreadsheet, OpenOffice etc.

VisiCalc Get populer in veri short time, and many forward-looking companies purchased the Apple II for the sole purpose of developing their budgets with VisiCalc. Consequently, VisiCalc is also a pillar for much of the Apple II’s initial success.

In the meantime, another class of personal computers was evolving; these PCs ran the CP/M operating system. Sorcim a US based company developed SuperCalc, which was a spreadsheet that also attracted the companies.

In 1981 IBM personal computers cam into the picture, Both VisiCorp and Sorcim modified with a PC virsion of their softwares. By current Standards both VisiCalc and SuperCalc were extremely clumsy.

• You cannot increase cell width.
• If you want to enter lengthy titles, then you have to use multiple cells.

See The Picture of VisiCalc

Nevertheless, the ability to automate the budgeting tedium was enough to lure thousands of accountants from paper ledger sheets to floppy disks.

Next Step of the Journey - Lotus 1-2-3

After the VisiCal Success, Many of the developers are trying to develop a application like this. Few among them Mitch Kapor, Jonathan Sachs and the company designed a new product and launched the software industry’s first

full-fledged marketing blitz. They have advertise every ware for the same.

Specification of Lotus 1-2-3

• Lotus 1-2-3 improved on all the basics embodied in VisiCalc and SuperCalc.
• First program to take advantage of the new and unique features found in the powerful 16-bit IBM PC AT
• 1-2-3 bypassed the DOS calls and wrote text directly to display memory.
• More Responsive and dynamic.
• The online help system.
• Dynamic menu bars, and many more.

Next Step of the Journey - Quattro Pro

Quattro Pro was launched by Borland International. Borland International came into the industry in 1987 with the Quattro Pro. 

Specification of Quattro Pro.

• Menu system was better then others.
• Low Cost.
• Familiar Commands like Lotus 1-2-3.
• Familiar with Macros.
• Work In multiple worksheet at a time.
• Movable and resize able windows.

Final Step The Evolution of Excel

Microsoft was also launched spreadsheet application in 1982 called MultiPlan. MultiPlan was launched for Apple II, Apple III, XENIX, and MS-DOS. MultiPlan essentially ignored existing software user-interface standards. Difficult to learn and use,it never earned much of a following in the United States. Not surprisingly, Lotus 1-2-3 pretty much left MultiPlan in the dust.

Evolution of Excel

Excel Evolved from Multiplan. Excel was a graphics-based program. Microsoft released the first version of Excel for Windows in 1987.

Excel first macro languave enabled 

test post 2

Hi Friend its been long time to see you. Believe me, I missed you a lot. I am here to tell you how to unblock yourself on Whatsapp.

"Disclaimer - This post is for educational purpose only, please do not misuse it. Happy Leaning."

Follow the below mentioned steps to Unblock yourself on Whatsapp:

1.  Go to Setting.
   
   
   
2.  Click On Account.
   
3.  Now Click on Delete my account.
   
4.  Enter Your Phone number and
   
5.  Press DELETE MY ACCOUNT.

After Deleting your account, Uninstall the Whatsapp from your device. After uninstalling, restart your device. After restarting the device follow the below mentioned steps.

1.  Download WhatsApp again from Google Play store or other app stores.
2.  Install With the same number. Fill Other details.
3.  Now You have a new Whatsapp Account with the same number and its      unblocked from all accounts they have blocked you. Enjoy.

Happy learning.

This post is only to let you know the possibilities. This is not a hack or a hacking idea. It is a general Whatsapp Trick that we all should know. In case of any emergency we can use it.

Its better to ask your friend for the region behind it, Try to understand his/Her concerns, feel sorry, ask apology. After ask his/her to unblock rather than unblocking yourself with a trick. Friendship is more important than our ego.