Toyin's Blog

Advance Excel

2011-11-30T01:04:00.000-08:00

If you know more excel tricks, you will excel in your career.
The topics we cover include the following:
Filter (Auto filter and Advanced filter)
Creating Subtotal
Validating & Producing Drop down list
Sorting using Excel database
Creating formulas with several operators and cell range
Using insert function feature to enter and edit formula
Creating and using name range
Selecting nonadjacent cell range
Creating conditional formula using IF function
Consolidating data from different files
Sharing a workgroup on the network
Using PMT Function
Importing and Exporting
Displaying and print formulas in a worksheet
Date Function
Working with arrays, array formulas and constants
Create Payroll and Mortgage
Macros
Recording Macros
Editing Macros
Assigning control to Macros
Creating Pivot Table
Change or Pivot a Table
Grouping information in a pivot Table
Pivot Chart
Using Database Function (DSUM)
Using Lookup Function (VLOOKUP)
Task (Analyzing Ticket Sales
Creating a Scenario
Creating a Scenario summary Report
Creating two input data table
Using Goal Seek
Setting up Complex what if analysis with Solver

Pecan Pie Recipe

2011-11-25T03:38:00.001-08:00

Pecan Pie
Use you favorite Pie crust
3 eggs beaten - add in
1 cup brown sugar
1 cup syrup (light or dark)
Pinch of salt
1 tsp. vanilla
Add 1 cup pecan nuts on top
Bake 45 min. at 350 degrees
(test with knife like you do with pumpkin pie)

Sweet POTATOES Recipe

2011-11-25T03:37:00.000-08:00

SWEET POTATOES RECIPES

Place sweet potatoes in 2-quart saucepan; add enough water just to cover potatoes. Heat to boiling; reduce heat. Cover and simmer 20 to 25 minutes or until tender; drain. When potatoes are cool enough to handle, slip off skins; cut potatoes into 1/2-inch slices.

2. Heat remaining ingredients in 10-inch skillet over medium heat, stirring constantly, until smooth and bubbly. Add potatoes. Gently stir until glazed and hot.

*1 can (23 ounces) sweet potatoes, drained and cut into 1/2-inch slices, can be substituted for the fresh sweet potatoes; omit step 1.

NUTRITION FACTS: 1 Serving:; Calories 210 (Calories from Fat 55); Fat 6g (Saturated 4g); Cholesterol 15mg; Sodium 250mg; Carbohydrate 40g (Dietary Fiber 3g); Protein 2g % DAILY VALUE:; Vitamin A 100%; Vitamin C 22%; Calcium 4%; Iron 4% DIET EXCHANGES:; 2 Starch; 1 Fruit; 1 Fat

Lighter Candied Sweet Potatoes: For 2 grams of fat and 175 calories per serving, decrease butter to 1 tablespoon; use nonstick skillet.

Mashed Sweet Potatoes: Cook potatoes as directed in step 1, except do not cut into slices. Omit 1/3 cup brown sugar, 3 tablespoons butter, 3 tablespoons water and 1/2 teaspoon salt. Add 2 tablespoons butter or stick margarine and 1/2 teaspoon salt to cooked, skinned potatoes. Mash potatoes in pan until no lumps remain.

Orange Sweet Potatoes: Substitute orange juice for the water. Add 1 tablespoon grated orange peel with the brown sugar.

Pineapple Sweet Potatoes: Omit water. Add 1 can (8 ounces) crushed pineapple in syrup, undrained, with the brown sugar

What Your Loved ones expects for Xmas

2011-11-24T13:54:00.000-08:00

Seasons come and go. Some are very significant while others are less.
During Christmas, one of the most significant seasons of the year,
You need to send worthy gifts to your friends and those you love.
But what can you send to them that will leave a permanent and
Lasting impact on their hearts and emotions?
Send them Cards, Send them customized Cards,
Wish them the best of the seasons with Cards.

<a href="http://www.tkqlhce.com/b1110lnwtnvAGGGCKBGACBKCFIKD" target="_blank" onmouseover="window.status='http://www.eyesave.com';return true;" onmouseout="window.status=' ';return true;">
<img src="http://www.awltovhc.com/s5105fz2rxvGMMMIQHMGIHQILOQJ" alt="" border="0"/></a>