13434 Manager courses in Huntingdon delivered Online

Course Overview Learn the Latest Skills | Acknowledged by CPD | MCQ Based Exam & Tutor Support | Interactive Video Training  Building surveying is one of the broadest areas of surveying practice and includes a variety of occupations. You will be required to provide a range of services linked to building upkeep and maintenance, including building design, renovation, or alteration, as well as other property and construction-related tasks. Therefore, in order to exhibit your proficiency in building surveying practice, it's imperative that you comprehend essential knowledge of construction technology, contracts, and building pathology. The fundamentals of contract administration, construction and environmental services, design and specification, inspection, and legal and regulatory compliance are topics covered in our course. Training in these key areas will furnish you with important knowledge and techniques for this multi-disciplined industry and will give you a practical skill set with which to implement key building surveying techniques. What Will You Learn? Introduction to building survey Learn about building information modelling and technology Understand work breakdown structure Reporting various aspects of the building sites All the legal aspects of building survey What classes are included in this package? Earn a digital Certificate upon successful completion acknowledged by UK and internationally acknowledged lesson There are no set schedules, so you can work at your own pace. Our email and live chat specialists are available to assist you 24 hours a day, 7 days a week. On weekdays, you'll have access to a full-time tutor. Learn in a user-friendly, cutting-edge online learning environment. High-quality e-learning study materials Lifetime Access Benefit from instant feedback through mock exams and multiple-choice assessments Who Should Take This Course? This Construction Surveyor course has been designed to train those individuals who work as Building Surveyors or are preparing to do so. It may also benefit comparable roles in the construction industry. Career Path Training offered by the Construction Surveyor could potentially benefit a range of roles but would particularly enhance careers in: Surveyor Contractor Civil Engineer Project Manager 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 Mock exams Multiple-choice assessments Assignment Certificate of Achievements from Janets Upon successful completion of the course, you will be able to obtain your course completion e-certificate free of cost. Print copy by post is also available at an additional cost of £9.99 and PDF Certificate at £4.99. Method of Assessment On successful completion of the Construction Surveyor, you will be required to sit an online multiple-choice assessment. You will need to score 60% or above to pass the course. 

