3146 Accounting & Finance courses in Linlithgow delivered Online

Course overview Financial analysis is a crucial part of a successful business. It helps companies to make informed decisions regarding investing. Learn how to make a practical analysis of financial statements with this Financial Statement Analysis Masterclass program.  This Financial Statement Analysis Masterclass course explains the steps involved in a practical financial statement analysis in detail. It will also educate you on the importance of financial accounting in businesses. Going through the lesson, you will develop a comprehensive understanding of GAAP rules, correct timing, earnings management and financial valuation. In addition, you will understand the importance and purpose of executive compensation and identify its major components. You will also learn how to prepare and analyze a balance sheet and the steps to prepare a cash flow statement.  Learning outcomes Explore the steps to an effective financial analysis Understand the GAAP requirements for creating financial statements Deepen your understanding of earnings management Learn about applying ratios Deepen your understanding of owner's equity Know how to prepare a cash flow statement Who Is This Course For? This Financial Statement Analysis Masterclass course is highly beneficial for anyone interested in learning the steps for an effective financial statement analysis. In addition, the skills gained from this training will provide excellent opportunities for career advancement.  Entry Requirement This course is available to all learners of all academic backgrounds. Learners should be aged 16 or over. Good understanding of English language, numeracy and ICT skills are required to take this course. Certification After you have successfully completed the course, you will obtain an Accredited Certificate of Achievement. And, you will also receive a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hardcopy for £39 or in PDF format at the cost of £24. PDF certificate's turnaround time is 24 hours, and for the hardcopy certificate, it is 3-9 working days. Why Choose Us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos and materials from the industry-leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; United Kingdom & internationally recognized accredited qualification; Access to course content on mobile, tablet and desktop from anywhere, anytime; Substantial career advancement opportunities; 24/7 student support via email. Career Path The Financial Statement Analysis Masterclass Course provides essential skills that will make you more effective in your role. It would be beneficial for any related profession in the industry, such as: Financial Analyst Financial Advisor Financial Planning Analysis Manager Financial and Management Accountant Introduction to the Course Introduction 00:02:00 Module 01: Why Analyse Financial Statements? Why Analyse Financial Statements? 00:10:00 Module 02: GAAP Rules GAAP Rules 00:10:00 Module 03: Correct Timing Correct Timing 00:15:00 Module 04: Earnings Management Earnings Management 00:11:00 Module 05: Balance Sheet Balance Sheet 00:11:00 Module 06: Balance Sheet Part-2 Balance Sheet Part-2 00:11:00 Module 07: Balance Sheet Part-3 Balance Sheet Part-3 00:07:00 Module 08: Statement of Cash Flow Statement of Cash Flow 00:07:00 Module 09: Time Series Time Series 00:11:00 Module 10: Ratios- Introduction Ratios- Introduction 00:16:00 Module 11: Applying Ratios Applying Ratios 00:19:00 Module 12: Valuation Valuation 00:14:00 Module 13: Credits Credits 00:07:00 Module 14: Contracts Contracts 00:10:00 Module 15: Executive Compensation Executive Compensation 00:12:00 Module 16: Lease Lease 00:08:00 Module 17: Owners' Equity Owners' Equity 00:07:00 Module 18: Earnings Per Share Earnings Per Share 00:16:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Overview This comprehensive course on Key Account Management Course will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Key Account Management Course comes with accredited certification, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this Key Account Management Course. It is available to all students, of all academic backgrounds. Requirements Our Key Account Management Course is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management, Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 14 sections • 13 lectures • 05:44:00 total length •Introduction to Key Account Management: 00:32:00 •Purpose of Key Account Management: 00:26:00 •Understanding Key Accounts: 00:28:00 •Elements of Key Account Management: 00:37:00 •What Makes a Good Key Account Manager: 00:35:00 •Building and Delivering Value to Key Accounts: 00:21:00 •Key Account Planning: 00:22:00 •Business Customer Marketing and Development: 00:29:00 •Developing Key Relationships: 00:42:00 •The Importance of Record Keeping for Key Account Management: 00:18:00 •Internal KAM Aspects: 00:26:00 •The Value Proposition: 00:28:00 •Assignment - Key Account Management: 00:00:00

