Instructor Led Advanced Formulas Training

Microsoft Excel 2007 Intermediate ...dsheets with templates, charts and graphics. You will use advanced formulas to display data in various formats, giving your documents a more professional look. This would be run as a private course. We can run private courses at your offices, and supply the laptops and projector. Training materials and 3 months post training support are included the price. Our rates are per day and  more...

Microsoft Excel 2010 Level 2 ...mpletion of this course students will be able to: Use advanced formulas Organise worksheet and table data using various techniques Create and modify charts Analyse data using PivotTables, Slicers and PivotCharts Insert and modify graphic objects in a worksheet Customise and enhance workbooks and the Microsoft Office Excel environment Target Audience This course is for  more...

Microsoft Excel 2007 Level 2 ... this course students will be able to: Calculate with advanced formulas Organise worksheet and table data using various techniques Create and modify charts Analyse data using PivotTables and PivotCharts Insert graphic objects Customise and enhance workbooks and the Excel environment Target Audience The target students for this course are students who desire to gain the  more...

Microsoft Excel 2003 - Introduction / Beginning ...odify charts. work with graphic objects. calculate with advanced formulas. sort and filter data. use Excel with the Web. SEE DAY TWO BELOW FOR ADDITIONAL TOPICS Welcome to Sonic Training!. (http://www.sonictraining.com 877-760-0078) Macromedia (Dreamweaver, Flash, Fireworks), Adobe (Photoshop, InDesign, Illustrator), Database (SQL, Access, Filemaker Pro, Goldmine), Programming (HTML,  more...

Advanced Crystal Reports 2011 The course is designed to provide delegates with extensive and in-depth knowledge of Crystal Reports 2011. Allowing report designers to create reports that will analyse and interpret business information. On completion of the course, delegates will be able to: * Create Advanced Formulas, * Create Specialised Reports, * Create Parameterized Reports, * Create Crosstabs, and * Create Sub  more...

Advanced Crystal Reports XI The course is designed to provide delegates with extensive and in-depth knowledge of Crystal Reports XI. Allowing report designers to create reports that will analyse and interpret business information. On completion of the course, delegates will be able to: * Create Advanced Formulas, * Create Specialised Reports, * Create Parameterized Reports, * Create Crosstabs, and * Create Sub  more...

Advanced Crystal Reports 2008 The course is designed to provide delegates with extensive and in-depth knowledge of Crystal Reports 2008. Allowing report designers to create reports that will analyse and interpret business information. On completion of the course, delegates will be able to: * Create Advanced Formulas, * Create Specialised Reports, * Create Parameterized Reports, * Create Crosstabs, and * Create Sub  more...

Customized Microsoft Excel Training in Toronto ...rts * Working with Graphic Objects * Calculating with Advanced Formulas * Sorting and Filtering Data * Using Excel with the Web * Streamlining Workflow * Collaborating with Others * Auditing Worksheets * Analyzing Data * Working with Multiple Workbooks * Importing and Exporting Data * Structuring XML Workbooks Reasons to choose Acend for your Customized Excel Training  more...

Crystal Reports 10 Level 1 (Nonconsecutive days) In this course, students will build basic list and group reports that work with almost any database. Who Should Attend: This course is designed for people who know how to create basic list and group reports and need to create reports that include subreports, cross-tabs, advanced formulas, and charts based on more than one data series. They may also need to build tools to  more...

Crystal Reports 10 Level 2 (Nonconsecutive days) In this course, students will learn how to create more sophisticated reports like subreports and cross-tabs. Also, they learn how to increase the speed and efficiency of their reports by using SQL queries and dictionaries. Who Should Attend: This course is designed for people who know how to create basic list and group reports and need to create reports that include  more...

Crystal Reports XI Level 1 (Nonconsecutive days) In this course, students will build basic list and group reports that work with almost any database. Who Should Attend: This course is designed for people who know how to create basic list and group reports and need to create reports that include subreports, cross-tabs, advanced formulas, and charts based on more than one data series. They may also need to build tools to  more...

Crystal Reports XI Level 2 In this course, students learn how to create more sophisticated reports including subreports and cross-tabs, and how to increase the speed and efficiency of your reports by using SQL queries. Who Should Attend: This course is designed for people who know how to create basic list and group reports and need to create reports that include subreports, cross-tabs, advanced formulas, and charts  more...

Intermediate Microsoft Excel ...a by using tools like sorting and filtering, and use more advanced formulas to perform more advanced analytical tasks. The class is taught as a hands-on "laboratory" lead by an experienced instructor. During class, students use a workstation to work with actual files and real-world examples. In addition to the classroom instruction and hands-on exercises, each participant recieves a booklet and  more...

Crystal Reports Advanced On Aspect Traininga s Crystal Reports Advance training course, delegates will create complex reports and data sources using Crystal Reports tools. They will create more sophisticated reports including sub reports and cross-tabs, and also increase the speed and efficiency of reports by using SQL queries. Aspect Traininga s Crystal Reports Advance training course is designed for people who know  more...

Advanced Excel 2003 for Business Class Type: * Can retake the class, for free, up to 3 months. * Free forum support for 1 year after class * Hands on, goal based * Small Classes of 4 to 9 people * Fast computers * Comfortable chairs, convenient location * Patient, Fun, Experienced Trainer When you are finished with this class you will be able to: * Extract data from large databases  more...

Advanced Excel Class ...advanced formulas and functions (Vlookup, If/ Then, Index/ Match, DSum, arrays, formula auditing techniques), what-if data-analysis techniques (pivot tables, scenarios, forecasting), database features (validations, extract unique values), advanced macros (with light VBA programming) and collaboration techniques. Advanced Excel Training Objectives: * Advanced Excel Formulas: Named  more...

ADVANCED EXCEL This program intends to impart the advance excel benefits to an individual. After the successful completion of the program, an individual will be able to use advanced filters, advanced pivots, array formulas, multi-dimensional lookup, more advanced formulas combining sumif, if, index, date functions and text functions. The program is offered online as well as as a live workshop.  more...