4079 Courses delivered Online

Look at the in depth features of charts and some specialist tools to make your charts come to life. Course overview Duration: 1 day (6.5 hours) Our Excel Charting Specialist course examines how to unlock the full potential of Charts in Excel. It investigates the useful tools needed for creating bespoke Charts, allowing you to creatively present data more visually. By the end of the course, you will have an awareness of the tools used for creating more advanced Charts and will be able to create your own Dynamic Charts. The course is designed for existing users of Excel who are looking at more advanced ways to visualise data in Excel using Charts. Objectives By the end of the course you will be able to: Create and Amend Charts Format multiple areas of a Chart Use a Combo Chart Apply Conditional Formatting to a Chart Create Dynamic Charts Work with Custom Formatting Create an Advanced Dynamic Chart Content Creating and amending charts Creating Simple Charts Using the Chart Design tab Adding Chart Elements Changing the type of Chart Formatting charts Format Chart Area Format Data Series Format Data Point Format Axis Working with combo charts Adding additional data to a Chart Customising Chart types Creating Clustered Column/line Charts Applying conditional formatting on charts Using IF Statements Highlighting Max/Min Data points in Charts Using Series Overlap Dynamic charts Creating dynamic Target vs Actual Charts Introducing the NA function Hiding data used for Charts Custom formatting charts Formatting Data Labels Customising number formats Using Trend Arrows to show changes Editing Format Code Advanced dynamic charts Pivot Chart rules Creating a Pivot Chart Working with your Pivot Chart Creating calculations Combining all elements to create an Advanced Chart Using Error Bars to create a line Adding a scroll bar and linking with data

Learn how to work with and connect multiple data sets to effectively analyse and report on data. Course overview Duration: 1 day (6.5 hours) Within Excel you have some powerful features to enable you to connect and analyse multiple data sources. Power Query enables you to import and manipulate your data, Power Pivot enables you to connect multiple data sources and create pivot tables and pivot charts from them. This course is an introduction to Power Query and Power Pivot in Excel to get you started on creating a powerful reporting capability. Knowledge of working with Excel workbooks and relational databases would be an advantage. Objectives By the end of the course you will be able to: Import data from multiple data sources Edit and transform data before importing Add extra columns of data Append data Merge data from other tables Create data models Build data relationships Build Pivot Tables Build Pivot Charts Use Slicers and Timeline Filters Content Importing data Data sources Importing data Transforming data Editing your data Setting data types Removing columns/rows Choosing columns to keep Setting header rows Splitting columns Appending queries Appending data from other tables Adding text Columns from example Custom columns Conditional columns Merge queries Setting up and using merge queries Merging in columns of data Creating a data model The data model Multiple data tables Connecting tables Building relationships Relationship types Building visuals from multiple tables Analysing information using pivot tables Creating and modifying a Pivot Table Recalculating the Pivot Table Filtering the Pivot Table Searching the Pivot Table Drilling down to underlying data Customising field names Changing field formatting Pivot charts, slices and timelines Creating Pivot Charts Adding and using Slicers

Ideal for those already using Excel but who really want to get to grips with formulas and functions. Course overview Duration: 1 day (6.5 hours) Our Excel Mastering Formulas and Functions course looks at how to confidently use formulas and functions within Excel. It looks at how to correctly construct formulas and explains how to build common formulas such as working with percentages. It investigates a range of built in Excel functions and shows you how to use the formula auditing tools to help when things go wrong.  This course is aimed at existing users of Excel who want to further their skills. Participants should be able to confidently create and amend worksheets. Objectives By the end of the course you will be able to: Construct Formulas Use a range of common Functions Work with absolute and relative references in formulas Create percentage calculations Use named ranges in formulas Use the XLOOKUP command Create formulas with date and use date functions Use formulas in conditional formatting Use a range of Count functions Use the formula auditing tools Content Formulas vs Functions Constructing formulas Using functions Common Excel functions Using the function wizard vs the formula bar Formulas in tables Absolute vs relative references in formulas Using absolute references in formulas Using partial absolute referencing Range Naming Naming ranges Using range names in formulas Single and multi-cell ranges Working with percentages Creating formulas with percentages Percentage breakdowns Percentage increases Formatting as a percentage Using Lookups Using XLOOKUP to insert information from other spreadsheets Calculating with dates Calculating with dates Using date functions Using formulas in conditional formatting Using conditional formulas Using functions in conditional formatting Count functions COUNT COUNTA COUNTBLANK Formula auditing Using the auditing facility Tracing how formulas are made up Tracing precedents and dependants Evaluating formulas Error checking Showing formulas on a sheet

