58 Courses in Birmingham

This course starts with the basics then moves seamlessly to an intermediate level. It includes a comprehensive yet balanced look at the four main components that make up Power BI Desktop: Report view, Data view, Model view, and the Power Query Editor. It also demonstrates how to use the online Power BI service. It looks at authoring tools that enables you to connect to and transform data from a variety of sources, allowing you to produce dynamic reports using a library of visualisations. Once you have those reports, the course looks at the seamless process of sharing those with your colleagues by publishing to the online Power BI service. The aim of this course is to provide a strong understanding of the Power BI analysis process, by working with real-world examples that will equip you with the necessary skills to start applying your knowledge straight away. 1 Getting started The Power BI process Launching Power BI Desktop The four views of Power BI Dashboard visuals 2 Connecting to files Connect to data sources Connect to an Excel file Connect to a CSV file Connect to a database Import vs. DirectQuery Connect to a web source Create a data table 3 Transforming data The process of cleaning data Column data types Remove rows with filters Add a custom column Append data to a table Fix error issues Basic maths operations 4 Build a data model Table relationships Manage table relationships 5 Merge queries Table join kinds Merging tables 6 Create report visualisations Creating map visuals Formatting maps Creating chart visuals Formatting chart Tables, matrixes, and cards Control formatting with themes Filter reports with slicers Reports for mobile devices Custom online visuals Export report data to Excel 7 The power query editor Fill data up and down Split columns by delimiter Add conditional columns Merging columns 8 The M formula Creating M functions Create an IF function Create a query group 9 Pivot and unpivot tables Pivot tables in the query editor Pivot and append tables Pivot but don't summarise Unpivot tables Append mismatched headers 10 Data modelling revisited Data model relationships Mark a calendar as a date table 11 Introduction to calculated columns New columns vs. measures Creating a new column calculation The SWITCH function 12 Introduction to DAX measures Common measure categories The SUM measure Adding measures to visuals COUNTROWS and DISINCTCOUNT functions DAX rules 13 The CALCULATE measure The syntax of CALCULATE Things of note about CALCULATE 14 The SUMX measure The SUMX measure X iterator functions Anatomy of SUMX 15 Introduction to time intelligence Importance of a calendar table A special lookup table The TOTALYTD measure Change year end in TOTALYTD 16 Hierarchy, groups and formatting Create a hierarchy to drill data Compare data in groups Add conditional formatting 17 Share reports on the web Publish to the BI online service Get quick insights Upload reports from BI service Exporting report data What is Q&A? Sharing your reports 18 Apply your learning Post training recap lesson

SAP Training Online | Sap Training in London, UK What is SAP? SAP is one of the largest ERP(Enterprise Resource Planning) software in the world. It provides end to end solution for Financials, Manufacturing, Logistics, Distributions etc. SAP applications, built around their latest R/3 system, provide the capability to manage financial, asset, and cost accounting, production operations and materials, personnel, plants, and archived documents. The R/3 system runs on a number of platforms including Windows and MAC and uses the client/server model. SAP Career Potential You can become a SAP consultant. SAP consultants analyze, design, and configure new computer software and systems in accordance with their employers' or clients' specifications, as well as write programs such as forms, specifications, and interfaces. They also test new interfaces to ensure that system workflows are optimized and interact with end-users to make changes as requested and obtain feedback. As a SAP consultant, you could expect to earn £80,000-£150,000 per year. Which SAP Module Osborne Training offers training on various sap modules such as  Financial and Controlling Sales and Distribution Material Management CRM SRM HANA And many more... Study Options Instructor-Led Live SAP Online Training Students attending training through Online LIVE Training have a real-time, Live Instructor-Led student experience through the world-class Virtual Learning Campus. Online LIVE Training provides an engaging live classroom environment that allows students to easily interact with instructors and fellow students virtually. Classroom-Based Live SAP Training in London Osborne Training offers evening sessions for classroom-based training, where an experienced Tutor/Consultant goes through the whole SAP Training course from the London campus. Only selected modules are offered from the London campus. Free Certification from Osborne Training on completion. You may attempt for SAP certification exams online to get certificate directly from SAP. Syllabus varies depending on the module take. Please send a query to receive full syllabus information.

