2841 Accounting & Finance courses near Harrow delivered On Demand

Microsoft Excel 2019 for Beginner course teaches you everything on the topic thoroughly from scratch so you can claim a certificate of achievement for free to showcase your achievement in professional life. This course is a comprehensive, instructor-guided course, designed to provide a detailed understanding of the nature of the related sector and your key roles within it. To become successful in your profession, you must have a specific set of skills to succeed in today's competitive world. In this in-depth training course, you will develop the most in-demand skills to kickstart your career, as well as upgrade your existing knowledge & skills. The training materials of this course are available online for you to learn at your own pace and fast-track your career with ease. Key Features of the Microsoft Excel 2019 for Beginner Course : Instant e-certificate and hard copy dispatch by next working day Fully online, interactive course with audio voiceover Developed by professionals in the field Self-paced learning and laptop, tablet, smartphone-friendly 24/7 Learning Assistance Discounts on bulk purchases *** Additional Gifts *** Free Life coaching Course *** (Offer Ends Soon) *** Course Curriculum The detailed curriculum outline of our Microsoft Excel 2019 for Beginner course is as follows: ***Microsoft Excel 2019*** Microsoft Excel 2019 New Features Introduction to Microsoft Excel 2019 New Features CONCAT IFS MAXIFS MINIFS SWITCH TEXTJOIN Map Chart Funnel Chart Better Visuals Pivot Table Enhancements Power Pivot Updates Getting Started with Microsoft Office Excel Navigate the Excel User Interface Use Excel Commands Create and Save a Basic Workbook Enter Cell Data Use Excel Help Performing Calculations Create Worksheet Formulas Insert Functions Reuse Formulas and Functions Modifying a Worksheet Insert, Delete, and Adjust Cells, Columns, and Rows Search for and Replace Data Use Proofing and Research Tools Formatting a Worksheet Apply Text Formats Apply Number Format Align Cell Contents Apply Styles and Themes Apply Basic Conditional Formatting Create and Use Templates Printing Workbooks Preview and Print a Workbook Set Up the Page Layout Configure Headers and Footers Managing Workbooks Manage Worksheets Manage Workbook and Worksheet Views Manage Workbook Properties Working with Functions Work with Ranges Use Specialized Functions Work with Logical Functions Work with Date & Time Functions Work with Text Functions Working with Lists Sort Data Filter Data Query Data with Database Functions Outline and Subtotal Data Analyzing Data Apply Intermediate Conditional Formatting Apply Advanced Conditional Formatting Visualizing Data with Charts Create Charts Modify and Format Charts Use Advanced Chart Features Using PivotTables and PivotCharts Create a PivotTable Analyze PivotTable Data Present Data with PivotCharts Filter Data by Using Timelines and Slicers Working with Multiple Worksheets and Workbooks Use Links and External References Use 3-D References Consolidate Data Using Lookup Functions and Formula Auditing Use Lookup Functions Trace Cells Watch and Evaluate Formulas Sharing and Protecting Workbooks Collaborate on a Workbook Protect Worksheets and Workbooks Automating Workbook Functionality Apply Data Validation Search for Invalid Data and Formulas with Errors Work with Macros Creating Sparklines and Mapping Data Create Sparklines MapData Forecasting Data Determine Potential Outcomes Using Data Tables Determine Potential Outcomes Using Scenarios Use the Goal Seek Feature Forecasting Data Trends Who is this course for? Anyone with a knack for learning new skills can take this Microsoft Excel 2019 for Beginner course. While this comprehensive training is popular for preparing people for job opportunities in the relevant fields, it also helps to advance your career for promotions. Accreditation All of our courses, including this course, are fully 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 course, you will immediately be sent a digital certificate. Also, you can have your printed certificate delivered by post (shipping cost £3.99). Our certifications have no expiry dates, although we do recommend that you renew them every 12 months. Assessment At the end of the course, there will be an online assessment, which you will need to pass to complete the course. Answers are marked instantly and automatically, allowing you to know straight away whether you have passed. If you haven't, there's no limit on the number of times you can take the final exam. All this is included in the one-time fee you paid for the course itself. Requirements The Microsoft Excel 2019 is open to all students and has no formal entry requirements. To study the Microsoft Excel course, all your need is a passion for learning, a good understanding of English, numeracy, and IT skills. You must also be over the age of 16. Career path This course will give you a comprehensive understanding of the Microsoft Excel platform and assist you in pursuing several exciting employment opportunities, such as - Administrative Assistant Accountants Business Analyst Cost Estimator Data Entry Specialist Project Manager And many more! These job prospects pay an average of £15k to £55k a year in the UK. Certificates Digital certificate Digital certificate - Included Hard copy certificate Hard copy certificate - Included You will get the hard copy certificates for Free! The delivery charge of the hard copy certificate inside the UK is £3.99 each.

