IT Training Solutions Limited courses

...Use the following 5 Functions on a range of numbers to speed up basic calculations : Sum, Average, Count, Min, Max. Follow on Courses Excel Level 2 Excel...

...Access information from a database by creating and saving queries within a database. Produce accurate, informative and well presented formal reports for presentational purposes...

...Grouping sales data by company Adding new fields to carry out calculations on a report Creating sub reports Inserting sub reports into main (parent)...

...delegates with skills needed to create complex queries, create macros to automate tasks, enhance forms and reports and use Access data in other Office applications...

...your database before entering any information. Explain the advantages of using different data types within their database to change the way data can be input...

...Database normalisation - Designing your tables in an efficient manner in order to avoid data replication and ensure good database design What is a relational database?...

...(a course written to your specific needs) at your company office throughout the UK, at our training venue or at an independent location, convenient...

...opens Adding toolbars and menus Hiding objects and disabling Access shortcuts Introducing the AutoExec macro All your hardwork wasted by the shift...

...online Adding comments through a web browser Designing and Using electronic forms Creating a web ready email response form Adding a text field to a form Adding...

...boxes Editing caption/text boxes Adding rollover caption boxes Editing rollover images Adding animated objects Inserting text animations Interactive Objects...

...Deleting files and folders Moving a file to the my documents folder Copying and moving files and folders Renaming files and folders Finding files and folders...

...will introduce the essential tools and techniques through hands on exercises and theory. Delegates will gain an understanding of CorelDraw's great features...

...in design view Reviewing sections Distributing / Exporting Data Web browser options to view reports on-line Creating a report using spreadsheet data Exporting...

...Control the appearance of your report using conditional format statements and multiple sections. Create parameter formulas that allow users to determine...

...call centre or any type of Helpdesk / Support environment. It is an intensive course that aims to build on areas where Helpdesk representatives feel...

...regions Using a template Adding an editable region Creating a template Style Sheets Page background Page properties Applying style sheets to multiple pages...

...region Server Behaviour Sorting records Paging through recordsets Adding and hiding previous and next functionality Adding a first and last link Live objects...

...and printing Starting the spell checker Viewing a print preview Printing the spreadsheet Printing a section of a worksheet Clearing a print...

...Appeal Using Graphic Objects Inserting and modifying graphic objects Emphasise an area of a worksheet Illustrate workflow using SmartArt graphics Formatting...

...charts, graphics, and formulas. Prerequisites We recommend that you have experience with creating, editing, formatting, saving, and printing basic spreadsheets in Excel...