Mac Introduction course,
Understand the needs of children who have a parent with a mental illness in this DfE-assured course for Senior Mental Health Leads.
Learn how to use Macros in Excel to automate your work and start to see the power these can give you. Course overview Duration: 1 day (6.5 hours) Our Excel – Working with Macros course aims to show how macros can be used to automate commonly used commands and processes. This course is designed for existing experienced users of Excel. You should be confident creating and manipulating Excel spreadsheets and creating formulas before attending this course. Objectives By the end of the course you will be able to: Record and run macros Navigate within the Visual Basic Environment Edit pre-recorded macros Create your own functions Content Recording macros Accessing the Developer Tab Naming conventions and storage locations Recording macros Absolute and relative cell addressing Running macros Assigning macros to the Quick Access Toolbar Assigning macros to objects Creating new tabs Workbook macros Recording macros in a specific workbook Saving the workbook as an Excel Macro-Enabled Workbook Creating quick access items specific to workbooks Importing and manipulating data Importing Delimited Text Files Importing Fixed Width Text Files The Visual Basic environment Project explorer Code window Properties window Renaming modules Deleting modules Working with code Code structure Adding comments Navigating within your code Editing macro code Getting help with syntax Debugging Errors Using debug Function procedures Creating function macros
The LMI Foundations of Success workshop introduces the concepts and practical tools used to help countless individuals within thousands of organisations, of all sizes and complexity in both the public and private sector, realise more of their true potential.
Start from the ground up and learn tips, tricks, shortcuts and build confidence in using Excel.
Introducing the the modality of Non-Violent Communication (NVC), also known as Mindful, or Compassionate Communication, this 2-day modular workshop will explore how we express ourselves and how we hear others - how we can increase our ability to create meaningful connections, both with others and with ourselves, even in disagreement, and how we can empower our clients to do the same within their own relationships.
This course provides the delegate with the theoretical and practical skills to undertake non-licensed works with ACM's. Persons requiring this type of training would include trade operatives undertaking tasks with ACM's as defined in HSG210 and in accordance with CAR 2012 Reg 3(2). In addition to the Asbestos Awareness, those employees whose work will knowingly disturb ACMs, and which is defined as non-licensable work or NNLW, should receive additional task-specific information, instruction and training.
Expand your Excel knowledge and learn how to structure and analyse large data sets.
A day of Data Governance, support, networking, and answering your questions. Join me for my 1 Day Data Governance Mastermind where you get allocated time to get specific advice on your current Data Governance challenges and get the chance to network with others in similar situations.