MS-Excel Self-Skill test for free

Excel is too big to know everything. Even the experts generally have an area of expertise. It is better to know the features that will help you with your CURRENT requirements! So for this you should know that:

• What your existing skill level is (in more detail than just beginner, intermediate or advanced)

Once you get the answer of above question, you'll be able to find that on what should you work on?


The Excel Skills Assessment test assesses the person’s aptitude for Excel learning and allows you to match your Excel skill level to the correct training material. It measures your skill across four axises being:

• Fundamental Knowledge- the basics
• Using Tools- using the tools available in excel e.g. sort, autofilter, pivots
• Using Functions- using Excel’s key formula functions e.g. vlookup, sumif etc
• Super User Attributes- ability to solve problems in excel using all the above

The test is available for Excel 2007, 2010 and 2013 in French and English. It includes videos and in application testing exercises. The test focuses on the following 4 areas:

• Software environment (save, print, protect, etc.)
• Functions (SUM, IF, etc.)
• Data management (filters, pivot tables, etc.)
• Formatting (number formats, conditional formatting, etc.)

You can assess yourself by giving Self-Test of your excel skills. You can choose any of the site mentioned below to give the test:


http://www.advanced-excel.com/excel_tests.html
http://www.auditexcel.co.za/excel-skills-assessment/
http://www.excel-skills.com/demos2010/skills_test.php
http://www.isograd.com/EN/freepositioningintro.php
http://www.proprofs.com/quiz-school/story.php?title=microsoft-excel-proficiency-test
http://www.skills-assessment.net/test-excel-skills.htm
https://accessanalytic.com.au/free-excel-stuff/free-excel-test/

Brackets in formula in MS-Excel

Sometimes you will need to use brackets, (also known as 'braces'), in formula.
This is to ensure that the calculations are performed in the order that you need.
The need for brackets occurs when you mix plus or minus with divide or multiply.

Mathematically speaking the * and / are more important than + and -
The * and / operations will be calculated before + and -

Example 1 : The wrong answer !

	C
12	10
13	20
14	2
15	50	=C12+C13*C14

Example 2 : The correct answer

	C
27	10
28	20
29	2
30	60	=(C27+C28)*C29

By placing brackets around (10+20) Excel performs this

part of the calulation first, resulting in 30

Then the 30 is multipled by 2 resulting in 60

Keyboard Shortcut to create chart in MS-Excel

Keyboard Shortcut to create chart on active sheet is "Alt+F1"

Select the data then press "Alt+F1"

Brackets in formula in MS-Excel

Use of Brackets in Excel Formulas:

We should use the brackets, (also known as 'braces'), in the formula. It ensure that the calculations are performed in the order that you need.The need for brackets occurs when you mix Plus or Minus with Divide or Multiply.

In the mathematical terminology  the * (Multiply) and / (Divide) are more important than + (Plus) and - (Minus). The * and / operations will be calculated before + and -

Example 1 : The wrong answer !

Example 2 : The correct answer !

By placing brackets around (10+20) Excel performs this part of the calculation first, resulting in 30, then the 30 is multiplied by 2 resulting in 60.

 

Brackets in formula in MS-Excel

Sometimes you will need to use brackets, (also known as 'braces'), in formula.
This is to ensure that the calculations are performed in the order that you need.
The need for brackets occurs when you mix plus or minus with divide or multiply.

Mathematically speaking the * and / are more important than + and -
The * and / operations will be calculated before + and -

Example 1 : The wrong answer !

	C
12	10
13	20
14	2
15	50	=C12+C13*C14

Example 2 : The correct answer

	C
27	10
28	20
29	2
30	60	=(C27+C28)*C29

By placing brackets around (10+20) Excel performs this

part of the calulation first, resulting in 30

Then the 30 is multipled by 2 resulting in 60