1012 Mapping courses

This comprehensive course will guide you to use the power of Python to evaluate recommender system datasets based on user ratings, user choices, music genres, categories of movies, and their years of release with a practical approach to build content-based and collaborative filtering techniques for recommender systems with hands-on experience.

Duration 2 Days 12 CPD hours This course is intended for This course is intended for network administrators, operators, and engineers responsible for managing the normal day-to-day operation and administration of a BIG-IP application delivery network. This course presents the prerequisite knowledge for many other of F5's BIG-IP instructor-led training courses. Overview Getting started with the BIG-IP system Traffic processing with BIG-IP Local Traffic Manager (LTM) Using the TMSH (TMOS Shell) command line interface Using NATs and SNATs Monitoring application health and managing object status Modifying traffic behavior with profiles, including SSL offload and re-encryption Modifying traffic behavior with persistence, including source address affinity and cookie persistence Troubleshooting the BIG-IP system, including logging (local, high-speed, and legacy remote logging), and using tcpdump User roles and administrative partitions vCMP concepts Customizing application delivery with iRules This course gives network administrators, network operators, and network engineers a functional understanding of the BIG-IP system as it is commonly deployed in an application delivery network. The course introduces students to the BIG-IP system, its configuration objects, how it processes traffic, and how typical administrative and operational activities are performed. The course includes lecture, hands-on labs, interactive demonstrations, and discussions. Setting Up the BIG-IP System Introducing the BIG-IP System Initially Setting Up the BIG-IP System Configuring the Management Interface Activating the Software License Provisioning Modules and Resources Importing a Device Certificate Specifying BIG-IP Platform Properties Configuring the Network Configuring Network Time Protocol (NTP) Servers Configuring Domain Name System (DNS) Settings Configuring High Availability Options Archiving the BIG-IP Configuration Leveraging F5 Support Resources and Tools Traffic Processing Building Blocks Identifying BIG-IP Traffic Processing Objects Configuring Virtual Servers and Pools Load Balancing Traffic Viewing Module Statistics and Logs Using the Traffic Management Shell (TMSH) Understanding the TMSH Hierarchical Structure Navigating the TMSH Hierarchy Managing BIG-IP Configuration State and Files BIG-IP System Configuration State Loading and Saving the System Configuration Shutting Down and Restarting the BIG-IP System Saving and Replicating Configuration Data (UCS and SCF) Using NATs and SNATs Address Translation on the BIG-IP System Mapping IP Addresses with NATs Solving Routing Issues with SNATs Configuring SNAT Auto Map on a Virtual Server Monitoring for and Mitigating Port Exhaustion Monitoring Application Health Introducing Monitors Types of Monitors Monitor Interval and Timeout Settings Configuring Monitors Assigning Monitors to Resources Managing Pool, Pool Member, and Node Status Using the Network Map Modifying Traffic Behavior with Profiles Introducing Profiles Understanding Profile Types and Dependencies Configuring and Assigning Profiles Introducing SSL Offload and SSL Re-Encryption Managing Object State Modifying Traffic Behavior with Persistence Understanding the Need for Persistence Introducing Source Address Affinity Persistence Managing Object State Administering the BIG-IP System Configuring Logging Legacy Remote Logging Introducing High Speed Logging (HSL) High-Speed Logging Filters HSL Configuration Objects Configuring High Speed Logging Using TCPDUMP on the BIG-IP System Leveraging the BIG-IP iHealth System Viewing BIG-IP System Statistics Defining User Roles and Administrative Partitions Leveraging vCMP Configuring High Availability Introducing Device Service Clustering (DSC) Preparing to Deploy a DSC Configuration Configuring DSC Communication Settings Establishing Device Trust Establishing a Sync-Failover Device Group Synchronizing Configuration Data Exploring Traffic Group Behavior Understanding Failover Managers and Triggers Achieving Stateful Failover with Mirroring

