Excel courses Southampton

...Add Subtotals to Worksheets Create and Remove Custom Filters Use Database Functions Create Scenarios Use Solver Managing Worksheets Consolidate Data...

...Create and Edit Hyperlinks Save Worksheets and Workbooks as Web Pages Examine the Research tool Using Templates Explore Templates Create Workbooks Based...

...Understand Cell References Use Cell References in Formulas Enter a Formula in the Formula Bar Copy and Edit Formulas Working With Charts Examine Charts...

...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 training, Microsoft 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, MS Excel, Visual Basic...

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

...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, Database Management...