# lifong Profile

Lee Li Fong

Join Date:
2010-11-15

## 1 - Work Smart By Smart Use Of Microsoft Office

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.

### Latest Blog Posts

• on Jul 27, 2012
try...
• on Jul 27, 2012
try...
• Show Variance Between Year PivotTable
on Jan 26, 2012 in Forum
Hi 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 PivotTable
on Jan 26, 2012
Question: 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 Month
on Dec 5, 2010
You 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 Excel
on Nov 28, 2010
Recently, 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 Date
on Nov 12, 2010
Some 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 Forum
Regarding 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 Range
on Apr 15, 2010
Regarding 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 Word
on Apr 2, 2010 in Forum
Regarding 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...
• Run A Macro By Opening A File
on Mar 25, 2010 in Forum
Eric,Referring to your question on how to run a macro when you open a file with the condition if current time is between 9 am and 10 am, otherwise, don't run this macro.I had create a Open event at the ThisWorkbook objects. You can use the If stateme...
• Linking Data From Form To DatabaseMany of us need to updata details of documents into a database/master list. Many of us always forget to update the database. It is good if we can update the database automatically whenever the changes of documents.The example below show you if you ca...
• Create Drop-down List From Other Workbook
on Mar 24, 2010 in Forum
Juan,Regarding your question of creating drop-down list at other workbooks by using the database from different workbook. When the database is revised, the drop-list of all the related workbooks will change accordingly. I had show the ways of doing s...
• Retrieve Data From Excel To Prepare Other Document
on Mar 21, 2010 in Linking Data From Excel To Word
Most of us like to prepare database in Microsoft Excel. If we can smart use of the database, we can use the information from the database in Excel to prepare other documents for example use the company details to prepare envelope as the example below...
• Combine Data Into A Form Automatically
on Mar 21, 2010
Are you fed up with keep asking your colleagues to update a form for you? Some staffs especially a ISO 9000 Project Coordinator always need to ask their colleagues updating a form. Now if you can smart use of Microsoft Office Excel functions, you can...
• Update Master List/Database AutomaticallyMany of us need to update the details of documents into a master list/database. When there is a change to the document, the master list/database need to update again. Most of us may forget to update the master list/database. Therefore, this book will...
• Perform Calculation AutomaticallyIf you are working at a manufacturing company, you must be familiar with tolerance, upper and lower specification. Normally, a customer will give a their supplier(manufacturing company) upper and lower specification of important inspection dimension.
• Speed Up Data Entry and Reduce Typing ErrorIn our daily job, we can not avoid repeatedly entrying same company details into document such as fax document, product labels, Purchase Order and etc. But do you know by combination of multiple useful and practical functions of Microsoft Office such...
• Monitor Data Entry AutomaticallySometime after your subordinate enter the inspection result into a Inspection Report, you need to check the data again. It is time consuming to check the data and human fatique may miss out the invalid data.For the Inspection Report below, you can se...
• View Multiple Worksheet At The Same TimeWhen we want to update/cross check from a document to another document, it is good if we can view the related document/worksheet at the same time. It can save our time keep referring to another document/worksheet. View the related document/worksheet...
1
Blogs
0
Followers
0
Following