One Shared Owner: artists talking about creating collaborative space and sustainability with SaltSpace and Vanilla Ink Join us for a conversation exploring how artist-led initiatives are set up, why they are necessary and perhaps most importantly how they evolve and sustain themselves over time.  SaltSpace and Vanilla Ink will be sharing their experiences setting up as a Cooperative and Community Interest Company; and how they operate as an artist led space and community for creative practitioners.  SaltSpace will be hosting Dr Deborah Jackson, Head of Fine Art Critical Studies at the Glasgow School of Art, and Ellie Smith-Barratt, Chief Executive Officer at Vanilla Ink. Both Deborah and Ellie will be sharing their experiences with artist-led initiatives, thinking about the topic of sustaining creative spaces and communities in Scotland, with a specific focus on supports for early career practitioners in Glasgow and more broadly across Scotland.  This conversation will be an opportunity to think about the transitional space of moving from student to graduate and into practicing as a professional artist. We will be talking about supports for recent graduates and early career artists in the form of organisations and initiatives set up by / for recent graduates due to the lack of support system often provided by institutions. We will be thinking about the need to support collaboration and foster community during that time, and what mechanisms of support are in place for this, and how we can improve and strengthen these supports. Context: This event is co-hosted and supported by the Scottish Artist Union, artist and researcher Chris Biddlecombe, will be providing an overview of his key findings from the ‘Artist-Led Organisations in Scotland: Survey and Mapping of Activity' research report, which has been undertaken by Scottish Artist Union on behalf of Creative Scotland.  The event has been developed in conversation with Dr Marianne Greated, Academic Development Lead, School of Fine Art, Glasgow School of Art who has a longstanding interest in developing artist led collaborations and how this can be supported through the Glasgow School of Art curriculum.  About SaltSpace: SaltSpace is a creative cooperative based in Glasgow which aims to provide a supportive platform for new graduates and early year creatives as a stepping-stone into their artistic career. Currently we offer studio spaces across two premises in Glasgow city in Dornoch Street and the Axiom Building and a gallery/community space in the Axiom Building on 54 Washington Street.  About Vanilla Ink: Vanilla Ink is a Community Interest Company with creative jewellery workshops in Glasgow and Banff. They offer a diverse range of resources and programmes tailored to empower and support emerging talent, giving members access to the fully equipped jewellery studios, tools and bench space. The emphasis is on providing a supportive environment for jewellers to develop their skills and confidence. The jewellery school provides classes, workshops and courses for both beginners and professionals. One Shared Owner and the research is supported by Creative Scotland. If you have any other participation needs, please email us via learning@artistsunion.scot

