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
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