Interested in this course?
Find Out More
What do the levels mean?
IT & Electronics Courses
EXCEL 2010 Intermediate
Course Code: 4246
Overview:
In this course, learners will apply visual elements and more advanced formulas and functions to a worksheet to display data in various formats. The target learners for this course are learners who desire to gain the skills necessary to create templates, sort and filter data, import and export data, analyse data, and work with Excel on the web
A selection of the following topics will be covered. Other skills not listed can be requested with sufficient notice.
Customising and Enhancing Workbooks and the Excel Environment
Customise the Excel Environment
Customise Workbooks
Manage Themes
Use Help
Store and Retrieve Files effectively
Open CSV files
Save files in CSV format
Use Built-in Templates
Modify Built-in Templates
Create Templates
Use Formatting Tools effectively
Freeze Panes
Customise formatting (e.g. dates)
Text Wrap
Text Orientation
Merge & Centre Cells
Combine and Link Data across Worksheets
Enter Data into Multiple Cells across Worksheets
Concatenation
Hyperlinks
Consolidate
Use Data Analysis Tools
Sort or Filter Worksheet or Table Data
Automatic Subtotals
Summarise Data
Calculate Data with Advanced Formulas
Calculate Data across Worksheets
Use Specialised Functions
Use Absolute and Mixed Cell References
Conditional Formatting
Insert Graphic Objects
Insert and Modify Pictures and ClipArt
Illustrate Workflow Using SmartArt Graphics
Present Data Using Charts
Create Charts
Modify Charts
Format Charts
Printing Options
Fit to Page
Set/Clear Print Area
Set / Clear gridlines
Set Paper Size
Understanding and Sorting Errors
Common Cell Errors
Trace Errors
Entry Requirements:
Excel beginner skills including the ability to: create and edit basic Excel 2010 workbooks, create basic formulas, use basic functions, copy formulas and functions, sort data, add borders and shading to cells, apply basic text, number, currency and date formats, insert and delete rows and columns.
Career Options:
ITQ Level 2 Award or Certificate, nationally recognised IT qualifications which can be tailored to individual and business needs.
Course Starting: Wednesday 12 Sep 2012 - Part Time - Tonbridge
Disclaimer:
This course information sheet describes courses and services offered by K College. Although great care has been taken in its compilation, it is for guidance only and does not form part of a contract with any individual and/or organisation. K College will take reasonable steps to provide courses and services in the manner described but reserves the right to modify or withdraw any courses or services. Some courses may not run if the College receives an insufficient number of enrolments. Please note that the fee and session information given above only applies to the academic year specified and is subject to change for subsequent years.
Errors and Omissions Excluded.
This course information sheet describes courses and services offered by K College. Although great care has been taken in its compilation, it is for guidance only and does not form part of a contract with any individual and/or organisation. K College will take reasonable steps to provide courses and services in the manner described but reserves the right to modify or withdraw any courses or services. Some courses may not run if the College receives an insufficient number of enrolments. Please note that the fee and session information given above only applies to the academic year specified and is subject to change for subsequent years.
Errors and Omissions Excluded.