Why do you need CPD Courses? CPD stands for Continuous Professional Development. As an accountant, it is vital to gain CPD points to comply with Professional Accounting Bodies (such as ACCA, AAT, CIMA, ICAEW etc.) requirement and to retain your membership. CPD Course Overview You can join various practical accounting cpd courses designed to build the bridge between knowledge and practical aspects of accounting and tax. With this cpd courses many modules of tax and accounting are covered in addition to Computerised Accounting & Payroll. After completing the cpd training you will have the chance to get hands on experience which will open the door for highly paid jobs in Accounting, Tax & Payroll sector. CPD Training Method Classroom Based - Osborne Training offers Daytime or Weekend sessions for accounting CPD Training Courses in London. Online Live - Osborne Training offers Evening or Weekend sessions for online CPD Training Courses through Virtual Learning Campus. A course certificate from Osborne Training, confirming CPD Points and Completion. Total Accounting Training with Job Placement Total Taxation Training Corporation Accounting and Tax Return Income Tax Return Advanced Excel Training

Total Accounting Courses It is a comprehensive practical accountancy training programme designed to build the bridge between knowledge and practical aspects of accounting and tax. With this programme various modules of tax and accounting are covered as well as Computerised based Accounting & Payroll. After completion of the modules you will have the chance to get hands on practical work experience which will open the door for lucrative Accounting, Tax & Payroll sector. Duration Accountancy Training: 10-12 Weeks (Weekdays/weekend/Evening) Accounting Work Experience 3 Months after the training You can start anytime of the year. The training takes place once each week. Once you finish your training modules then you can start job placement. What accounting jobs will I qualify for? Tax advisor Tax consultant Payroll Consultant Finance Officer Financial Accountant In these roles, you could earn up to £42,000 per annum (source: reed Salary Checker, UK Only). Benefits for Trainees Completion of this training will open new doors to exciting careers, as well as extending current skills if you are currently employed Free Job Placement(optional) Start your own accountancy Practice Work in a wide range of businesses Update your knowledge on tax and accountancy Improve your employability prospects A career path into tax and accountancy Ideal Continuing Professional Development course Gain a qualification to boost your CV Start your training soon without having to wait long for the new term to begin Free Tablet PC when paying in full upfront Gain Verifiable CPD Units Accounting Courses Contents Advanced Excel Bookkeeping VAT Training - Preparation and Submission Personal Tax Return Training Company Accounting and Tax Training Sage 50 Accounting Training Sage Payroll Training Accounting work experience (optional)

Course Objectives At the end of this course you will be able to: Do advance Table design Do advance Query design and Action Querys Do advance Form design with the use of macros and buttons Export and import data to and from different sources. 1 year email support service Take a look at the consistent excellent feedback from our corporate clients visiting our site ms-officetraining co uk With more than 20 years experience, we deliver courses on all levels of the Desktop version of Microsoft Office and Office 365; ranging from Beginner, Intermediate, Advanced to the VBA level. Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering public, one to one, tailored and bespoke courses. Our competitive rates start from £550.00 per day of training Tailored training courses: You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs. Advanced Table Design Advanced Field Properties Table Properties Advanced Query Design Advanced Naming Conventions Join Tables in Queries Manage Query Joins Use Self-Joins in Queries Summarise Data in Queries Parameter Queries Action Queries Crosstab Queries Advanced Form Design Create Subforms and Linked Forms Form Controls Command Buttons Form Properties Interface, Start-Up and Navigations Forms Working with Macros Create Single Macros Run Macros Work with Sub Macros Use Conditional Macros Run Macros from Buttons Assign Macros to Events Extending Data Reach Import Data Export Data Work with Linked Tables Managing Databases Object Dependencies Database Documenter Performance Analyzers Regular Management of a Database Access Database Security Who is this course for? Who is this course for? The course is aimed at all users who would like to obtain the necessary skills to create advanced table, query, form and reports as well as to automate tasks with the use of macros. Career path Career path Microsoft Office know-how can instantly increase your job prospects as well as your salary. 80 percent of job openings require spreadsheet and word-processing software skills

