- Professional Development
- Medicine & Nursing
- Arts & Crafts
- Health & Wellbeing
- Personal Development
1279 Scratch courses in Birmingham delivered Online
Excel - introduction (In-House)
By The In House Training Company
This one-day workshop is designed to give you an awareness of the fundamentals of Microsoft Excel and, in particular, to give you the confidence needed to efficiently create, edit and manage spreadsheets. This course will help participants: Create tables Use functions Manage rows and columns Write formulas Manage sheets Use content formats Handle larger tables Create reports and charts 1 Creating a table Creating an Excel table from scratch Wrapping text in cells Speeding up data entry using AutoFill Sorting columns 2 Inserting function Inserting function calculators Using AutoSum to sum numbers Statistical calculations AVERAGE, MAX and MIN 3 Table rows and columns Inserting and deleting rows and columns Adjusting multiple column widths and row heights Hiding and unhiding rows and columns 4 Formula writing The basics of formula writing Understanding mathematical symbols Using multiple mathematical symbols in a formula When to use brackets Troubleshooting calculation errors 5 Managing sheets Inserting, renaming, moving and deleting sheets Copying a worksheet to another file Copying a table to another sheet 6 Managing content formats Applying data formats Managing number formats Controlling formats with the Format Painter 7 Managing larger tables Applying freeze panes to lock tables when scrolling Sorting on multiple columns Using filters to extract table information 8 Creating and modifying charts Creating a pie chart Creating a column chart Inserting chart titles and data labels Controlling chart formatting Changing chart types 9 Printing Previewing and printing tables and charts Modifying page orientation Adjusting print margins Printing a selection 10 Calculating with absolute reference The difference between a relative and absolute formula Changing a relative formula to an absolute Using $ signs to lock cells when copying formulas 11 Pivot tables Create a pivot table report Insert a pivot chart into a report
Course Overview Sending updated notifications, analysis reports automatically will make your websites more efficient and improve your performance as well. Learn how you can use asynchronous JavaScript to set functions from this Asynchronous JavaScript for Beginner-Level course and get the best output from your websites. In this Asynchronous JavaScript for Beginner-Level course, you will learn beginner level JavaScript and asynchronous JavaScript functions. You will learn different scenarios of using JavaScript, functions. You'll be able to work with multiple values and set up functions based on your preferences. This course will teach you the function of asynchronous JavaScript from scratch. You will be able to understand the connection between databases and websites and be able to use them effectively. Learning Outcomes Familiarize with the fundamentals of asynchronous JavaScript Be able to perform repeated tasks be able to understand the functions of asynchronous code and promises Learn what generator is and how it works Familiarize with the use of async and await function Understand the functions of generators Learn the usability of the settimeout and set interval functions Who is this course for? This course is ideal for anyone who wants to be a programmer and learn the JavaScript programming language. You will be able to understand asynchronous JavaScript and its functions from this course. 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 Asynchronous JavaScript for Beginner-Level is a useful qualification to possess and would be beneficial for any related profession or industry such as: Programmers JavaScript Developers Web Developers App Designers Software Engineers Asynchronous JavaScript for Beginner-Level An Async Javascript Scenario 00:02:00 Defining Asynchronous / What is Synchronous code? 00:04:00 WORKSHOP -Exploring Synchronicity in JavaScript 00:09:00 All About Asynchronous Code 00:06:00 Course Roadmap 00:01:00 What is setTimeout? 00:05:00 DEMO - Delaying Code Execution with setTimeout 00:10:00 What is setInterval? 00:02:00 DEMO - Repeating Tasks with setInterval 00:07:00 Chapter Summary 00:01:00 What is Async / Await? 00:03:00 What are Promises? 00:02:00 DEMO - Wrapping setTimeout with a Promise 00:05:00 All About Async 00:02:00 DEMO - Performing Asynchronous Tasks Concisely with Async / Await 00:12:00 What are JavaScript Generator Functions? 00:02:00 Demo - Asynchronous JavaScript via generators 00:08:00 Course Summary 00:02:00 Order Your Certificates and Transcripts Order Your Certificates and Transcripts 00:00:00
Course Overview Understanding the function of an internal combustion engine is a must if you want to work in the automobile industry. This knowledge will increase your love for machines, especially cars, and open new career opportunities for you. Learn how an internal combustion engine works from this The Basics of Internal Combustion Engines course. This The Basics of Internal Combustion Engines course will teach you the basic functions and principle of internal combustion engines, their components and their work. You will be familiarized with the working procedure of two-stroke and four-stroke internal combustion engines. You will also understand the difference between petrol and diesel engine. This course will teach you everything you need to know about an internal combustion engine from scratch. You don't need any prior knowledge or formal certification to start this course. The easily understandable modules will help you to grasp the knowledge fast and memories them. It is ideal for all level of learners. Learning Outcomes Learn about the basic functions of the internal combustion engine Familiarize with the petrol and diesel engines Know how two-stroke engine works know about the working procedure of four-stroke engine Learn about the differences between petrol and diesel engines Be able to identify the main components of any engine Know all of an engines ancillary system and what they do Who is this course for? This comprehensive The Basics of Internal Combustion Engines is ideal for those who want to learn more about the function of internal combustion engines. 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 The Basics of Internal Combustion Engines is a useful qualification to possess and would be beneficial for any related profession or industry such as: Engineers Mechanics Automobile Engineers Motor Designers The Basics of Internal Combustion Engines Course Overview 00:02:00 Welcome 00:05:00 Engine Exterior 00:02:00 Common Engine Components 00:06:00 How Two Stroke Engines Work 00:15:00 How Four Stroke Engines Work 00:15:00 Petrol vs. Diesel 00:08:00 Lubrication Oil System 00:09:00 Fuel System 00:03:00 Air and Exhaust Systems 00:08:00 Cooling Water System 00:07:00 Cylinder Sleeve 00:05:00 Electrical System Part 1 00:06:00 Electrical System Part 2 00:07:00 Final Thoughts 00:02:00 Resources Resources - The Basics of Internal Combustion Engines 00:00:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00
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
Resume Writing - Your Ultimate Step-by-Step Resume Guide
By iStudy UK
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