Deal Price is Active! Offer Ends Soon; Hurry Up!! Are you looking to improve your current abilities or make a career move? Our unique Course might help you get there! Expand your expertise with high-quality training - study the course and get an expertly designed, great value training experience. Learn from industry professionals and quickly equip yourself with the specific knowledge and skills you need to excel in your chosen career through the online training course. This Advanced Diploma in Complete Survey Training at QLS Level 7 course is endorsed by The Quality Licence Scheme and accredited by CPDQS (with 180 CPD points) to make your skill development & career progression more accessible than ever! Why Prefer This Complete Survey Training Course? Opportunity to earn certificate a certificate endorsed by the Quality Licence Scheme & another accredited by CPDQS after completing the Complete Survey Training course Get a free student ID card! (£10 postal charge will be applicable for international delivery) Innovative and engaging content. Free assessments 24/7 tutor support. The course is broken down into several in-depth modules to provide you with the most convenient and rich learning experience possible. Upon successful completion of the course, an instant e-certificate will be exhibited in your profile that you can order as proof of your new skills and knowledge. Add these amazing new skills to your resume and boost your employability by simply enrolling on this course. With this comprehensive course, you can achieve your dreams and train for your ideal career. The course provides students with an in-depth learning experience that they can work through at their own pace to enhance their professional development. You'll get a Free Student ID card by enrolling in this course. This ID card entitles you to discounts on bus tickets, movie tickets, and library cards. This training can help you to accomplish your ambitions and prepare you for a meaningful career. So, join the course today - gear up with the essential skills to set yourself up for excellence! Experts created the Complete Survey Training course to provide a rich and in-depth training experience for all students who enrol in it. Enrol in the course right now and you'll have immediate access to all of the Complete Survey Training course materials. Then, from any internet-enabled device, access the Complete Survey Training course materials and learn when it's convenient for you. Start your learning journey straight away with this Complete Survey Training course and take a step toward a brighter future! *** Course Curriculum *** Here is the curriculum breakdown of the course: Complete Survey Training Course • Module 01: Basics of Surveying • Module 02: Levelling • Module 03: Distance Measurement • Module 04: Angles and Directions • Module 05: Error and Uncertainty • Module 06: Survey Report • Module 07: Quantity Surveying Measurement • Module 08: Cost Management • Module 09: Pricing and Operational Estimation • Module 10: Contract Management and Tendering • Module 11: Procurement and Bill Preparation • Module 12: Predicting Potential Risk and Management • Module 13: Building Procurement and Contract Administration • Module 14: Building Information Modelling • Module 15: Building Technology • Module 16: Beginning of the Survey: Foundation and In-depth Survey in Walls • Module 17: Ground Level Investigation: Floors, Roofs and Chimneys • Module 18: Inspection of Joinery and Woodwork • Module 19: Finishes and Surfaces of the Building • Module 20: Land Surveying Basics • Module 21: Land Surveying Instrumentation • Module 22: Land Surveying Methods and Techniques • Module 23: Topographic Surveying and Mapping • Module 24: Boundary Surveying • Module 25: The Role of a Residential Surveyor • Module 26: Residential Surveying Legal Procedures • Module 27: Residential Surveying Inspection • Module 28: Residential Surveying Assessment- Part I • Module 29: Residential Surveying Assessment- Part II • Module 30: Valuation of Residential Property Assessment Process You have to complete the assignment questions given at the end of the course and score a minimum of 60% to pass each exam.Our expert trainers will assess your assignment and give you feedback after you submit the assignment. After passing the Advanced Diploma in Complete Survey Training at QLS Level 7 course exam, you will be able to request a certificate at an additional cost that has been endorsed by the Quality Licence Scheme. CPD 180 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Is This Course Right for You? Anyone interested in learning more about this subject should take this course. This will help you grasp the basic concepts as well as develop a thorough understanding of the subject. All are welcome to take this Complete Survey Training course. There are no prerequisites for enrolment, and you can access the course materials from any location in the world. Requirements The Complete Survey Training program does not require any prior knowledge; everyone may participate! This course is open to anyone interested in learning from anywhere in the world. Every student must be over the age of 16 and have a passion for learning and literacy. This 100% online course can be accessed from any internet-connected device, such as a computer, tablet, or smartphone. This Complete Survey Training course allows you to study at your speed and grow a quality skillset. Career path After completing this Course, you are to start your career or begin the next phase of your career in this field. Our entire Complete Survey Training course will help you to gain a position of respect and dignity over your competitors. The certificate enhances your CV and helps you find work in the field concerned. Certificates Certificate of completion Digital certificate - £10 Advanced Diploma in Complete Survey Training at QLS Level 7 Hard copy certificate - £139 Show off Your New Skills with a Certificate of Completion After successfully completing the Advanced Diploma in Complete Survey Training at QLS Level 7, you can order an original hardcopy certificate of achievement endorsed by the Quality Licence Scheme. The certificate will be home-delivered, with a pricing scheme of - 139 GBP inside the UK 149 GBP (including postal fees) for International Delivery Certificate Accredited by CPDQS 29 GBP for Printed Hardcopy Certificate inside the UK 39 GBP for Printed Hardcopy Certificate outside the UK (International Delivery)

