Advanced excel courses

...We will show you how to use spreadsheet software to visually display figures and numbers...

... 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. Target Audience Users with a good understanding... Learn about: Microsoft Word, Ms Word, Word 2007...

... will learn techniques for updating data in a star schema data warehouse using the DataStage SCD (Slowly Changing Dimensions) stage. Even if you are not working with all of these specific types of data, you will benefit from this course by learning advanced DataStage job design techniques, techniques that... Learn about: XML training, Database training, MS Excel...

...use table relationships to best effect. use advanced queries to analyse data. create customised forms and subforms to find the precise data required quickly. use macros to automate the operation of the database. automate exporting data to excel. administer the database using access'' inbuilt...

...Your training in and use of Access has provided you with a solid foundation in the basic and intermediate skills for working in Access. You're now ready to extend your knowledge into some of the more specialized and advanced capabilities... Learn about: Microsoft Access...

... to automate tasks to save you time, how to apply advanced techniques such as macros and VBAs and overall Access best practice... Learn about: Delete data, Access Control, External sources...

... Essential Excel analysis techniques such as Dynamic Ranges, and Advanced Charts How to effectively and clearly present your findings to relevant stakeholders... Learn about: Financial Training, Excel analysis, Dynamic Ranges...

...On completion of Microsoft Word 2007 Advanced Part 2 you will be able to: manage the use of styles;* create and modify headings in documents. import Excel, Word and Access data into a Word document;* draw tables in a document. create electronic forms in Word;* create captions and... Learn about: Word 2007...

...and animations To customise and format PowerPoint to your taste How to make a presentation flow using charts, graphs and tables PowerPoint is available in versions... Learn about: Ms PowerPoint, Ms Word, Microsoft Powerpoint...

...to present your data clearly using PivotCharts and Conditional Formatting... Learn about: DAX expressions, Data Modelling, Query editor...

...2. Course description This is an internationally recognised professional course which will give you the skills to excel at a wide range of accounting and finance jobs. On the Advanced Diploma you are introduced to more advanced bookkeeping and final accounts preparation. The qualification...

...2. Course description The Advanced Diploma in Accounting is the second stage of the full AAT qualification. It is a professional course which will give you the skills to excel at a wide range of accounting and finance jobs. On the Advanced Diploma you are introduced to more advanced bookkeeping... Learn about: Part Time, Economics Science, Part Time courses...

...This course aims to give delegates an in-depth knowledge of Excel 2016 features... Learn about: Microsoft excel training, Protection



, Tracing errors...

...Computerised Accounts - Advanced College Certificate This course follows on from the Beginners course and aims to provide further skills...

...Do you want to improve your skills in Microsoft Excel? With basic skills and some experience of Microsoft Excel, the topics covered on this course will enable you to further enhance your spreadsheets and to use some of the more advanced features to streamline your work. If you want to enjoy... Learn about: Chart analysis, MS Excel, Graphic representation...