MS Excel – Intermediate Level

  • Home
  • MS Excel – Intermediate Level
( 0 Rating )
Shape Image One
  • by sahil
  • Course level: Intermediate
  • Categories MS Excel
  • Duration 14h
  • Total Enrolled 0
  • Last Update September 25, 2020

About Course

Lorem ipsum dolor sit amet, constetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore.

Description

Syllabus for Beginner Level – 2 Hours Per Day

  1. Introduction of Excel
  2. Worksheet/Workbook
  3. Cells, Cell Address
  4. Mathematical Operators
  5. Formula
  6. Formatting Cells
  7. Cut/Copy/Paste
  8. Drag and Drop
  9. Use of Ribbon tools
  10. Save/Open Worksheets
  11. Page Layout and printing of Worksheet
  12. Date/Time Formatting
  13. Chart, Data Sort
  14. Filter Validation
  15. Conditional formatting
  16. some important functions like SUM
  17. AVERAGE & Examples of worksheets
  18. Lookup Function (Hlookup/Vlookup)
  19. Data Table
  20. Cell References with Examples
  21. Protection of Formula/Sheets
  22. GST Invoice
  23. Goal Seek
  24. Solver
  25. Function (Date/Time/ SumIf/Sumifs/CountIF/CountIfs)
  26. Remove Duplicate
  27. Range Naming
  28. Freeze Panes & Split Windows

Certification

Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Quis ipsum suspendisse ultrices gravida. Risus commodo viverra maecenas accumsan lacus vel facilisis.

Who This Course is for

Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Quis ipsum suspendisse ultrices gravida. Risus commodo viverra maecenas accumsan lacus vel facilisis.

What Will I Learn?

  • Learn MS Excel very well in very short time.

About the instructors

4.00 (1 ratings)

18 Courses

14 students

300.00

Material Includes

  • 3 hours on-demand video
  • 3 articles
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of completion

Requirements

  • You just need a computer with Internet access and a Web Browser

Target Audience

  • Get your team access to 4,000+ top eCademy courses anytime, anywhere.