6154 Computing courses

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

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

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

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

Course Description Take your critical thinking abilities to the next level with the Critical Thinking and Decision Making: Part 1 course. In this course, you will learn the basic principles of critical thinking. You will be able to understand the connection between critical thinking and the judgment of claims. Here, you will achieve the ability to identify the barriers to critical thinking. This Critical Thinking and Decision Making: Part 1 course will help you understand the benefits and importance of critical thinking. Join the course and boost your critical thinking skills.  Learning outcome  Understand the core concept of critical thinking Familiarise with the principles of the judgment of claims Learn about the barriers of critical thinking Know the importance of critical thinking How Much Critical Thinkers Earn Senior - £39,000 - £50,000(Appx.) Average - £32,000 - £38,000(Appx.) Starting - £21,000 - £31,000(Appx.) Requirements Our Critical Thinking 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 and Decision Making: Part 1 Module 01: Introduction to Critical Thinking 00:23:00 Module 02: Critical Thinking and the Judgment of Claims 00:19:00 Module 03: Benefits and Barriers of Critical Thinking 00:32:00 Module 04: Importance of Critical Thinking 00:17:00 Assignment Assignment - Critical Thinking and Decision Making: Part 1 00: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 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

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

🌟 Unlock Your Excel Potential with Microsoft Excel 2019 - Intermediate Level Training! 🌟 Master the art of Excel with our comprehensive online course designed specifically for intermediate learners. Elevate your skills, boost productivity, and excel in spreadsheet management like never before. 📊 Course Curriculum 📊 🔹 Section 1 - Excel - Intermediate: Dive into the intermediate level of Excel functionalities, bridging the gap between basic and advanced techniques. 🔹 Section 2 - Lists: Learn the art of managing data efficiently with lists, organizing information for streamlined analysis and presentation. 🔹 Section 3 - DataBase Functions: Harness the power of database functions, empowering you to manipulate data with ease and precision. 🔹 Section 4 - Data Validation: Ensure data accuracy and integrity by implementing effective data validation techniques, preventing errors in your spreadsheets. 🔹 Section 5 - Importing and Exporting: Master the process of importing and exporting data seamlessly, integrating external information into your Excel sheets effortlessly. 🔹 Section 6 - Creating Basic Charts: Transform data into impactful visuals with basic chart creation, enhancing your ability to communicate insights effectively. 🔹 Section 7 - Pivot Tables: Unlock the potential of pivot tables, harnessing their analytical power to summarize and analyze complex data sets effortlessly. 🔹 Section 8 - Working with Large Data: Navigate and manipulate extensive data sets efficiently, optimizing your workflow with strategies tailored for large-scale information. 🔹 Section 9 - LookUp Functions: Explore lookup functions to search for and retrieve specific data, refining your ability to find information swiftly. 🔹 Section 10 - Advanced Functions: Elevate your Excel proficiency with advanced functions, expanding your capabilities to handle complex calculations and tasks. 🔹 Section 11 - Excel Intermediate - Conclusion: Wrap up your intermediate Excel journey, reinforcing key concepts and preparing you for further advancements. 🎓 Why Choose Our Course? 🎓 🚀 Comprehensive Learning: A structured curriculum tailored to the needs of intermediate Excel users, covering a wide array of functionalities. 👨‍🏫 Expert Guidance: Led by industry experts well-versed in Excel, ensuring a rich learning experience with practical insights. 🤝 Interactive Learning: Engage with interactive exercises and real-life examples, solidifying your understanding through hands-on practice. 📈 Career Growth: Acquire skills highly sought after in the job market, giving you a competitive edge in various professional domains. 🔓 Don't miss this opportunity to take your Excel skills to the next level! Enroll now and unleash your potential with Microsoft Excel 2019 - Intermediate Level Training. 🔓 Course Curriculum Section 1 - Excel - Intermediate Excel Intermediate Introduction 00:00 Intermediate Shortcut Keys 00:00 Section 2 - Lists What are Lists 00:00 Sorting a List 00:00 Sorting - Multiple Criteria 00:00 Custom Sort 00:00 What are Filters 00:00 Format a List as a Table 00:00 Section 3 - DataBase Functions Introduction to DataBase Functions 00:00 DSum Function 00:00 DSum Function - Single Criteria 00:00 DSum Function - Multiple Criteria 00:00 DAverage 00:00 DCount Function 00:00 Subtotal 00:00 Section 4 - Data Validation Data Validation - List 00:00 Data Validation - Decimal 00:00 Input and Error Messages 00:00 Section 5 - Importing and Exporting Importing Data from Text Files 00:00 Importing Data from MS Access 00:00 Exporting Data to a Text File 00:00 Section 6 - Creating Basic Charts Creating Basic Charts 00:00 The Chart Ribbon 00:00 Adding and Modifying Data on a Chart 00:00 Formatting Charts 00:00 Section 7 - Pivot Tables Understanding Pivot Tables 00:00 Creating Pivot Tables 00:00 Pivot Table Calculations 00:00 Grouping Pivot Table Data 00:00 Formatting Pivot Table Data 00:00 Drilling Down into Pivot Table Data 00:00 Creating Pivot Charts 00:00 Filtering Pivot Table Data 00:00 Filtering using the Slicer 00:00 Section 8 - Working with Large Data Grouping Data 00:00 Consolidating Data 00:00 Section 9 - LookUp Functions VLookUp 00:00 HLookUp 00:00 Index and Match 00:00 Section 10 - Advanced Functions FV Function 00:00 PMT Function 00:00 Hyperlinks 00:00 Text to Columns 00:00 Section 11 - Excel Intermediate - Conclusion Excel Intermediate - Conclusion 00:00

