4845 Courses

Gain the skills and credentials to kickstart a successful career and learn from the experts with this step-by-step

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

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

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

Overview A Comprehensive Guide to Budgeting Success 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 A Comprehensive Guide to Budgeting Success 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. Module 01: Introduction Introduction 00:03:00 Module 02: Why Are You Doing This Course? Why Are You Doing This Course? 00:04:00 Module 03: How To Download The Template How to Download the Template 00:02:00 Module 04: Becoming Aware Of Your Current Situation Becoming Aware of Your Current Situation 00:21:00 Module 05: Creating An Intentional Budget Creating an Intentional Budget 00:18:00 Module 06: Comparing Your Options Comparing Your Options 00:07:00 Module 07: Creating Specific Budgets Creating Specific Budgets 00:09:00 Module 08: Calculating Your Net Worth Calculating Your Net Worth 00:04:00 Module 09: Understanding Your Cash Flow Understanding Your Cash Flow 00:08:00 Module 10: How To Pay Off Debt Fast How to Pay off Debt Fast 00:12:00 Module 11: Investing And Compound Interest Investing and Compound Interest 00:08:00 Module 12: How To Track Your Expenses With Paper Receipts How to Track Your Expenses with Paper Receipts 00:08:00 Module 13: How To Track Your Expenses Digitally How to Track Your Expenses Digitally 00:05:00 Module 14: The Envelope System The Envelope System 00:06:00 Module 15: Why And How To Create An Emergency Fund Why and How to Create an Emergency Fund 00:05:00 Module 16: How To Organize Your Financial Life How to Organize Your Financial Life 00:05:00 Module 17: How To Organize Finances With Your Partner How to Organize Finances with Your Partner 00:07:00

Overview By enroling in Property Law and Taxation for Accountants and Lawyers, you can kickstart your vibrant career and strengthen your profound knowledge. You can learn everything you need to know about the topic. The Property Law and Taxation for Accountants and Lawyers course includes all of the most recent information to keep you abreast of the employment market and prepare you for your future. The curriculum for this excellent Property Law and Taxation for Accountants and Lawyers course includes modules at all skill levels, from beginner to expert. You will have the productivity necessary to succeed in your organisation once you have completed our Property Law and Taxation for Accountants and Lawyers Program. So enrol in our Property Law and Taxation for Accountants and Lawyers course right away if you're keen to envision yourself in a rewarding career. Description Enroling in this Property Law and Taxation for Accountants and Lawyers course can improve your Property Law and Taxation for Accountants and Lawyers perspective, regardless of your skill levels in the Property Law and Taxation for Accountants and Lawyers topics you want to master. If you're already a Property Law and Taxation for Accountants and Lawyers expert, this peek under the hood will provide you with suggestions for accelerating your learning, including advanced Property Law and Taxation for Accountants and Lawyers insights that will help you make the most of your time. This Property Law and Taxation for Accountants and Lawyers course will act as a guide for you if you've ever wished to excel at Property Law and Taxation for Accountants and Lawyers. Why Choose Us? After successfully completing the Property Law and Taxation for Accountants and Lawyers Course, you will receive a FREE PDF Certificate as evidence of your newly acquired abilities. Lifetime access to the whole collection of Property Law and Taxation for Accountants and Lawyers learning materials. Online test with immediate results Enroling in the course has no additional cost. You can study and complete the Property Law and Taxation for Accountants and Lawyers course at your own pace. Study for the Property Law and Taxation for Accountants and Lawyers course using any internet-connected device, such as a computer, tablet, or mobile device. Who Is This Course For? This Property Law and Taxation for Accountants and Lawyers course is a great place to start if you're looking to start a new career in Property Law and Taxation for Accountants and Lawyers field. This training is for anyone interested in gaining in-demand Property Law and Taxation for Accountants and Lawyers proficiency to help launch a career or their business aptitude.  Requirements The Property Law and Taxation for Accountants and Lawyers course requires no prior degree or experience. All you require is English proficiency, numeracy literacy and a gadget with stable internet connection. Learn and train for a prosperous career in the thriving and fast-growing industry of Property Law and Taxation for Accountants and Lawyers, without any fuss. Career Path This Property Law and Taxation for Accountants and Lawyers training will assist you develop your Property Law and Taxation for Accountants and Lawyers ability, establish a personal brand, and present a portfolio of relevant talents. It will help you articulate a Property Law and Taxation for Accountants and Lawyers professional story and personalise your path to a new career. Furthermore, developing this Property Law and Taxation for Accountants and Lawyers skillset can lead to numerous opportunities for high-paying jobs in a variety of fields. Course Curriculum Property Law and Taxation for Accountants and Lawyers Module 01: The Property Law and Practice 00:23:00 Module 02: Ownership and Possession of the Property 00:16:00 Module 03: Co-Ownership in Property 00:17:00 Module 04: Property Taxation on Capital Gains 00:16:00 Module 05: VAT on Property Taxation 00:11:00 Module 06: Property Taxation Tips for Accountants and Lawyers 00:16:00 Module 07: Changes in the UK Property Market 00:14:00 Mock Exam Mock Exam - Property Law and Taxation for Accountants and Lawyers 00:20:00 Final Exam Final Exam - Property Law and Taxation for Accountants and Lawyers 00:20:00