Course Overview Learn how to take your organisation's potential to the next level by taking this course on the fundamentals of Process Improvement: Reduce Waste. Most businesses and companies have an element of 'accepted' waste in their procedures, but you can highlight this and deliver solutions for practical wastage removal, effectively evolving routines and making them more efficient. This comprehensive Process Improvement tutorial offers step-by-step guidance for identifying unnecessary activities and eliminating them. By embracing Lean methodology in a work environment, you will be able to calculate the genuine value of tasks and their outcomes. You will be surprised as to how useful and successful this philosophy is in everyday working practice. After training, you will completely understand the best process improvement initiatives and use them to make a positive difference to your business. This best selling Process Improvement: Reduce Waste has been developed by industry professionals and has already been completed by hundreds of satisfied students. This in-depth Process Improvement: Reduce Waste is suitable for anyone who wants to build their professional skill set and improve their expert knowledge. The Process Improvement: Reduce Waste is CPD-accredited, so you can be confident you're completing a quality training course will boost your CV and enhance your career potential. The Process Improvement: Reduce Waste is made up of several information-packed modules which break down each topic into bite-sized chunks to ensure you understand and retain everything you learn. After successfully completing the Process Improvement: Reduce Waste, you will be awarded a certificate of completion as proof of your new skills. If you are looking to pursue a new career and want to build your professional skills to excel in your chosen field, the certificate of completion from the Process Improvement: Reduce Waste will help you stand out from the crowd. You can also validate your certification on our website. We know that you are busy and that time is precious, so we have designed the Process Improvement: Reduce Waste to be completed at your own pace, whether that's part-time or full-time. Get full course access upon registration and access the course materials from anywhere in the world, at any time, from any internet-enabled device.  Our experienced tutors are here to support you through the entire learning process and answer any queries you may have via email.

Register on the Absolute Beginners Retopology and UV Unwrapping in 3dsMax today and build the experience, skills and knowledge you need to enhance your professional development and work towards your dream job. Study this course through online learning and take the first steps towards a long-term career. The course consists of a number of easy to digest, in-depth modules, designed to provide you with a detailed, expert level of knowledge. Learn through a mixture of instructional video lessons and online study materials. Receive online tutor support as you study the course, to ensure you are supported every step of the way. Get a digital certificate as a proof of your course completion. The Absolute Beginners Retopology and UV Unwrapping in 3dsMax course is incredibly great value and allows you to study at your own pace. Access the course modules from any internet-enabled device, including computers, tablet, and smartphones. The course is designed to increase your employability and equip you with everything you need to be a success. Enrol on the now and start learning instantly! What You Get With The Absolute Beginners Retopology and UV Unwrapping in 3dsMax course Receive a e-certificate upon successful completion of the course Get taught by experienced, professional instructors Study at a time and pace that suits your learning style Get instant feedback on assessments 24/7 help and advice via email or live chat Get full tutor support on weekdays (Monday to Friday) Course Design The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace. You are taught through a combination of Video lessons Online study materials Certification After the successful completion of the final assessment, you will receive a CPD-accredited certificate of achievement. The PDF certificate is for £9.99, and it will be sent to you immediately after through e-mail. You can get the hard copy for £15.99, which will reach your doorsteps by post. Who Is This Course For: The course is ideal for those who already work in this sector or are an aspiring professional. This course is designed to enhance your expertise and boost your CV. Learn key skills and gain a professional qualification to prove your newly-acquired knowledge. Requirements: The online training is open to all students and has no formal entry requirements. To study the Absolute Beginners Retopology and UV Unwrapping in 3dsMax 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. Course Content Absolute Beginners Retopology And UV Unwrapping In 3dsMax Module 01: Introduction 00:11:00 Module 02: Preparing the Model In Zbrush and Exporting Meshes For Retopology 00:25:00 Module 03: Getting Familiar With 3dsmax and Starting Retopology 00:24:00 Module 04: Retopologizing the Horns 00:24:00 Module 05: Retopology of the Head and Symmetry 00:22:00 Module 06: Retopo the Shoulders Pt1 00:21:00 Module 07: Retopo the Shoulders Pt2 00:21:00 Module 08: Retopologizing the Cape 00:23:00 Module 09: Retopologizing the Arm 00:22:00 Module 10: Retopologizing the Small Cloth and Traps Armor 00:21:00 Module 11: Retopo of the Chest Armor 00:22:00 Module 12: Retopologizing the Legs 00:23:00 Module 13: Retopo the Knee Armor and the Sword 00:27:00 Module 14: Starting the Uv Unwrap 00:26:00 Module 15: Uv Mapping the Shoulders and Armor 00:23:00 Module 16: Unwrapping the Arms and Some Zbrush Unwrap 00:21:00 Module 17: Finishing the Unwrap of the Character 00:30:00 Module 18: Retopology of A Realistic Head Pt1 00:24:00 Module 19: Retopology of the Head Pt2 00:23:00 Module 20: Finishing the Head Retopology 00:26:00 Module 21: Making the Head Uvs 00:22:00 Module 22: Using Zbursh to Better Unwrap the Head 00:08:00 Module 23: Hand Retopology In 3dsmax Pt1 00:23:00 Module 24: Finish the Retopo of the Hand 00:21:00 Module 25: Uv Unwrapping of the Hand 00:15:00 Module 26: Goodbye 00:04:00 Frequently Asked Questions Are there any prerequisites for taking the course? There are no specific prerequisites for this course, nor are there any formal entry requirements. All you need is an internet connection, a good understanding of English and a passion for learning for this course. Can I access the course at any time, or is there a set schedule? You have the flexibility to access the course at any time that suits your schedule. Our courses are self-paced, allowing you to study at your own pace and convenience. How long will I have access to the course? For this course, you will have access to the course materials for 1 year only. This means you can review the content as often as you like within the year, even after you've completed the course. However, if you buy Lifetime Access for the course, you will be able to access the course for a lifetime. Is there a certificate of completion provided after completing the course? Yes, upon successfully completing the course, you will receive a certificate of completion. This certificate can be a valuable addition to your professional portfolio and can be shared on your various social networks. Can I switch courses or get a refund if I'm not satisfied with the course? We want you to have a positive learning experience. If you're not satisfied with the course, you can request a course transfer or refund within 14 days of the initial purchase. How do I track my progress in the course? Our platform provides tracking tools and progress indicators for each course. You can monitor your progress, completed lessons, and assessments through your learner dashboard for the course. What if I have technical issues or difficulties with the course? If you encounter technical issues or content-related difficulties with the course, our support team is available to assist you. You can reach out to them for prompt resolution.

