Show Pie Chart By Month

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 picture below.


2) Vlookup or Hlookup is a good function to obtain data from a table. After selecting a month, use Vlookup to obtain data from table below. Thats all. After select a month, the data from selected month will show at table above. Then, create pie chart using table above.

Compiling Data By Date

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 Insert, PivotTable,select New Worksheet or Existing Worksheet,select location, OK.
2. The PivotTable Field List will then shown at the right, select the Date and Quantity field list, then the table will created.

Include a value from one cell within text of another cell.

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 also use Data Validation at Data, Data Validation by setting Setting below.

You can also set message box to display by setting Error Alert below.

When the number 25 to 150 is enter, a message box and text is displayed as below.

Conditional Formatting Date Range

Regarding the question how to use Conditional Formatting to look at the range of dates in
B3: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 picture below, when you use sumproduct for cell Q7 compare with range B3:B13, it will equal to 1 because it is in the range.




Therefore, you can use the formula to conditional formatting's formula by setting it to red color if the formula more than o or equal 1.

Check box help in Word

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 toolbar) and Commandbutton (from Control Toolbox). (For Word 2007, click Customize Quick Access Toolbar, More Command, Choose Command From: All Command, add Check box, Command button).
2) Select the Commandbutton and right-click to select View Code.

3) The Microsoft Visual Basic will open for you to write coding. Write this statement to enable the checkbox check after press command button.

ActiveDocument.FormFields("Check1").CheckBox.Value=True

4) Double-click the checkbox to ensure the check box name is tally.

5) Select the commandbutton and right-click to select CommandButton Object, Edit to change the commandbutton caption to "Check".

6) Click Exit Design Mode. Now you can click the "Check" button to check the checkbox. (For Word 2007, click Customize Quick Access Toolbar, More Command, Choose Command From: All Command, add Design Mode).

7) Now, when you click the button, the check box will check. You can also write other program to perform action required by you.

Run A Macro By Opening A File

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 statement below, and change Msgbox below to Run to run your macro.

Linking Data From Form To Database

Many 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 can smart use of the template wizard function, you can updating database/master list automatically whenever the change of documents.


Now you can see the real life examples how other people work smart by smart use of Microsoft Office (Microsoft Excel, Word and PowerPoint) in a series of Microsoft Office (Microsoft Excel, Word and PowerPoint) book. You can view the coverage and special features of the books at Youtube and get the books in ebay.

Create Drop-down List From Other Workbook

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 so.

1. Create drop-down list where the data get from other workbook.

2. Show the Form toolbar.

3. Show Format Control dialog box.
4. Setting the Input range from other workbook.
5. The drop-list down is created after click OK.

Retrieve Data From Excel To Prepare Other Document

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.

After linking the database from Excel to Word in envelope, simply by clicking the arrow, you can prepare envelope of other company easily.

You can also use the same database to prepare other document like letter/quotation by adding in other additional columns.


Now you can see the real life examples how other people work smart by smart use of Microsoft Office (Microsoft Excel, Word and PowerPoint) in a series of Microsoft Office (Microsoft Excel, Word and PowerPoint) book. You can view the coverage and special features of the books at Youtube and get the books in ebay.

Combine Data Into A Form Automatically

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 just email a form for all coleagues to update it then reply to you. When they reply to you, you can then compile the data into your form automatically. If they forget to update it, just email to them as reminder again. You can even set email to them at a fixed frequency.

The example below show you how the example of getting suppliers' evaluation from respective departments by emailing to them. After receive their reply, you can then update into your form automatically.

Now you can see the real life examples how other people work smart by smart use of Microsoft Office (Microsoft Excel, Word and PowerPoint) in a series of Microsoft Office (Microsoft Excel, Word and PowerPoint) book. You can view the coverage and special features of the books at Youtube and get the books in ebay.

View Multiple Worksheet At The Same Time

When 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 at the same time is important especially we want to link master list/database with documents. This can enable us check whether the updating is accurate or not.

Update Master List/Database Automatically

Many 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 teach you how to smart use of Microsoft Excel and Word, the master list/database can update automatically whenever the change of the document.

For the example below, you can see whenever the document's Revision Number in Microsoft Word is changed, the master list/database is changed according to document.

