0043 - Microsoft Excel Level I

Course Description

Excel Level 1 Overview:

This introductory course is designed to equip you with the fundamental skills needed to work efficiently in Microsoft Excel. Whether you're managing data, creating simple spreadsheets, or performing basic calculations, this course will give you the confidence to use Excel in your everyday tasks. By the end of the course, you'll be comfortable navigating the Excel interface, using basic formulas, and creating clean, organized spreadsheets.

Course Content:

• Introduction to Excel

  • Navigating the Excel interface

  • Understanding workbooks, worksheets, and cells

  • Basic customization of the Excel environment

• Data Entry & Formatting

  • Efficiently entering data into cells

  • Basic text, number, and date formatting

  • Adjusting column widths and row heights

• Basic Excel Functions & Formulas

  • Using SUM, AVERAGE, MIN, MAX, and basic calculations

  • Introduction to the IF function for simple logic

  • Understanding relative and absolute references

• Working with Data

  • Sorting and filtering data for easy analysis

  • Using Excel tables to manage data efficiently

  • Applying basic data validation

• Basic Charting & Data Visualization

  • Creating simple charts (bar, line, pie)

  • Customizing charts for clarity and impact

  • Using Excel’s built-in styles to format charts

• Cell Referencing & Formulas

  • Understanding cell references and creating formulas

  • Introduction to basic text functions (e.g., CONCATENATE)

• Saving, Printing & Sharing

  • Saving workbooks in different formats

  • Printing and page setup for professional reports

  • Sharing workbooks via email and collaboration tools