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

21 Money Management Tools courses in Birmingham

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

Online Options

Show all 670

Real Estate Investor (Advanced Development Cash Flow Modelling in Excel)

4.3(5)

By Bayfield Training

The Real Estate Investor course primarily focuses on financial modelling and commercial considerations in the real estate industry across various sectors, geographies, and project types.

Real Estate Investor (Advanced Development Cash Flow Modelling in Excel)
Delivered in person or Online + more
£2,000

Excel - Automating Excel with Macros and Analysis Tools

By Nexus Human

Duration 1 Days 6 CPD hours This course is intended for To ensure success, students should have completed Excel Essentials and Excel Functions Including Pivot Tables and Lookups or have the equivalent knowledge and experience. Overview Upon successful completion of this course, students will be able to enhance productivity and efficiency by streamlining workflow, collaborate with others, and audit and analyse data. This course is designed for students desiring to gain skills necessary to create macros, collaborate with others, audit and analyse data, incorporate multiple data sources, and import data. Working with Multiple Worksheets and Workbooks Working with Named Ranges Link Cells Across Worksheets and Workbooks Use 3D References to Calculate Across Worksheets Consolidate Data Use Formula Auditing and Error Checking Reveal Formulas Trace Cell Precedents and Dependents Locate Errors in Formulas Watch and Evaluate Formulas Reviewing and Protecting Workbooks Control Data Entry via Data Validation Protect Workbook Access Protect Worksheets and Cell Content Add and Edit Comments Prepare a Workbook for Distribution Modify Excel's Default Settings Using Macros to Automate Workbook Functionality Create Macros via Recording Run Macros via Buttons and Shortcuts Assign Macros to the Quick Access Toolbar and Ribbon Assign Macros to Objects View Macro Code Forecasting and Analysis Data Use Conditional Formatting to Highlight, Sort and Filter Key Data Advanced Conditional Formatting using Formulas Create Sparklines to Visualise Data Add Trendlines to Charts to Visualise and Forecast Trends Use Data Tables and Scenarios to Project Potential Outcomes Use Goal Seek to Calculate Outcomes Forecast Data Trends Using Solver

Excel - Automating Excel with Macros and Analysis Tools
Delivered Online
£197

Real Estate Modelling Masterclass (Advanced Cash Flow Modelling)

4.3(5)

By Bayfield Training

This course is intended to the most ambitious modellers in the property industry who would like to be fully proficient in building complex real estate models.

Real Estate Modelling Masterclass (Advanced Cash Flow Modelling)
Delivered in person or Online + more
£1,500

Understanding Key Principles of Real Estate Modelling (Advanced Theoretical Course)

4.3(5)

By Bayfield Training

On this course, we will use case studies to enhance the delegates understanding of Real Estate financial appraisals, and help them fully appreciate the theory behind the numbers.

Understanding Key Principles of Real Estate Modelling (Advanced Theoretical Course)
Delivered in person or Online + more
£950

Excel - Excel Essentials and Formulas

By Nexus Human

Duration 1 Days 6 CPD hours This course is intended for To ensure success, students will need to be familiar with using personal computers and should have experience using a keyboard and mouse. Students should also be comfortable working in the Windows environment and be able to manage information on their computers. Overview Upon successful completion of this course, you will be able to create and develop Excel worksheets and workbooks in order to work with and analyse the data that is critical to the success of your organisation. This course is intended for those who wish to gain the foundational understanding of Excel that is necessary to create and work with electronic spreadsheets. Excel can help you organise, calculate, analyse, revise, update, and present your data. Getting Started with Excel Navigate the Excel User Interface Use Excel Commands Create and Save a Basic Workbook Enter and Edit Cell Data Fill Cells with Series of Data (AutoFill and Flash Fill) Use Excel Help Performing Calculations Create Worksheet Formulas Insert Functions and use Autocomplete Reuse Formulas and Functions Create an Absolute Reference Modifying a Worksheet Insert, Delete, and Adjust Cells, Columns, and Rows Move and Copy Data between Cells Search for and Replace Data Use Spellcheck and Proofing Formatting a Worksheet Apply Text Formats Apply Number Formats Align Cell Contents Apply and Copy Cell Styles Apply Basic Conditional Formatting Printing Workbooks Preview and Print a Workbook Controlling Page Layout Adding Headers and Footers Set Print Titles and Print Ranges Managing Workbooks Manage Worksheets Insert and Delete Worksheets Manage Workbook and Worksheet Views Manage Workbook Properties

