4154 Computing courses in Cardiff delivered On Demand

Introduction Introduction 00:02:00 Geometry Lines and Angles (Basics) 00:07:00 Parallel lines (Basics) 00:06:00 Practice Problems 1 (Lines and Angles) 00:06:00 Triangles (Basics) 00:11:00 Practice Problems 2 (angle sum and exterior angle Property) 00:10:00 Pythagoras Theorem 00:13:00 Inequalities in Triangles 00:06:00 Sine and Cosine Rule 00:12:00 Median, Altitude, Angle bisector 00:06:00 Practice Problems 3 00:11:00 Properties of Medians 00:09:00 Practice Problems 4 00:07:00 Properties of Equilateral Triangles 00:04:00 Some special Quadrilaterals 00:08:00 Polygons-interior angles, diagonals etc. 00:08:00 Angle Bisector Theorem 00:07:00 Congruent Triangles 00:06:00 Similar Triangles 00:14:00 Practice Problems 5 00:10:00 Circle 00:10:00 Cyclic Quadrilateral _ Tangent to circle 00:07:00 Areas Areas of Parallelogram & Triangle 1 00:10:00 Areas of Parallelogram _ Triangle 2 00:10:00 Practice Problems based on Areas 1 00:05:00 Practice Problems based on Areas 2 00:12:00 Mensuration of 2 dimensional figures Mensuration Formulae 00:07:00 Practice problems on 2-d figures 00:11:00 Assignment (Video) on 2 - d figure 00:02:00 Areas related to the circle 00:05:00 Practice questions on areas related to circle 00:10:00 Practice Test (Check your knowledge of Geometry) Practice Test (Geometry) 00:02:00 Concept of Unit Digit Lecture 32 What is Unit Digit? 00:40:00 How to find unit digit of numbers with exponents 00:10:00 Practice Problems based on Unit Digit 00:08:00 Simplification Problems-1 Simplifications based on Percentages 00:11:00 Simplification based on Exponents 00:12:00 Fastest method of finding square roots 00:12:00 Fastest method of finding cube roots 00:03:00 Simplification based on square and cube roots 00:16:00 Lecture 40 Simplification Problems 00:50:00 Crack Simplification problems-2 Lecture 41 Simplification problems Type 1 00:10:00 Simplification problems Type 1 00:08:00 Simplification problems Type 2 00:08:00 Simplification problems Type 3 00:08:00 Simplification problems Type 4 00:07:00 Finding smallest and greatest from difficult exponents 00:08:00 Simplification using Digital sum What is Digital sum 00:05:00 Lecture 44 What is Digital sum? 00:10:00 How to apply Digital sum technique in different operations 00:14:00 Simplification problems using Digital sum -1 00:07:00 Simplification problems using Digital sum -2 00:06:00 Time and Work Lecture 49 Simplification problems using Digital sum -2 00:06:00 Lecture 50 Resources download 1 00:55:00 Problems based on persons, days, work and hours 00:12:00 Short cut formulas for most common problems 00:11:00 Problems based on Two Persons 00:06:00 Problems based on three Persons 00:10:00 Based on Efficiency 00:13:00 Complex problems on Efficiency 00:10:00 Fraction of work 00:07:00 Leaving and Joining - 1 00:06:00 Men, women and boys 00:05:00 Work and wages 00:11:00 Pipes and Cisterns Lecture 62 Resources download 1 00:25:00 Basics of pipes and cisterns 00:06:00 Pipes and cisterns - Type 1 00:07:00 Pipes and cisterns - Type 2 00:04:00 Pipes and cisterns - Type 3 00:07:00 Pipes and cisterns - Type 4 00:06:00 Pipes and cisterns - Type5 00:05:00 Speed , Distance and Time Lecture 69 Speed, Distance and Time Resources download 00:40:00 Basic Concepts and simple problems 00:10:00 Problems based on average speed 00:07:00 Problems of finding Distance 00:13:00 Practice Problems 1 00:10:00 Practice Problems 2 00:08:00 Practice Problems 3 00:07:00 Boats and Streams Lecture 76 Boats and Streams 00:30:00 Basics of Boats and streams 00:10:00 Finding speed of boat or stream 00:13:00 Problems based on finding Distance 00:06:00 Latest Problems on Boat and cisterns 00:11:00 Percentage Percentage Basics 1 00:10:00 Percentage Basics 2 00:04:00 Fractional Values of Percentages 00:09:00 Lecture 84 Simplification using fractional values of Percentages-1 00:06:00 Simplification problems of Percentage 2 00:05:00 Lecture 86 Article for Resources 00:30:00 Word Problems Lecture 87 Problems based on Marks in examination 00:15:00 Problems based on Price and Quantity 1 00:08:00 Problems based on Price and Quantity 2 00:08:00 Lecture 90 Word problems based on Income 00:08:00 Lecture 91 Resources for the section 'Word Problems' 00:35:00