Overview With the ever-increasing demand for Forensic Science in personal & professional settings, this online training aims at educating, nurturing, and upskilling individuals to stay ahead of the curve - whatever their level of expertise in Forensic Science may be. Learning about Forensic Science or keeping up to date on it can be confusing at times, and maybe even daunting! But that's not the case with this course from Compete High. We understand the different requirements coming with a wide variety of demographics looking to get skilled in Forensic Science . That's why we've developed this online training in a way that caters to learners with different goals in mind. The course materials are prepared with consultation from the experts of this field and all the information on Forensic Science is kept up to date on a regular basis so that learners don't get left behind on the current trends/updates. The self-paced online learning methodology by compete high in this Forensic Science course helps you learn whenever or however you wish, keeping in mind the busy schedule or possible inconveniences that come with physical classes. The easy-to-grasp, bite-sized lessons are proven to be most effective in memorising and learning the lessons by heart. On top of that, you have the opportunity to receive a certificate after successfully completing the course! Instead of searching for hours, enrol right away on this Forensic Science course from Compete High and accelerate your career in the right path with expert-outlined lessons and a guarantee of success in the long run. Who is this course for? While we refrain from discouraging anyone wanting to do this Forensic Science course or impose any sort of restrictions on doing this online training, people meeting any of the following criteria will benefit the most from it: Anyone looking for the basics of Forensic Science , Jobseekers in the relevant domains, Anyone with a ground knowledge/intermediate expertise in Forensic Science , Anyone looking for a certificate of completion on doing an online training on this topic, Students of Forensic Science , or anyone with an academic knowledge gap to bridge, Anyone with a general interest/curiosity Career Path This Forensic Science course smoothens the way up your career ladder with all the relevant information, skills, and online certificate of achievements. After successfully completing the course, you can expect to move one significant step closer to achieving your professional goals - whether it's securing that job you desire, getting the promotion you deserve, or setting up that business of your dreams. Course Curriculum Module 1 Introduction to Forensic Science Introduction to Forensic Science 00:00 Module 2 Forensic Mathematics Forensic Mathematics 00:00 Module 3 Forensic Chemistry Forensic Chemistry 00:00 Module 4 Forensic Toxicology Forensic Toxicology 00:00 Module 5 Forensic Intelligence Forensic Intelligence 00:00 Module 6 Forensic Science and Criminology Forensic Science and Criminology 00:00 Module 7 DNA Analysis in Forensics DNA Analysis in Forensics 00:00 Module 8 Forensic Pathology Forensic Pathology 00:00

Overview With the ever-increasing demand for Forensic Nursing in personal & professional settings, this online training aims at educating, nurturing, and upskilling individuals to stay ahead of the curve - whatever their level of expertise in Forensic Nursing may be. Learning about Forensic Nursing or keeping up to date on it can be confusing at times, and maybe even daunting! But that's not the case with this course from Compete High. We understand the different requirements coming with a wide variety of demographics looking to get skilled in Forensic Nursing . That's why we've developed this online training in a way that caters to learners with different goals in mind. The course materials are prepared with consultation from the experts of this field and all the information on Forensic Nursing is kept up to date on a regular basis so that learners don't get left behind on the current trends/updates. The self-paced online learning methodology by compete high in this Forensic Nursing course helps you learn whenever or however you wish, keeping in mind the busy schedule or possible inconveniences that come with physical classes. The easy-to-grasp, bite-sized lessons are proven to be most effective in memorising and learning the lessons by heart. On top of that, you have the opportunity to receive a certificate after successfully completing the course! Instead of searching for hours, enrol right away on this Forensic Nursing course from Compete High and accelerate your career in the right path with expert-outlined lessons and a guarantee of success in the long run. Who is this course for? While we refrain from discouraging anyone wanting to do this Forensic Nursing course or impose any sort of restrictions on doing this online training, people meeting any of the following criteria will benefit the most from it: Anyone looking for the basics of Forensic Nursing , Jobseekers in the relevant domains, Anyone with a ground knowledge/intermediate expertise in Forensic Nursing , Anyone looking for a certificate of completion on doing an online training on this topic, Students of Forensic Nursing , or anyone with an academic knowledge gap to bridge, Anyone with a general interest/curiosity Career Path This Forensic Nursing course smoothens the way up your career ladder with all the relevant information, skills, and online certificate of achievements. After successfully completing the course, you can expect to move one significant step closer to achieving your professional goals - whether it's securing that job you desire, getting the promotion you deserve, or setting up that business of your dreams. Course Curriculum Module 1 Introduction to Forensic Nursing Introduction to Forensic Nursing 00:00 Module 2 Forensic Mental Health Nursing Forensic Mental Health Nursing 00:00 Module 3 Assessment of Wounds and Injury Assessment of Wounds and Injury 00:00 Module 4 Death Investigation Death Investigation 00:00 Module 5 Forensic Toxicology Forensic Toxicology 00:00 Module 6 DNA Analysis in Forensics DNA Analysis in Forensics 00:00 Module 7 Forensic Pathology Forensic Pathology 00:00

