460 Accounting courses in Devizes delivered Live Online

Introduction to International Trade This module provides a foundational understanding of the development and significance of international trade, focusing on the UK's trade strategy and its global role. Participants will explore key topics such as trade definitions, the World Trade Organization (WTO), the evolution of customs, and major post-WW2 trade developments. Additionally, the module covers the UK's entry into and exit from the EU, and the current UK Digital Strategy for International Trade. **Agenda Highlights**: - Definitions and importance of international trade - Overview of the WTO - Customs fundamentals - Post-WW2 global trade growth - Impact of EU membership and Brexit - UK Digital Strategy for international trade growth

This module aims to develop knowledge from research activities to gain an understanding of international trade theory, global economic development and growth, currency and exchange rates, trade policies and their impact on an organisation, free trade agreements, direct investment from financial sources outside the UK, tariffs and no trade barriers, supply chain and logistics, intercultural management and international law and treaties.

Understanding how to plan for capacity, be able to forecast and manage budgets is a critical skill in today's leadership and management environment. This programme will not only support your understanding but will also help you to practically put the learning into practice.

This module aims to develop knowledge and understanding of the importance of research including social media to find opportunities in global trade.

Duration 2 Days 12 CPD hours This course is intended for This course is intended for business users who have been using Power BI to build analytic solutions and are ready to take advantage of the power and flexibility that DAX provides. Learning DAX is a very common 'next step' for experienced Power BI users. Overview At course completion, you should be able to describe DAX syntax, data types, and errors use DAX to create calculated columns, measures, and tables explain how DAX calculations are evaluated, along with the differences between row context and filter context configure and use Time Intelligence to perform common time-based calculations, for example to-date calculations, year-over-year analysis, moving averages, etc. create calculated columns and measures that use data from multiple tables in the data model write measures that handle error conditions gracefully use DAX to enhance the Power BI user experience use DAX Studio to connect to a Power BI data model and execute simple queries Welcome to Introduction to DAX for Power BI. This two-day instructor-led course is intended for business users who have been using Power BI and want to use DAX to create custom calculations in their data models. In this class, you will be introduced to using Data Analysis Expressions (DAX), which is the expression language that is used to create custom calculations in the Power BI Data model. The course covers some of the theoretical underpinnings of the data model and the DAX language, but the emphasis is on using DAX to solve common business problems. You will learn how to write your own calculated columns, measures, and tables, how to visualize the way Power BI computes DAX calculations, and how to troubleshoot custom code. MODULE 1: GETTING STARTED WITH DAX INTRODUCTION TODAX CREATING OBJECTS WITHDAX CONTEXT AND RULES OF EVALUATION VARIABLES,COMMENTS,AND TESTING MODULE 2: PERFORMING BASIC CALCULATIONS GETTING STARTED IMPLICIT MEASURES ADDING QUICK MEASURES WORKING WITH DAX DATA TYPES . DOING BASIC MATH USING LOGIC IN YOUR CALCULATIONS USING THE IF() FUNCTION NESTED IF() USING THE SWITCH() FUNCTION ADVANCED SWITCH() LOGICAL OPERATORS & FUNCTIONS: ||, OR(), &&, AND(), NOT() AGGREGATING AND SUMMARIZING DATA THE SUM() FUNCTION MODULE 3: WORKING WITH CONTEXT IN THE DATA MODEL CONTEXT DEFINED DATA MODELING BASICS INTRODUCTION TO DIMENSIONAL MODELING RELATIONSHIPS AND THEIR EFFECT ON THE EVALUATION CONTEXT GETTING DATA FROM OTHER TABLES USING RELATED() AND RELATEDTABLE LOOKING UP DATA WITHOUT USING RELATIONSHIPS MODIFYING THE CONTEXT USING CALCULATE() MODULE 4: PERFORMING MORE ADVANCED CALCULATIONS THE DAX ITERATOR FUNCTIONS USING TABLE MANIPULATION FUNCTIONS MODULE 5: WORKING WITH TIME PERFORMING DATE CALCULATIONS WORKING WITH DATE TABLES GENERATING A DATE TABLE WITH THE CALENDAR() FUNCTION DEFINING CUSTOM OPERATING PERIODS YTD, QTD, AND MTD CALCULATIONS CUSTOM TO-DATE CALCULATIONS FINDING YEAR-OVER-YEAR CHANGE FINDING MOVING AVERAGES MODULE 6: ENHANCING THE USER EXPERIENCE CONTROLLING VISIBILITYOF YOUR MEASURES USING WHAT-IF PARAMETERS ADDING BANDING USING DAX TO PROVIDE ROW-LEVEL SECURITY