Overview Boost your functional math skills to progress in work, education and life. This Functional Skills Maths Course will guide you in every possible way to gain confidence and fluency in maths.  The Functional Skills Maths Training includes various training modules to develop your math skills. Throughout this training, you'll learn about integers and the methods for adding, subtracting, multiplying and dividing integers. The course will also discuss factors and multiples, fractions, ratios and proportions, etc. By the end of the program, you'll have the expertise to get instant solutions to various math problems.  Learning Outcomes Know the various operations on integers Expand your knowledge of factors and multiples Understand how to solve various math equations using the BODMAS rule Become efficient in applying basic operations involving decimals Know about the unitary method and its application Why You Should Choose Functional Skills Maths Training Course Lifetime access to the course No hidden fees or exam charges CPD Qualification Standards 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? The Functional Skills Maths Training is for anyone interested in improving their functional maths skills to live independently. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our Functional Skills Maths Course is fully compatible with any kind of device. Whether you are using a Windows computer, Mac, smartphone or tablet, 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 This course will provide you with the necessary knowledge and skills required to succeed in this sector. You will be ready to enter the relevant job market after completing this course. On top of that, the course will enhance your ability to earn an average salary of £52,500 annually.  Functional Skills Maths Training Integers ( Directed Numbers) Lecture 1 Introduction FREE 00:00:00 Lecture 2 Quick glance at number system FREE 00:05:00 Lecture 3 Integers and ordering of integers 00:06:00 Lecture 4 Addition and Subtractions of Integers 00:07:00 Lecture 5 Operations on Integers 00:04:00 Lecture 6 Multiplication and Division of Integers 00:04:00 Lecture 7 Powers of Integers (Exponents) 00:04:00 Factors and Multiples Lecture 8 Complete knowledge about factors and multiples 00:06:00 Lecture 9 Divisibility tests for 2,3,4,5,6 00:07:00 Lecture 10 Divisibility rules 7,8,9,10,11 00:06:00 Lecture 11 Prime Factorization 00:06:00 Lecture 12 Highest Common Factor HCF 00:10:00 Lecture 13 Least Common Multiple LCM FREE 00:16:00 Lecture 14 Relation between LCM and HCF 00:04:00 Fractions Lecture 15 Classification of Fractions 00:04:00 Lecture 16 Convert mixed to improper and improper to mixed fractions 00:03:00 Lecture 17 Equivalent Fractions 00:04:00 Lecture 18 Comparing Fractions after converting to like fractions 00:09:00 Lecture 19 Reducing a fraction to lowest term 00:03:00 Lecture 20 Addition and subtraction OF fractions 00:08:00 Lecture 21 Multiplication and division of fractions 00:11:00 Lecture 22 Word problems on fractions 00:16:00 Simplification Rule : BODMAS Lecture 23 BODMAS and rules to remove brackets 00:03:00 Lecture 24 Simplify expressions using BODMAS rules 00:05:00 Lecture 25 Simplify expressions involving fractions using BODMAS 00:07:00 Decimal numbers Lecture 26 Decimal numbers in relation to fractions 00:08:00 Lecture 27 Like and unlike Decimals 00:05:00 Lecture 28 Ordering of Decimal numbers 00:10:00 Lecture 29 Addition and subtraction of Decimal 00:07:00 Lecture 30 Multiplication of Decimal 00:03:00 Lecture 31 Division of Decimal 00:00:00 Rational Numbers Lecture 32 Rational number 00:02:00 Lecture 33 Representation of Rational Numbers on Number line 00:04:00 Lecture 34 Determining which fraction is terminating or non terminating 00:05:00 Lecture 35 shortcut method of writing decimal expansion of fraction to decimal 00:08:00 Approximation Lecture 36 Rounding to whole number 00:06:00 Lecture 37 Rounding to required number of decimals (1 d.p. ) 00:05:00 Lecture 38 rounding to significant digits 00:07:00 Lecture 39 Practice question on three methods of approximation 00:05:00 Estimation and Scientific Notation or Standard form Lecture 40 Estimation 00:05:00 Lecture 41 Scientific Notation 00:07:00 Lecture 42 Operation on numbers when they are in scientific notation 00:06:00 Percentage Lecture 43 Percentage to fraction and fraction to percentage 00:06:00 Lecture 44 Percentage of a quantity and conversation to decimal 00:05:00 Lecture 45 Expressing one quantity as percentage of another quantity 00:06:00 Lecture 46 Finding increase decrease percent 00:05:00 Lecture 47 Uses of percentages-Word Problems 00:09:00 Ratio and Proportion Lecture 48 Ratio- How to express as simple ratio 00:09:00 Lecture 49 How to compare Ratios 00:04:00 Lecture 50 Word problems on finding ratios FREE 00:07:00 Lecture 51 To divide a given quantity into a given Ratio 00:11:00 Lecture 52 Proportion 00:04:00 Lecture 53 Practice problems on Proportion 00:00:00 Lecture 54 Continued proportion 00:06:00 Unitary Method and its Applications Lecture 55 Direct Variation ( or proportion) 00:04:00 Lecture 56 Problems based on Direct proportion 00:10:00 Lecture 57 Inverse Variation ( or proportion) 00:10:00 Lecture 58 Multiple Ratios 00:10:00 Profit , Loss, discount and Tax Lecture 59 Basics - Profit and Loss 00:04:00 Lecture 60 More practice problems on Profit & Loss 00:06:00 Lecture 61 Selling price formula and Problems 00:04:00 Lecture 62 Cost price formula and Problems 00:03:00 Lecture 63 Higher problems on Profit and Loss 00:08:00 Lecture 64 Basics - Discount 00:05:00 Lecture 65 Practice problems on Discount 00:04:00 Lecture 66 Tax 00:06:00 Resources Resources - Functional Skills Maths Training 00:00:00

