1353 Scratch courses

Description: This Microsoft Office 2013 Excel Intermediate - Complete Video Course covers the intermediate functions and features of Excel 2013. You will learn about creating formulas, inserting graphics and enhancing workbooks. You will also learn how to organize worksheet data with tables and charts and how to analyze data using PivotTables, Slicers and PivotCharts. In this course creating advanced formulas, you will learn how to apply range names and how to use specialized functions. Once you are comfortable with the basics, you will be ready for this intermediate level. Here, you will explore more advanced formatting with terms, using Excel provided templates, adding graphics and charts, and using Excel as a database. You finish off with advanced formulas and applying conditional formatting to your worksheet, and more. If you want to take your Microsoft Excel 2013 skills to the next level, you'll learn how to use this program's advanced features to build a fully functional database from scratch. 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? Microsoft Office 2013 Excel Intermediate - Complete Video 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 Microsoft Office 2013 Excel Intermediate - Complete Video 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 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. Creating Advanced Formulas Apply Range Names FREE 00:18:00 Use Specialized Functions 00:14:00 Analyzing Data with Logical and Lookup Functions Leverage Questions and Testing to Write Formulas 00:01:00 Use Logical and Lookup Functions to Find Answers to Questions 00:25:00 Organizing Worksheet Data with Tables Create and Modify Tables 00:09:00 Sort and Filter Data 00:27:00 Use Summary and Database Functions to Calculate Data 00:25:00 Visualizing Data with Charts Create Charts 00:05:00 Modify and Format Charts 00:25:00 Create a Trendline 00:10:00 Create Advanced Charts 00:09:00 Analyzing Data with PivotTables, Slicers, and PivotCharts Create a PivotTable 00:24:00 Filter Data by Using Slicers 00:09:00 Analyze Data by Using PivotCharts 00:07:00 Inserting Graphics Insert and Modify Graphic Objects 00:10:00 Layer and Group Graphic Objects 00:12:00 Incorporate SmartArt 00:06:00 Enhancing Workbooks Customizing Workbooks 00:08:00 Manage Themes 00:06:00 Create and Use Templates 00:06:00 Protect Files 00:08:00 Mock Exam Mock Exam- Microsoft Office 2013 Excel Intermediate - Complete Video Course 00:20:00 Final Exam Final Exam- Microsoft Office 2013 Excel Intermediate - Complete Video Course 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Course Overview Won't it be amazing if you could transform your favorite print or designs into soft copy and change it however you want? Now you can do this using photoshop by following some simple steps. Learn how you can transform any design from paper to screen and make digital artworks using photoshop from this Digital Art (From paper to Screen) In Photoshop course and be able to change, modify and edit any artwork you like. This Digital Art (From paper to Screen) In Photoshop course will help you to transform any artwork into a soft copy and edit them. You will learn the editing process with Photoshop step by step. You will be able to scan the hard copy, clean any noise from the picture and edit it however you wish. You will learn the photo editing and transformation techniques from scratch with this course. Learning Outcomes Understand the basic function of Photoshop Learn how to scan your artwork Be able to clean up your work and make it ready to edit Learn how to change colors and shades using photoshop Create different patterns and make the artwork unique Be able to resize various templates to create new art pieces Who is this course for? This course is ideal for anyone who wants to learn how to transform a hard copy of art into a soft copy. This course will teach you how you can transform a photo from paper to digital art using photoshop.  Entry Requirement This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Certification After you have successfully completed the course, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hardcopy at the cost of £39 or in PDF format at the cost of £24. PDF certificate's turnaround time is 24 hours, and for the hardcopy certificate, it is 3-9 working days. Why choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry-leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognized accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. Career Path Digital Art (From paper to Screen) In Photoshop is a useful qualification to possess and would be beneficial for any related profession or industry such as: Designers Digital Artists Illustrators Photo Editors Digital Art (From paper to Screen) In Photoshop 1. Intro 00:03:00 2. Scanning Your Artwork 00:02:00 3. Cleaning Up Your Work in Photoshop 00:16:00 4. Color Exploration - Digitally Editing in Photoshop 00:07:00 5. Creating Patterns 00:11:00 6. Resizing for Various Template Dimensions 00:04:00 7. Final Tips 00:01:00 DigitalGuide-CatCoq 00:05:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Course Overview A library holds the history and literature of a culture or the whole world in the pages of its books. To make all these information accessible and enjoyable to people, proper library management is essential. Learn library management skills from this Diploma in Library and Information Science course and take the first step to be a librarian. This Diploma in Library and Information Science course will teach you how you can manage and organise information. You'll be familiarised with library infrastructure and acquire managerial and financial skills you need to be a librarian. You'll also learn about virtual library management skills. This course will help you to understand the functions of library networking and boost your skill. The easily understandable lessons will provide you with the updated skills and knowledge of library management. You'll be able to learn about information science from scratch in this course. Learning Outcomes Learn about the roles and responsibilities of a librarian Understand the ethical values in library management Be able to use library networking efficiently Familiarise with data management and the duties of library management Know about UK legislation of data storage and library management Be able to understand how to manage a digital library Familiarise with the virtual library system Learn to manage finance and budgeting for library resources Why Take This Course From John Academy? Affordable, well-structured and high-quality e-learning study materials Meticulously crafted engaging and informative tutorial videos and materials Efficient exam systems for the assessment and instant result Earn UK & internationally recognised accredited qualification Easily access the course content on mobile, tablet, or desktop from anywhere, anytime Excellent career advancement opportunities Get 24/7 student support via email What Skills Will You Learn from This Course? Network Building Financial Management Library Management Who Should Take this Diploma in Library and Information Science Course? Whether you're an existing practitioner or an aspiring professional, this course is an ideal training opportunity. It will elevate your expertise and boost your CV with key skills and a recognised qualification attesting to your knowledge. Are There Any Entry Requirements? This Diploma in Library and Information Science course is available to all learners of all academic backgrounds. But learners should be aged 16 or over to undertake the qualification. And a good understanding of the English language, numeracy, and ICT will be helpful. Diploma in Library and Information Science Certification After completing and passing the Diploma in Library and Information Science course successfully, you will be able to obtain a Recognised Certificate of Achievement. Learners can obtain the certificate in hard copy at £14.99 or PDF format at £11.99. Career Path The Diploma in Library and Information Science is a useful qualification to possess and would be beneficial for any related profession or industry such as: Librarians Library Assistants Researchers Data Analysts Data Scientists Diploma in Library and Information Science Module 01: Organisation Systems 00:27:00 Module 02: Ethics and Values in the Library Professions 00:23:00 Module 03: Library Networking 00:19:00 Module 04: Library as Infrastructure 00:27:00 Module 05: Finance and Budgeting 00:19:00 Module 06: Digital and Virtual Libraries 00:21:00 Module 07: Library Legislation 00:25:00 Order Your Certificates and Transcripts Order Your Certificates and Transcripts 00:00:00

