Excel Date and Time Formulas Self-Taught

Contenuto dell'eBook:

Ira Krakow's book, based on his nearly 40 years of computer experience and his knowledge of Excel since its inception in 1985, answers these questions, as well as many others.

All the Excel functions, from all the Excel versions, are covered, including
DATE - DATEVALUE - TIME - TIMEVALUE - YEAR - MONTH - DAY - HOUR - MINUTE - SECOND - WEEKDAY - WEEKNUM - EOMONTH - YEARFRAC - DAYS360 - WORKDAY - WORKDAY.INTL - DATEDIF - NETWORKDAYS - NETWORKDAYS.INTL - ROMAN


Ira also shows you many useful Excel date and time tricks, with clear explanations and easy to follow, step by step, examples. 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 separated by 20 minutes
• How to create a date stamp, a date and time that does not recalculate
• How to fix time calculations that are more than 24 hours
• What Excel thinks the century is for a 2 digit year, and how to change it
• How to calculate the number of workdays in a project, given a deadline
• How to calculate a deadline, given the number of required workdays to complete a project, accounting for weekdays and holidays
• How military time works
• What happens with negative times
• A bug that’s always been in Excel and that Microsoft will never fix
• Why Excel has two date systems
• and many more.

After reading Ira’s book and following along using your version of Excel - any version will do - you should feel comfortable tackling even the most complex date and time related Excel calculations, giving you a giant leg up on becoming and Excel guru.

Per maggiori informazioni: l'eBook "Excel Date and Time Formulas Self-Taught" di Ira Krakow, edito da The Krakow Press, è in vendita in formato Kindle su Amazon.it al prezzo di Euro 3,01.