Free Essay

Tea in My Cup

In:

Submitted By joepass
Words 785
Pages 4
Accounting Format – Cells above each other hundreds/tens/ones place
Custom Value: positive value; negative values; zero; text [green]?”$”;[red](?);”ZERO!”;”Why text?” - Use @ for numbers typed AKA repeat back

Ctrl + : to get current time
Ctrl + ; to get current date
Custom format d = 7 or 17 dd = 07 or 17 ddd = sex dddd = sex-feira

File > Options > Advanced > Edit Custom Lists > Import To program an autofill list feature where other names are filled in after

Fill > series > weekdays > step: 5 Gets you Jan 1, Jan 6, Jan 11

Format number for dates gives you # of days since 1-1-1900

Conditional Formatting

Conditional Formatting > Top/Bottom > Bottom 10% Green light to 20% best; Red 20% least; Yellow to middle Conditional Formatting > Icon Sets > Lights Conditional Formatting > Manage rules Green > 80 percent Yellow < 80 percent but > 20 percent Red =OR(Month($A3)=11;Month($A3)=12) - Where A3 is the title cell like “Birth Date”

Make all lines with Dog the color blue Conditional Formatting > New Rule > Formula to determine which cells to format =$B4 = “Dog” Formal > Fill > Blue

Color in red dogs born on Wednesday =And($B4 = “Dog”; weekday($F4)=3)

Color in red dogs born on Wednesday or Thursday =And($B4 = “Dog”;Or(weekday($F4)=3; Weekday($F4) = 4))

= Iseven(Row(1))

Themes

Cell style > Right – click > Modify

Ribbons + Developer Record Macro + use relative reference (do something) stop recording

Developer > Insert Combo Box > Right click > Format Input Range Cell link

Editing and Proofing

File > Options > Language > Add additional language
Change screen tips to help with foreigners

Symbols Insert > Symbols > Subsets Date in cell > Home > Date > More format options Date > Home > Date > More form > Custom > [$-40>]dddd

Consolidate

Data > Consolidate > Use labels in top, left > Add Select reference you want to use

NPV Click Fx > Search NPV Rate = 5% Value = E46:E81 (First Column) Drag to the right

IRR Click Fx > Search IRR Enter > Result > Change format to % > Drag to the right

Project w/ IRR over 10% summing NPV Click Fx > Search Sumif Range: E84:AA84 (IRR row) Criteria: “>10%” Sum Range: E83:AA83 (NPV row) > OK

Add Solver Add-In File > Options > Add-ins > Manage Excel Add-in > Go > Solver Add-in

Issue Bonds to raise debt (2015) Bond Issue date: 1st Jan 2015 Maturity: 31st Dec 2015 Coupon: 5% Redemption Value: 300

Solver (Yield) Set objective: Raised cash Value of: 15750 (cash needed to invest) By changing variable cells: Yield % cell Solve

Ctrl + adds a column in between rows =Concatenate (Last name, “ “, A6) Gets last name + first name together

