4844 Courses

Overview This comprehensive course on Advanced Excel Course (Formula, VLOOKUP & Power Query) will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Advanced Excel Course (Formula, VLOOKUP & Power Query) comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this Advanced Excel Course (Formula, VLOOKUP & Power Query). It is available to all students, of all academic backgrounds. Requirements Our Advanced Excel Course (Formula, VLOOKUP & Power Query) is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more!   Course Curriculum 5 sections • 41 lectures • 02:56:00 total length •How to Get the most of the course: 00:01:00 •Text formulas in Excel: 00:08:00 •Text Formulas Exercise: 00:01:00 •Text Formulas Exercise (answers): 00:01:00 •Mathematical Formulas In Excel: 00:04:00 •Mathematical Formulas Exercise: 00:01:00 •Mathematical Formulas Exercise (answers): 00:01:00 •Date and Time Formulas In Excel: 00:05:00 •Date and Time Formulas Exercise: 00:01:00 •Date and Time Exercise Formulas (answers): 00:01:00 •Logic Formulas In Excel: 00:12:00 •Logic Formula Exercise: 00:01:00 •Logic Formula Exercise (answers): 00:01:00 •Financial Formula In Excel: 00:06:00 •Financial Formula Exercise: 00:01:00 •Financial Formula Exercise (answers): 00:02:00 •Informational Formula In Excel: 00:04:00 •Informational Formula Exercise: 00:01:00 •Informational Formula Exercise (answers): 00:01:00 •Menu Example with Excel Vlookup: 00:08:00 •Wildcard Search with Excel Vlookup: 00:09:00 •Looking to the Left with Excel Vlookup: 00:17:00 •2-Way Lookup: 00:14:00 •Comparing Lists with Excel Vlookup: 00:03:00 •Microsoft Excel Vlookup Tips and Tricks: 00:14:00 •Power Query Intro and Excel version: 00:03:00 •Excel Power Query - Introduction: 00:03:00 •Enabling M in Power Query: 00:02:00 •Transform Data - Trim in Excel Power Query: 00:05:00 •Transform Data - Format Dates and Values in Excel Power Query: 00:02:00 •Simple Expressions: 00:08:00 •Simple Expressions - Nested Expressions: 00:03:00 •Transform Data - Parsing URLs in Excel Power Query: 00:05:00 •Variables: 00:08:00 •Formatting Excel Keyboard Shortcuts: 00:02:00 •Table Excel Keyboard Shortcuts: 00:02:00 •Editing Excel Keyboard Shortcuts: 00:05:00 •Formula Excel Keyboard Shortcuts: 00:03:00 •Workbook Excel Keyboard Shortcuts: 00:02:00 •Handy Excel Shortcuts Keyboard Shortcuts: 00:05:00 •Assignment - Advanced Excel Course (Formula, VLOOKUP & Power Query): 00:00:00

Overview This comprehensive course on Excel spreadsheet for Beginner will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Excel spreadsheet for Beginner comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this Excel spreadsheet for Beginner. It is available to all students, of all academic backgrounds. Requirements Our Excel spreadsheet for Beginner is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 2 sections • 14 lectures • 01:29:00 total length •Tour of the Excel screen: 00:10:00 •Entering Data: 00:13:00 •Autofill Speedfill: 00:09:00 •Saving the file: 00:02:00 •Autosum: 00:04:00 •Formula Basics: 00:11:00 •Copying formulas - Relative Formulas: 00:04:00 •Totals and Averages: 00:04:00 •Formatting the Spreadsheet: 00:07:00 •Managing the Sheets: 00:06:00 •Copying formulas - absolute formulas: 00:08:00 •Linking the Sheets together: 00:06:00 •Introduction to Functions: 00:05:00 •Assignment - Excel spreadsheet for Beginner: 00:00:00

Overview This comprehensive course on Excel: Top 50 Microsoft Excel Formulas in 50 Minutes! will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Excel: Top 50 Microsoft Excel Formulas in 50 Minutes! comes with accredited certification which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is this course for? There is no experience or previous qualifications required for enrolment on this Excel: Top 50 Microsoft Excel Formulas in 50 Minutes!. It is available to all students, of all academic backgrounds. Requirements Our Excel: Top 50 Microsoft Excel Formulas in 50 Minutes! is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible on tablets and smartphones so you can access your course on wifi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career path Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management, Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 2 sections • 23 lectures • 01:56:00 total length •Excel promo: 00:01:00 •Getting the most of the course: 00:01:00 •How to Get the most of the course: 00:01:00 •Text formulas in Excel: 00:08:00 •Text Formulas Exercise: 00:01:00 •Text Formulas Exercise (answers): 00:01:00 •Mathematical Formulas In Excel: 00:04:00 •Mathematical Formulas Exercise: 00:01:00 •Mathematical Formulas Exercise (answers): 00:01:00 •Date and Time Formulas In Excel: 00:06:00 •Date and Time Formulas Exercise: 00:01:00 •Date and Time Exercise Formulas (answers): 00:01:00 •Logic Formulas In Excel: 00:12:00 •Logic Formula Exercise: 00:01:00 •Logic Formula Exercise (answers): 00:01:00 •Financial Formula In Excel: 00:06:00 •Financial Formula Exercise: 00:01:00 •Financial Formula Exercise (answers): 00:02:00 •Informational Formula In Excel: 00:04:00 •Informational Formula Exercise: 00:01:00 •Informational Formula Exercise (answers): 00:01:00 •Getting Traffic To Your Site: 01:00:00 •Resources : Excel: Top 50 Microsoft Excel Formulas in 50 Minutes!: 00:00:00