Internal auditing plays a crucial role in ensuring an organisation’s processes operate efficiently and risks are managed effectively. This course provides a thorough introduction to auditing as a form of assurance, guiding learners through essential internal audit procedures and the use of technology in modern audits. You'll gain a clear understanding of how internal controls and control risks influence audit outcomes, alongside mastering the techniques for conducting audit interviews and reporting findings with clarity and precision. Designed to align with UK Internal Audit Standards, this training equips participants with the knowledge necessary to confidently navigate the internal audit landscape. Whether you’re aiming to establish a career in internal auditing or enhance your current expertise, this course delivers valuable insights into the professional expectations and opportunities within the field. Accessible entirely online, it allows you to study at your own pace while developing a solid foundation in internal auditing principles and practices. Key Features CPDA Accredited Internal Auditor Training Instant FREE e-certificate Fully online, interactive Internal Auditor course with audio voiceover Self-paced learning and laptop, tablet, and smartphone-friendly 24/7 Learning Assistance Discounts on bulk purchases Free Gifts Life Coaching Course Enrol now in this Internal Auditor course to excel! Internal Auditor Course Curriculum Module 01: Auditing as a Form of Assurance Module 02: Internal Audit Procedures Module 03: Technology-based Internal Audit Module 04: Internal Control and Control Risk Module 05: Audit Interviews Module 06: Reporting Audit Outcome Module 07: UK Internal Audit Standards Module 08: Career as an Internal Auditor Accreditation This Internal Auditor is CPD Quality Standards (CPD QS) 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 Internal Auditor course, you will immediately be sent a digital certificate. Also, you can have your printed certificate delivered by post (shipping cost £3.99). CPD 10 CPD hours / points Accredited by The CPD Quality Standards (CPD QS) Who is this course for? This Internal Auditor course is suitable for anyone interested in: Information Systems Audit and Control Association Financial Investigator Forensic Accounting Professionals seeking to develop skills in auditing, including entry-level Internal auditors, financial controllers, risk managers, and compliance officers. Requirements No prior degree or experience is required to enrol in this Internal Auditor course. Career path Entry-level Internal Auditor: £25,000 - £35,000 per annum Internal Auditor with 3-5 years of experience: £35,000 - £50,000 per annum Senior Internal Auditor with 5+ years of experience: £50,000 - £80,000+ per annum Certificates Certificate of completion Digital certificate - Included Certificate of completion Hard copy certificate - Included You will get the hard copy certificates for Free! The delivery charge of the hard copy certificate inside the UK is £3.99 each.

Master advanced Excel skills and boost your career with our Microsoft Excel Advanced Diploma Course. Gain proficiency in data analysis, understand advanced features, and develop practical expertise.

The Professional Presenter Training provides you with the knowledge and skill building in the planning, preparation and delivery of truly engaging presentations. Exploring all aspects of concept, design and delivery, you will gain a range of tools and techniques to help you plan and deliver engaging and effective presentations to a range of audiences. You'll learn how to use specific tools and techniques for presentation creation and delivery which will enable you to conduct powerful presentations that engage your audience every time. This course will give you the framework needed to develop and deliver an effective, memorable presentation. You will learn proven tips and examples that will guide you through the presentation process no matter how large the audience. Who is this course for? Excel 2019 Intermediate is suitable for anyone who wants to gain extensive knowledge, potential experience and professional skills in the related field. This course is CPD accredited so you don't have to worry about the quality. Requirements Our Excel 2019 Intermediate is open to all from all academic backgrounds and there are no specific requirements to attend this course. It is compatible and accessible from any device including Windows, Mac, Android, iOS, Tablets etc. CPD Certificate from Course Gate At the successful completion of the course, you can obtain your CPD certificate from us. You can order the PDF certificate for £9 and the hard copy for £15. Also, you can order both PDF and hardcopy certificates for £22. Career path This course opens a new door for you to enter the relevant job market and also gives you the opportunity to acquire extensive knowledge along with required skills to become successful. You will be able to add our qualification to your CV/resume which will help you to stand out in the competitive job industry. Course Curriculum Intro Introduction 00:01:00 Section 01 Linking Worksheets and Workbooks 00:07:00 Linking Worksheets with 3D References 00:05:00 Understanding the Consolidate Feature 00:06:00 Section 02 What are Range Names 00:06:00 Creating Range Names Using the Name Box and Define Name 00:06:00 Creating Range Names Using Create from Selection 00:03:00 Section 03 Understanding the Differences Between Sorting and Filtering 00:03:00 Sorting Lists 00:07:00 Filtering Lists 00:06:00 Creating Subtotals 00:05:00 Section 04 Creating Tables and Understanding the Benefits 00:06:00 Understanding the Elements of a Table 00:05:00 Formatting a Table 00:05:00 Sorting and Filtering Tables 00:04:00 Filtering with Slicers 00:07:00 Calculating with Tables 00:06:00 Removing Erroneous Table Data 00:05:00 Exporting, Refreshing, and Converting Tables 00:05:00 Section 05 What is Conditional Formatting 00:03:00 Conditional Formatting-HIghlight Cells and Top Bottom Rules 00:06:00 Conditional Formatting-Data Bars, Icon Sets, and Color Scales 00:06:00 Using Custom Fonts and Colors 00:03:00 Using Custom Conditional Formatting 00:05:00 Modyfing or Removing Conditional Formatting 00:04:00 Section 06 What are Charts 00:06:00 Forecasting with Trendlines 00:05:00 Creating a Chart Template 00:04:00 Displaying Trends with Sparklines 00:08:00 Creating Charts 00:05:00 Understanding Chart Elements 00:05:00 Modifying Chart Elements 00:05:00 Changing and Moving Charts 00:03:00 Filtering a Chart 00:04:00 Formatting Charts 00:13:00 Adjusting Numbering 00:06:00 Creating Dual Axis Charts 00:05:00 Section 07 What is a PivotTable 00:05:00 Creating a PivotTable 00:07:00 Working with the PivotTable Fields Pane 00:10:00 Basic Data Organization and Analysis with PivotTables 00:08:00 Formatting PivotTables 00:05:00 Creating a PivotChart 00:04:00 Modifying and Formatting a PivotChart 00:04:00 Using Slicers and Timeline Slicers 00:08:00 Section 08 Using the PivotTable and PivotChart Wizard 00:03:00 Adding a Calculated Field 00:04:00 Adding a Calculated Item 00:04:00 Applying Conditional Formatting to a PivotTable 00:06:00 Creating Filter Pages for a PivotTable 00:04:00 Enabling the PowerPivot Add-in 00:11:00 Recap Recap 00:02:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00

