Microsoft Excel

Whether you’re a beginner or aiming for mastery, this certificate course offers valuable insights into Excel’s capabilities.

Duration: 50 hours over 6 weeks.

Course content: will be decided on the basis of your Level of familiarity about the Excel commands:

• Level 1 – Beginner - Admission Started

• Level 2 – General user – Admission Started

• Level 3 – Professional (advanced) user – Admission Started

Software: The latest Microsoft 365 Business, Home, and Professional; OS Platform: Microsoft Windows 10 / 11.

Content:

• Interface and Foundational Features

• Data Organization Techniques

• Data Visualization

• Advanced Data Manipulation

• Pivot Tables and Charts

• Design Dynamic Dashboards

• Certificate Recognized by ADACALL

• Cell Formatting, & Worksheet management

• Styling, Protecting, Printing

• References and Data Management

• Advanced Functions

• Date-Time Manipulation

• Lookup Techniques

• Crafting Compelling Charts

• Dynamic Dashboards

• Saving, Sharing & Teaming.

Here are some essential areas to focus on:

Editing & Shortcuts:

• Create a new workbook, edit values, and use keyboard shortcuts (e.g., Ctrl + C for copy, Ctrl + V for paste, Ctrl + S for save).

• Familiarize yourself with the Find & Select feature to locate specific cells or values.

Formatting:

• Learn how to format cells, fonts, and numbers.

• Explore features like bold, italics, and text alignment.

Functions:

• Understand basic functions (e.g., SUM, AVERAGE, COUNT).

• Explore more advanced functions like VLOOKUP and IF statements.

Tables:

• Create tables to organize data efficiently.

• Use filters and sorting options.

Pivot Tables:

• Master pivot tables for data analysis and summarization.

• Learn to create calculated fields and custom calculations1.

Charting:

• Create various types of charts (e.g., bar, line, pie).

• Customize chart elements and labels.

Import & Clean Data:

• Import data from external sources (e.g., CSV files, databases).

• Clean and transform data using features like Text to Columns and 

• Remove Duplicates.

Analyzing Data:

• Explore data analysis tools such as Goal Seek, Solver, and Scenario Manager.

• Understand how to create scenarios and perform sensitivity analysis.

Sharing & Protection:

• Learn to protect sheets and workbooks with passwords.

• Share files securely via email or cloud storage.

Page Layout & Setup:

• Adjust page margins, headers, and footers.

• Set print areas and page breaks.

Customizing Excel:

• Customize the ribbon, quick access toolbar, and keyboard shortcuts.

• Explore Excel options and settings.

Templates:

• Use built-in templates or create your own.

• Templates can save time when starting new projects.

VBA (Visual Basic for Applications):

• If you’re interested in automation, learn VBA for creating macros and custom functions (Optional: Not included in this program)

Developer Controls:

• Understand form controls (e.g., buttons, checkboxes) for interactive spreadsheets. (Optional: Not included in this program)

Add-Ins:

• Explore Excel add-ins for additional functionality (e.g., data analysis, financial modeling). 

This course will start with the basics and gradually explore more advanced features. Excel proficiency can significantly boost your productivity and analytical capabilities.