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

10768 Mac courses

Oracle 11g PL/SQL Beginner

4.3(43)

By John Academy

Description PL/SQL is program units which are composed by the Oracle Database server and stored in the database. The main function of PL/SQL is to hold SQL proclamation within its syntax. If you are interested to know more about SL/SQL function, and how it brings optimal competence in terms of 'procedural language', you may have a look at the Oracle 11g PL/SQL Beginner course. The course is designed in such a way that will assist the learners to know how it works with various strings, numbers, table row record, and error management. It also teaches the learner how to use different key data lexicon to synopsize and maintain the data. The learners will also be able to know about portability, productivity, and manageability of this most widely manipulative language. Assessment: This course does not involve any MCQ test. Students need to answer assignment questions to complete the course, the answers will be in the form of written work in pdf or word. Students can write the answers in their own time. Once the answers are submitted, the instructor will check and assess the work. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Oracle 11g PL/SQL Beginner is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our Oracle 11g PL/SQL Beginner is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Introduction Introduction FREE 00:03:00 Preparing Your Environment Course Setup 00:37:00 Working with Oracle Database Tools Selecting the Appropriate Database Tool 00:31:00 Language Features Understanding PL/SQL 00:18:00 PL/SQL Blocks 00:15:00 Working with SQL Plus 00:11:00 The DECLARE Clause DECLARE Clause Objects 00:16:00 PL/SQL Available Data Types 00:17:00 Declaring Simple Data Types and Assignments 00:12:00 Declaring Complex Data Types and Assignments 00:11:00 Declaring Complex RowTypes and Assignments 00:07:00 Declaring Complex Tables 00:08:00 Declaring Complex Records 00:08:00 Creating and Declaring User-Defined Types 00:09:00 The BEGIN Clause What Can Be Included in the BEGIN Clause 00:07:00 Working with CHAR and VARCHAR2 Variables 00:08:00 Handling String Literals 00:08:00 Working with Numeric Variables 00:07:00 Working with Date Variables 00:06:00 Assigning and Using Boolean Variables 00:08:00 Using Comparison Operators 00:07:00 Using SQL Functions 00:06:00 SQL DML within PL/SQL 00:15:00 Using SELECT 00:07:00 Exceptions and Embedded SQL 00:11:00 Using Sequences 00:14:00 Logic Control and Branching 00:07:00 Using GOTO 00:06:00 Working with LOOPS 00:19:00 Creating and Using the Indefinite Loop 00:07:00 Creating and Using the Conditional Loop 00:09:00 Using Nested Loops 00:12:00 Using the If-Then-Else 00:19:00 Using the CASE Statement 00:18:00 The EXCEPTION Clause What Are the Types of Exceptions 00:06:00 Trapping Exceptions 00:06:00 Identify Exception Details 00:11:00 Creating User-Defined Exceptions 00:11:00 Using SQLCODE and SQLERRM Objects 00:09:00 Understand the Implicit Cursor 00:15:00 Creating User-Defined Events 00:12:00 Explicit Cursors Understanding the Concept and Purpose of Explicit Cursors 00:18:00 Learn about Cursor Attributes 00:10:00 Using the Continue Statement 00:06:00 Working with Updateable Cursors 00:19:00 Creating and Using Cursor Parameters 00:15:00 FORLOOP Cursors 00:07:00 Nested Blocks Understanding Nested Blocks 00:11:00 Difference between Global vs Local Objects and Exceptions 00:13:00 Declared Subprograms Subprograms: How They Differ from Nested Blocks 00:18:00 Conclusion Conclusion 00:04:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Oracle 11g PL/SQL Beginner
Delivered Online On Demand9 hours 55 minutes
£18

Adobe Photoshop CS3 for Beginners

4.3(43)

By John Academy

