           |
Excel 2003 CoursesMicrosoft Excel 2003 for Accounting: AdvancedA One-Day Training Course
Your 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 Advanced training course focuses on more advanced functions, list management, scenarios and what if analysis, as well as productivity tools such as PivotTables and Macros. It is entirely 'hands on', so those attending will get practice in creating and modifying actual spreadsheets. Who Should AttendAnyone with a basic understanding of Excel in an accounting environment who wishes to improve their productivity and quality of work. Note : A working knowledge of using Microsoft Excel is required. Course OutlineIntroduction and Course OverviewWorking with Functions and Formulas
Using Functions in Excel:
• Inserting Functions
• Using Functions And Autofill To Perform Difficult Calculations
• Using The IF Function
• Working With Nested Functions
Working with Names and Ranges: • What Are Range Names? • Defining And Using Range Names • Selecting Nonadjacent Ranges • Auto Calculate Working with Array Formulas: • What Are Array Formulas • Using Basic Array Formulas • Using Functions with Array Formulas • Using the IF Function in Array Formulas Introduction to Financial Functions: • PMT Function • FV Function Using Functions in Excel: • Inserting Functions • Using Functions And Autofill To Perform Difficult Calculations • Using The IF Function • Working With Nested Functions orking with Names and Ranges: orking with Names and Ranges: • What Are Range Names? • Defining And Using Range Names • Selecting Nonadjacent Ranges • Auto Calculate orking with Array Formulas: • What Are Array Formulas • Using Basic Array Formulas • Using Functions with Array Formulas • Using the IF Function in Array Formulas troduction to Financial Functions: • PMT Function • FV Function Managing Lists
Working with Lists:
• What Is A List?
• Creating Lists
• Modifying Lists
• What Is The Total Row?
Working with Records and Fields: • What Are Records And Fields? • Adding Fields By Inserting Columns • Adding Records By Inserting Rows • Adding Records With A Data Form • Finding And Deleting Records Working with Lists and Filters: • Sorting A List • What Is An Autofilter • Custom Autofilters • Using An Advanced Filter • Copying Filtered Records Using Excel as a Database: • Filtering With Wild Card Characters • Validating Your Data • What Are Database Functions? • What Are Lookup Functions? Working with Lists: • What Is A List? • Creating Lists • Modifying Lists • What Is The Total Row? orking with Records and Fields: • What Are Records And Fields? • Adding Fields By Inserting Columns • Adding Records By Inserting Rows • Adding Records With A Data Form • Finding And Deleting Records Working with Lists and Filters: • Sorting A List • What Is An Autofilter • Custom Autofilters • Using An Advanced Filter • Copying Filtered Records sing Excel as a Database: • Filtering With Wild Card Characters • Validating Your Data • What Are Database Functions? • What Are Lookup Functions? Grouping Data and Using PivotTables
Outlining and Grouping your Data:
• Using Automatic Outlining
• Displaying And Collapsing Levels
• Grouping Data Manually
• Creating Subtotals
PivotTables: • PivotTables • Creating A PivotTable Frame • Specifying Data in a PivotTable • Rearranging PivotTable Data More on PivotTables: • Modifying PivotTable Calculations • Formatting A PivotTable • Refreshing A PivotTable • Charting A PivotTable • Creating a PivotTable based on Data from an External Database Outlining and Grouping your Data: • Using Automatic Outlining • Displaying And Collapsing Levels • Grouping Data Manually • Creating Subtotals PivotTables: • PivotTables • Creating A PivotTable Frame • Specifying Data in a PivotTable • Rearranging PivotTable Data More on PivotTables: • Modifying PivotTable Calculations • Formatting A PivotTable • Refreshing A PivotTable • Charting A PivotTable • Creating a PivotTable based on Data from an External Database Scenarios and What If Analysis
Exploring Scenarios:
• What Is A Scenario?
• Creating A Scenario
• Creating a Scenario Summary Report
• Saving Multiple Scenarios
What if Analysis: • Using A One And Two Input Data Table • Using Goal Seek • Using Solver Exploring Scenarios: • What Is A Scenario? • Creating A Scenario • Creating a Scenario Summary Report • Saving Multiple Scenarios What if Analysis: • Using A One And Two Input Data Table • Using Goal Seek • Using Solver Using Simple Macros in Excel
Creating Macros in Excel:
• What Is A Macro?
• Creating A Macro
• Playing A Macro
• Assigning A Shortcut Key To Macro
• Macros, Buttons, And Toolbars
Creating Macros in Excel: • What Is A Macro? • Creating A Macro • Playing A Macro • Assigning A Shortcut Key To Macro • Macros, Buttons, And Toolbars More Information
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 |
Why Activia for Excel 2003 Courses ?
Excel 2003 Courses in London, Birmingham, Manchester, Leeds, Bristol and the South East
Activia should be your first choice for courses in Excel 2003 and 2007 in the UK. We provide you with a full range of classes for Advanced MS Excel 2003 Training Course.
If you are looking for Microsoft Excel 2003 classes, you will find that Activia offers a level of service that is unrivalled in the market, with quality, flexible 1 day Excel 2003 Courses at fiercely competitive prices.
Advanced MS Excel 2003 Training Course
If your requirement is Microsoft Excel 2003 spreadsheet software courses, we can provide you with training courses from introduction to advanced level at highly competitive prices. You will find that for learning 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.
Courses in London, the Midlands, Manchester, Bristol, Berkshire, Buckinghamshire, Hampshire, Surrey and UK wide
We provide Advanced MS Excel 2003 Training Course courses all over the UK, with modern, fully equipped training centres in the following locations:
Excel 2003 Courses in the City of London
Serving the City in Liverpool Street and Fleet Street, and the West End of London, as well as areas like Leytonstone, Walthamstow, Barking, Chingford and Ilford.
Excel 2003 Courses in West London
Serving West London, as well as areas like Brentford, Kew, Watford, Richmond and Hounslow.Advanced MS Excel 2003 Training Course in the centre of Bristol
Serving South West England, covering Bristol, Avon and Bath and Radstock in Somerset as well as Clevedon and Chepstow.
Excel 2003 Courses in Birmingham City Centre
Serving Warwickshire and the Midlands, covering Birmingham, Walsall and Dudley as well as Wolverhampton, Solihull and Tamworth.
Advanced MS Excel 2003 Training Course in Leeds
Serving Yorkshire and the North of England, covering Leeds, Bradford and Harrogate as well as Halifax, Wakefield and Castleford.
Excel 2003 Courses in Manchester
Serving Lancashire and the North West, covering Manchester, Salford, Stockport and Oldham as well as Bolton, Rochdale, Wigan, Warrington and Macclesfield.
Excel 2003 Courses in Reading
Serving Berkshire and the Thames Valley, covering Reading, Theale and Newbury as well as Henley and South Oxfordshire.
Excel 2003 Courses in Bracknell
Serving Berkshire and the Thames Valley, covering Bracknell, Wokingham and Ascot as well as Crowthrone, Camberley and Woking.
Advanced MS Excel 2003 Training Course in Slough
Serving Berkshire and the Thames Valley, covering Slough, Windsor and Maidenhead as well as High Wycombe, Uxbridge and Watford.
Advanced MS Excel 2003 Training Course in Milton Keynes
Serving Buckinghamshire, covering Milton Keynes, Aylesbury and Buckingham, as well as Luton, Bedford, Stevenage, St Albans and Welwyn Garden City.
Excel 2003 Courses in Basingstoke
Serving Hampshire, covering Basingstoke, as well as Farnham, Farnborough and Aldershot to the east, and Newbury, Andover and Winchester to the west.
Our experienced, high quality trainers will deliver your training to the highest standards and with the maximum effect.
In House Excel 2003 Courses across the UK
For in house delivery of Advanced MS Excel 2003 Training Course, we have an established national UK network of trainers, as well as thirteen centres in London, Birmingham, Manchester, Leeds, Bristol, Slough, Reading, Bracknell and Milton Keynes. So you can be sure that your courses in Excel 2003 and 2007 will be delivered in a quality assured and cost effective manner. For in-house Microsoft Excel 2003 spreadsheet software courses, you need look no further than Activia.
|
Training centres in London Birmingham Bristol Berkshire Buckinghamshire Manchester Leeds
Why Activia? |