Description: Payroll is the process by which employers pay an employee for the work they have completed. Any business with employees should have a payroll process established; payroll is often the largest expense for a business. If you want to learn how to perform payroll, gross pay, RTI and more, then this will be the perfect choice for you. This Payroll Management and Systems Diploma is all about payroll management, how to calculate the payroll and general overall understanding about what payroll is and the legal requirements in place, the forms, the deadlines, the process and procedures. The course will develop your skills in how to effectively perform a payroll run, understand statutory deductions, PAYE and real time income. Whether you currently work in finance, or wanting to work in finance, run your own business or simply want to gain a new skills then you should join us today! Assessment: At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Payroll Management and Systems Diploma is certified by CPD Qualifications Standards and CiQ. 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 background. Requirements Our Payroll Management and Systems 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 After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Introduction Introduction to the Course and Instructor FREE 00:10:00 An Overview of Payroll 00:17:00 The UK Payroll System Running the payroll - Part 1 00:14:00 Running the payroll - Part 2 00:18:00 Manual payroll 00:13:00 Benefits in kind 00:09:00 Computerised systems 00:11:00 Total Photo scenario explained 00:01:00 Brightpay Brightpay conclude 00:03:00 Find software per HMRC Brightpay 00:03:00 Add a new employee 00:14:00 Add 2 more employees 00:10:00 Payroll settings 00:04:00 Monthly schedule - Lana 00:14:00 Monthly schedule - James 00:08:00 Directors NI 00:02:00 Reports 00:02:00 Paying HMRC 00:05:00 Paying Pensions 00:04:00 RTI Submission 00:02:00 Coding Notices 00:01:00 Journal entries 00:07:00 102 Schedule 00:03:00 AEO 00:06:00 Payroll run for Jan & Feb 2018 00:13:00 Leavers - p45 00:03:00 End of Year p60 00:02:00 Installing Brightpay 00:13:00 Paye, Tax, NI PAYE TAX 00:13:00 NI 00:11:00 Pensions 00:06:00 Online calculators 00:07:00 Payslips 00:03:00 Conclusion and Next Steps Conclusion and Next Steps 00:07:00 Assessment Assignment - Payroll Management and Systems Diploma 00:00:00 Order Your Certificates and Transcripts Order Your Certificates and Transcripts 00:00:00

