excel2007函数使用.rar
需积分: 7 88 浏览量
2019-05-09
21:37:33
上传
评论
收藏 96.56MB RAR 举报
excel2007函数使用.rar （29个子文件） 
excel2007函数使用 04 Excel's Date Time Functions 
0403 WEEKDAY Determining the day of the week.mov 2.34MB 0404 NETWORKDAYS Calculating working days.mov 2.92MB 0401 EOMONTH and EDATE Setting ends of months and future past dates.mov 4.64MB 0406 DATEVALUE and TIMEVALUE Converting text entries into dates and times.mov 3.63MB 0402 DATEDIF Calculating date differences by year, month, day, and more.mov 4.96MB 0405 WORKDAY Calculating an ending date.mov 2.21MB 06 Using Dates and Times with Excel Commands 0602 Using date controls in data validation rules.mov 6.11MB 0604 Converting unusually formatted dates into usable data (text to columns).mov 3.94MB 0601 Using special date filters with date data.mov 5.26MB 0603 Using date functions in data validation rules.mov 4MB 02 Creating Date Time Entries 0201 Looking at standard date time entry options and acceptable alternatives.mov 5.48MB 0202 Using instant date time entry.mov 1.25MB 0203 Using TODAY and NOW functions for dynamic date time entry.mov 3.18MB 0204 Using Auto Fill to enter date and time series.mov 6.31MB 01 Excel's Date Time Entries 0101 Understanding how Excel records and stores dates.mov 5.62MB 0102 Understanding how Excel records and stores times.mov 2.15MB Exercise Files 
Ex_Files_Excel07_Dates.zip 3.12MB 05 Calculating with Dates and Times 0503 Calculating fiscal years and quarters.mov 6.42MB 0505 Using times with currency calculations.mov 2.91MB 0504 Rounding time calculations to convenient intervals.mov 4.44MB 0506 Calculating holidays (Labor Day, Thanksgiving, Memorial Day, etc.).mov 2.39MB 0502 Calculating time differences within and across days.mov 6.19MB 0501 Calculating date differences across days, months, and years.mov 2MB 00 Introduction 0002 Using the exercise files.mov 562KB 0001 Welcome.mov 8.48MB 07 Conclusion 0701 Goodbye.mov 404KB 03 Date Time Formatting 0302 Formatting time for hours over 24.mov 3.32MB 0301 Exploring keystroke shortcuts.mov 2.79MB 0303 Creating custom date formatting.mov 3.43MB资源评论