There is always that one time of the year when you will go crazy trying to get all your papers right for taxes. Your hair goes awry, you get dark circles under your eyes; essentially stress is a given during tax season. Well not anymore, because you can say goodbye to stress by simply taking this Tax Filing Diploma course. This diploma level course will help you manage your own taxes with ease. The course primarily focuses on the American tax system, however the principles can be applied to other countries as well. In this course you will get tax saving ideas for individuals and businesses, how to use tax preparation software, methods of saving on taxes and so much more. You will also understand the importance of acquiring a financial planning certificate through this course. Furthermore you will get an overview of tax systems in different states. This course is the ultimate guide to prepare you for any tax related problems that might occur; all you have to do now is get this Tax Filing Diploma course. Course Highlights Tax Filing Diploma is an award winning and the best selling course that has been given the CPD Certification & IAO accreditation. It is the most suitable course anyone looking to work in this or relevant sector. It is considered one of the perfect courses in the UK that can help students/learners to get familiar with the topic and gain necessary skills to perform well in this field. We have packed Tax Filing Diploma into 34 modules for teaching you everything you need to become successful in this profession. To provide you ease of access, this course is designed for both part-time and full-time students. You can become accredited in just 1 day, 1 hour and it is also possible to study at your own pace. We have experienced tutors who will help you throughout the comprehensive syllabus of this course and answer all your queries through email. For further clarification, you will be able to recognize your qualification by checking the validity from our dedicated website. Why You Should Choose Tax Filing Diploma Lifetime access to the course No hidden fees or exam charges CPD Accredited certification on successful completion Full Tutor support on weekdays (Monday - Friday) Efficient exam system, assessment and instant results Download Printable PDF certificate immediately after completion Obtain the original print copy of your certificate, dispatch the next working day for as little as £9. Improve your chance of gaining professional skills and better earning potential. Who is this Course for? Tax Filing Diploma is CPD certified and IAO accredited. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic backgrounds. Requirements Our Tax Filing Diploma is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path You will be ready to enter the relevant job market after completing this course. You will be able to gain necessary knowledge and skills required to succeed in this sector. All our Diplomas' are CPD and IAO accredited so you will be able to stand out in the crowd by adding our qualifications to your CV and Resume. Individual Tax Saving Ideas 01:00:00 Tax Saving Measures For Business 01:00:00 The Tax Audit 01:00:00 The Ins And Outs Of Federal Payroll Taxes 02:00:00 Why People File Taxes Online 00:30:00 What Are Your County Property Taxes Used For? 00:30:00 Offering Personal Financial Advice -Ameriprise Financial Services 01:00:00 Using Free Tax Preparation Software 00:30:00 Consulting Tax Attorneys - Tax Law Specialists 00:30:00 Delinquent Property Taxes- Three Steps To Deal With Your Delinquent Property Taxes 01:00:00 Federal Income Taxes - How To Deal With Federal Income Taxes? 01:00:00 File State Taxes- E-File System Is The Best Way To File Your State Taxes 00:30:00 Filing Income Taxes- How To File Income Taxes? 01:00:00 Financial Planning Software- Nine Benefits Of Financial Planning Software 01:00:00 Free Taxes- Benefits Of Filing Free Taxes Online 00:30:00 Income Tax Forms- Three Must To Follow If You Desire To Fill Your Income Tax Forms Yourself 00:30:00 LLC Tax Savings- How To Avail LLC Tax Savings 00:30:00 Benefits Of Online Tax Forms Over Traditional Methods 00:30:00 Save On Taxes By Refinancing Your Mortgage 00:30:00 Save On Taxes By Spending Less On Credit 00:30:00 Save On Taxes By Investing In Life Insurance 00:30:00 Save On Taxes: Hot Tips 01:00:00 Save On Taxes With Tax Deductions 01:00:00 Federal Tax Law 2005 For Nonprofit Organizations 00:30:00 Understanding California State Taxes 00:30:00 Make Your Personal Finances Work for You 01:00:00 The Importance of Acquiring a Financial Planning Certificate 00:30:00 Social Development and Financial Planning 01:00:00 An Overview Of Hennepin County Property Taxes 00:30:00 Kentucky State Taxes 01:00:00 Maryland State Taxes 01:00:00 Ohio State Taxes 00:30:00 UBS Financial Services For Small And Large Business 00:30:00 What Is A VP Financial Planner? 00:15:00 Mock Exam Mock Exam- Tax Filing Diploma 00:20:00 Final Exam Final Exam- Tax Filing Diploma 00:20:00