Want to master basic algebra? Engineering, physics, pharmaceuticals and many other industries require excellent numerical skills, so it's important to know your algebra if you want to work in these fields. This Build Your Algebra Fundamentals (New version) Course will help you gain fundamental practical skills and help you reach a higher level of learning, whether you're a student or professional. This essential algebra course will train you to develop your critical thinking skills, so you can become a master at problem-solving and logical reasoning. Even if you have little or no knowledge of the subject, in just a few hours, you'll be able to tackle more advanced algebra equations and simplify equations with ease. You'll explore all levels of algebra, including common algebraic terminology, and will get the chance to tackle beginner and advanced problems. On course completion, you'll have the confidence to solve simple and more complex algebraic equations, with the ability to apply your newfound skills in the workplace. Highlights of this Build Your Algebra Fundamentals (New version) Course Familiarise with basic algebraic expressions and concepts Learn how to multiply and divide algebraic expressions Understand how to expand and simplify brackets Solve linear equations and inequalities with ease Expand your knowledge of algebraic identities Get an overview of polynomials in abstract algebra Familiarise with the coordinate plane and the axis of symmetry What you'll learn Higher Indices - Laws of Indices (Exponent) Formula - Change the subject of formula Rational Expressions - Simplification of Algebraic Fractions to its lowest form BODMAS - Adding and removing brackets in algebraic expressions Graphs - Coordinate Axis, Points and Line Graph Linear equations in one variable and word problems Linear Inequalities Simultaneous linear equations- Graphical method, Substitution method, Equating coefficient & cross multiplication method Graphical method of solving simultaneous linear equations Word problems with the help of simultaneous linear equations Quadratic equations using Factorization method and Quadratic Formula Quadratic equations using squaring complete method Equations reducible to quadratic equations Word problems of Quadratic equations Quadratic polynomials Knowledge of nature of roots of quadratic equations Zeros of polynomials α, β & γ Addition, Subtraction,Multiplication and Division of Algebraic Expressions Remainder Theorem & Factor Theorem Directed Numbers (Integers) Finding Numerical Value of Algebraic Expressions Factorization Techniques like common factors, regrouping , splitting the middle term and using identities Algebraic Identities like ( a - b ) ² , ( a + b ) ³ , a ³ - b ³ , ( a + b + c ) ² etc Requirements Knowledge of Mathematics till 5th grade Introduction Lecture 1 Introduction FREE 00:03:00 Fundamental concepts on Algebraic Expressions Lecture 2 What is Algebra FREE 00:02:00 Lecture 3 Simple Equations 00:05:00 Lecture 4 What are Polynomials 00:04:00 Lecture 5 Terms in Polynomials 00:03:00 Lecture 6 Degree of Polynomials 00:05:00 Lecture 7 Writing statements to algebraic form 00:04:00 Operations on Algebraic Expressions Lecture 8 Integers and common mistakes in solving integers 00:13:00 Lecture 9 Arrangement of Terms 00:07:00 Lecture 10 Powers on integers 00:04:00 Lecture11 Simplification using BODMAS 00:08:00 Lecture 12 Distributive Properties in Polynomials 00:04:00 Lecture 13 Simplify Polynomials 00:10:00 Lecture 14 Additions of Polynomials 00:06:00 Lecture 15 Subtractions of Polynomials 00:10:00 Indices ( Exponents) Lecture 16 The rules of Indices in algebra 00:11:00 Lecture 17 Fractional indices 00:10:00 Lecture 18 Understanding indices (practice questions) 00:07:00 Lecture 19 Problems from IGCSE Last year papers 00:09:00 Multiplication and Division of Algebraic expressions Lecture 20 Multiplication of monomial to Polynomial 00:09:00 Lecture 21 Multiplication of Polynomial by Polynomial 00:06:00 Lecture 22 Division of algebraic expression by a monomial 00:08:00 Lecture 23 Division of algebraic expression by another polynomial 00:09:00 Lecture 24 Division of a polynomial by another polynomial with remainder 00:11:00 Brackets in Algebra Lecture 25 Rules of brackets 00:04:00 Lecture 26 Simplification by removing brackets 00:11:00 Linear equations in one variable Lecture 27 Simplification of algebraic fractions 00:07:00 Lecture 28 Rules to solve linear equations in one variable 00:03:00 Lecture 29 Solving linear equations in one variable 00:07:00 Lecture 30 Solving complex linear equations in one variable 00:10:00 Lecture 31 Word problems on linear equations in one variable 00:13:00 Algebraic Identities Lecture 32 What are Identities? 00:05:00 Lecture 33 Identity ( a + b ) ² 00:13:00 Lecture 34 Identity ( a - b ) ² new 00:07:00 Lecture 35 Identity a² - b² = (a-b) (a +b ) new 00:07:00 Lecture 36 -- Standard Identities ( a + b + c ) ² = a ² + b ² + c ² + 2 a b + 2 a c +2 b c old 00:07:00 Lecture 37 Identity (x + a) (x + b) Identity Derivation & Application new 00:08:00 Lecture 38 Pascal's Triangle _ Identity ( a + b ) ³ new 00:07:00 Lecture 39 Identities( a - b ) ³, ( a ³ + b ³) and (a ³ - b ³) new 00:13:00 Lecture 40 - Standard Identities a ³ + b ³ + c ³ - 3 a b c 00:10:00 Formula : Change of subject of formula Lecture 41 -Changing the subject of formula 00:08:00 Linear Inequalities Lecture 42 - Linear Inequalities 00:12:00 Resolve into factors Lecture 43 - Factorization by taking out common factor 00:10:00 Lecture 44 - Factorization by grouping the terms 00:09:00 Lecture 45 - factorize using identity a ² - b ² 00:07:00 Lecture 46 - factorize using identity (a + b )² and (a - b )² (2) 00:08:00 Lecture 47 - factorize using identity ( a + b + c ) ² 00:05:00 Lecture 48 - factorization by middle term split 00:12:00 Algebraic Fractions Lecture 49 -Simplification of algebraic fractions 00:06:00 Coordinate axis - points and Line graph Lecture 50 All that you need to know about co ordinate axis 00:04:00 Lecture 51 Some important facts needed to draw line graph 00:03:00 Lecture 52 - How to draw a line graph on coordinate plane 00:03:00 Lecture 53 Drawing line graphs 00:06:00 System of simultaneous linear equations in two variables Lecture 54 Simultaneous Linear Equations in two variables- intro 00:03:00 Lecture 55 Graphical method of solving linear equations 00:06:00 Lecture 56 Graphical method - more problems 00:10:00 Lecture 57 Method of Elimination by substitution 00:09:00 Lecture 58 Method of Elimination by Equating coefficients 00:11:00 Lecture 59 Method of Elimination by cross multiplication 00:07:00 Lecture 60 Equations reducible to simultaneous linear equations 00:12:00 Lecture 61 Word Problems on Linear equations 00:18:00 Polynomials Lecture 62 Polynomials and Zeros of polynomials 00:10:00 Lecture 63 Remainder Theorem 00:04:00 Lecture 64 Factor Theorem 00:08:00 Lecture 65 Practice problems on Remainder and Factor Theorem 00:09:00 Lecture 66 Factorization using factor Theorem 00:10:00 Quadratic Polynomials Lecture 67 Zeros of polynomials α, β & γ 00:10:00 Lecture 68 Relation between zeros and coefficients of a polynomials 00:13:00 Lecture 69 Finding polynomials if zeros are known 00:06:00 Lecture 70 Practice problems on zeros of polynomials 00:10:00 Lecture 71Problems solving with α and β (part 1) 00:11:00 Lecture 72 Problems solving with α and β (part 2) 00:10:00 Quadratic Equations Lecture73 what are Quadratic equations 00:03:00 Lecture 74 Solutions by factorization method 00:12:00 Lecture 75 Solutions by completing square formula 00:06:00 Lecture 76 Deriving Quadratic formula 00:05:00 Lecture 77 Practice problems by Quadratic formula 00:07:00 Lecture 78 Solving complex quadratic equations by Quadratic Formula 00:11:00 Lecture 79 Solutions of reducible to Quadratic Formula 00:09:00 Lecture 80 Skilled problems on Quadratic Equations 00:07:00 Lecture 81 Exponential problems reducible to Quadratic Equations 00:06:00 Lecture 82 Nature of Roots of Quadratic Equations 00:09:00 Lecture 83 Word problems on quadratic Equations Part 1 00:13:00 Lecture 84 Word problems on quadratic Equations Part 2 00:11:00