Highlights of the Course Course Type: Online Learning Duration: 1 to 2 hours Tutor Support: Tutor support is included Customer Support: 24/7 customer support is available Quality Training: The course is designed by an industry expert Recognised Credential: Recognised and Valuable Certification Completion Certificate: Free Course Completion Certificate Included Instalment: 3 Installment Plan on checkout What you will learn from this course? Gain comprehensive knowledge about supply chain management Understand the core competencies and principles of supply chain management Explore the various areas of supply chain management Know how to apply the skills you acquired from this course in a real-life context Become a confident and expert supply chain manager Supply Chain Operation Course Master the skills you need to propel your career forward in supply chain management. This course will equip you with the essential knowledge and skillset that will make you confident and take your career to the next level. This comprehensive supply chain course is designed to help you surpass your professional goals. The skills and knowledge that you will gain through studying this supply chain course will help you get one step closer to your professional aspirations and develop your skills for a rewarding career. This comprehensive course will teach you the theory of effective supply chain management practice and equip you with the essential skills, confidence and competence to assist you in the supply chain management industry. You'll gain a solid understanding of the core competencies required to drive a successful career in supply chain management. This course is designed by industry experts, so you'll gain knowledge and skills based on the latest expertise and best practices. This extensive course is designed for or for people who are aspiring to specialise in supply chain management. Enrol in this supply chain course today and take the next step towards your personal and professional goals. Earn industry-recognised credentials to demonstrate your new skills and add extra value to your CV that will help you outshine other candidates. Who is this Course for? This comprehensive supply chain course is ideal for anyone wishing to boost their career profile or advance their career in this field by gaining a thorough understanding of the subject. Anyone willing to gain extensive knowledge on this supply chain management can also take this course. Whether you are a complete beginner or an aspiring professional, this course will provide you with the necessary skills and professional competence, and open your doors to a wide number of professions within your chosen sector. Entry Requirements This supply chain course has no academic prerequisites and is open to students from all academic disciplines. You will, however, need a laptop, desktop, tablet, or smartphone, as well as a reliable internet connection. Assessment This supply chain course assesses learners through multiple-choice questions (MCQs). Upon successful completion of the modules, learners must answer MCQs to complete the assessment procedure. Through the MCQs, it is measured how much a learner could grasp from each section. In the assessment pass mark is 60%. Recognised Accreditation This course is accredited by continuing professional development (CPD). CPD UK is globally recognised by employers, professional organisations, and academic institutions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. What is CPD? Employers, professional organisations, and academic institutions all recognise CPD, therefore a credential from CPD Certification Service adds value to your professional goals and achievements. Benefits of CPD Improve your employment prospects Boost your job satisfaction Promotes career advancement Enhances your CV Provides you with a competitive edge in the job market Demonstrate your dedication Showcases your professional capabilities What is IPHM? The IPHM is an Accreditation Board that provides Training Providers with international and global accreditation. The Practitioners of Holistic Medicine (IPHM) accreditation is a guarantee of quality and skill. Benefits of IPHM It will help you establish a positive reputation in your chosen field You can join a network and community of successful therapists that are dedicated to providing excellent care to their client You can flaunt this accreditation in your CV It is a worldwide recognised accreditation What is Quality Licence Scheme? This course is endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. Benefits of Quality License Scheme Certificate is valuable Provides a competitive edge in your career It will make your CV stand out Course Curriculum Introduction Introduction 00:01:00 Supply Chain Fundamentals The Broad Meaning of Supply Chain 00:01:00 History of Supply Chain 00:03:00 Real Supply Chain Definition 00:03:00 Logistics Under The Microscope 00:02:00 Supply Chain Flows 00:05:00 Supply Chain Strategies 00:08:00 Supply Chain Objectives 00:05:00 Supply Chain Risks 00:09:00 Certificate of Achievement Certificate of Achievement 00:00:00 Get Your Insurance Now Get Your Insurance Now 00:00:00 Feedback Feedback 00:00:00

Managing people is as much about timing and tone as it is about targets. The People Management: 8 in 1 Premium Courses Bundle offers a punchy lineup of skills that managers, team leads, and rising professionals need to keep their workplace not only efficient—but mostly civil too. Whether you're aiming to calm a heated phone call or schedule three meetings at once (without losing your mind), this bundle covers essentials like communication skills, telephone etiquette, negotiation, and lean methodology. A bit of equality and diversity knowledge doesn’t go amiss either—it helps keep things human. Learning Outcomes Build effective communication for teams and professional settings. Understand leadership techniques for better team coordination. Apply time management methods to improve productivity. Use problem-solving approaches to handle workplace challenges. Learn telephone and digital communication etiquette. Recognise fairness and equality in team environments. Who is this Course For Team leaders managing daily operations and staff issues. Office managers wanting smoother people-handling skills. HR assistants supporting interpersonal workplace functions. Call centre staff aiming for confident phone communication. Business professionals improving task and time management. New managers building leadership experience online. Customer service supervisors learning negotiation basics. Coordinators managing multiple departments or teams. Career Path Team Leader – £25,000 to £35,000 per year HR Administrator – £23,000 to £30,000 per year Customer Service Manager – £28,000 to £40,000 per year Operations Supervisor – £30,000 to £42,000 per year Office Manager – £27,000 to £38,000 per year Training Coordinator – £25,000 to £35,000 per year

This course will transform you from someone who has never thought of coding a website to someone who can create a professional website in an hour using ChatGPT. If you are already a web designer, this will exponentially enhance your productivity. What would take days of work by a professional can now be done by any individual in just a few hours.

