Excel courses City of London

...and how to secure it. Advanced Features of Excel Functions Panel The properties of an object from VBA Events Sheet, Workbook and Application Formula repeatedly... Learn about: MS Excel...

...Course Objectives This course will help improve your familiarity with Excel and statistics and as a result increase the effectiveness and efficiency of your work or research... Learn about: MS Excel, Microsoft Excel, Data analysis...

...Analysis Routines Sorting, filtering and distributing data between worksheets and workbooks Using VBA to control charts Using VBA to control pivot tables... Learn about: MS Excel...

...Reporting 12-Month Reporting Closing Remarks... Learn about: Financial Reporting, Financial Training, MS Excel...

...Immediate window Traps - Watches Call Stack Error handling Types of errors and ways to avoid Capturing and handling run-time errors Structures... Learn about: MS Excel, Visual Basic training, Visual Basic...

...2010, 2013 or 2016). Getting Started Starting Out About Workbooks Exploring your Workbook Getting Help with Excel The Excel Interface The Quick Access... Learn about: Visual Basic training, Visual Basic, MS Excel...

...Calculated Field Working with External Data Exporting and importing Exporting and importing XML data Querying external databases Linking to a database... Learn about: Financial Training, MS Excel, Database training...

...charts Creating Charts. Components of graphs and their modification Create your own chart types... Learn about: Database Management, MS Excel, Data analysis...

...File Operations Opening and closing text files Reading and writing text and binary data Processing of records in the CSV file Efficient processing of... Learn about: Visual Basic, MS Excel, Oriented Programming...

...and resolve performance issues, properly define indexes for best performance, and how to optimise XQuery applications for concurrency. Application development... Learn about: Database training, Application Development...

...and how to secure it. Advanced Features of Excel Functions Panel The properties of an object from VBA Events Sheet, Workbook and Application Formula repeatedly... Learn about: MS Excel...

...Course Objectives This course will help improve your familiarity with Excel and statistics and as a result increase the effectiveness and efficiency of your work or research... Learn about: Data analysis, Confidence Training, Microsoft Excel...

...Application Object Workbook Object and Workbooks Collection Worksheet Object and Worksheets Collection ThisWorkbook, ActiveWorkbook, ActiveCell... Learn about: Visual Basic, Microsoft Excel, Visual Basic training...

...Financial functions Lookups and data tables Using lookup functions Using MATCH and INDEX Advanced list management Validating cell entries Exploring database... Learn about: Microsoft Excel, Financial Training, MS Excel...

...Immediate window Traps - Watches Call Stack Error handling Types of errors and ways to avoid Capturing and handling run-time errors Structures... Learn about: Visual Basic training, Visual Basic, MS Excel...

...menu and toolbar in add-in Deployment and securing add-ins Using external librariesUsing external data sources (Access, Oracle, etc.) Using ADO Data providers... Learn about: Object-oriented training, MS Excel, Object oriented Programming...

...the validation Macros - automation tasks in sheets Registration macros Understanding and modifying the code macros (VBA items) Connecting the interface... Learn about: Database training, Database Management, MS Excel...