Excel in Limerick Chamber-Beginners-12th Nov 2024

The class is designed for those who have little or no knowledge of Excel or who have only been working on inputting data into a standard Excel spreadsheet.

Course Outline
. A first look at the Excel environment.
• Understanding the difference between a
spreadsheet and a database within Excel.
• Entering data into Excel.
• Manipulating Rows and Columns of data.
• Changing data, copying or moving data
within a spreadsheet or between
spreadsheets.
• Formatting a spreadsheet, including text
formatting, cell formatting, borders,
alignment and font.
• Creating basic formulas using
mathematical symbols.
• Understanding and using the AutoSUM
functions.
• Understanding the difference between
Relative and Absolute cell referencing.
• Page layout and preparing data for
printing.
• Creating Headers and Footers within
Excel.
• Freezing rows and columns.
• Creating basic charts from data.
• Saving a spreadsheet in various formats.
• Creating Pie, Column, Line, and Mixed
charts.
• Quick sorting in ascending and descending
order.
• Multilevel sorting by more than one field.
• Retrieving records using autofilter, custom
and advanced filters.