-
All
-
Online
-
Filters
-
Location
-
Online
-
Type of studies
-
+ Filters
Excel macros courses
- Vocational qualification
- Doncaster
- 1 Day
...m well and be dedicated to the business. Well-trained staff will be able to complete tasks more quickly and efficiently and productivity may go up.Course AimsThis course allows the delegate to appreciate the full potential of Excel 2003. By the end of the course, the user will be competent...
- Vocational qualification
- Croydon
- 1 Day
...This course will give delegates the ability to create advanced spreadsheets using the full range of Microsoft Excel tools and features. Delegates will learn to apply custom formatting and use templates; to import and export data in different formats; to use LOOKUP functions; and to create...
- Course
- Blended in Milton Keynes
- 20h
...To teach Excel 2003 to Microsoft Office Expert level. Suitable for: Those familiar with using Microsoft Excel to an intermediate level who now wish to learn advanced features...
- Course
- Online
- Different dates available
... Subqueries Data Normalization Create a Junction Table Import Data into Access Export Data to Text File Formats Export Access Data to Excel Create a Mail Merge... Learn about: Perform Calculations in a Query, Convert a Macro to VBA, Create Lookups...
- Training
- Inhouse
- 1 Day
...To build on previous knowledge and explore Advanced 2007 functionality within Excel, finishing with an introduction to Macros. Suitable for: Fairly experienced Excel 2007 users whom need to learn more complex functions, nesting, data manipulation and automation using basic macros... Learn about: MS Excel...
- Short course
- Carlisle
- 1 Day
...Course Details: Our one day Advanced course in Microsoft Excel, covers the following topics: Naming Cells & Ranges Automatic & conditional Formatting...
- Short course
- Inhouse
- Advanced
- 1 Day
...Delegates will learn various advanced techniques for analysing and manipulating data in Excel. Suitable for: This course is designed for those delegates who already experienced in the use of Excel...
- Course
- London
- Advanced
- 2 Days
...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
- Birminghamandanother venue.
- London-City
.... In this course, you will extend your knowledge into some of the more specialised and advanced capabilities of Excel by automating some common tasks, applying advanced analysis techniques to more complex data sets such as PivotTables, collaborating on worksheets with others, importing and exporting data.Target... Learn about: MS Excel, Microsoft excel training, Microsoft Excel...
- Course
- Inhouse
...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...
- Vocational qualification
- Southampton
- 8h
... Cells and Worksheets Protect Workbooks Customizing Excel Record Macros Run Macros Change Security Levels for Macros Understand Editing Macros...
- Short course
- Inhouse
- Advanced
- 1 Day
...You already know the basic and some advanced operations in Excel, now you will learn even more...
- Short course
- Inhouse
- Advanced
- 1 Day
...To introduce more advanced Excel features...
- Course
- Online
- Different dates available
... Activity-Update Workbook Properties Create and Edit a Macro Activity-Create and Edit a Macro Apply Conditional Formatting Activity-Apply Conditional... Learn about: Microsoft Word, Ms Office, Database training...
- Short course
- Cambridge
- Advanced
- 1 Day
... 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 2016, Excel 2013, Microsoft Excel...
- Short course
- Inhouse
- Advanced
- 1 Day
...Course Content Our one day Advanced course in Microsoft Excel, covers the following topics: Naming Cells & Ranges Automatic & conditional Formatting...
- Training
- Sunderland
- Advanced
- Different dates available
- 2 Days
...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: Microsoft Excel, Excel Objects, MS Excel...
- Course
- London
- 2 Days
...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
- Online
...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: Business Intelligence, Microsoft excel training, Microsoft Excel...
- Course
- Inhouse
...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...