Ira Krakow
ASIN: B00LC7UWL2
Publisher: The Krakow Press
Pages: 124
Ira's book, based on his Excel knowledge and experience since its inception in 1985, is a comprehensive presentation of Excel's amazing date and time formulas and functions. Topics covered include:• How to create a time card in Excel, starting with a blank worksheet• How to display calendar headings in Hindi, Chinese, Yoruba, French, Estonian, and many other languages• How to construct a formulas that calculate Thanksgiving, Memorial Day, or Columbus Day for any year• How to create a calendar a book club meeting that meets on the third Tuesday of the month• How to calculate a person’s age in years, months, days, hours, minutes, and/or seconds• How to import dates from external databases with the Text to Columns Wizard• Why the date you enter isn’t the same as the date Excel displays• When Excel thinks dates are text• How Excel stores time• How to create column headings with times ...