Want to get rid of the burden of heavy calculations? On the off chance that you have ever been keen on speeding up your Mathematics multiple times quicker with Vedic Math, Mental Math tricks and shortcuts for GMAT, Olympiad, then Best Techniques To Speed Up Your Mathematics will be the best opportunity for you. Through this course, you will receive lots of tips and tricks which will become a component of your calculations. Besides, numerous know-how of Vedic Mathematics also covered in this course which can easily apply in today's Math. By the time you complete this course, you will be set to perform large calculations and enhanced your Mathematics skills. To sum up, this course will be remarkably helpful for individuals who have interest in doing complicated multiplication in less time. What Will I Learn? Apply ' Digital Sum' technique of vedic Mathematics to find right options in multiple choice questions with in a few seconds. Short cuts for 'Time & Work' explained in 11 lectures with lots of practice problems. Find day of the week when any old or coming date is given without counting odd days and leap years Count number of squares , rectangles and triangles with the help of short cut tricks Find answer in 2 seconds of simplification problems like 1/6 +1/12+1/20+1/30+1/42+1/50+1/72+1/90+1/110+1/132 Apply short cuts to solve fraction series like 3/1²×2² + 5/ 2²×3² + 7/ 3²×4² +.............19/9²×10² Simplify in 2 seconds problems like ( 1 - 1/3 ) ( 1 - 1/4 ) ( 1 - 1/5 ) ( 1 - 1/6) ........ ( 1 - 1/50 ) Find the solution of complicated repeated square root problems like √5(√5(√5(√5))) in two seconds Squaring any two digit numbers,decimal and non decimal with the help of vedic math technique Squaring any three digit numbers,decimal and non decimal with the help of vedic math technique Able to find square root of any digit number which are not perfect square easily with a special short trick Able to find cube root of any digit number which are not perfect cube easily with a special short trick With Vedic Maths techniques, Multiplying any digit number by 9 ; 99 ; 999 ; 9999999 etc faster than calculator like 47356 × 99999 and 345 × 99999 Multiplying two numbers of any digit in a single line with the help of very fast technique of Vedic mathematics 'Vertically and Crosswise' Multiply any two digit number or any big number by 11,22 and 33 in brain faster than the calculator . Learn how to find remainder when any big digit number is divided by 9 without actually dividing , faster than calculator With Vedic Maths techniques, Multiplying two large numbers of same digits below the base 1000 ;10000 ;100000 etc in 2 seconds like 996 ×995, 9991 × 9992 Multiplying two numbers of same digits above the base 1000 ;10000 ;100000 etc in 2 seconds like 105 ×106 , 1003 × 1007, 100001 × 100006 Multiplication of numbers one above the base and the other less than the base like 1 0 5 × 9 4 ; 1 0 02 × 996 etc in 2 seconds Multiplying any digit number by 5 , 25 and 125 very fast within 2 seconds. Squaring numbers that end in 5 faster than calculator Requirements Knowledge of mathematics up to fifth grade Knowledge of the Times Tables up to 9 A pen/ pencil and paper Who is the target audience? GMAT, GRE, CAT, Maths Olympiad, Banking Exams and University entrance exams students looking to increase calculation power with the help of Vedic Maths Shortcuts Whoever wants to learn to do calculations without calculator Whoever wants to increase Math power, skill and get rid of fear of Maths School students want to learn short tricks , wants to increase concentration Middle school and High school students want to do calculations many times faster Introduction Lecture 1 Introduction.mp4 FREE 00:02:00 Section 2 Lecture 2 Multiplying any digit number by 11, 22, and 33 00:09:00 Section 3 Lecture 3 Finding remainder when a number of any digits is divided by 9.mp4 00:04:00 Section 4 Lecture 4 Multiplying any digit number by series of 9; 99; 999; 99999 Part 1.mp4.TS 00:08:00 Lecture 5 Multiplying any digit number by series of 9; 99 ; 999 ; 99999 Part 2.mp4 00:07:00 Section 5 Lecture 6 Product of two numbers below the base number 100; 1000 etc.mp4 00:08:00 Lecture 7 Multiplication of Numbers above the base 1000; 10000; 100000 etc.mp4 00:08:00 Lecture 8 Multiplication of numbers one above the base and second less than the base.mp4 00:06:00 Section 6 Lecture 9 multiplying any two digit numbers using Vertically and Crosswise.mp4 00:04:00 Lecture 10 Multiplying three digit numbers using Vertically and Crosswise.mp4 00:05:00 Section 7 Lecture 11 Multiplying any digit number by 5, 25, and 125 faster than calculator.mp4 00:07:00 Section 8 Lecture 12 Squaring numbers that end in 5 using Vedic Math.mp4.TS 00:04:00 Lecture 13 Squaring two digit numbers mentally Using Vedic Math technique.mp4 00:06:00 Lecture 14 Squaring three digit numbers mentally Using Vedic Math technique.mp4 00:05:00 Section 9 Lecture 15 Finding cube of any two digit number faster than calculator.mp4 00:10:00 Section 10 Lecture 16 Approximate value of square root of numbers which are not perfect squares.mp4 00:09:00 Lecture 17 Approximate value of cube root of numbers which are not perfect cubes.mp4 00:05:00 Section 11 Lecture 18 Short tricks to count Number of Squares in given figure.mp4 00:05:00 Lecture 19 Short tricks to count Number of Rectangles in given figure.mp4 00:03:00 Lecture 20 Short tricks to count Number of triangles in given figure.mp4.TS 00:04:00 Section 12 Lecture 21 Finding Day of the week when any date is given in 2 Seconds mentally.mp4 00:12:00 Simplify calculations super fast Lecture 22 Digital sum of a number.mp4 00:04:00 Lecture 23 Digital sum- Addition and Subtraction.mp4 00:10:00 Lecture 24 Digital sums- Multiplication.mp4 00:07:00 Lecture 25 Digital sum- divisions.mp4 00:08:00 Simplification short cuts for complicated fractions and square root problems Lecture 26 Simplification short tricks for complicated fractions.mp4 00:10:00 Lecture 27 Simplification short tricks for fractions series part 1.mp4 00:07:00 Lecture 28 Simplification short tricks for fractions series part 2.mp4 00:05:00 Lecture 29 Simplification short tricks for complicated square root problems.mp4 00:09:00

