Instructor Led Advanced Functions Training
Advanced Functions Training Provider? - Tell us about your Training!
Please select the location nearest to you:
United Kingdom
Canada
New Zealand
United States
Croatia
Singapore
South Africa
India
Poland
From Wise Owl Business Solutions Ltd
Advanced Excel 2007



If you have been using Microsoft Excel for a while now, maybe it is time to move on a bit. This two-day course shows how you can use Excel to manage a database, create advanced charts, use some of the advanced functions in Excel and much more besides! Why not spend two days finding out just what Excel can do?
more...
Advanced Excel 2007
Microsoft Excel 2003 Advanced



If you've been using Microsoft Excel for a while now, maybe it's time to move on a bit. This two-day course shows how you can use Excel to manage a database, create advanced charts, use some of the advanced functions in Excel and much more besides! Invest two days of your time to make yourself permanently more efficient in Excel, by finding out just what it can do.
more...
From Mullan Training
Advanced MS Access


... action queries
- use of Expression Builder
- a range of advanced functions
PREREQUISITES
A working knowledge of Access or our Introduction to MS Access course will allow sufficient knowledge to attend our Advanced MS Access course.
BENEFITS
At the end of this course you will have a complete understanding of the higher functions of Access.
You will:
- Learn to automate functions by
more...
Advanced MS Word - 1 Day

...functions of Word.
You will be able to perform the most advanced functions, including merging your documents with databases for mail-shots and producing well-defined forms.
You will learn how to work with extremely large documents and how to use macros to speed through any repetitive functions. You will be able to redesign your Word environment to make it truly user friendly.
For a course
more...
From WWP Training Ltd
Microsoft Excel 2003 Level 4
Aims
This course is aimed at people who want to expand their knowledge into the more specialised analytical functionality and built-in automation offered by Microsoft Excel.
Prerequisites
Students who wish to attend this course must have a very good knowledge of Excel and be competent at working with advanced functions (e. g. Logical & LookUp) and have some basic knowledge of Excela s
more...
Microsoft Excel 2007 Level 4
Aims
This course is aimed at people who want to expand their knowledge into the more specialised analytical functionality and built-in automation offered by Microsoft Excel.
Prerequisites
Students who wish to attend this course must have a very good knowledge of Excel and be competent at working with advanced functions (e. g. Logical & LookUp) and have some basic knowledge of Excela s
more...
From Last Minute Training
Simply Accounting 2010 Level 2
This is a continuation of basic features for daily accounting tasks using Simply & will introduce some of the more advanced functions. Students will look at how to create files, deal with more advanced tasks for receivables, payables, inventory & payroll
more...
Simply Accounting 2008 Level 2 - presidio
This is a continuation of basic features for daily accounting tasks using Simply & will introduce some of the more advanced functions. Students will look at how to create files, deal with more advanced tasks for receivables, payables, inventory & payroll
more...
Simply Accounting Intermediate-2 Days
Location: Toronto Date: 2007-04-23
List Price: $550 Offered Price: $385.00
Seats Available: 5
The main objective of this course is to introduce some of the more advanced functions and capabilities of Simply Accounting.
more...
MS Excel 2003 Formulas for Statistical Analysis

Location: City of Mississauga Date: 2007-04-13
List Price: $245 Offered Price: $171.00
Seats Available: 2
This class is an overview of calculations using selected advanced functions drawn from the statistical, database, and mathematic functions in Excel's core collections and add-in libraries. Participants will also be introduced to creating user-defined functions with Visual Basic in
more...
Microsoft Excel 2003 Level 4 - Bilingual

...1
Module 0: Working with Data Series
Module 1: Using Advanced Functions
Module 2: Using Scenarios and Goal Seeking
Module 3: Using Data Tables
Module 4: Using Auditing Tools
Module 5: Consolidating Worksheets
Module 6: Solving Problems
Module 7: Working With Views
Module 8: Using Macros
Module 9: Recording Macros
Module 10: Editing Macros
Module 11: Using Custom Toolbars And
more...
MS Outlook Training Course in Ottawa - Advanced