Overview This comprehensive course on Create Website for Accounting Business will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Create Website for Accounting Business comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this Create Website for Accounting Business. It is available to all students, of all academic backgrounds. Requirements Our Create Website for Accounting Business is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more!   Course Curriculum 3 sections • 21 lectures • 00:55:00 total length •Introduction: 00:01:00 •Importance of an Online Presence of an Accounting Firm: 00:03:00 •Multi-Page Accounting Website - Part 1: 00:03:00 •Multi-Page Accounting Website - Part 2: 00:02:00 •Single-Page Accounting Website: 00:03:00 •How to Build a Multi-Page Accounting Website Using WIX: 00:04:00 •How to Edit the Homepage of an Accounting Website: 00:06:00 •How to Edit the About Page, Service Page and Contact Page: 00:04:00 •How to Make an Accounting Website Mobile Friendly: 00:03:00 •A Brief View: 00:01:00 •Set Up Wix Editor: 00:02:00 •Dashboard - Part 1: 00:02:00 •Dashboard - Part 2: 00:03:00 •Edit the Header Part 1: 00:03:00 •Edit the Header Part 2: 00:03:00 •Edit the Hero Section: 00:03:00 •Edit the Services Section Part 1: 00:05:00 •Edit the Services Section Part 2: 00:02:00 •Edit the Contact Section and Footer: 00:01:00 •Mobile Version: 00:01:00 •Assignment -Create Website for Accounting Business: 00:00:00

Overview This comprehensive course on Content Management will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Content Management comes with accredited certification which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is this course for? There is no experience or previous qualifications required for enrolment on this Content Management. It is available to all students, of all academic backgrounds. Requirements Our Content Management is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible on tablets and smartphones so you can access your course on wifi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career path Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management, Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 8 sections • 8 lectures • 02:55:00 total length •Introduction to Content Management: 00:13:00 •Content Management System (CMS): 00:27:00 •Basics of Content Management Systems: 00:26:00 •Content Strategy: 00:24:00 •Content Marketing: 00:25:00 •Content Marketing Tools and Tactics: 00:31:00 •Content Marketing Strategy: 00:29:00 •Assignment - Content Management: 00:00:00

Overview This comprehensive course on Management Accounting Tools will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Management Accounting Tools comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this Management Accounting Tools. It is available to all students, of all academic backgrounds. Requirements Our Management Accounting Tools is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more!   Course Curriculum 14 sections • 15 lectures • 02:59:00 total length •Introduction to Management Account: 00:04:00 •Manufacturing Costs and Financial Statements: 00:15:00 •Traditional Costing System - Job and Process: 00:12:00 •Activity Based Costing System: 00:14:00 •Activity Based Management: 00:05:00 •Cost Behaviour and the Contribution Margin: 00:22:00 •Cost Volume Profit: 00:12:00 •Cost Volume Profit Analysis: 00:18:00 •Incremental Analysis in Decision Making: 00:15:00 •Budget Planning: 00:15:00 •Responsibility Accounting Lecture: 00:18:00 •Budget Control Lecture: 00:15:00 •Control Using Standard Costs and the Balanced Scorecard: 00:14:00 •Resources: 00:00:00 •Assignment - Management Accounting Tools: 00:00:00

