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

4334 Courses

Microsoft Excel Level 3

4.9(27)

By Apex Learning

Overview Master the use of the world's most popular data analysis and office tool, with absolutely no previous experience or training needed.This course will help you quickly become an expert in the use of Microsoft's best-selling Excel, allowing you to be a valuable asset to any business or organisation.The Microsoft Excel Level 3course will teach you how to manage finances, produce spreadsheets, and file invoices in no time. Our innovative training method will have you visualising and presenting company data efficiently. Learn to impress your peers and managers with your intuitive use of Excel and make sure that your administration skills are faultless. 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 Microsoft Excel Level 3. It is available to all students, of all academic backgrounds. Requirements Our Microsoft Excel Level 3 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 21 sections • 73 lectures • 10:39:00 total length •Introduction to Microsoft Excel 2019 New Features: 00:07:00 •CONCAT: 00:02:00 •IFS: 00:01:00 •MAXIFS: 00:01:00 •MINIFS: 00:01:00 •SWITCH: 00:02:00 •TEXTJOIN: 00:01:00 •Map Chart: 00:02:00 •Funnel Chart: 00:01:00 •Better Visuals: 00:06:00 •Pivot Table Enhancements: 00:02:00 •Power Pivot Updates: 00:01:00 •Navigate the Excel User Interface: 00:28:00 •Use Excel Commands: 00:10:00 •Create and Save a Basic Workbook: 00:19:00 •Enter Cell Data: 00:12:00 •Use Excel Help: 00:05:00 •Create Worksheet Formulas: 00:15:00 •Insert Functions: 00:17:00 •Reuse Formulas and Functions: 00:17:00 •Insert, Delete, and Adjust Cells, Columns, and Rows: 00:10:00 •Search for and Replace Data: 00:09:00 •Use Proofing and Research Tools: 00:07:00 •Apply Text Formats: 00:16:00 •Apply Number Format: 00:08:00 •Align Cell Contents: 00:09:00 •Apply Styles and Themes: 00:12:00 •Apply Basic Conditional Formatting: 00:11:00 •Create and Use Templates: 00:08:00 •Preview and Print a Workbook: 00:10:00 •Set Up the Page Layout: 00:09:00 •Configure Headers and Footers: 00:07:00 •Manage Worksheets: 00:05:00 •Manage Workbook and Worksheet Views: 00:07:00 •Manage Workbook Properties: 00:06:00 •Work with Ranges: 00:18:00 •Use Specialized Functions: 00:11:00 •Work with Logical Functions: 00:23:00 •Work with Date & Time Functions: 00:08:00 •Work with Text Functions: 00:11:00 •Sort Data: 00:10:00 •Filter Data: 00:10:00 •Query Data with Database Functions: 00:09:00 •Outline and Subtotal Data: 00:09:00 •Apply Intermediate Conditional Formatting: 00:07:00 •Apply Advanced Conditional Formatting: 00:05:00 •Create Charts: 00:13:00 •Modify and Format Charts: 00:12:00 •Use Advanced Chart Features: 00:12:00 •Create a PivotTable: 00:13:00 •Analyze PivotTable Data: 00:12:00 •Present Data with PivotCharts: 00:07:00 •Filter Data by Using Timelines and Slicers: 00:11:00 •Use Links and External References: 00:12:00 •Use 3-D References: 00:06:00 •Consolidate Data: 00:05:00 •Use Lookup Functions: 00:12:00 •Trace Cells: 00:09:00 •Watch and Evaluate Formulas: 00:08:00 •Collaborate on a Workbook: 00:19:00 •Protect Worksheets and Workbooks: 00:08:00 •Apply Data Validation: 00:13:00 •Search for Invalid Data and Formulas with Errors: 00:04:00 •Work with Macros: 00:18:00 •Create Sparklines: 00:07:00 •MapData: 00:07:00 •Determine Potential Outcomes Using Data Tables: 00:08:00 •Determine Potential Outcomes Using Scenarios: 00:09:00 •Use the Goal Seek Feature: 00:04:00 •Forecasting Data Trends: 00:05:00 •Excel Templates: 00:00:00 •Resources - Microsoft Excel - Beginner Course - Cpd Accredited: 00:00:00 •Assignment - Microsoft Excel Level 3: 00:00:00