Description: Adobe Photoshop has become a household name these days. Editing photos has never been easier thanks to this beautiful piece of software. Well thanks to this Adobe Photoshop CS3 for Beginners course, you can now master the software as well. This course is designed to help you learn Photoshop in an easy to understand manner. As the name suggests, this course will help you develop a strong foundation within this community. This course will help you get familiar with the different tools and provide plenty of examples along the way. So get this course immediately and build a strong foundation in Adobe Photoshop CS3 for Beginners. Learning Outcomes: Introduction to Photoshop CS3, new features, starting the program, workspace overview and exiting the program On screen options like the Menu Bar, Toolbox, Palettes, and The Status Bar Opening, creating, saving files, also find out about different file formats and how to view file info Customize the Toolbox and Palettes, choose a screen mode and save your workspace Using help menu, help, how to and online help Learn the toolbox through selection, crop and slice, retouching, painting and other types of tools Save, access and delete presets, along with using the preset palette Explore different palette options like navigator and info palettes and more View rulers, set up guides, view the grid, and set snap options Print your pictures through page setup, print command, print dialogue box, and printing single copies Understand pixels, bitmap and vector images, find out pixel information with info palette and basic anatomy of images Understand Image Resolution, change image size through pixels, image resampling, using auto resolution, dimension constraints, and changing the image document size Understand, flip and rotate canvas; and further work with canvas size, colour, and anchor point RGB and CMYK colours, colour setting and modes Using colour palette, ramp, picker and swatches Select complete images; use marquee, lasso, quick selection and refine edge tool; magic wand; and selection through colour range Add or subtract from selection, modify selections through moving, rotating, resizing, scaling, inverting, skewing and feathering options Save selected regions, cut, copy, paste, delete selections along with deselect and history palette Crop and trim images, adjust exposure, and convert to black and white Use basic editing tools like undo, redo, clear, duplicate and place Assessment: At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Adobe Photoshop CS3 for Beginners is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our Adobe Photoshop CS3 for Beginners is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Getting Started Introduction 00:15:00 The Photoshop CS3 Screen 00:15:00 File Management Basics 00:30:00 Modifying Your Photoshop Layout 00:30:00 Getting Help 00:30:00 Exploring Photoshop Introduction to the Photoshop Toolbox 01:00:00 Using Tool Presets 00:15:00 Introduction to the Photoshop Palettes 00:30:00 Getting Started 00:15:00 Printing your Image 00:15:00 Images and Color Understanding Digital Images 00:30:00 Image Size and Resolution 01:00:00 Working with Your Canvas 00:30:00 Working with Color 01:00:00 Working with Color Tools 00:30:00 Image Basics Making Selections 01:00:00 Manipulating Selections 01:00:00 Editing with Selections 00:15:00 Adjusting Your Image 00:30:00 Basic Editing Tools 00:15:00 Mock Exam Mock Exam- Adobe Photoshop CS3 for Beginners 00:20:00 Final Exam Final Exam- Adobe Photoshop CS3 for Beginners 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Adobe Photoshop CS3 for Beginners
Delivered Online On Demand11 hours 25 minutes
£11.99

Speech And Language Therapy Diploma

4.3(43)

By John Academy

Speech and Language Therapy Diploma Description: 1.4 million children in the UK suffer from long term speech and language disorders. Fortunately, these children can overcome the speech difficulties with the right therapy and learn to express themselves without any glitches. If you want to pursue a career where you can help others live a better life, then speech therapy is your call. This Speech and Language Therapy Diploma is the best training ground for aspiring speech therapists. Starting from the basics Speech and Language Therapy Diploma course will introduce you to speech therapy's basic principles. You will gain an understanding of the scientific aspects of language and speech. This course will provide the necessary skills to deal with communication disorders like aphasia. It will enhance your ability to identify the problem and take action accordingly. Speech and language therapistscarry a huge amount of responsibilities. Enrol on the Speech and Language Therapy Diploma course and get a certificate to boost your career prospects. Disclaimer Please note that in this Speech And Language Therapy Diploma Course you will come across all the basic guidelines of a Speech and Language Therapist to boost and shine your knowledge in this particular field. However, the title Speech Therapist is protected by the HCPC and completion of this course does not entitle you to use the protected title or practise as a Speech Therapist. Also, it does not qualify you to join the HCPC register. If you are looking for a course to comply with HCPC's requirements, please contact the relevant authority. Assessment: This course does not involve any MCQ test. Students need to answer assignment questions to complete the course, the answers will be in the form of written work in pdf or word. Students can write the answers in their own time. Once the answers are submitted, the instructor will check and assess the work. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Speech and Language Therapy Diploma Course for? This is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential field-related skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our course is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will have a clear understanding of your job role and the industry, and this will help you to brighten up your career in the relevant job market. Speech And Language Therapy Diploma - Updated Version Module 01: An Overview of Speech Therapy 00:13:00 Module 02: The Science of Speech 00:20:00 Module 03: The Anatomy of Speech 02:00:00 Module 04: Characteristic of Speech: Linguistic Discipline 00:27:00 Module 05: Literacy and Language Development 00:22:00 Module 06: Child Speech & Language Disorders 00:32:00 Module 07: Adult Speech & Language Disorders 00:29:00 Module 08: How to Help a Child with SL Difficulties 00:25:00 Assignment Assignment - Speech And Language Therapy Diploma 00:00:00 Speech And Language Therapy Diploma - Old Version Introduction to Speech and Language Therapy Introduction to Speech and Language Therapy 00:30:00 Main Ethical Principles of ASHA 00:45:00 Language Acquisition and Literacy Development Literacy, Roles of SLT and Preliteracy in Newborns 00:30:00 The Scientific Aspects of Language and Speech Speech Science 00:30:00 Basic Structure and Function of the Human Nervous System 00:20:00 Basics of Linguistics 00:30:00 Communication Disorders Communication Disorders and Fluency disorder 00:20:00 Speech disorders 00:30:00 Language Disorders 00:20:00 Aphasia 00:30:00 Other Speech and Language Disorders Agnosia, Attention-Deficit/Hyperactivity Disorder and Dementia 00:45:00 Understanding Brain Damage Locations 00:20:00 Traumatic Brain Injury 00:05:00 Huntington's disease and Parkinson's Disease 00:30:00 Swallowing Disorders 00:45:00 Mock Exam Mock Exam - Speech And Language Therapy Diploma Course 00:20:00 Final Exam Final Exam - Speech And Language Therapy Diploma Course 00:20:00 Order Your Certificates and Transcripts Order Your Certificates and Transcripts 00:00:00