This Course is designed for participants who want more advanced functions of Outlook.
more...
Microsoft Excel XP 2003 Level 3
Location: Vancouver Date: 2008-03-18
List Price: $229 Offered Price: $160.00
Seats Available: 2
After you complete this course you will be able to do the following:
* Create and modify Pivot Tables
* Create and modify macros
* Create and modify outlines
* Use advanced functions
* Trace Dependents and Precedents
* Create and modify scenarios
You will also
more...
Microsoft Excel XP 2003 Level 3
Location: Vancouver Date: 2008-04-28
List Price: $229 Offered Price: $160.00
Seats Available: 2
After you complete this course you will be able to do the following:
* Create and modify Pivot Tables
* Create and modify macros
* Create and modify outlines
* Use advanced functions
* Trace Dependents and Precedents
* Create and modify scenarios
For more
more...
Microsoft Excel XP 2003 Level 3
After you complete this course you will be able to do the following:
* Create and modify Pivot Tables
* Create and modify macros
* Create and modify outlines
* Use advanced functions
* Trace Dependents and Precedents
* Create and modify scenarios
more...
Private 1-on-1 Training: Microsoft Access (Intermediate Level)
You ve started using MS Access but you know you can do more. You want to know how to use its more advanced functions. Our private one on one training will target the areas you need help with and teach you what you need to know quickly and effectively.
more...
QuickBooks 2007 Level 2
This courseware is a continuation of basic features for daily accounting tasks using QuickBooks and will introduce some of the more advanced functions and capabilities of QuickBooks. Students will look at how to create company files, and deal with more advanced tasks for receivables, payables, inventory and payroll.
more...
Simply Accounting 2006 Level 2
This course is designed for computer users who are already familiar with accounting with work experience in the basic operations of Simply Accounting by Sage, and/or have completed Simply Accounting by Sage 2006 Level 1. The main objective of this courseware is to introduce some of the more advanced functions and capabilities of Simply Accounting by Sage.
more...
Excel Intermediate - Level 2
This course provides competency in organizing and consolidating data from multiple worksheets, adjusting the screen display, working with advanced functions, using advanced formatting features, using advanced print options, filtering data, using comments, naming worksheet ranges and formulas, creating and modifying charts, protecting data, importing and exporting data, saving worksheets and
more...
Project 2003 Intermediate 2 Days
This course continues from the previous level and demonstrates some of the advanced functions you can use with projects. Topics include: web functions and sharing data, multi-project management, cost management and tracking results, and resource and task management.
more...
Microsoft Excel 2007 Level 3 - On Track
* Create and modify Pivot Tables
* Create and modify macros
* Create and modify outlines
* Use advanced functions
* Trace Dependents and Precedents
* Create and modify scenarios
more...
Microsoft Access- private one on one training
You ve started using MS Access but you know you can do more. You want to know how to use its more advanced functions. Our private one on one training will target the areas you need help with and teach you what you need to know quickly and effectively
more...
Simply Accounting 2008 Level 2
The main objective of this courseware is to introduce some of the more advanced functions and capabilities of Simply Accounting by Sage.
more...
Analysing Statistical Data with Excel
This class is an overview of calculations using selected advanced functions drawn from the statistical, database, & mathematic functions in Excel's core collections & add-in libraries. Participants will be introduced to creating user-defined functions.
more...
Microsoft Access- private one on one training - INTERMEDIATE level
You ve started using MS Access but you know you can do more. You want to know how to use its more advanced functions. Our private one on one training will target the areas you need help with and teach you what you need to know quickly and effectively
more...
MS Outlook 2002-2003 Advanced French- Compuease
This Course is designed for participants who want more advanced functions of Outlook.
Upon completion, participants will be able to customise Outlook, create
rules, templates and use Outlook stationery as well as set up Outlook for Mobile Users.
more...
QuickBooks 2007 Level 2-Presidio
This courseware is a continuation of basic features for daily accounting tasks using QuickBooks and will introduce some of the more advanced functions and capabilities of QuickBooks. Students will look at how to create company files, and deal with more advanced tasks for receivables, payables, inventory and payroll.
more...
Project 20032007 Intermediate 2 Days
This course continues from the previous level and demonstrates some of the advanced functions you can use with projects. Topics include: web functions and sharing data, multi-project management, cost management and tracking results, and task management.
more...
QuickBooks Pro 2007 Level 2 - presidio
This is a continuation of basic features for daily accounting tasks using QuickBooks & will introduce some of the more advanced functions. We'll look at how to create files, deal with more advanced tasks for receivables, payables, inventory & payroll.
more...
QuickBooks Pro 2010 Level 2
This is a continuation of basic features for daily accounting tasks using QuickBooks & will introduce some of the more advanced functions. We'll look at how to create files, deal with more advanced tasks for receivables, payables, inventory & payroll.
more...
From Accountserve Ltd
Beyond the Basics with MYOB Software