Description: This Certified Information Systems Auditor (CISA) - Complete Video Course will provide you with the knowledge and proficiency to prepare for the globally recognized CISA certification exam. The CISA certification has become very popular since it originated in 1978, and is a benchmark for IS audit, security, control, and assurance personnel to validate your skill set. This course will immerse you into the subject, with in-depth coverage of the information covering the five domains that make up the 'Body of Knowledge' for the CISA exam and will provide you the tools to build your technical skills to develop, manage, and perform IT security audits. Being CISA-certified showcases your audit experience, skills and knowledge, and demonstrates you are capable to assess vulnerabilities, report on compliance and institute controls within the enterprise. So, enhance your career by earning CISA - world-renowned as the standard of achievement for those who audit, control, monitor and assess information technology and business system 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? Certified Information Systems Auditor (CISA) - Complete Video Course 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 Certified Information Systems Auditor (CISA) - Complete Video Course 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. The Process of Auditing Information Systems Management of the Audit Function FREE 00:20:00 ISACA IT Audit and Assurance Standards and Guidelines 01:16:00 Risk Analysis 00:21:00 Internal Controls 00:17:00 Performing An IS Audit 01:07:00 Control Self-Assessment 00:09:00 The Evolving IS Audit Process 00:12:00 Governance and Management of IT Corporate Governance 00:06:00 IT Governance 00:02:00 IT Monitoring and Assurance Practices for Board and Senior Management 00:40:00 Information Systems Strategy 00:05:00 Maturity and Process Improvement Models 00:01:00 IT Investment and Allocation Practices 00:05:00 Policies and Procedures 00:17:00 Risk Management 00:31:00 IS Management Practices 00:50:00 IS Organizational Structure and Responsibilities 00:17:00 Auditing IT Governance Structure and Implementation 00:06:00 Business Continuity Planning 00:37:00 Information Systems Acquisition, Development and Implementation Business Realization 01:21:00 Project Management Structure 00:08:00 Project Management Practices 00:18:00 Business Application Development 00:42:00 Business Application Systems 00:38:00 Alternative Forms of Software Project Organization 00:03:00 Alternative Development Methods 00:10:00 Infrastructure Development/Acquisition Practices 00:09:00 Information Systems Maintenance Practices 00:09:00 System Development Tools And Productivity Aids 00:05:00 Business Process Reengineering And Process Change Projects 00:08:00 Application Controls 00:07:00 Auditing Application Controls 00:14:00 Auditing Systems Development, Acquisition And Maintenance 00:08:00 Information Systems Operations, Maintenance and Support Information Systems Operations 00:19:00 Information Systems Hardware 00:13:00 IS Architecture and Software 00:39:00 Network Infrastructure 01:16:00 Disaster Recovery Planning 00:19:00 Protection of Information Assets Importance Of Information Security 00:43:00 Logical Access 00:37:00 Network Infrastructure Security 00:39:00 Auditing Information Security Management Framework 00:03:00 Auditing Network Infrastructure Security 00:13:00 Environmental Exposures and Controls 00:02:00 Physical Access Exposures and Controls 00:05:00 Mobile Computing 00:05:00 Mock Exam Mock Exam- Certified Information Systems Auditor (CISA) - Complete Video Course 00:20:00 Final Exam Final Exam- Certified Information Systems Auditor (CISA) - Complete Video Course 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