Speech And Language Therapy Diploma
Delivered Online On Demand12 hours 38 minutes
£11.99

American Sign Language (ASL) Course

4.3(43)

By John Academy

It's hard to imagine how many difficulties people with speech disabilities face in their day-to-day life. On top of that, they also suffer from loneliness, as very few of the hearing community can use sign language. If you wish to help them make their life easier, learning sign language is the first step you should take. The American Sign Language (ASL) course is here to help you out. The American Sign Language (ASL) course is designed to deepen your understanding of American Sign Language. In this course, you will learn how to show signs for the alphabet. The easy-to-follow modules will help you grasp the process of signing verbs in ASL. In addition, you will acquire the ability and the confidence to construct sentences related to colour, number, family, and animals. This comprehensive course will also train you to express your emotions in ASL. In addition, you will develop the essential expertise to discuss food and drinks in sign language.  This beneficial American Sign Language (ASL) course will also give you a certificate after completing the course. This certificate will assist you in pursuing a promising career in the revenant fields. Learning Outcomes Familiarise yourself with the signs for the alphabets Learn how to show the verb signs in ASL Understand how to show numbers, colours, animals in ASL Develop the ability to express your emotions in sign language Become competent in using the signs for food and drinks Who is this Course for? The American Sign Language (ASL) Course is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our American Sign Language (ASL) Course is fully compatible with any kind of device. Whether you are using Windows computers, 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. Assessment This course does not involve any MCQ test. Students need to answer assignment questions to complete the course, the answers will be in the form of written work in pdf or word. Students can write the answers in their own time. Once the answers are submitted, the instructor will check and assess the work. Certification After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at the cost of £39 or in PDF format at the cost of £24. 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 After completing this American Sign Language (ASL) course, you will be able to build up accurate knowledge and skills with proper confidence to pursue a career in the following fields. ASL Teacher SEN Teacher SEN Teaching Assistant Social Worker Introduction Introduction FREE 00:01:00 The Golden Age of Deaf Education 00:11:00 The Age of Oralism 00:09:00 The Alphabet Letters A-J 00:07:00 Letters K-Z 00:07:00 Numbers Numbers 1-20 00:05:00 Numbers 30-99 00:03:00 21-29 00:04:00 Colors Colors 00:08:00 Sentence Practice - Colors 00:03:00 Animals Animal Signs - Part 1 00:10:00 Animal Signs - Part 2 00:10:00 Sentence Practice - Animals 00:02:00 Family Signs for Family 00:09:00 Sentence Practice - Family 00:02:00 Food and Drink Food and Drink - Part 1 00:09:00 Food and Drink - Part 2 00:12:00 Sentence Practice - Food and Drink 00:01:00 Your First Story 00:03:00 Verbs Verb Signs - Part 1 00:06:00 Verb Signs - Part 2 00:06:00 Sentence Practice - Verbs 00:01:00 Emotions Emotions 00:05:00 Your Second Story 00:11:00 Conclusion Conclusion 00:01:00 Resources Resources - American Sign Language (ASL) Course 00:00:00 Order Your Certificates and Transcripts Order Your Certificates and Transcripts 00:00:00