Rule hires manager average score > 10, aspect 10 > 15 =If(And(Average(First row) > 10; Cell w/ value) > 10 > 15) If true; Hire | If not, Don’t Hire
Vlookup
LV – Value table (in table, ID # for grade) Table array – All table (other table w/ numbers) Col Index + 1 is Which column you find it in Range lookup is 0 if exact match, 1 check closest value

*Do for FIRST value of table then pull formula down*

NetworkdaysINTL How many days between ____ and ____ NetworkdaysINTL(A4;A5;4) 4 if Tues, wed, holidays

SLN To compute depreciation of car Initial: $125,000 Life: 4 years Salvage: 50,000 =SLN(125,000,50000,4)

Merge cell styles Between two templates Cell styles > Merge cell styles

Catch data from Access files/Web Data > Get external Data > Import If anything changes in original, click refresh Also do = (click cell in other excel)

Unlock cells/Lock cells Review > (select range of cells) > Protection Formal cells > protection > Locked/Hidden Allow users to edit range: Refers to cells (select) + ______ Track changes
File > Inspect workbook > Check for issues > Inspect Document Unprotect and unshared work before inspecting errors

Merging workbooks File > Options > Quick access toolbar > Compare and merge > add Click green button top left

Charts Insert > Chart Design > Select Data Right click bar, add trend line Right click > format data series (secondary) Right click > save as template Design > move chart

Sorting Home > Sort and filter > Custom sort Division Values A-Z Team Values Small-Large Insert pivot table > Choose fiels right Put unit price in value box (average price) Pivot tool options > Insert slicer

Creating relationships Select all > Powerpoint > Create link table Table > Relationships > Create relationships

Similar Documents

Free Essay

The Art of Drinking Tea by Nin Andrews

...The Art of Drinking Tea By Nin Andrews When I first read this poem, I just thought it was about a lonely man’s desire to sleep with the black-haired woman who is drinking tea. He pictures her undress him and enjoying the one night stand that lasts 49 days and nights. Although the wordings of the poem sounded complicated, I believed that the poem just had a fun and simple read and that was my main reason why I selected this poem. However, when I started to think about why Andrews used drinking tea to describe a man’s sexual desires, the depth of the poem changed entirely. In the middle of the poem, the man tries to follow the instructions on the drinking of tea but fails to because he constantly imagines making love with a woman. This was my favorite part of the poem. Although he says that he failed to follow the instructions, I think he was doing it perfectly. When you take your first sip from the first cup of tea, the liquid moistens your lips and surrounds your mouth with warmth and comfort, just like a kiss that the man was picturing. “She lifts him to her lips like a china cup and sips so slowly.” So he knows what the art of drinking tea is but decides to become to teacup so that the lady can kiss him. Nin Andrews also used tea to show a sense of addiction. In tea, there is a bit of caffeine, which allows the drinkers to crave more of it. In the poem, the man seems to be addicted to his imagination that he barely remembers his own name. Although there weren’t enough...

Words: 587 - Pages: 3

Premium Essay

Food Labels Week One Assignment

...Glenn Johnson My current eating habits are pretty simple. I have to always eat breakfast; I either eat a normal bowl size of raisin brain with about a cup of skim milk or stop by Burger King for two breakfast burritos with either tea or coffee. For lunch sometimes I either just snack around the office with popcorn or pretzels or whatever else my craving is for that day. However it’s usually something light, rather having something really heavy. Then for dinner I usually cook every night of the week which consists of one meat, vegetable, and a starch. When fixing my plate I usually get ½ a cup of each individual food. However even though I do place a little more than what I am supposed to eat on my plate, there are a lot of times where I don’t finish eating. I also have found myself not trying to eat any more food after I begin to feel full. When it came to the Super Tracker on what your body needs and then what they show what I had reordered, mine has been under on just about every single food group and nutrients. The refined grains are the only thing that was actually over that I had ate in those three days of my recording. As far as how many servings in each food group I ate in was also under as well. Grains in the three days I intake 6 ½ ounces, vegetables 2 ¼ cups, fruits I intake ½ cups, dairy was 1 ¼ cups, protein foods was 5 ounces, and oils I intake was 2 teaspoons. This assignment has showed me that a lot of my problems with...

Words: 1330 - Pages: 6

Premium Essay

Business Research Report

...7-Nov-15, Lisa Allen Yorkville University Business Research Report #2 As part of my Business Research Report I have chosen the following companies: The Second Cup Ltd. And DAVIDs Tea Inc. Throughout the course, there has been so much discussion regarding coffee that I thought I would delve into the coffee and tea world a little deeper. Davids Tea first opened in 2008, in Toronto by David Segal and Herschel Segal. David was a tea loving entrepreneur and his cousin Herschel a Canadian Retail Pioneer and founder of Le Chateau. The two are passionate about tea and opened a tea company because they felt that tea brings people together. It is healthy and delicious and is the second most popular drink second only to water. Davids tea carries over 150 types of teas, including exclusive blends, limited edition seasonal collections, and exotic teas from around the globe. David’s teas have unique names such as the sweet blends named Read My Lips or Red Velvet Cake that tastes like red velvet cake. They carry premium green teas such as Sencha Ashikubo or Dragonwell. They also sell tea accessories to assist you in making the best cup of tea possible (The Davids Tea Experience, 2015). The company now has 136 tea shop locations across Canada and 25 in the United States, offering the public 5.1 million shares in June of 2015 for $19 U.S. per share (Davids Tea debuts, 2015). Second Cup started in a shopping mall that sold six blends of specialty coffee beans in 1970. During the...

Words: 1946 - Pages: 8

Free Essay

Nutrition

... Day 2 Breakfast: 2 eggs, 2 sausages, and tea with 2 teaspoons of sugar. Snack: 1 apple and 1 water bottle. Lunch: Fried shrimp, salad, and bottle of water. Dinner: French fries, burger, and pickles. 2 glasses of apple juice. Breakfast: Special K cereal with low fat blueberry yogurt, and tea with 2 spoons of sugar. Lunch: Turkey with tomatoes on 2 slices of whole wheat bread and 1 cup of peach bubble tea. Snack: Plum, apple, grapes and 1 glass of water. Dinner: Brown rice with chicken, mushrooms, 2 pieces of white bread, and 2 glasses of water. I would pick day two to analyze for nutritional content. Step 2: On day 2 for breakfast I ate 1 cup Special K cereal with 1 cup of low fat blueberry yogurt. My liquid intake for breakfast was 1 large cup of gray tea with 2 teaspoons of sugar. For lunch I had a cream cheese with tomatoes on a whole wheat bagel with 1 large cup of peach bubble tea. As a snack I had a plum, apple, grapes and 1 glass of water. For dinner, I had 1 cup of brown rice with 2 chicken breasts and 2 glasses of water. I choose a 2000 calorie level of food plan. According to the chart, for grains the daily recommendation is 6 ounces and the minimum is 3 ounces of grains a day. For breakfast I had 1 cup of cereal which is equivalent to 1 ounce of grains. I had 1 cup of of low fat blueberry yogurt which is equivalent to 8 fluid ounce carton, and the daily recommendation is to have 3 cups of dairy. For launch I had 2 slices of whole wheat...

Words: 626 - Pages: 3

Free Essay

Hypothesis

... Hypothesis – the larger the surface area the faster the rate of reaction Why did you choose your hypothesis? The reason I have chosen my hypothesis is because large surface area of the tea bag will contain more molecules which means the rate of reaction will happen faster. For example the pyramid due to it 3D shape provides more sides for diffusion to take place and more area in the middle for the tea molecules to move around which will make them escape quicker so the reaction will happen faster. 2 web sites I have done my research, a) http://www.mylearning.org/learning/investigate/Tea%20Bag%20Trials.pdf b) http://www.science-sparks.com/2012/01/02/get-the-kids-to-make-your-cuppa-investigating-teabags/ I prefer website science-sparks because I found it easier to follow and also it was more useful was because it’s a scientific website therefore it was more accurate than mylearing. It also appeared to make more sense to me. Therefore website science-sparks was more detailed and had a diagram whereas website mylearning didn’t have one so it was hard to understand how to do the experiment and how to set it all up. Equipment: Circle, square and pyramid tea bags 4 pieces of white paper A black pen or a marker Kettle with hot water (70°c) A stopwatch/timer 3 Clear glass cups Thermometer Method: On the piece of 4 white paper that are going to be used as part of the experiment draw a table on one of them where...

