Excel macros courses

...On this course you will be taught some of the more advanced functions of MS Excel. Suitable for: This course is for those who require a higher level of skill with MS Excel's more technical functions. You will need a strong existing knowledge of Excel in order to attend this course...

...create custom templates to be more productive. automate repetitive and/or complex tasks using macros. summarise data using pivot tables. analyse and extrapolate data using scenarios and solver. create complex formulae using combinations of functions like vlookup and match. use array formulae...

...This course will enable delegates to create macros, audit and analyse worksheet data, create PivotTables and PivotCharts, use lookup tables and import and export data...

...Users will see techniques for using the application in a more efficient manner and learn how to create more sophisticated formulae. This entirely 'hands on' course allows participants the chance to explore some of the more complex Excel features and functions. Suitable for: Users who want to...

...You will learn various advanced techniques for analyzing and manipulating data in Excel. This course meets the Microsoft Proficiency Guidelines for Excel at the Expert level. Suitable for: This course is intended for businesses and home users of Microsoft Excel that need advanced skills...

...create custom templates to be more productive. automate repetitive and/or complex tasks using macros. summarise data using pivot tables. analyse and extrapolate data using scenarios and solver. create complex formulae using combinations of functions like vlookup and match. use array formulae...

... Excel Standard, Home or Student Editions. None of the activities involve or require the use of macros. Target student Anyone who needs to work with Excel in order to connect to, arrange, prepare, process, analyse and display data in order to produce suitable output and views of data for... Learn about: MS Excel, Microsoft excel training, Microsoft Excel...

...Users will see techniques for using the application in a more efficient manner and learn how to create more sophisticated formulae. This entirely 'hands on' course allows participants the chance to explore some of the more complex Excel features and functions. Suitable for: Users who want to...

...Using an intuitive blend of instructor-led videos, hands-on exercises and interactive quizzes the Microsoft Excel 2010 Online Training course is delivered online via the learning platform. This self-study approach means that students can work at thei... Learn about: Microsoft excel training, Microsoft Excel, MS Excel...

...With expert guidance and a combination of videos, PDFs, and worksheets, this course will enable you to develop your beginner to advanced excel skills, become a data analyst,excel expert and unlock your full potential. This Microsoft Excel from A-Z: Beginner To Expert Course covers: Excel functions... Learn about: MS Excel, Microsoft excel training, Microsoft Office...

..., 2010 or 2013 who want to expand on their capabilities in a short space of time. Delegates should have a good working knowledge and understanding of the concepts covered in the Introduction and Intermediate courses. Class sizes Maximum class size for Excel Advanced (2007, 2010 & 2013) courses... Learn about: Microsoft excel training, Microsoft Excel, MS Excel...

...This course provides hands-on delivery covering the following topics: Auditing Look up tables Macros and Assigning Code to Buttons IF Revisited... Learn about: Microsoft excel training, MS Excel, Microsoft Excel...

...Description Excel dashboards enable visualisation of data to produce high level management reports. Dashboards often have user interactivity to convey the most important information at a glance. At the end of this course, delegates will be able to manipulate tables of data & use relevant functions... Learn about: MS Excel, Microsoft Office, Microsoft Excel...

...Master Excel completely with this comprehensive course encompassing both Excel 2010 and Excel 2013. Learn how to capture, understand and present data with this powerful application and make full use of all of the tools and functions across both editi... Learn about: MS Excel, Microsoft Excel, Microsoft excel training...

..., 2010 or 2013 who want to expand on their capabilities in a short space of time. Delegates should have a good working knowledge and understanding of the concepts covered in the Introduction and Intermediate courses. Class sizes Maximum class size for Excel Advanced (2007, 2010 & 2013) courses... Learn about: Microsoft excel training, MS Excel, Microsoft Excel...

...Become an accomplished Microsoft Excel professional with this engaging, innovative online distance learning course. Through exercises that put knowledge gained from video and handout lessons into practice, you will master higher Excel functions such as performing statistical analyses, creating... Learn about: Excel Interface, MS Excel, Microsoft excel training...

... recording Edit a macro Macro security Customising Excel Creating templates Customising toolbars/menus Create custom keyboard shortcuts Create custom views... Learn about: MS Excel...

...Course Details: Our one day Advanced course in Microsoft Excel, covers the following topics: Naming Cells & Ranges Automatic & conditional Formatting...

...If you're already up to speed with Microsoft Excel but you would now like to automate some common tasks, apply advanced analysis techniques to more complex data sets. This course is aimed at someone desiring to gain the skills necessary to create macros, audit and analyse worksheet data, create...

...You already know the basic and some advanced operations in Excel, now you will learn even more...