Microsoft Excel Level 3
Delivered Online On Demand10 hours 39 minutes
£12

Microsoft Excel - 25 Must-Know Formulas and Functions

4.9(27)

By Apex Learning

Overview This comprehensive course on Microsoft Excel - 25 Must-Know Formulas and Functions will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Microsoft Excel - 25 Must-Know Formulas and Functions 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 Microsoft Excel - 25 Must-Know Formulas and Functions. It is available to all students, of all academic backgrounds. Requirements Our Microsoft Excel - 25 Must-Know Formulas and Functions 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 2 sections • 2 lectures • 01:12:00 total length •Must-Know Formulas and Functions: 01:12:00 •Resource - Microsoft Excel - 25 Must-Know Formulas and Functions: 00:00:00

Microsoft Excel - 25 Must-Know Formulas and Functions
Delivered Online On Demand1 hour 12 minutes
£12

Microsoft Excel: Master Power Query in 120 Minutes!

4.9(27)

By Apex Learning

Overview This comprehensive course on Microsoft Excel: Master Power Query in 120 Minutes! will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Microsoft Excel: Master Power Query in 120 Minutes! 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 Microsoft Excel: Master Power Query in 120 Minutes!. It is available to all students, of all academic backgrounds. Requirements Our Microsoft Excel: Master Power Query in 120 Minutes! 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 1 sections • 25 lectures • 02:25:00 total length •Power Query Intro and Excel version: 00:03:00 •Excel Power Query - Introduction: 00:03:00 •Excel Power Query - Query Editor Ribbon: 00:09:00 •Transform Data - Trim in Excel Power Query: 00:05:00 •Transform Data - Format Dates and Values in Excel Power Query: 00:02:00 •Transform Data - Parsing URLs in Excel Power Query: 00:05:00 •Transform Data - Split Text Fields in Excel Power Query: 00:10:00 •Transform Data - Group By in Excel Power Query: 00:03:00 •Transform Data - Unpivoting Columns in Excel Power Query: 00:05:00 •Transform Data - Pivoting Columns in Excel Power Query: 00:02:00 •Transform Data - Split Columns into Other Columns in Excel Power Query: 00:04:00 •Transform Data - Filtering Rows in Excel Power Query: 00:05:00 •Transform Data - Sorting Columns in Excel Power Query: 00:02:00 •Transform Data - Transform and Add Columns in Excel Power Query: 00:07:00 •From Folder - Import From Folder in Excel Power Query: 00:07:00 •From Folder - Doing Auto Cleanup in Excel Power Query: 00:13:00 •From Folder - Extract Data from Forms in Excel Power Query: 00:13:00 •From Workbook - Extract Multiple Criteria in Excel Power Query: 00:05:00 •From Workbook - Extract Multiple Worksheets in Excel Power Query: 00:04:00 •Joins - Intro to Joins: 00:04:00 •Joins - Merging: 00:08:00 •Joins - Full Outer Join: 00:06:00 •Joins - Right Anti Join: 00:09:00 •Power Query - Convert Reports into Pivot Tables: 00:05:00 •Modulo: 00:06:00

Microsoft Excel: Master Power Query in 120 Minutes!
Delivered Online On Demand2 hours 25 minutes
£12

Upgrade Excel Skill: 50 Best Tips

4.8(9)

By Skill Up

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

Upgrade Excel Skill: 50 Best Tips
Delivered Online On Demand2 hours 57 minutes
£25

Compliance Management

5.0(1)

By LearnDrive UK

Compliance Management Course will guide you to understand child psychology issues and development, including its various stages.

Compliance Management
Delivered Online On Demand1 hour
£5

ISO 9001:2015 Quality Management

5.0(1)

By LearnDrive UK

Master ISO 9001:2015 Quality Management standards. From leadership to performance evaluation, this course provides a comprehensive guide to implementing effective quality management systems in your organization.

ISO 9001:2015 Quality Management
Delivered Online On Demand1 hour
£5

Probate Real Estate Investment Diploma

5.0(1)

By Empower UK Employment Training

Unlock the potential of real estate investing with our comprehensive course. Master probate deals, financing, and marketing while boosting your mindset. Start your journey now!

Probate Real Estate Investment Diploma
Delivered Online On Demand6 hours
£5

Day Trading & Scalping Strategies

