Can't quite figure out how to run a macro when using Microsoft Excel 2011 on your Mac? This video will show you how it's done. Whether you're new to Microsoft's popular digital spreadsheet application, new to Excel 2011 or even an expert merely looking to brush up on the fundamentals, you're sure to be well served by this quality video tutorial from the folks at Lynda. For all of the details, and to get started using macros in your own MS Excel '11 projects, watch the video.
Need a hand figuring out how to adjust AutoCorrect and AutoReplace settings in Excel 2011? This video will show you how it's done. Whether you're new to Microsoft's popular digital spreadsheet application, new to Excel 2011 or even an expert merely looking to brush up on the fundamentals, you're sure to be well served by this quality video tutorial from the folks at Lynda. For all of the details, and to get started using AutoCorrect and AutoReplace in your own MS Excel '11 projects, watch the...
Looking for a quick primer on how to use PivotTable (or Pivot Table) reporting in Excel 2011? This video will show you how it's done. Whether you're new to Microsoft's popular digital spreadsheet application, new to Excel 2011 or even an expert merely looking to brush up on the fundamentals, you're sure to be well served by this quality video tutorial from the folks at Lynda. For all of the details, and to get started employing PT reports in your own MS Excel '11 projects, watch the video.
Want to know how to align and layer objects in Excel 2011? This video will show you how it's done. Whether you're new to Microsoft's popular digital spreadsheet application, new to Excel 2011 or even an expert merely looking to brush up on the fundamentals, you're sure to be well served by this quality video tutorial from the folks at Lynda. For all of the details, and to get started using object and layer alignment in your own MS Excel '11 projects, watch the video.
Need to know how to create and use hyperlinks in Excel 2011? This video will show you how it's done. Whether you're new to Microsoft's popular digital spreadsheet application, new to Excel 2011 or even an expert merely looking to brush up on the fundamentals, you're sure to be well served by this quality video tutorial from the folks at Lynda. For all of the details, and to get started splitting and freezing rows and columns in your own MS Excel '11 projects, watch the video.
Want to generate a line chart in Excel 2011? This video will show you how it's done. Whether you're new to Microsoft's popular digital spreadsheet application, new to Excel 2011 or even an expert merely looking to brush up on the fundamentals, you're sure to be well served by this quality video tutorial from the folks at Lynda. For all of the details, and to get started creating and using line charts to visualize data in your own MS Excel '11 projects, watch the video.
Need some help figuring out how to handle Office themes from within Excel 2011? This video will show you how it's done. Whether you're new to Microsoft's popular digital spreadsheet application, new to Excel 2011 or even an expert merely looking to brush up on the fundamentals, you're sure to be well served by this quality video tutorial from the folks at Lynda. For all of the details, and to get started better managing Office theme settings yourself, watch the video.
Want to create a formula to count cells in Excel 2011? This video will show you how it's done. Whether you're new to Microsoft's popular digital spreadsheet application, new to Excel 2011 or even an expert merely looking to brush up on the fundamentals, you're sure to be well served by this quality video tutorial from the folks at Lynda. For all of the details, and to get started counting cells by formula in your own MS Excel '11 projects, watch the video.
Want to create an AutoSum formula in Excel 2011? This video will show you how it's done. Whether you're new to Microsoft's popular digital spreadsheet application, new to Excel 2011 or even an expert merely looking to brush up on the fundamentals, you're sure to be well served by this quality video tutorial from the folks at Lynda. For all of the details, and to get started using AutoSum formulas in your own MS Excel '11 projects, watch the video.
In this video Nicko teaches us how to roast a chicken for Christmas dinner. You will need: 1 large whole chicken, 2 lemons, seasons, paprika, chicken spice, chicken spice, cayenne pepper, bbq seasoning, salt, and pepper. The optional vegetables you can use are: baby potatoes and red onions. First, place your chicken on a roast rack and cover it with the seasoning and the lemon juice. After this, cut your potatoes up and place them around the chicken with onions. Now, roast the chicken in the ...
In this tutorial, we learn how to decorate a bronze beauty cake with fondant. Start off by coloring the cake with a light bronze or buttercream color. After you do this, you will need to mix up some medium brown colored icing and place it into a piping bag. When you do this, you will pipe this all around the sides of the cake. When you finish with this, you will color the fondant the same color brown and then roll it into a circled shape to make beautiful flowers. Lay these on the cake and th...
In this tutorial, we learn how to decorate a carrot cake. First, apply icing all over the top and the sides of the cake. After this, apply sliced pecans to the side of the cake using your hands to press them on. After this, use your icing to create squares in the cake to make equal size pieces. Then, use orange and green icing to create carrot shapes on all of the individual squares. Once you're finished making the carrots, you will be ready to cut this up and serve. If you want more icing, y...
In this tutorial, we learn how to make and decorate a spider cake for Halloween. First, you will need to bake cupcakes and then use these to help shape the spider. After this, use green and black frosting in a tube to create a spiked look for a pattern of each all over the cake. After you finish decorating the spider with the frosting, use gum drops to decorate the eyes and use candy corn to make the teeth. Then, stick black licorice pieces on the sides to make the legs, with orange slice gum...
In this video, we learn how to make chocolate covered strawberries for dessert. First you will wash your strawberries and then thoroughly dry them as well. After this, you will take two squeeze bottles from a craft store and fill them half way through with two different kinds of decorating chocolate. Then, heat up a double boiler and heat up chocolate candy melts. Then, melt the two craft bottles in the hot water from the double boiler. Now, dip the strawberries into the chocolate and place t...
In this tutorial, we learn how to make a buffalo wing dig. This is to be baked in a 9x13 baking dish. You will need: 2 packages cream cheese, hot wing sauce, blue cheese dressing, 3 celery stalks, 2 c your choice cheese, and 2 c chopped boiled chicken. Combine all of these ingredients together in a large mixing bowl After this, pour into your baking dish and add more cheese to the top. Bake this in the oven until golden brown on the top and enjoy! To make another dip, you will need: 2 c chees...
In this video, we learn how to make homemade spaghetti sauce. This uses ground turkey instead of meat. First, chop up a small onion and turn your pot on high. Fill it with 3 tbsp extra virgin olive oil and the diced onions. Next, add in 1 tbsp garlic shallot puree. Then, add in 1 tbsp dried basil leaves crushed up with your fingers. Then, add in 1 tbsp dried oregano and your ground turkey meat. Then, add in 1/3 c sherry wine and then 2 cans of organic crushed tomatoes. Let this simmer and mix...
In this video, we learn how to make Korean short ribs with sauteed asparagus. You will need: 1 lb short ribs, 3/4 c soy sauce, 3/4 c brown sugar, 2 tbsp sesame seed oil, and 5 cloves garlic. First, crush the five cloves of garlic up and then chop them. From here, combine this with all the other liquid ingredients and mix well. Then, pour this into a bag with the ribs and leave in the fridge for 30 minutes. Next, make some asparagus with onion and chopped garlic. Heat a skillet with olive oil ...
In this tutorial, we learn how to cook yellow summer squash. You will need: yellow squash, zucchini, bacon, and salt to make this recipe. now, you will cut your bacon into strips and then cook it over medium heat in a large skillet. Once the bacon is fried and crispy, you will need to take it out along with most of the drippings, unless you like a lot of it in your recipe. After this, cut your vegetables up into thin slices. Then, add these along with some salt to the pot you cooked the bacon...
In this free video chemistry lesson from Salman Khan, we learn about SN1 reactions. Whether you need help studying for that next big test or could just use a hand finishing your homework, you're sure to be well served by this video lesson. For all of the details, take a look.
This mummy-shaped cupcake will be a ka-razy big hit on your Halloween buffet table. Flat, noodle-like layers of icing create a bandaged mummy effect, while an assortment of blue and red candies mimic the mummy's creepy eyes and mouth.
This delicious, crunchy snack is from Gujarat, India, where it has been served traditionally with crisped rice and dry cereal. This particular version is made with corn for a bit of sweetness.
In this free video science lesson from Internet pedagogical superstar Salman Khan, you'll learn how to name amines. Whether you need help studying for that next big test or could just use a hand finishing your homework, you're sure to be well served by this video lesson. For more information, including detailed, step-by-step instructions, take a look.
In this video, we learn how to make cranberry orange scones. To make this, you will need: 3 c self-rising flour, 1/2 c sugar, 1 stick unsalted butter, 3/4 c buttermilk, 1/4 c orange juice, and 1/2 c chopped cranberries. Pour all of these into a bowl and stir them together. Once they are mixed, add in the zest of one orange and fold it in. Then, pour this into a baking dish that has been greased and place in the oven at 400 degrees, then bake for 12-20 minutes. After this, prepare the glaze by...
In this tutorial, we learn how to cook buttermilk fried chicken. First, take your chicken and marinade with black pepper, paprika, salt, and cayenne pepper. Use any other seasonings you would like. After this, pour buttermilk over the chicken and then let it sit for a couple of hours in the fridge. Now, combine flour with salt and pepper and any other seasonings you would like. Cover the chicken in the flour, getting as much flour on them as possible. Then, let the chicken sit for a few minut...
In this tutorial, we learn how to cook crab soup. First, you will need to saute some garlic, chopped onion, and olive oil together. Next, you will add in some shallots and broth to the large pan. Then, add in some salt and pepper, along with an array of vegetables and spices that you prefer. Use as many as you would like: including artichoke hearts, peas, and carrots. Once this is brought to a boil, add in some potatoes and crab to the pot. Let this simmer and allow the potatoes to cook. When...
In this tutorial, we learn how to make an authentic alfredo sauce. First, you will want to add some soft butter into a bowl and break it apart. Then, mix in some grated cheese (your choice) and mix together until you have a creamy paste. Once this is a paste, add in your cooked pasta and mix everything together until the pasta is coated. Add in some of the pasta water to the bowl if you would like, then add in the vegetables to the dish. You can season this with some more seasonings if you wo...
In this video we learn how to make biscuits. First, pour 2 c self-rising flour in a large bowl. After this, add in 1/2 tsp salt and then add in 4 tbsp shortening then mix up with your hands. From here, add in 3/4 c milk and then mix everything together until well combined. After these are combined, spread these out and cut them out into biscuit shapes. Bake these in the oven until they are golden brown and cooked all the way through. Then, serve these with some fresh butter and your favorite ...
In this video, we learn how to make chicken katsu or Japanese fried chicken. To start, you will need to pour some flour into a large bowl and then sprinkle it with your favorite seasonings you want on your chicken. Get creative and add as many or few seasonings as you would like. After you mix this together, you will crack two eggs and whisk them together with a fork. Now, pour some panko breadcrumbs into a bowl next to the other two bowls. Take your chicken and dip it into the flour and then...
In this video, we learn how to cut a pineapple. First, take your pineapple and remove the leaves from it. Then, using a sharp knife you will cut off both ends of the pineapple. From here, turn the fruit on one side and gently cut the edges off of it with the sharp knife. Continue to do this all the way around the pineapple until there is no more skin left on it. After this, you will place the fruit on it's side and cut it into thick slices. After this, take each individual slice and cut the r...
This video tutorial is in the Food category which will show you how to make a no-bake oatmeal raisin cookie. Put dry oat powder into a mixing bowl, then add 1/2 cup of dates, 1/2 cup of raisins and a pinch of cinnamon. Now mix well with your hands to make the cookie dough. Normally the moisture in the dates should help in binding the dough. If that doesn't happen, you can add a little bit of water. The awesome thing about this cookie is that you don't have to bake it. After the dough is ready...
In this tutorial, we learn how to make cinnamon toast crunch French toast. Start out by beating up a couple off eggs, adding in some half and half and water. Then, add in some cinnamon and sugar to the egg mixture. Now, dip your bread into the egg wash, then toss it in some crushed Cinnamon Toast Crunch. When you are finished with this, you will grill the bread on a hot skillet that has been greased. When it is golden brown on both sides, serve this with syrup and whipped cream and share with...
In this tutorial, we learn how to prepare a cantaloupe. First, cut the top and the bottom off of the cantaloupe. After you have these cut off, take a sharp knife and cut from the top to the bottom of the fruit. Cut just the skin off, making sure you get the least amount of orange left on the skin when it's cut off. Continue to cut all the way around the cantaloupe until there is no more green or skin left on the fruit. After this, cut the fruit in half and then scoop out all the seeds. From h...
In this video, we learn how to make traditional tamales. You can fill your tamales with anything that sounds good to you, using any meat and veggies. First, you will need to separate and soak corn chucks in water for a few hours. After this, you will need to make your masa in a large container until it has a spongy feel and place in fridge overnight. From here, you will mix paprika, pumpkin seeds, pepper seeds, and water to make the sauce that will mix with your meat. Ground these up after br...
In this tutorial, we learn how to make mini veggie burgers. First, boil some water to add in with your soy protein. Mix these together until there are no chunks and everything is well incorporated. Set this aside, then mix up 1/4 c oats, 1/2 tsp garlic powder, 1/2 tsp onion powder, 3 tbsp flour, 1 tsp salt, 1/2 tsp cumin, 1 tbsp ketchup, 1 tbsp soy sauce, and 1 egg. Now, combine the first mixture with the second one and form patties with it. Fry these on a skillet, then serve with your favori...
In this tutorial, we learn how to make Cuban Sopa de Platano (plantain soup). Ingredients are: 4 c chicken broth, 1 chopped onion, 1 carrot, 1 celery rib, 4 garlic cloves, 2 large plantains, 1 bay leaf, salt, 1/2 c cilantro, and 1 lime. Once you have prepared all your ingredients, add the onion, celery, and carrots to a pan with olive oil. Saute these, then add in the garlic and mix together with the chicken broth. From here, add in the bay leaf, then the salt and bring to a boil. Add in the ...
In this video, we learn how to make a chicken and white wine cream sauce. First, saute a chicken breast in some butter, then place it in the oven and cook until it's finished. After this, melt some more butter in a pan and add in some shallots to the pan. Saute these for around a minute, then add in white wine and reduce. Once it's reduced, add in some heavy cream to the pan and let it reduce. Now, take this off the heat and add in a lot of butter and salt/pepper to taste. Now, you can pour t...
In this tutorial, we learn how to make Dutch oven chicken. Ingredients are: 1 whole chicken, 1 chopped onion, 3 tbsp garlic, salt, pepper, cayenne pepper, paprika, Italian seasoning, and 28 oz diced tomatoes. First, melt some butter in a pot and then throw in your chopped onion. Let this heat up, then add in your garlic and other seasonings with it. Once these are combined, stick your chicken on top of them and sprinkle on additional flavorings of your choice. Cook for 1.5 hours on medium wit...
In this video, Skinny and Mini teach us how to make a quiche. First, crack two eggs inside of a bowl and whisk them together. Next, you will need to add in four more eggs and whisk those with in. Now, you add whisk in half of 1/3 c water with the eggs. From here, you will add in your favorite vegetables and meats that you want in with your quiche. Also add in your choice of cheese and combine everything together. Now, grease a baking dish and pour the quiche mixture inside of it. Bake this in...
In this tutorial, we learn how to cook chicken and yellow rice the quick & easy way. First, you will need to boil your chicken and de-bone it. After you cut it up into chunks, place 2 tbsp butter in a large pot. Then add in 1 large chopped onion and saute. After this, add in 2 large chopped carrots and saute for several minutes. Then, add in your chicken pieces and stir everything together so the chicken can absorb the juices. After this, add in salt, pepper, and garlic for seasoning and acco...
In this video, we learn how to make chicken and dumplings. To make this, you will need: 3 chicken breasts, 2 pie crusts, 1 onion, 3 tbsp garlic, and 8 cups chicken broth. First, you will saute chopped onions with minced garlic and salt/pepper. Stir this, then add your chicken skin down into the pot. Let the chicken brown and cook on all sides until it's cooked all the way through. After this, take the chicken out and drain the fat from the juices left in the pot. Tear your chicken into pieces...