Enhance your Excel skills with our comprehensive course covering 50 essential tips and techniques. Perfect for beginners and professionals alike, this course offers CPD accreditation and practical insights to boost your career prospects.

CPD Accredited | Free PDF Certificate | 20 CPD Points | Lifetime Access | Tutor Support

Unlock the full potential of Microsoft Excel with our course for everyone. Learn essential skills and advanced techniques to excel in any data-driven role.

Master data retrieval in Excel with our XLOOKUP and VLOOKUP course. Learn to efficiently find and analyze data, enhancing your spreadsheet skills for better decision-making.

Unlock the secrets of the criminal mind with our comprehensive "Crime Analyst with Interrogations And Confessions Psychology" bundle! In the UK alone, crime rates have surged by 15% in the last year, highlighting the critical need for crime analysis and investigation experts. This bundle equips you with a powerful skill set to navigate the complexities of modern crime. Delve into eight immersive CPD Accredited courses, each a standalone course: Course 01:- 8 Courses Bundle  Course 02: Accident Investigation Course 03: Criminal Law Course 04: Criminal Psychology and Profiling Course 05: Interrogations And Confessions Psychology Course 06: Anti-Money Laundering (AML) and Financial Crime Course 07: Forensic Science Level 3 Course Course 08: Human Rights Elevate your expertise in understanding crime from multiple angles with our "Crime Analyst with Interrogations And Confessions Psychology" bundle. Enrol now to unravel the secrets that lie within every investigation. Take advantage of this opportunity to delve into the fascinating world of crime analysis! Learning outcomes Master Criminal Investigation Techniques Expertise in Accident Investigation Comprehensive Understanding of Criminal Law Proficiency in Criminal Psychology and Profiling Mastery of Interrogations And Confessions Psychology Anti-Money Laundering and Financial Crime Prevention Get a head start on your career in crime analysis and investigative psychology with our comprehensive "Crime Analyst with Interrogations And Confessions Psychology" bundle. This thoughtfully curated collection of courses is your ticket to a dynamic and impactful role in criminal justice. Become familiar with investigative techniques, criminal law frameworks, and psychological insights that drive successful crime analysis. With a focus on decoding criminal behaviour and understanding the science of obtaining reliable information, this Crime Analyst with Interrogations And Confessions Psychology bundle equips you with the skills needed to excel in this competitive field. Learn how to navigate the complexities of financial investigations and uncover hidden patterns that reveal illicit activities. Discover the ethical considerations that underpin every facet of criminal justice, ensuring you're well-prepared to handle sensitive information and situations. By enrolling in this "Crime Analyst with Interrogations And Confessions Psychology" bundle, you're setting the stage for a successful career that's both personally satisfying and socially impactful. Don't just dream about a rewarding profession - make it a reality with our "Crime Analyst with Interrogations And Confessions Psychology" bundle. Your journey towards a promising career starts here. CPD 80 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Aspiring Crime Analysts Law Enforcement Professionals Legal Consultants and Advisors Private Investigators Students Pursuing Criminal Justice Studies Professionals in Financial Services Career path Upon completing the Crime Analyst bundle, you'll be equipped with a diverse skill set that opens doors to a range of compelling career paths like Crime Analyst (£20k - £50k+ per year) Criminal Investigator (£20k - £40k+ per year) Forensic Psychologist (£25k - £44k+ per year) Financial Crime Analyst (£20k - £60k+ per year) Legal Consultant (£25k - £80k+ per year) Certificates CPD Certificate Of Completion Digital certificate - Included 8 Digital Certificates Are Included With This Bundle CPD Quality Standard Hardcopy Certificate (FREE UK Delivery) Hard copy certificate - £9.99 Hardcopy Transcript - £9.99

