• Professional Development
  • Medicine & Nursing
  • Arts & Crafts
  • Health & Wellbeing
  • Personal Development

210 Courses in Birmingham

Excel - introduction (In-House)

By The In House Training Company

This one-day workshop is designed to give you an awareness of the fundamentals of Microsoft Excel and, in particular, to give you the confidence needed to efficiently create, edit and manage spreadsheets. This course will help participants: Create tables Use functions Manage rows and columns Write formulas Manage sheets Use content formats Handle larger tables Create reports and charts 1 Creating a table Creating an Excel table from scratch Wrapping text in cells Speeding up data entry using AutoFill Sorting columns 2 Inserting function Inserting function calculators Using AutoSum to sum numbers Statistical calculations AVERAGE, MAX and MIN 3 Table rows and columns Inserting and deleting rows and columns Adjusting multiple column widths and row heights Hiding and unhiding rows and columns 4 Formula writing The basics of formula writing Understanding mathematical symbols Using multiple mathematical symbols in a formula When to use brackets Troubleshooting calculation errors 5 Managing sheets Inserting, renaming, moving and deleting sheets Copying a worksheet to another file Copying a table to another sheet 6 Managing content formats Applying data formats Managing number formats Controlling formats with the Format Painter 7 Managing larger tables Applying freeze panes to lock tables when scrolling Sorting on multiple columns Using filters to extract table information 8 Creating and modifying charts Creating a pie chart Creating a column chart Inserting chart titles and data labels Controlling chart formatting Changing chart types 9 Printing Previewing and printing tables and charts Modifying page orientation Adjusting print margins Printing a selection 10 Calculating with absolute reference The difference between a relative and absolute formula Changing a relative formula to an absolute Using $ signs to lock cells when copying formulas 11 Pivot tables Create a pivot table report Insert a pivot chart into a report

Excel - introduction (In-House)
Delivered in Harpenden or UK Wide or OnlineFlexible Dates
Price on Enquiry

Excel - advanced (In-House)

By The In House Training Company

Most people only use a fraction of Excel's capabilities. This workshop shows what you've been missing! This course will help participants: Nest formulas Get the most from pivot tables Use conditional formatting Write array formulas Explore the lookup functions Calculate by criteria Use 'goal seek' and 'scenario manager' for what-if analysis Record macros 1 Nesting formulas Principles of nesting formulas together Using IF with AND or OR to answer questions Nesting an AND function in an IF Nesting an OR function in an IF 2 Advanced pivot table reports Grouping dates, numerical and text items Running percentage analyse Running analyses to compare data Inserting Field calculations Finishing off with a user-friendly dashboard 3 Advanced conditional formatting Colour table rows based on criteria in it Applying colour to approaching dates Exploring the different rule types 4 Lookup functions Going beyond the VLOOKUP function Lookups that retrieve data from left or right The versatile INDEX and MATCH functions Retrieving data from columns with duplicates 5 Calculate by criteria Using SUMIFS to sum by criteria Finding an average by criteria with AVERAGEIFS Use SUMPRODUCT to multiply then add different values 6 What-if analysis Use Goal Seek to meet targets Forecast reports with the Scenario Manager 7 Recording Macros Macro security Understanding a Relative References macro Recording, running and editing macros Saving files as Macro Enabled Workbooks Introduction to VBA code Making macros available across workbooks Add a macro button to the Quick Access toolbar

Excel - advanced (In-House)
Delivered in Harpenden or UK Wide or OnlineFlexible Dates
Price on Enquiry

Excel - intermediate (In-House)

By The In House Training Company

This one-day course focuses on issues such as writing formulas and accessing help while writing them, and taking formulas to the next level by nesting one inside another for a powerful formula result. It also looks at ways of analysing data with reports, summarised by varying criteria. A range of time-saving tips and tricks are shared. This course will help participants: Calculate with absolute reference Group worksheets Link to tables Use the function library effectively Get to grips with the logical IF function Use conditional formatting Create pivot table reports Use data validation Master the VLOOKUP function 1 Calculating with absolute reference The difference between a relative and absolute formula Changing a relative formula to an absolute Using $ signs to lock cells when copying formulas 2 Grouping worksheets Grouping sheets together Inputting data into multiple sheets Writing a 3D formula to sum tables across sheets 3 Linking to tables Linking to a source table Using paste link to link a table to another file Using edit links to manage linked tables 4 The function library Benefits of writing formulas in the function library Finding the right formula using insert function Outputting statistics with COUNTA and COUNTBLANK Counting criteria in a list with COUNTIFS 5 Logical IF Function Outputting results from tests Running multiple tests for multiple results The concept of outputting results from numbers 6 Conditional formatting Enabling text and numbers to standout Applying colour to data using rules Managing rules Copying rules with the format painter 7 View side by side Comparing two Excel tables together Comparing two sheets together in the same file 8 Pivot table reports Analysing data with pivot tables Managing a pivot table's layout Outputting statistical reports Controlling number formats Visualising reports with pivot charts Inserting slicers for filtering data 9 Data validation Restricting data input with data validation Speeding up data entry with data validation 10 VLOOKUP function Best practices for writing a VLOOKUP A false type lookup A true type lookup Enhance formula results with IFNA 11 Print options Getting the most from print Printing page titles across pages Scaling content for print