American Sign Language (ASL) Course
Delivered Online On Demand2 hours 26 minutes
£11.99

Bridal Hair Certificate

4.3(43)

By John Academy

Description: A hairstyle is a dominant area of styling. When it comes to Bridal hair styling, it is more important as your hairstyle can change the whole look. Proper hair styling can make your day memorable. If you want to master the bridal hair styling, the Bridal Hair Certificate course is designed for you. Throughout the course, you will master all the essential techniques that you need to know about becoming a freelance bridal hair stylist. You will learn various bridal hairstyles such as traditional up-dos, free-flowing styles and combinations of the two. The course provides a detailed discussion on the preparation process and teaches you how to set and complete a highly-sought after, modern romantic look. Shortly, the course covers the knowledge about the necessary equipment, best curly hair for loose, beachy waves, techniques for creating Hollywood-glam inspired waves, how to choose the right pin, strategies of making a messy bun with maximum hold, and more. By studying the course, you will not only be able to start your career as a bridal hair stylist but also able to market your business rightly. Assessment: This course does not involve any MCQ test. Students need to answer assignment questions to complete the course, the answers will be in the form of written work in pdf or word. Students can write the answers in their own time. Once the answers are submitted, the instructor will check and assess the work. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Bridal Hair Certificate is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our Bridal Hair Certificate is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Updated Version - Bridal Hair Certificate Module 01: Introduction to Bridal Hair Introduction to Bridal Hair 00:20:00 Module 02: Hair and Scalp Care for Brides Hair and Scalp Care for Brides 00:18:00 Select Module 03: Basic Bridal Hair Styling Techniques Module 03: Basic Bridal Hair Styling Techniques Basic Bridal Hair Styling Techniques 00:18:00 Module 04: Bridal Hair Updos and Braids Bridal Hair Updos and Braids 00:17:00 Select Module 05: Bridal Hair Coloring and Extensions Module 05: Bridal Hair Coloring and Extensions Bridal Hair Coloring and Extensions 00:18:00 Select Module 06: Advanced Bridal Hair Styling Module 06: Advanced Bridal Hair Styling Advanced Bridal Hair Styling 00:17:00 Old Version - Bridal Hair Certificate Bridal Hairstyles Preparation and Required Tools 01:00:00 Modern Romance Up-Do Part 1 - Hollywood Glam 01:00:00 Modern Romance Up-Do Part 2 - Pinning it Up 00:30:00 Other Popular Bridal Styles 01:00:00 Tips and Marketing 00:30:00 Unique Hairstyles Fishtail Braid Updo | The JLO Braid 00:15:00 Game of Thrones Inspired Hair Tutorial | The Khaleesi Braid 00:15:00 Slip Tie Braid | Knotted Mohawk Braid 00:30:00 Pull Back Ladder Braid Hairstyle Tutorial 00:15:00 Braided Flower Bun 00:15:00 Slip Knot Technique - 2 Strand Braid 00:15:00 French Pull-Through Braid Ponytail 00:30:00 Wedding Prom and Party Hairstyles 00:15:00 Romantic Hairstyle for Long Hair 00:15:00 Greek Goddess-Inspired Hairstyles! 00:15:00 Bridal Hairstyles 00:15:00 Updo Hairstyles 00:15:00 Half Updo Hairstyle 00:15:00 Updo Braided Elsa-Inspired Hairstyle Tutorial 00:15:00 Bridal Updo For Medium Hair and Long Hair 00:15:00 Outstanding Bridal Hairstyle 00:30:00 Romantic Side-Swept Updo 00:15:00 Order Your Certificates and Transcripts Order Your Certificates and Transcripts 00:00:00

Bridal Hair Certificate
Delivered Online On Demand10 hours 48 minutes
£11.99

Microsoft Excel: Master Power Query in 120 Minutes!

4.5(3)

By Studyhub UK