Job hunting can be a real struggle and marketing yourself with key features in a piece of paper is a tricky task. Your resume is the key marketing tool for your career and should be a persuasive piece to highlight your academic qualifications and professional skills. Learn the art of resume writing with our Resume Writing - Your Ultimate Step-by-Step Resume Guide course. Selling yourself is probably the most required thing in the modern world. Our Resume Writing - Your Ultimate Step-by-Step Resume Guide will teach you how to revise, write, design, and format your resume to represent you in the best possible way. This course is about to give you an in-depth tour of the skills needed to master the art of resume writing. After successful completion of this resume writing course, you will be able to build a powerful professional resume which will help you grab the attraction of your prospective employee. What you'll learn Transform your current resume to a stunning, marketable resume Develop a cutting-edge resume that helps you stand out from the crowd Market yourself as a valuable employee Show your specific, marketable skills and traits through writing Determine which experiences and sections to include Teach others how to write an effective resume with examples Receive convenient and expert support and feedback for your resume Requirements Access to a word processor to edit or write your resume A resume already written ready to be transformed (my recommendation) OR ready to write a resume from scratch (this works too) Who this course is for: Recent or soon-to-be college graduates just entering the workforce Professionals looking to switch to a new career field Career center employees or anyone who helps others write resumes People looking to become professional resume writers Course Introduction Intro and Tips to the Course FREE 00:04:00 General Tips Introduction to General Tips 00:01:00 Words to Avoid 00:04:00 Writing Tip Show Don't tell FREE 00:07:00 Writing Tip Get with the Action 00:06:00 Final Writing Tip 00:02:00 Resume Length 00:02:00 Content: Heading and Top Spot Content Introduction 00:01:00 Heading 00:03:00 Top Spot Objective Versus Career Summary FREE 00:04:00 Top Spot Objective Function and Writing Tips 00:03:00 Top Spot Career Summary Function and Writing Tips 00:04:00 Top Spot How to write an effective career summary 00:16:00 Content: Experience and Education Section Experience Introduction and Selecting Experiences to Include FREE 00:05:00 Experience Headings and Summary 00:05:00 Experience Description of Accomplishments 00:11:00 Experience: Food for thought 00:05:00 Education Section 00:05:00 Content: Optional Sections Optional Section Activities Awards Leadership Honors 00:09:00 Activities/Awards Clarification 00:05:00 Optional Section Skills 00:04:00 Skills Clarification 00:10:00 Optional Section Certification License 00:01:00 Design and Layout Introduction to Design 00:01:00 Main Design Graphics and Element Layout FREE 00:07:00 Designer's Tools Typography and Appropriate White Space 00:07:00 Final Tips Just flip it, Organize, and Bullets 00:04:00 Artsy Resumes 00:05:00 Bonus: Watch me Transform a Resume Step-by-Step Transforming a resume steps 1-4 00:09:00 Continuing transforming a resume steps 5-12 00:06:00