Duration 2 Days 12 CPD hours This course is intended for This course is designed for people who need output from a database. In some cases, database programs have limited reporting tools, or tools that are not accessible. Learners may or may not have programming or SQL experience. Overview In this course, you will connect to a database to extract data and present it as a report. You will: Identify the elements of the Crystal Reports interface. Create and modify a basic report. Use formulas to calculate and filter data. Build a parameterized report. Group report data. Enhance a report. Create a report using data from an Excel workbook. Distribute data. In this course, students will create a basic report by connecting to a database and modifying the report's presentation. 1 - EXPLORING THE CRYSTAL REPORTS INTERFACE Topic A: Explore Crystal Reports Topic B: Use Crystal Reports Help Topic C: Customize Report Settings 2 - WORKING WITH REPORTS Topic A: Create a Report Topic B: Modify a Report Topic C: Display Specific Report Data Topic D: Work with Report Sections 3 - USING FORMULAS IN REPORTS Topic A: Create a Formula Topic B: Edit a Formula Topic C: Filter Data by Using a Formula Topic D: Work with Advanced Formulas and Functions Topic E: Handle Null Values 4 - BUILDING PARAMETERIZED REPORTS Topic A: Create a Parameter Field Topic B: Use a Range Parameter in a Report Topic C: Create a Prompt 5 - GROUPING REPORT DATA Topic A: Group Report Data Topic B: Modify a Group Report Topic C: Group by Using Parameters Topic D: Create a Parameterized Top N Report 6 - ENHANCING A REPORT Topic A: Format a Report Topic B: Insert Objects in a Report Topic C: Suppress Report Sections Topic D: Use Report Templates 7 - CREATING A REPORT FROM EXCEL DATA Topic A: Create a Report Based on Excel Data Topic B: Modify a Report Generated from Excel Data Topic C: Update Data in a Report Based on Excel Data 8 - DISTRIBUTING DATA Topic A: Export Data Topic B: Create Mailing Labels 9 - APPENDIX Appendix A: Setting Up and Configuring Data Sources Appendix B: Using Report Processing Techniques Appendix C: Using Functions in Formulas

Hone your accountancy skills with professional accountancy tuition from Hone Financial. Delivered online, courses can be tailor made to suit your pace and your requirements

Are you a customs agent/ Importer ? Or does your company use customs agents and intermediaries to help you trade with the EU and the Rest of the World? If so, you need to know how to meet customs requirements fast and efficiently now the new customs declaration system CDS is in place. We can help.

Duration 3 Days 18 CPD hours This course is intended for This course is primarily designed for students who want to gain the skills necessary to use VBA to automate tasks in Excel such as collecting data from external sources, cleaning, and manipulating data. The target student may also want to learn how to create custom worksheet functions to streamline worksheet formulas and make complex worksheets easier to support, maintain, and understand. Overview In this course, you will develop and deploy VBA modules to solve business problems. You will: Identify general components of VBA and their appropriate use in solving business solutions. Record VBA macros to automate repetitive tasks. Use reference tools built into Excel to get help on VBA programming language and objects used in the Excel VBA environment. Write VBA code to create a custom worksheet function. Eliminate, avoid, or handle errors in VBA code, and optimize its performance. Control how and when macros run. Develop UserForm objects to create custom dialog boxes and windows. Use VBA to read and write data from local files and cloud services. Use VBA to clean and transform data. Run programs and commands outside of Excel and share VBA projects with other users VBA (Visual Basic for Applications) enables you to enhance and extend the capabilities of Microsoft© Excel© and other applications in the Microsoft© Office application suite. You can use VBA to perform tasks that would be difficult or impossible to do using only worksheet functions, and you can automate a wide range of tasks involving the collection, processing, analysis, and visualization of data. This course will give you a good foundation for understanding, creating, and using VBA in your own Excel workbooks, show you how to work with data across different applications, and how to package the macros and functions you create so you can back them up, move them to other computers, and share them with other users Prerequisites To ensure your success in this course, you should be an experienced Excel user who is comfortable creating and working with Excel workbooks, including tasks such as entering worksheet formulas, using absolute and relative addressing, formatting cells, and creating pivot tables and charts. This level of skill could be acquired by taking the Microsoft Excel for Office 365? (Desktop or Online) courses, Parts 1, 2, and 3 1 - Using VBA to Solve Business Problems Topic A: Use Macros to Automate Tasks in Excel Topic B: Identify Components of Macro-Enabled Workbooks Topic C: Configure the Excel VBA Environment 2 - Automating Repetitive Tasks Topic A: Use the Macro Recorder to Create a VBA Macro Topic B: Record a Macro with Relative Addressing Topic C: Delete Macros and Modules Topic D: Identify Strategies for Using the Macro Recorder 3 - Getting Help on VBA Topic A: Use VBA Help Topic B: Use the Object Browser to Discover Objects You Can Use in VBA Topic C: Use the Immediate Window to Explore Object Properties and Methods 4 - Creating Custom Worksheet Functions Topic A: Create a Custom Function Topic B: Make Decisions in Code Topic C: Work with Variables Topic D: Perform Repetitive Tasks 5 - Improving Your VBA Code Topic A: Debug VBA Errors Topic B: Deal with Errors Topic C: Improve Macro Performance 6 - Controlling How and When Macros Run Topic A: Prompt the User for Information Topic B: Configure Macros to Run Automatically 7 - Developing Custom Forms Topic A: Display a Custom Dialog Box Topic B: Program Form Events 8 - Using VBA to Work with Files Topic A: Use VBA to Get File and Directory Structure Topic B: Use VBA to Read Text Files Topic C: Use VBA to Write Text Files 9 - Using VBA to Clean and Transform Data Topic A: Automate Power Query Topic B: Transform Data Using VBA and Workbook Functions Topic C: Use Regular Expressions Topic D: Manage Errors in Data 10 - Extending the Programming Environment Beyond the Workbook Topic A: Run Other Programs and Commands Topic B: Share Your VBA Projects