Overview With the ever-increasing demand for Purchase Ledger in personal & professional settings, this online training aims at educating, nurturing, and upskilling individuals to stay ahead of the curve - whatever their level of expertise in Purchase Ledger may be. Learning about Purchase Ledger or keeping up to date on it can be confusing at times, and maybe even daunting! But that's not the case with this course from Compete High. We understand the different requirements coming with a wide variety of demographics looking to get skilled in Purchase Ledger . That's why we've developed this online training in a way that caters to learners with different goals in mind. The course materials are prepared with consultation from the experts of this field and all the information on Purchase Ledger is kept up to date on a regular basis so that learners don't get left behind on the current trends/updates. The self-paced online learning methodology by compete high in this Purchase Ledger course helps you learn whenever or however you wish, keeping in mind the busy schedule or possible inconveniences that come with physical classes. The easy-to-grasp, bite-sized lessons are proven to be most effective in memorising and learning the lessons by heart. On top of that, you have the opportunity to receive a certificate after successfully completing the course! Instead of searching for hours, enrol right away on this Purchase Ledger course from Compete High and accelerate your career in the right path with expert-outlined lessons and a guarantee of success in the long run. Who is this course for? While we refrain from discouraging anyone wanting to do this Purchase Ledger course or impose any sort of restrictions on doing this online training, people meeting any of the following criteria will benefit the most from it: Anyone looking for the basics of Purchase Ledger , Jobseekers in the relevant domains, Anyone with a ground knowledge/intermediate expertise in Purchase Ledger , Anyone looking for a certificate of completion on doing an online training on this topic, Students of Purchase Ledger , or anyone with an academic knowledge gap to bridge, Anyone with a general interest/curiosity Career Path This Purchase Ledger course smoothens the way up your career ladder with all the relevant information, skills, and online certificate of achievements. After successfully completing the course, you can expect to move one significant step closer to achieving your professional goals - whether it's securing that job you desire, getting the promotion you deserve, or setting up that business of your dreams. Course Curriculum Module 1 - Introduction to Purchase Ledger Introduction to Purchase Ledger 00:00 Module 2 - Purchase Ledger Account Purchase Ledger Account 00:00 Module 3 - Purchase Ledger Control Account Purchase Ledger Control Account 00:00 Module 4 - The Sales Ledger and the Purchase Ledger The Sales Ledger and the Purchase Ledger 00:00 Module 5 - Difference Between Sales Ledger and Purchase Ledger Difference Between Sales Ledger and Purchase Ledger 00:00 Module 6 - Reconciliation Reconciliation 00:00 Module 7 - Paperless Purchase Paperless Purchase 00:00 Module 8 - Auditing - Vouching of Ledger Auditing - Vouching of Ledger 00:00