Overview Do you face struggle when you open a Power Query seeing the number of things to do then and cannot make good use of your time? Then this Microsoft Excel: Master Power Query in 120 Minutes! Course is just what you need.to break free of your worries. Power Query is a business intelligence tool available in Excel that allows you to import data from many sources and then clean, transform and reshape your data as needed. The course is designed for learners opting to learn Power Query, a feature available in Excel. Power query is a data connection technology that enables you to connect combine refine and discover data from various sources to meet analysis needs.  The course will introduce you to the basic features of Power query and then show how to trim and transform Data in Excel Power Query, Format Dates and Values in Excel Power Query. You will also learn how to extract data from folders and doing auto clean up on Excel Power Query. You will also learn to merge and shape data according to analysis requirements and prepare models by tools such as power pivot. Learning Outcomes: Acquire proficiency in using Excel Power Query for efficient data management. Master the art of transforming raw data into actionable insights. Learn advanced techniques for data manipulation and analysis. Develop the ability to streamline complex data processes. Enhance your analytical thinking and problem-solving skills. How is the course assessed? To successfully complete the course you must pass an automated, multiple-choice assessment. The assessment is delivered through our online learning platform. You will receive the results of your assessment immediately upon completion. Will I receive a certificate of completion? Upon successful completion, you will qualify for the UK and internationally-recognised certification and you can choose to make your achievement formal by obtaining your PDF Certificate at a cost of £9 and Hardcopy Certificate for £15. Why study this 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. Requirements Our Microsoft Excel: Master Power Query in 120 Minutes! Course is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career paths Data Analyst: £25,000 - £40,000 Per Annum Business Analyst: £30,000 - £50,000 Per Annum Financial Analyst: £28,000 - £45,000 Per Annum Marketing Analyst: £24,000 - £40,000 Per Annum Operations Analyst: £26,000 - £42,000 Per Annum Management Consultant: £35,000 - £55,000 Per Annum Course Curriculum Microsoft Excel: Master Power Query in 120 Minutes! Power Query Intro and Excel version 00:03:00 Excel Power Query - Introduction 00:03:00 Excel Power Query - Query Editor Ribbon 00:09:00 Transform Data - Trim in Excel Power Query 00:05:00 Transform Data - Format Dates and Values in Excel Power Query 00:02:00 Transform Data - Parsing URLs in Excel Power Query 00:05:00 Transform Data - Split Text Fields in Excel Power Query 00:10:00 Transform Data - Group By in Excel Power Query 00:03:00 Transform Data - Unpivoting Columns in Excel Power Query 00:05:00 Transform Data - Pivoting Columns in Excel Power Query 00:02:00 Transform Data - Split Columns into Other Columns in Excel Power Query 00:04:00 Transform Data - Filtering Rows in Excel Power Query 00:05:00 Transform Data - Sorting Columns in Excel Power Query 00:02:00 Transform Data - Transform and Add Columns in Excel Power Query 00:07:00 From Folder - Import From Folder in Excel Power Query 00:07:00 From Folder - Doing Auto Cleanup in Excel Power Query 00:13:00 From Folder - Extract Data from Forms in Excel Power Query 00:13:00 From Workbook - Extract Multiple Criteria in Excel Power Query 00:05:00 From Workbook - Extract Multiple Worksheets in Excel Power Query 00:04:00 Joins - Intro to Joins 00:04:00 Joins - Merging 00:08:00 Joins - Full Outer Join 00:06:00 Joins - Right Anti Join 00:09:00 Power Query - Convert Reports into Pivot Tables 00:05:00 Modulo 00:06:00

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

Level 3 Diploma in Microsoft Access

By iStudy UK