Description This course is aimed at the excel user who already knows the basics of Excel 2007. This course will help you to go beyond the basics - to reach a higher-intermediate level. With shortcuts, tricks and tips - you will be able to work smarter and faster. If you want to be fairly competent on the software, then this course will be very handy. Its a lot quicker to be shown things, then to try and muddle through and work things out by yourself. Guaranteed, there'll be some items which we cover, that you have no idea that Excel was capable of doing! We don't want you to spend a day of your life in the classroom... learn 99 quick and very useful, practical things which you can apply on your job or on your projects. We'll cover: Working with Data - using series, symbols and special characters, hide rows and freeze panels Formulas and Functions - Calculate the duration between two dates/times, best loan terms, create conditional formula and conditional sums Copying Data - transposing rows into columns and paste specials Using Excel lists - sort and filter a list, remove duplicate records, count filtered records, look up information in a list Data Patterns - Pivot tables, pivot charts, what-if analysis Creating charts - histogram, trendlines, piecharts, error bars Presenting data - formatting columns and numbers Saving and printing worksheets - printing multiple worksheets, area, cell ranges, repeat headings of a row or column Extending excel - hyperlinks, embed a chart, importing a worksheet Customizing Excel - custom workspace, custom view, macros The target audience is those who have a basic level with Excel and want to learn other handy functions and features. We use Excel 2007 only in this course. If you have Excel 2003, this course will be difficult to follow as although the functions and features exist in 2003, the layout changed very dramatically between the two versions. Excel 2007 isn't too dissimilar from 2010. Where necessary, we provide a spreadsheet - but as long as you have Excel 2007, you'll be able to copy and do exactly what you see on the screen by pausing the video and following along. The course will take approx 7.5 hours to complete. Take this course if you want to take your basic understanding of Excel to a higher intermediate-level. What Will I Learn? Work with Formulas and Functions Copy data and formats Use excel lists Create charts Present worksheets nicely Save and print worksheets Who is the target audience? This is for those who are beginners in Excel and want to take it further to higher intermediate level - using Excel 2007 You should know the 'basics' in Excel and we take it from near-beginner, to higher intermediate Requirements Students will need to have Excel 2007 installed, as this is the system used in the teaching Introduction to the course and your tutor Data Enter numbers and fractions 00:05:00 Dates and Times 00:08:00 Name Cells and Ranges 00:04:00 Validate Data entry using a pick list FREE 00:07:00 Extend a series of dates with autofill 00:04:00 Add a symbol or special character 00:04:00 Compare multiple spreadsheets using freeze panels 00:06:00 Hide rows 00:04:00 Keyboard 00:10:00 Speak Cells 00:04:00 Find and replace data 00:10:00 Formulas and Functions Add values 00:03:00 Function wizard 00:06:00 Formulas with comments 00:04:00 OneNote 00:06:00 Define a constant 00:04:00 Apply names in functions 00:05:00 Figure out the best loan terms 00:04:00 Internal Rates of Return 00:04:00 Nth largest value 00:04:00 Large, Small, Max, Min 00:04:00 Conditional formula 00:03:00 Conditional formula with names 00:04:00 Conditional sum 00:03:00 Count If 00:02:00 Inner calculator 00:02:00 Square Roots 00:03:00 Calculate the duration between two times 00:04:00 Calculate days between two dates 00:04:00 Copying Data, Formats etc., Copy a range 00:03:00 Transpose a row into a column FREE 00:02:00 Chart formatting 00:07:00 Copy styles to another workbook 00:07:00 Paste special and copying worksheets 00:06:00 Track changes while Editing 00:06:00 Lists Enter list data using a form 00:05:00 Searching through a data list 00:04:00 Import a word list into excel 00:04:00 Sort a list 00:02:00 Filter a list 00:02:00 Sort by multiple criteria FREE 00:03:00 Find averages in a sorted group 00:05:00 Filter by multiple criteria 00:03:00 Remove duplicate records from a list 00:03:00 Count filtered records 00:07:00 Filter by multiple criteria in the same column 00:06:00 Chart a filtered list 00:02:00 Look up information in a List 00:05:00 Data Patterns Create a PivotTable 00:05:00 Modify a PivotTable and layout 00:03:00 Find the average of a field 00:04:00 Create a calculated field 00:03:00 Calculated fields and charts FREE 00:02:00 Hide rows and columns in a PivotTable 00:02:00 AutoFormat a PivotTable 00:01:00 Create a PivotChart 00:03:00 Turning on the Data Analysis function so that statistical information can be run 00:02:00 Describe Data with Statistics 00:03:00 Discover associations within your data 00:03:00 Product Numbers 00:02:00 What-if analysis 00:05:00 Goal seek 00:06:00 Creating Charts Create a Chart 00:06:00 Modify Chart details 00:04:00 Change the Chart Type 00:03:00 Add a Trendline to a Chart 00:06:00 Remove Chart Data 00:02:00 Add chart data 00:02:00 Missing chart data 00:04:00 Error bars 00:04:00 Pull a slice from a Pie Chart 00:03:00 Label slices of a Pie Chart 00:04:00 Histogram 00:06:00 Paste a chart into Word 00:03:00 Amending a chart in Word 00:02:00 Paste-link a Chart into Word 00:05:00 Worksheets Format Numbers as Percentages 00:04:00 Format Currencies in Currency and Accounting Formats 00:03:00 Format Column Headings 00:05:00 Format Quickly with Format painter FREE 00:02:00 Insert a background image into your worksheet 00:03:00 Create a Transparent image 00:03:00 Saving and Printing Worksheets Save a workbook as a Template 00:07:00 Save a workbook as an XML spreadsheet 00:05:00 Print multiple cell ranges on One Page 00:03:00 Print multiple worksheets of a workbook 00:01:00 Page set up, header, footer, margins - 1 page printing 00:04:00 Repeat Headings of a Row or Column 00:07:00 Print functions to show calculations & comments 00:07:00 Extending Excel Hyperlink a worksheet to another office document 00:03:00 Embed a chart within PowerPoint 00:05:00 Publish an Interactive Workbook 00:05:00 Import a Worksheet into Access 00:09:00 Use Excel Data to create labels in Word 00:10:00 Customizing Excel Launch a specific Workbook when Excel Opens 00:03:00 Save Time by Creating a Custom View 00:03:00 Create a Custom Number Format 00:06:00 Changing Text to Columns 00:05:00 Create a Macro to Format Numbers 00:06:00 Online Live Webinar Course-S3_W4_L1 - 42 - Excel Made simple 01:00:00