...advanced functions such as jobs costing, multiple currencies, time billing and more.
This course is designed to help you apply the more advanced functions of MYOB accounting software in running your business.
On completing this course, you will be able to:
Manage contact logs
Set up recurring transactions
Use advanced search features to find transactions
Customise reports and
more...
From Ascend Training
Adobe Dreamweaver CS4 Level 2 Advanced Website Development and CSS
Hone your skills in Adobe Dreamweaver CS4 with Ascend's Level 2 course, for the seasoned user. Build off your foundation learning advanced functions of CSS, HTML and more. Explore advanced templates and also server side includes at either our Chicago or Deerfield locations.
more...
From NR Computer Learning Center
Microsoft Excel 2010 Intermediate



...to apply basic skill sets along with some intermediate to advanced functions to manage and audit numerical reports. You will work with various functions to perform specific types of calculations, customize charts, work with pictures or shapes in a worksheet, customize formatting for specific types of data, and look at various features for managing different types of lists using a table or
more...
Microsoft Excel 2010 Intermediate (1 Day)








Microsoft ® Office Excel 2010 a Intermediate teaches students how to apply basic skill sets along with some intermediate to advanced functions to manage and audit numerical reports. Students will work with various functions to perform specific types of calculations, customize charts, work with pictures or shapes in a worksheet, customize formatting for specific types of data, and look at
more...
From FormaServe Systems Ltd
RPG IV Intermediate Programming



If you need to advance your RPG skill set and get fully up to date, then this is the course for you.
Learn how to use sub-file programming techniques to enhance your coding and skills.
This RPG IV Programming training course has been designed to take you from the basics of RPG IV programming to being proficient in the advanced functions of RPG IV programming.
This course has been designed
more...
From Aspect Training
Microsoft Project Advanced
Aspect Traininga s Microsoft Project Advanced course is suitable for those with a sound working knowledge of Project and wish to progress to the most complicated functions and features.
Aspect Traininga s Microsoft Project Advanced course will give you a complete understanding of the higher functions of Project. You will be able to perform the most advanced functions of managing a project and
more...
From Affinity IT Training, LLC
Sybase Advanced Transact-SQL for ASE 12 5 1
In this course you will learn
valuable tips, techniques and topics
beyond what was encountered in the Introduction to ASE 12.5.1
course to help solve and prevent common problems.
This course also emphasizes good coding practices,
report formatting, advanced functions, characteristic functions,
applied case logic, and bcp (bulkcopy),
as well as generalized methods for solving specific information
more...
From The Training Experts Ltd
Advanced Microsoft Access
...kills and equipping them with a good understanding of the advanced functions of
Microsoft Access. The course can be delivered either on a 1: 1 or group basis.
Target Group
This course is aimed at people who are already competent users of Microsoft
Access and wish to develop these skills to an advanced level.
Objectives
By the end of this course, delegates will be able to:
more...
Advanced Microsoft Word
...lls and
equipping them with a good understanding of the advanced functions of Microsoft Word.
The course can be delivered either on a 1: 1 or group basis.
Target Group
This course is aimed at people who are already competent users of Microsoft Word and
wish to develop these skills to an advanced level.
Objectives
By the end of this course, delegates will be able to:
more...
Advanced ACT
This one day course is designed to increase delegatesa existing knowledge of ACT!
Target Group
This course is aimed at database administrators or any personnel who currently use
ACT! 2009 and wish to implement the more advanced functions to further aid them in
their job role.
Objectives
By the end of this course delegates will be able to use ACT! fully as a contact
more...
From Cognita
MS Excel Advanced

... this instructor-led live training session you will learn advanced functions and techniques in using Microsoft Excel. If you use this great tool for data operations on everyday basis this course is a must see!
Training agenda:
- Using Excel As a Database
- Filtering Excel data list
- Advanced formulas and functions
- Searching and extracting data
- Conditional calculations
-
more...
From Intellisoft Systems
Advanced Microsoft Excel 2007



