Introduction to Excel Spreadsheets Course ( 2 Courses ) See Dates/Register  

  • Introduction to Spreadsheets

    Introduction to Spreadsheets (Microsoft Excel)

    This course is designed for new users of Spreadsheets / Excel and those who have been Self Taught. We cover all areas of creating a spreadsheet including entering Excel formulas. Can be used in preparation for MOS Excel Core Exam or ECDL Excel Test.

  • Excel Basics

    • Introducing the Ribbons
    • Workbooks, Worksheets, Rows, Columns, Cells
    • Selection Techniques & Mouse Shapes
    • Saving, File Types, Compatability
    • The File Tab
    • Page Layout View
    • Getting Help
    • Inserting Files

    Entering, Selecting & Editing Data

    • Entering, Editing, Deleting Data in Cells
    • Using the Fill Handle
    • Inserting/Deleting Rows, Columns & Cells
    • Insert/Deleting/Moving/ Renaming/Copying Sheets
    • Creating Custom Lists

    Creating Formulas and Functions

    • Creating/Editing/Copying Formulas
    • Using AutoSum
    • Common Basic Functions
    • Using the Formula Tab
    • Relative and Absolute Cell References

    Formatting Cells, Rows, Columns & Sheets

    • Formatting Cells Options
    • Applying Borders and Shading
    • Changing Column Widths
    • Changing Row Heights
    • Clearing Formats
    • Using Format Painter

    Charts, Graphs and Data Sort

    • Create Simple Charts
    • Editing Charts
    • Formatting Charts
    • Sorting Data
    • Auto Filter

    Printing

    • Print Preview & Page Orientation
    • Adding Headers and Footers
    • Printing a Selection & Setting a Print Area
    • Adjusting Page Breaks using Page Break Preview
    • Changing Margins
    • Centre on Page
  • For those who need excel skills for their work or want to have an edge over others. Learn about creating & editing spreadsheets entering data for records.  Useful for jobs in Human Resources, Accounting, Finance or Research and Development.
  • You must have good basic knowledge of a computer and good working Knowledge of Word Processing. 

Introduction to Excel Aug

This course is currently run online through Zoom with Tutor
1 Day Course from 10am to 5pm / 2 half days / or 1 hrly sessions
Individual and Small group size only
Course Date 17-08-2021 10:00 am
Individual Price €180.00
€180.00 7


Introduction to Excel 31 Aug

This course is currently run online through Zoom with Tutor
1 Day Course from 10am to 5pm / 2 half days / or 1 hrly sessions
Individual and Small group size only
Course Date 31-08-2021 10:00 am
Individual Price €180.00
€180.00 8

Email:
European Computer Driving Licence, ECDL
Irish Computer Society
Microsoft Office Specialist Certification
Quality and Qualifications Ireland (QQI)