Overview of Office Administration With over 4 million people working in administrative roles, office administration is a growing field full of opportunities in the UK. This office administration course equips you with the essential skills like time management, business writing, communication, and organisation needed to thrive as an administrative professional. You'll gain practical insights into managing office tasks, interacting with staff and clients, and problem-solving issues that arise. With dedicated modules on skills like writing, communication, and stress management, this comprehensive course readies you for diverse administrative and secretarial jobs across sectors.  Invest in your potential. Become the backbone of success. Enrol today and unlock the thriving world of Office Administration in the UK! Get a Quick Look at The Course Content: This Office Administration Course will help you to learn: Employ advanced communication skills to thrive in any business environment. Implement organisational strategies to ensure efficiency and productivity. Master negotiation techniques to secure advantageous outcomes. Manage stress effectively to maintain a healthy work-life balance. Develop leadership qualities to excel in your chosen career path. This course covers the topic you must know to stand against the tough competition. The future is truly yours to seize with this Office Administration. Enrol today and complete the course to achieve a certificate that can change your career forever. Details Perks of Learning with IOMH One-To-One Support from a Dedicated Tutor Throughout Your Course. Study Online - Whenever and Wherever You Want. Instant Digital/ PDF Certificate. 100% Money Back Guarantee. 12 Months Access. Process of Evaluation After studying the course, an MCQ exam or assignment will test your skills and knowledge. You have to get a score of 60% to pass the test and get your certificate. Certificate of Achievement Certificate of Completion - Digital / PDF Certificate After completing the Office Administration course, you can order your CPD Accredited Digital / PDF Certificate for £5.99.  Certificate of Completion - Hard copy Certificate You can get the CPD Accredited Hard Copy Certificate for £12.99. Shipping Charges: Inside the UK: £3.99 International: £10.99 Who Is This Course for? Individuals seeking a rewarding career in Office Administration. Existing professionals looking to refine their skills and climb the ladder. Business owners are eager to empower their teams with essential administrative expertise. Anyone seeking to enhance their organisational and communication skills for personal growth. Requirements You don't need any educational qualification or experience to enrol in the Office Administration course. Do note: you must be at least 16 years old to enrol. Any internet-connected device, such as a computer, tablet, or smartphone, can access this online course.   Career Path This UK-focused Office Administration course paves the way for a diverse range of rewarding careers, including: Executive Assistant - £32,000 to £48,000/year. Office Manager - £18,000 to £38,000/year. Sales Administrator - £17,000 to £28,000/year. Receptionist - £16,000 to £24,000/year. Customer Service Advisor - £18,000 to £26,000/year. Course Curriculum Office Administration Module 1: Introduction to Office Administration 00:17:00 Module 2: Skills of an Effective Administrator 00:18:00 Module 3: Business Writing Skills 00:39:00 Module 4: Communication Skills 00:27:00 Module 5: Managing Meetings and Giving Feedback 01:29:00 Module 6: Organisational Skills 01:18:00 Module 7: Telephone Etiquette 01:09:00 Module 8: Negotiation Techniques 00:18:00 Module 9: Conflict Management 00:16:00 Module 10: Stress Management 00:18:00 Module 11: Time Management 00:39:00 Assignment Assignment - Office Administration 00:00:00