This two-day programme gives the key insights and understanding of contracting principles and the impact they have on business and operations. The course is designed for individuals involved in or supporting contracting who want to improve their commercial management skills; individuals in functions such as project management, business development, finance, operations who need practical training in commercial management; general audiences wanting to gain a basic understanding of commercial management. This is an assessed programme, leading to the International Association for Contracts & Commercial Management (IACCM)'s coveted Contract and Commercial Management Associate (CCMA) qualification. The programme addresses 31 different subject areas, across the five stages of the contracting process. By the end of the course the participants will be able, among other things, to: Develop robust contract plans, including scope of work and award strategies Conduct effective contracting activities, including ITT, RFP, negotiated outcomes Negotiate effectively with key stakeholders, making use of the key skills of persuading and influencing and to work with stakeholders to improve outcomes Set up and maintain contract management systems Take a proactive approach to managing contracts Make effective use of lessons learned to promote improvements from less than optimal outcomes, using appropriate templates Develop and monitor appropriate and robust Key Performance Indicators to manage the contractor and facilitate improved performance Understand the approvals process and how to develop and present robust propositions Make appropriate use of best practice contract management tools, techniques and templates DAY ONE 1 Introductions Aims Objectives Plan for the day 2 Commercial context Explaining the contracting context Define the key objective The importance of contact management Impact upon the business 3 Stakeholders How to undertake stakeholder mapping and analysis Shared vision concept, How to engage with HSE, Finance, Operations 4 Roles and responsibilities Exploring the key roles and responsibilities of contract administrators, HSE, Finance, Divisional managers, etc 5 Initiating the contract cycle Overview of the contracting cycle Requirement to tender Methods Rationale and exceptions 6 Specifications Developing robust scope of works Use of performance specifications Output based SOW 7 Strategy and award criteria Developing a robust contract strategy Award submissions/criteria 8 Managing the tender process Review the pre-qualification process Vendor registration rules and processes Creation of bidder lists Evaluation, short listing, and how to use of the 10Cs© model template and app 9 Types of contract Classify the different types of contracts Call-offs Framework agreement Price agreements Supply agreements 10 The contract I: price Understanding contract terms Methods of compensation Lump sum, unit price, cost plus, time and materials, alternative methods Cost plus a fee, target cost, gain share contracts Advanced payments Price escalation clauses DAY TWO 11 Risk How to manage risks Risk classification Mitigation of contractual risks 12 Contractor relationship management session Effectively managing relationships with contractors, Types of relationships Driving forces? Link between type of contract and style of relationship 13 Disputes Dealing with disputes Conflict resolution Negotiation Mediation Arbitration 14 Contract management Measuring and improving contract performance Using KPIs and SLAs Benchmarking Cost controls 15 The contract II: terms and conditions Contract terms and conditions Legal aspects Drafting special terms 16 Managing claims and variations How to manage contract and works variations orders Identifying the causes of variations Contractor claims process 17 Completion Contract close-out process Acceptance/completion Capture the learning/HSE Final payments, evaluation of performance 18 Close Review Final assessment

