Spreadsheets Introduction to MS Excel
Details
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.
Outline
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
Pery Square Business College provide training for companies, individuals and groups. We run scheduled training courses from our premises in Pery Square and also offer onsite training tailored to the needs of any organisation. Pery Square Business College have over 20 years industry experience.
We cater for all ages and skill levels - from Absolute Beginners to Business Professionals and Trainers.
Our Tutors are all highly qualified and class sizes are kept small.
We cater for Business Training, both in-house at our training rooms or on-site at the company's offices.
Specially customised training affords our Business Clients the assurance of compliance within their I.T. and customer service systems.
Our Recruitment Agency links up with many organisations in the Limerick city and Mid-West Region offering a discreet and confidential service for both temporary and permanent placements to the private and public sectors. All candidates are screened by experienced consultants prior to introduction, in order to match the most suitable candidate to our customer requirements.