🚀 Unlock Your Excel Potential with the Microsoft Excel Crash Course 2024: Masterclass for Weekend! 🚀 Are you tired of spending endless hours trying to figure out Microsoft Excel on your own? Do you want to boost your skills and become an Excel pro without sacrificing your entire weekend? Look no further - our Microsoft Excel Crash Course 2024 is here to revolutionize the way you work with spreadsheets!   🔥 Why Excel Matters: In today's data-driven world, Excel proficiency is a non-negotiable skill. Whether you're a student, a professional, or someone looking to enhance your productivity, mastering Excel can open doors to new opportunities.   💡 What Sets Our Masterclass Apart: ✅ Weekend-Friendly Format: We get it - your time is precious! That's why our course is designed to be completed over a weekend, giving you the skills you need without disrupting your busy schedule. ✅ Hands-On Learning: Forget boring lectures! Dive straight into hands-on, practical exercises that reinforce your learning. Our step-by-step approach ensures you grasp each concept thoroughly. ✅ Up-to-Date Content: Excel evolves, and so do we! Our 2024 edition is packed with the latest features and best practices, ensuring you're on the cutting edge of spreadsheet mastery. ✅ Expert Guidance: Learn from seasoned Excel experts who've cracked the code to efficient and effective spreadsheet use. Benefit from their real-world insights and insider tips that go beyond basic functions. ✅ Lifetime Access: Purchase once, benefit forever! Gain access to our course materials, updates, and a supportive community, ensuring you stay on top of your Excel game for years to come.   📚 Course Highlights: 👉 Essential Excel Functions: From basic formulas to advanced functions, we cover it all. 👉 Data Visualization: Transform your data into impactful charts and graphs. 👉 Pivot Tables Mastery: Unlock the power of data analysis with Pivot Tables. 👉 Time-Saving Shortcuts: Work smarter, not harder, with keyboard shortcuts. 👉 Advanced Formulas: Impress your colleagues with advanced calculations. 👉 Automation with Macros: Streamline your tasks with Excel automation. 👉 Error Handling: Learn how to troubleshoot and avoid common mistakes.   🎓 Who Should Enroll: Professionals looking to enhance their spreadsheet skills. Students aiming to boost their academic performance. Entrepreneurs and business owners seeking data-driven insights. Anyone wanting to save time and increase productivity.   🌟 Get Ready to Excel! Don't miss out on this opportunity to become an Excel maestro in just one weekend! Enroll now in the Microsoft Excel Crash Course 2024: Masterclass for Weekend and empower yourself with the skills that will set you apart. 👉 Limited seats available. Secure your spot now! 👈 Disclaimer: Results may vary based on individual commitment and practice. Course Curriculum Module- 1 Introduction 00:00 Getting started on Windows, macOS, Android, and IOS 00:00 How to ask great questions 00:00 FAQ 00:00 Start Excel 00:00 Module- 2 Overview of top Excel tips 00:00 Add numbers like a pro 00:00 Save time by filling cells automatically 00:00 Did data enter into one column - Split it 00:00 Switch data around by transposing it 00:00 Sort and filter for quick results 00:00 Create a data table for tasks to make it easy 00:00 Make drop-down list 00:00 Quick Data Analysis 00:00 Great charts for your visualization 00:00 Pivot Tables for Data Analytics 00:00 Module- 3 Introduction 00:00 Basic formula operations 00:00 Mathematical functions level1 00:00 Mathematical functions level2 00:00 Text functions level1 00:00 Text functions level2 00:00 Logical functions 00:00 Date time functions 00:00 V Lookup formula 00:00 HLookup formula 00:00 HLookup Match formula 00:00 Match Index formula 00:00 Module- 4 Introduction 00:00 XLookup 00:00 Handling NA and Approximates match in XLookup 00:00 Wildcard matching in XLookup 00:00 Module- 5 Introduction 00:00 Split Text into columns 00:00 Flash Fill 00:00 Remove Duplicates 00:00 Data Validation 00:00 Get - import Data from Text 00:00 Get - import Data from CSV 00:00 Module- 6 Introduction 00:00 Creating Pivot Table 00:00 Value field settings 00:00 Number format 00:00 Pivot Table Design 00:00 Excel Exercise 00:00 Solution for Excel Exercise 00:00 Module- 7 Introduction 00:00 Excel Charts - Categories 00:00 Elements of a chart 00:00 Easy way to create charts 00:00 Column or Bar charts 00:00 Formatting charts 00:00 Line charts 00:00 Area charts 00:00 Pie and Doughnut charts 00:00 Format Area Plot or XY chart 00:00 Scatter or bubble charts 00:00

Overview   With the ever-increasing demand for MS Excel 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 MS Excel may be.   Learning about MS Excel 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 MS Excel. 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 MS Excel 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 Microsoft Excel Beginner to Intermediate 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 Microsoft Excel Beginner to Intermediate 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 Microsoft Excel Beginner to Intermediate 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 MS Excel, Jobseekers in the relevant domains, Anyone with a ground knowledge/intermediate expertise in MS Excel, Anyone looking for a certificate of completion on doing an online training on this topic, Students of MS Excel, or anyone with an academic knowledge gap to bridge, Anyone with a general interest/curiosity   Career Path   This Microsoft Excel Beginner to Intermediate 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 01-Excel Interface Module 01-Excel Interface 00:00 Module-02-Basic Functions Module-02-Basic Functions 00:00 Module-03-Working With Worksheet Module 03-Working With Worksheet 00:00 Module-04-Work with Data and Excel tables Module-04-Work with Data and Excel tables 00:00 Module-05-Basic Calculations Module-05-Basic Calculations 00:00 Module-06-Shortcuts in Excels Module-06-Shortcuts in Excels 00:00

Overview   With the ever-increasing demand for NFT 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 NFT may be.   Learning about NFT 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 NFT. 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 NFT 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 NFT Crash 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 NFT Crash 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 NFT Crash 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 NFT, Jobseekers in the relevant domains, Anyone with a ground knowledge/intermediate expertise in NFT, Anyone looking for a certificate of completion on doing an online training on this topic, Students of NFT, or anyone with an academic knowledge gap to bridge, Anyone with a general interest/curiosity   Career Path   This NFT Crash 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 NFTs or Non Fungible Tokens NFTs or Non Fungible Tokens 00:00 Module 2 - DEFI (Decentralized Finance) DEFI (Decentralized Finance) 00:00

