Sort by:
Relevance |
Price
Advanced Microsoft Excel
Reed Learning
A detailed coverage of the advanced features of MS Excel providing you with the knowledge and confidence to manage complex and large data sets. This two day course also covers the additional features unique to the XP version Course Outline: Advanced...
(Spreadsheet Course in West Midlands)
£495 + VAT
Advanced Microsoft Excel
Reed Learning
A detailed coverage of the advanced features of MS Excel providing you with the knowledge and confidence to manage complex and large data sets. This two day course also covers the additional features unique to the XP version Course Outline: Advanced...
(Spreadsheet Course in London)
£495 + VAT
Excel VBA
2e2 Training
Course objectives: After completing this course, you will know how to: Use Visual Basic for Applications terminology, start Visual Basic Editor, and work with object properties, methods, and events. Manipulate data by declaring variables and procedur...
(Spreadsheet Training in West Midlands)
£550 + VAT
Excel VBA
2e2 Training
Course objectives: After completing this course, you will know how to: Use Visual Basic for Applications terminology, start Visual Basic Editor, and work with object properties, methods, and events. Manipulate data by declaring variables and procedur...
(Spreadsheet Training in West Yorkshire)
£550 + VAT
MS Excel 2007 VBALevel 2 (2 days)
Macresource Computer Training
Excel object model About classes and objects Objects and collections The hierarchy of objects Properties, methods and events The Locals Window The Immediate Window Function procedures Sub versus function User-defined functions Declaring a function Ca...
(Spreadsheet Course in London)
£1,095 + VAT
MS Excel VBA Level 2
Macresource Computer Training
Excel object model About classes and objects Objects and collections The hierarchy of objects Properties, methods and events The Locals Window The Immediate Window Function procedures Sub versus function User-defined functions Declaring a function Ca...
(Spreadsheet Course in London)
£550 + VAT
MS Excel VBA Level 1
Macresource Computer Training
Basics Excel VBA overview Understanding macro steps Modifying macro steps Storing values in variables Adding comments to your code Stepping through macros Getting help on macros Objects, properties and methods About Excel objects Range object The Sel...
(Spreadsheet Course in London)
£295 + VAT
MS Excel Advanced
Macresource Computer Training
Data manipulation Automatic outlining Group and ungroup Filtering data Advanced filtering Sorting data Inserting Subtotals Creating an Advanced Filter Single input data tables Double input data tables Formulas and functions Complex If statements Usin...
(Spreadsheet Course in London)
£245 + VAT
MS Excel 2007 VBA Level 1(1 day)
Macresource Computer Training
Basics Excel VBA overview Understanding macro steps Modifying macro steps Storing values in variables Adding comments to your code Stepping through macros Getting help on macros Objects, properties and methods About Excel objects Range object The Sel...
(Spreadsheet Course in London)
£1,095 + VAT
MS Excel Level 1: Beginner
Wise Ltd.
Excel Basics Worksheets and workbooks Menus & toolbars Save a workbook Moving around a workbook Keyboard shortcuts Adjust column width/row height Working With Cells Select cells Edit, delete cell content Spelling check AutoCorrect, AutoComplete, Auto...
(Spreadsheet Course in London)
£210 + VAT
MS Excel Level 3: Advanced
Wise Ltd.
Advanced Formulas & Functions IF and related functions Nested functions/formulas Array formulas Date arithmetic Financial functions Locating and interpreting errors Analysing Data Create a PivotTable Create a PivotChart Create Scenarios Use Goal Seek...
(Spreadsheet Course in London)
£210 + VAT
MS Excel Level 2: Intermediate
Wise Ltd.
Referencing Cells & Cell Ranges Absolute, relative & mixed referencing Named ranges Referencing values in other worksheets/workbooks 3-D referencing Circular referencing Working With Large/Multiple Spreadsheets Freeze panes Split window Arrange windo...
(Spreadsheet Course in London)
£210 + VAT
Excel XP\2003 Introduction
PPi Learning Services
Course content Understanding screen features, using help and the Office assistant, toolbars and dialog boxes, smart tags and task panes Creating and saving workbooks, opening and closing files, managing workbooks Moving to and selecting cells, enteri...
(Spreadsheet Course in London)
£130 + VAT
Excel 97/2000 Introduction
PPi Learning Services
Course content Understanding screen features, using help and the Office assistant, toolbars and dialog boxes Creating and saving workbooks, opening and closing files, managing workbooks Moving to and selecting cells, entering, editing and erasing cel...
(Spreadsheet Course in London)
£130 + VAT
Excel 2007 Intermediate
PPi Learning Services
Course content Formulas and Functions Data series 3D formulas Naming cells Relative and Absolute cell referencing Subtotals Using IF and Nested IF Functions Naming Cells And Creating 3D Names Applying Names To Formulas LOOKUPfunctions Formatting Cond...
(Spreadsheet Course in London)
£130 + VAT
Excel XP\2003 Introduction
PPi Learning Services
Course content Understanding screen features, using help and the Office assistant, toolbars and dialog boxes, smart tags and task panes Creating and saving workbooks, opening and closing files, managing workbooks Moving to and selecting cells, enteri...
(Spreadsheet Course in West Midlands)
£130 + VAT
Excel 2007 Intermediate
PPi Learning Services
Course content Formulas and Functions Data series 3D formulas Naming cells Relative and Absolute cell referencing Subtotals Using IF and Nested IF Functions Naming Cells And Creating 3D Names Applying Names To Formulas LOOKUPfunctions Formatting Cond...
(Spreadsheet Course in West Midlands)
£130 + VAT
Excel For Statistical Data Analysis
Nobleprog Limited
Aggregating Data in Excel Statistical Functions Outlines Subtotals Pivot Tables Data Relation Analysis Normal Distribution Descriptive Statistics Linear Correlation Regression Analysis Covariance Analysing Data in Time Trends/Regression line Linear,...
(Spreadsheet Course in London)
£710 + VAT
Analysing Financial Data in Excel
Nobleprog Limited
Advanced functions Logical functions Math and statistical functions Financial functions Lookups and data tables Using lookup functions Using MATCH and INDEX Advanced list management Validating cell entries Exploring database functions PivotTables and...
(Spreadsheet Course in London)
£540 + VAT
Excel VBA
2e2 Training
Course objectives: After completing this course, you will know how to: Use Visual Basic for Applications terminology, start Visual Basic Editor, and work with object properties, methods, and events. Manipulate data by declaring variables and procedur...
(Spreadsheet Training in London)
£550 + VAT
