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

...A hands-on one-day course with free pre-course online skills testing. This course covers 2007, 2010, 2013 and 2016 versions. TARGET AUDIENCE This intensive hands-on one-day course is aimed at existing users of Microsoft Excel who want to use the more advanced data manipulation and display features... Learn about: Microsoft Excel, MS Excel, Business Intelligence...

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

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

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

... and PivotChartsCreating and examining macros This course is applicable to all versions of Excel from Excel 97 to Excel 2013. Furthermore, you can complete the Hands-On exercises in either Excel 2013, 2010, 2007 or 2003, allowing you to choose the version that better suits your needs. Learning Objectives You Will Learn... Learn about: MS Excel, Microsoft excel training, Microsoft Excel...

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

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

...A hands-on one-day course with free pre-course online skills testing. This course covers 2007, 2010, 2013 and 2016 versions. TARGET AUDIENCE This intensive hands-on one-day course is aimed at existing users of Microsoft Excel who want to use the more advanced data manipulation and display features... Learn about: Microsoft excel training, Business Intelligence, MS Excel...

... with our VBA course to automate tasks in Microsoft Excel that are performed frequently... Learn about: Design techniques, MS Excel, PC training...

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

...Academy instructors have undertaken the MOS programme, have several years teaching experience and have achieved MOS Master Instructor Certification.To become a Microsoft Office Specialist (MOS) in Microsoft Excel Expert 2003 an individual has to demonstrate proficient use of the application during...

... and be able to create a simple Macro. Suitable for: Designed for existing users of Excel who wish to progress their Excel skills and benefit from it's powerful data analysis tools... Learn about: Excel 2013, MS Excel, Exel 2007...

...Are you tired of struggling with Microsoft Excel? Do you want to use Excel with ease to solve complex problems, automate spreadsheets, and master graphs for presentations instead of pulling your hair out? We can help! Once you’ve got the Excel covered, take your skills to the next level... Learn about: MS Excel, Microsoft Excel, Project Management...

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

... Macros...