Description: Microsoft Access is a database management system (DBMS) from Microsoft. This software combines the relational Jet Database Engine with a graphical user interface and software-development tools. It stores data in its format based on the Access Jet Database Engine. Through this course, you will learn from beginner, intermediate, and advanced level skills, knowledge, and information about Microsoft Access 2013. You will then know the different components of the database so that you understand the structure underlying your data to know data manipulation and user control. Course Highlights Level 3 Diploma in Microsoft Access is an award-winning and the best selling course that has been given the CPD Qualification Standards & IAO accreditation. It is the most suitable course anyone looking to work in this or relevant sector. It is considered one of the perfect courses in the UK that can help students/learners to get familiar with the topic and gain necessary skills to perform well in this field. We have packed Level 3 Diploma in Microsoft Access into 39 modules for teaching you everything you need to become successful in this profession. To provide you ease of access, this course is designed for both part-time and full-time students. You can become accredited in just 1 day, 10 hours hours and it is also possible to study at your own pace. We have experienced tutors who will help you throughout the comprehensive syllabus of this course and answer all your queries through email. For further clarification, you will be able to recognize your qualification by checking the validity from our dedicated website. Why You Should Choose Level 3 Diploma in Microsoft Access Lifetime access to the course No hidden fees or exam charges Full Tutor support on weekdays (Monday - Friday) Efficient exam system, assessment, and instant results Download Printable PDF certificate immediately after completion Obtain the original print copy of your certificate, dispatch the next working day for as little as £9. Improve your chance of gaining professional skills and better earning potential. Who is this Course for? Level 3 Diploma in Microsoft Access is  IAO accredited. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic backgrounds. Requirements Our Level 3 Diploma in Microsoft Access is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path You will be ready to enter the relevant job market after completing this course. You will be able to gain necessary knowledge and skills required to succeed in this sector. All our Diplomas' are  IAO accredited so you will be able to stand out in the crowd by adding our qualifications to your CV and Resume. Microsoft Access Essentials Module One - Getting Started FREE 00:30:00 Module Two - Opening and Closing Access FREE 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 CPD Accredited 00:00:00 Microsoft Access Expert Module One - Getting Started 00:30:00 Module Two - Creating a Custom App 01:00:00 Module Three - Customizing App Actions 01:00:00 Module Four - Customizing Your App Views with Macros 01:00:00 Module Five - Working with Validation Rules and Messages 01:00:00 Module Six - Working with Macros 01:00:00 Module Seven - Advanced Query Tasks 01:00:00 Module Eight - Designing Forms 01:00:00 Module Nine - Advanced Reporting Tasks 01:00:00 Module Ten - Advanced Database Tools 01:00:00 Module Eleven - Working with the Access Environment 01:00:00 Module Twelve - Wrapping Up 00:30:00 Activities - Microsoft Access Intermediate Level Accredited Course 00:00:00 Microsoft Access Advanced Module One - Getting Started 00:30:00 Module Two - Using App Views 01:00:00 Module Three - Customizing Apps, Part One 01:00:00 Module Four - Customizing Apps, Part Two 01:00:00 Module Five - Working with More Record Tasks 01:00:00 Module Six - Using Advanced Field Tasks 01:00:00 Module Seven - Working in Table Design View 01:00:00 Module Eight - Working with the Expression Builder 01:00:00 Module Nine - Working with External Data 01:00:00 Module Ten - Creating Queries 01:00:00 Module Eleven - Creating Forms and Reports 01:00:00 Module Twelve - Wrapping Up 00:30:00 Activities - Certified Microsoft Access Professional 00:00:00 Mock Exam Mock Exam- Level 3 Diploma in Microsoft Access 00:30:00 Final Exam Final Exam- Level 3 Diploma in Microsoft Access 00:30:00

Level 3 Diploma in Microsoft Access
Delivered Online On Demand34 hours
£25

Professional Diploma in Microsoft Excel 2010

By iStudy UK