Overview This comprehensive course on Excel Pivot Tables, Pivot Charts, Slicers, and Timelines will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Excel Pivot Tables, Pivot Charts, Slicers, and Timelines comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this Excel Pivot Tables, Pivot Charts, Slicers, and Timelines. It is available to all students, of all academic backgrounds. Requirements Our Excel Pivot Tables, Pivot Charts, Slicers, and Timelines is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 2 sections • 15 lectures • 01:21:00 total length •Getting started with your Pivot Table: 00:04:00 •Drill Down: 00:01:00 •Managing the Field List: 00:02:00 •Changing the Calculation type with Value Field Settings: 00:06:00 •Growing your Pivot Table with Multiple Fields: 00:04:00 •Formatting the Pivot Table: 00:05:00 •Sorting and Filtering the Pivot Table: 00:03:00 •Creating a Dashboard with Slicers, Timelines and Pivot Charts: 00:09:00 •Reporting by day, month, qtr, or year within the Pivot Table: 00:04:00 •Refreshing the Pivot Data with new data: 00:03:00 •Adding your own calculations into the Pivot Table: 00:03:00 •The power of the Filter Section in the Pivot Table: 00:04:00 •PowerQuery: 00:12:00 •PowerPivot: 00:21:00 •Assignment - Excel Pivot Tables, Pivot Charts, Slicers, and Timelines: 00:00:00

Overview This comprehensive course on Diploma in Excel Vlookup Xlookup Match and Index will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Diploma in Excel Vlookup Xlookup Match and Index comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this Diploma in Excel Vlookup Xlookup Match and Index. It is available to all students, of all academic backgrounds. Requirements Our Diploma in Excel Vlookup Xlookup Match and Index is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 2 sections • 8 lectures • 00:46:00 total length •1.1 Excel vlookup: 00:08:00 •1.2 Excel xlookup: 00:06:00 •1.3 Excel vlookup: 00:08:00 •1.4 Excel vlookup: 00:03:00 •1.5 Excel vlookup: 00:11:00 •1.6 Excel vlookup: 00:05:00 •1.7 Excel vlookup: 00:05:00 •Assignment - Diploma in Excel Vlookup Xlookup Match and Index: 00:00:00

Overview This comprehensive course on Microsoft Excel: Master Power Query in 120 Minutes! will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Microsoft Excel: Master Power Query in 120 Minutes! comes with accredited certification which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is this course for? There is no experience or previous qualifications required for enrolment on this Microsoft Excel: Master Power Query in 120 Minutes!. It is available to all students, of all academic backgrounds. Requirements Our Microsoft Excel: Master Power Query in 120 Minutes! is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible on tablets and smartphones so you can access your course on wifi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career path Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management, Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 1 sections • 25 lectures • 02:25:00 total length •Power Query Intro and Excel version: 00:03:00 •Excel Power Query - Introduction: 00:03:00 •Excel Power Query - Query Editor Ribbon: 00:09:00 •Transform Data - Trim in Excel Power Query: 00:05:00 •Transform Data - Format Dates and Values in Excel Power Query: 00:02:00 •Transform Data - Parsing URLs in Excel Power Query: 00:05:00 •Transform Data - Split Text Fields in Excel Power Query: 00:10:00 •Transform Data - Group By in Excel Power Query: 00:03:00 •Transform Data - Unpivoting Columns in Excel Power Query: 00:05:00 •Transform Data - Pivoting Columns in Excel Power Query: 00:02:00 •Transform Data - Split Columns into Other Columns in Excel Power Query: 00:04:00 •Transform Data - Filtering Rows in Excel Power Query: 00:05:00 •Transform Data - Sorting Columns in Excel Power Query: 00:02:00 •Transform Data - Transform and Add Columns in Excel Power Query: 00:07:00 •From Folder - Import From Folder in Excel Power Query: 00:07:00 •From Folder - Doing Auto Cleanup in Excel Power Query: 00:13:00 •From Folder - Extract Data from Forms in Excel Power Query: 00:13:00 •From Workbook - Extract Multiple Criteria in Excel Power Query: 00:05:00 •From Workbook - Extract Multiple Worksheets in Excel Power Query: 00:04:00 •Joins - Intro to Joins: 00:04:00 •Joins - Merging: 00:08:00 •Joins - Full Outer Join: 00:06:00 •Joins - Right Anti Join: 00:09:00 •Power Query - Convert Reports into Pivot Tables: 00:05:00 •Modulo: 00:06:00

