All posts by Paul D. Wood

Formatting & Keyboard Shorcuts for Date & Time Data [Excel 2007]

Video Details: OS: Windows 7 (x64) Program: Excel 2007 Similar Programs: Excel 2010 Example Files: Date and Time Functions Goal: To present the fundamentals of date and time manipulation within Excel 2007. Tweaks, Shortcuts, & Other Functions Used: Microsoft’s Serial Begin Time: 1/1/1900 at 12:00:00 AM Static Current Date: CTRL + ; Static Current Time: [...]

Vertical Lookup Function [Excel 2007 & 2010]

Goal: To create a formula that will read an input value and match it within a range of data [in a table], returning said matched row’s specified output column. Procedure: Create your reference table Create your input table Enter “=VLOOKUP(“ > select your lookup value (aka the value you want to cross-reference with the data [...]

Header, Footer, & Page Number Formattings [Word 2007 & 2010]

Goal: To fundamentally manipulate headers & footers within a Microsoft Word 2007 & 2010 document. Procedure: Office Ribbon > Insert (tab) > Header & Footer (group) Header (button) > Blank You’ll be presented with blank header, and it will automatically insert a center and right alignment tab. If you hit the TAB key, it will [...]

Define Variable Names to Spreadsheet Cells [Excel 2007 & 2010]

Goal: To define an individual cell or array of cells with a variable name. Procedure: Formulas > Defined Names (group) > Define Name (button) A New Name dialog box will appear, input the variable name, scope, and referring cells. Comment is optional. If you select the same range of cells you previously named, you should [...]

2 Comments

by Paul D. Wood on June 16, 2011 • Permalink

Posted in Excel, Office Suite

Tagged array, calculation, define, excel, excel 2007, formula, names, office, range, spreadsheet, tag

Posted by Paul D. Wood on June 16, 2011

http://workyourbest.com/2011/06/16/define-variable-names-to-spreadsheet-cells-excel-2007-2010/

Find & Replace Text [Word 2007 & 2010]

Goal: To find and replace all words (or phrases) within a document with desired text quickly. Procedure: Home (tab) Find (button) or Ctrl + F Replace (tab) Complete the Find What and Replace With fields. (Optional) – For additional options hit the More>> (button) and select you desired options. Replace All (button) Successful replacement > [...]

1 Comment

by Paul D. Wood on June 15, 2011 • Permalink

Posted in Office Suite, Word

Tagged apple, bill gates, ctrl + f, ctrl+f, find, Microsoft Word, phrase, replace, replace all, searching, steve jobs, Word, Word 2007, Word 2010

Posted by Paul D. Wood on June 15, 2011

http://workyourbest.com/2011/06/15/find-replace-text-word-2007-2010/

Page X of Y [Word 2007 & 2010]

Goal: To insert the current page number and total page count fields into the header or footer of the Word document; also known as Page X of Y. Procedure: Insert Page Numbers Choose Top of Page or Bottom of Page and scroll down to Page X of Y Select your preference for left, center, or [...]

3 Comments

by Paul D. Wood on June 9, 2011 • Permalink

Posted in Office Suite, Word

Tagged count, footer, header, Microsoft Word, office, page x of y, pages, total page, Word, Word 2007, Word 2010

Posted by Paul D. Wood on June 9, 2011

http://workyourbest.com/2011/06/09/page-x-of-y-word-2007-2010/

Export PDF to JPG [Adobe Acrobat]

Goal: To export a PDF to an image file, such as JPEG. Procedure: Open the PDF with Adobe Acrobat File > Export > Image > JPEG Confirm your save file name, location, and color/resolution settings (Settings Button) > Save. If image quality is an issue please adjust the color and resolution settings accordingly. Conclusion: You [...]

1 Comment

by Paul D. Wood on May 5, 2011 • Permalink

Posted in Adobe Acrobat

Tagged acrobat, adobe, adobe acrobat, export, image, img, jpeg, jpg, pdf, pdfs, png, portable document format, tif, tiff

Posted by Paul D. Wood on May 5, 2011

http://workyourbest.com/2011/05/05/export-pdf-to-jpg-adobe-acrobat/

Find a Topic:

Search for:
Categories
Authors
- Paul D. Wood
Recent
Twitter Updates
- Formatting & Keyboard Shorcuts for Date & Time Data [Excel 2007] wp.me/p1sY1G-30 1 month ago
- Graduated Response to force web users to prove innocence in 10 days if accused(not convicted) of copyright infringement bit.ly/GXRonz 2 months ago
- How does @lifehacker not have a "Print" compatible page formatting button? #basicwebfeatures 2 months ago
- DoJ bit.ly/z0HkVn claims APPL $-fixing on e-books @caseyjohnston #antitrust 2 months ago
- If ure in the market for an iPad2, why not wait until 2/7 to see if APPL drops the $ due to iPad3. Also, an 8GB iPad2? bit.ly/yHLKJR 3 months ago
Writer’s Guild
Copyright & Affliation Information

NOTE: I am in no way affiliated, sponsored, or compensated for these post(s) from any third party. These posts are my opinion(s) and anything I link to is at my sole discretion for the benefit of my readers, not for financial gain.

Unless explicitly stated, all works on this site are licensed under

WorkYourBest by Paul D. Wood is licensed under a Creative Commons Attribution-NonCommercial-NoDerivs 3.0 Unported License.

Based on a work at www.WorkYourBest.com

Header & design image(s) provided by Vectorportal.com (CC BY 2.0) via flickr

All posts by Paul D. Wood

Find a Topic:

Categories

Authors

Recent

Writer’s Guild

Copyright & Affliation Information

Follow “WorkYourBest.com”