Share with you how to work smart by smart use of practical and useful Microsoft Office Excel, Word and PowerPoint. A lots of real life examples of work smart methods show in the blog.
Owner: lifong
Listed in: Computers
Language: English
Tags: microsoft office, microsoft excel, microsoft word, microsoft powerpoint, work smart
Site Statistics
Unique Visitors Today:
0
Page Views Today:
0
Unique Visitors this Week:
0
Page Views this Week:
0
Unique Visitors this Month:
5
Page Views this Month:
5
Total Unique Visitors:
3,047
Total Page Views:
3,697
Total Hits Out:
82
Latest Blog Posts for Work Smart By Smart Use Of Microsoft Office
- on Jul 27, 2012try...
- on Jul 27, 2012try...
- Show Variance Between Year PivotTableon Jan 26, 2012 in ForumHi AJ,Question: I need to create a variance formula for the data selected in a pivot table. My problem is that the data is coming in from one column and I don't know how to distinquish the data by year in the formula. I have put a small selection...
- Create Calculated Field At PivotTableon Jan 26, 2012Question: How can I create a calculation from the total of a count of a field on a pivot table? Example: I need to calculate the number of employees for each process level times a specified amount - 89 x $4.59, 3 x $4.59. Answer: Select the table and...
- Show Pie Chart By Monthon Dec 5, 2010You can show data into pie chart by month. By selecting a month, the pie chart will shown as picture below.Instruction:1) Data Validation is a good function to create a list of selection. You can use Data Validation to create a list of month as pictu...
- Practice Spelling Using Microsoft Excelon Nov 28, 2010Recently, I used some of the useful and practical Microsoft Excel's functions and Visual Basic For Application (VBA) of Microsoft Excel to create a program for my 5 years old daughter to practise her spelling of new wordings.At the same time I am als...
- Compiling Data By Dateon Nov 12, 2010Some people maybe take time to combile all the data by date/week/month/year, actually PivotTable tool at Microsoft Excel is useful for combile the data in table by date/week/month/year and also plot in into chart.Instruction:1. Select the data, click...
- Include a value from one cell within text of another cell.on Apr 16, 2010 in ForumRegarding the question when user enter data in cell B4, the cell B5 will show text such as " X is not a valid entry. Please enter the correct pair number." for entry of 25~150 (X is the enter number). You can use the formula below at cell B5:You can...
- Conditional Formatting Date Rangeon Apr 15, 2010Regarding the question how to use Conditional Formatting to look at the range of dates inB3:B13 and highlight all the cells that contain a date in the mini calendar. You can use sumproduct formula in your conditional formatting. You can see the pictu...
- Check box help in Wordon Apr 2, 2010 in ForumRegarding the question of a faster way to do check/uncheck these boxes, I propose create a command button to perform you required action. To do this, you need to create a simple program to do this.Follow the steps below:1) Insert Checkbox (from Forms...
Loading Comments...
Comments
{ds_PageTotalItemCount} commentcomments
{pvComments::date}
{pvComments::comment}