5.00
(1 Rating)

Microsoft Excel Certification Program

By cdp Categories: MS Office
Wishlist Share

About Course

Master Microsoft Excel from Basic to Advanced level and improve your workplace productivity with practical hands-on learning. Learn formulas, functions, data analysis, dashboards, Pivot Tables, and reporting skills used in real business environments.

Course Content

Excel Fundamentals
The Excel Fundamentals module is designed to provide learners with a strong foundation in Microsoft Excel. This section covers the essential concepts and tools required to work efficiently with spreadsheets in professional and business environments. Students will learn how to navigate the Excel interface, manage worksheets, protect cells, configure print settings, and use important features such as Goal Seek, Freeze Panes, Charts, Conditional Formatting, Data Validation, and Drop-Down Lists. The module also introduces basic formulas, date functions, rounding techniques, and budget planning templates used in day-to-day office operations. By completing this module, learners will gain practical knowledge of Excel fundamentals, improve data organization skills, enhance productivity, and build the confidence required to perform common spreadsheet tasks in academic, personal, and workplace scenarios. Lessons Included: • Excel Basic Knowledge • How To Lock (Protect) Cells In Excel • Excel Print Page Setup • Goal Seek In Excel • How To Freeze Row In Excel Tutorial • Charts In Excel • Conditional Formatting In Excel • How to Count Colored Cells in Excel • Data Validation In Excel • Excel Round Off Formula • DateDif In Excel Explained • How To Change Date Format In Excel • How to Create Drop Down List In Excel • Excel Budget Template

  • Excel Basic Knowledge
    00:00
  • How To Lock (Protect) Cells In Excel
    17:44
  • Excel Print Page Setup
    07:47
  • Microsoft Excel Final Assessment
  • Goal Seek In Excel
    04:14
  • How To Freeze Row In Excel Tutorial
    02:30
  • Charts In Excel
    17:51
  • Conditional Formatting In Excel
    03:20
  • How to Count Colored Cells in Excel?
    05:46
  • Data Validation In Excel
    22:22
  • Excel Lookup Tutorial
    32:16
  • How To Convert PDF To Excel
    01:46
  • Excel Round Off Formula
    02:34
  • Combining Data From Multiple Cells In Excel
    02:28
  • DateDif In Excel Explained
    03:28
  • How To Change Date Format In Excel (dd/mm/yyyy) To (mm/dd/yyyy)
    03:54
  • How to Create a Pivot Table Using Multiple Sheets in Excel
    03:28
  • Slicers In Excel
    04:25
  • Excel Tips And Tricks
    35:52
  • SUMIFS Formula in Excel
    07:35
  • How to Create Drop Down List In Excel?
    11:06
  • Excel Budget Template
    06:49
  • Excel MIS Report
    09:50
  • Excel Power Query Tutorial For Beginners
    56:56
  • Pivot Tables In Excel
    27:59

Student Ratings & Reviews

5.0
Total 1 Rating
5
1 Rating
4
0 Rating
3
0 Rating
2
0 Rating
1
0 Rating
YA
2 months ago
Good