Beranda > Computer & IT, Office & Project, Video Training & Tutorial Release > Lynda.com – Excel 2007 Working with Dates and Times

Lynda.com – Excel 2007 Working with Dates and Times

Publisher : Lynda.com
Platform : Microsoft Excel
Format : Mov
Size : 1 CD

Links : Homepage

 

Description :

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

Screenshot :

Lynda.com - Excel 2007 Working with Dates and Times Screenshot

  1. Belum ada komentar.
  1. No trackbacks yet.

Tinggalkan Balasan

Isikan data di bawah atau klik salah satu ikon untuk log in:

Logo WordPress.com

You are commenting using your WordPress.com account. Logout / Ubah )

Gambar Twitter

You are commenting using your Twitter account. Logout / Ubah )

Foto Facebook

You are commenting using your Facebook account. Logout / Ubah )

Foto Google+

You are commenting using your Google+ account. Logout / Ubah )

Connecting to %s

%d blogger menyukai ini: