Excel courses Swindon

...2. Course description Learn all the necessary skills to create your own dashboards and reports. Discover how Excel can be utilised as an effective Business Intelligence... Learn about: MS Excel...

...2. Course description Gain an insight into some of the many lesser-used Excel functions and formulas, to improve your business data analysis... Learn about: MS Excel...

...2. Course description For anyone who is already confident using Excel and wants to learn all the necessary skills to utilise Excel pivot tables and pivot charts for data analysis... Learn about: MS Excel, Data analysis...

...2. Course description Learn skills to utilise macros within Excel. Techniques for creating, storing and reusing macros, and looking at editing... Learn about: Visual Basic, Visual Basic training, 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, Microsoft excel 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...

...the Page Setup Print preview A dialog box, printing Using lists Lists Transforming the range of the list Application forms AutoFilter Advanced filters... Learn about: Ms Office, Microsoft excel training, Office IT...

...Error GoTo On Error Resume Next Excel Model Object Application Object Workbook Object and Workbooks Collection Worksheet Object and Worksheets Collection ThisWorkbook... Learn about: MS Excel, Visual Basic, Visual Basic training...

...the Page Setup Print preview A dialog box, printing Using lists Lists Transforming the range of the list Application forms AutoFilter Advanced filters... Learn about: MS Excel, Ms Office...

...the correctness Recording and editing macros Visual Basic for Applications Create your own functions Results in VBA VBA Forms... Learn about: Visual Basic, MS Excel, Database training...

...the correctness Recording and editing macros Visual Basic for Applications Create your own functions Results in VBA VBA Forms... Learn about: Database training, Data analysis, Visual Basic...

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