It simply amazes me how the same month can feel like an eternity and an instant at the same time. I cannot believe I am already sitting at home (dreading the onslaught of school in roughly 1 week) after spending 31 days living, breathing, eating, and sleeping everything eventing in West Grove, PA. (The breathing part is unfortunate at night when the smell of local mushroom farms is overpowering...)
I found it very easy to lose track of the date during my stay as a working student. Every new day at TPF felt like my first day, yet at the same time I felt as if I had also been there forever. I would say it takes the full first two weeks to settle in and get the hang of things. Also - the weeks are a bit 'backwards' in the sense that they are not your typical week having Monday through Friday with a laid back weekend. Rather, Friday takes Monday's place as the long, drawn out first day of the week with show preparations taking place (clipping, bathing, braiding, packing etc.) and Monday steps in for Friday without the stress of competition, horses having the day off, etc. TGIM, anyone?
While mucking stalls, grooming horses, and dragging hoses to water troughs are just some of the daily chores... mane pulling, clipping, and packing the trailer fall under the category of 'frequent but not daily' chores. Only one chore stands out in my mind that merely had to be completed once in my time at TPF... bagging and storing all the horse blankets that returned from being washed! A fairly quiet afternoon while most of the action was taking place at a show, someone arrived with an entire SUV filled with clean bundles of winter wear. The blankets are separated by owner, secured in oversize trash bags, and carried up to the loft for storage. Nothing too difficult - I was just impressed by the sheer number of horse blankets stacked up along the aisle-way!
Another memory that quickly comes to mind is the time when someone arrived at the barn to conduct the 2010 US census. You are so immersed in the world that is TPF, you forget about the 'outsiders' who have no clue. (What is the owner's name? Phillip who? How do you spell that?) It was a bit of a tricky situation as there are many people who live in apartments scattered around the property (attached to the indoor, above the barns, etc..)but there is no proper house, as it is after all a business. It boggled her mind when she learned that people from all over the world, not just the country, come to this farm for the experience. Needless to say, True Prospect Farm can cross 'outsmarting the US census' off its to-do list.
On another note, I am thrilled with the progress my horse and I made in our brief summer with Boyd. I could not have hoped for a more productive 31 days. A year ago, when I mailed in an entry fee for a clinic with Boyd Martin, I would never have imagined myself as a working student this summer. I suppose two lessons and a cross country school can be life changing after all! It was very hard for me to leave the farm after spending my month there, and I am already working to arrange a working student position somewhere for 2011. Now it is up to me to keep up the hard work with my riding throughout my school year, and keep building on the progress I made this summer. I am looking forward to how this work will translate into scores at my next show, and I can not thank everyone involved enough for making my fabulous summer happen!!
twenty-first, into the base words from English into ordinal base into ordinal word is a more complicated issue. Because it does not have a very fixed pattern: most of the ordinal numbers are in use into the st Moreover, Therefore, it seems very complicated to implement. In fact, as long as we clarify ideas, identify the function, simply write a formula that can be easily converted. Do not believe, see: , 2,3,}, CHOOSE (RIGHT (A2), is
XXII, filled with a special symbol digit
and financial dealings of the people know, the book fills in when there is a convention of the , or in the amount of data preceded by digits) 16-LEN (A2))) (A3))) & A3 ) & A4 & REPT (the requirements.
xxiii, create text in addition to re-enter the histogram
outside, principle is very simple, it is smart to use a special symbol repetition, according to a specified cell results show the comparative effectiveness of different lengths.
example, we first make an annual balance sheet, and then font , and drag the fill handle to the G14. we see that a function does not use Excel chart text histogram has been unfolding before our eyes, convenient and intuitive, simple and clear.
XXIV calculate the total cell number of words Sometimes, we may have a number of characters in a cell of interest, the cells need to calculate the total number of words To solve this problem, in addition to using the function to remove spaces, such as cell A1, enter now are LEN (TRIM (A1))-LEN (SUBSTITUTE (TRIM (A1 ),using The number of characters.
XXV, the euro conversion
This is a new tool in Excel 2002 if you choose to install the Excel 2002 is the default, then it may not be in the find it, but we can first select > After we again open the currency conversion The show is more professional, we can also click on the Excel toolbar, the
XVII control specific cell type text length
Can you imagine when you enter the four digits of the cell was filled with a digit, or enter text in the cell Enter the numbers you have the time, Excel will automatically determine, instant analysis and pop-up warning that nice ah! to achieve this function, Excel, is also not difficult.
example, we register the cursor to a Therefore, we can click the In the Then in the We then came to the and
Obviously, when if someone in the cell when the input is not a four-digit number, Excel will display a warning dialog box pops up telling you what went wrong, and until you enter the correct can continue typing. Magic, right? In fact, in the Excel , why not self-assertion, his design of a testing standard to make your show unique luster Excel does.
eighth, into a group of more than fill the form of fixed cells
We know that each time you open Excel, the software is always turned on by default multiple sheets. In addition to this we can see that Excel has a strong single form of processing power, more suitable for multiple interrelated tables coordination. To coordinate the association, of course, first you need to synchronize the input. Therefore, in many cases, will need more than one table simultaneously in the same cell type the same content.
So how tables into a group of editors? First we click on the first sheet tab name not associated with a table, hold down the Ctrl key to select). At this point, we see the name of the Excel title bar to a The need to enter more than one table cell content just to write, we found that the
However, only the synchronization input is not enough. For example, we need to place more than one table in the same format for the data to change the uniform how to do it? First, we have to change the data format of the first table, and then click The sub-menu, select At this time, Excel will pop up
ninth, change case of text
In Excel, the form processing and data computing support to provide the most powerful formula is not, nor is the database, but the function. Do not think that is a function in Excel for numbers, in fact, as long as the content is written into the table, Excel has a special function to edit it. For example, change the text of the case.
In Excel 2002, provide at least three functions to convert the text of the case. They are: into For example, in a form of cell A1, enter a lowercase Similarly, if we enter in cell A3
XX extract specific character string
addition to the direct importation from the existing contents of the cell extract specific character input, is absolutely a way to save time and save trouble, especially for some styles especially similar information, such as employee lists, place of origin and other information.
If we want to quickly extract the cells from A4 title, it is best to use characters' input to this location. Of course, if you want to extract the name, then, will have to use the In another case, we do not start from the left and right ends, but directly extracted from the data center a few characters. For example, we want to extract from the A5 cell Means: in the A5 cell extract after the first four characters of the two characters, that is, 4 and 5 word.
seven, the data sheet completely hidden
part of the cell contents do not want visitors to access, it had to be hidden.
1. selected to hide the contents of the cell (area), the implementation of the
2. and then switch to the
3. execute
After this set after the contents of the cell is no longer displayed, is to use Excel's features can not be allowed to borrow transparent.
Tip:
eight, so that in the English input method appeared
intelligent editing table, some cells to enter the English, and some cells to enter the Chinese, it is inconvenient to repeatedly switch the input method, why not set and let the input method intelligently adjust it?
selected range of cells need to enter the Chinese, the implementation of tab, press the
need to enter the Chinese after the election in any range of cells in a cell, the Chinese input method (IME list first a Chinese input method) automatically opens when you select the other cells, Chinese input method automatically off.
nine, so that
1. execute
2. In the then click
3. If you need to enter the text later, just enter
ten, custom functions in Excel
Excel function, although abundant, but it does not meet all our needs. We can customize a function to perform certain operations. Here, we have from the definition of a trapezoid area calculation function:
1. Execute
2. In the window, execute the
3. in the right defined function to complete.
built-in functions can later be the same as using a custom function.
Tip: Use the above method defined in the corresponding function is usually only used in the workbook.
XI header following pictures
lining add to the background of the sheet, is lining the entire worksheet below, can only head in the table below lining it?
1. implementation Worksheet → Background
2. While holding down the Ctrl key while using the mouse in the picture without lining cells (area) in drag, and select those cells (area).
3. Click After this set after leaving the cell lining on the picture below, and the selected cell (area) there is no lining pictures below (in fact, is the picture to be
Tip? lining in the cell below the picture is not supported for printing.
twelve, with a hyphen get it (here assumed that the B, C, D columns into one column in).
1. in the D column, insert two empty columns (E, F column), then enter the formula in cell D1: = B1 & C1 & D1.
2. D1 cells again selected, use the
3. Select column E, the implementation of , press the
4. to B, C, D, E column deleted, completion of the merger work.
Tip: Complete Steps 1 and 2 operation, the combined effect has been achieved, but at this time if you delete B, C, D column, the formula error. Therefore, to carry out step 3, the formula into the same
student achievement of
friends often ask, For this consideration, I am here gives a simple way with the function implementation.
student achievement is assumed here to save the Sheet1 worksheet range of cells A1 to G64, of which the first act title, the name of the first two acts of discipline.
1. Switch to Sheet2 worksheet, select cell A1, enter the formula: = IF (MOD (ROW (), 3) = 0, , sheet1! Aū, INDEX (sheet1! $ A: $ G, INT (((ROW () +4) / 3) +1), COLUMN ())))。
2. Again select cell A1 , use the > So far, the results of the basic shape, the following simple modification look.
3. adjust the row height and column width, the same selected range of cells A1 to G2 (the first a student performance of the region), according to The following operation).
4. also selected range of cells A1 to G3, click on Add to all of the results of the border.
press the What more appropriate function. Excel Please enter requirements (such as the associated help file, you can quickly determine the required function.
fifth, while viewing a different worksheet in multiple cells of data
Sometimes we edit a worksheet (Sheet1), the need View other worksheet (Sheet2, Sheet3 ... ...) the contents of a cell, you can use Excel's .
later, no matter what the worksheet, simply open the > In previous versions of Excel 2002, add a border to the operation of a range of cells is too much trouble, Excel 2002 which features a new expansion.
Click pull button, then the pop-up drop-down list, select drop-down button, select a border style, and then in the range of cells you need to add border drag, you can quickly draw the corresponding range of cells on the border.
Tip: ① If you draw the wrong frame, does not matter, Select the tool bar on the Color
Excel spreadsheet of 35 strokes will learn Cheats (reproduced Come learn accounting, keep for future use)
Perhaps you had already done in Excel hundreds of financial statements, perhaps you have been using Excel functions to achieve thousands of complex calculations, but perhaps you think that Excel is the case, even nothing new. However, we repeated countless times daily in handy to use only one per cent of Excel all skills. From Excel, the topic of some little-known tips to start a trip on the Excel Different customs.
one, so that different types of data using different colors
in payroll, if you want more than equal to the total wages of 2,000 yuan to greater than or equal to the total wages of 1,500 yuan,
1. Open the Click the second box on the right of the drop-down button, select the Click
2. press the
3. set up is complete, press the
it look payroll, payroll data is not according to your request to display a different color.
Second, a classification drop-down list filled with items
we often want to enter the name of the enterprise to the table in order to maintain the name of consistency, the use of
1. on Sheet2 in the name of the business by category (such as
2. Select A column (
follow the above operation, the B, C ... ... column named If column C), the implementation of In the Enterprise
then need to enter the corporate name of the selected column (for example, column D), then open the C1), OK to exit.
4. Select any cell in column C (eg, C4), click the right drop-down button, select the appropriate Then select the corresponding cell in column D cell (eg D4), click the drop-down button to the appropriate category business name from the list, select the desired company name fill the cell.
Tip: When printing a report in the future, if you do not need to print
Third, the establishment of a
1. the space in the toolbar right-click, choose In the
click
2. and then in the (common document), and follow the above named action it (such as
repeat the above operation, add a few more than the name of the document list.
3. select the distribution Hyperlink By pressing the
repeat the above operation, the menu item and its corresponding workbook hyperlink documents together.
4. After the need to open the
Tip: Although we will
Fourth, the production of
1. execute Select the .
follow the above operation, one by one good other special symbols to record the input
2. open the A work area in the toolbar.
switch to the How many buttons).
3. Select one of the
4. Right-click a button named after, in the subsequent pop-up shortcut menu, select out.
Repeat this step, the macro button and the corresponding link.
5. close the
five, use the
1. Open the worksheet to print, use the mouse to the need to print the row (or column) marked drag, select them and then right-click in the shortcut menu that appears, select will need to print the row (or column) hidden.
2. implement the
3. the hidden rows (or columns) are displayed, and repeat the above operation,
4. After the need to print a form, open the , layout look, click the toolbar's
six, so that data on demand
If you want to sort according to department where employees sort the names both of these departments are not in alphabetical order of the information, nor Alphabetical, how do? can be self- define the sort sequence.
1. implementation the team, a workshop, two workshops, three workshops,
2. Select the one of the drop-down button, select the just-defined sequence, according to two