Description Microsoft Project is one of the excellent project management software in the world. Microsoft Project is useful software which helps in assisting a project manager to develop a plan; assigning resources to tasks and much more. Get a kick start of Microsoft Project from the scratch through this course. Learn how to use Microsoft project management from the very beginning. Explore the essential functions and features of Microsoft Project. In this course you will learn the necessary skills, knowledge and information of Microsoft Project.  Who is this course for? Individuals who are interested in Microsoft Project and are seeking to acquire knowledge about it. For individuals who are already working in project management and are looking forward to excelling at their work place. 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 Microsoft Project for Beginners will be very beneficial and helpful, especially to the following professionals: Junior Project Manager. Project Assistant. Project Management Officer. Project Support. Microsoft Project for Beginners Module One - Getting Started 01:00:00 Module Two - Opening and Closing Project 02:00:00 Module Three - Your First Project 02:00:00 Module Four - Adding Tasks 02:00:00 Module Five - Advanced Task Operations 02:00:00 Module Six - Adding Resources 02:00:00 Module Seven - Other Ways to View Project Information 02:00:00 Module Eight - Managing Your Project Status 02:00:00 Module Nine - Updating and Tracking Your Progress 02:00:00 Module Ten - Creating Reports 02:00:00 Module Eleven - Adding the Finishing Touches 02:00:00 Module Twelve - Wrapping Up 01:00:00 Activities Microsoft Project for Beginners - Activities 00:00:00 Mock Exam Mock Exam- Microsoft Project for Beginners 00:20:00 Final Exam Final Exam- Microsoft Project for Beginners 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Indulge your passion for baking with our Cupcake Baking & Decorating course. Dive into the art of creating delectable cupcakes from scratch. From mastering the basics of cupcake baking and exploring a variety of flavors to crafting exquisite frostings and fillings, this course offers a comprehensive journey into the world of cupcakes. Learn innovative decorating techniques, stay updated with cupcake trends, and discover how to create specialty cupcakes that are sure to impress. Learning Outcomes: Baking Mastery: Learn the art of baking perfect cupcakes, from mixing to baking times. Flavorful Variations: Explore a wide range of flavors and variations for your cupcakes. Frosting Expertise: Master frosting and filling techniques for delectable cupcakes. Decorative Skills: Develop creative decorating skills for visually appealing cupcakes. Cupcake Trends: Stay current with the latest trends in cupcake design and presentation. Specialty Creations: Dive into specialty cupcakes, catering to unique tastes and occasions. Quality Control: Ensure consistency and quality in your cupcake production. Business Fundamentals: Understand the basics of starting a cupcake business. Why buy this Cupcake Baking & Decorating?  Unlimited access to the course for forever Digital Certificate, Transcript, student ID all included in the price Absolutely no hidden fees Directly receive CPD accredited qualifications after course completion Receive one to one assistance on every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Certification After studying the course materials of the Cupcake Baking & Decorating you will be able to take the MCQ test that will assess your knowledge. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Who is this course for? This Cupcake Baking & Decorating course is ideal for Baking Enthusiasts: Individuals passionate about baking and eager to enhance their cupcake-making skills. Aspiring Bakers: Those considering a career in baking or starting a cupcake business. Home Bakers: Home-based bakers looking to elevate their cupcake game. Event Planners: Professionals involved in event planning seeking cupcake expertise. Prerequisites This Cupcake Baking & Decorating 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. Career path Cupcake Baker: Average Earnings: $25,000 - $50,000 per year. Bakery Owner: Average Earnings: $30,000 - $60,000 per year (depending on the scale of the business). Event Baker: Average Earnings: $25,000 - $45,000 per year. Cupcake Decorator: Average Earnings: $20,000 - $40,000 per year. Baking Instructor: Average Earnings: $30,000 - $50,000 per year. Course Curriculum Module 01: Introduction to Cupcakes Introduction to Cupcakes 00:08:00 Module 02: Baking Cupcakes Baking Cupcakes 00:06:00 Module 03: Cupcake Flavours and Variations Cupcake Flavours and Variations 00:10:00 Module 04: Frosting and Fillings Frosting and Fillings 00:06:00 Module 05: Cupcake Decorating Techniques Cupcake Decorating Techniques 00:09:00 Module 07: Cupcake Trends Cupcake Trends 00:07:00 Module 06: Speciality Cupcakes Speciality Cupcakes 00:06:00

Take your songwriting to the next level with this ten session mentoring journey from Josh Bowker, acclaimed folk songwriter and workshop leader.

Learn how to create stunning websites with HTML5, CSS3, and Bootstrap. This course will teach you the fundamentals of web design and help you master the skills you need to succeed in the web development industry. Don't miss this opportunity to level up your web design skills.

This course first equips you with the fundamentals of Python and then progresses to teach you how to use various libraries such as NumPy, Pandas, Seaborn, Bokeh, and so on. This course contains several mini projects so that, by the end of this course, you will be equipped with the essential tools you need to become a visualization expert.

Create soaps that look good and smell out of this world. Acquire mastery in the soap-making process. Learn Types of Soap Making, Creative Moulds, and Troubleshooting in Soap Making.