Some user like to create their document and master List/database in Microsoft Excel, therefore the book also teach you how to update master list/database automatically whenever the document is changed.

Now you can see the real life examples how other people work smart by smart use of Microsoft Office (Microsoft Excel, Word and PowerPoint) in a series of Microsoft Office (Microsoft Excel, Word and PowerPoint) book. You can view the coverage and special features of the books at Youtube and get the books in ebay.

Monitor Data Entry Automatically

Sometime 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 see that if you can smart use of Microsoft Office function, you can setting a dialog box to display when the the data entry enter the value out of the acceptable range above. If the data entry choose to proceed with the invalid data, the value can set to red colour automatically (sometime the value is really out of range, and need to report to management). Therefore, the management can see the invalid data obviously.

Now you can see the real life examples how other people work smart by smart use of Microsoft Office (Microsoft Excel, Word and PowerPoint) in a series of Microsoft Office (Microsoft Excel, Word and PowerPoint) book. You can view the coverage and special features of the books at Youtube and get the books in ebay.

Decision Making Automatically

It is very ideal if once we enter the data, the workbook can show automatically whether the data comply to requirement. Therefore, it can save time reviewing data.

The example below show you when you smart use of Microsoft Excel functions, you can set when you enter the data, decision will make automatically whether comply to standard requirement.



Now you can see the real life examples how other people work smart by smart use of Microsoft Office (Microsoft Excel, Word and PowerPoint) in a series of Microsoft Office (Microsoft Excel, Word and PowerPoint) book. You can view the coverage and special features of the books at Youtube and get the books in ebay.

Perform Calculation Automatically

If 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. Therefore, the manufacturing company will base on the customer given upper and lower specification to calculate acceptable dimension. Most of the time, the uppper and lower specification will change frequently, therefore staff will need to calculate frequently. If the staff forget to change the acceptable dimension and calculate wrongly, it will give a big impact to the company.

The Inspection Data below show you when the user change the specification tolerance, the acceptable range will change automatically.

Now you can see the real life examples how other people work smart by smart use of Microsoft Office (Microsoft Excel, Word and PowerPoint) in a series of Microsoft Office (Microsoft Excel, Word and PowerPoint) book. You can view the coverage and special features of the books at Youtube and get the books in ebay.

Reduce Time Key In Same Wording

Most of the time we need to key in numbering together with same wording at a cell. If you key in numbering together with text in a cell, the number in the cell can not use for calculation. Besides, it is also time consuming keep entering the same wording.

For example the Inspection Data below, the data entry always need to enter sampling size together with "pcs" into sampling size column and enter lot size with "pcs" into Lot Size column. Therefore, if you can smart use of formatting cell function, you can reduce your time key in the "pcs" wording.

For the Purchase Order example below, you only need to enter the numbering in Quantity and Unit Price columns only, the "pcs" and "JPY" wording will display automatically. It is important here, because when you enter the numbering and text together, you can not perform calculation and it is also wasting your time.

Now you can see the real life examples how other people work smart by smart use of Microsoft Office (Microsoft Excel, Word and PowerPoint) in a series of Microsoft Office (Microsoft Excel, Word and PowerPoint) book. You can view the coverage and special features of the books at Youtube and get the books in ebay.

Speed Up Data Entry and Reduce Typing Error

In 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 as Microsoft Excel, Word, PowerPoint and etc. can help us increase our work efficiency. For examples below, smart use of Validation function and lookup worksheet function can help us speed up data entry and reduce typing error at our job.

The fax example show you how by selecting the company name only from the company drop-down list, the related company's recipient, fax, phone can change according.

The label example show you how by selecting the company name only from the company drop-down list, the related company's recipient, fax, phone can change accordingly. Besides, you can also set by selecting Part Number, the related Part Name, Quantity/box can change accordingly.

Can you see that by smart use of the practical and useful Microsoft Office functions, you can increase your working effiency. Of course, you need to explore more how the ways other people smart use of Microsoft Office in their jobs.

Now you can see the real life examples how other people work smart by smart use of Microsoft Office (Microsoft Excel, Word and PowerPoint) in a series of Microsoft Office (Microsoft Excel, Word and PowerPoint) book. You can view the coverage and special features of the books at Youtube and get the books in ebay.