Excel - intermediate (In-House)
Delivered in Harpenden or UK Wide or OnlineFlexible Dates
Price on Enquiry

Risk Assessing

By Prima Cura Training

This course is designed to enable learners to increase their understanding of risk assessment and risk management in Health and Social Care settings.

Risk Assessing
Delivered in person or OnlineFlexible Dates
Price on Enquiry

Health & Safety in the Care Sector

By Prima Cura Training

This Health & Safety in the Care Sector Course works alongside, and helps, learners understand Standard 13 of the Care Certificate. This Standard touches on the legislation, policies & responsibilities relating to Health & Safety in the care sector, as well as looking at accidents and sudden illnesses.

Health & Safety in the Care Sector
Delivered in person or OnlineFlexible Dates
Price on Enquiry

We will help you to find the right course for you

By EU Network

Foundation Year, Bachelors degree, Masters, no IELTS needed, Student finance support

We will help you to find the right course for you
Delivered In-Person in London + 1 more or UK WideFlexible Dates
FREE

COSHH & RIDDOR

By Prima Cura Training

This course aims to provide a more in depth understanding of COSHH & RIDDOR.

COSHH & RIDDOR
Delivered in person or OnlineFlexible Dates
Price on Enquiry

Boardroom Conflicts! - Causes and Cures

By Ralph Ward

Pushy boardroom bullies... battling agendas... conflicts of interest. Here are the most common drivers of trouble in the boardroom, and tools for making things right.

Boardroom Conflicts! - Causes and Cures
Delivered in Riverdale or UK Wide or OnlineFlexible Dates
Price on Enquiry

Safeguarding Children (Awareness to L3)

By Prima Cura Training

To increase your awareness and understanding of what safeguarding children means, in order to increase your confidence to enable you to make a positive contribution towards the process.

Safeguarding Children (Awareness to L3)
Delivered in person or OnlineFlexible Dates
Price on Enquiry

Moving & Positioning (People)

By Prima Cura Training

Working within Heath and Social Care settings often involves moving, lifting, or otherwise manually handling the people within your care. This moving and handling training course is designed to educate learners regarding both the requirements and risks associated with moving people safely. Learners will also participate in practical moving & positioning enabling competency sign-off.

Moving & Positioning (People)
Delivered In-PersonFlexible Dates
Price on Enquiry

Educators matching " Finance"

Show all 103
Leadership Partners

leadership partners

London

Providing pre-deal analysis and due diligence for Private Equity teams or companies involved in transactions in the CRO and pharmaceutical field. Our experienced management, commercial operations and financial partners and associates provide a unique perspective on deal potential. MANAGEMENT DEVELOPMENT Bespoke training courses developed and delivered globally across the CRO, Pharma, Manufacturing and Legal business sectors. The programme delivers specific finance and business training solutions in a highly competitive environment using experiential learning techniques via a deceptively simple industry-specific board game for teams of 2-6 players. COMPANY DEVELOPMENT Catalyzing the development of companies. We help you identify the potential within your organization and the industry and provide the framework to take your company to the next level. STRATEGIC CRO PARTNERSHIPS With a unique perspective on the pharmaceutical and CRO industries we work with you to identify and understand current outsourcing practices and, through an interactive process, work with you to develop a solution to meet your needs for the future. SALES SKILLS TRAINING Bespoke courses, skills analysis and mentoring services led by experienced business developers and experts in relationship management. A combination of real-life scenarios and role-play provides your sales teams with a highly realistic environment within which to fine-tune their RFP management, bid-defence and communication skills. OUTSOURCING & PROJECT FINANCE Experienced staff provide virtual, biotech & pharma companies with innovative solutions ranging from support and training for existing staff, through to management of specific outsourcing projects including RFP preparation, negotiation and contract execution. We can even help you manage your financial and commercial relationships with your selected CRO providers.