Course Description The Critical Thinking, Problem Solving and Decision Making: Part 2 course is designed to enhance your problem-solving and decision-making skills through developing critical thinking. In this course, you will learn about the standards and steps of critical thinking. The course will help you to enhance and boost your critical thinking skills. You will also learn about the characteristics and qualities of a critical thinker. This bite-size course will help you to make better decisions and solve problems with critical thinking. Enrol the course now if you want to develop these skills. Learning outcome  Gain knowledge about the standards and steps of critical thinking Enhance your critical thinking skills Learn about the characteristics of a critical thinker Make better decisions with critical thinking How Much Do Managers Earn? Senior - £70,000(Appx.) Average - £46,000(Appx.) Starting - £36,000(Appx.) Requirement Our Critical Thinking, Problem Solving and Decision Making: Part 2 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. Critical Thinking, Problem Solving and Decision Making: Part 2 Module 01: What Are the Critical Thinking Steps 00:17:00 Module 02: Critical Thinking Strategies 00:25:00 Module 03: Recognising a Critical Thinker 00:23:00 Module 04: Decision Making with Critical Thinking 00:26:00 Module 05: Problem-Solving Through Critical Thinking 00:25:00 Assignment Assignment - Critical Thinking, Problem Solving and Decision Making: Part 2 00:00:00