...raining
Course Objectives:
Understand how you can apply Advanced functions of Microsoft Excel to improve productivity, enhance spreadsheets with charts & formulas and streamline your work.
Learn how you can automate common tasks, apply advanced analysis techniques to more complex data sets, collaborate on worksheets with others, and leverage on Excela s advanced functionality to
more...
From Knowledge Source Inc
Crystal Reports Advanced Skills
This course will build on the skills learned in Crystal Reports 2008: Basic. Students will learn how to create and use parameter fields, including interactive and cascading parameters. They will learn how to build advanced formulas using variables, advanced functions, and constructs. They will also learn how to create and customize charts and maps, how to apply advanced formatting options to
more...
From Training-2-Go
Excel 2007 - Advanced
Advanced functions
Lookups and data tables
Advanced list management
PivotTables and PivotCharts
Exporting and importing
Analytical options
Macros and custom functions
Conditional formatting and SmartArt
more...
From Computer Training Source, Inc.
Microsoft Excel Intermediate
...ur own template, and learn how to use pivot tables. Using advanced functions in formulas will also be practiced. Our classes are all instructor-led, hands-on learning. Each student has their own computer and is given a student manual with practice files to take home. A free repeat, within six months, is included as well as thirty days of technical support.Class is usually one day from 9am to
more...
From Square 3 Training
Microsoft Project Advanced
...ject and would like to explore and learn some of the more advanced functions.
Topics Include
Revision
Setting up a plan
Viewing the critical path and baseline
Filtering
Customising Tables, Views and Filters
Customise tables
Customise views
Customise filters
Customising Fields
Different types of custom fields
Add custom fields to tables
Create calculated fields
Display as
more...
From NetLearn
Excel 2007 basic - advanced




...Advanced functions
Topic A: Logical functions
A-1: Using the IF function
A-2: Using OR, AND, and NOT as nested functions
A-3: Using nested IF functions
A-4: Using the IFERROR function
Topic B: Math and statistical functions
B-1: Using SUMIF
B-2: Using COUNTIF
B-3: Using AVERAGEIF
B-4: Using SUMIFS, COUNTIFS, and AVERAGEIFS
B-5: Using ROUND
Topic C: Financial functions
C-1:
more...
From Dataspark
ExcelVBMS Access training in Bangalore
...ta subtotaling, Subtotaling, grouping and filtering data, advanced functions in Excel, Lookup functions, Mathematical functions, Text, database functions and Data consolidation, macros writing in Excel/ VBA. Duration: 20hrsa .
2. VBA/ macros programming in Excel.
Introduction to VBA, VBA Procedures, User Forms, Creating Multiple Pivot Table, Modifying Pivot Table, Excela s Events,
more...
From Wintrac Inc.
SAP Human Capital Management (HCM)
The course will give you a broad overview of SAP HCM / HR human resources management in 18 parts. You will learn the basic and advanced functions of the SAP HCM / HR module. The course is divided into Five main topics.
You can get a complete list of other SAP classes at
http://www.wintrac.com/courses/coursesSAP.asp
more...
From AccIT - (PASTEL) Accounting IT Solutions
Pastel Partner Advanced
This course gives you the skills necessary to perform all the advanced task available from a bookkeeper to trial balance function in Pastel Partner.
You work in a training company. You learn all the advanced functions in General Ledger, Customers and Suppliers.
This course takes you through Pastel Bank Manager and Pastel Cash Manager.
more...
From GITS Academy
MS Excel Advacned training Bangalore
...ta subtotaling, Subtotaling, grouping and filtering data, advanced functions in Excel, Lookup functions, Mathematical functions, Text, database functions and Data consolidation, macros writing in Excel/ VBA. Duration: 22hrsa .
2. VBA/ macros programming in Excel.
Introduction to VBA, VBA Procedures, User Forms, Creating Multiple Pivot Table, Modifying Pivot Table, Excela s Events,
more...
From Compendium EC
301 FortiGate Multi-Threat Security Systems II - Secured Network Deployment and Virtual Private Networks
Upon completion of this course students will have the comprehensive knowledge and lab experience required to implement a variety of security services in medium to large enterprise networks using FortiGate devices. Through a series of practical hands on labs, students will have the opportunity to configure advanced functions such as routing, dual Internet connections, site-to-site and dial-up IPSec
more...
From Wintrac Inc.
Corel WordPerfect X4- Level 2
In the first course in this series, Corel ® WordPerfect ® X4: Level 1, you gained an understanding of the basic functions available to create a range of simple, standardized documents. You may now be interested in gaining greater proficiency with the application, and to personalize it to suit your work style. In this course, you will explore some advanced functions available in Corel ®
more...
Corel WordPerfect X4 -Level 2
In the first course in this series, Corel ® WordPerfect ® X4: Level 1, you gained an understanding of the basic functions available to create a range of simple, standardized documents. You may now be interested in gaining greater proficiency with the application, and to personalize it to suit your work style. In this course, you will explore some advanced functions available in Corel ®
more...
