Teacher's Corner

“Our deepest fear is not that we are inadequate. Our deepest fear is that we are powerful beyond measure. It is our light, not our darkness that most frightens us. We ask ourselves, Who am I to be brilliant, gorgeous, talented, fabulous? Actually, who are you not to be? You are a child of God.” - Marriane Williamson

Pages

  • MS Excel
  • Secretarial - I
  • My Escapades
  • Random

Chapter 2 - MS Excel

Chapter 2 - MS Excel
1. Important Date Functions (TODAY, NOW, YEAR, MONTH, DAY, DATE )
2. Age Calculations
3. Calculate End of Probation period using EDATE & WORKDAY
4. Calculate no. of working days between two dates (Networkdays Function)
5. Common Error types in Excel and error handling by Iferror function.
6. Substitute and Find
7. Left, Right and Mid
8. Common IS Functions : Istext, Isnumber, Isblank, Iserror
9. Len and Text


BACK TO THE HOME PAGE
Posted by BeeBee
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Newer Post Older Post Home

TOPICS

  • ►  2017 (26)
    • ►  July (18)
      • ►  Jul 30 (4)
      • ►  Jul 21 (3)
      • ►  Jul 14 (9)
      • ►  Jul 09 (1)
      • ►  Jul 08 (1)
    • ►  April (6)
      • ►  Apr 23 (2)
      • ►  Apr 21 (3)
      • ►  Apr 14 (1)
    • ►  January (2)
      • ►  Jan 07 (2)
  • ▼  2016 (29)
    • ►  November (2)
      • ►  Nov 05 (1)
      • ►  Nov 02 (1)
    • ▼  October (27)
      • ►  Oct 31 (6)
      • ▼  Oct 28 (10)
        • Chapter 2 - MS Excel
        • MS EXCEL - Len and Text
        • MS EXCEL - Common IS Functions : Istext, Isnumber,...
        • MS EXCEL - Left, Right and Mid
        • MS EXCEL - Substitute and Find
        • MS EXCEL - Common Error types in Excel and error h...
        • MS EXCEL - Calculate no. of working days between t...
        • MS EXCEL - Calculate End of Probation period using...
        • MS EXCEL - Age Calculations
        • Important Date Functions (TODAY, NOW, YEAR, MONTH,...
      • ►  Oct 24 (7)
      • ►  Oct 23 (4)
Simple theme. Powered by Blogger.