Course Description Enrich your diction making and critical thinking skills with the Critical Thinking and Decision Making: Part 2 course. Here, you will be introduced to the steps of critical thinking. You will acquire the skills to identify a critical thinker. From this course, you will grasp a handful of critical thinking strategies. This Critical Thinking and Decision Making: Part 2 course will show you the techniques of problem-solving through critical thinking. Within no time, you will attain the strategies to use critical thinking during decision-making. Enrol in this course and master the skills of critical thinking. Learning outcome  Familiarise with the steps of critical thinking Acquire the strategies of critical thinking Learn how to solve your problems through critical thinking Understand how to use critical thinking for taking the right decisions How Much Critical Thinkers Earn Senior - £39,000 - £50,000(Appx.) Average - £32,000 - £38,000(Appx.) Starting - £21,000 - £31,000(Appx.) Requirement Our Critical Thinking and Decision Making: Part 2 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. Critical Thinking and Decision Making: Part 2 Module 01: Recognising a Critical Thinker 00:23:00 Module 02: What Are the Critical Thinking Steps 00:17:00 Module 03: Critical Thinking Strategies 00:25:00 Module 04: Problem-Solving Through Critical Thinking 00:25:00 Module 05: Decision Making with Critical Thinking 00:26:00 Assignment Assignment - Critical Thinking and Decision Making: Part 2 00:00:00

Course Description The Critical Thinking, Problem Solving and Decision Making: Part 1 course is designed for you to deepen your skill of problem-solving and decision making through critical thinking. In this course, you will learn what critical thinking is, its types and features. You will understand the importance of critical thinking and its benefits and barriers. In addition, you will learn about the judgment of claims. Enrol the course now if all these sound good to you.  Learning outcome  Learn what critical thinking is, its types and features Understand the importance of critical thinking and its benefits and barriers Explore judgment of claims How Much Do Managers Earn? Senior - £70,000(Appx.) Average - £46,000(Appx.) Starting - £36,000(Appx.) Requirement Our Critical Thinking, Problem Solving and Decision Making: Part 1 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. Critical Thinking, Problem Solving and Decision Making: Part 1 Module 01: Introduction to Critical Thinking 00:23:00 Module 02: Importance of Critical Thinking 00:17:00 Module 03: Benefits and Barriers of Critical Thinking 00:32:00 Module 04: Critical Thinking and the Judgment of Claims 00:19:00 Assignment Assignment - Critical Thinking, Problem Solving and Decision Making: Part 1 00:00:00

Learning Computer Programming has never been so easy! Do you want ot learn codes and create your own software? Get this course to learn about coding and become a Programmer. Learn the different coding languages and have a career in one of the most demanding jobs at this moment in time. A computer programmer creates the code for software applications and operating systems. After a software developer designs a computer program, the programmer writes code that converts that design into a set of instructions a computer can follow. He or she tests the program to look for errors and then rewrites it until it is error-free. The programmer continues to evaluate programs that are in use, making updates and adjustments as needed. This course teaches you all the roles and responsibilities you will take as a computer programmer and how to deal with each one of them. It will also teach you about coding which essential for any prospective computer programmer. Course Highlights Certified Computer Programming Skills Training 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 Certified Computer Programming Skills Training into 33 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, 4 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 Certified Computer Programming Skills Training 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? Certified Computer Programming Skills Training 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 Certified Computer Programming Skills Training 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. Computer Programming at a Glance COMPUTER PROGRAMMING AT A GLANCE 01:00:00 UNDERSTANDING THE LANGUAGE OF THE COMPUTER 00:30:00 Choosing a Language 00:30:00 Basic Programming Language BASIC Programming Language 01:00:00 Getting Started with BASIC Programming Language 01:00:00 BASIC Overview of BASIC Components 01:00:00 BASIC Special Variables 01:00:00 BASIC Probability Functions 01:00:00 Filtering the Data Set or Splitting the Data Set 01:00:00 DATA Blocks 01:00:00 DELETE Statement 01:00:00 FOR...NEXT Statement 01:00:00 IF. . . THEN Statement 01:00:00 PHP Programming Welcome to the world of programming! FREE 00:30:00 Getting Started FREE 01:00:00 Let's Start Coding! 01:00:00 PHP Strings 01:00:00 PHP Variables 01:00:00 Useful Variables 00:30:00 PHP Includes & Problem Solving 01:00:00 Tip When Creating Inc Pages 00:30:00 Redirecting Using PHP 00:30:00 Multiple Conditions 01:00:00 PHP Arrays 01:00:00 PHP Loops 01:00:00 Note on PHP Math Functions: 00:30:00 Functions 01:00:00 PHP Sessions 00:30:00 Cookies 01:00:00 Introduction to MySQL 01:00:00 Making The Connection 01:00:00 Inserting Data 01:00:00 Deleting / Removing Data 00:15:00