Whether you use excel for work or study, this online course covers beginner, intermediate and advanced lessons in excel. Microsoft Excel 2010 is the spreadsheet application in the MS Office 2010 suite. You will begin with the fundamentals, assembling a strong foundation that will give you further knowledge as you advance into intermediate and advanced level topics. By the end of this course, you will have mastered the most important Excel 2010 tools and come out with confidence to finish any Excel assignments with proficiency and grace. Course Highlights Professional Diploma in Microsoft Excel 2010 is an award winning and the best selling course that has been given the CPD Certification & IAO accreditation. It is the most suitable course anyone looking to work in this or relevant sector. It is considered one of the perfect courses in the UK that can help students/learners to get familiar with the topic and gain necessary skills to perform well in this field. We have packed Professional Diploma in Microsoft Excel 2010 into 39 modules for teaching you everything you need to become successful in this profession. To provide you ease of access, this course is designed for both part-time and full-time students. You can become accredited in just 1 day, 8 hours hours and it is also possible to study at your own pace. We have experienced tutors who will help you throughout the comprehensive syllabus of this course and answer all your queries through email. For further clarification, you will be able to recognize your qualification by checking the validity from our dedicated website. Why You Should Choose Professional Diploma in Microsoft Excel 2010 Lifetime access to the course No hidden fees or exam charges CPD Accredited certification on successful completion Full Tutor support on weekdays (Monday - Friday) Efficient exam system, assessment and instant results Download Printable PDF certificate immediately after completion Obtain the original print copy of your certificate, dispatch the next working day for as little as £9. Improve your chance of gaining professional skills and better earning potential. Who is this Course for? Professional Diploma in Microsoft Excel 2010 is CPD certified and IAO accredited. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic backgrounds. Requirements Our Professional Diploma in Microsoft Excel 2010 is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path You will be ready to enter the relevant job market after completing this course. You will be able to gain necessary knowledge and skills required to succeed in this sector. All our Diplomas' are CPD and IAO accredited so you will be able to stand out in the crowd by adding our qualifications to your CV and Resume. Microsoft Excel 2010 for Beginners Module One - Getting Started FREE 00:30:00 Module Two - Opening and Closing Excel FREE 01:00:00 Module Three - Your First Worksheet 01:00:00 Module Four - Working with Excel Files 01:00:00 Module Five - Viewing Excel Data 01:00:00 Module Six - Printing Excel Data 01:00:00 Module Seven - Building Formulas 01:00:00 Module Eight - Using Excel Functions 01:00:00 Module Nine - Using Time Saving Tools 00:30:00 Module Ten - Formatting Your Data 01:00:00 Module Eleven - Advanced Formatting Tools 01:00:00 Module Twelve - Wrapping Up 00:30:00 Microsoft Excel 2010 Intermediate Level Module One - Getting Started 00:30:00 Module Two - Working with Permissions and Options 01:00:00 Module Three - Sharing Workbooks 00:30:00 Module Four - Performing Advanced Formula and Function Tasks 01:00:00 Module Five - Working with Array Formulas 01:00:00 Module Six - Working with Functions 01:00:00 Module Seven - Working with Macros 01:00:00 Module Eight - Working with Forms 01:00:00 Module Nine - Applying Advanced Chart Features 01:00:00 Module Ten - Working with PivotTables and PivotCharts 01:00:00 Module Eleven - Using the Automated Analysis Tools Add -In 00:30:00 Module Twelve - Wrapping Up 00:30:00 Microsoft Excel 2010 Advanced Level Module One - Getting Started 00:30:00 Module Two - SmartArt and Objects 01:00:00 Module Three - Auditing 01:00:00 Module Four - Creating Charts 01:00:00 Module Five - Creating Pivot Tables 01:00:00 Module Six - Working with PivotTables and PivotCharts 01:00:00 Module Seven - Macros 01:00:00 Module Eight - Solving Formula Errors 01:00:00 Module Nine - Using What If Analysis 01:00:00 Module Ten - Managing Your Data 01:00:00 Module Eleven - Grouping and Outlining Data 00:30:00 Module Twelve - Wrapping Up 00:30:00 Activities Activities-Accredited Microsoft Excel 2010 for Beginners 00:00:00 Activities-Microsoft Excel 2010 Intermediate Level 00:00:00 Activities-Certified Microsoft Excel 2010 Advanced Level- CPD & IAO Accredited 00:00:00 Mock Exam Mock Exam- Professional Diploma in Microsoft Excel 2010 00:30:00 Final Exam Final Exam- Professional Diploma in Microsoft Excel 2010 00:30:00

Professional Diploma in Microsoft Excel 2010
Delivered Online On Demand32 hours
£25

Teaching English to Speakers of Other Languages (TESOL)

5.0(1)

By Course Gate

Be a certified TESOL and starts teaching with the Teaching English to Speakers of Other Languages (TESOL) course. TESOL stands for Teaching English to Speakers of Other Languages and encompasses what used to be called TEFL (Teaching English as a Foreign Language) and TESL (Teaching English as a Second Language). Getting a TESOL course opens your door to travel around the world and make your living better by teaching the English language. The course covers the mandatory aspect of TESOL and teaches you how to teach English. Teaching English does not include only the lexical, grammatical or pragmatic use of the language. It also includes the techniques of motivating your students, creating an anxiety-free zone for your learners and managing the classroom, etc. The course explains all these issues along with the necessary skills for teaching grammar, listening, speaking, reading, and writing. Finally, the course shows you the path to get hired abroad. Upon completion, you will be able to teach English properly and confidently. Who is this course for? Teaching English to Speakers of Other Languages (TESOL) is suitable for anyone who want to gain extensive knowledge, potential experience and professional skills in the related field. This course is CPD accredited so you don't have to worry about the quality. Requirements Our Teaching English to Speakers of Other Languages (TESOL) is open to all from all academic backgrounds and there is no specific requirements to attend this course. It is compatible and accessible from any device including Windows, Mac, Android, iOS, Tablets etc. CPD Certificate from Course Gate  At the successful completion of the course, you can obtain your CPD certificate from us. You can order the PDF certificate for £9 and the hard copy for £15. Also, you can order both PDF and hardcopy certificates for £22. Career path This course opens a new door for you to enter the relevant job market and also gives you the opportunity to acquire extensive knowledge along with required skills to become successful. You will be able to add our qualification to your CV/resume which will help you to stand out in the competitive job industry. Course Curriculum Teaching English to Speakers of Other Languages (TESOL) Introduction to Teaching English 00:45:00 Linguistics Basics 00:45:00 Working With a Variety of Approaches 01:00:00 Teaching Speaking 01:00:00 Teaching Listening 01:00:00 Teaching Reading 01:00:00 Teaching Writing 01:00:00 Planning Pedagogy 01:00:00 Planning Lessons 01:00:00 Managing Classrooms 01:00:00 Getting a job 01:00:00 Mock Exam Mock Exam - Teaching English to Speakers of Other Languages (TESOL) 00:20:00 Final Exam Final Exam - Teaching English to Speakers of Other Languages (TESOL) 00:20:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00