4.5(3)

By Studyhub UK

Unravel the complexities of financial markets with the 'Day Trading & Scalping Strategies' course. This program is a comprehensive guide for those aspiring to master the art of quick, profitable trading. The course begins with an introduction to the fundamental concepts of day trading and scalping, setting a solid foundation for more advanced strategies. Learners are introduced to a variety of tools and techniques, each designed to navigate the fast-paced world of short-term trading. The curriculum is crafted to ensure a deep understanding of market dynamics and the skills needed to make informed trading decisions. Advance through the course to explore specialized strategies using tools like MACD, Moving Averages, RSI, and EMA's, each section providing a detailed approach to utilizing these indicators effectively. The course also emphasizes the critical aspect of risk management, ensuring traders are well-equipped to handle market volatility. As you progress, you'll encounter strategies tailored for different markets, including cryptocurrencies, forex, and stocks, offering a broad perspective on day trading and scalping techniques. The final section provides bonus content, further enriching your trading toolkit. Whether you're a novice looking to enter the world of trading or an experienced trader seeking to refine your strategies, this course offers valuable insights and practical skills. Learning Outcomes Understand the principles and techniques of day trading and scalping. Develop skills in utilizing MACD, Moving Averages, RSI, and EMA's for trading strategies. Master the art of risk management in day trading. Learn specialized strategies for trading in crypto, forex, and stock markets. Enhance decision-making abilities in fast-paced trading environments. Why choose this Day Trading & Scalping Strategies course? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards and CIQ after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the Course at your own pace, on your own schedule. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience. Unlock career resources for CV improvement, interview readiness, and job success. Who is this Day Trading & Scalping Strategies course for? Individuals interested in learning day trading and scalping techniques. Traders seeking to diversify their strategy portfolio. Beginners aiming to enter the financial trading market. Investors looking to enhance their short-term trading skills. Finance professionals seeking advanced trading strategies. Career path Day Trader: £30,000 - £100,000+ Financial Analyst: £35,000 - £60,000 Risk Manager: £40,000 - £70,000 Trading Strategy Consultant: £45,000 - £80,000 Cryptocurrency Trader: £30,000 - £90,000+ Forex Trader: £30,000 - £100,000+ Prerequisites This Day Trading & Scalping Strategies does not require you to have any prior qualifications or experience. You can just enrol and start learning. This course was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Certification After studying the course materials, there will be a written assignment test which you can take at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £4.99 Original Hard Copy certificates need to be ordered at an additional cost of £8. Course Curriculum Section 01: Introduction Introduction to the Course 00:04:00 Section 02: Risk Management Introduction to Risk Management 00:02:00 What a Risk Management? 00:03:00 Why Risk Management is So Important 00:18:00 Why You Have to Manage Your Risk 00:18:00 My Risk Management System 00:12:00 You Can't Progress in Something That You Don't Measure 00:09:00 Section 03: Professional Day trading/Scalping strategy with MACD Introduction 00:02:00 Trading on 2 different timeframe 00:10:00 How to add it to your screen 00:05:00 The rules that you have to follow 00:15:00 Let's practice it 00:30:00 Results from the practice 00:10:00 Class project 00:01:00 Section 04: Day trading / scalping PRO strategy with Moving averages Introduction 00:04:00 How to put it on your screen 00:05:00 The criteria needed 00:19:00 Entries, exits and stop losses practice 00:24:00 51% profits on the account in 6 weeks on 1 pair 00:15:00 Class project 00:01:00 Section 05: Day trading / scalping strategy with RSI and EMA's Introduction 00:03:00 The setup 00:09:00 The Criteria 00:14:00 Practice 00:30:00 22 % profit on account in 30 trades 00:14:00 68 % Win Rate 00:01:00 Section 06: Day trading strategies with Stochastic indicator and EMA's Introduction 00:03:00 Why you have to be using multiple timeframes 00:09:00 Introduction to using Stochastic indicator with an EDGE 00:08:00 First strategy - How to set it up on your chart 00:07:00 First strategy - Criteria 00:30:00 First strategy - Practice 00:20:00 Second strategy - Criteria 00:12:00 Second strategy - Practice 00:15:00 Class project 00:01:00 Section 07: 2 Scalping/ Day trading strategies for Crypto/Forex/Stocks Introduction 00:03:00 The first Scalping / Day trading strategy 00:14:00 Volatility is key 00:08:00 Practice of the First strategy 00:17:00 Second scalping / day trading strategy and how to set it up 00:04:00 Criteria for the second strategy 00:04:00 Backtesting the second strategy 00:23:00 Class project 00:01:00 Section 08: Bonus How to Know When to Take Profits 00:35:00 Hull Moving Average 00:06:00 7 Habits Belief of Successful Traders 00:17:00 Momentum Play with Multiple Timeframes 00:20:00 Assignment Assignment - Day Trading & Scalping Strategies in 2021 00:00:00