Business Analyst bundle course teaches you everything on the Business Analyst topic thoroughly from scratch so you can achieve a certificate for free to showcase your achievement in professional life. This Business Analyst bundle course is a comprehensive course designed to provide a detailed understanding of the nature of the Business Analyst related sector and your key roles within it. The training materials of this Business Analyst course are available online for you to learn at your own pace and fast-track your career with ease. Key Features of Business Analyst Bundle CPD Accredited Business Analyst Course Instant PDF certificate Fully online, interactive Business Analystcourse Self-paced learning and laptop, tablet, smartphone-friendly 24/7 Learning Assistance Discounts on bulk purchases Enrol now in this Business Analyst Bundle course to excel! To become successful in your profession, you must have a specific set of Business Analyst skills to succeed in today's competitive world. In this in-depth Business Analysttraining course, you will develop the most in-demand Business Analyst skills to kickstart your career, as well as upgrade your existing knowledge & skills. Business Analyst Curriculum Course 01: Business Analysis Course 02: Basic Data Analysis Course 03: Business Finance Course 04: Microsoft Power BI Accreditation This Business Analyst bundle courses are CPD accredited, providing you with up-to-date skills and knowledge and helping you to become more competent and effective in your chosen field. Certification Once you've successfully completed your Business Analyst course, you will immediately be sent a digital certificate. Also, you can have your printed certificate delivered by post (shipping cost £3.99). CPD 40 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This course is ideal for all employees or anyone who genuinely wishes to learn more about Business Analyst basics. Requirements No prior degree or experience is required to enrol in this course. Career path This Business Analyst Course will help you to explore avariety of career paths in the related industry. Certificates Digital certificate Digital certificate - Included Hardcopy Certificate Hard copy certificate - Included Hardcopy Certificate (UK Delivery): For those who wish to have a physical token of their achievement, we offer a high-quality, printed certificate. This hardcopy certificate is also provided free of charge. However, please note that delivery fees apply. If your shipping address is within the United Kingdom, the delivery fee will be only £3.99. Hardcopy Certificate (International Delivery): For all international addresses outside of the United Kingdom, the delivery fee for a hardcopy certificate will be only £10.

Learn audit strategy and process to enhance your understanding and skills in the field.After the successful completion of the course, you will be able to learn about the following; Understand the concept of audit strategy and its importance in the auditing process. Learn the steps involved in establishing an effective audit strategy. Develop the skills required to conduct an audit strategy efficiently and effectively. Gain a comprehensive understanding of the audit process, including planning, fieldwork, and reporting. Identify the different documents required in auditing and their significance in the audit process. Explore various audit approaches used in business and understand how they can be applied to different audit scenarios. The Understanding Audit Strategy and Process course provide students with a comprehensive understanding of the audit process from beginning to end. This course covers the necessary steps for developing an effective audit strategy, including planning, executing, and reporting. Students will learn how to conduct an audit by understanding the audit process, audit approaches in business, and the necessary documents required for auditing. Additionally, this course emphasizes the importance of effective compliance monitoring and its impact on business performance. Students will explore various approaches to monitoring audit practices for effectiveness and compliance. By the end of this course, students will have a strong foundation in audit strategy and process and be able to apply these skills to real-world scenarios. The Understanding Audit Strategy and Process course provide students with a comprehensive understanding of the audit process from beginning to end. This course covers the necessary steps for developing an effective audit strategy, including planning, executing, and reporting. Students will learn how to conduct an audit by understanding the audit process, audit approaches in business, and the necessary documents required for auditing. Additionally, this course emphasizes the importance of effective compliance monitoring and its impact on business performance. Students will explore various approaches to monitoring audit practices for effectiveness and compliance. By the end of this course, students will have a strong foundation in audit strategy and process and be able to apply these skills to real-world scenarios. VIDEO - Course Structure and Assessment Guidelines Watch this video to gain further insight. Navigating the MSBM Study Portal Watch this video to gain further insight. Interacting with Lectures/Learning Components Watch this video to gain further insight. Understanding Audit strategy and process Self-paced pre-recorded learning content on this topic. Understanding Audit Strategy And Process Put your knowledge to the test with this quiz. Read each question carefully and choose the response that you feel is correct. All MSBM courses are accredited by the relevant partners and awarding bodies. Please refer to MSBM accreditation in about us for more details. There are no strict entry requirements for this course. Work experience will be added advantage to understanding the content of the course. The certificate is designed to enhance the learner's knowledge in the field. This certificate is for everyone eager to know more and get updated on current ideas in their respective field. We recommend this certificate for the following audience. CEO, Director, Manager, Supervisor Risk Manager Investment Risk Analyst Portfolio Manager Chief Risk Officer Investment Analyst Quantitative Analyst Risk Management Consultant Compliance Officer Financial Advisor Hedge Fund Manager Average Completion Time 2 Weeks Accreditation 3 CPD Hours Level Advanced Start Time Anytime 100% Online Study online with ease. Unlimited Access 24/7 unlimited access with pre-recorded lectures. Low Fees Our fees are low and easy to pay online.