Duration 5 Days 30 CPD hours This one of kind Cisco UC in-depth course takes student from initial endpoint configuration to a full solution deployment using all of the Cisco UC Components. Students will have extensive labs in which they will Administer and troubleshoot a Cisco 12.5 UC Deployment.Participants will gain in-depth practical knowledge with exercises on administering and troubleshooting of all Cisco UC Components. Tools for Managing UC Collaboration 12.5 Prime Collaboration Deployment Manager Overview 12.5 Bulk Admin Tool (BAT) Importing and Exporting Settings Importing and Exporting Users Importing and Exporting Phones Phone Migrations Unsupported IP Phone Models CUCM Upgrades Loading COP Files Unified Communication Manager 12.5 Cisco Smart Licensing Cisco Unified Communication Manager Overview Cisco UCM Configuration Redundancy Services Service Parameters Enterprises Parameters User Configuration LDAP Integration Synchronization Authentication Attribute Mapping Filters Endpoint Configuration Creating and Modifying Phone and Configuration Call Routing Implementing Calling Privileges Partitions and CSSs Configuration Implementing Extension Mobility Media Resources Cisco Meeting Server Troubleshooting UCM Features CAR (CDR Accounting and Reporting) Tool Reports Dialed Number Analyzer RTMT Log Collection Use RTMT to View Performance Counters Troubleshooting Common Endpoint Registration Issues Disaster Recovery System Remote Site Redundancy Gateway Gateway Overview Cisco H323 Gateways Cisco MGCP Gateways Cisco IOS SIP Gateways Troubleshooting IOS Gateways Cisco Emergency Responder (CER) 12.5 CER Overview Emergency Notifications CER Redundancy and Clustering Integration with CUCM Cisco Emergency Responder Administration Interfaces Configuring Users and Role-Based System Access Configuring Cisco Emergency Responder Notification by IP Subnet SNMP Overview Adding new switches Notification by Switch Port Cisco Unified Communications Mobile and Remote Access (MRA) MRA Overview Expressway Edge MRA Licensing MRA Components Certificates Integrating Cisco Unified IM and Presence 12.5 IM&P and Jabber Overview Configure Service Discovery DNS Record Requirements Install Cisco Jabber Cisco Jabber in Softphone Mode Set Up Cisco Jabber in Full UC Mode Integrating CUCM and IM&P Configuring CUCM Services for Jabber Troubleshooting Jabber Integrating Cisco Unity Connection 12.5 Cisco Unity Connection Overview Cisco Unity Connection Integration Using SIP Cisco Unity Connection Call Handlers Configuring Search spaces and Partitions Cisco Unity Connection Administration Cisco Unity Connection Integration Troubleshooting Tools RTMT Using Port Monitor to Troubleshoot Voice Mails Cisco Unity Audiotext Application Unified Messaging Cisco Meeting Server (CMS) Introduction to Cisco Meeting Server Configuring CMS Configuring Meetings with CMS Configuring Spaces with CMS Scheduling Meeting with TMS Cisco UCCX Cisco Unified Contact Center Express Overview Cisco Unified Contact Center Express Administration Agents Skills Queues Basic Scripting (Overview) Finesse Reporting CUIC Cisco Paging Server (InformaCast) InformaCast Overview InformaCast Administration IP Phone Paging Analog Paging Multicast Requirements Using InformaCast Troubleshooting Using Troubleshooting Methodology Analyze the Troubleshooting Process Troubleshooting Methodology in Complex Environments Define the Problem Gather Facts Consider Possibilities Create an Action Plan Implement an Action Plan Observe Results Restart the Problem-Solving Process Document Facts Using Troubleshooting and Monitoring Tools Cisco Unified Serviceability Cisco Unified RTMT Performance Monitor and Data Logging Trace File Collection Troubleshooting Common Gateway and Endpoint Registration Issues IP Phone Initialization Common DHCP-Related and TFTP-Related Issues Using Ping to Cisco IP Phones Cisco Unified IP Phone Status Messages Cisco Unified IP Phone Network Configuration Additional course details: Nexus Humans Administering Cisco Unified Communications (Call Manager) (ACUCC v12.5) training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the Administering Cisco Unified Communications (Call Manager) (ACUCC v12.5) course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.