Day Trading & Scalping Strategies
Delivered Online On Demand8 hours 55 minutes
£10.99

ADVANCED VALUATION FOR INSTITUTIONAL INVESTORS

By Behind The Balance Sheet

This course was developed for one of the largest investment institutions in the world, a multi-trillion household name. We explain in detail our tips and tricks to build an accurate and rolling enterprise value, and then review different valuation methodologies, from DCF, through the sum of the parts and football field analyses to LTV/CAC based methods. We conclude with a series of case studies examining the valuation of individual stocks.

ADVANCED VALUATION FOR INSTITUTIONAL INVESTORS
Delivered In-Person in InternationallyFlexible Dates
Price on Enquiry

MB-335T00: Microsoft Dynamics 365 Supply Chain Management, Expert

By Nexus Human

Duration 5 Days 30 CPD hours This course is intended for This course is designed for the Dynamics 365 Supply Chain Management Functional Consultant Expert or those whose role includes implementing and configuring advanced features of Dynamics 365 Supply Chain Management. Overview Objectives: Create products as type Item and Service. Set up product unit conversions. Set up transfer orders Set up default order settings. Create product masters with predefined variants. Create and set up category hierarchies. Create product attributes. Create bill of materials using BOM designer Discrete manufacturing concepts Production order statuses Production stages Bill of materials (BOM) Resources Routes and operations Configure commodity pricing in Supply Chain Management. Configure product compliance in Supply Chain Management. Configure commodity pricing in Supply Chain Management. Configure product compliance in Supply Chain Management. Configure process manufacturing. Create and configure catch weight items. Configure approved vendors. Understand the features in engineering change management. Learn how the end-to-end engineering change management process works. Set up engineering organizations. Work with product versioning. Create dimension groups by using the version dimensions. Create product life cycle states. Use engineering categories. Set up engineering change severities and severity rules. Set up product owners. Use a workflow with engineering change management. Create an engineering change request. Learn about business impacts. Create an engineering change order. Important terminology to help you understand the concepts and processes that are associated with product configuration. Product configuration end-to-end scenario. Different areas that span the product configuration process. The product configuration model. How to build a product configuration model. Configure the costing sheet. Perform BOM calculation and analyze costs by using the costing sheet. IoT intelligence and insights in Supply Chain Management This course is designed to build your in Dynamics 365 Supply Chain Management application knowledge. This course will cover the most important features and functionalities needed by Dynamics 365 Supply Chain Management functional consultant including: The product information and how to configure, create, and manage your product and inventory. Supply chain management configuration and processing. The transportation management features, and the warehouse management features. Asset Management functionalities. Master planning configuration and processing. Sales and procurement processes. Create products and product masters in Dynamics 365 Supply Chain Management Product information workspace Concept of a product Create products Set up unit conversions Batch disposition codes Default order settings Define products as not stocked Create product masters with variants Gain productivity by using the Variant suggestions page Create and set up category hierarchies and attributes Set up item pricing Create bill of materials in Dynamics 365 Supply Chain Management Work with the BOM designer BOM and formula versions BOM line types BOM levels Get started with discrete manufacturing in Dynamics 365 Supply Chain Management Discrete manufacturing life cycle Master planning and planned production orders Bills of materials Working with BOM and item configurations Create a bill of materials Production orders Work with commodity pricing and compliance in Dynamics 365 Supply Chain Management Configure commodity pricing Configure product compliance Configure process manufacturing in Dynamics 365 Supply Chain Management Process manufacturing item types Production type setup Set up packaging and batch attributes Shelf life related setup Item model group, product compliance, and approved vendors Catch weight Transaction adjustments Catch weight item handling policy Catch weight tags Configure approved vendors Get started with Engineering Change Management for Dynamics 365 Supply Chain Management Overview of features End-to-end walkthrough of features Set up versioned products in Dynamics 365 Supply Chain Management Create an engineering organization Create nomenclature for product versions Create product version number rules Create product dimension groups by using the version dimension Create product life cycle states Engineering attributes Product readiness policies Product release policies Create engineering categories Configure engineering change management for Dynamics 365 Supply Chain Management Set up engineering change severities Set up severity rule sets Set up product owners Engineering workflows Request and follow up with product changes in Dynamics 365 Supply Chain Management Engineering change requests Engineering change orders up with product changes in Dynamics 365 Supply Chain Management Get started with product configuration in Dynamics 365 Supply Chain Management Elements of a product configuration model Expression constraints and table constraints in product configuration models Validate and test a product configuration model Finalize a model for configuration Set up a product configuration model Calculations for product configuration models Solver strategy for product configuration Reuse product configurations Release a product configuration model Customize a product configuration model Work with the costing sheet in Dynamics 365 Supply Chain Management Costing versions Cost groups Calculation groups Costing sheets BOM calculations BOM Measurements BOM Reports Configure formulas for process manufacturing in Dynamics 365 Supply Chain Management Formulas, formula lines, and formula versions Formula features Approve and activate formulas and formula versions Use step consumption Coproducts By-products Burden allocation Planning items Get started with production control in Dynamics 365 Supply Chain Management Core concepts in production control Understand unified manufacturing Manufacturing principles Overview of the production process and production life cycle Batch orders Discrete manufacturing Process manufacturing Lean manufacturing Configure production control for unified manufacturing Capacity planning Integration between the General ledger and the Production control modules IoT intelligence and insights Describe the value proposition for mixed-reality Guides for production floor workers Use warehouse management for manufacturing in Dynamics 365 Supply Chain Management Production input location Production output location Staging and order picking Release BOM and formula lines to the warehouse Cross-docking Planned cross docking Visibility into material exceptions Work with manufacturing execution in Dynamics 365 Supply Chain Management Understand the manufacturing executions Identify roles in manufacturing execution Planning consideration for manufacturing execution Configure manufacturing execution Setup time and attendance for manufacturing execution processes Control production with manufacturing execution Create and process report as finished journals with co-products and by-products Calculate and approve raw time registrations Report as finished from the job card device Get started with Asset Management for Dynamics 365 Supply Chain Management Asset Management terminology and concepts Functional locations and assets Assets and work orders Install the Asset Management mobile workspace Use the Asset Management mobile workspace Asset Management integration capabilities Integrate Asset Management with Dynamics 365 Guides Schedule work orders in Asset Management for Dynamics 365 Supply Chain Management Configure workers for work order scheduling Schedule and dispatch work orders Calculate capacity load on scheduled work orders Configure and perform the procure-to-purchase process in Dynamics 365 Supply Chain Management Procurement scenario Overview of the procure-to-purchase process Set up procurement categories Use procurement catalogs Create a purchase requisition Create and process a request for quotation Create purchase orders Vendor categories and catalogs Evaluate a vendor and put a vendor on hold Use purchasing policies Configure activity-based subcontracting and production flow costing in Dynamics 365 Supply Chain Management Subcontracting capabilities Subcontracting a vendor Subcontracting service Transfer activities as subcontracting activities Subcontracting as an alternate resource Cost accounting of subcontracted services Subcontracting cost flow Backflush costing Products and material in Work in Progress Standard cost Costing lean manufacturing Calculation of standard cost Calculate unused quantities Calculation of production variances to standard cost Ledger entries created from processing a production flow Configure and use agreements in Dynamics 365 Supply Chain Management Work with trade agreements Create sales agreements Create purchase agreements Configure trade allowance management Configure brokerage contract management Configure royalty contract management Configure vendor rebates Rebate management module Work with capa Additional course details: Nexus Humans MB-335T00: Microsoft Dynamics 365 Supply Chain Management, Expert 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 MB-335T00: Microsoft Dynamics 365 Supply Chain Management, Expert 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.

MB-335T00: Microsoft Dynamics 365 Supply Chain Management, Expert
Delivered OnlineFlexible Dates
Price on Enquiry