Teaching English to Speakers of Other Languages (TESOL)
Delivered Online On Demand11 hours 10 minutes
£11.99

Diploma in Business Management

4.3(43)

By John Academy

Description: Business Management helps you to oversees and supervise the whole business processes for the growth of your business. If you want to know the secret techniques of managing your business, then you have come to the right place. The Diploma in Business Management course focuses on how to plan, monitor, lead, control, and organise a project. The knowledge acquired from the job will prepare you to pursue a career in Business Operation and Management. Throughout the course, you will learn various branches of business such as basic accounting, finance, marketing, insurance, human resource management, human sciences, business communication, project management, and many more. The course will fill the gap between business goal and practical business operation. Upon completion, you will be able to take decisions for problem-solving. You will also be able to harmonise your company by applying the proper management techniques. Assessment: At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Diploma in Business Management is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our Diploma in Business Management is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Module 01 The Fundamentals of Business Process Management 00:30:00 Defining Business Process Management 00:30:00 The Business Process Life Cycle 00:15:00 The Vision Phase 00:15:00 The Design Phase 01:00:00 The Modeling Phase 00:30:00 The Execution Phase 01:00:00 The Monitoring Phase 00:30:00 The Optimizing Phase 01:00:00 Module 02 About the Learning Organization 00:15:00 Achieving Personal Mastery 00:15:00 Analyzing Our Mental Models 00:30:00 Achieving a Shared Vision 00:15:00 Team Learning 00:15:00 Systems Thinking 00:15:00 Understanding Leadership 00:30:00 Five Practices 00:15:00 Building Trust 00:15:00 Managing Change 00:30:00 The Four Room Apartment 00:15:00 Time Management Tips and Tricks 00:30:00 Managers vs. Leaders 00:15:00 Types of Thinking 00:15:00 Influence Strategies 00:15:00 Managing Relationships 01:00:00 Strategic Planning 00:00:00 Doing Delegation Right 00:15:00 Criteria for Useful Feedback 00:15:00 Feedback Techniques 00:15:00 Mastering Your Body Language 00:15:00 Meeting Management 00:30:00 Pumping up a Presentation 00:15:00 Module 03 Understanding the Balanced Scorecard 00:30:00 Overview of the Balanced Scorecard Process 00:30:00 Creating a Project Vision Statement 00:30:00 Understanding Organizational Mission, Vision, and Values 00:30:00 Plans and Processes to Build 00:30:00 Building Balanced Scorecard Teams 00:30:00 Module 04 A Need for Succession Planning 00:05:00 Defining a Succession Plan 00:15:00 Pre-Assignment Review 00:05:00 Identifying Resources and Analyzing Risks 00:15:00 Defining Roles, Responsibilities, and Functions 00:15:00 Gathering Information 00:15:00 Forecasting Needs 00:15:00 Putting the Plan Together 00:15:00 Putting the Plan into Action 00:15:00 Module 05 Understanding the Global Business Environment 00:45:00 The Global Trade Market 00:30:00 Products and Services 00:30:00 E-Commerce on the Global Stage 00:30:00 Working in the Global Context 00:45:00 The Economics of Global Business 00:00:00 The Logistics of Global Business 00:46:00 Rules and Regulations 00:45:00 Beyond the Rules - Ethical Concerns 00:45:00 Choosing Your Growth Strategy 00:30:00 Building Your Growth Plan 00:30:00 Implementing Your Growth Plan 00:30:00 Module 06 What is Corporate Social Responsibility? 00:30:00 Creating a Corporate Social Responsibility Program 00:15:00 Corporate Social Responsibility Principles 00:30:00 Mock Exam Mock Exam- Diploma in Business Management 00:30:00 Final Exam Final Exam- Diploma in Business Management 00:30:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Diploma in Business Management
Delivered Online On Demand26 hours
£25