4118 Computing courses in Barrow-in-Furness delivered On Demand

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

Overview With the ever-increasing demand for Functional Skills in personal & professional settings, this online training aims at educating, nurturing, and upskilling individuals to stay ahead of the curve - whatever their level of expertise in Functional Skills may be. Learning about Functional Skills or keeping up to date on it can be confusing at times, and maybe even daunting! But that's not the case with this course from Compete High. We understand the different requirements coming with a wide variety of demographics looking to get skilled in Functional Skills . That's why we've developed this online training in a way that caters to learners with different goals in mind. The course materials are prepared with consultation from the experts of this field and all the information on Functional Skills is kept up to date on a regular basis so that learners don't get left behind on the current trends/updates. The self-paced online learning methodology by compete high in this Functional Skills course helps you learn whenever or however you wish, keeping in mind the busy schedule or possible inconveniences that come with physical classes. The easy-to-grasp, bite-sized lessons are proven to be most effective in memorising and learning the lessons by heart. On top of that, you have the opportunity to receive a certificate after successfully completing the course! Instead of searching for hours, enrol right away on this Functional Skills course from Compete High and accelerate your career in the right path with expert-outlined lessons and a guarantee of success in the long run. Who is this course for? While we refrain from discouraging anyone wanting to do this Functional Skills course or impose any sort of restrictions on doing this online training, people meeting any of the following criteria will benefit the most from it: Anyone looking for the basics of Functional Skills , Jobseekers in the relevant domains, Anyone with a ground knowledge/intermediate expertise in Functional Skills , Anyone looking for a certificate of completion on doing an online training on this topic, Students of Functional Skills , or anyone with an academic knowledge gap to bridge, Anyone with a general interest/curiosity Career Path This Functional Skills course smoothens the way up your career ladder with all the relevant information, skills, and online certificate of achievements. After successfully completing the course, you can expect to move one significant step closer to achieving your professional goals - whether it's securing that job you desire, getting the promotion you deserve, or setting up that business of your dreams.    Course Curriculum Functional Skills Maths Level 2 Module 01 Introduction Introduction 00:00 Functional Skills Maths Level 2 Module 2 Basic arithmetic Basic arithmetic 00:00 Functional Skills Maths Level 2 Module 3 Fractions Fractions 00:00 Functional Skills Maths Level 2 Module 4 Decimals Decimals 00:00 Functional Skills Maths Level 2 Module 5 Using a calculator Using a calculator 00:00 Functional Skills Maths Level 2 Module 6 Percentages Percentages 00:00 Functional Skills Maths Level 2 Module 7 Ratio and proportion Ratio and proportion 00:00 Functional Skills Maths Level 2 Module 8 Powers, roots and laws of indices Powers, roots and laws of indices 00:00 Functional Skills Maths Level 2 Module 9 Units, prefixes and engineering notation Units, prefixes and engineering notation 00:00

🌟 Unlock the Full Power of Microsoft Excel 2019! 🌟 Ready to take your Excel skills to the next level? Dive into our comprehensive online course - 'Microsoft Excel 2019 - Advanced Level Training' - designed to transform you into an Excel maestro! 🚀 Here's What You'll Master: 📊 Section 1: Excel - Advanced - Get hands-on with advanced techniques and shortcuts to streamline your workflow. 📂 Section 2: Working with Multiple Workbooks - Seamlessly manage multiple workbooks and boost your productivity effortlessly. 🔒 Section 3: Protecting Worksheets and Workbooks - Learn how to safeguard your data with robust protection strategies. 📝 Section 4: Conditional Formulas - Unravel the power of conditional logic and unleash the true potential of formulas. 🧮 Section 5: Advanced Functions - Elevate your Excel expertise by mastering complex functions for data analysis. 📚 Section 6: Text Based Functions - Manipulate text effortlessly and efficiently with advanced text-based functions. 🔍 Section 7: What IF Tools - Explore the 'What If' analysis tools to make informed decisions and predictions. 🏁 Section 8: Excel Advanced - Conclusion - Wrap up with a comprehensive understanding and practical application of advanced Excel features. 🎁 Section 9: Bonus #1 - Advanced Pivot Tables - Delve into bonus content covering advanced techniques for Pivot Tables, a must-have skill for data analysis pros. 🌟 Why Choose Our Course? 🔐 Expert Guidance: Led by seasoned Excel professionals, ensuring clarity and depth in learning. 🔄 Practical Assignments: Apply your newfound skills through real-world exercises. 📈 Career Growth: Elevate your career prospects by mastering sought-after Excel abilities. 🌐 Accessible Learning: Study at your own pace from anywhere, anytime with our user-friendly online platform. 🤝 Join our vibrant community of learners dedicated to mastering Excel's advanced functionalities. 💡 Enroll now and revolutionize your Excel prowess with 'Microsoft Excel 2019 - Advanced Level Training'! Don't miss this chance to become an Excel wizard! 💡   Course Curriculum Section 1 - Excel - Advanced Excel Advanced Introduction 01:39 Advanced Shortcut Keys 02:58 Section 2 - Working with Multiple Workbooks Tracing Precedents 00:00 Tracing Dependants 00:00 Watch Window 00:00 Show Formulas 00:00 Section 3 - Protecting Worksheets and Workbooks Protecting Cells in a Worksheet 00:00 Protecting the Workbook Structure 00:00 Encryption with Passwords 00:00 Section 4 - Conditional Formulas Name Ranges 00:00 Simple IF Function 00:00 IF, AND 00:00 IF, OR 00:00 Nested Formulas 00:00 CountIF and CountIFs 00:00 SumIF and SumIFs 00:00 Section 5 - Advanced Functions Advanced VLookUp 00:00 IF and IS Error - Part 1 00:00 IF and IS Error - Part 2 00:00 Advanced Index Match 00:00 Dates - Part 1 00:00 Dates - Part 2 00:00 Replace and Substitute - Part 1 00:00 Replace and Substitute - Part 2 00:00 Section 6 - Text Based Functions Left, Right and Mid Function 00:00 Search Function 00:00 Concatenate and Search 00:00 Indirect - Static 00:00 Indirect - Dynamic 00:00 Section 7 - What IF Tools Goal Seek 00:00 Data Tables 00:00 Scenarios 00:00 Solver 00:00 Section 8 - Excel Advanced - Conclusion Excel Advanced - Conclusion 00:00 Section 9 - Bonus # 1 - Advanced Pivot Tables Building a Mini Dashboard 00: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