Excel for Business

K College

We are no longer receiving applications for this opportunity, but there are plenty more open so please continue searching.

  • Level 1
  • Business & Admin
  • Nationwide

What does the course involve?: This 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 Day 2 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 software Career 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
Length: Part Time
Start date: Wednesday, October 26, 2011

Sign-up or log in to apply

Cookies: By continuing to browse the site you are agreeing to our use of cookies. For more details see our cookie policy.