Interested in this course?
Find Out More
What do the levels mean?
IT & Electronics Courses
Excel for Business
Course Code: 4044
Duration : 2 daysThis programme is offered over two days.
Day 1
Designed for the business user who is comfortable with the Excel basics but would like to know more and ask the expert for hints and tips to improve their Excel and Spreadsheet Skills. Taught using Excel 2003 or 2007. Students are encouraged to bring any examples of sheets they are working on with them on a USB Memory Stick to allow them to work on their own material during the Course.
Course Content:
- Creating new workbooks
- Using multiple MS Excel worksheets - linking spreadsheets tabs and workbooks together
- Entering text and values
- Linking Excel tables in a Word document
- The undo and redo command
- Using named ranges
- Moving and copying cells
- Data series
- Entering a formula (sum, sumif, count, counta, countif to name but a few)
- Absolute and relative cell referencing
- Cell Formatting & Conditional Formatting
- Protecting Sheets
- Printing
Learn how Excel can interact with other applications including Word for mail merging and Sage for data sharing.
Course Content:
- Handling large MS Excel spreadsheets
- Custom views - Split screen and freeze panes
- Tracking changes
- Creating and editing charts
- Sorting a list
- Auto filter and advanced filtering
- Automatic subtotalling
- Creating a pivot table
- The auditing tools
- Validation of data
- Goal seeking from formulae and charts
- Solving from a complex formula
- Array formulae
- Macros
- Hiding workbooks and worksheets
Entry Requirements:
Prior experience with any spreadsheet softwareCareer Options:
Other Related Courses- Excel For Business - Stage 2
- Sage 50 Reporting inc Excel
- Sage 50 Accounts "We know it can do the numbers, but what more can it do to help my business?"
- Sage 50 Payroll "It calculates the payroll, but what more does it do to help my business?"
- Sage 50 Payroll Year End
Course Starting: Wednesday 13 Jun 2012 - Part Time - Dover
Course Starting: Wednesday 18 Jul 2012 - Part Time - Tonbridge
Course Starting: Thursday 06 Sep 2012 - Part Time - Ashford
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.