The Finance And Management Business School

the finance and management business school

2.7(17)

Birmingham

Welcome to FMBS, one of the UK’s leading providers of training for unemployed people and those looking to reskill. Our offer is designed to deliver programmes which help people improve their lives by delivering a range of affordable programmes across many sectors which are free to most learners. Our training programmes will enable those wanting to gain employment to do so rapidly through undertaking courses which are delivered over a short period of time, at times convenient to you and with additional support to enable you to overcome any additional barriers to employment you may have such as an inability to afford AAT Membership Fees, Forklift Licences and SIA Security Licences. Our records show that the majority of learners who complete our programmes progress into employment. For those looking to reskill we offer a range of blended learning solutions which will enable you to study in your own timeframe whether you want to learn at home, on the go or in a College environment. Our programmes are chosen to link into areas with skills shortages such as Bookkeeping. Evidence suggests that people who are better qualified earn higher salaries so adding qualifications to your CV will not only help you climb the career ladder they will also enable you to earn more money! Our expert teaching team have many years’ experience in delivering the qualifications we offer giving you the confidence and support you need to succeed. We look forward to welcoming you to an FMBS centre very soon to begin your qualification, employment and/ or job improvement journey! Jacqueline Cope, Trudi Gunning & Chris Levitt The Finance & Management Business School

Aspire People and Business Development

aspire people and business development

ASPIRE CONSULTING AND TRAINING LTD specialises in providing tailored solutions to assist companies in cultivating employee engagement and executing strategic objectives. Employing contemporary theories, cutting-edge techniques, and proven methodologies, we craft straightforward yet impactful learning solutions tailored to the evolving landscape. In essence, we facilitate the alignment of your workforce with your business strategy, fostering active participation in its realisation. Our mission is to enhance your understanding of the business landscape, propelling you to the next echelon. In today's dynamic environment, the key differentiator lies in the implementation of precise training solutions. We are committed to guiding your team in reshaping mindsets, concentrating on pivotal priorities, and taking decisive actions that translate your strategy into tangible results. Despite being a small company, we boast a global footprint, offering Management and Leadership Training across Europe, Asia, The GCC, and North America. Leveraging our extensive knowledge, skills, and experience, we have collaborated with distinguished companies spanning diverse sectors such as Oil and Gas, Finance, Travel and Hospitality, Ministry and Government, Education, and Health and Social Care. Additionally, we extend our support to new enterprises, start-ups, and businesses at various stages of development. Our mentorship and coaching services acknowledge the unique challenges faced by these ventures, recognizing that they often possess ambitious plans without a clear roadmap to achievement. Our values epitomise our commitment as we strive to INFLUENCE and EMPOWER, ultimately contributing to the SUCCESS of our clients.

Trading 402

trading 402

London

My name is M. R. Naveed and I’m a Property Investor, Serviced Accommodation Business Owner, Fulltime Day Trader and the founder of Trading 402. The reason behind establishing Trading 402 was to fill the gap left by the main stream traders who spend 1000s on Marketing funnels to reach to 1000s to sell their course which haven’t really benefited the students and i feel the main reason behind that is the reason why those courses were sold to those students and the sole reason was not to make students money but to fill the so called coaches pockets. On the other hand my approach is simple my objective is to get people out of their 9-5 jobs the modern slavery they are in. And what’s different about my training course is the passion, energy and personal touch. I take every students success personally because the intention behind these training course isn’t to make me money but to train my students to be independent day traders so that they are able to make this a career and have this as their main stream of income. The end goal for Trading 402 community is to earn freedom of these 3 kinds. 1. Freedom of Location Everyone should be able to make money no matter where they are. Making money doesn’t mean you should be stuck behind your desk fixed a location in a corporate office. Aim is to make money from anywhere in the world as long as you have laptop with fast internet connection. 2. Freedom of Time I believe there should be fixed hours of work where you feel prisoned for those hours. Day Trading even though very risky but if learnt it can make a huge difference in your day to day life and how much time you can buy back for you to enjoy that time with your loved ones and on yourself and maybe on something you really love doing whether is helping the less fortunate, helping a charity, spending more time for your LORD, Whatever that maybe. 3. Freedom of Money No one should struggle to make ends meat. Even though day trading is extremely risky, once learnt and enough efforts made to get your head around it. it could be extremely rewarding financially which could eventually change everything for you and your loved ones.