![]() ![]() |
Excel 2003 Training CoursesMicrosoft Excel 2003 for Accounting: IntroductionA One-Day Training CourseYour training is easier with Activia because we have:
|
Course ContentCourse AimsMicrosoft Excel is probably the most useful office tool available to accounting functions for the simple analysis and manipulation of data. This Introduction training course focuses on the basic functionality of Excel for accounting, including formatting and structuring worksheets, using workbooks, and an introduction to functions and formulas. It is entirely 'hands on', so those attending will get practice in creating and modifying actual spreadsheets. Who Should AttendAnyone who wishes to start using Excel in an accounting environment. Note: A working knowledge of using PCs in the Microsoft Windows environment is required, and a familiarity with the Microsoft Excel 2003 interface would also be an advantage. Course OutlineIntroduction and Course OverviewExcel Fundamentals
Beginning Excel:
• The Standard Toolbar
• The Formatting Toolbar
• Working with Excel Menus
• Exploring Task Panes
• Excel Short-cut Keys
Explore your Workbook: • Switching Worksheets • The Active Cell • Selecting Cells • Exploring a Worksheet • The Zoom Feature Working with Excel: • Columns, Rows, Cells, and Ranges • Creating Worksheet Labels • Entering and Deleting Data • Printing your Worksheet Moving your Data: • Dragging and Dropping Cells • How to Cut, Copy, and Paste Cells • How to Cut, Copy, and Paste Multiple Cells and Items • How to Use Paste Special • How to Insert and Delete Cells, Rows, and Columns • Using Undo, Redo, and Repeat Modifying Cells and Data: • Changing the Size of Rows or Columns • Working with the Formatting Toolbar • Adjusting Cell Alignment • Rotating Text • Creating Custom Number and Date Formats Formatting, Toolbars and Charts
Basic Excel Features:
• AutoFill
• What is AutoSum?
• AutoComplete
• Working with Basic Formulas
Cell Formatting: • Conditional Formatting • The Format Painter • AutoFormat • Cell Merging and AutoFit • Find and Replace Formatting Modifying Excel’s Toolbars: • Hiding Toolbars • Showing Toolbars • Moving Toolbars • Customizing Toolbars Working with Charts: • Creating a Chart • Formatting a Chart • Manipulating a Chart • Enhancing a Chart with Drawing Tools • Enhancing your Chart with Titles and Tables Working with Charts and Data: • Changing the Type of Chart • Changing the Source Data • Creating 3-D Charts • Working with the Chart Axes and Data Series • Making Custom Charts Using Workbooks
Organizing your Workbook:
• Inserting and Removing Worksheets
• Renaming, Moving, and Colour-Coding Worksheets
• How to Split and Freeze a Window
• Using Multiple Workbooks and Windows
• Using a Watch Window
• Creating a Custom View
Printing a Workbook: • Choosing a Print Area • Setting up Page Breaks • Choosing Paper Size and Changing Print Scale • Adding Print Titles and Gridlines Workbooks, Worksheets and Templates: • Linking Workbooks • Consolidating Workbooks • Combining Worksheets • Protecting Worksheets • Using Templates Introduction to Functions and Formulas
Using Formulas in Excel:
• Understanding Relative and Absolute Cell References
• Practice – Relative Cell References
• Practice – Absolute Cell References
• Relative and Absolute Practice
Using Formulas in Excel: • Using Formulas With Multiple Cell References • Using Formulas across Worksheets • Working across Worksheets Practice Using Formulas in Excel: • The Formula Auditing Bar • Fixing Formula Errors • Displaying And Printing Formulas xploring Excel Functions: • What Are Functions? • Finding the Right Function • Some Useful And Simple Functions • Working across Worksheets Practice Using Formulas in Excel: • The Formula Auditing Bar • Fixing Formula Errors • Displaying And Printing Formulas xploring Excel Functions: • What Are Functions? • Finding the Right Function • Some Useful And Simple Functions More Information
Related CoursesWe also run the following related courses which may be of interest to you.
Click for full details of content, prices and dates: Quick Course FinderWith truly hundreds of training courses to choose from, we have a Quick Course Finder that will help you to find the subject area and course you need.Just click on any heading (in black) or section (in blue) to go straight to where you need to be. Click to use our Quick Course Finder Contact Us
Activia Training
Head Office: Regus House, 268 Bath Road Slough, SL1 4DX Sales: 0845 230 6150 Service: 0845 230 6159 Accounts: 0845 230 6157 |
Activia should be your first choice for training for Excel 2003 in the UK. We provide you with a full range of classes for Introduction to Microsoft Excel 2003 Training.
If you are looking for courses for MS Excel 2003, you will find that Activia offers a level of service that is unrivalled in the market, with quality, flexible 1 day Excel 2003 Training Courses at fiercely competitive prices.
If your requirement is training for Microsoft Excel 2003, we can provide you with training courses from introduction to advanced level at highly competitive prices. You will find that for classes for Microsoft Excel 2003, Activia will provide more tailored, flexible and focused solutions, and this enables you to get the most from your budget using the minimum of resources.
We provide Introduction to Microsoft Excel 2003 Training courses all over the UK, with modern, fully equipped training centres in the following locations:
Serving the City in Bank and Aldgate, and Canary Wharf from our London Bridge (SE1) centre.
Across West and South West London, in Hammersmith, Baker Street and London Victoria.
Serving South West England, covering Bristol, Avon and Bath and Radstock in Somerset as well as Clevedon and Chepstow.
Serving Warwickshire and the Midlands, covering Birmingham, Walsall and Dudley as well as Wolverhampton, Solihull and Tamworth.
Serving Yorkshire and the North of England, covering Leeds, Bradford and Harrogate as well as Halifax, Wakefield and Castleford.
Serving Lancashire and the North West, covering Manchester, Salford, Stockport and Oldham as well as Bolton, Rochdale, Wigan, Warrington and Macclesfield.
Serving Berkshire and the Thames Valley, covering Reading, Theale and Newbury as well as Henley and South Oxfordshire.
Serving Berkshire and the Thames Valley, covering Bracknell, Wokingham and Ascot as well as Crowthrone, Camberley and Woking.
Serving Berkshire and the Thames Valley, covering Slough, Windsor and Maidenhead as well as High Wycombe, Uxbridge and Watford.
Serving Buckinghamshire, covering Milton Keynes, Aylesbury and Buckingham, as well as Luton, Bedford, Stevenage, St Albans and Welwyn Garden City.
Serving Tyneside, also Sunderland and Gateshead, as well as North Shields and South Shields, and Whitley Bay.
Our experienced, high quality trainers will deliver your training to the highest standards and with the maximum effect.
For in house delivery of Introduction to Microsoft Excel 2003 Training, we have an established national UK network of trainers, as well as fifteen centres in London, Birmingham, Manchester, Leeds, Newcastle, Bristol, Slough, Reading, Bracknell and Milton Keynes. So you can be sure that your training for Excel 2003 will be delivered in a quality assured and cost effective manner. For in-house training for Microsoft Excel 2003, you need look no further than Activia.
|
Training centres in London Birmingham Bristol Berkshire Buckinghamshire Manchester Leeds Newcastle
Why Activia? |
|||||