Archive for January, 2011

What type of intelligence do you identify with?

Sunday, January 30th, 2011

With intelligence according to psychologists there are about 9 different types. That’s why a lot of gifted people with Einstein are only gifted in one area (in Einstein’s case it would have have been scientific and mathematical).

The types of intelligence are as follows:

Spatial: People who are spatially intelligent are good at visual things such as visual arts like architecture and designing.

Linguistic: People who are linguistic are good with verbal and written things. They are usually good at reading, writing, telling stories, learning languages and public speaking. They learn best by discussing, debating, reading and writing.

Logical-mathematical: These people are good with reasoning, abstractions, logic and numbers. They’re usually very good at mathematics, chess, computer programming and similar. They excel at these things. They’re best suited to jobs such as scientists, enigineers, philosophers, doctors…

Bodily-Kinesthetic: These people are really good at using their body to learn and achieve. These people often use their body in a way to revise and remember things using their body (not remembering but via movement). These people are often athletes, actors, dancers, soldiers and similar.

Musical Intelligence: These people are very sensitive to noise and rhythms. They are often very good at learning musical instruments and singing and often learn through making songs. Singers, composers, conductors etc are often gifted in this way.

Interpersonal: Interpersonally intelligent people are very good with people. They tend to be epmathetic and sensitive towards the plight of others and are often extroverted. They are good communicators and often become things like politicians and social workers.

Intrapersonal: People with intrapersonal intelligence are often introverted and prefer to work alone. They are very good at deciphering their own feelings and understanding their sense of self, what makes them unique and using it to their advantage. People with intrapersonal intelligence are often theologians, writers, lawyers etc.

Naturalistic: These people are very good with nature and can relate well to natural surroundings. They tend to become farmers, wildlife volunteers etc

Exisential: These people are very good at contemplating hypothetical situations and ideas such as the infinite and are best suited to the career of philosopher.

I tend to lean towards being linguistically intelligent (I’m not gifted or anything I’m just good with linguistics). I’ve always gotten good marks in things like English. I’m a good reader, public speaker and have always been good at writing stories. I’m too sure about languages because at school I used to learn Japanese and was horrible at it. But I learnt French from 5-7 and was okay with it so I think maybe I’m more suited to European languages over Asian ones, specifically Germanic ones. (Ones with the phonetic alphabet).

Which type of intelligence best suits you/you find yourself best at?

I don’t specifically identify with a single one, but rather could pick and choose certain traits from Linguistic, Intrapersonal and Existential. While I would consider reading, writing, story telling and manipulation of the English language one of my strongest points, I’m absolutely awful when it comes to public speaking and learning the grammar of foreign languages. Similarly, while I’m introverted and philosophical the majority of the time, I have my moments when I’m surprisingly extroverted and petty.

Need help with excel formulas and macros?

Saturday, January 29th, 2011

Suddenly the fomulas in all my excel files are not working. E.g., the sum formula..and so on…nothing works…even if i try to put some new formula…not sure why…..pls help!

Check to make sure the ‘Calculation’ setting is not ‘Manual’, by pressing F9. If the formulas calculate, the setting is ‘Manual.

For Excel 2003, and prior, go to Tools > Options

Select the ‘Calculation’ tab and make sure the Calculation optionbutton is set to ‘Automatic’.

How to do basic subtraction in Microsoft Excel 2007

Saturday, January 29th, 2011

Learn how to use the Auto Sum feature to do subtraction.

Duration : 0:2:10

(more…)

Technorati Tags: , , , , , , , , , , , , , , ,

Excel Statistics 69: #1 Normal Probability Excel Functions & Area Charts

Friday, January 28th, 2011

Calculate Probability (area) for Normal Curve for less than or equal to an X value. Topics for Normal Bell Standard Normal Probability Distributions:
1.Calculate Probability for Normal Curve less than or equal to an X value
2.NORMDIST FUNCTION
3.NORMINV FUNCTION
4.NORMSDIST FUNCTION
5.NORMSINV FUNCTION
6.Create Area Chart for Normal Curve
7.Create IF function Formula to add a partial area to a full area chart

Statistics functions formulas

Standard Normal Distribution Area Chart Probability Theory Statistics.

Busn 210 Business Statistical Using Excel Highline Community College taught by Mike Gel excelisfun Girvin

Duration : 0:15:5

(more…)

Technorati Tags: , , , , , , , , , , , , , , , , , , , , , ,

Excel Basics #10: Formulas: Copy Vs. Cut

Friday, January 28th, 2011

The Excel Basics Series shows a systematic description of what Excel can do from beginning to end.
#10 Video topics:
1)See the differences between Copy a Formula and Cutting a Formula
2)Copy formula: Rules of Cell Reference Apply
3)Cut a Formula; Rules of Cell Reference Do Not Apply

Duration : 0:3:13

(more…)

Technorati Tags: , , , , , , , , , , , , , ,

Control slicers by using VBA

Friday, January 28th, 2011

Control slicers by using VBAToday’s author is Jan Karel Pieterse, an Excel MVP, who explains how to work with the SlicerCache object, and how customize buttons or change slicer properties by using VBA. For more information about slicers, read PivotTable Slicers on Jan Karel’s website: http://www.jkp-ads.com/.

…(read more)
(more…)

Excel Magic Trick #101: IS Functions

Thursday, January 27th, 2011

IS Functions. See how to use the following functions:

ISBLANK functionValue refers to an empty cell.
ISERR functionValue refers to any error value except #N/A.
ISERROR functionValue refers to any error value (#N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, or #NULL!).
ISLOGICAL functionValue refers to a logical value.
ISNA functionValue refers to the #N/A (value not available) error value.
ISNONTEXT functionValue refers to any item that is not text. (Note that this function returns TRUE if value refers to a blank cell.)
ISNUMBER functionValue refers to a number.
ISREF functionValue refers to a reference.
ISTEXT functionValue refers to text.

IF function formula.

EXCEL IS functions. Excel Logical functions. Excel IsFunctions.

Duration : 0:3:19

(more…)

Technorati Tags: , , , , , , , , , , , , ,

SkillCaddy.com – Creating Excel Macros

Thursday, January 27th, 2011

How to create and use Excel Macros, part of the Microsoft Office suite, tons of other free software training videos at SkillCaddy.com

Duration : 0:5:53

(more…)

Technorati Tags: , , , , , , , , , , ,

Excel Macros -010- VBA Text Functions

Thursday, January 27th, 2011

Lesson Summary: VBA Text Functions. This video teaches you how to analyze and manipulate text strings using Visual Basic. Includes Left, Right, InStr, Mid, Trim and UCase functions

Visit http://www.excel4business.com/videos/visual-basic-text-strings.php for additional information on this video.

The “Excel Macros” series of training videos has been created by Excel4Business’ expert consultants.

Duration : 0:9:27

(more…)

Technorati Tags: , , , , , , , , , , , , ,

Fill series weekday.mp4

Thursday, January 27th, 2011

Learn basic excel function to increase your work effectivness and efficiency. Basic excel function are 1) fill series numbering, weekday, 2) counif formula, 3) Pivot table, 4) vlookup, 5)index formula, 6)Label cell, 7)number to word, 8)dropdown list, 9)advance vlookup, 10)transpose,11) number format, 12) text format,

Visit www.excel2function.blogspot.com to register FREE for link to the rest of the excel function video.

For any queries, please email to excel2function@freeautobot.com

Duration : 0:1:30

(more…)

Technorati Tags: , , , , ,