Course Overview To create interactive and effective web applications, JavaScript is one of the first choices for developers. Learn how you can use JavaScript and node.js to make your website more interactive and entertaining from this Learn Node.JS Framework in 2021 course and boost and update your programming skill. The Learn Node.JS Framework in 2021 course will teach you the steps of creating websites using JavaScript from scratch. You will familiarize yourself with the concepts of JavaScript and node.js, how node.js works and its beauty. You will learn about node package manager, asynchronous JavaScript and promises, event emitter, file system, creating a path and many other functions that node.js offers. This course will also help you to create a strong authentication and verification system so that you can secure your website from common threats and get notifications if there is any problem. This course is helpful to learn web development and will assist you to increase your skill in no time. Learning Outcomes Familiarize with node.js basics Be able to create API development Understand the basics of asynchronous JavaScript Learn how to create a login system and password hashing Be able to secure your device using user verification, data validation and email verification using node.js Learn in detail about authentication and authorization system Who is this course for? This course is ideal for anyone who wants to learn web designing or web development and use JavaScript to design their websites. This course will help you to understand the functions of JavaScript and node.js and how to design websites from scratch. Entry Requirement This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Certification After you have successfully completed the course, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hardcopy at the cost of £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/materials from the industry-leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognized accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. Career Path Learn Node.JS Framework in 2021 is a useful qualification to possess and would be beneficial for any related profession or industry such as: JavaScript Developers Web Developers App Developers Software Engineers Programmers Unit 01: Introduction Module 01: Introduction 00:02:00 Unit 02: Node.js Basics Module 01: Introduction 00:01:00 Module 02: What's & Why Node.js? 00:07:00 Module 03: Installation 00:01:00 Module 04: First Node.js app 00:12:00 Module 05: Mechanism of Node.js 00:07:00 Module 06: Event Loop 00:09:00 Module 07: Loop tick 00:04:00 Module 08: Modules 00:07:00 Unit 03: Asynchronous JavaScript Module 01: Introduction 00:01:00 Module 02: JSON format 00:03:00 Module 03: Callback pattern 1 00:05:00 Module 04: Callback pattern 2 00:03:00 Module 05: Callback hell 00:01:00 Module 06: Promises pattern 1 00:02:00 Module 07: Promises pattern 2 00:02:00 Module 08: Master promises 1 00:03:00 Module 09: Master promises 2 00:05:00 Module 10: async/await pattern 1 00:02:00 Module 11: async/await pattern 2 00:02:00 Module 12: Promisify a function 00:03:00 Unit 04: Core Modules Module 01: Introduction 00:01:00 Module 02: Event emitter I 00:03:00 Module 03: Event emitter II 00:02:00 Module 04: Event emitter III 00:03:00 Module 05: File system I 00:02:00 Module 06: File system II 00:01:00 Module 07: File system III 00:04:00 Module 08: Streams I 00:03:00 Module 09: Streams II 00:02:00 Module 10: Path I 00:02:00 Module 11: Path II 00:02:00 Module 12: Path III 00:02:00 Unit 05: npm Module 01: Introduction 00:01:00 Module 02: package.json file 00:01:00 Module 03: Commands I 00:02:00 Module 04: Commands II 00:03:00 Module 05: Commands III 00:04:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Do you want to improve your customer service skills & want to make your customers happy? Do you want to exceed customer expectations and want to create clients who spread words about your business? If yes, then enrol now and benefit from this course. Description: This Customer Service course teaches the basics of customer service and translates that knowledge into practical application. Students will come away from this customer service course knowing how a positive attitude, going a step beyond basic customer service, and dealing effectively with complaints will enhance their work experience. Students will learn the difference between internal and external customers and will find out how the development and implementation of a comprehensive customer service policy promote consistency in how customers are treated and keep customers happy. Who is the course for? Individuals who have any interaction with customers in any business. People who want to take their customer service skills to the next level. Students. Job seekers. Entry Requirement: This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Assessment:  At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After you have successfully passed the test, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hardcopy at a cost of £39 or in PDF format at a 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/materials from the industry leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognised accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. Career Path: Level 2 Certificate in Customer Service is a useful qualification to possess, and would be beneficial for the following professionals: Administrative Receptionist. Assistant Office Manager. Call Center Customer Service Representative. Call Center Representative. Call Center Supervisor. Customer Care Representative. Customer Service Administrative Assistant. Customer Service Agent. Customer Service Analyst. Customer Service Assistant. Customer Service Associate. Customer Service Introduction To Customer Service 00:15:00 The Power of Positive Thinking in Customer Service 00:30:00 Types of Difficult Customers and How to Help them 01:00:00 How to Deal with Difficult Customers 00:30:00 Conclusion 00:15:00 Customer Service Basics Customer Service and Retention Templates 01:00:00 Customer Service & Retention Checklist 01:00:00 Customer Service Checklist 01:00:00 Customer Service Skills First Lesson 00:30:00 Second Lesson 01:00:00 Third Lesson 00:30:00 Fourth Lesson 00:30:00 Fifth Lesson 01:00:00 Microsoft Word Module One - Getting Started 00:30:00 Module Two - Opening 01:00:00 Module Three - Working with the Interface 01:00:00 Module Four - Your First Document 01:00:00 Module Five - Basic Editing Tasks 01:00:00 Module Six - Basic Formatting Tasks 01:00:00 Module Seven - Formatting Paragraphs 01:00:00 Module Eight - Advanced Formatting Tasks 01:00:00 Module Nine - Working with Styles 01:00:00 Module Ten - Formatting the Page 01:00:00 Module Eleven - Sharing Your Document 01:00:00 Module Twelve - Wrapping Up 00:30:00 Microsoft Excel Module One - Getting Started 00:30:00 Module Two - Opening Excel 01:00:00 Module Three - Working with the Interface 01:00:00 Module Four - Your First Worksheet 01:00:00 Module Five - Viewing Excel Data 01:00:00 Module Six - Building Formulas 01:00:00 Module Seven - Using Excel Functions 01:00:00 Module Eight - Using Quick Analysis 01:00:00 Module Nine - Formatting Your Data 01:00:00 Module Ten - Using Styles, Themes, and Effects 01:00:00 Module Eleven - Printing and Sharing Your Workbook 01:00:00 Module Twelve - Wrapping Up 01:00:00 Mock Exam Mock Exam- Certificate in Customer Service 00:30:00 Final Exam Final Exam- Certificate in Customer Service 00:30:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