🌟 Unlock Your Excel Potential with Microsoft Excel 2019 - Intermediate Level Training! 🌟 Master the art of Excel with our comprehensive online course designed specifically for intermediate learners. Elevate your skills, boost productivity, and excel in spreadsheet management like never before. 📊 Course Curriculum 📊 🔹 Section 1 - Excel - Intermediate: Dive into the intermediate level of Excel functionalities, bridging the gap between basic and advanced techniques. 🔹 Section 2 - Lists: Learn the art of managing data efficiently with lists, organizing information for streamlined analysis and presentation. 🔹 Section 3 - DataBase Functions: Harness the power of database functions, empowering you to manipulate data with ease and precision. 🔹 Section 4 - Data Validation: Ensure data accuracy and integrity by implementing effective data validation techniques, preventing errors in your spreadsheets. 🔹 Section 5 - Importing and Exporting: Master the process of importing and exporting data seamlessly, integrating external information into your Excel sheets effortlessly. 🔹 Section 6 - Creating Basic Charts: Transform data into impactful visuals with basic chart creation, enhancing your ability to communicate insights effectively. 🔹 Section 7 - Pivot Tables: Unlock the potential of pivot tables, harnessing their analytical power to summarize and analyze complex data sets effortlessly. 🔹 Section 8 - Working with Large Data: Navigate and manipulate extensive data sets efficiently, optimizing your workflow with strategies tailored for large-scale information. 🔹 Section 9 - LookUp Functions: Explore lookup functions to search for and retrieve specific data, refining your ability to find information swiftly. 🔹 Section 10 - Advanced Functions: Elevate your Excel proficiency with advanced functions, expanding your capabilities to handle complex calculations and tasks. 🔹 Section 11 - Excel Intermediate - Conclusion: Wrap up your intermediate Excel journey, reinforcing key concepts and preparing you for further advancements. 🎓 Why Choose Our Course? 🎓 🚀 Comprehensive Learning: A structured curriculum tailored to the needs of intermediate Excel users, covering a wide array of functionalities. 👨‍🏫 Expert Guidance: Led by industry experts well-versed in Excel, ensuring a rich learning experience with practical insights. 🤝 Interactive Learning: Engage with interactive exercises and real-life examples, solidifying your understanding through hands-on practice. 📈 Career Growth: Acquire skills highly sought after in the job market, giving you a competitive edge in various professional domains. 🔓 Don't miss this opportunity to take your Excel skills to the next level! Enroll now and unleash your potential with Microsoft Excel 2019 - Intermediate Level Training. 🔓 Course Curriculum Section 1 - Excel - Intermediate Excel Intermediate Introduction 00:00 Intermediate Shortcut Keys 00:00 Section 2 - Lists What are Lists 00:00 Sorting a List 00:00 Sorting - Multiple Criteria 00:00 Custom Sort 00:00 What are Filters 00:00 Format a List as a Table 00:00 Section 3 - DataBase Functions Introduction to DataBase Functions 00:00 DSum Function 00:00 DSum Function - Single Criteria 00:00 DSum Function - Multiple Criteria 00:00 DAverage 00:00 DCount Function 00:00 Subtotal 00:00 Section 4 - Data Validation Data Validation - List 00:00 Data Validation - Decimal 00:00 Input and Error Messages 00:00 Section 5 - Importing and Exporting Importing Data from Text Files 00:00 Importing Data from MS Access 00:00 Exporting Data to a Text File 00:00 Section 6 - Creating Basic Charts Creating Basic Charts 00:00 The Chart Ribbon 00:00 Adding and Modifying Data on a Chart 00:00 Formatting Charts 00:00 Section 7 - Pivot Tables Understanding Pivot Tables 00:00 Creating Pivot Tables 00:00 Pivot Table Calculations 00:00 Grouping Pivot Table Data 00:00 Formatting Pivot Table Data 00:00 Drilling Down into Pivot Table Data 00:00 Creating Pivot Charts 00:00 Filtering Pivot Table Data 00:00 Filtering using the Slicer 00:00 Section 8 - Working with Large Data Grouping Data 00:00 Consolidating Data 00:00 Section 9 - LookUp Functions VLookUp 00:00 HLookUp 00:00 Index and Match 00:00 Section 10 - Advanced Functions FV Function 00:00 PMT Function 00:00 Hyperlinks 00:00 Text to Columns 00:00 Section 11 - Excel Intermediate - Conclusion Excel Intermediate - Conclusion 00:00