Many organisations find that project teams struggle to create and maintain effective plans. Estimates are often overly optimistic and risks go unmanaged until the inevitable happens. Resource managers also find it hard to forecast the likely loading on their departments and requests for support are not provided in a consistent format. This programme has been developed to address these needs in a very practical, hands-on format. Case study work can be based on simulations or on the organisation's current projects for maximum benefit to participants. The aim of this training is to develop and enhance participants' planning and risk management skills in order to maximise the success of project work undertaken by the organisation. The principal training objectives for this programme are to: Provide a structured, integrated approach to planning and risk management Demonstrate practical tools and techniques for each stage of planning Show how to organise and involve relevant people in the planning process Explain how to use the plan for forecasting and pro-active project control Identify ways to improve planning, both individually and corporately The course will emphasise the importance of participative planning techniques that improve the quality of plans whilst reducing overall time and cost of planning. The course will encourage discussion of internal procedures and practices and may be customised to include them if required. DAY ONE 1 Introduction (Course sponsor) Why this programme has been developed Review of participants' needs and objectives 2 Projects and planning Why plan? The benefits of good planning / penalties of poor planning Planning in the project lifecycle; the need for a 'living' plan The interaction between target setting and the planning process Team exercise: planning the project 3 Planning the plan Defining the application and structure of the plan Impact of planning decisions during the project lifecycle Using available time to create an effective plan 4 Defining deliverables Assessing the context; reviewing the goals and stakeholders Developing the scope and defining deliverables; scope mapping Understanding customer priorities; delivering value for money Case study: defining the project deliverables 5 Creating the work breakdown Building the work breakdown structure Detailing the tasks and sub-tasks; structured brainstorming Defining task ownership; the task responsibility matrix 6 Creating and using a logical network Developing the logical network; task boarding Determining the critical path and calculating float Accelerating the plan; concurrent programming and risk Individual and group exercises DAY TWO 7 Developing resource schedules Deriving the Gantt chart from the network Developing the detailed resource schedules Calculating the expenditure profile ('S' curve) 8 Estimating task durations and costs Understanding estimates: effort, availability and duration Estimating tools and techniques Application of estimating techniques during the project lifecycle 9 Case study Developing the project plan Refining the project plan Team presentations and discussion 10 Managing risks and refining the plan Awareness of contractual issues associated with risk Identifying and evaluating risks; deciding ownership Managing risks: determining levels of provision and contingency Controlling risks: maintaining an up-to date risk register 11 Planning for pro-active control The earned value analysis (EVA) concept and its predictive value Deriving the measures needed for cost and delivery performance Practical issues associated with implementing EVA 12 Using and maintaining the plan Tracking progress and updating the plan Publishing and controlling the plan 13 Course review and transfer planning (Course sponsor present) Identify ways of implementing the techniques learnt Sponsor-led review and discussion of proposals Conclusion

