-
All
-
Online
-
Filters
-
Location
-
Online
-
Type of studies
-
+ Filters
Excel macros courses
- Course
- Inhouse
...This course is aimed at those people who find they have reached their limit with the menu items of Excel and need to modify Excel to be better suited to their environment, by creating their own functions and procedures...
- Course
- Online
- Intermediate
- Different dates available
- 12 Months
... - Training Bundle’ is your step-by-step guide to getting it all done. Get started now, and be on your way to mastering Word, PowerPoint, Excel, and more. Project Files included!... Learn about: Microsoft Project, Ms PowerPoint, Microsoft excel training...
- Course
- London-cityand2 other venues
- Birmingham, Reading
.... TARGET AUDIENCE The course is designed for existing, experienced users of Excel 2007, 2010, 2013 or 2016 who need to use VBA to automate their spreadsheets. Delegates should therefore have a solid grounding in, and understanding of, Microsoft Excel to a high level. Familiarity with the content... Learn about: MS Excel, Microsoft Excel, Microsoft excel training...
- Short course
- London
- 1 Day
...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...
- Course
- Washington
- 3 Days
...This course is aimed at those people who find they have reached their limit with the menu items of Excel and need to modify Excel to be better suited to their environment, by creating their own functions and procedures...
- Short course
- Inhouse in Cambridgeshire
- Advanced
- 1 Day
...You already have a good working knowledge of Access, working with various Access objects, such as tables, queries, forms, and reports. In this course, you will explore some of the more specialist and advanced aspects of Access, including writing advanced queries, working with macros, enhancing...
- Course
- Birminghamand2 other venues
- London-City, Reading
..., or with a simple copy and paste of your new data into your spreadsheet. TARGET AUDIENCE Anyone with an advanced knowledge of Excel who wants to learn how to create dashboards which will enhance their spreadsheets with easily understood and interactive data displays. Excel Dashboards provide insight, analysis... Learn about: Microsoft excel training, MS Excel, Microsoft Excel...
- Short course
- London
- 1 Day
...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...
- Course
- Peterboroughand2 other venues
- Birmingham, London-City
... foundation in the basic and intermediate skills for working in Excel. You have already used Excel to perform tasks such as running calculations on data and sorting and filtering numeric data. Learning Objectives Delegates will learn how toEnhance productivity and efficiency by streamlining... Learn about: Ms Office, Microsoft Excel, XML training...
- Short course
- London
- Advanced
- 1 Day
...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...
- Course
- London
- 2 Days
...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
- London-cityand2 other venues
- Birmingham, Reading
... in order to produce professional and interactive reports and charts. Delegates should have a very good existing knowledge of Excel and ideally would have attended, or have knowledge of the concepts covered in the Excel Introduction and Intermediate courses. Learning Objectives Do you need to... Learn about: Microsoft excel training, Microsoft Excel, Business Intelligence...
- Course
- London
- 2 Days
...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
- Online
...In this course you will learn the skills to enable you to use the Visual Basic for Applications (VBA) programming language to simplify or automate activities and tasks using the Microsoft Office 2007 - 2016 applications. The course covers examples in Excel, Access, Word and PowerPoint 2007 -... Learn about: Ms Office, MS Excel, Microsoft Office...
- Short course
- London
- 1 Day
...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...
- Short course
- London
- 1 Day
...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...
- Short course
- London
- 1 Day
...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
- London
- 2 Days
...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...
- Short course
- London
- 1 Day
...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
- London
- 2 Days
... of microsoft excel. Suitable for: no previous programming skills are necessary, although a good working knowledge of excel is an advantage including using some functions...