Introduction to Microsoft Excel

Microsoft Excel Icon

Gain confidence in Microsoft Excel with our 6-hour introductory course. Perfect for beginners, you'll learn essential functions like data entry, formatting, formulas, and basic data analysis. Explore Excel's interface, create workbooks, and master basic charts. Ideal for students & entry-level pro's

  • Audience

    This course is tailored for beginners who have minimal or no experience using Microsoft Excel. It's ideal for students, entry-level professionals, administrative staff, or anyone looking to acquire foundational skills in spreadsheet creation, data entry, and basic functions within Excel.

    Pe-requisites

    No prior knowledge or experience in Microsoft Excel is required. Participants should have a basic understanding of computer operations and familiarity with the Windows operating systems.

    Duration

    6 hours

    Delivery Method

    Face to face or Virtual
  • Course Objectives

    The "Introduction to Microsoft Excel" course is designed to provide participants with a foundational understanding of Excel, one of the most widely used spreadsheet software.

    Course Content

    • Introduction to Excel
    • Overview of Microsoft Excel and its significance
    • Navigating the Excel interface: Ribbons, Worksheets, and Cells
    • Creating a new workbook and saving files
    • Basic text entry and editing
    • Basic Data Entry and Formatting
    • Entering data and numbers in Excel
    • Text formatting: font, size, style
    • Cell formatting: alignment, borders, and shading
    • Autofill and Flash Fill for repetitive data
    • Working with Rows, Columns, and Sheets
    • Adding, deleting, and resizing rows and columns
    • Renaming and rearranging worksheets
    • Using Excel’s Zoom and Split features for better view
    • Basic Formulas and Functions
    • Introduction to Excel formulas and functions
    • Performing basic calculations: addition, subtraction, multiplication, division
    • Introduction to SUM and AVERAGE functions
    • Relative and absolute cell referencing
    • Basic Charts and Graphs
    • Creating simple charts: bar, column, and pie charts
    • Formatting and customizing charts
    • Adding chart elements: titles, labels, and legends
    • Changing chart types to visualize data