Facebook
Twitter
RSS
Daily E-mail Follow SLAMXHYPE Recent Posts Undercover for Nike “GYAKUSOU” Collection Free Run+2 Here is a look at a new addition to the Undercover for Nike “GYAKUSOU” Collectio...
more
JAM HOME MADE Skull Cuff Links Here is another stand out piece from JAM HOME MADE with this pair of cuff links whic...
more
GOODENOUGH Spot Items A series of spot items have surfaced as part of the GOODENOUGH spring/summer 2011 co...
more
Gagosian Gallery iPad App The highly coveted Gagosian Gallery has become more accessible to the online world w...
more
JAM HOME MADE x Wonderwall Pencil Case The JAM HOME MADE 10th anniversary has enticed many names of great stature, and not ...
more
Popular This Month Riverside Museum by Zaha Hadid Renowned architect Zaha Hadid latest project has taken her to Glasgow to create the ...
more
Mark McNairy x ACL & Co. Wingtip Brogue Boot Highly regarded New York designer Mark McNairy is the central figure of another comp...
more
Nike Air Jordan 3 “True Blue” Retro It doesn’t get much more iconic than this when we talk about sneakers, and wit...
more
De La Barracuda Boxing Club Spring/Summer 2011 Collection With the the introduction of a new venture we are given new apparel from De La Barra...
more
F.C.R.B. Leopard Stole Everyone’s favorite fictional football club, FC Real Bristol gears up to relea...
more
Twitter Undercover for Nike “GYAKUSOU” Collection Free Run+2 #slamxhype view 5 mins ago JAM HOME MADE Skull Cuff Links #slamxhype view 2 hours ago GOODENOUGH Spot Items #slamxhype view 2 hours ago -->
Friday, June 17, 2011
Monday, May 30, 2011
2011 to force the mine die you hilarious couplet 63,535,955
The Union: doctoral, graduate, undergraduate, going!
Second line: 06 th, 07 th, 08 th, th session of the unemployed!
scroll reads: May the reading of a fighter
The Union: the Jinsha River and Jialing River, Heilongjiang, Jiang Jiang can vote!
Second line: leap buildings, teaching building, dormitory, building floor can jump!
scroll reads: unprecedented
The Union: no return love family love!
Second line: anti-fire security Brother!
scroll reads: free love
The Union: boys, girls, poor scholar, going!
Second line: first love, love, extramarital affairs, reluctantly!
scroll reads: There is no love
The Union: the phase met, acquaintance, friend, love to be!
second line: small noisy, Noisy, kicked up, breaking up is inevitable!
scroll reads: Love on the hard
woven together: the people I love do not love me
second line: Love me I do not love people
scroll reads: Bitter
The Union: the Internet, playing cards, love, wasted four years time,
; second line: that something was going abroad to find work, live pigs and dogs than
scroll reads: fed on the joint support of the
: test test junior high both in the university entrance exam test to worry
Second line: copy the English language copy copy copy copy to mathematics had
scroll reads: do not believe in hanging branches
The Union: Yesterday, Today, Tomorrow, the second line
tough day: breakfast, lunch, dinner, every meal is hard
; scroll reads: college life
The Union: Walking on campus last night and saw the frog cool, vomiting, vomiting, and can only take the first hit the tree
Second line: Baiku Stadium last night, when I suddenly hit the tree of dinosaurs, horror, terror, poor tree trees
scroll reads: Ghost Story
The Union: hard to say, hard to say, so hard that
Second line: think you, read you, miss you
; scroll reads: love regret
The Union: Reviewing the past eventful years, a wife, a bunch of kids.
Second line: look at the present peace and prosperity, a child, his wife a bunch.
scroll reads: Times
The Union: rather no personality, can not pass
Second line: cheating in exams , next year when the school brother
scroll reads: dies too
The Union: Reading sound of rain and wind, I do not say anything.
Second line: Family affairs world affairs, none of my Pishi.
Streamer: The side of the play go.
The Union: boys, girls, poor scholar, going!
Second line: first love, love, extramarital affairs, reluctantly!
scroll reads: There is no love
The Union: doctoral, graduate, undergraduate, going!
Second line: the last term, this term, the next, second session of the unemployed!
scroll reads: May the reading of throwing in the towel
The Union: wind, and rain the next, I'm waiting for you back;
second line: for your health, you die, waiting a lifetime for you;
scroll reads: send the wrong person.
The Union: Look back agitated mighty force;
Second line: turned his head to scare off millions of bold warriors;
; scroll reads: My goodness
The Union: cheating in the exam next year when the school brother;
Second line: no personality rather not fail;
Streamer: that is to live!
The Union: Mahjong Poker Golden, after the losers go home;
Second line: Road westerly Shouma heartbroken man in the horizon; < br> scroll reads: terribly!
the Alliance: to remove the number one and two;
Second line: There forty-five thousand six hundred seventy-nine;
Streamer: only thirty-eight!
The Union: the line you are on the line that you can not row;
Second line: you said no no no trekking line;
; scroll reads: not satisfied.
scroll reads: crazy for love.
The Union: I love unofficially crowned;
Second line: I love the people miserable;
scroll reads: Bitter .
The Union: In the last as commander;
second line: the next as a pig;
scroll reads: Marshal canopy.
The Union: false name false name a false address;
Second line: Pianchipianhe feeling cheated;
scroll reads: take the bait.
The Union: Red rice, pumpkin soup, a wife and a child to help;
Second line: red rice tortoise soup, a wife and a bunch of kids;
scroll reads: with the times.
The Union: the pressure layers of overweight and success;
second line: The next cheat on steadily with water, a matter of course;
; scroll reads: happy.
The Union: love and be loved is difficult;
Second line: sentient beings destined to time;
scroll reads : bonds of friendship is priceless
Second line: 06 th, 07 th, 08 th, th session of the unemployed!
scroll reads: May the reading of a fighter
The Union: the Jinsha River and Jialing River, Heilongjiang, Jiang Jiang can vote!
Second line: leap buildings, teaching building, dormitory, building floor can jump!
scroll reads: unprecedented
The Union: no return love family love!
Second line: anti-fire security Brother!
scroll reads: free love
The Union: boys, girls, poor scholar, going!
Second line: first love, love, extramarital affairs, reluctantly!
scroll reads: There is no love
The Union: the phase met, acquaintance, friend, love to be!
second line: small noisy, Noisy, kicked up, breaking up is inevitable!
scroll reads: Love on the hard
woven together: the people I love do not love me
second line: Love me I do not love people
scroll reads: Bitter
The Union: the Internet, playing cards, love, wasted four years time,
; second line: that something was going abroad to find work, live pigs and dogs than
scroll reads: fed on the joint support of the
: test test junior high both in the university entrance exam test to worry
Second line: copy the English language copy copy copy copy to mathematics had
scroll reads: do not believe in hanging branches
The Union: Yesterday, Today, Tomorrow, the second line
tough day: breakfast, lunch, dinner, every meal is hard
; scroll reads: college life
The Union: Walking on campus last night and saw the frog cool, vomiting, vomiting, and can only take the first hit the tree
Second line: Baiku Stadium last night, when I suddenly hit the tree of dinosaurs, horror, terror, poor tree trees
scroll reads: Ghost Story
The Union: hard to say, hard to say, so hard that
Second line: think you, read you, miss you
; scroll reads: love regret
The Union: Reviewing the past eventful years, a wife, a bunch of kids.
Second line: look at the present peace and prosperity, a child, his wife a bunch.
scroll reads: Times
The Union: rather no personality, can not pass
Second line: cheating in exams , next year when the school brother
scroll reads: dies too
The Union: Reading sound of rain and wind, I do not say anything.
Second line: Family affairs world affairs, none of my Pishi.
Streamer: The side of the play go.
The Union: boys, girls, poor scholar, going!
Second line: first love, love, extramarital affairs, reluctantly!
scroll reads: There is no love
The Union: doctoral, graduate, undergraduate, going!
Second line: the last term, this term, the next, second session of the unemployed!
scroll reads: May the reading of throwing in the towel
The Union: wind, and rain the next, I'm waiting for you back;
second line: for your health, you die, waiting a lifetime for you;
scroll reads: send the wrong person.
The Union: Look back agitated mighty force;
Second line: turned his head to scare off millions of bold warriors;
; scroll reads: My goodness
The Union: cheating in the exam next year when the school brother;
Second line: no personality rather not fail;
Streamer: that is to live!
The Union: Mahjong Poker Golden, after the losers go home;
Second line: Road westerly Shouma heartbroken man in the horizon; < br> scroll reads: terribly!
the Alliance: to remove the number one and two;
Second line: There forty-five thousand six hundred seventy-nine;
Streamer: only thirty-eight!
The Union: the line you are on the line that you can not row;
Second line: you said no no no trekking line;
; scroll reads: not satisfied.
scroll reads: crazy for love.
The Union: I love unofficially crowned;
Second line: I love the people miserable;
scroll reads: Bitter .
The Union: In the last as commander;
second line: the next as a pig;
scroll reads: Marshal canopy.
The Union: false name false name a false address;
Second line: Pianchipianhe feeling cheated;
scroll reads: take the bait.
The Union: Red rice, pumpkin soup, a wife and a child to help;
Second line: red rice tortoise soup, a wife and a bunch of kids;
scroll reads: with the times.
The Union: the pressure layers of overweight and success;
second line: The next cheat on steadily with water, a matter of course;
; scroll reads: happy.
The Union: love and be loved is difficult;
Second line: sentient beings destined to time;
scroll reads : bonds of friendship is priceless
Sunday, May 29, 2011
Advanced Excel Tips
1. Editing skills
2. The merger of the cell contents
3. Conditions indicate
4. Custom format
5. Drawing Function Image
6. Custom functions
7 . Matrix
8. automatically switch the input method
9. batch delete empty lines
10. how to avoid the error message
11. macro use
12. the icon of the application of skills
1, editing skills
1 editing skills
(4) fill streak
If you want to add the beautiful in the workbook The horizontal stripes, can use the alignment of the filled function. First filled in a cell of
Figure 1
(5) multiple sheets to enter the same content in several worksheets
enter the same data in the same location, you can select a worksheet, and then hold down the Ctrl key, then click the window to the bottom left corner of the Sheet1, Sheet2 ...... to directly select the input the same content multiple sheets, then in any one of them to enter these same worksheet data, then the data will automatically appear in the table selected among other work. After input finished, press the Ctrl key on the keyboard, then use the left mouse button click on the selected multiple worksheets, work table to remove these links, or in a form input data will then appear in the election the other work table.
(6) cells do not populate the same data continuously
select a cell, hold down the Ctrl key, right click the other cells, it will select all those cells the. Enter data in the edit area, then hold down the Ctrl key while you tap Enter, in all the selected cells have emerged in the data.
(7) to display the formula in cell
data in the table if the majority of work is generated by a formula and want to quickly know the formula for each cell in the form of, for editing , you can do: Use the left mouse button click on At this time the division of labor in each cell that come. If you want to restore the display of calculated results to re-set
Figure 2
(8) Select the text using Ctrl + *
a work table, if there are many data tables, you can select the table by a cell, and then press Ctrl + * key to select the entire table. Ctrl + * the selected region: According to the selected cell to the surrounding radiation data involved are the largest regional cell. So that we can easily and accurately select the data table, and effective method to avoid dragging large range of cells selected screen Luangun phenomenon.
(9) quickly remove the contents of the cell
If you want to delete the contents of the cell content and its format and comments, can not simply be applied to the cell selected, then press the Delete key way to go. To completely remove the cells, using the following method: you want to remove the selected cell or range of cells; click the
2, the combined cell contents
needed, and sometimes want to B and C list the contents of the column to merge, if the number of rows less, can directly use the Paste
solution is: In the C line, insert a blank line (if the D column is not content to operate directly in the D column), in D1, enter , C, and the two columns. Select cell D1, the cell with the mouse to point the bottom right corner of the small box B series and C series combined. Then do not just put the first B and C column remove column, the first column of the results of D should copy it, and then Time you delete B, C, D columns.
The following is a With AutoCAD drawing, some people like the coordinate point is stored in EXCEL, called when drawing curves in these parameters. Stored data format is merged into C column, enter in C1: = A1 &All contents of the combined (see Figure 3-4).
merge the contents of different cells, there is a way is to use CONCATENATE function, the function of certain text string into a string, the specific operation for the . For example, assume that the investigation in a river ecosystem in the table, B2 contains ,
Figure 3 Figure 4
3, conditions indicate
we know, the use of If the function can be achieved in accordance with the conditions of display. A common example is when the teachers in student achievement statistics, want to enter scores below 60, can appear as This effect, the use of IF functions can be easily achieved. Assumption results in the A2 cell, determine the results in cell A3. Then in cell A3 enter the formula: = if (A2 <60,
For example, if you type: = if (A2 <60,
If you enter = if (A2 <60, to four grades.
another example, the formula: = if (SUM (A1: A5> 0, SUM (A1: A5), 0) this style on the use of a nested function, meaning that, when A1 to A5 and large at 0, returns this value if less than 0, it returns 0. Another point to draw your attention: The above symbols are the half-angle, and the IF with no spaces between brackets.
4, the custom format
Excel by default a lot of useful data formats, and can basically meet the requirements of use, but for some special requirements, such as the emphasis on some important data or information display, set the display conditions so, we must use a custom format function to complete. Excel custom format using the following general model: a positive number format, negative format, zero format, text format, in this general model, containing three numbers and a text paragraph section: use of data greater than zero positive number format; less than zero data using a negative format; zero data using a zero format; enter the body cells to use text format. We can also use the test, add descriptive text and the use of custom format color to extend the application of universal model.
(1) use of color in a custom format to a paragraph set the color, simply add the paragraph in square brackets the color name or color number. Excel recognize the color is named: [black], [Red], [White], [Blue], [Green], [blue] and [magenta]. Excel is also identified by [color X] specified colors, where X is a number between 1-56, representing 56 kinds of colors (Figure 5).
Figure 5
(2) add description text in the input digital data to automatically after add text, using a custom format: add text position.
(3) create a conditional format of six logic symbols can be used to design a conditional format: ),<=( less than or equal), = (equal ),<>( not equal), bad if you think these symbols in mind, simply use the .
the custom number format, up to only 3 field, Excel provides a maximum number of segments in the first two conditions, including 2 tests, meet with a number of test conditions specified in the corresponding paragraph format, the other digital format for use in paragraph 3. If the test contains only one condition, they have different situations according to specific analysis.
custom format is equivalent to the general model the following formula: [>; 0] positive format; [<; 0] negative format; zero format; text format.
an example is given below: Select one, and then click the In the dialog box, select show Enter the text ; [blue] ,],[> As another example, assume that the ongoing settlement of accounts, you want to use the blue more than $ 50,000 account balance, negative values shown in brackets in red, the rest of the value of the color displayed by default, you can create the following format: character values can be used as a powerful auxiliary scale, for example, if the unit production of several products, as long as a few grams of each product of a compound, while the production of several thousand a day this product, then used in the preparation of the budget, you need to from g into kilograms, tons, then you can define the following format: custom format can be used to achieve the purpose of hiding the input data, such as the format Definition Format The appearance of only changing the data, the data does not change the value, that does not affect the calculation of data. flexible use of a good custom format function to the actual work will bring great convenience.
5, the draw function to do image
teaching friends will encounter problems drawn function curve now! If you want to quickly and accurately draw a function curve, a chart can make use of EXCEL functions, which enables you draw the curve of both standard and beautiful. You have to ask, is not hard to learn it? fact, this is not difficult, can be very simple, do not believe you told me to try.
to Draw y = | lg (6 + x ^ 3) | of the curve, for example, the method is as follows: in a blank worksheet, enter the function arguments: A column in the cell A1 enter that this is the independent variable, and then the A2 in the A column and box after successive small to large input from the values of variables; the actual input, the application of arithmetic progression is usually input method, enter the first two values, determined from the number of variables between the number of steps and then select the two cells A2 and A3, so that the two into a rectangle with a black border, and then point to the lower right corner of the small rectangular black box ■ generally written in the form, y = | lg (6 + x ^ 3) |; in cell B2 enter the , and then select cell B2, so that the cursor point to the lower right corner of the rectangle B2 7
drawn curve: Click on the toolbar, the items, given the data area, then the curve in front of us (Figure 8).
Figure 8
Note: How to determine the initial value of the independent variables, the data points What is the step between, this is according to the specific characteristics to determine the function, which is the ability of the test users. If you want to quickly find the function of the extreme or see its development trend of the data points are given not necessarily have to be arithmetic, can be arbitrarily given.
from simple to complex logarithmic trigonometric functions, exponential functions, can draw the curve with EXCEL. If available, you can Using EXCEL to complete the determinant, the matrix of the various calculations, a simple integral operation, the use of iteration of a function value (such as x ^ 2 = x ^ 7 +4, iteration method can find x value), and so on, all things related to computing, looking for EXCEL to help, it will give you a satisfactory answer.
6, a custom function
While Excel has a large number of built-in function, but some calculations which may also run into situations without function is available. If a company uses a special mathematical formula products, the purchaser's discount, if there is a function to calculate how much more convenient? said the following about how to create such a self- defined function.
custom functions, also called user-defined functions, Excel is the most innovative and attractive features, one of the following Visual Basic module, we create a function. In the following example, we to give each person the amount by a factor, if it is working meals at work, and beat the tickets; if it is working overtime meal time, and beat half of the amount; if it is a rest day to dinner, hit Jiuzhe. First, open the In the right-hand column to create the following function rrr, the following code: Function rrr (tatol, rr) If rr = Then rrr = 0.9 * tatol End If End Function (Figure 9).
Figure 9
then close the editor, as long as we enter in the appropriate column rrr (F2, B2) , then after the kick off even out the amount (Figure 10).
Figure 10
7, Matrix
Excel's powerful computing capabilities, not only for Simple arithmetic can also be an array, matrix calculations.
(1) the definition of arrays and matrices
matrix is not a number, but an array. In Excel, the array takes a unit field, the unit field with large brackets, such as {A1: C3}, in order and the general unit domain A1: C3 phase difference. settings, first select the unit field, press Shift + Ctrl + Enter keys, curly braces that is automatically generated, the array field able to confirm.
a cell is a variable, a unit of the domain can be regarded as a set of variables. In order to calculate the convenience, a set of variables to an array of the best name. For example A = {A1: C3 }, B = {E1: G3} and so on. array were set steps are: an array of field selected, click function - calculating a matrix of; MMULT - calculating the product of two matrices; SUMPRODUCT - the product of the calculation of all matrix elements corresponding to the sum.
Figure 11
(2) matrix array of basic computing and computing
matrix calculation is very different, such as the following example, A and B are defined array, as the two arrays are 3 × 3, the output is 3 × 3 unit cells. calculated results when the first output of the selected matrix domain, the range of cells for the 3 × 3, then enter the formula. If you enter added or subtracted, enter matrix addition, subtraction and addition and subtraction array is the same expression, but also A by B, the inverse matrix, so the formula is br>
8,
automatically switch the input method on a worksheet, the data is often both, there are text, so that input back and forth in the need to flip between English and Chinese input method much trouble. If you want to enter something very regular, such as this column is all words, all Chinese to explain the next column, you can use the following method for automatic switching. is:
(1) Select the column to type in English, click Mode , in the English, in the next column, you can directly enter the Chinese and English in order to achieve the automatic switching between input methods.
9, bulk delete blank lines
sometimes we need to delete Excel workbook blank lines, the general practice is to identify one by one blank line, and then delete it. If the number of rows in the table a lot of work, this is very inconvenient. We can use the deleted. approach: first in the table insert a new blank line, then press Ctrl + A keys to select the entire worksheet, right-click Then in the top of each column, are a drop-down list box, in a typical drop-down list box, select the column 13
in all cases the data have been selected, click the be deleted, and then click
If you want to delete only one empty cell in the column, while the other columns of data and blank cells are not affected, you can copy the first column, paste it to a blank worksheet will be empty by the above method delete all rows, then copy this column and paste it into the original location on the corresponding worksheet.
10, how to avoid the error message
enter the formula in Excel, sometimes not correctly to calculate results, and in the cell displays a error message, the production of these errors, some due to the formula itself, and some are not. Here's introduce some common error messages, and proposed ways to avoid mistakes. < br>
1) :####
mean error value: Enter the data into a cell or cell formula is too long the result is too large, so that the results displayed in the cell in less than . or the date and time format the cell to do subtraction, there has been negative.
solution: increase the width of the column so that the results can be fully displayed. If the date or time by subtracting the negative generated caused the cells to change the format to text format such as, the result is a negative amount of time.
2) error value: # DIV / 0!
meaning: trying to divide 0. This error is usually associated with the following situations: the divisor is 0, the divisor used in the formula or the empty cells contain a zero value cell reference cells.
solution: modify the cell reference, or used as a divisor input cell value is not zero.
3) error value: # VALUE!
meaning: the text-input mathematical formula item. If incorrect parameters or operator, or when performing an automatic correction function can not correct the formula for the formula, will produce an error message # VALUE!.
solution: At this time the formula or function should be required to confirm the operation character or parameters correctly, and that a formula references a cell contains a valid value. For example, cell C4 has a numeric or logical values, cell D4 contains the text, then the formula = C4 + D4, the system can not convert text the correct data type, which returns the error value # VALUE!.
4) error value: # REF!
meaning: delete the formula referenced by the range of cells.
< br> The solution: restore the referenced cell range, or re-set the reference range.
5) error value: # N / A
meaning: no information can be used to run calculations. in the establishment of model, the user can enter in a cell # N / A, to show that is waiting for data. containing any reference to # N / A value of the cell will return # N / A.
Solution: waiting for the data cell is filled with data.
6) error value: # NAME?
meaning: the formula used in Excel can not recognize the text, such as may lose the wrong name, or enter a name deleted, if not the literal string enclosed in double quotes, will produce the error value
solution: If you are using a non-existent Name this type of error generated, should be sure to use the name does exist; if the name, function name, spelling mistakes should be corrected; the text string enclosed in double quotes; sure all areas used in the formula are used in reference to a colon ( :). For example: SUM (C1: C10). Note that the formula in the text enclosed in double quotes.
7) error value: # NUM! meaning: to provide an invalid argument to the worksheet functions or the result of the formula is too large or too small to be expressed in the worksheet.
solution: Make sure the function parameter type used is correct. If the result is too big or too small for the formula, it is necessary to modify the formula so that it results in -1 × 10307 and between 1 × 10307.
8) error value: # NULL! meaning: in the formula to insert a space between the two areas to represent the intersection But these two, there is no public cell. such as the input: grid. the style can be changed to the specified action. macro is similar to a computer program, but it is being fully operational in EXCEL, we can use a macro to complete the tedious, often repetitive work. macro to complete the action faster than the users themselves do much faster. For example, we can create a macro for each row of the worksheet, enter a date and in each cell within the center-aligned date and format of this border-line application. We can also create a macro, in the macro to help. In fact, you may rest assured bold to use, if only with a , the system will put the operation and run it again.
macro given below applications, as long as the then edit the macro, we should have some knowledge of VBA.
* set a table for each job requires a fixed form of the header;
* set the cell into a species has its own style in the form;
* are fixed for each print page setup;
* frequently or repeatedly enter some fixed content, such as the line up of companies address format , personnel lists, etc.;
* create a formatted table;
* insert a thin sheet or other.
be pointed out that, EXCEL and WORD in the macro Some of the difference between the macro, for the recording operation, it will remember the coordinates of the cell (ie, all references are absolute), so when it comes to the operation of position, we should pay particular attention to. If the relative phase with reference, to learn from Offset methods, such as the following statement: ActiveCell.Offset (1,0). range (up, you will find it to have more content and more flexible application methods.
12, the chart application skills
Excel offers 14 standard chart types, each of which with a variety of combinations and transformations. Among the many chart types, select a chart that better? according to the different data and different application requirements, you can choose different types of charts. The choice of the chart form with the data related to Second, before considering the effectiveness and sense of aesthetics. Here are some common rules.
area chart: shows the magnitude of change over time. When there are changes in several parts, and the sum of those parts of you interested in, they are particularly useful. area chart that you see changes in the various parts separately, but also see the overall change.
bar: composed by a series of horizontal bars. makes the timeline a certain point, two or more items is comparable relative size. For example: it can compare each quarter, the three products in the sales of any kind. bar in each worksheet is a separate data points or number. because it is the row and column column is exactly transfer over, so are sometimes used interchangeably.
Column: composed by a series of vertical bars, usually used to compare period of time two or more projects in the relative size. For example: quarterly or annual sales of different products compare, in several projects in the allocation of funds from different departments, so each year the number of various types of information. bar is the application of more wide chart types, a lot of people are using the chart from its beginning.
Line: is used to show trends over time. For example: the data over time is an increasing trend, and the other a time in a downward trend, we can line chart, to predict the future. For example: speed - time curve, thrust - fuel consumption curve, lift coefficient - Mach number curve, the pressure - temperature curve, the fatigue strength - rotation curve transfusion power penalty - distance curve, using a line chart can be expressed more generally in engineering applications, if there are several situations in which a data, a line chart where there are several different lines, such as five athletes In the course of the rate of change of meters, there are five line, compared to each other, can also add a trend line to predict the speed.
stock figure: the three data series is a line chart, was used to show a given time period of the subject shares of high, low and close. by the highest, lowest drawing lines between data points forming vertical lines, while the axis of the closing price on behalf of a small scale. stock chart used for financial , commerce and industry, used to describe commodity prices, currency exchange rates and the temperature, pressure measurement, of course, describe the stock price is the most adept.
pie chart: number of data used for comparison The formation of a percentage of the value of the sum of the most useful. representative of the whole sum of bread, each with a wedge or slice the number of representatives. such as: sales of different products that the percentage of total sales, the units of the total funding requirements the proportion of books collected, how many of each type and so on. expressions pie chart although only one data column, but because the expression was clear and easy to use and easy to learn, so in practice more than used. If to several series of data, can be circular diagram.
radar: How to display data or other data changes at the center. coordinate values for each category of radiation from a central point. from the same sequence of data connected with lines. You can use radar to map the sequence of several interrelated, it is easy to make a visual contrast. For example: You have three parts with five identical machines, the radar can draw on each one machine for each component wear.
XY scatter: display the number of pairs and they represent the relationship between the trend. For each number on a number is drawn in the X axis, while the other was drawn in the Y axis. had two points in the vertical axis, intersecting at a mark on the chart. When a large number of such numbers being drawn, the emergence of a graph. scatterplot important role is to function can be used to draw the curve, from simple trigonometric, exponential functions, logarithmic functions to more complex hybrid function, you can use to quickly and accurately draw the curves, so in teaching, often used in scientific computing to.
There are other types of charts, such as Cylinder, Cone, Pyramid, just a variation of bar and column charts, with no outstanding features, but with a relatively small here stop here. here is to note: This is only general application of the chart, sometimes a set of data can be used to express a variety of charts, then we should be selected according to specific circumstances. on some chart, if drawn into the cylinder of a data sequence, and the other drawn into a line chart or area chart, the chart will look better.
L in EXCE in combination allows the creation of such charts, but if you want EXCEL is not allowed to create a combination of chart types, such as a two-dimensional map can not be the same mix with a three-dimensional chart, this combination is not possible, the system will display an error message. how to build mixed-chart it? click Chart Wizard Click the
2. The merger of the cell contents
3. Conditions indicate
4. Custom format
5. Drawing Function Image
6. Custom functions
7 . Matrix
8. automatically switch the input method
9. batch delete empty lines
10. how to avoid the error message
11. macro use
12. the icon of the application of skills
1, editing skills
1 editing skills
(4) fill streak
If you want to add the beautiful in the workbook The horizontal stripes, can use the alignment of the filled function. First filled in a cell of
Figure 1
(5) multiple sheets to enter the same content in several worksheets
enter the same data in the same location, you can select a worksheet, and then hold down the Ctrl key, then click the window to the bottom left corner of the Sheet1, Sheet2 ...... to directly select the input the same content multiple sheets, then in any one of them to enter these same worksheet data, then the data will automatically appear in the table selected among other work. After input finished, press the Ctrl key on the keyboard, then use the left mouse button click on the selected multiple worksheets, work table to remove these links, or in a form input data will then appear in the election the other work table.
(6) cells do not populate the same data continuously
select a cell, hold down the Ctrl key, right click the other cells, it will select all those cells the. Enter data in the edit area, then hold down the Ctrl key while you tap Enter, in all the selected cells have emerged in the data.
(7) to display the formula in cell
data in the table if the majority of work is generated by a formula and want to quickly know the formula for each cell in the form of, for editing , you can do: Use the left mouse button click on At this time the division of labor in each cell that come. If you want to restore the display of calculated results to re-set
Figure 2
(8) Select the text using Ctrl + *
a work table, if there are many data tables, you can select the table by a cell, and then press Ctrl + * key to select the entire table. Ctrl + * the selected region: According to the selected cell to the surrounding radiation data involved are the largest regional cell. So that we can easily and accurately select the data table, and effective method to avoid dragging large range of cells selected screen Luangun phenomenon.
(9) quickly remove the contents of the cell
If you want to delete the contents of the cell content and its format and comments, can not simply be applied to the cell selected, then press the Delete key way to go. To completely remove the cells, using the following method: you want to remove the selected cell or range of cells; click the
2, the combined cell contents
needed, and sometimes want to B and C list the contents of the column to merge, if the number of rows less, can directly use the Paste
solution is: In the C line, insert a blank line (if the D column is not content to operate directly in the D column), in D1, enter , C, and the two columns. Select cell D1, the cell with the mouse to point the bottom right corner of the small box B series and C series combined. Then do not just put the first B and C column remove column, the first column of the results of D should copy it, and then Time you delete B, C, D columns.
The following is a With AutoCAD drawing, some people like the coordinate point is stored in EXCEL, called when drawing curves in these parameters. Stored data format is merged into C column, enter in C1: = A1 &All contents of the combined (see Figure 3-4).
merge the contents of different cells, there is a way is to use CONCATENATE function, the function of certain text string into a string, the specific operation for the . For example, assume that the investigation in a river ecosystem in the table, B2 contains ,
Figure 3 Figure 4
3, conditions indicate
we know, the use of If the function can be achieved in accordance with the conditions of display. A common example is when the teachers in student achievement statistics, want to enter scores below 60, can appear as This effect, the use of IF functions can be easily achieved. Assumption results in the A2 cell, determine the results in cell A3. Then in cell A3 enter the formula: = if (A2 <60,
For example, if you type: = if (A2 <60,
If you enter = if (A2 <60, to four grades.
another example, the formula: = if (SUM (A1: A5> 0, SUM (A1: A5), 0) this style on the use of a nested function, meaning that, when A1 to A5 and large at 0, returns this value if less than 0, it returns 0. Another point to draw your attention: The above symbols are the half-angle, and the IF with no spaces between brackets.
4, the custom format
Excel by default a lot of useful data formats, and can basically meet the requirements of use, but for some special requirements, such as the emphasis on some important data or information display, set the display conditions so, we must use a custom format function to complete. Excel custom format using the following general model: a positive number format, negative format, zero format, text format, in this general model, containing three numbers and a text paragraph section: use of data greater than zero positive number format; less than zero data using a negative format; zero data using a zero format; enter the body cells to use text format. We can also use the test, add descriptive text and the use of custom format color to extend the application of universal model.
(1) use of color in a custom format to a paragraph set the color, simply add the paragraph in square brackets the color name or color number. Excel recognize the color is named: [black], [Red], [White], [Blue], [Green], [blue] and [magenta]. Excel is also identified by [color X] specified colors, where X is a number between 1-56, representing 56 kinds of colors (Figure 5).
Figure 5
(2) add description text in the input digital data to automatically after add text, using a custom format: add text position.
(3) create a conditional format of six logic symbols can be used to design a conditional format: ),<=( less than or equal), = (equal ),<>( not equal), bad if you think these symbols in mind, simply use the .
the custom number format, up to only 3 field, Excel provides a maximum number of segments in the first two conditions, including 2 tests, meet with a number of test conditions specified in the corresponding paragraph format, the other digital format for use in paragraph 3. If the test contains only one condition, they have different situations according to specific analysis.
custom format is equivalent to the general model the following formula: [>; 0] positive format; [<; 0] negative format; zero format; text format.
an example is given below: Select one, and then click the In the dialog box, select show Enter the text ; [blue] ,],[> As another example, assume that the ongoing settlement of accounts, you want to use the blue more than $ 50,000 account balance, negative values shown in brackets in red, the rest of the value of the color displayed by default, you can create the following format: character values can be used as a powerful auxiliary scale, for example, if the unit production of several products, as long as a few grams of each product of a compound, while the production of several thousand a day this product, then used in the preparation of the budget, you need to from g into kilograms, tons, then you can define the following format: custom format can be used to achieve the purpose of hiding the input data, such as the format Definition Format The appearance of only changing the data, the data does not change the value, that does not affect the calculation of data. flexible use of a good custom format function to the actual work will bring great convenience.
5, the draw function to do image
teaching friends will encounter problems drawn function curve now! If you want to quickly and accurately draw a function curve, a chart can make use of EXCEL functions, which enables you draw the curve of both standard and beautiful. You have to ask, is not hard to learn it? fact, this is not difficult, can be very simple, do not believe you told me to try.
to Draw y = | lg (6 + x ^ 3) | of the curve, for example, the method is as follows: in a blank worksheet, enter the function arguments: A column in the cell A1 enter that this is the independent variable, and then the A2 in the A column and box after successive small to large input from the values of variables; the actual input, the application of arithmetic progression is usually input method, enter the first two values, determined from the number of variables between the number of steps and then select the two cells A2 and A3, so that the two into a rectangle with a black border, and then point to the lower right corner of the small rectangular black box ■ generally written in the form, y = | lg (6 + x ^ 3) |; in cell B2 enter the , and then select cell B2, so that the cursor point to the lower right corner of the rectangle B2 7
drawn curve: Click on the toolbar, the items, given the data area, then the curve in front of us (Figure 8).
Figure 8
Note: How to determine the initial value of the independent variables, the data points What is the step between, this is according to the specific characteristics to determine the function, which is the ability of the test users. If you want to quickly find the function of the extreme or see its development trend of the data points are given not necessarily have to be arithmetic, can be arbitrarily given.
from simple to complex logarithmic trigonometric functions, exponential functions, can draw the curve with EXCEL. If available, you can Using EXCEL to complete the determinant, the matrix of the various calculations, a simple integral operation, the use of iteration of a function value (such as x ^ 2 = x ^ 7 +4, iteration method can find x value), and so on, all things related to computing, looking for EXCEL to help, it will give you a satisfactory answer.
6, a custom function
While Excel has a large number of built-in function, but some calculations which may also run into situations without function is available. If a company uses a special mathematical formula products, the purchaser's discount, if there is a function to calculate how much more convenient? said the following about how to create such a self- defined function.
custom functions, also called user-defined functions, Excel is the most innovative and attractive features, one of the following Visual Basic module, we create a function. In the following example, we to give each person the amount by a factor, if it is working meals at work, and beat the tickets; if it is working overtime meal time, and beat half of the amount; if it is a rest day to dinner, hit Jiuzhe. First, open the In the right-hand column to create the following function rrr, the following code: Function rrr (tatol, rr) If rr = Then rrr = 0.9 * tatol End If End Function (Figure 9).
Figure 9
then close the editor, as long as we enter in the appropriate column rrr (F2, B2) , then after the kick off even out the amount (Figure 10).
Figure 10
7, Matrix
Excel's powerful computing capabilities, not only for Simple arithmetic can also be an array, matrix calculations.
(1) the definition of arrays and matrices
matrix is not a number, but an array. In Excel, the array takes a unit field, the unit field with large brackets, such as {A1: C3}, in order and the general unit domain A1: C3 phase difference. settings, first select the unit field, press Shift + Ctrl + Enter keys, curly braces that is automatically generated, the array field able to confirm.
a cell is a variable, a unit of the domain can be regarded as a set of variables. In order to calculate the convenience, a set of variables to an array of the best name. For example A = {A1: C3 }, B = {E1: G3} and so on. array were set steps are: an array of field selected, click function - calculating a matrix of; MMULT - calculating the product of two matrices; SUMPRODUCT - the product of the calculation of all matrix elements corresponding to the sum.
Figure 11
(2) matrix array of basic computing and computing
matrix calculation is very different, such as the following example, A and B are defined array, as the two arrays are 3 × 3, the output is 3 × 3 unit cells. calculated results when the first output of the selected matrix domain, the range of cells for the 3 × 3, then enter the formula. If you enter added or subtracted, enter matrix addition, subtraction and addition and subtraction array is the same expression, but also A by B, the inverse matrix, so the formula is br>
8,
automatically switch the input method on a worksheet, the data is often both, there are text, so that input back and forth in the need to flip between English and Chinese input method much trouble. If you want to enter something very regular, such as this column is all words, all Chinese to explain the next column, you can use the following method for automatic switching. is:
(1) Select the column to type in English, click Mode , in the English, in the next column, you can directly enter the Chinese and English in order to achieve the automatic switching between input methods.
9, bulk delete blank lines
sometimes we need to delete Excel workbook blank lines, the general practice is to identify one by one blank line, and then delete it. If the number of rows in the table a lot of work, this is very inconvenient. We can use the deleted. approach: first in the table insert a new blank line, then press Ctrl + A keys to select the entire worksheet, right-click Then in the top of each column, are a drop-down list box, in a typical drop-down list box, select the column 13
in all cases the data have been selected, click the be deleted, and then click
If you want to delete only one empty cell in the column, while the other columns of data and blank cells are not affected, you can copy the first column, paste it to a blank worksheet will be empty by the above method delete all rows, then copy this column and paste it into the original location on the corresponding worksheet.
10, how to avoid the error message
enter the formula in Excel, sometimes not correctly to calculate results, and in the cell displays a error message, the production of these errors, some due to the formula itself, and some are not. Here's introduce some common error messages, and proposed ways to avoid mistakes. < br>
1) :####
mean error value: Enter the data into a cell or cell formula is too long the result is too large, so that the results displayed in the cell in less than . or the date and time format the cell to do subtraction, there has been negative.
solution: increase the width of the column so that the results can be fully displayed. If the date or time by subtracting the negative generated caused the cells to change the format to text format such as, the result is a negative amount of time.
2) error value: # DIV / 0!
meaning: trying to divide 0. This error is usually associated with the following situations: the divisor is 0, the divisor used in the formula or the empty cells contain a zero value cell reference cells.
solution: modify the cell reference, or used as a divisor input cell value is not zero.
3) error value: # VALUE!
meaning: the text-input mathematical formula item. If incorrect parameters or operator, or when performing an automatic correction function can not correct the formula for the formula, will produce an error message # VALUE!.
solution: At this time the formula or function should be required to confirm the operation character or parameters correctly, and that a formula references a cell contains a valid value. For example, cell C4 has a numeric or logical values, cell D4 contains the text, then the formula = C4 + D4, the system can not convert text the correct data type, which returns the error value # VALUE!.
4) error value: # REF!
meaning: delete the formula referenced by the range of cells.
< br> The solution: restore the referenced cell range, or re-set the reference range.
5) error value: # N / A
meaning: no information can be used to run calculations. in the establishment of model, the user can enter in a cell # N / A, to show that is waiting for data. containing any reference to # N / A value of the cell will return # N / A.
Solution: waiting for the data cell is filled with data.
6) error value: # NAME?
meaning: the formula used in Excel can not recognize the text, such as may lose the wrong name, or enter a name deleted, if not the literal string enclosed in double quotes, will produce the error value
solution: If you are using a non-existent Name this type of error generated, should be sure to use the name does exist; if the name, function name, spelling mistakes should be corrected; the text string enclosed in double quotes; sure all areas used in the formula are used in reference to a colon ( :). For example: SUM (C1: C10). Note that the formula in the text enclosed in double quotes.
7) error value: # NUM! meaning: to provide an invalid argument to the worksheet functions or the result of the formula is too large or too small to be expressed in the worksheet.
solution: Make sure the function parameter type used is correct. If the result is too big or too small for the formula, it is necessary to modify the formula so that it results in -1 × 10307 and between 1 × 10307.
8) error value: # NULL! meaning: in the formula to insert a space between the two areas to represent the intersection But these two, there is no public cell. such as the input: grid. the style can be changed to the specified action. macro is similar to a computer program, but it is being fully operational in EXCEL, we can use a macro to complete the tedious, often repetitive work. macro to complete the action faster than the users themselves do much faster. For example, we can create a macro for each row of the worksheet, enter a date and in each cell within the center-aligned date and format of this border-line application. We can also create a macro, in the macro to help. In fact, you may rest assured bold to use, if only with a , the system will put the operation and run it again.
macro given below applications, as long as the then edit the macro, we should have some knowledge of VBA.
* set a table for each job requires a fixed form of the header;
* set the cell into a species has its own style in the form;
* are fixed for each print page setup;
* frequently or repeatedly enter some fixed content, such as the line up of companies address format , personnel lists, etc.;
* create a formatted table;
* insert a thin sheet or other.
be pointed out that, EXCEL and WORD in the macro Some of the difference between the macro, for the recording operation, it will remember the coordinates of the cell (ie, all references are absolute), so when it comes to the operation of position, we should pay particular attention to. If the relative phase with reference, to learn from Offset methods, such as the following statement: ActiveCell.Offset (1,0). range (up, you will find it to have more content and more flexible application methods.
12, the chart application skills
Excel offers 14 standard chart types, each of which with a variety of combinations and transformations. Among the many chart types, select a chart that better? according to the different data and different application requirements, you can choose different types of charts. The choice of the chart form with the data related to Second, before considering the effectiveness and sense of aesthetics. Here are some common rules.
area chart: shows the magnitude of change over time. When there are changes in several parts, and the sum of those parts of you interested in, they are particularly useful. area chart that you see changes in the various parts separately, but also see the overall change.
bar: composed by a series of horizontal bars. makes the timeline a certain point, two or more items is comparable relative size. For example: it can compare each quarter, the three products in the sales of any kind. bar in each worksheet is a separate data points or number. because it is the row and column column is exactly transfer over, so are sometimes used interchangeably.
Column: composed by a series of vertical bars, usually used to compare period of time two or more projects in the relative size. For example: quarterly or annual sales of different products compare, in several projects in the allocation of funds from different departments, so each year the number of various types of information. bar is the application of more wide chart types, a lot of people are using the chart from its beginning.
Line: is used to show trends over time. For example: the data over time is an increasing trend, and the other a time in a downward trend, we can line chart, to predict the future. For example: speed - time curve, thrust - fuel consumption curve, lift coefficient - Mach number curve, the pressure - temperature curve, the fatigue strength - rotation curve transfusion power penalty - distance curve, using a line chart can be expressed more generally in engineering applications, if there are several situations in which a data, a line chart where there are several different lines, such as five athletes In the course of the rate of change of meters, there are five line, compared to each other, can also add a trend line to predict the speed.
stock figure: the three data series is a line chart, was used to show a given time period of the subject shares of high, low and close. by the highest, lowest drawing lines between data points forming vertical lines, while the axis of the closing price on behalf of a small scale. stock chart used for financial , commerce and industry, used to describe commodity prices, currency exchange rates and the temperature, pressure measurement, of course, describe the stock price is the most adept.
pie chart: number of data used for comparison The formation of a percentage of the value of the sum of the most useful. representative of the whole sum of bread, each with a wedge or slice the number of representatives. such as: sales of different products that the percentage of total sales, the units of the total funding requirements the proportion of books collected, how many of each type and so on. expressions pie chart although only one data column, but because the expression was clear and easy to use and easy to learn, so in practice more than used. If to several series of data, can be circular diagram.
radar: How to display data or other data changes at the center. coordinate values for each category of radiation from a central point. from the same sequence of data connected with lines. You can use radar to map the sequence of several interrelated, it is easy to make a visual contrast. For example: You have three parts with five identical machines, the radar can draw on each one machine for each component wear.
XY scatter: display the number of pairs and they represent the relationship between the trend. For each number on a number is drawn in the X axis, while the other was drawn in the Y axis. had two points in the vertical axis, intersecting at a mark on the chart. When a large number of such numbers being drawn, the emergence of a graph. scatterplot important role is to function can be used to draw the curve, from simple trigonometric, exponential functions, logarithmic functions to more complex hybrid function, you can use to quickly and accurately draw the curves, so in teaching, often used in scientific computing to.
There are other types of charts, such as Cylinder, Cone, Pyramid, just a variation of bar and column charts, with no outstanding features, but with a relatively small here stop here. here is to note: This is only general application of the chart, sometimes a set of data can be used to express a variety of charts, then we should be selected according to specific circumstances. on some chart, if drawn into the cylinder of a data sequence, and the other drawn into a line chart or area chart, the chart will look better.
L in EXCE in combination allows the creation of such charts, but if you want EXCEL is not allowed to create a combination of chart types, such as a two-dimensional map can not be the same mix with a three-dimensional chart, this combination is not possible, the system will display an error message. how to build mixed-chart it? click Chart Wizard Click the
Sunday, May 8, 2011
Happy feeling like you __
a long time without my diary , write a few words today, so it just bored
the past few days are thinking about a person, this feeling strange , as if had not been seen in decades, the
fast from eleven days to the present understanding of it, in the ten day I 'll think of you ; this feeling seems to become stronger, haha
sad since the last time ever , the math should also have a few years now ; now finally began to feel something , that is, if I do not know whether the chance
hey ~~~~~ In fact, I 'm not quite pick ah ; I want is a feeling ; sometimes I was quite easily satisfied , haha
maybe I really hope to have some feeling of happiness , even if it is to see others happy feeling , I will happy
accidentally open your album today and saw a lot of happy pictures oh
feel you are a quiet, innocent , happy , happy children ,,,,,, ,,,,,,, haha feeling really want to have
your quiet your innocence your happiness you the kind of self-satisfaction and meet ,,,,, I like these are what I aspire
I think if they can integrate into your lives , I certainly can feel your joy and happiness brought it
God, I will not again be poisoned to death ah ~~~~~~~ poor me Oh, please God help me ~~~~~
the past few days are thinking about a person, this feeling strange , as if had not been seen in decades, the
fast from eleven days to the present understanding of it, in the ten day I 'll think of you ; this feeling seems to become stronger, haha
sad since the last time ever , the math should also have a few years now ; now finally began to feel something , that is, if I do not know whether the chance
hey ~~~~~ In fact, I 'm not quite pick ah ; I want is a feeling ; sometimes I was quite easily satisfied , haha
maybe I really hope to have some feeling of happiness , even if it is to see others happy feeling , I will happy
accidentally open your album today and saw a lot of happy pictures oh
feel you are a quiet, innocent , happy , happy children ,,,,,, ,,,,,,, haha feeling really want to have
your quiet your innocence your happiness you the kind of self-satisfaction and meet ,,,,, I like these are what I aspire
I think if they can integrate into your lives , I certainly can feel your joy and happiness brought it
God, I will not again be poisoned to death ah ~~~~~~~ poor me Oh, please God help me ~~~~~
Thursday, May 5, 2011
Reprinted Why to hurt a loved one
? ? Is love a person wrong? ? ?Wrong , wrong, wrong ,
Why hurt a loved one ? ? ? Is love a person wrong? ? ? Lavender Passion flower
you are my Dependents , Scattered , and forget I hope that I You say I sent you as a receipt of that letter , Do not ask that the paper drops the Never break up! ... looked straight ahead to turn! ! ! ! ! ( love someone right )!
Why hurt a loved one ? ? ? Is love a person wrong? ? ? Lavender Passion flower
you are my Dependents , Scattered , and forget I hope that I You say I sent you as a receipt of that letter , Do not ask that the paper drops the Never break up! ... looked straight ahead to turn! ! ! ! ! ( love someone right )!
Wednesday, May 4, 2011
Reprinted 40 Let your baby smart , and I hope each of us are extremely intelligent baby !
-
Let your baby smart 40, and I hope each of us are extremely intelligent baby! Woods -
Keep it super useful! 40 smart your baby, and I hope each of us are extremely intelligent baby! -
baby's intelligence is the father and mother have been very concerned about the issue, but this requires a slow process, here to improve the baby's 40 intelligence, and I hope to to improve the intelligence of help your baby. -
-
-
-
-
one. improve the baby logic -
1, test reasoning -
you and your baby ready to eat breakfast, but have not opened the boxes early, parents can allow children to guess: This method can improve children's mathematical logic intelligence. -
2, the stair count -
up and down stairs make the child feel tired and tasteless, but if this time with some interesting ways the parents can not only make your baby smart has improved, and the baby was noisy on the stairs to adults and hold their condition will also be greatly reduced . Parents can lead the children a level one step, layer by layer counting the order of the stairs, and often the process of climbing the stairs, the children's mathematical logic, intelligence will be increased. -
3, considered way, a few numbers -
kids go out, you can use to go home for some time, because time is very adequate way home, the child's mood is mostly relaxed. This time, in the face of all of the road extending in all directions, let the children identify and remember to identify the characteristics of the road and the differences, learn to use reference to know the route, can improve children's observation. -
the way home, you can also teach children the number of house number, to distinguish which side is even, which side is odd, can strengthen children's number concepts, to enhance the mathematical logic of intelligent help. -
4, find program schedules -
watching TV at night, when the children love to see what the program is broadcast it? reported on the TV to find the time to teach children about time. This can develop children's mathematical abilities, and children can unconsciously learn some Chinese characters. -
5, and children with few toys -
before going to bed at night, let the children put their toys packed. To do their own thing their own, but parents can assist, to take this opportunity to help children learn new skills. At first, parents and children can be loud with a few toys, put away the number one finished one. Children will be able to know the count by imitating the order, after the number can let the children and put a toy. This can foster the children's mathematical intelligence. -
6, see product price -
shopping, the parents and children to take a look at the labels of goods, let the children know that every kind of product has its price. And children and then calculate, how much money to buy two pieces, mother of 10 dollars, enough to buy a few ... ... It can have a first child on the concept of money, but also to enhance his mathematical intelligence. -
7, change clothing and mathematics -
warm weather, clothes to be reduced; the winter cold, clothes to be increased accordingly. In this process, you can and the number of children with the number of clothes, summer wear unlined 1; fall underwear + sweater + coat of 3 parts; winter underwear + sweater + jacket + winter clothes 4 pieces. In this process, the baby will be the cold weather and wear thick clothes to keep warm and the weather to cool and heat and wear thin clothes linked to the lives of children from specific experiences to enhance proprioception, awareness of nature. -
clothes to wear off in time for your baby to button his own shirt, from top to bottom lines, or lines from the bottom up, so that the baby's mathematical logic intelligence has been improved. -
-
-
-
-
II. Enhancement and people skills -
8, with people greeting -
teach children to meet acquaintances say hello say hello to them. When teaching children to say hello to a different courtesy title, such as This can improve the child's interpersonal intelligence. -
9, let the children to introduce yourself -
calling to see, let a child simply to introduce myself, do not talk too much, if the child shy, just tell us the name, age on it, which not only foster the children's interpersonal skills, but also enhance the introspection of his intelligence. -
10, similar to the age of the children's families have a guest -
Sometimes parents have to pick about a guest of the object. To have children of people to dinner for children to create with people's time. And playing with the children, but also to cultivate the awareness of children teamwork and cooperation. -
11, let the children come to help -
parents can pretend to have difficulties, let the children come to give you a hand, look like rags, etc. to help rub. Through labor, children can build self-awareness of services and service to others. To help parents give their children a sense of participation requests, and can train his first cooperative, on his good interpersonal communication. -
12, your baby ask for directions -
mothers can often take to the streets with children in the street, the mother should encourage the baby to ask for directions, which can improve his interpersonal intelligence, because the road to ask a stranger, the baby can fully exercise interpersonal skills. -
-
-
-
-
III. enhance spatial intelligence -
13, identify the direction of -
way to teach children to pay attention to recognize Road, to identify the direction, such as the building for identification markings. In particular, to the crossroads and other complex terrain, allows children to observe the up, down, left, right, front and rear in all directions. This can improve the child's spatial intelligence, let the children familiar with the roads. -
14, identify the four cardinal points -
teach children to use to find their way around the landscape, as with a balcony, leaf orientation, signs, etc. to help identify the truck, the training helps the child a sense of direction, but also enhance the child's spatial intelligence. -
15, to give the baby the next instruction -
mother for your baby to be a small help, give him a proper ground instruction, such as . Talk to the baby, mother and more with the following words: inside, above, below, front, back, top, bottom and so on. This can improve the baby's spatial intelligence. -
16, observe the leaves change -
seasons, the most obvious changes in the plant. Life, to observe changes in the leaves throughout the year, your baby learn the concept of the season, while enhancing baby's visual-spatial intelligence. -
summer foliage color is emerald green, to yellow autumn, while in the winter to fall away, leaving only isolated branches, but the spring, the green tree buds and reared their ugly heads . Parents can observe the same tree with the baby, observed 1 year and explain one of the reasons for the baby. -
leaf color change, growth, and withered at the turn of the baby's sight continually to improve the child's spatial intelligence and natural intelligence. -
17, look at the map to find directions -
ready to travel before it is best to buy a map of tourist destinations, of course, you can buy at your destination. Do not underestimate this map, but you raise your baby is an effective tool for spatial intelligence. -
you tell the baby the next target, so that the baby is now on the map to find your location and destination location, and find a way forward in the right direction. The way to the destination, but also to remind parents to see baby signs, destination, and then pulled out a map so that the baby recognized targets are correct. -
This process seems complex, but in raising the baby's spatial intelligence is very effective, while the baby's sense of direction. Space of imagination and execution have also been training and training. -
18, school name, and know the scene along the way -
pointing the way streets, stations, buildings, tell the child their own name, the construction of age. Enhance the child's linguistic intelligence, an increase of the child's knowledge. -
allows children to observe the natural landscape along the way for the introduction to the child, and told him the name of a variety of landscapes, characteristics, function, seasonal changes, improve children's observation -
-
IV. exercise of speech -
19, the child described his favorite animated character -
the role of their favorite children must be very deep impression. Allows children to listen to the mother described as his favorite characters look like, is a small duck, or a large Benxiong, the color of its mouth is and so on. This can foster the children's powers of observation and language skills. -
20, to walk and sing songs -
parents with children walking in the road, there are many opportunities to increase knowledge of the child, the child can guess, such as vivid songs of this will be of interest, is conducive to the child's linguistic intelligence. -
-
-
21, describe the item feature -
mother holding a baby can be items of interest, as he describes the characteristics of one or more items, such as talk about its color (green is the grass-like); or its shape and size (small round ball); to the amount of (two orange); or its texture (soft or hard); or describe its sound (TV sound great, very noisy). Also allows the baby to try to describe the characteristics of the goods. -
baby in the process learned to use language and organization of language, his linguistic intelligence can also be improved. -
22, decide together what to buy -
in the shopping process, you can let your baby's attention to the things you are doing, as is the selection of bread, and baby you can discuss your ideas, and let the baby tell his idea, he must will say why buy the bread, perhaps like good-looking, perhaps smells and so on. Finally, we are satisfied to make a decision, the baby in his views at the same time, greatly enhance the logic of his intelligence and linguistic intelligence. -
-
-
-
-
five. cultivate artistic -
23, singing -
children singing nursery teacher in the way of the songs, can mobilize the child's emotional, because in kindergarten, not every child has the opportunity to sing alone, let him alone to sing if he would be interested in music . -
24, easy listening to upbeat music work -
you are not the whole family once a week cleaning it? allows children with you, while cleaning, while listening to upbeat music. This can improve our emotional labor, the child will think this is a happy time and help to develop the good habit of his labor of love, but also to enhance his musical intelligence. -
VI. training in observation and memory -
25, identify the vegetables -
children identify vegetables, spinach and other vegetables, to identify their similarities and their respective characteristics, can improve children's naturalist intelligence. -
26, observe the color change of dishes -
her mother cook, let the children practice to determine when the cooked vegetables, look for lettuce and ready meal of different color, can train the child's observation. -
27, observing the order of cooking -
mother cooking, carefully observe your baby next to her mother in the cooking process, do a good job, let him step out of a dish, such as making celery shredded pork or shredded pork first, when the first fried celery so, this will train the child's memory, increase knowledge of children's lives. -
28, describes the nutritional value -
meal to accompany the baby, the parents start with the nutritional value of each dish, and then see how many children can remember not only increase the knowledge and the training of the memory. -
29, to draw their favorite characters -
children according to the way television roles like he likes to draw. TV screen is not fixed, so it can not only develop the child's observation, but also training his memory. -
30, say the color of toys -
allows children to first say the color of a toy, and then repeat the same color as what toys that can teach children about color, but also to cultivate children's visual resolution and observation. -
31, the same material to teach children to find toys -
can teach the child to put together toys of different materials, such as some plastic toys, some stuffed toys, and some made of wood toys. This can foster the children's tactile perception and visual resolution, let the children learn classification. -
32, identify colors -
parents can take advantage of opportunities, let the children learn to identify a variety of colors. If the color of the leaves are green, there are yellow, you can also ask the baby, There are many different colors of outdoor plants, you can teach your baby to distinguish the type and color of flowers such as chrysanthemums very many varieties, color is diverse, is very good natural materials. Colors in the identification process, the baby's visual intelligence constantly stimulated, give full play to his visual ability, to develop his ability to identify and observation. Identify the color of his parents were not to be implied as far as possible, let your baby to observe things around, to recognize visual objects are looking for. -
33, to identify the sound -
take your baby to an outdoor environment close to nature, the chances of exposure to natural sounds, parents can tell the baby to listen to a voice note. For example, animal sounds, sound of water streams, wind and thunder, can be used to enhance your baby's hearing. We live in a town where there are many voices, such as: motorcycle boot, car horn, fire engine blew, knocking build tall buildings, etc., can be used to stimulate baby's hearing. With these voices in the memory of your baby, you can let him hear the sound immediately after identification. By stimulating the baby's hearing will make him feel more sensitive and more clever. -
34, touch things guess name -
in outdoor activities, parents can use the outdoor experience of various materials, shapes, sizes and so something different to enhance your baby's tactile skills. Let the baby put his hand behind the palm facing up, the parents picked up all kinds of little things to put on the baby's palm, to let him look at the hands of the things described the feeling of touching up, and then say that he guessed the answer. For example, parents of the baby can touch the pebbles in his hand, said: guessed right. Enhance such intelligence activities in addition to using still life, you can also use the animals. See if the baby can not guess is that he is a touch silkworms, or an ant. -
-
-
-
-
VII. enhance intrapersonal intelligence -
35, deliberately wrong thing -
talk with their children, the deliberately wrong one thing we all know, or a story wrong, for example, the sun is shining today, and you say weather is bad today, to see the child's response, which can improve the child Provincial intelligence, logical intelligence. -
37, to express feelings -
chat with family and suddenly the child is not to judge other people happy family, happy and to what extent; or tell a story, let the children practice the expression of joy, anger, sadness and joy and other emotions, to enhance the child's introspection intelligence. -
38, your baby travel in preparation -
before the trip, parents will be prepared items, do not think this is an adult thing, nothing to do with the baby, in fact, travel to the baby in his preparation is effective to enhance the logical intelligence and intrapersonal intelligence opportunities. -
think travel should be prepared to baby items, there may be something he would particularly like to bring the parents do not remember. In the preparation process, from living to the diet, one by one into account, to encourage the baby to fully contribute their strength, which makes the logic of the baby be raised in the nurture of intelligence. Must also respect the views of the baby and let him feel their needs, which is to develop his intrapersonal intelligence is very effective. -
VIII. to improve exercise capacity -
39, let the children pick up toys -
at the beginning, you can let the children help you to organize, and gradually let the children learn to pick up. When children make their own time, to encourage children, even if he did not very good, do not blame him. This can train the child's ability, but also let the children know that children should learn to make able to do. -
40, long-distance communication -
parents can take your baby to a more open grassland or square, dad, baby, my mother a distance interval between 3 people, my father plus sign language expression of the sentence clearly see the baby after school Dad looks forward to the other side of the sentence passed to the mother. -
this event can exercise your baby's skills (verbal and physical expression), in a fun game-type activities to enhance your baby's language of intelligence and physical movement intelligence. -
-
-
Subscribe to the reading room -
-
Let your baby smart 40, and I hope each of us are extremely intelligent baby! Woods -
Keep it super useful! 40 smart your baby, and I hope each of us are extremely intelligent baby! -
baby's intelligence is the father and mother have been very concerned about the issue, but this requires a slow process, here to improve the baby's 40 intelligence, and I hope to to improve the intelligence of help your baby. -
-
-
-
-
one. improve the baby logic -
1, test reasoning -
you and your baby ready to eat breakfast, but have not opened the boxes early, parents can allow children to guess: This method can improve children's mathematical logic intelligence. -
2, the stair count -
up and down stairs make the child feel tired and tasteless, but if this time with some interesting ways the parents can not only make your baby smart has improved, and the baby was noisy on the stairs to adults and hold their condition will also be greatly reduced . Parents can lead the children a level one step, layer by layer counting the order of the stairs, and often the process of climbing the stairs, the children's mathematical logic, intelligence will be increased. -
3, considered way, a few numbers -
kids go out, you can use to go home for some time, because time is very adequate way home, the child's mood is mostly relaxed. This time, in the face of all of the road extending in all directions, let the children identify and remember to identify the characteristics of the road and the differences, learn to use reference to know the route, can improve children's observation. -
the way home, you can also teach children the number of house number, to distinguish which side is even, which side is odd, can strengthen children's number concepts, to enhance the mathematical logic of intelligent help. -
4, find program schedules -
watching TV at night, when the children love to see what the program is broadcast it? reported on the TV to find the time to teach children about time. This can develop children's mathematical abilities, and children can unconsciously learn some Chinese characters. -
5, and children with few toys -
before going to bed at night, let the children put their toys packed. To do their own thing their own, but parents can assist, to take this opportunity to help children learn new skills. At first, parents and children can be loud with a few toys, put away the number one finished one. Children will be able to know the count by imitating the order, after the number can let the children and put a toy. This can foster the children's mathematical intelligence. -
6, see product price -
shopping, the parents and children to take a look at the labels of goods, let the children know that every kind of product has its price. And children and then calculate, how much money to buy two pieces, mother of 10 dollars, enough to buy a few ... ... It can have a first child on the concept of money, but also to enhance his mathematical intelligence. -
7, change clothing and mathematics -
warm weather, clothes to be reduced; the winter cold, clothes to be increased accordingly. In this process, you can and the number of children with the number of clothes, summer wear unlined 1; fall underwear + sweater + coat of 3 parts; winter underwear + sweater + jacket + winter clothes 4 pieces. In this process, the baby will be the cold weather and wear thick clothes to keep warm and the weather to cool and heat and wear thin clothes linked to the lives of children from specific experiences to enhance proprioception, awareness of nature. -
clothes to wear off in time for your baby to button his own shirt, from top to bottom lines, or lines from the bottom up, so that the baby's mathematical logic intelligence has been improved. -
-
-
-
-
II. Enhancement and people skills -
8, with people greeting -
teach children to meet acquaintances say hello say hello to them. When teaching children to say hello to a different courtesy title, such as This can improve the child's interpersonal intelligence. -
9, let the children to introduce yourself -
calling to see, let a child simply to introduce myself, do not talk too much, if the child shy, just tell us the name, age on it, which not only foster the children's interpersonal skills, but also enhance the introspection of his intelligence. -
10, similar to the age of the children's families have a guest -
Sometimes parents have to pick about a guest of the object. To have children of people to dinner for children to create with people's time. And playing with the children, but also to cultivate the awareness of children teamwork and cooperation. -
11, let the children come to help -
parents can pretend to have difficulties, let the children come to give you a hand, look like rags, etc. to help rub. Through labor, children can build self-awareness of services and service to others. To help parents give their children a sense of participation requests, and can train his first cooperative, on his good interpersonal communication. -
12, your baby ask for directions -
mothers can often take to the streets with children in the street, the mother should encourage the baby to ask for directions, which can improve his interpersonal intelligence, because the road to ask a stranger, the baby can fully exercise interpersonal skills. -
-
-
-
-
III. enhance spatial intelligence -
13, identify the direction of -
way to teach children to pay attention to recognize Road, to identify the direction, such as the building for identification markings. In particular, to the crossroads and other complex terrain, allows children to observe the up, down, left, right, front and rear in all directions. This can improve the child's spatial intelligence, let the children familiar with the roads. -
14, identify the four cardinal points -
teach children to use to find their way around the landscape, as with a balcony, leaf orientation, signs, etc. to help identify the truck, the training helps the child a sense of direction, but also enhance the child's spatial intelligence. -
15, to give the baby the next instruction -
mother for your baby to be a small help, give him a proper ground instruction, such as . Talk to the baby, mother and more with the following words: inside, above, below, front, back, top, bottom and so on. This can improve the baby's spatial intelligence. -
16, observe the leaves change -
seasons, the most obvious changes in the plant. Life, to observe changes in the leaves throughout the year, your baby learn the concept of the season, while enhancing baby's visual-spatial intelligence. -
summer foliage color is emerald green, to yellow autumn, while in the winter to fall away, leaving only isolated branches, but the spring, the green tree buds and reared their ugly heads . Parents can observe the same tree with the baby, observed 1 year and explain one of the reasons for the baby. -
leaf color change, growth, and withered at the turn of the baby's sight continually to improve the child's spatial intelligence and natural intelligence. -
17, look at the map to find directions -
ready to travel before it is best to buy a map of tourist destinations, of course, you can buy at your destination. Do not underestimate this map, but you raise your baby is an effective tool for spatial intelligence. -
you tell the baby the next target, so that the baby is now on the map to find your location and destination location, and find a way forward in the right direction. The way to the destination, but also to remind parents to see baby signs, destination, and then pulled out a map so that the baby recognized targets are correct. -
This process seems complex, but in raising the baby's spatial intelligence is very effective, while the baby's sense of direction. Space of imagination and execution have also been training and training. -
18, school name, and know the scene along the way -
pointing the way streets, stations, buildings, tell the child their own name, the construction of age. Enhance the child's linguistic intelligence, an increase of the child's knowledge. -
allows children to observe the natural landscape along the way for the introduction to the child, and told him the name of a variety of landscapes, characteristics, function, seasonal changes, improve children's observation -
-
IV. exercise of speech -
19, the child described his favorite animated character -
the role of their favorite children must be very deep impression. Allows children to listen to the mother described as his favorite characters look like, is a small duck, or a large Benxiong, the color of its mouth is and so on. This can foster the children's powers of observation and language skills. -
20, to walk and sing songs -
parents with children walking in the road, there are many opportunities to increase knowledge of the child, the child can guess, such as vivid songs of this will be of interest, is conducive to the child's linguistic intelligence. -
-
-
21, describe the item feature -
mother holding a baby can be items of interest, as he describes the characteristics of one or more items, such as talk about its color (green is the grass-like); or its shape and size (small round ball); to the amount of (two orange); or its texture (soft or hard); or describe its sound (TV sound great, very noisy). Also allows the baby to try to describe the characteristics of the goods. -
baby in the process learned to use language and organization of language, his linguistic intelligence can also be improved. -
22, decide together what to buy -
in the shopping process, you can let your baby's attention to the things you are doing, as is the selection of bread, and baby you can discuss your ideas, and let the baby tell his idea, he must will say why buy the bread, perhaps like good-looking, perhaps smells and so on. Finally, we are satisfied to make a decision, the baby in his views at the same time, greatly enhance the logic of his intelligence and linguistic intelligence. -
-
-
-
-
five. cultivate artistic -
23, singing -
children singing nursery teacher in the way of the songs, can mobilize the child's emotional, because in kindergarten, not every child has the opportunity to sing alone, let him alone to sing if he would be interested in music . -
24, easy listening to upbeat music work -
you are not the whole family once a week cleaning it? allows children with you, while cleaning, while listening to upbeat music. This can improve our emotional labor, the child will think this is a happy time and help to develop the good habit of his labor of love, but also to enhance his musical intelligence. -
VI. training in observation and memory -
25, identify the vegetables -
children identify vegetables, spinach and other vegetables, to identify their similarities and their respective characteristics, can improve children's naturalist intelligence. -
26, observe the color change of dishes -
her mother cook, let the children practice to determine when the cooked vegetables, look for lettuce and ready meal of different color, can train the child's observation. -
27, observing the order of cooking -
mother cooking, carefully observe your baby next to her mother in the cooking process, do a good job, let him step out of a dish, such as making celery shredded pork or shredded pork first, when the first fried celery so, this will train the child's memory, increase knowledge of children's lives. -
28, describes the nutritional value -
meal to accompany the baby, the parents start with the nutritional value of each dish, and then see how many children can remember not only increase the knowledge and the training of the memory. -
29, to draw their favorite characters -
children according to the way television roles like he likes to draw. TV screen is not fixed, so it can not only develop the child's observation, but also training his memory. -
30, say the color of toys -
allows children to first say the color of a toy, and then repeat the same color as what toys that can teach children about color, but also to cultivate children's visual resolution and observation. -
31, the same material to teach children to find toys -
can teach the child to put together toys of different materials, such as some plastic toys, some stuffed toys, and some made of wood toys. This can foster the children's tactile perception and visual resolution, let the children learn classification. -
32, identify colors -
parents can take advantage of opportunities, let the children learn to identify a variety of colors. If the color of the leaves are green, there are yellow, you can also ask the baby, There are many different colors of outdoor plants, you can teach your baby to distinguish the type and color of flowers such as chrysanthemums very many varieties, color is diverse, is very good natural materials. Colors in the identification process, the baby's visual intelligence constantly stimulated, give full play to his visual ability, to develop his ability to identify and observation. Identify the color of his parents were not to be implied as far as possible, let your baby to observe things around, to recognize visual objects are looking for. -
33, to identify the sound -
take your baby to an outdoor environment close to nature, the chances of exposure to natural sounds, parents can tell the baby to listen to a voice note. For example, animal sounds, sound of water streams, wind and thunder, can be used to enhance your baby's hearing. We live in a town where there are many voices, such as: motorcycle boot, car horn, fire engine blew, knocking build tall buildings, etc., can be used to stimulate baby's hearing. With these voices in the memory of your baby, you can let him hear the sound immediately after identification. By stimulating the baby's hearing will make him feel more sensitive and more clever. -
34, touch things guess name -
in outdoor activities, parents can use the outdoor experience of various materials, shapes, sizes and so something different to enhance your baby's tactile skills. Let the baby put his hand behind the palm facing up, the parents picked up all kinds of little things to put on the baby's palm, to let him look at the hands of the things described the feeling of touching up, and then say that he guessed the answer. For example, parents of the baby can touch the pebbles in his hand, said: guessed right. Enhance such intelligence activities in addition to using still life, you can also use the animals. See if the baby can not guess is that he is a touch silkworms, or an ant. -
-
-
-
-
VII. enhance intrapersonal intelligence -
35, deliberately wrong thing -
talk with their children, the deliberately wrong one thing we all know, or a story wrong, for example, the sun is shining today, and you say weather is bad today, to see the child's response, which can improve the child Provincial intelligence, logical intelligence. -
37, to express feelings -
chat with family and suddenly the child is not to judge other people happy family, happy and to what extent; or tell a story, let the children practice the expression of joy, anger, sadness and joy and other emotions, to enhance the child's introspection intelligence. -
38, your baby travel in preparation -
before the trip, parents will be prepared items, do not think this is an adult thing, nothing to do with the baby, in fact, travel to the baby in his preparation is effective to enhance the logical intelligence and intrapersonal intelligence opportunities. -
think travel should be prepared to baby items, there may be something he would particularly like to bring the parents do not remember. In the preparation process, from living to the diet, one by one into account, to encourage the baby to fully contribute their strength, which makes the logic of the baby be raised in the nurture of intelligence. Must also respect the views of the baby and let him feel their needs, which is to develop his intrapersonal intelligence is very effective. -
VIII. to improve exercise capacity -
39, let the children pick up toys -
at the beginning, you can let the children help you to organize, and gradually let the children learn to pick up. When children make their own time, to encourage children, even if he did not very good, do not blame him. This can train the child's ability, but also let the children know that children should learn to make able to do. -
40, long-distance communication -
parents can take your baby to a more open grassland or square, dad, baby, my mother a distance interval between 3 people, my father plus sign language expression of the sentence clearly see the baby after school Dad looks forward to the other side of the sentence passed to the mother. -
this event can exercise your baby's skills (verbal and physical expression), in a fun game-type activities to enhance your baby's language of intelligence and physical movement intelligence. -
-
-
Subscribe to the reading room -
-
Tuesday, May 3, 2011
True failure
Qingyuan, two days before the fight to the left boar ! I know only the hit point to the wild boar , Qingyuan catch a few left to go to eat chicken , then go left Qingyuan County Point two feet unable to know the ! ! ! Depressed!
Subscribe to:
Posts (Atom)