Overview This comprehensive course on 50 Tips to Upgrade your Excel Skill will deepen your understanding on this topic.After successful completion of this course you can acquire the required skills in this sector. This 50 Tips to Upgrade your Excel Skill comes with accredited certification which will enhance your CV and make you worthy in the job market.So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is this course for? There is no experience or previous qualifications required for enrolment on this 50 Tips to Upgrade your Excel Skill. It is available to all students, of all academic backgrounds. Requirements Our 50 Tips to Upgrade your Excel Skill is fully compatible with PC's, Mac's, Laptop,Tablet and Smartphone devices. This course has been designed to be fully compatible on tablets and smartphones so you can access your course on wifi, 3G or 4G.There is no time limit for completing this course, it can be studied in your own time at your own pace. Career path Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management, Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 7 sections • 52 lectures • 02:57:00 total length •Welcome: 00:02:00 •Camera Tool: 00:05:00 •Add Line Break in Formula Bar: 00:03:00 •Advanced Copy-Paste using Office Clipboard: 00:03:00 •Navigation between Worksheets using Shortcut Keys: 00:01:00 •Flash Fill: 00:02:00 •Add Multiple Rows and Columns Quickly: 00:02:00 •Delete Blank Rows: 00:03:00 •Multi Level Row and Column Sorting: 00:04:00 •Add Sparklines: 00:03:00 •Paste Special - Transpose: 00:03:00 •Snap to Grid: 00:03:00 •Create Custom Auto fill List: 00:06:00 •Absolute Cell Reference: 00:03:00 •Import Data from Web page: 00:04:00 •Move Cell Direction: 00:03:00 •Delete Data using Mouse: 00:02:00 •Status Bar Quick Calculations: 00:03:00 •Link Text Boxes to Cell: 00:04:00 •Phone Number and ZIP Code Format: 00:04:00 •Speaking Cell: 00:05:00 •Invisible Text: 00:03:00 •Worksheet Grouping: 00:04:00 •Advanced Transpose: 00:04:00 •XLStart Folder: 00:03:00 •Use Slicers: 00:05:00 •Convert Text to Numbers: 00:03:00 •Hiding Workbook Elements: 00:02:00 •Useful Shortcut Keys: 00:03:00 •Sort data from Left to Right: 00:03:00 •Advanced Filter (Complex): 00:11:00 •Email as PDF: 00:02:00 •Synchronous Scrolling: 00:03:00 •Quick Analysis of data within Excel: 00:02:00 •Fill blank cells with Value: 00:03:00 •Hidden Chart Source Data: 00:03:00 •Two more Shortcuts: 00:03:00 •Add Blank Rows: 00:03:00 •Custom views in Excel: 00:06:00 •EMBED Feature: 00:04:00 •Adding Country code in Mobile Numbers: 00:04:00 •Plot an Average Line to a Chart: 00:04:00 •3D Referencing: 00:04:00 •Extract Unique Values: 00:03:00 •Excel Array Formula: 00:04:00 •Forecast Sheet: 00:04:00 •Add Spin Controls in Excel: 00:05:00 •Move Data using Mouse: 00:01:00 •Add new entry in Auto Correct to use across Office Applications: 00:05:00 •Find Differences between Two Lists: 00:02:00 •Find formulas Quickly: 00:02:00 •Thank You: 00:01:00

Gain the skills and credentials to kickstart a successful career and learn from the experts with this step-by-step

Overview Knowledge of how to prepare and submit VAT Return can help you to stand out from the crowd of job seekers. Moreover, if you are running a business or thinking of running a business, the vat training course will help you to understand the issues relating to vat more clearly and help process VAT Return more accurately and efficiently. Our VAT Training courses are eligible CPD Training for accountants and attending this course can give you a more detailed understanding of how to do a VAT return correctly. What is VAT Return? Almost every business has to submit a VAT Return. VAT Return contains Output VAT and Input VAT information to be submitted to Taxman (HMRC). Through the VAT return, HMRC knows exactly how much the business owes to HMRC. Moreover, HMRC can pay back any VAT amount overpaid which only can be determined through an accurate VAT return. How to do VAT Return Firstly, businesses need to register with HMRC before they can process a VAT Return. Businesses must fulfil the criteria to become VAT registered and to get a VAT Registration no. Once the business is registered they can then regularly submit the VAT return using specified VAT forms. There are many VAT Schemes available in general. There are some specialised VAT schemes available only for specific industries. Understanding VAT Principles Analysis of different VAT Scheme Preparing VAT in Spreadsheet Reconciliation of VAT Completing a VAT return Import and Export VAT analysis Calculating VAT for a business with mixed zero-rated and standard-rated sales, using Spreadsheet Introduction of TOMS (Tour Operator Margin Scheme) Submission Steps of VAT Return to HMRC Introduction to Making Tax Digital(VAT) scheme

This is the sign that you can learn cool courses during high school. If you want to prepare for your future, do it with Spark Generation and our Cambridge self-paced Business course :)