17 Money Management Tools courses in Hurstpierpoint

Remote training session for FreeAgent Accounting and Payroll software.

Remote training session for Sage Accounting and Payroll software.

Remote training session for Xero Accounting and Payroll software.

Remote training session for QuickBooks Accounting and Payroll software.

Our bespoke Xero Training sessions are designed to get your Xero working properly & showing you the correct information, and to save you time for the important things... Get Xero set up properly, working as it should, error free Fix all of your Xero issues, once & for all Learn how to deal with your transactions correctly Use reporting to understand how your business is performing Gain confidence using Xero Save oodles of time on your accounting every single day with our bespoke Xero Training!

Excel but different. Harness this most powerful tool but on a course tailored to your business and needs. Using case studies relevant to your business and often actual files your firm uses on a daily basis we embark on a voyage of discovery. This isn't a boring "watch what I do and copy" course. This is exciting, engaging, funny and enjoyable. Delegates will learn relevant skills but also, because of the delivery methods they will gain an increased enjoyment of using Excel and will retain and implement all of the material covered. They also have access to the trainer for an unlimited amount of time after the course to continue to grow their knowledge

Excel but different. Harness this most powerful tool but on a course tailored to your business and needs. Using case studies relevant to your business and often actual files your firm uses on a daily basis we embark on a voyage of discovery. This isn't a boring "watch what I do and copy" course. This is exciting, engaging, funny and enjoyable. Delegates will learn relevant skills but also, because of the delivery methods they will gain an increased enjoyment of using Excel and will retain and implement all of the material covered. They also have access to the trainer for an unlimited amount of time after the course to continue to grow their knowledge

* A series of hourly small group sessions where we look at different aspects of Excel * Duration: 1 hr sessions  Alternatively, we can do you one-to-one sessions, either via virtual classroom or in person at our training course. These are £25 per hour, or £100 for 5-hour blocks.

Following on from the Macros course look at how you can write your own Visual Basic code within Excel to fully automate tasks and save time. -------------------------------------------------------------------------------- COURSE OVERVIEW Duration: 2 days (13 hours) Our VBA in Excel course is an introduction to using the Visual Basic for Applications language for programming in Excel. It looks at structures, syntax and coding standards. This course is designed for existing experienced users of Excel who can record and run macros and those who have dabbled in VBA but would like some formal training and help to put some structure to their code. OBJECTIVES  By the end of the course you will be able to: * Write visual basic procedures * Create event and general procedures * Use commands from the Excel data model * Use statements and functions * Use a selection of debugging tools * Create and use variables and constants * Use different types of loops * Create an Excel user form CONTENT THE VBA ENVIRONMENT   * Project explorer * Excel objects * Modules * Properties window * Code window CODE STRUCTURE * Code structure * Navigating within your code * Adding comments * Using WITH * Steps to creating a VBA procedure PROCEDURES  * Sub procedures * Event procedures * Calling procedures THE EXCEL DATA MODEL  * Workbook commands * Worksheet commands * Excel selection methods * Data manipulation commands DEBUGGING  * Using breakpoints * Stepping through code * The immediate window * The watch window * The locals window points VARIABLES AND CONSTANTS  * Declaring variables * Declaring multiple variables * Variable data types * Concatenation * Scope of variables * Constants * Declaring constants * Using constants * Scope of constants LOOPING  * Do while loops * Do until loops * For next loops CONDITIONAL STATEMENTS * IF statement * SELECT CASE statement * Comparison statements * Logical operators CREATING A USER FORM * Form layout * The control toolbox * Naming conventions * Adding objects * Naming objects * Captions * Displaying the form OBJECT PROPERTIES * Object properties * Setting properties at design time * Setting properties at run time INTERCONNECTIVITY BETWEEN THE USER FORM AND EXCEL * Comparing values * Transferring information * Running code

Expand your VBA knowledge further and learn some of the more advanced coding features. -------------------------------------------------------------------------------- COURSE OVERVIEW Duration: 2 days (13 hours) This course is aimed at experienced VBA users or those who have attended our Part 1 [https://www.underscore-group.com/training/training-courses/technical-and-office-programs/vba-in-excel/] course and have started to use the language. Part 2 expands on the huge array of commands and elements of the data model that can be used and looks at building more complex VBA models OBJECTIVES  By the end of the course you will be able to: * Use comparison operators and system functions * Use Arrays * Work with ranges * Work with the worksheets and workbooks collections and objects * Use application objects * Use the FileSystemObject * Create function procedures * Import and save text files * Connect to other applications CONTENT COMPARISON OPERATORS   * Using Comparison operators and functions * The LIKE function * Wildcards * Using SELECT Case SYSTEM FUNCTIONS   * The VAL function * Case functions * Trim functions * Text functions * Date functions EXCEL WORKSHEET FUNCTIONS   * Using Excel functions in VBA ARRAYS   * Creating arrays * Using arrays * Ubound and Lbound * Single and multi dimensional arrays * Static vs dynamic arrays WORKING WITH RANGES   * Creating range objects * Passing data between range objects and arrays * Using Transpose THE EXCEL OBJECT MODEL   * The object browser WORKING WITH COLLECTIONS   * Collections * Creating object variables * Setting object variables * The For Each . . . Next Loo SHEET COLLECTIONS   * The worksheets collection * The worksheet object * The sheets collection * Using object * Grouping worksheets * Using Typename THE WORKBOOK COLLECTION   * The workbooks collection * Setting workbook variables APPLICATION OBJECTS   * Excel default information * Display/alerts * Screen updating * Status bar * On Time * Using Wait SYSTEMS DIALOG BOXES   * Showing dialog boxes * Using dialog boxes WORKING WITH FILES   * Searching for files and folders * The DIR function * The FileSystemObject FUNCTION PROCEDURES   * Creating functions * Adding arguments * Calling functions WORKING WITH TEXT FILES   * Searching for files and folders * The DIR function * The FileSystemObject * Using the FILE and FOLDER collections SHARING DATA WITH OTHER APPLICATIONS   * Early vs Late Binding * Setting references to other applications * Creating application variables * Setting application variables