Wednesday, April 30, 2014

Save as PDF File

Excel 2007 Save as PDF File,
1.       Click on “File”> Then click on “Save As”> PDF or XPS
2.       PDF should be selected by default, if not select “Save as type” of PDF
3.       Enter a “File Name”
4.       The Open file after publishing if checked will open the file after saving it
5.       Select whatever “Optimize for:” option you want...I will select “Standard (publishing online...)
6.   Click the “Options” button to publish the entire workbook, a selection or just the active worksheet(s)
7.       Click OK> Then Click “Publish”>

Read More..

Tuesday, April 1, 2014

COUNT Formula counts numbers and dates

Theory:
=COUNT(Range)
Example:
=COUNT(A2:A9)
The count formula above counts the number of times a date value or number value is listed. The count formula will not count anything other than dates and numbers.

Read More..

www.cineclouds.com. Powered by Blogger.