2455 Courses delivered On Demand

Discover Excel 2019 and become confident in using spreadsheets

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

Learn Excel for Business Accounting with our comprehensive course. From basic worksheet creation to advanced functions like pivot tables, charts, and data analysis, master Excel's features for efficient accounting tasks. Ideal for business professionals and students looking to enhance their Excel skills for financial management.

Highlights of the Course Course Type: Online Learning Duration: 2 Hours 26 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 Fusion 360 graphic designing Understand the core competencies and principles of Fusion 360 graphic designing Explore the various areas of Fusion 360 graphic designing Know how to apply the skills you acquired from this course in a real-life context Become a confident and expert graphic designer Microsoft Office Excel 2016: Part 2 (Intermediate 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 2016 intermediate level course is designed to help you surpass your professional goals. The skills and knowledge that you will gain through studying this excel 2016 intermediate leve 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 2016 intermediate leve 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 2016 intermediate leve 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 2016 intermediate leve 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 2016 intermediate leve 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 2016 intermediate leve 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 Course Overview Introduction and Course Overview 00:02:00 Working with Functions Working and Function - Introduction 00:01:00 Work with Ranges - Introduction 00:01:00 Name and Edit Ranges 00:05:00 Use Defined Names in a Formula 00:03:00 Locate and Use Specialized Functions 00:05:00 Work with Logical Functions - Introduction (02:13) 00:02:00 IF Function 00:04:00 AND, OR and NOT Function 00:05:00 Combine Functions 00:06:00 Functions Similar to the IF Function 00:05:00 Work with Date and Time Functions - Introduction 00:01:00 TODAY, NOW and DATE Functions 00:03:00 NETWORKDAY, WEEKDAY, WORKDAY and ISOWeeknum Functions 00:05:00 Work with Text Functions - Introduction 00:01:00 LEFT, RIGHT and MID Functions 00:02:00 FIND Function 00:03:00 Text to Columns Feature 00:03:00 CONCATENATE Function 00:03:00 UPPER, LOWER and PROPER Functions 00:02:00 Practice File Working with Functions Practice File Working with Functions 00:00:00 Working with Lists Sort Data - Introduction 00:01:00 Sort Data 00:03:00 Filter Data - Introduction 00:01:00 Filter Data 00:02:00 Query Data with Database Functions 00:01:00 Database Functions 00:03:00 Outline and Subtotal Data - Introduction 00:01:00 Use Subtotals to Summarize Data 00:03:00 Practice File Working with Lists Practice File Working with Lists 00:00:00 Assessment Mock 1 Assessment Mock 1 - Microsoft Office Excel 2016: Part 2 (Intermediate Level) 00:10:00 Analyzing Data Create and Modify Tables - Introduction 00:01:00 Create and Modify Tables 00:06:00 Use Summary Functions in Tables 00:03:00 Apply Intermediate Conditional Formatting - Introduction 00:01:00 Apply Intermediate Conditional Formatting 00:02:00 Apply Advanced Conditional Formatting - Introduction 00:01:00 Use Logical Functions to Apply Conditional Formatting 00:03:00 Practice File Analyzing Data Practice File Analyzing Data 00:00:00 Visualizing Data with Charts Create Charts - Introductions 00:01:00 Create Charts 00:04:00 Modify and Format Charts - Introduction 00:01:00 Modify and Format Charts 00:05:00 Use Advanced Chart Features - Introduction 00:01:00 Create a Dual-Axis Chart 00:04:00 Create a Chart Template 00:03:00 Visualizing Data with Charts - Best Practice 00:04:00 Practice File Visualizing Data with Charts Practice File Visualizing Data with Charts 00:00:00 Using PivotTables and PivotCharts Create a PivotTable - Introductions 00:01:00 Create a PivotTable 00:04:00 Analyze PivotTable Data - Introduction 00:01:00 Analyze PivotTable Data 00:04:00 Present Data with PivotCharts - Introduction 00:01:00 Present Data with PivotCharts 00:05:00 Filter Data by Using Timelines and Slicers - Introduction 00:01:00 Filter Data by Using Slicers and Timelines 00:04:00 Bonus Lecture 00:01:00 Practice File Using PivotTables and PivotCharts Practice File Using PivotTables and PivotCharts 00:00:00 Assessment Mock 2 Assessment Mock 2 - Microsoft Office Excel 2016: Part 2 (Intermediate Level) 00:10:00 Final Assessment Final Assessment - Microsoft Office Excel 2016: Part 2 (Intermediate 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

A knowledge of Windows PowerShell is a must for IT professionals and this course is a one-stop-shop for gaining this necessary and in-demand skill. This course is designed to take system administrators to an advanced level in PowerShell scripting. You will find ways to automate your daily work using the advantages of PowerShell scripting.

Gain the solid skills and knowledge to kickstart a successful career and learn from the experts with this

  This course is designed to simplify the complexities of Calculus and provide a clear understanding of derivatives for Engineering applications. Through step-by-step explanations and practical examples, you will gain confidence in your ability to compute derivatives and leverage them in engineering scenarios. This Course At A Glance Accredited by CPD UK Learn inverse functions Understand graphs of equations and graphs of functions Know continuous functions Understand limits of sequences Learn limits of functions at infinity Understand one-sided and two-sided limits Know rules of differentiation Understand higher order derivatives Know the chain rule Learn trigonometric functions Know how to increase and decrease functions Learn curve sketching and relative extrima Engineering Calculus Made Simple (Derivatives) Course Overview This extensive course is beneficial for those interested in learning the squeeze theorem, the derivative of sin(x), the derivative of cos(x), and other derivatives. You will discover functions and graphs such as domain and ranges of functions, graphs of equations, and inverse functions. This online course will educate you on limits such as limits of sequences, limits of functions at infinity, one-sided limits, and two-sided limits. You will also have a broad knowledge of integration, including the fundamental theorem of calculus, indefinite integrals, integration by parts, and partial fractions. By the end of the course, you will have deep knowledge of functions and graphs, limits, differentiation, the derivative, and much more. Who should take this course? This comprehensive course is suitable for those who wish to learn functions, limits, the derivative, trig identities, and the squeeze theorem. It is ideal for those who want to advance their career in engineering calculus. Entry Requirement There are no academic entry requirements for this Engineering Calculus Made Simple (Derivatives) course, and it is open to students of all academic backgrounds. However, you are required to have a laptop/desktop/tablet or smartphone and a good internet connection. Assessment Method This engineering calculus made simple (derivatives) 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%. Course Curriculum Introduction Introduction Functions Limits The Derivative Trig Identities The Squeeze Theorem The Derivative of Sin(x) The Derivative of Cos(x) Other Derivatives Assessment Assessment - Engineering Calculus Made Simple (Derivatives) Recognised Accreditation CPD Certification Service 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. CPD certificates are accepted by thousands of professional bodies and government regulators here in the UK and around the world. Many organisations look for employees with CPD requirements, which means, that by doing this course, you would be a potential candidate in your respective field. Certificate of Achievement Certificate of Achievement from Lead Academy After successfully passing the MCQ exam you will be eligible to order your certificate of achievement as proof of your new skill. The certificate of achievement is an official credential that confirms that you successfully finished a course with Lead Academy. Certificate can be obtained in PDF version at a cost of £12, and there is an additional fee to obtain a printed copy certificate which is £35.   FAQs Is CPD a recognised qualification in the UK? CPD is globally recognised by employers, professional organisations and academic intuitions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. CPD-certified certificates are accepted by thousands of professional bodies and government regulators here in the UK and around the world. Are QLS courses recognised? Although QLS courses are not subject to Ofqual regulation, they must adhere to an extremely high level that is set and regulated independently across the globe. A course that has been approved by the Quality Licence Scheme simply indicates that it has been examined and evaluated in terms of quality and fulfils the predetermined quality standards. When will I receive my certificate? For CPD accredited PDF certificate it will take 24 hours, however for the hardcopy CPD certificate takes 5-7 business days and for the Quality License Scheme certificate it will take 7-9 business days. Can I pay by invoice? Yes, you can pay via Invoice or Purchase Order, please contact us at info@lead-academy.org for invoice payment. Can I pay via instalment? Yes, you can pay via instalments at checkout. How to take online classes from home? Our platform provides easy and comfortable access for all learners; all you need is a stable internet connection and a device such as a laptop, desktop PC, tablet, or mobile phone. The learning site is accessible 24/7, allowing you to take the course at your own pace while relaxing in the privacy of your home or workplace. Does age matter in online learning? No, there is no age limit for online learning. Online learning is accessible to people of all ages and requires no age-specific criteria to pursue a course of interest. As opposed to degrees pursued at university, online courses are designed to break the barriers of age limitation that aim to limit the learner's ability to learn new things, diversify their skills, and expand their horizons. When I will get the login details for my course? After successfully purchasing the course, you will receive an email within 24 hours with the login details of your course. Kindly check your inbox, junk or spam folder, or you can contact our client success team via info@lead-academy.org

Description: This Microsoft Office 2007 Excel Advanced - Complete Video Course builds on knowledge gained in the Introduction and Intermediate courses. In Advanced Microsoft Office Excel 2007, you will explore the many data analysis tools available in Excel, such as formula auditing, goal seek, Scenario Manager and subtotals. Additionally, during this course you will use advanced functions, learn how to apply conditional formatting, filter and manage your data lists, create and manipulate PivotTables and PivotCharts and record basic macros. You will also learn to use key advanced financial, logical, text, statistical and math, and lookup functions, audit formulas for errors, analyze data using subtotals, goal seek and the scenario manager, use custom and conditional formatting, manage data with tables, filtering and sorting, create, edit and format PivotTables and PivotCharts, import and export date to and from a workbook, create and use macros. So, by taking this course you will have a complete understanding of the higher functions of Excel. 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 2007 Excel Advanced - 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 2007 Excel Advanced - 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. Advanced Functions Logical Functions FREE 00:08:00 Math and Statistical Functions 00:06:00 Financial Functions 00:03:00 Displaying and Printing Formulas 00:02:00 Lookups and Data Tables Using Lookup Functions 00:03:00 Using MATCH and INDEX 00:01:00 Creating Data Tables 00:03:00 Advanced List Management Validating Cell Entries 00:01:00 Exploring Database Functions 00:01:00 PivotTables and PivotCharts Working with PivotTables 00:04:00 Rearranging PivotTables 00:02:00 Formatting PivotTables 00:02:00 PivotCharts 00:01:00 Exporting and Importing Exporting and Importing Text Files 00:07:00 Exporting and Importing XML Data 00:02:00 Querying External Databases 00:03:00 Analytical Options Goal Seek and Solver 00:05:00 The Analysis ToolPak 00:01:00 Scenarios 00:02:00 Views 00:01:00 Macros and Custom Functions Running and Recording a Macro 00:02:00 Working with VBA Code 00:01:00 Creating Functions 00:05:00 Conditional Formatting and SmartArt Conditional Formatting with Graphics 00:03:00 SmartArt Graphics 00:02:00 Mock Exam Mock Exam- Microsoft Office 2007 Excel Advanced - Complete Video Course 00:20:00 Final Exam Final Exam- Microsoft Office 2007 Excel Advanced - Complete Video Course 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

You do not need any lectures regarding the importance of Maths and English, do you? To suffice, one is the language of science, and the other is the international language. Unfortunately, we often struggle in both, thanks to the lack of a solid base. Our Learning Maths & English GCSE bundle can give you a firm foundation or help you to pass your GCSE exam with flying colours! This Learning Maths & English GCSE bundle consists of 12 individual courses. This bundle can be primarily divided into two parts. The first part, consisting of six courses, covers fundamentals and advanced mathematics. You will learn the basic concepts of Algebra, high school maths, as well as advanced maths and calculus. The other six courses deal with English language essentials. You will gain an understanding of GCSE English, TESOL, spelling, punctuation, and basics of grammar etc. Moreover, you will learn 200 common English idioms and phrases along with essay writing in English. Be the master of numbers and letters, then? Enrol immediately in this Learning Maths & English GCSE and firm your base. Happy learning! Along with this Learning Maths & English GCSE Course - CPD Accredited course, you will get 11 premium courses, an originalhardcopy, 12 PDF certificates (Main Course + Additional Courses) Student ID card as gifts. This Learning Maths & English GCSE Course - CPD Accredited Bundle Consists of the following Premium courses: Course 01: Functional Skills Maths Level 2 Course 02: Mathematics Fundamentals Course 03: Algebra Fundamentals Course 04: Calculus Level 1 - Learn Differentiation Course 05: Advanced Mathematics Course 06: High School Math Course 07: GCSE English Course 08: Diploma in TEFL/TESOL Course 09: Functional Skills: English Course 10: English Spelling, Punctuation, and Grammar Basic Course Course 11: 200 Common English Idioms and Phrases Course 12: Essay Writing in English Learning Outcome Upon completion of this Learning Maths & English GCSE bundle, you will be able to - Learn about major mathematical concepts such as Decimal numbers, Rational Numbers, Approximation etc Understand the BODMAS Simplification Rule Consolidate your understanding of fundamental mathematics Learn differential calculus Understand advanced mathematical ideas such as Matrices, Trigonometric Functions and Trigonometric Functions Comprehend the rudiments of English Grasp sentence structure, verb usage, capitalisation and punctuation rules in detail Learn 200 common English idioms and phrases Enrol now in Learning Maths & English GCSE Course - CPD Accredited to advance your career, and use the premium study materials from Apex Learning. Curriculum of the Bundle Course 01: Functional Skills Maths Level 2 Module 1: Numbers and Negative Numbers Module 2: Multiples Factors Module 3: Fractions and Power Module 4: Percentages Module 5: Expressions Module 6: Decimals Module 7: Ratio and Proportion Module 8: Exponents and Radicals Module 9: Graphs Module 10: The Profit and Loss Module 11: Perimeter and Area Module 12: Averages Module 13: Probability Course 02: Mathematics Fundamentals Integers (Directed Numbers) Factors and Multiples Fractions Simplification Rule : BODMAS Decimal numbers Rational Numbers Approximation Estimation and Scientific Notation or Standard form Percentage Ratio and Proportion Unitary Method and its Applications Profit , Loss, discount and Tax Course 03: Algebra Fundamentals Introduction Fundamental concepts on Algebraic Expressions Operations on Algebraic Expressions Indices ( Exponents) Multiplication and Division of Algebraic expressions Brackets in Algebra Linear equations in one variable Algebraic Identities Formula : Change of subject of formula Linear Inequalities Resolve into factors Algebraic Fractions Coordinate axis - points and Line graph System of simultaneous linear equations in two variables Polynomials Quadratic Polynomials Quadratic Equations Course 04: Calculus Level 1 - Learn Differentiation Section 01: Introduction Section 02: Fundamental Rules for Differentiation Section 03: Differentiation of Trigonometric Functions Section 04: Differentiation of Exponential Functions Section 05: Differentiation of Logarithmic Functions Section 06: Revision Section 0on Chain Rule Section 07: Differentiation of inverse Trig Function Section 08: Differentiation of Hyperbolic Trig Functions Section 09: Differentiation of Implicit functions Section 10: Logarithmic Differentiation Section 11: Differentiation of Parametric Functions Section 12: Differentiation of Higher order derivatives Course 05: Advanced Mathematics Unit 01: Introduction Unit 02: Mathematical Logic Unit 03: Matrices Unit 04: Trigonometric Functions Unit 05: Pair of Straight Line Unit 06: Lines & Planes Unit 07: Linear Programming Course 06: High School Math Introduction Functions Quadratic Equations Co-ordinate Geometry Sequence and series Binomial Theorem Differentiation Tangents and Normals Stationary Points & Curve Sketching Second Derivative Test (Maximum & Minimum Points) Simultaneous Linear equations Essential Revision Course 07: GCSE English Module 01: Introduction to GCSE English Module 02: Edexcel English Section A Part 01 Module 03: Edexcel English Section A Part 02 Module 04: Edexcel English Section B Module 05: Edexcel English Section C Module 06: Cambridge English Exercise 1-4 Module 07: Cambridge English Exercise 5 Module 08: Cambridge English Exercise 6 Course 08: Diploma in TEFL/TESOL Module 01: Introduction to English Language Teaching & Learning Module 02: Linguistics Module 03: English Pronunciation Module 04: Teaching Grammar and Vocabulary Module 05: Language Teaching Methodologies Module 06: Teaching Receptive Skills: Reading Module 07: Teaching Productive Skills: Writing Module 08: Teaching Receptive Skills: Listening Module 09: Teaching Productive Skills: Speaking Module 10: Lesson Planning and Creating Materials Module 11: Use of Games and Activities Module 12: Technology in Second Language Teaching & Learning Module 13: Classroom Management and Student Motivation Module 14: Teaching English: Situational Approach Module 15: Professional Development and Employment Course 09: Functional Skills: English Module 1: Introduction to the Course Module 2: Basics of Grammar Module 3: The Basics of Sentence Module 4: Structure of Sentence Module 5: Question Module 6: Punctuation & Capitalisation Module 7: Spelling Module 8: Common Mistakes & Ways to Improve Course 10: English Spelling, Punctuation, and Grammar Basic Course Module 1: Introduction to the Course Module 2: The Basics of Grammar Module 3: The Basics of Sentence Module 4: Structure of Sentence Module 5: Question Module 6: Punctuation and Capitalisation Module 7: Spelling Module 8: Common Mistakes & Ways to Improve Course 11: 200 Common English Idioms and Phrases Section 01: Introduction Section 02: Idioms and Phrases Unit 1 Section 03: Idioms and Phrases Unit 2 Section 04: Idioms and Phrases Unit 3 Section 05: Idioms and Phrases Unit 4 Section 06: Idioms and Phrases Unit 5 Section 07: Idioms and Phrases Unit 6 Section 08: Idioms and Phrases Unit 7 Section 09: Idioms and Phrases Unit 8 Section 10: Idioms and Phrases Unit 9 Section 11: Idioms and Phrases Unit 10 Course 12: 200 Common English Idioms and Phrases Module 01: Introduction Module 02: The Narrative Essay Module 03: The Narrative Essay / part 2 Module 04: Introduction to the Essay 'Shooting an Elephant' Module 05: A reading of 'Shooting an Elephant' Module 06: Discussion on 'Shooting an Elephant' Module 07: Introduction to 2nd Essay - 'Most Important Day' Module 08: A reading - 'Most Important Day' Module 09: Discussion - 'Most Important Day' Module 10: Prompt for your own Narrative Essay CPD 120 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone from any background can enrol in this Learning Maths & English GCSE Course - CPD Accredited bundle. Requirements This Learning Maths & English GCSE Course - CPD Accredited course has been designed to be fully compatible with tablets and smartphones. Career path Building a solid foundation in maths and English will benefit you in every career prospect. Specifically, This Learning Maths & English GCSE course will lead you to some particular career opportunities, such as; Teacher - £30,000 - £41,000 Annually Private Tutor - £20,00 - £25.00 Annually Finance Manager - £50,000 - £60,000 Annually Certificates Certificate of completion Digital certificate - Included Certificate of completion Hard copy certificate - Included You will get the Hard Copy certificate for the title course (Functional Skills Maths Level 2) absolutely Free! Other Hard Copy certificates are available for £10 each. Please Note: The delivery charge inside the UK is £3.99, and the international students must pay a £9.99 shipping cost.

This hands-on course on SQL starts with the basics, and gradually delves deep into SQL, ensuring a well-rounded learning experience. Practical examples and real-world applications will be at the heart of your learning. No prior experience or specific software installation is necessary. Just bring your enthusiasm to learn and get started.