Birmingham - Bristol - Cambridge - Coventry - Edinburgh - Glasgow - Kingston - Leeds - London - Manchester - Slough

Excel training courses and schools
Microsoft Excel

School: NobleProg
[All Courses]

Analysing Financial Data in Excel
Course Format: On-site
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 PivotCharts Creating Pivot Tables Calculated Item and Calculated Field Working with External Data Exporting and ...
 

Excel VBA Advanced (Certificate)
Course Format: On-site
Excel Object Model Workbook and worksheet object Workbooks and worksheets collections Range object’s properties and methods Current Region object Chart object Statusbar Timer List object Events Events with application object Arrays Dynamic arrays Arrays optimization Multidimensional arrays Arrays and objects Object Oriented Programming (OOP) Classes and obj...
 

Excel VBA Introduction (Certificate)
Course Format: On-site
Macros Recording and Modifying Macros Assigning Macros to Toolbar, Buttons, Shortcut key Visual Basic for Applications Environment Visual Basic Editor and its options Component Management Shortcuts Environment Optimization Introduction to Procedural Programming Procedures: Functions and Sub-routines Data Types Control Flow If ...Then....Elseif....Else....End...
 

Excel Advanced with VBA
Course Format: On-site
Making Your Life Easier Shortcuts, Toolbars and Menus Tuning Excel interface Paste Special and Transposition Styles Selecting cells with "Go To Special" Dealing with Data Utilizing cell’s and range’s Names Formula, Workbook and Worksheet protection File encryption Track changes and revisions Workbook sharing Formula auditing Managing temp...
 

Excel Advanced
Course Format: On-site
Workbooks and Worksheet Templates Presenting Scenarios (What if... analysis) Functions Text Functions Date and Time functions Spreadsheet Databases Sorting Database Autofilter Advanced Filter Database functions Data Exchange CSV Files Importing Data Exporting Data Outline Subtotals Pivot Tables Creating pivot tables from different sources Cal...
 

Excel Introduction
Course Format: On-site
Introduction Running Microsoft Excel Excel elements Managing workbooks and worksheets Entering Data into Spreadsheet Formatting Changing number and date formatting (currency, percentage, etc...) Formatting cell’s borders and background Formatting row and column headers Styles in Excel Excel Navigation Moving around a big spread sheet Dealing with multi...
 

School: WWP Training Ltd.
[All Courses]

Excel VBA Programming
Course Format: Classroom
This programme is for you if you already have a thorough understanding of Excel formulae and functions and may already use some Visual Basic programming, but now you are looking for a more professional result using Excel. This programme has been specially designed for advanced users who want to exploit the more powerful features of Excel made available by VBA. In this programme, you will ex...
 

Excel 2007
Course Format: Classroom
This programme is for you if you are a complete beginner to Excel, or you may have some basic skills and now want to expand your knowledge. This programme will enable you to build the confidence to use Excel and introduce you to the basic operations. Prerequisites �Knowledge of PC fundamentals �Experience in working within the Microsoft Windows environment �A reasonable degree of key...
 

School: Wise Owl Business Solutions
[All Courses]

Excel 2007 Visual Basic
Course Format: Classroom
Recording macros and buttons Absolute and relative recording Where macros can be stored Assigning macros to buttons Selecting cells Selecting cells (absolute) Selecting cells (relative) Selecting to the end of a block Selecting a range by its corners The VB code editor Using Project Explorer Creating modules Basic subroutines and comments Messages and variables Input...
 

Excel 2007 Business Modelling
Course Format: Classroom
This course is aimed fairly and squarely at people who work in Finance and business modelling. Developed in-house by an expert in business modelling, this course shows you how to create robust business models which are easy to build and (above all) easy to test. The course makes extensive use of Excel range names. Building models Freezing windows What makes a good formula Separating i...
 

Page(s):- 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 [ Popular Topics ] [ Schools Only ]