Words: 534 - Pages: 3

Premium Essay

Vx-577 Opeartions

...Smoothie Recipes for Weight Loss - 30 Delicious Detox, Cleanse and Green Smoothie Diet Book Troy Adashun Copyright © 2013 Troy Adashun 2 Wait! Before you continue… are you on a diet or want to lose a few pounds? If your answered YES you are not alone. Almost everyone wants to lose 10, 20 or 50 pounds. Unfortunately most of us have no idea how to do it. Yes dieting can work, but starving yourself just leads to frustration and failure. If you've been searching for weight loss tips that really work - you've found the right place. Right now you can get full FREE access to 5 WEIGHT LOSS REPORTS packed full of weight loss secrets, myths and hacks so you can easily and quickly create the body of your dreams. Click here for instant access. www.FormulatedFitness.com Download 5 of the Best Weight Loss Reports to Help You Burn Fat and Get in Shape Fast 100% FREE 13 weight loss myths that will blow your mind. 45 smart, super-effective ways to burn of calories. How to lose 14 pounds in 14 days and keep it off for good! 13 secrets, tricks and cheats that trigger fast fat loss almost instantly. The ultimate guide to losing fat fast without losing your mind. Click Here for Instant Access 3 Disclaimer/Legal Notices All rights reserved. Without limiting the rights under the copyright reserved above, no part of this publication may be reproduced, stored in or introduced into a retrieval system, or transmitted, in any form, or by any means (electronic, mechanical, photocopying, recording...

Words: 4965 - Pages: 20

Free Essay

Ais Paper

...Start My Own Business What new business would you start and why? What are the steps you would take? What type of accounting system would you use and why is it important? What are the pros and cons of owning your own business? Americans enjoy various entertainment places, such as beer bars, music bars, sports bars, gay bars, lesbian bars, etc. Coming from another country, I had hard time finding a quiet place where I didn’t have to raise my voice to conduct informal communications with my friends or with somebody important while enjoying a cup of fresh green leaf tea. I believe there are tea bars in New York or California where Asian people reside, and I heard that there is one in Miami, but there is nothing in Ft Lauderdale, where I live. Luckily, we have Starbuck Cafe, which is close to the environment I am looking for; however, it is still a fast food industry, where people come to grab a cup of coffee and go. Others, like me, try hard to find a quiet corner in all the noise. I miss the times that I spent with my friends in the tea bars in my country. So, I dream of having a tea bar here, where it provides a peaceful place for people to enjoy a calm chat while having a cup of quality tea, and a little relaxing time for themselves. Americans could realize the potential of slowing down and smelling the roses. The economic slowdown might be that opportunity for people to slow down and enjoy a cup of hot tea that they have to drink carefully and slowly fully appreciate...

Words: 1265 - Pages: 6

Free Essay

Why Should You Drink Camomile Tea?

...Camomile Tea! Dear fellow classmates and Mrs Montgomery, today I would like to introduce you to Camomile tea. I understand that not very many people like tea or maybe all of you do, I don't know. However one thing I do know is that I am in love with Camomile tea! Now, I had never heard of such creation before and when Mum brought it home I was weary to try it as the only hot drink I liked was hot chocolate! Well, I am now in love with this tea. I would drink it over hot chocolate any day! I am sure many of you think I am crazy for saying this, but you shouldn't pass judgment until you've tried it. Camomile tea is a tea sent from Heaven itself and is an infusion of dried flowers of sweet Camomile with no caffeine or artificial preservatives. Many, if not all, of us having trouble sleeping at night. Am I right or am I right?! Well studies have actually shown that if you make yourself a cup of Camomile tea 30 to 40 minutes before you go to sleep, it will help you dose off! Now for the past week I have been up and down looking after my ill sister and I haven't been able to sleep that much and coincidently I didn't drink my tea, however, last night I drank my tea and oh I slept like a baby all night long! Studies have also shown that Camomile tea can help with insomnia and other sleeping disorders; anxiety and panic attacks; muscle twitches; wounds, burns, and scrapes; skin conditions such as, eczema and chickenpox,; and lastly stomach problems such as menstrual cramps, stomach...

Words: 434 - Pages: 2

Premium Essay

Three Cups Of Tea Rhetorical Analysis

...In 2007, Three Cups of Tea had signaled much confusion. One individual, Greg Mortenson, helped publish Three Cups of Tea and his fabrication could be seen throughout the book. A few individuals had seen the lies and took action. CBS and Jon Krakauer reported about Greg Mortenson’s lies in 60 Minutes. After that, NBC had interviewed Mortenson, confirming that he lied in his book. Greg Mortenson fabricated his story, he also built schools for children in the Middle East. Mortenson should be punished for his lies in Three Cups of Tea. When Three Cups of Tea was published, much controversy, about Greg’s schools, was raised. Mortenson, according to the argument, lied about the number of schools he built. In 2011, Jon Krakauer had written Three Cups of Deceit, claiming that much of Mortenson’s experiences regarding his adventures in making his schools are highly exaggerated. Krakauer uses Mortenson’s acquaintances to support his claims, against Mortenson (Krakauer). CBS, also, launched an investigation on Mortenson. CBS had aired in 60 Minutes that he did lie. In 60 Minutes, Krakauer claimed that Mortenson did create schools, but Three Cups of Tea is over exaggerated....

Words: 491 - Pages: 2

Free Essay

Lab Investigation 3

...Heterotrophy | Image 1 | Amoeba | Eukaryote | Stagnant water | Heterotrophy | Image 12 | Plant cells with nucleus (chloroplasts absent) | Eukaryote | Plants | Autotrophy | List two similarities between plant cells and animal cells 1. Both plant and animal cells have a nucleus. 2. Both plant and animal cells have ribosomes, mitochondria, and a Golgi apparatus. List two differences between plant and animal cells 1. Animal cells do not have a cell wall or chloroplasts, but plant cells do. 2. Plant cells have one large central vacuole while animal cells have one or more small vacuoles. Part 2 – Diffusion and Osmosis Diffusion [4 pts] Boiling water (Right Side) | Cold water (Left Side) | * Absorbed tea bag rapidly | * Slowing...

Words: 1322 - Pages: 6

Free Essay

The Book of Tea

...THE BOOK OF TEA by Kakuzo Okakura Originally published  Dreamsmyth edition First printing  Typography, book design and binding by William Adams Printed in the U.S.A.  The Book of Tea . . . . . . . The Cup of Humanity The Schools of Tea Taoism and Zennism The Tea-Room Art Appreciation Flowers Tea-Masters        Colophon       The Book of Tea . The Cup of Humanity T     and grew into a beverage. In China, in the eighth century, it entered the realm of poetry as one of the polite amusements. The fifteenth century saw Japan ennoble it into a religion of æstheticism—Teaism. Teaism is a cult founded on the adoration of the beautiful among the sordid facts of everyday existence. It inculcates purity and harmony, the mystery of mutual charity, the romanticism of the social order. It is essentially a worship of the Imperfect, as it is a tender attempt to accomplish something possible in this impossible thing we know as life. The Philosophy of Tea is not mere æstheticism in the ordinary acceptance of the term, for it expresses conjointly with ethics and religion our whole point of view about man and nature. It is hygiene, for it enforces cleanliness; it is economics, for it shows comfort in simplicity rather than in the complex and costly; it is moral geometry, inasmuch as it defines our sense of proportion to the universe....

Words: 3784 - Pages: 16

Premium Essay

Drink Recipes

...Collected Hello, I'm Dr. Susan Albers. I'm a clinical psychologist who specializes in eating issues and has worked with clients just like you for over a decade. This short e-book is one of two companion pieces to my new book, 50 MORE Ways to Soothe Yourself Without Food. In this guide I'm going to show you how to use mindfulness to create and enjoy drink recipes that keep you calm, cool, and collected. Some of these drinks are simply soothing, while others both comfort and fill you. With these drinks, there's no need to concern yourself with calories or feel guilty after enjoying them. What you'll find in this book: Miss your daily trips to the coffee shop for a flavored latte? Make a healthier, tastier...

Words: 1630 - Pages: 7

Free Essay

Three Cups of Tea Paper

...Balti proverb says, "The first time you share tea with a Balti, you are a stranger. The second time you take tea, you are an honored guest. The third time you share a cup of tea, you become family,” this helped originate the title for this novel and is a main message that I believe is presented throughout the book by either direct or indirect means. When I first began reading “Three Cups of Tea” by Greg Mortenson and David Oliver Relin, I had my own personal ideas about the people who practiced Islam and lived in areas of the Middle East similar to the Balti. I never believed that any story would change the perceptions that had become engraved in my mind since a young age and influenced by the harsh activities such as the attacks of 9/11. “Three Cups of Tea” is a story based on Mortenson's experiences in the area near K2 and especially the village of Korphe. The story begins with a failed attempt of reaching the summit of the K2 in order to put his sister’s necklace there to honor her death. However,the journey ends up becoming a bigger accomplishment. This story is the telling of one man’s dedication to build schools and help a group of people who struggle with poverty to become better educated, especially girls who are seen to not be allowed to privileges of education. Throughout the novel, there are different times in which the Balti people show fierce yet hospitable actions and within this essay I will fully discuss my reactions to these numerous examples. Also...

Words: 1760 - Pages: 8

Premium Essay

An Excerpt From Napoleon's Epilogue To Treasure Island

...was already nervous enough, but now I might not even be able to get in there and do my duty? "Surely you are mistaken," I begin, trying not to let my fake french accent waver, "The Emperor asked me to come serve tea for him and his officers at noon. Am I mistaken? I'm sure that the clock said noon..." I added the bit about...

Words: 2202 - Pages: 9

Premium Essay

Marketing Plan: a Perfect Cup of Coffee

...Marketing Plan: A Perfect Cup of Coffee Abstract The purpose of this paper is to show a complete marketing plan developed for A Perfect Cup of Coffee (PCC). The idea for A Perfect Cup of Coffee grew one winter morning in 2011 when my wife and I were discussing our dissatisfaction with the delivery times and prices for our online coffee services for our one cup coffee makers. We enjoyed the taste of the Tassimo coffee pods, but were dissatisfied with the delivery times, customer service and prices. We thought the customer service components of Keurig Company were top notch, but Keurig lacked the quality in their coffee pods as well as efficiency in their coffee systems. As owners of one cup coffee makers for both companies for more than a year, we thought we could create a company that could have tremendous online customer service as well as have the depth and quality of coffee to surpass the industry leaders. 1.0 State your marketing objectives. • Increase brand awareness among our target audience by 30 percent this year through an advertising campaign in magazines and online. • Increase new customers from month to month. • Maintain a high standard of coffee and customer service. • After six months, continue to increase new customers and sales while maintaining or decreasing marketing expenses. • Maintain a positive and steady growth each quarter. • Increase our market share by 10% this year. • Enter into the overseas market, Finland specifically, 12 months...

Words: 1195 - Pages: 5