Excel - Excel Essentials and Formulas
Delivered Online
£197

Real Estate Analyst (Investment Cash Flow Modelling in Excel)

4.3(5)

By Bayfield Training

The Real Estate Analyst course has been taught non-stop to global real estate firms over the last 25 years, and is without doubt the core financial modelling training in your career portfolio. Whether you have an upcoming financial modelling test for a new job or an APC exam, the Real Estate Analyst course is the choice for you.

Real Estate Analyst (Investment Cash Flow Modelling in Excel)
Delivered in person or Online + more
£1,750

ROCK Solid®️- Financial Basics Programme for Business Owners

By Peace Together Money Coaching

A six-week self study finance course brought to you by award-winning Financial Adviser and Money Coach Claire Sweet

ROCK Solid®️- Financial Basics Programme for Business Owners
Delivered Online On Demand6 weeks
£295

QuickBooks for Self-Employed Course

By Course Cloud

Course Overview Learn how to easily manage and track your business income and expenditure with this QuickBooks for Self-Employed Course. Professionals who are responsible for their own administration and finances need to master and accomplish personal accounting to succeed in their field. You can gain the awareness to master those skills by using this special accounting software package, which currently dominates the finance sector for the self-employed and independent businesses.  This QuickBooks course guides you simply through the process of setting up a personal account and using it to organise your budget. You will be given expert tuition in all fiscal management applications on the software, from banking and invoicing, right up to producing profit and loss reports for tax purposes. This is the perfect introduction to this valuable financial tool and will enable you to run your business with concern about your money movements and tax deductions. This best selling QuickBooks for Self-Employed Course has been developed by industry professionals and has already been completed by hundreds of satisfied students. This in-depth QuickBooks for Self-Employed Course is suitable for anyone who wants to build their professional skill set and improve their expert knowledge. The QuickBooks for Self-Employed Course is CPD-accredited, so you can be confident you're completing a quality training course will boost your CV and enhance your career potential. The QuickBooks for Self-Employed Course is made up of several information-packed modules which break down each topic into bite-sized chunks to ensure you understand and retain everything you learn. After successfully completing the QuickBooks for Self-Employed Course, you will be awarded a certificate of completion as proof of your new skills. If you are looking to pursue a new career and want to build your professional skills to excel in your chosen field, the certificate of completion from the QuickBooks for Self-Employed Course will help you stand out from the crowd. You can also validate your certification on our website. We know that you are busy and that time is precious, so we have designed the QuickBooks for Self-Employed Course to be completed at your own pace, whether that's part-time or full-time. Get full course access upon registration and access the course materials from anywhere in the world, at any time, from any internet-enabled device.  Our experienced tutors are here to support you through the entire learning process and answer any queries you may have via email.

QuickBooks for Self-Employed Course
Delivered Online On Demand
£319

QuickBooks: Self Employed

By Course Cloud

