MS Excel Essentials
Advanced Excel – Essential Excel for Business 21 May 2015 The Mount Conference Centre, Belfast This advanced Excel training is designed to help you to master the more advanced functions and introduce advanced tools and techniques which will help you create more powerful spreadsheets and increase your work efficiency. What Will I learn? In business, it is important that the data managed by an organisation is accessed, manipulated and analysed in a secure and robust manner. Integration with other applications and sharing data between users is now commonplace and detailed data analysis helps to inform and provide important management information.During the course you will learn how data can be successfully and securely exchanged with outside sources and how it can be shared between multiple users. Advanced data analysis and functions are considered, along with an introduction to macros. The course is designed as a practical course enabling you to receive hands-on experience of these advanced Excel topics. The content will be relevant to both Excel 2007 and 2010.By the end of the course you will have an understanding of: Analysing Data – using IF statements, Data and Pivot Tables Macros – recording & running macros, and assigning Macros to Buttons Sharing Workbooks – consolidating data, conflicts of shared data and administration Template and Protection – creating templates and protecting Excel files Importing from External Sources such as Word, Access and Powerpoint. Introducing Dynamic Data Exchange Forms – creating Forms and using Ready made Forms When and Where is it Running ? Thursday 21 May 2015 The Mount Conference Centre, Belfast Course Costs £199 In conjunction with AKU...
Read MoreMS Word Essentials
Advanced Word – Essential Word for Business Microsoft Word training to help you to master its advance features and powerful tools to create high quality, professional business documents. You will save time and vastly enhance the layout and impact of your documents through use of Word’s automated functions, templates and design features. What Will I learn? You will learn how to use advanced features such as cross references, templates, change tracking facility and collaboration on a document via the web. The course also examines how documents and text can be successfully and securely exchanged with outside sources and shared by multiple users.By the end of the training course you will be able to: Create tailored templates for your organisation or department Insert bookmarks, cross references, tables of contents and footnotes Manage linked headers and footers Use track changes and protect documents with tracked changes Use the sort function for rules, tables, lists and subsections Insert, order and group diagrams, charts and illustrations Enhance document design with tailored backgrounds and watermarks Use collaboration tools for online meetings, schedules and web discussions Integrate with Excel, Access and the Web Link and embed objects When and Where is it Running ? Tuesday 19 May 2015 The Mount Conference Centre, Belfast Course Costs £199 In conjunction with AKU Training...
Read MoreConnect with us
