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 to Course Illustrator Course Outline 00:01:00 The Power of Adobe Illustrator 00:01:00 Achieving the best learning experience 00:02:00 Illustrator Fundamentals & Basics Illustrator Documents 00:04:00 Illustrator workspaces & Properties Panel 00:13:00 Artboards 00:12:00 Navigation & zooming in illustrator 00:08:00 New Illustrator cc 2019 view features 00:04:00 illustrator Preferences & Settings 00:11:00 illustrator Basic Geometric shapes 00:15:00 Illustrator Transformation & Rotation 00:11:00 illustrator Pathfinder panel & Shape Builder tool 00:11:00 Illustrator Selection tools & methods 00:09:00 grouping elements in illustrator 00:05:00 illustrator Layers 00:07:00 Illustrator Align & distribute panel 00:04:00 Illustrator Guides, Grids & Rulers 00:11:00 Exercise: Drawing Basic Geometric shapes 00:17:00 Illustrator Stroke Panelââ 00:09:00 Colors, Appearance & Graphic Styles in Illustrator Illustrator color panels (color, swatches, themes, guide)ââ 00:18:00 Illustrator Gradient colors panel 00:12:00 Free form gradient ( Illustrator 2019 users) 00:06:00 Illustrator Appearance & Graphic style panels 00:09:00 Illustrator effects 00:14:00 Exercise: Appearance, graphic style, gradients 00:09:00 Drawing Tools & Techniques Illustrator Pencil Tool 00:06:00 Illustrator Brush tool 00:03:00 Illustrator Drawing modes & blob brush tool 00:17:00 Illustrator Pen Tools 00:14:00 Illustrator curvature tool 00:05:00 Pen Tools & curvature tool exercise 00:18:00 Illustrator drawing modifying tools 00:13:00 illustrator Transform & distort tools (Liquify Tools) 00:09:00 Illustrator Puppet Warp tool 00:04:00 Illustrator Envelope Distort 00:07:00 Drawing Symmetric Shapes 00:08:00 Drawing Concentric Symmetrical design 00:11:00 Illustrator Clipping Masks 00:11:00 Illustrator Opacity Masks 00:07:00 illustrator live paint bucket tool 00:09:00 Recolor Artwork 00:08:00 Complex Drawing Exercise 00:08:00 Illustrator Complex Drawing techniques 00:15:00 Illustrator Brushes Illustrator Art Brushes 00:13:00 Illustrator Scatter Brush 00:09:00 illustrator Bristle Brush 00:07:00 Illustrator Calligraphic brush 00:09:00 Illustrator Pattern brush 00:07:00 Illustrator Images brushes 00:09:00 Illustrator brushes exercise 00:03:00 Design With images in illustrator Images modifying for tracing 00:06:00 Tracing images in illustrator 00:12:00 Enhancing traced Vectors & coloring hints 00:06:00 Illustrator image exercise 00:03:00 Typography in Illustrator Illustrator Typography Anatomy & Character control 00:14:00 illustrator Paragraphes control 00:12:00 Illustrator Character & paragraph styles panels 00:10:00 Font Selection (illustrator cc 2019 users) 00:04:00 Illustrator Fonts (Filtering, Variable, glyphs, stylistic sets, open type, SVG) 00:15:00 illustrator Touch type tool 00:02:00 Illustrator type on a path tools 00:07:00 Clipping Typography Masks 00:03:00 Illustrator Typography Art directions & trending visual effects 00:14:00 Illustrator type envelope distort 00:04:00 illustrator text wrap 00:02:00 Exercise: Typography composition 00:02:00 Illustrator Advanced Techniques & Tricks Illustrator Blend Tool 00:10:00 illustrator perspective drawing 00:12:00 Illustrator Symbols 00:11:00 illustrator global edits (Illustrator cc 2019 Users) 00:02:00 Creating Patterns in illustrator 00:09:00 Illustrator Graphs 00:14:00 Illustrator Gradient Mesh 00:08:00 Exporting & Finalizing Artwork in illustrator Exporting illustrator files & save for web 00:06:00 Preparing & exporting illustrator file for printing 00:06:00 Asset Export Panel 00:01:00 Creative Cloud & Illustrator Libraries 00:07:00 illustrator export for screens, save for web & Archiving files 00:09:00 Assessment Assessment - Illustrator CC - Beginners To Advanced 00:10: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
Embark on a coding odyssey like no other with our course, 'Start Learning Arduino without Writing a Single Line of Code.' Imagine a journey where the intricacies of Arduino unfold effortlessly, without the need for complex coding. From the basics of Arduino and embedded systems to the installation of ArduinoBlockly, this course revolutionizes learning by offering a code-free approach. Visualize yourself effortlessly interfacing LEDs, switches, buzzers, and even mastering advanced concepts like pulse width modulation and ultrasonic distance sensing. Each module is a gateway to a new project, from traffic light controllers to digital thermometers, all achieved without a single line of code. This course is not just an introduction; it's an invitation to witness the magic of Arduino without the constraints of traditional coding barriers. Learning Outcomes Attain a profound understanding of Arduino basics and embedded systems without the need for traditional coding syntax. Master the installation and program downloading process using ArduinoBlockly and Arduino IDE. Acquire hands-on experience in interfacing LEDs, switches, buzzers, and tri-color LEDs, realizing projects like chasers and traffic light controllers without writing a single line of code. Explore advanced concepts such as serial communication, ADC, pulse width modulation, ultrasonic distance sensing, and servo motor interfacing, unlocking a world of possibilities without coding complexities. Gain the ability to create functional projects, including digital thermometers, water level indicators, and servo-based angular control, utilizing a code-free approach. Why choose this Start Learning Arduino without Writing a Single Line of Code 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 Start Learning Arduino without Writing a Single Line of Code for? Coding beginners and enthusiasts eager to explore Arduino without delving into traditional programming. Students and hobbyists looking for a hands-on, code-free introduction to embedded systems. DIY enthusiasts intrigued by the prospect of building innovative projects without the complexities of coding. Technology enthusiasts interested in mastering Arduino interfaces, sensors, and advanced concepts without traditional coding barriers. Anyone seeking a creative and accessible entry point into the world of Arduino and embedded systems. Career path Arduino Specialist: £25,000 - £40,000 Electronics Technician: £20,000 - £35,000 Embedded Systems Technician: £22,000 - £38,000 IoT Device Developer: £28,000 - £45,000 Automation Engineer: £30,000 - £50,000 Electronics Design Assistant: £23,000 - £38,000 Prerequisites This Start Learning Arduino without Writing a Single Line of Code does not require you to have any prior qualifications or experience. You can just enrol and start learning. This Start Learning Arduino without Writing a Single Line of Code 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 Introduction To Arduino Introduction To Course 00:01:00 Introduction to Embedded System and Arduino 00:04:00 Arduino Basics 00:09:00 Difference between C Syntax of Arduino and C Coding 00:10:00 Arduino And Ardublockly Installation And Program Downloading Arduino IDE and ArduinoBlockly Installation 00:10:00 Writing Program into ArduioBlockly and downloading on Board 00:11:00 Program Downloading using Arduino IDE 00:05:00 Arduino Interfaces Breadboard 00:08:00 LEDs LED Interfacing 00:11:00 Project 1: All LED Blinking 00:01:00 Project 2: Alternate LED Blinking 00:01:00 Project 3: Four LEDs ON - OFF 00:01:00 Project 4: Chaser 00:01:00 Ten Times LED Blinking 00:01:00 Switches Switch Interfacing 00:11:00 Project 6: LED and Switch Program 00:02:00 Project 7: Two LEDs and Two Switches Program 00:02:00 Buzzer Buzzer 00:03:00 Project 8: Buzzer Programming 00:01:00 Project 9: Buzzer and LED Program 00:01:00 Tri Color LED Tri-Color LED 00:05:00 Project 10: Tri-Color LED Based Red, Green, Blue Color Generation 00:01:00 Project 11: Tri Color LED Based Yellow, Cyan and Magenta Color Generation 00:01:00 Project 12: Traffic Light Controller 00:01:00 Project 13: Tri Color LED and Switch Based Color Generation 00:02:00 Seven Segment Display Seven Segment Display Interfacing 00:07:00 Project 14: Up Counter Using Seven Segment Display 00:04:00 Serial Communication Introduction Serial Communication 00:13:00 Project 15: Printing a Message into Monitor Window 00:01:00 Project 16: Message Reading Using Serial Communication 00:01:00 Project 17: Device Control 00:03:00 ADC And Analog Sensors ADC concepts 00:17:00 Project 18: Digital Thermometer 00:02:00 Project 19: Digital Voltmeter 00:02:00 Project 20: Digital Light Meter 00:01:00 Project 21: Temperature Controller 00:01:00 Pulse Width Modulation In Arduino Introduction To Pulse Width Modulation and its Concepts 00:12:00 Project 22: LED Fading 00:01:00 Ultrasonic Distance Sensing Ultrasonic Sensor concept 00:14:00 Project 23: Distance Meter 00:02:00 Project 24: Water Level Indicator 00:01:00 Servo Motor Interfacing Servo Interfacing with Arduino 00:15:00 Project 25: Servo Based Angular Control 00:01:00 Conclusion Conclusion 00:01:00
Highlights of the Course Course Type: Online Learning Duration: 2 Hours 5 Minutes 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 Microsoft Office Excel Understand the core competencies and principles of Microsoft Office Excel Explore the various areas of Microsoft Office Excel Know how to apply the skills you acquired from this course in a real-life context Become a confident and expert office admin Microsoft Office Excel 2016: Part 1 Beginner Level Course Master the skills you need to propel your career forward in Microsoft Office Excel. This course will equip you with the essential knowledge and skillset that will make you a confident office admin and take your career to the next level. This comprehensive excel beginner level course is designed to help you surpass your professional goals. The skills and knowledge that you will gain through studying this excel beginner level 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 Microsoft Office Excel practice and equip you with the essential skills, confidence and competence to assist you in the Microsoft Office Excel industry. You'll gain a solid understanding of the core competencies required to drive a successful career in Microsoft Office Excel. 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 office admin or for people who are aspiring to specialise in Microsoft Office Excel. Enrol in this excel beginner level 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 excel beginner level 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 Microsoft Office Excel 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 excel beginner level 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 excel beginner level 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%. Advance Your Career This excel beginner level course will provide you with a fresh opportunity to enter the relevant job market and choose your desired career path. Additionally, you will be able to advance your career, increase your level of competition in your chosen field, and highlight these skills on your resume. 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. Course Curriculum Getting Started With Excel 2016 Navigate the Excel User Interface - Introduction 00:01:00 Navigate the Excel User Interface 00:06:00 Use Excel Commands - Introduction 00:01:00 Use Excel Commands - Introduction 00:01:00 Create and Save a Basic Workbook - Introduction 00:05:00 Create and Save a Basic Workbook 00:05:00 Enter Cell Data - Introduction 00:01:00 Enter Cell Data 00:05:00 Flash Fill and Auto Fill 00:04:00 Use Excel Help - Introduction 00:01:00 Use Excel Help 00:03:00 Performing Calculations Create Worksheet Formulas - Introduction 00:01:00 Create Worksheet Formulas 00:06:00 Insert Functions - Introduction 00:01:00 Insert Functions 00:05:00 Reuse Formulas and Functions - Introduction 00:01:00 Reuse Formulas and Functions 00:05:00 Modifying a Worksheet Insert, Delete and Adjust Cells, Columns and Rows 00:04:00 Search for and Replace Data 00:06:00 Insert, Delete and Adjust Cells, Columns and Rows - Introduction 00:01:00 Use Proofing and Research Tools 00:01:00 Check the Spelling in a Worksheet 00:03:00 Search for and Replace Data - Introduction 00:01:00 Insights Task Pane 00:03:00 Formatting a Worksheet Apply Text Formats - Introduction 00:01:00 Apply Text Formats 00:06:00 Apply Number Formats - Introduction 00:02:00 Apply Number Formats 00:03:00 Align Cell Contents - Introduction 00:01:00 Align Cell Contents 00:03:00 Apply Cell Styles and Themes 00:06:00 Apply Cell Styles and Themes - Introduction 00:01:00 Create and Use Templates - Introduction 00:01:00 Apply Basic Conditional Formatting - Introduction 00:01:00 Apply Basic Conditional Formatting 00:03:00 Create and Use Templates 00:04:00 Printing Workbooks Preview and Print a Workbook 00:01:00 Configure and Preview a Print Job 00:03:00 Set Up the Page Layout - Introduction 00:01:00 Set Up the Page Layout 00:04:00 Configure Headers and Footers - Introduction 00:01:00 Configure Headers and Footers 00:02:00 Managing Workbooks Manage Worksheets - Introduction 00:01:00 Manage Worksheets 00:05:00 Manage Workbook and Worksheet Views - Introduction 00:01:00 Manage Workbook and Worksheet Views 00:01:00 Manage Workbook Properties - Introduction 00:01:00 Manage Workbook Properties 00:03:00 Final Assessment Assessment - Microsoft Office Excel 2016: Part 1 Beginner Level 00:10:00 Obtain Your Certificate Order Your Certificate of Achievement 00:00:00 Get Your Insurance Now Get Your Insurance Now 00:00:00 Feedback Feedback 00:00:00
Description: A professional receptionist is someone who is assigned as one of the front liners in the business. As a receptionist, it is your task to be knowledgeable on the operations and the overall state of the business. Since you are assigned to communicate first with the clients, it is important for you to have the skills in office management. This course is comprised of training in (1) organizational skills; (2) office management techniques; and (3) advanced Microsoft Office skills. These three pieces of training will help you become a professional receptionist and help in the success of your organization. Who is the course for? Current executive and personal assistants who want to improve their administrative skills. People who have an interest in becoming an executive or personal assistant. 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 hard copy 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: The Professional Receptionist Diploma course is a useful qualification to possess, and would be beneficial for the following careers: Assistant Manager Entrepreneur Assistant Executive Assistant Legal Secretary Personal Assistant Receptionist Secretary. Receptionist Receptionist 00:30:00 Importance of Receptionist 00:15:00 Different Types of Receptionist & Roles 01:00:00 Communication Skills for Receptionist 01:00:00 Telephone Skills 01:00:00 Listening Skills 01:00:00 Taking Messages 00:30:00 Presenting & Appearance 00:30:00 Reservation Procedure 00:15:00 Confidentiality Checklist 00:15:00 Being Organized as Receptionist 00:15:00 Becoming a Successful Receptionist 00:15:00 Being an Assistant Module One - Getting Started 00:30:00 Module Two - Working with Your Manager 01:00:00 Module Three - Administrative Soft Skills 01:00:00 Module Four - Effective Time Management 01:00:00 Module Five - Meeting Management 01:00:00 Module Six - Tools of the Trade (I) 01:00:00 Module Seven - Tools of the Trade (II) 01:00:00 Module Eight - Being an Effective Gatekeeper 01:00:00 Module Nine - Organizational Skills 01:00:00 Module Ten - Confidentiality Guidelines 01:00:00 Module Eleven - Special Tasks 01:00:00 Module Twelve - Wrapping Up 00:30:00 Executive and Personal Assistant Training Course- Activities 00:00:00 Answering Telephones Module One - Getting Started 00:30:00 Module Two - Core Skills Required 01:00:00 Module Three - Self-Management (I) 01:00:00 Module Four - Self-Management (II) 01:00:00 Module Five - Time Management (I) 01:00:00 Module Six - Time Management (II) 01:00:00 Module Seven - Organizing and Planning (I) 01:00:00 Module Eight - Organizing and Planning (II) 01:00:00 Module Nine - Communication (I) 01:00:00 Module Ten - Communication (II) 01:00:00 Module Eleven - Additional Challenges 01:00:00 Module Twelve - Wrapping Up 00:30:00 Professional Telephone Receptionist Course - Activities 00: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 Microsoft PowerPoint Module One - Getting Started 00:30:00 Module Two - Opening PowerPoint 01:00:00 Module Three - Working with the Interface 01:00:00 Module Four - Your First Presentation 01:00:00 Module Five - Working with Text 01:00:00 Module Six - Formatting Text and Paragraphs 01:00:00 Module Seven - Adding Pictures 01:00:00 Module Eight - Advanced Formatting Tasks 01:00:00 Module Nine - Working with Transitions and Animations 01:00:00 Module Ten - Setting Up Your Slide Show 01:00:00 Module Eleven - Showtime! 01:00:00 Module Twelve - Wrapping Up 00:30:00 Mock Exam Mock Exam- Professional Receptionist Diploma 00:30:00 Final Exam Final Exam- Professional Receptionist Diploma 00:30:00 Order Your Certificates and Transcripts Order Your Certificates and Transcripts 00:00:00
Register on the Arduino 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 Arduino 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 Arduino 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 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 Arduino 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 Introduction to Arduino Introduction To Course 00:01:00 Introduction to Embedded System and Arduino 00:04:00 Arduino Basics 00:09:00 Difference between C Syntax of Arduino and C Coding 00:10:00 Arduino and Ardublockly Installation and Program Downloading Arduino IDE and ArduinoBlockly Installation 00:10:00 Writing Program into ArduioBlockly and downloading on Board 00:11:00 Program Downloading using Arduino IDE 00:05:00 Arduino Interfaces Breadboard 00:08:00 LEDs LED Interfacing 00:11:00 Project 1: All LED Blinking 00:01:00 Project 2: Alternate LED Blinking 00:01:00 Project 3: Four LEDs ON - OFF 00:01:00 Project 4: Chaser 00:01:00 Ten Times LED Blinking 00:01:00 Switches Switch Interfacing 00:11:00 Project 6: LED and Switch Program 00:02:00 Project 7: Two LEDs and Two Switches Program 00:02:00 Buzzer Buzzer 00:03:00 Project 8: Buzzer Programming 00:01:00 Project 9: Buzzer and LED Program 00:01:00 Tri Color LED Tri-Color LED 00:05:00 Project 10: Tri-Color LED Based Red,Green, Blue Color Generation 00:01:00 Project 11: Tri Color LED Based Yellow, Cyan and Magenta Color Generation 00:01:00 Project 12: Traffic Light Controller 00:01:00 Project 13: Tri Color LED and Switch Based Color Generation 00:02:00 Seven Segment Display Seven Segment Display Interfacing 00:07:00 Project 14: Up Counter Using Seven Segment Display 00:04:00 Serial Communication Introduction Serial Communication 00:13:00 Project 15:Printing a Message into Monitor Window 00:01:00 Project 16: Message Reading Using Serial Communication 00:01:00 Project 17: Device Control 00:03:00 ADC and analog sensors ADC concepts 00:17:00 Project 18: Digital Thermometer 00:02:00 Project 19: Digital Voltmeter 00:02:00 Project 20: Digital Light Meter 00:01:00 Project 21: Temperature Controller 00:01:00 Pulse Width Modulation in Arduino Introduction To Pulse Width Modulation and its Concepts 00:12:00 Project 22: LED Fading 00:01:00 Ultrasonic Distance Sensing Ultrasonic Sensor concept 00:14:00 Project 23: Distance Meter 00:02:00 Project 24: Water Level Indicator 00:01:00 Servo Motor Interfacing Servo Interfacing with Arduino 00:15:00 Project 25: Servo Based Angular Control 00:01:00 Conclusion Conclusion 00:01:00 Resources Resources - Start Learning Arduino without Writing a Single Line of Code 00:00: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.
Learning Objectives Introduction , Customizing Excel , Analyzing Data with Logical Functions , Working with Lookup Functions , Using Text Functions , Working with Date and Time Functions , Formula Auditing , What-If Analysis , Worksheet and Workbook Protection , Automating with Macros , Working with Form Controls , Ensuring Data Integrity , Collaborating in Excel , Importing and Exporting Data to a Text File , Conclusion Pre-Requisites Excel 365 Introduction and Intermediate courses or equivalent experience. Description This course will teach students advanced concepts and formulas in Microsoft Excel 365. Students will learn functions such as SUMIF, AVERAGEIF, and COUNTIF, advanced lookup functions, and complex logical and text functions. Additionally, students 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 their worksheets and workbooks. Students will also learn about Excel's many collaboration features and import and export data to and from their workbooks. Course Introduction Introduction 00:01:00 Section 01 Lesson 01-Customizing the Ribbon 00:09:00 Lesson 02-Customizing the Quick Access Toolbar 00:06:00 Lesson 03-Customizing the General and Formula Options 00:04:00 Lesson 04-Customizing the AutoCorrect Options 00:03:00 Lesson 05-Customizing the Save Defaults 00:04:00 Lesson 06-Customizing Advanced Excel Options 00:03:00 Section 02 Lesson 01-Working with the Most Common Logical Functions 00:03:00 Lesson 02-Understanding IF Functions 00:06:00 Lesson 03-Evaluating Data with the AND Function 00:05:00 Lesson 04-Evaluating Data with the OR Function 00:03:00 Lesson 05-Creating a Nested IF Function 00:05:00 Lesson 06-Using the IFS Function 00:03:00 Lesson 07-Summarizing Data with SUMIF 00:03:00 Lesson 08-Summarizing Data with AVERAGEIF 00:02:00 Lesson 09-Summarizing Data with COUNTIF 00:02:00 Lesson 10-Summarizing Data with MAXIFS and MINIFS 00:03:00 Lesson 11-Using the IFERROR Function 00:03:00 Section 03 Lesson 01-What are Lookup Functions 00:03:00 Lesson 02-Using VLOOKUP 00:08:00 Lesson 03-Using HLOOKUP 00:03:00 Lesson 04-Using VLOOKUP with TRUE 00:04:00 Lesson 05-Using HLOOKUP with TRUE 00:02:00 Lesson 06-Using the Index Function 00:03:00 Lesson 07-Using the MATCH Function 00:03:00 Lesson 08-Combining INDEX and MATCH 00:04:00 Lesson 09-Comparing Two Lists with VLOOKUP 00:02:00 Lesson 10-Comparing Two Lists with VLOOKUP and ISNA 00:04:00 Lesson 11-Using the New XLookup Function-v2 00:07:00 Lesson 12-Using Dynamic Array functions-v2 00:06:00 Lesson 13-Other New Functions-v2 00:04:00 Section 04 Lesson 01-What are Text Functions 00:01:00 Lesson 02-Using CONCAT, CONCATENATE, AND TEXTJOIN 00:04:00 Lesson 03-Using Text to Columns 00:02:00 Lesson 04-Using LEFT, RIGHT, and MID Functions 00:03:00 Lesson 05-Using UPPER, LOWER, and PROPER Functions 00:02:00 Lesson 06-Using the Len Function 00:03:00 Lesson 07-Using the Trim Function 00:01:00 Lesson 08-Using the SUBSTITUTE Function 00:02:00 Section 05 Lesson 01-What are Date and Time Functions 00:02:00 Lesson 02-Using TODAY, NOW, and DAY Functions 00:03:00 Lesson 03-Using NETWORKDAYS and YEARFRAC Functions 00:03:00 Section 06 Lesson 01-Showing Formulas 00:03:00 Lesson 02-Tracing Precedents and Dependents 00:04:00 Lesson 03-Adding a Watch Window 00:04:00 Lesson 04-Error Checking 00:04:00 Section 07 Lesson 01-Using the Scenario Manager 00:07:00 Lesson 02-Using Goal Seek 00:03:00 Lesson 03-Analyzing with Data Tables 00:04:00 Section 08 Lesson 01-Understanding Protection 00:02:00 Lesson 02-Encrypting Files with Passwords 00:05:00 Lesson 03-Allowing Specific Worksheet Changes 00:02:00 Lesson 04-Adding Protection to Selected Cells 00:03:00 Lesson 05-Additional Protection Features 00:03:00 Section 09 Lesson 01-What are Macros 00:03:00 Lesson 02-Displaying the Developer Tab 00:03:00 Lesson 03-Creating a Basic Formatting Macro 00:05:00 Lesson 04-Assigning a Macro to a Button 00:03:00 Lesson 05-Creating Complex Macros 00:04:00 Lesson 06-Viewing and Editing the VBA Code 00:04:00 Lesson 07-Adding a Macro to the Quick Access Toolbar 00:03:00 Section 10 Lesson 01-What are Form Controls 00:02:00 Lesson 02-Adding a Spin Button and Check Boxes 00:04:00 Lesson 03-Adding a Combo Box 00:07:00 Section 11 Lesson 01-What is Data Validation 00:02:00 Lesson 02-Restricting Data Entry to the Whole Numbers 00:02:00 Lesson 03-Restricting Data Entry to a List 00:04:00 Lesson 04-Restricting Data Entry to a Date 00:02:00 Lesson 05-Restricting Data Entry to Specific Text Lengths 00:01:00 Lesson 06-Composing Input Messages 00:02:00 Lesson 07-Composing Error Alerts 00:03:00 Lesson 08-Finding Invalid Data 00:02:00 Lesson 09-Editing and Deleting Validation Rules 00:01:00 Section 12 Lesson 01-Working with Comments-v2 00:03:00 Lesson 02-Printing Comments and Errors 00:02:00 Lesson 03-Sharing a Workbook 00:04:00 Lesson 04-Co-Authoring in Excel 00:02:00 Lesson 05-Tracking Changes in a Workbook 00:03:00 Lesson 06-Working with Versions 00:03:00 Lesson 07-Sharing files Via Email-v2 00:03:00 Section 13 Lesson 01-Importing a Text File 00:04:00 Lesson 02-Exporting Data to a Text File 00:01:00 Course Recap Recap 00:02:00 Additional Materials Resource - Excel 365 Advanced 00:00:00 Final Exam Final Exam - Excel 365 Advanced 00:20:00
Administrative office strategies may not be fabulous, but rather they are fundamental to the achievement of any venture. A well-run office diminishes miscommunications and dispenses with regular blunders. By making the administrative office a need, you will build up clear arrangements and methodology with representative comprehension and purchase in, which guarantees that your workplace runs easily. This course is about every single administrative strategy that ought to be incorporated into your business or company. You will be able to learn about the administrative instruments, how they utilised adequately and productive way to diminish the problems and issues. The course will also discuss the best five to methodologies that you require to record in the binder to guarantee the recordings are exact and accurate. Other things you will consider are the things that ought to be incorporated into the cover, for example, how telephone calls ought to be addressed and how to incorporate the particular arrangements of the association like compensation plans. All of these lessons and more will be taught in this course thoroughly. Who is the course for? Professionals, employees or businessmen who want to improve the administration department of their company. People who want to know how administrative management works. 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 can sit for an optional 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 hard copy at a cost of £14.99 or in PDF format at a cost of £11.99. 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: The Diploma in Administrative Management is a useful qualification to possess, and would be beneficial for the following careers: Accounting Technician Admin Assistant Bid Writer Bookkeeper Civil Service Administrative Officer Data Entry Clerk Finance Officer Hotel Receptionist Legal Secretary Payroll Administrator Liaison Officers Supervisor Typist. Administrative Management Module One - Getting Started 00:30:00 Module Two - Why Your Office Needs Administrative Procedures 01:00:00 Module Three - Gathering the Right Tools 01:00:00 Module Four - Identifying Procedures to Include 01:00:00 Module Five - Top Five Procedures to Record 01:00:00 Module Six - What to Include in Your Binder (I) 01:00:00 Module Seven - What to Include in Your Binder (II) 01:00:00 Module Eight - Organizing Your Binder 01:00:00 Module Nine - What Not to Include in the Procedure Guide 01:00:00 Module Ten - Share Office Procedure Guide 01:00:00 Module Eleven - Successfully Executing the Guide 01:00:00 Module Twelve - Wrapping Up 00:30:00 Admin Support Module One - Getting Started 00:30:00 Module Two - Getting Organized (I) 01:00:00 Module Three - Getting Organized (II) 01:00:00 Module Four - Managing Time 01:00:00 Module Five - Getting It All Done On Time 01:00:00 Module Six - Special Tasks 01:00:00 Module Seven - Verbal Communication Skills 01:00:00 Module Eight - Non-Verbal Communication Skills 01:00:00 Module Nine - Empowering Yourself 01:00:00 Module Ten - The Team of Two 01:00:00 Module Eleven - Taking Care of Yourself 01:00:00 Module Twelve - Wrapping Up 00:30: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 PowerPoint Module One - Getting Started 00:30:00 Module Two - Opening PowerPoint 01:00:00 Module Three - Working with the Interface 01:00:00 Module Four - Your First Presentation 01:00:00 Module Five - Working with Text 01:00:00 Module Six - Formatting Text and Paragraphs 01:00:00 Module Seven - Adding Pictures 01:00:00 Module Eight - Advanced Formatting Tasks 01:00:00 Module Nine - Working with Transitions and Animations 01:00:00 Module Ten - Setting Up Your Slide Show 01:00:00 Module Eleven - Showtime! 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 Microsoft Access Module One - Getting Started 00:30:00 Module Two - Opening and Closing Access 01:00:00 Module Three - An Introduction to Databases 01:00:00 Module Four - Sharing Data Using Apps 01:00:00 Module Five - Working in Your App 01:00:00 Module Six - An Introduction to Desktop Databases 01:00:00 Module Seven - Performing Basic Table Tasks 01:00:00 Module Eight - Working with Fields 01:00:00 Module Nine - Working with Table Relationships 01:00:00 Module Ten - An Introduction to Queries, Forms, and Reports 01:00:00 Module Eleven - Protecting Your Data 01:00:00 Module Twelve - Wrapping Up 00:30:00 Mock Exam Mock Exam- Diploma in Administrative Management 00:20:00 Final Exam Final Exam- Diploma in Administrative Management 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00
Description: Microsoft Office includes Access, Excel, Outlook, Power Point, Publisher and Word. The most widely used version is the desktop version. These versions are available on different operating systems. Through this course, you will learn the necessary skills, knowledge, and information about Microsoft Office. You will know the different components and parts of Microsoft Office that you need to learn to be able to utilise the programs. You will realise that you will not be able to work without it since it is very user-friendly and helpful in your career. Who is the course for? New staff or professionals who want to learn about the Microsoft Office Essentials People who have an interest in the basics and features of Microsoft Office 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: The Microsoft Office Essentials course is a useful qualification to possess and would be beneficial for any type of professions or careers like: Account Manager Administrative Assistant Executive Assistant Office Administrator Office Manager Personal Assistant Secretary Supervisor Top Executive. 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 Word for Newbies - Activities 00:00: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 Excel for Newbies - Activities 00:00:00 Microsoft PowerPoint Module One - Getting Started 00:30:00 Module Two - Opening PowerPoint 01:00:00 Module Three - Working with the Interface 01:00:00 Module Four - Your First Presentation 01:00:00 Module Five - Working with Text 01:00:00 Module Six - Formatting Text and Paragraphs 01:00:00 Module Seven - Adding Pictures 01:00:00 Module Eight - Advanced Formatting Tasks 01:00:00 Module Nine - Working with Transitions and Animations 01:00:00 Module Ten - Setting Up Your Slide Show 01:00:00 Module Eleven - Showtime! 01:00:00 Module Twelve - Wrapping Up 00:30:00 PowerPoint Essential Activities 00:00:00 Microsoft Access Module One - Getting Started 00:30:00 Module Two - Opening and Closing Access 01:00:00 Module Three - An Introduction to Databases 01:00:00 Module Four - Sharing Data Using Apps 01:00:00 Module Five - Working in Your App 01:00:00 Module Six - An Introduction to Desktop Databases 01:00:00 Module Seven - Performing Basic Table Tasks 01:00:00 Module Eight - Working with Fields 01:00:00 Module Nine - Working with Table Relationships 01:00:00 Module Ten - An Introduction to Queries, Forms, and Reports 01:00:00 Module Eleven - Protecting Your Data 01:00:00 Module Twelve - Wrapping Up 00:30:00 Activities - Microsoft Access for Beginners 00:00:00 Microsoft Outlook Module One - Getting Started 00:30:00 Module Two - Opening and Closing Outlook 01:00:00 Module Three - Understanding the Interface 01:00:00 Module Four - Working with the Message List and the Reading Pane 01:00:00 Module Five - Using Message List Commands 01:00:00 Module Six - Creating a New Email 01:00:00 Module Seven - Managing Email 01:00:00 Module Eight - Searching for Items 01:00:00 Module Nine - An Introduction to the Calendar 01:00:00 Module Ten - An Introduction to Tasks 01:00:00 Module Eleven - An Introduction to Contact 01:00:00 Module Twelve - Wrapping Up 00:30:00 Activities - Microsoft Outlook for Beginners 00:00:00 Microsoft Publisher Module One - Getting Started 00:30:00 Module Two - Opening Publisher 01:00:00 Module Three - Working with the Interface 01:00:00 Module Four - Your First Publication 01:00:00 Module Five - Working with Pictures 01:00:00 Module Six - Basic Editing Tasks 01:00:00 Module Seven - Formatting Fonts 01:00:00 Module Eight - Formatting Paragraphs 01:00:00 Module Nine - Working with Objects 01:00:00 Module Ten - Working with Pages 01:00:00 Module Eleven - Publishing Your Work 01:00:00 Module Twelve - Wrapping Up 00:30:00 Refer A Friend Refer A Friend 00:00:00 Mock Exam Mock Exam- Microsoft Office Essentials 00:30:00 Final Exam Final Exam- Microsoft Office Essentials 00:30:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00
Overview This comprehensive course on Python Programming: Beginner To Expert will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Python Programming: Beginner To Expert 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 Python Programming: Beginner To Expert. It is available to all students, of all academic backgrounds. Requirements Our Python Programming: Beginner To Expert 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 18 sections • 121 lectures • 15:27:00 total length •Intro To Python Section Overview: 00:05:00 •What is Python Programming: 00:10:00 •Who is This Course For: 00:05:00 •Python Programming Marketplace: 00:06:00 •Python Job Opportunities: 00:05:00 •How To Land a Python Job Without a Degree: 00:08:00 •Python Programmer Job Roles: 00:09:00 •Python from A-Z Course Structure: 00:04:00 •Getting Familiar with Python Section Overview: 00:06:00 •Installing Python on Windows: 00:10:00 •Anaconda and Jupyter Notebooks Part 1: 00:08:00 •Anaconda and Jupyter Notebooks Part 2: 00:16:00 •Comments: 00:05:00 •Python Syntax: 00:02:00 •Line Structure: 00:03:00 •Line Structure Exercise: 00:07:00 •Joining Lines: 00:05:00 •Multiple Statements on a Single Line: 00:05:00 •Indentation: 00:08:00 •Basic Data Types Section Overview: 00:08:00 •String Overview: 00:10:00 •String Manipulation: 00:07:00 •String Indexing: 00:04:00 •String Slicing: 00:08:00 •Printing: 00:10:00 •Python Variables: 00:08:00 •Integers and Floats: 00:08:00 •Booleans: 00:05:00 •Mini Project 1 : Letter Counter: 00:20:00 •Python Operators Section Overview: 00:04:00 •Comparison Operators: 00:09:00 •Arithmetic Operators: 00:08:00 •Assignment Operators: 00:04:00 •Logical Operators: 00:13:00 •Identity Operators: 00:05:00 •Membership Operators: 00:02:00 •Bitwise Operators: 00:08:00 •Python Advanced Data Types Section Overview: 00:11:00 •Sets: 00:06:00 •List Overview: 00:05:00 •List Slicing and Indexing: 00:04:00 •Tuples: 00:02:00 •When to use each one?: 00:05:00 •Compound Data Types: 00:03:00 •Dictionaries: 00:11:00 •Control Flow Part 1 Section Overview: 00:15:00 •Intro to Control Flow: 00:01:00 •Basic Conditional Statements: 00:14:00 •More Conditional Statements: 00:05:00 •For Loops: 00:10:00 •While Loops: 00:12:00 •Control Flow Part 2 Section Overview: 00:02:00 •Break Statements: 00:08:00 •Continue Statements: 00:05:00 •Zip Function: 00:07:00 •Enumerate Function: 00:04:00 •List Comprehension: 00:04:00 •Python Functions Section Overview: 00:03:00 •Intro to Functions: 00:02:00 •Python help Function: 00:03:00 •Defining Functions: 00:09:00 •Variable Scope: 00:08:00 •Doc Strings: 00:04:00 •User Input and Error Handling Section Overview: 00:02:00 •Introduction to error handling: 00:03:00 •User Input: 00:04:00 •Syntax Errors: 00:04:00 •Exceptions: 00:11:00 •Handling Exceptions Part 1: 00:08:00 •Handling Exceptions Part 2: 00:08:00 •Python Advanced Functions Section Overview: 00:05:00 •Lambda Functions: 00:05:00 •Functions args and kwargs: 00:10:00 •Iterators: 00:08:00 •Generators and Yield: 00:12:00 •Map Function: 00:14:00 •Filter Function: 00:08:00 •Python Scripting and Libraries Section Overview: 00:05:00 •What is a script: 00:01:00 •What is an IDE: 00:17:00 •What is a text editor?: 00:12:00 •From Jupyter Notebook to VScode Part 1: 00:15:00 •From Jupyter Notebook to VScode Part 2: 00:05:00 •Importing Scripts: 00:03:00 •Standard Libraries: 00:04:00 •Third Party Libraries: 00:06:00 •NumPy Section Overview: 00:04:00 •Intro to NumPy: 00:04:00 •Why use NumPy?: 00:04:00 •NumPy Arrays: 00:10:00 •Reshaping, Accessing, and Modifying: 00:07:00 •Slicing and Copying: 00:06:00 •Inserting, Appending, and Deleting: 00:10:00 •Array Logical Indexing: 00:04:00 •Broadcasting: 00:08:00 •Intro to Pandas: 00:17:00 •Pandas Series: 00:17:00 •Pandas Series Manipulation: 00:17:00 •Pandas DataFrame: 00:17:00 •Pandas DataFrame Manipulation: 00:13:00 •Dealing with Missing Values: 00:10:00 •Functional vs OOP: 00:06:00 •OOP Key Definitions: 00:04:00 •Create your First Class: 00:12:00 •How to Create and Use Objects: 00:06:00 •How to Modify Attributes: 00:12:00 •Python Decorators: 00:27:00 •Property Decorator: 00:09:00 •Class Method Decorator: 00:07:00 •Static Methods: 00:10:00 •Inheritance from A to Z: 00:21:00 •Python Career Section Overview: 00:06:00 •Getting Started with Freelancing: 00:09:00 •Building A Brand: 00:12:00 •Personal Branding: 00:13:00 •Importance of Having Website/Blog: 00:04:00 •Do's And Don'ts Of Networking: 00:06:00 •Top Freelance Websites: 00:08:00 •Creating A Python Developer Resume: 00:06:00 •Resources - Python Programming: Beginner To Expert: 00:00:00 •Assignment - Python Programming: Beginner To Expert: 00:00:00
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 Course Introduction Introduction 00:03:00 Part 1: Forecasting Basics of Forecasting 00:05:00 Creating Linear Model with Trendlines 00:08:00 1.1 Getting Data Ready For Regression Model Gathering Business Knowledge 00:03:00 Data Exploration 00:03:00 The Data and the Data Dictionary 00:07:00 Univariate analysis and EDD 00:03:00 Discriptive Data Analytics in Excel 00:10:00 Outlier Treatment 00:04:00 Identifying and Treating Outliers in Excel 00:04:00 Missing Value Imputation 00:03:00 Identifying and Treating missing values in Excel 00:04:00 Variable Transformation in Excel 00:03:00 Dummy variable creation: Handling qualitative data 00:04:00 Dummy Variable Creation in Excel 00:07:00 Correlation Analysis 00:09:00 Creating Correlation Matrix in Excel 00:08:00 1.2 Forecasting Using Regression Model The Problem Statement 00:01:00 Basic Equations and Ordinary Least Squares (OLS) method 00:08:00 Assessing accuracy of predicted coefficients 00:14:00 Assessing Model Accuracy: RSE and R squared 00:07:00 Creating Simple Linear Regression model 00:02:00 Multiple Linear Regression 00:05:00 The F - statistic 00:08:00 Interpreting results of Categorical variables 00:05:00 Creating Multiple Linear Regression model 00:07:00 1.3 Handling Special Events Like Holiday Sales Forecasting in presence of special events 00:02:00 Excel: Running Linear Regression using Solver 00:08:00 Excel: Including the impact of Special Events 00:22:00 1.4 Identifying Seasonality & Trend for Forecasting Models to identify Trend & Seasonality 00:06:00 Excel: Additive model to identify Trend & Seasonality 00:09:00 Excel: Multiplicative model to identify Trend & Seasonality 00:06:00 Market Basket Analysis Market Basket and Lift - Introduction 00:08:00 Named Ranges - Excel 00:10:00 Indirect Function - Excel 00:05:00 2-way lift calculation in Excel 00:11:00 2-way lift calculation - Dynamic 00:07:00 2-way lift data table creation 00:07:00 3-way lift calculation 00:19:00 Store Layout optimization using Lift values 00:15:00 RFM (Recency, Frequency, Monetary) Analysis RFM (recency, frequency, monetary) Analysis 00:08:00 RFM Analysis in Excel- Part 1 00:16:00 RFM Analysis in Excel- Part 2 00:12:00 Part 2: Pricing Part 2: Pricing Steps of setting a Pricing policy 00:03:00 Different Pricing Objectives 00:07:00 2.1 Estimating Demand Estimating Demand 00:07:00 Forms of Demand Curve 00:02:00 Excel: Estimating Linear Demand Curve 00:08:00 Excel: Estimating Power Demand curve with Elasticity 00:05:00 Excel: Estimating Power Demand Curve with points 00:03:00 Subjective Demand curve 00:01:00 Excel: Estimating Subjective Demand Curve 00:02:00 2.3 Evaluating Pricing Strategies Price Bundling 00:07:00 Types of Bundling 00:08:00 The Bundling Problem 00:04:00 Excel: Solving Bundling problem Part 1 00:14:00 Excel: Solving Bundling problem Part 2 00:08:00 Non-Linear Pricing Strategies 00:03:00 Excel: Solving Bundling problem (Price Reversal) 00:08:00 3.1 Lifetime Customer Value Lifetime Customer Value - Key concepts 00:09:00 Lifetime Customer Value - Excel model 00:11:00 3.2 Variations And Sensitivity Analysis Sensitivity Analysis in Excel 00:07:00 Variations in finding customer value 00:07:00 Appendix 1: Excel Crash Course Basics 00:08:00 Worksheet Basics 00:16:00 Entering values and Formulas 00:07:00 Data Handling Basics - Cut, Copy and Paste 00:14:00 Saving and Printing - Basics 00:09:00 Basic Formula Operations 00:13:00 Mathematical Formulas 00:19:00 Textual Formulas 00:17:00 Logical Formulas 00:11:00 Date-Time Formulas 00:07:00 Lookup Formulas ( V Lookup, Hlookup, Index-Match ) 00:08:00 Data Tools 00:19:00 Formatting data and tables 00:18:00 Pivot Tables 00:08:00 Advance Excel- Solver, Data tables 00:15:00 Assessment Assessment - Retail Analytics In Microsoft Excel Diploma 00:10:00 Obtain Your Certificate Order Your Certificate of Achievement 00:00:00 Get Your Insurance Now Get Your Insurance Now 00:00:00 Feedback Feedback 00:00:00