Duration 2 Days 12 CPD hours This course is intended for The audience for this course includes professionals who are new to Looker who are interested in leveraging Looker for data analysis, visualization, and reporting. The course is designed for individuals seeking to gain a comprehensive understanding of Looker's functionalities and apply these skills in their organizations to drive data-driven decision-making. Overview This course combines expert lecture, real-world demonstrations and group discussions with machine-based practical labs and exercises. Working in a hands-on learning environment led by our expert facilitator, you'll explore and gain: Comprehensive understanding of Looker's platform: Gain a solid foundation in Looker's key features, functionality, and interface, enabling you to navigate and utilize the platform effectively for your data analysis and visualization needs. Mastery of LookML and data modeling: Develop proficiency in Looker's unique data modeling language, LookML, to create customized and efficient data models that cater to your organization's specific requirements. Expertise in creating insightful Explores: Learn to build, customize, and save Explores with dimensions, measures, filters, and calculated fields, empowering you to analyze your data and uncover valuable insights. Proficiency in dashboard design and sharing: Acquire the skills to design visually appealing and informative dashboards, share them with different user roles, and schedule exports to keep stakeholders informed and up-to-date. Enhanced content organization with folders and boards: Understand how to effectively use folders and boards to organize, manage, and discover content within Looker, making it easily accessible for you and your team. Optional: Advanced visualization techniques for impactful storytelling: Master advanced visualization techniques, including customizations with HTML, CSS, and JavaScript, and interactive visualizations using Looker's API, to create compelling data stories that resonate with your audience. Discover the power of data analytics and visualization with our hands-on, two-day introductory course Looker Bootcamp: Analyzing and Visualizing Data with Looker. Designed for professionals who want to unlock valuable insights from their data, this immersive training experience will guide you through Looker's cutting-edge features and provide you with the essential skills to create engaging, interactive, and insightful reports and dashboards. Our experienced trainers will take you on a journey from the fundamentals of Looker and its unique data modeling language, LookML, to advanced visualization techniques and content organization strategies, ensuring you leave the course equipped to make data-driven decisions with confidence. Throughout the course, you will have the opportunity to participate in practical exercises and workshops that will help you apply the concepts and techniques learned in real-world scenarios. You will explore the potential of Looker's Explores, dive into LookML's capabilities, and master the art of dashboard design and sharing. Learn how to organize and manage your content with folders and boards and harness the power of advanced visualization techniques to make your data come alive. Getting Started with Looker Overview of Looker and its key features Navigating the Looker interface Looker terminology and basic concepts Connecting to Data Sources Setting up and managing data connections Exploring database schemas Understanding LookML: Looker's data modeling language Creating and Customizing Explores Building and customizing Explores Adding dimensions, measures, and filters Creating calculated fields Saving and organizing Explores Data Visualization Creating visualizations using Looker's visualization library Customizing chart types, colors, and labels Displaying visualizations in dashboards Introduction to Looker's API for custom visualizations Advanced Explores and LookML LookML refresher and best practices Creating derived tables and data transformations Managing access controls and data permissions Organizing and Sharing Content with Folders and Boards Introduction to folders and boards in Looker Creating and managing folders for organizing content Setting up boards for easy content discovery Sharing folders and boards with different user roles and permissions Dashboard Design and Sharing Best practices for dashboard design Adding, arranging, and resizing visualizations Scheduling and exporting dashboard data Advanced Visualization Techniques Customizing visualizations with HTML, CSS, and JavaScript Creating interactive visualizations using Looker's API Integrating Looker visualizations with other tools Hands-on Workshop and Project Participants work on a guided project to apply the skills learned Trainer provides individual support and guidance Project Presentations, Q&A, and Training Wrap-up Additional course details: Nexus Humans Looker Bootcamp: Analyzing and Visualizing Data with Looker (TTDVLK02) 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 Looker Bootcamp: Analyzing and Visualizing Data with Looker (TTDVLK02) 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.