This award winning Complete Beauty Care Training is a comprehensive best selling course, which is designed for those wishing to operate as a beauty therapist, salon or spa manager or salon owner. Whether you're learning purely for pleasure or wish to start or expand your own practice, our flexible, affordable home-study course will help you achieve the appropriate skills and qualifications. So discover your passion for beauty therapy by joining us today! This Complete Beauty Care Training covers a range of skills which you will need to become a successful beauty therapist. From nails to massage and everything in between, you will gain the skills and experience you need to pursue your new career as a beauty therapist. As well as the ability to provide clients with beauty advice, recommend beauty treatments and services, and sell retail skin-care and cosmetic products. Our course is designed to ensure that you are 'industry-ready' when you graduate. Why choose this course Earn an e-certificate upon successful completion. Accessible, informative modules taught by expert instructors Study in your own time, at your own pace, through your computer tablet or mobile device Benefit from instant feedback through mock exams and multiple-choice assessments Get 24/7 help or advice from our email and live chat teams Full Tutor Support on Weekdays 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 Mock exams Multiple-choice assessment 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? Complete Beauty Care Training is suitable for anyone who want to gain extensive knowledge, potential experience and professional skills in the related field. This course is designed by industry experts so you don't have to worry about the quality. Most importantly, this course does not require any experience or qualification to get enrolled. You will learn everything that is required from this course directly. This is a great opportunity for all student from any academic backgrounds to learn more on this subject.

Course Description Understand the strategies and techniques of successfully managing a team with the Team Management: Part 2 course. In this valuable course, you will pick up the key skills for talent management. The course will show you effective ways of stress management and how to take care of mental health. From this Team Management: Part 2 course, you will be able to grasp succession planning techniques. Not just that, the course will also provide you with practical skills for negotiation. Enrol in the course and master the skills of team management. Learning outcome  Learn the fundamental skills for talent management Understand the strategies of stress management Gain in-depth knowledge about succession planning Master the skills of negotiation How Much Do Team Leaders Earn? Senior - £44,000(Appx.) Mid Career - £26,000(Appx.) Starting - £19,000(Appx.) Requirements Our Team Management: Part 2 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. Team Management: Part 2 Module 01: Talent Management 00:33:00 Module 02: Stress Management and Mental Health 00:21:00 Module 03: Succession Planning 00:29:00 Module 04: Negotiation Techniques 00:17:00 Assignment Assignment - Team Management: Part 2 00:00:00

