Questions on date, currency, if and count functions

511 views · Published 25 March 2012 · 5:00 · Indexed 4 October 2026

Channel: Dinesh Kumar Takyar · 2012 · Education

Watch on YouTube

Simple yet very relevant questions by a website visitor to https://www.exceltrainingvideos.com.
The first question is how to enter today's date in an Excel worksheet. The next question involves calculating a bonus based on the sales amount. Formatting the total sales and bonus into a $ format with 2 decimal places is something most people need to do in a work environment. Finally, how to calculate the total number of entries.
http://www.youtube.com/watch?v=zSVcMZpcWxs

More from this channel

• 3:55 What are slicers in Microsoft Excel

  Dinesh Kumar Takyar

  1,913 views · 16 April 2011

• 4:39 How to use dsum and array formulas to perform specific calculations in Microsoft Excel

  Dinesh Kumar Takyar

  3,720 views · 31 October 2011

• 4:03 if function Excel

  Dinesh Kumar Takyar

  1,631 views · 9 November 2011

• 4:12 Conditional formatting solution Microsoft Excel

  Dinesh Kumar Takyar

  383 views · 16 November 2011

• 2:37 Collaboration in MS Excel using SkyDrive

  Dinesh Kumar Takyar

  2,603 views · 4 July 2012

• 15:37 Automating Managers Response Time Calculations in MS Excel

  Dinesh Kumar Takyar

  532 views · 19 September 2012

• 13:31 Graphs MS Excel - How to use them to avoid heavy calculations

  Dinesh Kumar Takyar

  502 views · 1 October 2012

• 0:07 HAPPY DIWALI

  Dinesh Kumar Takyar

  219 views · 13 November 2012