Excel Beginning

STUDENTS ENROLLED
    This course provides beginner concepts required to produce basic spreadsheets. Participants will learn how to create, save, open and close files; enter data; as well as edit using insert, delete, move and copy functions. This course presents simple formula creation concepts including the use of built-in functions. Relative formulas will also be covered. On completion of this course students will … READ MORE

    This course provides beginner concepts required to produce basic spreadsheets. Participants will learn how to create, save, open and close files; enter data; as well as edit using insert, delete, move and copy functions. This course presents simple formula creation concepts including the use of built-in functions. Relative formulas will also be covered. On completion of this course students will be familiar with formatting features such as: row heights, column width, alignment, merge cells and number styles. Participants will also work with margins, headers and footers to enhance page layout in different views to prepare for printing.

    Objectives :
    Understanding spreadsheet concepts
    Creating & using Excel spreadsheets
    Editing & formatting data & sheets
    Understanding the role of databases & charts in Microsoft Excel
    Dealing with worksheets & workbooks
    Printing data from Excel

    Course Outline

    Basic Skills

    • Introducing Microsoft Excel
    • Dealing with Excel Files
    • Editing Data in Worksheets
    • Identifying Data Types
    • Copying, Moving, Finding & Replacing Data
    • Formatting Data & Cells
    • Working with Styles

    Functions

    • Functions Overview
    • Relative & Absolute References
    • Function Categories
    • Statistical & Logical Functions
    • If Conditional Function
    • Text Functions

    Databases & Charts

    • Understanding Data List Concepts
    • Restricting & Sorting Data
    • Editing Data through Forms
    • Performing Subtotals
    • Excel & Database Programs
    • Creating Charts
    • Identifying Chart Components
    • Formatting Chart Axis & Data
    • Data Series & Trend Lines

    Workbooks

    • Navigating & Formatting Worksheets
    • Worksheet References & Hyperlinks
    • Freezing & Splitting Windows
    • Arranging & Hiding Windows
    • Preparing Worksheets for Printing
    • Previewing & Printing Data
    LESS

    Course Reviews

    No Reviews found for this course.

    TAKE THIS COURSE
    • course Hours: 12
    • course price: EGP
    • Course Dates: