Excel macros courses

...To develop knowledge of Excel. Suitable for: This course is suitable for users with a good understanding of Excel who want to use some of the more advanced features and functions...

...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...

...create formulae with excel functions, including conditional and nested functions. produce a variety of reports and models including what if analysis and pivot tables. manipulate and analyse data using list management techniques. create and manage shared workbooks. create and use custom templates...

...Course Outcome: Participants will be able to use Excel to present information in different financial modals...

..., sheets etc. You want to enhance your skills by looking at programming techniques. You want to work with pre-built spreadsheet examples and coded modules&all to take away. One of our other courses will be more suitable if: You are not an experienced Excel user...

...Become fully proficient with Microsoft VBA Programming. Individuals will be able to make use of the most powerful features of Microsoft Excel available through programming VBA code. Some of topics covered include macros, writing/editing code, variables, objects, properties and methods, control... Learn about: Excel Objects, Excel Variables, Microsoft Excel...

...create formulae with excel functions, including conditional and nested functions. produce a variety of reports and models including what if analysis and pivot tables. manipulate and analyse data using list management techniques. create and manage shared workbooks. create and use custom templates...

... 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: Microsoft Excel, MS Excel, Microsoft excel training...

...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: MS Excel, Microsoft Excel, Microsoft excel training...

... : what you need to know Large sets of data maintenance: tailoring your approach to maximise impact Mastering Creating Effective Spreadsheets Create Dynamic Report with Excel PivotTables Auditing Excel Worksheet Formulas... Learn about: Microsoft Office, Microsoft Excel, MS Excel...

...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 intensive hands-on one-day training course has been designed to provide delegates with a solid understanding of advanced Excel 2007, 2010 or 2013 tools and concepts in order to increase their knowledge and productivity. Target AudienceUsers with a good understanding of Microsoft Excel... 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: MS Excel, Microsoft Excel, Microsoft excel training...

...We have partnered with world-famous brand ‘For Dummies®’ to develop a user-friendly online learning course to help people of any ability to develop skills with Microsoft Excel 2010 from the very foundations to the expert level.... Learn about: Basic IT, Basic IT training, MS Excel...

...To learn practical skills and concepts for: developing project appraisal and business planning applications. building accurate, efficient and reliable project and planning models. using advanced techniques in Excel to customise and manipulate models. sensitivity testing and other risk analysis...

...This intensive hands-on one-day training course has been designed to provide delegates with a solid understanding of advanced Excel 2007, 2010 or 2013 tools and concepts in order to increase their knowledge and productivity. Target AudienceUsers with a good understanding of Microsoft Excel... Learn about: Microsoft excel training, Microsoft Excel, MS Excel...

...To introduce more advanced Excel features...

... reports and scenarios. -etc. Suitable for: This programme is for you if you have some experience in working with Excel and now want to broaden your knowledge and use the more advanced features. You will learn how to use the more complex functions and practise them so that you can build the confidence...

...create formulae with excel functions, including conditional and nested functions. produce a variety of reports and models including what if analysis and pivot tables. manipulate and analyse data using list management techniques. create and manage shared workbooks. create and use custom templates...

... by automating many of the repetitive tasks that are part of spreadsheet development. In Excel...