Are you ready to embark on an enlightening journey of wisdom with the ERP Project Manager bundle, and pave your way to an enriched personal and professional future? If so, then Step into a world of knowledge with our course bundle - ERP Project Manager - CPD Certified. Delve into eight immersive CPD Accredited courses, each a standalone course: Course 01: Operations Management: Enterprise Resource Planning Course 02: Project Management Training Course 03: Project Management: How to Build a Project Charter Course 04: Business Analysis Course Level 5 Course 05: Leadership and Management Course Course 06: SAP Controlling (CO) - Product Costing S4HANA Course 07: Finance and Budgeting Course Course 08: Personal and Networking Skills Traverse the vast landscapes of theory, unlocking new dimensions of understanding at every turn. Let the ERP Project Manager - CPD Certified bundle illuminate your path to wisdom. The ERP Project Manager - CPD Certified bundle offers a comprehensive exploration into a rich tapestry of vast knowledge across eight carefully curated courses. The journey is designed to enhance your understanding and critical thinking skills. Each course within the bundle provides a deep-dive into complex theories, principles, and frameworks, allowing you to delve into the nuances of the subject matter at your own pace. In the framework of the ERP Project Manager - CPD Certified package, you are bestowed with complimentary PDF certificates for all the courses included in this bundle, all without any additional charge. Adorn yourself with the ERP Project Manager bundle, empowering you to traverse your career trajectory or personal growth journey with self-assurance. Register today and ignite the spark of your professional advancement! So, don't wait further and join the ERP Project Manager - CPD Certified community today and let your voyage of discovery begin! Learning Outcomes: Attain a holistic understanding in the designated areas of study with the ERP Project Manager bundle. Establish robust bases across each course nestled within the ERP Project Manager bundle. Decipher intricate concepts through the articulate content of the ERP Project Manager bundle. Amplify your prowess in interpreting, scrutinising, and implementing theories. Procure the capacity to engage with the course material on an intellectual and profound level. Become proficient in the art of problem-solving across various disciplines. Stepping into the ERP Project Manager bundle is akin to entering a world overflowing with deep theoretical wisdom. Each course within this distinctive bundle is an individual journey, meticulously crafted to untangle the complex web of theories, principles, and frameworks. Learners are inspired to explore, question, and absorb, thus enhancing their understanding and honing their critical thinking skills. Each course invites a personal and profoundly enlightening interaction with knowledge. The ERP Project Manager bundle shines in its capacity to cater to a wide range of learning needs and lifestyles. It gives learners the freedom to learn at their own pace, forging a unique path of discovery. More than just an educational journey, the ERP Project Manager bundle fosters personal growth, enabling learners to skillfully navigate the complexities of the world. The ERP Project Manager bundle also illuminates the route to a rewarding career. The theoretical insight acquired through this bundle forms a strong foundation for various career opportunities, from academia and research to consultancy and programme management. The profound understanding fostered by the ERP Project Manager bundle allows learners to make meaningful contributions to their chosen fields. Embark on the ERP Project Manager journey and let knowledge guide you towards a brighter future. CPD 80 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Individuals keen on deepening their firm understanding in the respective fields. Students pursuing higher education looking for comprehensive theory modules. Professionals seeking to refresh or enhance their knowledge. Anyone with a thirst for knowledge and a passion for continuous learning. Career path Armed with the ERP Project Manager bundle, your professional journey can reach new heights. The comprehensive theoretical knowledge from this bundle can unlock diverse career opportunities across several fields. Whether it's academic research, consultancy, or programme management, the ERP Project Manager bundle lays a solid groundwork. Certificates CPD Certificate Of Completion Digital certificate - Included 8 Digital Certificates Are Included With This Bundle CPD Quality Standard Hardcopy Certificate (FREE UK Delivery) Hard copy certificate - £9.99 Hard copy Transcript - £9.99