If you are looking forward to advance your skills with Microsoft Excel 2016 and want to learn more advanced skills or want to learn the topics covered in this course in the 2016 interface, this Excel 2016 Advanced will be the perfect choice for you! Through the course you will gain the skills necessary to use pivot tables, audit and analyze worksheet data, utilize data tools, collaborate with others, and create and manage macros. Additionally, you 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 your worksheets and workbooks. You will also learn about Excel's many collaboration features, as well as how to import and export data to and from your workbooks. What Will I Learn? Use Advanced IF Statements Use Advanced Lookup Functions Use Complex Logical and Text Functions Auditing Formulas Working with What-If Analysis Tools Protecting Worksheet and Workbook Use Advanced PivotTables and PowerPivot Tools Automate with Macros Work with Form Controls Ensure Data Integrity Collaborate in Excel Import and Export Data to a Text File Requirements Excel Introduction and Intermediate courses or equivalent experience. Who is the target audience? Students who want to expand their Excel knowledge. Introduction Introduction FREE 00:01:00 Using Advanced IF Statements Summarize Data with SUMIF FREE 00:04:00 Summarize Data with AVERAGIF 00:03:00 Summarize Data with COUNTIF 00:02:00 Using Advanced Lookup Functions Using VLOOKUP with TRUE to find an Approximate Match 00:04:00 Using HLOOKUP TRUE to find an Approximate Match 00:01:00 Using the Index Function 00:03:00 Using the Match Function 00:02:00 Creating a Combined Index and Match Formula 00:04:00 Comparing Two Lists with VLOOKUP 00:02:00 Comparing Two Lists with VLOOKUP and ISNA 00:04:00 Using Complex Logical and Text Functions Creating a Nested IF Function 00:03:00 Using the IFERROR Function 00:02:00 Using the LEN Function 00:02:00 Using the TRIM Function 00:01:00 Using the Substitute Function 00:02:00 Formula Auditing Showing Formulas 00:01:00 Tracing Cell Precedents and Dependents 00:03:00 Adding a watch Window 00:02:00 Error Checking 00:02:00 What-If Analysis Tools Using the Scenario Manager 00:03:00 Using Goal Seek 00:02:00 Analyzing with Data Tables 00:02:00 Worksheet and Workbook Protection Protection Overview 00:02:00 Excel File Password Encryption 00:03:00 Allowing Specific Worksheet Changes 00:01:00 Adding Protection to only Certain Cells in a Worksheet 00:03:00 Additional Protection Features 00:02:00 Advanced Use of PivotTables and PowerPivot Using the Pivot Tables Charts Wizard 00:02:00 Adding a Calculated Field 00:02:00 Adding a Caculated Item 00:02:00 Apply Conditional Formatting to a Pivot Table 00:03:00 Using Filters in the Pivot Table Fields Pane 00:02:00 Creating Filter Pages for a Pivot Table 00:01:00 Enabling a Power Pivot Add In 00:04:00 Automating with Macros What are Macros 00:03:00 Displaying the Developer Tab and Enabling Macros in Excel 00:03:00 Creating a Basic Formatting Macro 00:03:00 Running a Macro 00:02:00 Assigning a Macro to a Button 00:02:00 Creating a More Complex Macro 00:02:00 Viewing and Editing the VBA Code for an Existing Macro 00:03:00 Adding a Macro to the Quick Access Toolbar 00:02:00 Working with Form Controls What are Form Controls 00:02:00 Adding Spin Buttons and Check Boxes to a Spreadsheet 00:02:00 Adding a Combo Box to a Spreadsheet 00:02:00 Ensuring Data Integrity What is Data Validation 00:01:00 Restricting Data Entries to Whole Numbers 00:02:00 Data Validation Restricting Data Entry to a List 00:01:00 Data Validation Restricting Data Entry to a Date 00:01:00 Data Validation Restricting Data Entry to Different Text Lengths 00:01:00 Composing Input Messages 00:02:00 Composing Error Alters 00:02:00 Finding Invalid Data 00:02:00 Editing and Deleting Data Validation Rules 00:01:00 Collaborating in Excel Working with Comments 00:03:00 Printing Comments and Errors 00:02:00 Sharing a Workbook 00:03:00 Tracking Changes in a Workbook 00:03:00 Working with Versions 00:02:00 Sharing Files via Email 00:02:00 Importing and Exporting Data to a Text File Importing a Text File 00:03:00 Exporting a Text File 00:01:00 Conclusion Course Recap 00:01:00 Course Certification