This one-day workshop is intended for participants who have a basic understanding of Outlook but who want to know how to use its advanced features to manage their email communications, calendar events, contact information and other communication tasks. This course will help participants: Gain confidence using Outlook and its advanced features Organise and prioritise email messages Archive messages for safe-keeping Use rules to process received or sent messages automatically Manage scheduled meetings with others Give others permission to view and manage their folders and items Use contacts and commands to find out more about a person or company Prioritise work-flow using tasks and assigning tasks to others 1 Email messages Combining multiple clicks with quick steps Following up flag options Saving multiple attachments Attaching a folder of files Recalling and replacing a message Categorising messages with conditional formatting 2 Message options Adding options to messages Marking a message as private Receiving quick responses with voting buttons Directing replies to specific users Delaying sent messages Inserting links in messages 3 Stay organised with rules Using rules to automate message flow Moving messages with rules Using the rules wizard Setting up rules with conditions Using rules that work whilst you are away 4 Message clean-up Using conversation clean-up Using mailbox clean-up Moving messages to the archive folder Archiving folder properties Auto-archiving properties 5 Managing calendars Creating calendar groups Sharing calendars with permissions Setting up working days and times Managing time zones Categorise appointments with conditional formatting Publishing a calendar 6 Schedule meetings Scheduling a meeting Managing meeting responses Proposing new meeting times Adding attendees to a meeting Viewing multiple appointments 7 Using contacts Merging contacts to letters Merging contacts to labels Mail merging contacts in Word Exporting contacts to Excel 8 Managing tasks Organising your workload with tasks Categorising tasks Assigning tasks to others Sending a task status report Allocating time for tasks Regenerating a new task Viewing your tasks in the calendar 9 Adding message items Adding calendars to messages Adding business cards to messages 10 Email accounts Adding multiple user accounts Adding account permissions

There is a lot to learn in Power BI, this course takes a comprehensive look at the fundamentals of analysing data and includes a balanced look at the four main components that make up Power BI Desktop: Report view, Data view, Model view, and the Power Query Editor. It also demonstrates how to utilise the online Power BI service. It looks at authoring tools that enable you to connect to and transform data from a variety of sources, allowing you to produce detailed reports through a range of visualisations, in an interactive and dynamic way. It also includes a detailed look at formulas by writing both M functions in Power Query, and DAX functions in Desktop view. This knowledge will allow you to take your reports to the next level. The aim of this course is to provide a complete introduction to understanding the Power BI analysis process, by working hands-on with examples that will equip you with the necessary skills to start applying your learning straight away. 1 Getting Started The Power BI ecosystem Opening Power BI Desktop Power BI's four views Introduction to Dashboards 2 Importing Files Importing data sources Importing an Excel file Importing a CSV file Importing a database Connect to an SQL Server Database Import vs. Direct Query Importing from the web Importing a folder of files Managing file connections 3 Shape Data in the Query Editor The process of shaping data Managing data types Keeping and removing rows Add a custom column Appending tables together Hiding queries in reports Fixing error issues Basic maths operations 4 The Data Model Table relationships Relationship properties 5 Merge Queries Table join kinds Merging tables 6 Inserting Dashboard Visuals Things to keep in mind Inserting maps Formatting Maps Inserting charts Formatting Charts Inserting a tree map Inserting a table, matrix, and card Controlling number formats About report themes Highlighting key points Filter reports with slicers Sync slicers across dashboards Custom web visuals 7 Publish and share Reports Publishing to Power BI service Editing online reports Pinning visuals to a dashboard What is Q&A? Sharing dashboards Exporting reports to PowerPoint Exporting reports as PDF files 8 The Power Query Editor Fill data up and down Split column by delimiter Add a conditional column More custom columns Merging columns 9 The M Functions Inserting text functions Insert an IF function Create a query group 10 Pivoting Tables Pivot a table Pivot and append tables Pivot but don't aggregate Unpivot tables Append mismatched headers 11 Data Modelling Expanded Understanding relationships Mark a date table 12 DAX New Columns New columns and measures New column calculations Insert a SWITCH function 13 Introduction to DAX Measures Common measure functions Insert a SUM function Insert a COUNTROWS function Insert a DISTINCTCOUNT function Insert a DIVIDE function DAX rules 14 The CALCULATE Measure The syntax of CALCULATE Insert a CALCULATE function Control field summarisation Things of note 15 The SUMX measure X iterator functions Anatomy of SUMX Insert a SUMX function When to use X functions 16 Time Intelligence Measures Importance of a calendar table Insert a TOTALYTD function Change financial year end date Comparing historical data Insert a DATEADD function 17 Hierarchies and Groups Mine data using hierarchies Compare data in groups