Overview Functional maths and English skills are highly valued in a wide range of industries. From education to marketing, these skills can open career opportunities in a wide range of areas. Polish your maths and English skills with our Functional Skills Maths & English course. This course aims to help you develop both English and maths skills in one place. The modules will provide detailed lectures on the vital areas of maths such as fractions, percentages, probability, decimals and more. Then, you will learn the core concepts and rules of English grammar, sentence structure and punctuation. Here, you will also get the chance to work on your speaking and writing skills. If you are determined to take your maths and English skills to the next level, join today! Course Preview Learning Outcomes Familiarise yourself with the multiple factors Understand the core principles of fractions and power Get detailed lessons on percentages, averages, expressions and decimals Learn the fundamentals of English grammar, punctuation and spelling Improve your English-speaking skills Understanding the principles of English sentence structure Develop the skills required for English writing Why Take This Course From John Academy? Affordable, well-structured and high-quality e-learning study materials Engaging tutorial videos, materials from the industry-leading experts Opportunity to study in a user-friendly, advanced online learning platform Efficient exam systems for the assessment and instant result Earn UK & internationally recognised accredited qualification Easily access the course content on mobile, tablet, or desktop from anywhere, anytime Excellent career advancement opportunities Get 24/7 student support via email. What Skills Will You Learn from This Course? Functional Maths Functional English Who Should Take This Functional Skills Maths & English Course? Whether you're an existing practitioner or an aspiring professional, this course is an ideal opportunity. It will elevate your expertise and boost your CV with key skills and a recognised qualification attesting to your knowledge. Are There Any Entry Requirements? This Functional Skills Maths & English course is available to all learners of all academic backgrounds. But learners should be aged 16 or over to undertake the qualification. And a good understanding of the English language, numeracy, and ICT will be helpful. Certificate of Achievement After completing this course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates & Transcripts can be obtained either in Hardcopy at £14.99 or in PDF format at £11.99. Career Path​ This exclusive Functional Skills Maths & English course will equip you with effective skills and abilities and help you explore career paths such as  Maths Teacher English Teacher Online Tutor Teaching Assistant Module 01: Introduction to Numbers Introduction to Numbers 00:10:00 Module 02: Multiples Factors Multiples Factors 00:11:00 Module 03: Fractions and Power Fractions and Power 00:15:00 Module 04: Percentages and Averages Percentages and Averages 00:12:00 Module 05: Expressions Expressions 00:06:00 Module 06: Decimals Decimals 00:08:00 Module 07: Exponents and Radicals Exponents and Radicals 00:09:00 Module 08: Graphs Graphs 00:05:00 Module 09: The Profit and Loss The Profit and Loss 00:06:00 Module 10: Perimeter and Area Perimeter and Area 00:08:00 Module 11: Probability Probability 00:06:00 Module 12: Reading Reading 00:17:00 Module 13: Writing Writing 00:16:00 Module 14: Speaking Speaking 00:22:00 Module 15: Grammar, Spelling and Punctuation Grammar, Spelling and Punctuation 00:23:00 Module 16: Sentence Structure Sentence Structure 00:11:00 Module 17: Composition Writing Composition Writing 00:12:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00