Are you looking to improve your current abilities or make a career move? Our unique Complete Microsoft Excel Course might help you get there! Expand your expertise with high-quality training - study the Complete Microsoft Excel and get an expertly designed, great value training experience. Learn from industry professionals and quickly equip yourself with the specific knowledge and skills you need to excel in your chosen career through the online training course. This Complete Microsoft Excel online training course is accredited by CPD with 15 CPD points for professional development. Students can expect to complete this training course in around 11 hours. You'll also get dedicated expert assistance from us to answer any queries you may have while studying our course. The course is broken down into several in-depth modules to provide you with the most convenient and rich learning experience possible. Upon successful completion of the Complete Microsoft Excel course, you will receive an instant e-certificate as proof of the comprehensive skill development and competency. Add these amazing new skills to your resume and boost your employability by simply enroling on this course. With this comprehensive course, you can achieve your dreams and train for your ideal career. The Complete Microsoft Excel course provides students with an in-depth learning experience that they can work through at their own pace to enhance their professional development. You'll get a Free Student ID card by enroling in this course. This ID card entitles you to discounts on bus tickets, movie tickets, and library cards. Enroling on the Complete Microsoft Excel course will ensure that you land your dream career faster than you thought possible. Stand out from the crowd and train for the job you want with the program. Why Prefer this Complete Microsoft Excel Course? Opportunity to earn a certificate accredited by CPD after completing this course Student ID card with amazing discounts - completely for FREE! (£10 postal charges will be applicable for international delivery) Standard-aligned lesson planning Innovative and engaging content and activities Assessments that measure higher-level thinking and skills Complete the program in your own time, at your own pace Each of our students gets full 24/7 tutor support Experts created the Complete Microsoft Excel course to provide a rich and in-depth training experience for all students who enrol in it. Enrol in the course right now and you'll have immediate access to all of the course materials. Then, from any internet-enabled device, access the course materials and learn when it's convenient for you. Start your learning journey straight away with this course and take a step toward a brighter future! *** Course Curriculum *** Here are the topics you will cover on the Course: >> Complete Microsoft Excel << Module 01: 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 Module 02: 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 Module 03: Performing Calculations Create Worksheet Formulas Insert Functions Reuse Formulas and Functions Module 04: Modifying a Worksheet Insert, Delete, and Adjust Cells, Columns, and Rows Search for and Replace Data Use Proofing and Research Tools Module 05: Formatting a Worksheet Apply Text Formats Apply Number Format Align Cell Contents Apply Styles and Themes Apply Basic Conditional Formatting Create and Use Templates Module 06: Printing Workbooks Preview and Print a Workbook Set Up the Page Layout Configure Headers and Footers Module 07: Managing Workbooks Manage Worksheets Manage Workbook and Worksheet Views Manage Workbook Properties Module 08: Working with Functions Work with Ranges Use Specialized Functions Work with Logical Functions Work with Date & Time Functions Work with Text Functions Module 09: Working with Lists Sort Data Filter Data Query Data with Database Functions Outline and Subtotal Data Module 10: Analyzing Data Apply Intermediate Conditional Formatting Apply Advanced Conditional Formatting Module 11: Visualizing Data with Charts Create Charts Modify and Format Charts Use Advanced Chart Features Module 12: Using PivotTables and PivotCharts Create a PivotTable Analyze PivotTable Data Present Data with PivotCharts Filter Data by Using Timelines and Slicers Module 13: Working with Multiple Worksheets and Workbooks Use Links and External References Use 3-D References Consolidate Data Module 14: Using Lookup Functions and Formula Auditing Use Lookup Functions Trace Cells Watch and Evaluate Formulas Module 15: Sharing and Protecting Workbooks Collaborate on a Workbook Protect Worksheets and Workbooks Module 16: Automating Workbook Functionality Apply Data Validation Search for Invalid Data and Formulas with Errors Work with Macros Module 17: Creating Sparklines and Mapping Data Create Sparklines MapData Module 18: Forecasting Data Determine Potential Outcomes Using Data Tables Determine Potential Outcomes Using Scenarios Use the Goal Seek Feature Forecasting Data Trends Module 19: Excel Templates Excel Templates Assessment Process Once you have completed all the modules in the Complete Microsoft Excel course, you can assess your skills and knowledge with an optional assignment. Our expert trainers will assess your assignment and give you feedback afterwards. CPD 15 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone interested in learning more about the topic is advised to take this course. This course is open to everybody. Requirements You will not need any prior background or expertise to enrol in this course. Career path After completing this course, you are to start your career or begin the next phase of your career. Certificates CPD Accredited Certificate Digital certificate - £10 CPD Accredited Certificate Hard copy certificate - £29 If you are an international student, then you have to pay an additional 10 GBP as an international delivery charge.

Take your JavaScript and Vue skills to the next level by learning state management, routing, authentication and Firebase