If you are looking forward to advance your skills with Microsoft Excel 2016 and want to learn more advanced skills or want to learn the topics covered in this course in the 2016 interface, this Excel 2016 Advanced will be the perfect choice for you! Through the course you will gain the skills necessary to use pivot tables, audit and analyze worksheet data, utilize data tools, collaborate with others, and create and manage macros. Additionally, you will experiment with auditing formulas and error checking, use the What-If Analysis tools, learn the options for worksheet and workbook protection, review advanced use of PivotTables and PowerPivot add-in, work with Macros, use form controls, and ensure data integrity in your worksheets and workbooks. You will also learn about Excel's many collaboration features, as well as how to import and export data to and from your workbooks. What Will I Learn? Use Advanced IF Statements Use Advanced Lookup Functions Use Complex Logical and Text Functions Auditing Formulas Working with What-If Analysis Tools Protecting Worksheet and Workbook Use Advanced PivotTables and PowerPivot Tools Automate with Macros Work with Form Controls Ensure Data Integrity Collaborate in Excel Import and Export Data to a Text File Requirements Excel Introduction and Intermediate courses or equivalent experience. Who is the target audience? Students who want to expand their Excel knowledge. Introduction Introduction FREE 00:01:00 Using Advanced IF Statements Summarize Data with SUMIF FREE 00:04:00 Summarize Data with AVERAGIF 00:03:00 Summarize Data with COUNTIF 00:02:00 Using Advanced Lookup Functions Using VLOOKUP with TRUE to find an Approximate Match 00:04:00 Using HLOOKUP TRUE to find an Approximate Match 00:01:00 Using the Index Function 00:03:00 Using the Match Function 00:02:00 Creating a Combined Index and Match Formula 00:04:00 Comparing Two Lists with VLOOKUP 00:02:00 Comparing Two Lists with VLOOKUP and ISNA 00:04:00 Using Complex Logical and Text Functions Creating a Nested IF Function 00:03:00 Using the IFERROR Function 00:02:00 Using the LEN Function 00:02:00 Using the TRIM Function 00:01:00 Using the Substitute Function 00:02:00 Formula Auditing Showing Formulas 00:01:00 Tracing Cell Precedents and Dependents 00:03:00 Adding a watch Window 00:02:00 Error Checking 00:02:00 What-If Analysis Tools Using the Scenario Manager 00:03:00 Using Goal Seek 00:02:00 Analyzing with Data Tables 00:02:00 Worksheet and Workbook Protection Protection Overview 00:02:00 Excel File Password Encryption 00:03:00 Allowing Specific Worksheet Changes 00:01:00 Adding Protection to only Certain Cells in a Worksheet 00:03:00 Additional Protection Features 00:02:00 Advanced Use of PivotTables and PowerPivot Using the Pivot Tables Charts Wizard 00:02:00 Adding a Calculated Field 00:02:00 Adding a Caculated Item 00:02:00 Apply Conditional Formatting to a Pivot Table 00:03:00 Using Filters in the Pivot Table Fields Pane 00:02:00 Creating Filter Pages for a Pivot Table 00:01:00 Enabling a Power Pivot Add In 00:04:00 Automating with Macros What are Macros 00:03:00 Displaying the Developer Tab and Enabling Macros in Excel 00:03:00 Creating a Basic Formatting Macro 00:03:00 Running a Macro 00:02:00 Assigning a Macro to a Button 00:02:00 Creating a More Complex Macro 00:02:00 Viewing and Editing the VBA Code for an Existing Macro 00:03:00 Adding a Macro to the Quick Access Toolbar 00:02:00 Working with Form Controls What are Form Controls 00:02:00 Adding Spin Buttons and Check Boxes to a Spreadsheet 00:02:00 Adding a Combo Box to a Spreadsheet 00:02:00 Ensuring Data Integrity What is Data Validation 00:01:00 Restricting Data Entries to Whole Numbers 00:02:00 Data Validation Restricting Data Entry to a List 00:01:00 Data Validation Restricting Data Entry to a Date 00:01:00 Data Validation Restricting Data Entry to Different Text Lengths 00:01:00 Composing Input Messages 00:02:00 Composing Error Alters 00:02:00 Finding Invalid Data 00:02:00 Editing and Deleting Data Validation Rules 00:01:00 Collaborating in Excel Working with Comments 00:03:00 Printing Comments and Errors 00:02:00 Sharing a Workbook 00:03:00 Tracking Changes in a Workbook 00:03:00 Working with Versions 00:02:00 Sharing Files via Email 00:02:00 Importing and Exporting Data to a Text File Importing a Text File 00:03:00 Exporting a Text File 00:01:00 Conclusion Course Recap 00:01:00 Course Certification