Course Overview QuickBooks is the leading software for the self-employed, small to medium-sized business owners, and independent contractors. It provides a simple and efficient way to manage self-assessment tax returns. It also is ideal for those who are not VAT registered and use cash accounting. If you are self-employed and are looking to learn how to use QuickBooks for faster, more efficient tax management, then this course is perfect for you. The QuickBooks: Self Employed course is designed to take you through the process of setting up your Quickbooks account on desktop and mobile as a self-employed person. It will walk you through how to set up Quickbooks Self-employed (QSE) and Quickbooks Online (QBO) for small businesses, step-by-step.  Through video tutorials, you will learn how to perform a wide range of accounting and bookkeeping tasks, including how to file a tax return, run financial reports, and create invoices. Get the most of your accounting software for easier, smoother financial management in no time. This best selling QuickBooks: Self Employed has been developed by industry professionals and has already been completed by hundreds of satisfied students. This in-depth QuickBooks: Self Employed is suitable for anyone who wants to build their professional skill set and improve their expert knowledge. The QuickBooks: Self Employed is CPD-accredited, so you can be confident you're completing a quality training course will boost your CV and enhance your career potential. The QuickBooks: Self Employed is made up of several information-packed modules which break down each topic into bite-sized chunks to ensure you understand and retain everything you learn. After successfully completing the QuickBooks: Self Employed, you will be awarded a certificate of completion as proof of your new skills. If you are looking to pursue a new career and want to build your professional skills to excel in your chosen field, the certificate of completion from the QuickBooks: Self Employed will help you stand out from the crowd. You can also validate your certification on our website. We know that you are busy and that time is precious, so we have designed the QuickBooks: Self Employed to be completed at your own pace, whether that's part-time or full-time. Get full course access upon registration and access the course materials from anywhere in the world, at any time, from any internet-enabled device.  Our experienced tutors are here to support you through the entire learning process and answer any queries you may have via email.

QuickBooks: Self Employed
Delivered Online On Demand
£319

Quickbooks Online Course

By Course Cloud

The innovative Quickbooks Online Course has been compiled with the assistance and expertise of industry professionals. It has been carefully crafted to meet the business requirements needed for an outstanding contribution to this role and the career path beyond it. By enrolling in this tutorial, a significant advantage can be gained by the student for securing their dream job and building an excellent reputation in this sector.  This popular Quickbooks Online Course has been designed to help dedicated individuals train to become the absolute best in this business field. Many other entrepreneurs and talented students have already completed this course, and others like it, empowering them to move onto satisfying and rewarding careers. This unique Quickbooks Online Course course is perfectly suited for those dedicated and ambitious individuals who are committed to genuinely becoming the best in the business.  The Quickbooks Online Course is recognised and accredited by CPD standards, so all contents are guaranteed to be accurate and reputable, adding valuable competencies and qualifications to a CV, making anyone stand out from other potential candidates or business rivals. For added convenience, the Quickbooks Online Course consists of a range of educational modules that allow study sessions to be organised at any time and any place When the final assessment of the Quickbooks Online Course has been completed, a certificate of completion is supplied to evidence newly acquired skills and knowledge. This will provide a significant boost for job-seeking or entry into a new and exciting career path. The valuable qualification from the Quickbooks Online Course course can help to make all the difference in a dynamic employment sector and can also be validated on our website. We are aware that a student's lifestyles and work ethics may not allow much time for a dedicated study session, so the Quickbooks Online Course has been specifically designed to be taken at a personally selected pace, and the hours that are suited to each individual. Full access is immediately available after registration, and this can be achieved via any online device, and at any global location you are sighted at. Our fully-trained tutors are committed to helping you throughout the course, and will instantly respond to any queries that are sent to them via email.

Quickbooks Online Course
Delivered Online On Demand
£319

Educators matching "Money Management Tools"

Show all 10
Sandwell College

sandwell college

West Bromwich

We are delighted that you are considering Sandwell College to prepare you for your next step towards university or employment. Deciding on the next stage of your journey isn’t always easy or straightforward, especially after such a challenging time for many young people and adults. We can guide you to get your future on track, with over 100 courses that lead to careers – including brand new T Levels, Apprenticeships and many other BTEC qualifications. Colleges will play a major part in boosting productivity, strengthening communities, and supporting people back into work with rich learning opportunities that will come with regional growth. We have a unique package of specialist and employer responsive courses leading to high quality qualifications, and aimed at specific career skillsets from teaching to social care and high-level management. Diversity is our strength at Sandwell College, and we’re proud to have over 90 languages spoken at our college. Our results are above national average and our state-of-the-art facilities are purpose built to offer you industry standard learning environments. I am extremely proud of the health and wellbeing support services we offer, ensuring that every student has access to the guidance they need within a safe and nurturing environment. Parents can be assured that their children will be protected from any type of harassment. We are committed to inspiring each and every school leaver and adult learner to fulfil their ambitions and ensure they’re supported every step of the way. I look forward to meeting you soon.