Microsoft Office arrow Lynda - Excel 2007 Working with Dates and Times
Lynda - Excel VBA in DepthLynda - Excel 2007 Power Shortcuts

Lynda - Excel 2007 Working with Dates and Times
ดูภาพขยาย


Lynda - Excel 2007 Working with Dates and Times

ราคาต่อหน่วย (piece): B 50.00


วิดีโอติวเตอร์สอนการใช้งานโปรแกรม excel เรื่อง Working with Dates and Times




alt


Lynda.com - Excel 2007 Working with Dates and Times
English | H264 960x540 | MP3 96 Kbps
Genre: eLearning

In Excel 2007: Working with Dates and Times, Dennis Taylor shares his solutions for optimizing the use of dates and times in Excel 2007. This course explains what's going on behind the scenes when Excel stores dates and times, gives tips for entering dates and times, and shows options for date and time formatting. It also demonstrates the various date and time functions and shows how to calculate with dates and times in a range of scenarios. Exercise files are included with the course.

Topics include:

* Understanding how Excel records and stores dates and times
* Looking at standard date/time entry options and acceptable alternatives
* Using the TODAY and NOW functions
* Customizing date formats
* Exploring keyboard shortcuts
* Formatting time for hours over 24
* Calculating differences across dates and times
* Rounding calculations
* Working with holidays
* Validating with dates
* Converting formatted dates to usable data



Introduction
Welcome           01:14
Using the exercise files           00:28
06:19 1. Excel's Date/Time System
Understanding how Excel records and stores dates           04:15
Understanding how Excel records and stores times           02:04
15:19 2. Creating Date/Time Entries
Looking at standard date/time entry options and acceptable alternatives           05:19
Using instant date/time entry           01:17
Using TODAY and NOW functions for dynamic date/time entry           03:02
Using Auto Fill to enter date and time series           05:41
08:03 3. Date/Time Formatting
Exploring keystroke shortcuts           02:12
Formatting time for hours over 24           03:04
Creating custom date formatting           02:47
18:51 4. Excel's Date/Time Functions
EOMONTH and EDATE: Setting ends of months and future/past dates           04:07
DATEDIF: Calculating date differences by year, month, day, and more           04:15
WEEKDAY: Determining the day of the week           02:13
NETWORKDAYS: Calculating working days           02:50
WORKDAY: Calculating an ending date           02:09
DATEVALUE and TIMEVALUE: Converting text entries into dates and times           03:17
21:34 5. Calculating with Dates and Times
Calculating date differences across days, months, and years           01:44
Calculating time differences within and across days           05:34
Calculating fiscal years and quarters           05:44
Rounding time calculations to convenient intervals           03:48
Using times with currency calculations           02:44
Calculating holidays (Labor Day, Thanksgiving, Memorial Day, etc.)           02:00
15:30 6. Using Dates and Times with Excel Commands
Using special date filters with date data           03:15
Using date controls in data validation rules           05:30
Using date functions in data validation rules           03:39
Converting unusually formatted dates into usable data (text to columns)           03:06
00:29 Conclusion
Goodbye           00:29







แสดงสินค้าเมื่อไม่นานนี้

สินค้าหมวดอื่นๆ


Access

Access


Excel

Excel


Groove

Groove


Infopath

Infopath


Onenote

Onenote


Outlook

Outlook


Powerpoint

Powerpoint


Publisher

Publisher


Sharepoint

Sharepoint


Word

Word


Featured Products | สินค้าแนะนำ

Lynda - CGI Essential Training
Lynda - CGI Essential Training
B 50.00

VideoHive set 46-50
VideoHive set 46-50
B 450.00
B 300.00
ท่านประหยัดได้: B 150.00

Blender DVD training 4 Venoms Lab
Blender DVD training 4 Venoms Lab
B 200.00

INE ADVANCED TECHNOLOGIES ON DEMAND 4
INE ADVANCED TECHNOLOGIES ON DEMAND 4
B 800.00
B 500.00
ท่านประหยัดได้: B 300.00

Random Product | สุ่มการแสดงผล

Lynda - Google Website Optimizer Essential Training with David Booth
Lynda - Google Website Optimizer Essential Training with David Booth
B 100.00

Lynda - Foundations of Photography Black and White
Lynda - Foundations of Photography Black and White
B 100.00

Digital Tutors - Introduction to 3ds Max 2011
Digital Tutors - Introduction to 3ds Max 2011
B 100.00

Artbeats - Canadian City Aerials HD Vol.1
Artbeats - Canadian City Aerials HD Vol.1
B 200.00
B 170.00
ท่านประหยัดได้: B 30.00

Cart | รถเข็น

รถเข็นของท่านยังไม่มีรายการสินค้า

JoomlaWatch Stats 1.2.9 by Matej Koval

 

GFX Blog

HTLM5 eBooks Collection [Part2] (2012) 11 เมษายน 2012, 13.18
HTLM5 eBooks Collection [Part2] (2012)
Download Free : HTLM5 eBooks Collection [Part2] (2012) English | PDF | 21 eBooks | 284 MB ...

HTLM5 eBooks Collection [Part1] (2012) 08 เมษายน 2012, 13.17
HTLM5 eBooks Collection [Part1] (2012)
Download Free : HTLM5 eBooks Collection [Part1] (2012) English | PDF | 33 eBooks | 304 MB ...

Programming Video Games for the Evil Genius 08 เมษายน 2012, 13.13
Programming Video Games for the Evil Genius
Download Free : Ian Cinnamon, "Programming Video Games for the Evil Genius" ISBN: 0071497528 | edition 2008 | PDF | 336 pages | 11,4 mb ...

Joomla Templates and Joomla Extensions by ZooTemplate.Com