How to do
everything in Excel in half the time- Dates
Dates are a common problem area for users of Excel, particularly
in the business world. This book covers the key questions around
dates in a quick, easy to read way. Just over 45 pages of useful
date related excel knowledge that will halve your work time (at
least!)
Read more below or go and buy it from
www.AuditExcel.com
|
|
Search the site
Contact Details
Mail:
info@AuditExcel.co.za
+27 11 563 3805
Miricle Solutions cc PO Box
2683 Rivonia
2128 |
- Understanding Dates in Microsoft Excel
- How do I know if Excel recognizes my date?
- Option 1
- Option 2
- Option 3
- Extract a DAY from a date
- Extract a MONTH from a date
- Extract a YEAR from a date
- Create a valid excel date with the day, month and year
information
- How to find the last day of the month, even in leap years
- How to determine what day of the week a date represents
- How to determine when the next working day is
- How to determine the number of working days between 2 dates
- How to count the number of days, months or years between 2
dates
- How to CONVERT dd/mm/yyyy to mm/dd/yyyy and vice versa
- How to CONVERT 20100925 into a valid excel date
- How to CONVERT 2010.09.25 into a valid excel date
- How to CONVERT any date style into an excel recognised date
- How to convert an Excel date into a 'special' format for uploads
e.g.2010.12.25
- How to Enter the current Date and Time easily into a cell
- How to find new formats for dates (and time)
- Why should I be careful about dates past 2030
- Why do some of my dates have a green note warning about
entering 2 digits
- How to group Pivot Table dates into years, quarters, months,
days etc
- Why does my Pivot Table not recognise my dates
- How do I get a pivot table to show me all the dates in a
sequence, even the dates with no data
- How do I get a year and a month in the horizontal axis of a
graph
- How can I control what dates are entered into a cell
- How can I change the colour of cell if a date exceeds a
reference date
- What does a #value mean when looking at a date
- How to set up a time format so that it adds the hours past 24
hours
- How to force Excel to see a 'date' as a date
- How to determine the fraction of a year between 2 dates
- Thinking through Date Problems in Excel
- How to escalate income based on periodic, date based
escalations
- How do I check if a year is a leap year
- How to determine the last weekday of any month
- CTRL Shortcuts
- How to easily access every function/ formula in Excel
|
|
In Excel terms what you will learn includes the following
functions and tools:
- WEEKDAY
- EOMONTH
- DATE
- DAY
- MONTH
- YEAR
- Custom Formats for dates
- Convert from US (mmddyyyy) to European format (ddmmyyyy)
- DATEDIF
- WORKDAY
- NETWORKDAY
- CELL
- DATEVALUE
- YEARFRAC
To but this book visit our corporate site at
www.AuditExcel.com |
.gif)
.gif)
NEW Videos
