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: [...]
All posts tagged excel
Formatting & Keyboard Shorcuts for Date & Time Data [Excel 2007]
Posted by Paul D. Wood on April 19, 2012
http://workyourbest.com/2012/04/19/formatting-keyboard-shorcuts-for-date-time-data-excel-2007/
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 [...]
Posted by Paul D. Wood on August 3, 2011
http://workyourbest.com/2011/08/03/vertical-lookup-function-excel-2007-2010/
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 [...]
Posted by Paul D. Wood on June 16, 2011
http://workyourbest.com/2011/06/16/define-variable-names-to-spreadsheet-cells-excel-2007-2010/
-
Authors
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
Paul D. Wood