Overview Property Law & Taxation Course is yet another 'Teacher's Choice' course from Teachers Training for a complete understanding of the fundamental topics. You are also entitled to exclusive tutor support and a professional CPD-accredited certificate in addition to the special discounted price for a limited time. Just like all our courses, this Property Law & Taxation Course and its curriculum have also been designed by expert teachers so that teachers of tomorrow can learn from the best and equip themselves with all the necessary skills. Consisting of several modules, the course teaches you everything you need to succeed in this profession. The course can be studied part-time. You can become accredited within 05 Hours studying at your own pace. Your qualification will be recognised and can be checked for validity on our dedicated website. Why Choose Teachers Training Some of our website features are: This is a dedicated website for teaching 24/7 tutor support Interactive Content Affordable price Courses accredited by the UK's top awarding bodies 100% online Flexible deadline Entry Requirements No formal entry requirements. You need to have: Passion for learning A good understanding of the English language Be motivated and hard-working Over the age of 16. Certification CPD Certification from The Teachers Training Successfully completing the MCQ exam of this course qualifies you for a CPD-accredited certificate from The Teachers Training. You will be eligible for both PDF copy and hard copy of the certificate to showcase your achievement however you wish. You can get your digital certificate (PDF) for £4.99 only Hard copy certificates are also available, and you can get one for only £10.99 You can get both PDF and Hard copy certificates for just £12.99! The certificate will add significant weight to your CV and will give you a competitive advantage when applying for jobs. Property Law & Taxation Module 01: The Property Law and Practice 00:27:00 Module 02: Ownership and Possession of the Property 00:19:00 Module 03: Co-Ownership in Property 00:19:00 Module 04: Property Taxation on Capital Gains 00:18:00 Module 05: VAT on Property Taxation 00:14:00 Module 06: Property Taxation Tips for Accountants and Lawyers 00:19:00 Module 07: Changes in the UK Property Market 00:16:00

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 understand the programming environment of Visual Basic for applications and know how to create custom procedures and functions that can expand their ability to use Excel more effectively. This course is intended for the experienced Excel users that want to gain knowledge of visual basic for applications (VBA). Introduction to Macros Recording Macros Absolute and Relative How to Run a Macro Basics of Code Writing The VBA Environment (the ?VBE? window) Essential Tips, Tricks, Shortcuts Understanding VBA and Best Practice Crucial VBA Objects and Structures Variables and Data Types Conditionals (If, Select Case) Loops (For, Do) Interaction Interact with Data, Sheets, the Excel Application Interact with User (Message Box, Input Box) Errors Run Editing Debuging Handeling Errors Additional course details: Nexus Humans Excel - VBA Bootcamp 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 Excel - VBA Bootcamp 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.

Description We all want to save money on our taxes, especially ultra wealthy taxpayers who are hit the hardest by the nation's highest tax percentages. The point is that the rich are able to avoid taxes through legal processes. Some mega-rich may use sketchy methods to avoid taxes, and everyone's definition of sketchy is different. However, most of the mega-rich use superior understanding of the tax laws to take advantage of all of the legal methods available to reduce their taxes. The US Tax Management Course stands to teach you those methods about taxes you should know. You will learn to save money on your taxes, build wealth in a tax efficient way, retire without paying any taxes on your income, and more.  What Will I Learn? Save money during tax season Reduce the amount of taxable income on their tax return Build wealth faster by saving money on taxes Complete their taxes with little stress Avoid an audit by the IRS Requirements Pencil and paper to take notes Who is the target audience? Anyone who wants to pay less in taxes Introduction Everything You Need to Know About Taxes Introduction: Why the Rich Get Richer FREE 00:07:00 The History of Taxes & Marginal Rates A Brief History of Taxes in America FREE 00:12:00 Understanding Marginal Tax Rates 00:06:00 Deductions & Credits How to Maximize Tax Deductions 00:11:00 How to Maximize Tax Credits 00:11:00 Retirement Accounts & FATCA Building Wealth Through Tax Efficient Retirement Accounts 00:13:00 Taxes on Foreign Earned Income and Assets 00:10:00 Strategies of the Wealthy Using CPAs & Tax Preparation Software 00:06:00 Tax Tips & Tricks of the Wealthy 00:07:00 How to Avoid an Audit by the IRS 00:08:00 Conclusion: Bringing it All together Creating a Wealth Building Tax Strategy 00:04:00