This comprehensive course, developed in line with the esteemed guidelines of the Resuscitation Council (UK), Skills for Health, and the Faculty of Pre-Hospital Care (RCS Ed), is designed to enhance your abilities in delivering superior emergency care across various settings.

R&D work is often carried out in entrepreneurial companies with the aim of developing solutions to scientific or technological problems for a wide range of customers. Projects can include longer term 'frontiers of science' research, medium term product development/manufacturing or more immediate troubleshooting or contract research assignments. In all these contexts, the ability to create innovative solutions in a timely and cost-effective manner is the essence of successful R&D. Whilst R&D groups typically excel in technical expertise, those involved often recognise that there is scope for improving the way that projects are managed. The aim of this training programme is to address this need whilst ensuring that the creative, entrepreneurial spirit that is fundamental to good R&D continues to flourish. MODULE 1: Creating the foundations for success Off-line video tutorials and exercises Total time ~ 1 - 1.5 hours Video 1: Making the most of project management in R&D Characterising R&D projects Applying project management to R&D work Exploiting the potential of project management in R&D Video 2: Promoting success in R&D project management Modelling successful project management Evaluating performance and promoting success The role and skills of the project manager/leader MODULE 2: Initiating and defining R&D projects Live interactive sessions (via Zoom): Session 1: 10:00 - 12:00 Session 2: 14:00 - 15:30 Session 1: Selecting and initiating projects Recognising worthwhile opportunities; initiating projects Identifying stakeholders and their goals Characterising and engaging stakeholders Session 2: Defining goals and agreeing deliverables Establishing the full scope of the project Clarifying and prioritising project deliverables Defining and agreeing deliverable specifications MODULE 3: Planning R&D projects Live interactive sessions (via Zoom): Session 1: 10:00 - 12:00 Session 2: 14:00 - 15:30 Session 1: Identifying and organising activities Creating effective plans; avoiding planning pitfalls Identifying tasks and assigning responsibilities Sequencing tasks and estimating durations Session 2: Developing the timeline and resource plan Identifying the 'critical path'; creating a resource plan Dealing with estimating uncertainty Accelerating the programme MODULE 4: Leadership and teamwork in R&D projects Off-line video tutorials and exercises Total time ~ 1 - 1.5 hours Video 1: Working effectively in project teams Building teamwork in contemporary organisations Recognising each other's skills; building synergy Building good working relationships; handling conflict Video 2: The role of the R&D project team leader Building teamwork: the role of leadership Creating an effective team culture Delegating work and motivating team members MODULE 5: Managing uncertainty in R&D projects Live interactive sessions (via Zoom): Session 1: 10:00 - 12:00 Session 2: 14:00 - 15:30 Session 1: Characterising uncertainty; identifying risks Exploring uncertainty; applying risk management Focusing the risk management process Identifying and defining risk events Session 2: Managing and controlling risks to the project Evaluating risk events Selecting between risk strategies; setting contingencies Updating and controlling exposure to risk MODULE 6: Implementing and controlling R&D projects Live interactive sessions (via Zoom): Session 1: 10:00 - 12:00 Session 2: 14:00 - 15:30 Session 1: Initiating assignments and managing changes Creating a pro-active implementation and control culture Establishing effective implementation and control procedures Assigning work and managing changes Session 2: Monitoring, managing and developing performance Adopting meaningful monitoring techniques Responding to problems; building performance Managing and controlling multiple project assignments

This 3 Days programme will equip you to use, price, manage and evaluate interest rate and cross-currency derivatives. The course starts with the building blocks of money markets and futures, through yield curve building to interest-rate and cross-currency swaps, and applications. The approach is hands-on and learning is enhanced through many practical exercises covering hedging, valuation, and risk management. This course also includes sections on XVA, documentation and settlement. The programme includes extensive practical exercises using Excel spreadsheets for valuation and risk-management, which participants can take away for immediate implementation.