2684 Office Skills & Productivity courses in Liverpool delivered On Demand

Register on the Microsoft Excel: Excel Sheet Comparison with VBA today and build the experience, skills and knowledge you need to enhance your professional development and work towards your dream job. Study this course through online learning and take the first steps towards a long-term career. The course consists of a number of easy to digest, in-depth modules, designed to provide you with a detailed, expert level of knowledge. Learn through a mixture of instructional video lessons and online study materials. Receive online tutor support as you study the course, to ensure you are supported every step of the way. Get a digital certificate as a proof of your course completion. The Microsoft Excel: Excel Sheet Comparison with VBA is incredibly great value and allows you to study at your own pace. Access the course modules from any internet-enabled device, including computers, tablet, and smartphones. The course is designed to increase your employability and equip you with everything you need to be a success. Enrol on the now and start learning instantly! What You Get With The Microsoft Excel: Excel Sheet Comparison with VBA Receive a e-certificate upon successful completion of the course Get taught by experienced, professional instructors Study at a time and pace that suits your learning style Get instant feedback on assessments 24/7 help and advice via email or live chat Get full tutor support on weekdays (Monday to Friday) Course Design The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace. You are taught through a combination of Video lessons Online study materials Certification After the successful completion of the final assessment, you will receive a CPD-accredited certificate of achievement. The PDF certificate is for £9.99, and it will be sent to you immediately after through e-mail. You can get the hard copy for £15.99, which will reach your doorsteps by post. Who Is This Course For: The course is ideal for those who already work in this sector or are an aspiring professional. This course is designed to enhance your expertise and boost your CV. Learn key skills and gain a professional qualification to prove your newly-acquired knowledge. Requirements: The online training is open to all students and has no formal entry requirements. To study the Microsoft Excel: Excel Sheet Comparison with VBA, all your need is a passion for learning, a good understanding of English, numeracy, and IT skills. You must also be over the age of 16. Course Content Introduction to Compare Data Workbook Introduction to Compare Data Workbook 00:06:00 Download Resources 00:00:00 Key requirements for Comparing any Datasets or Worksheets 00:03:00 Tool to Compare Datasets or Worksheets 00:06:00 Comprehensive Introduction to Compare Data Excel VBA Workbook Overview of Compare Data Workbook 00:09:00 Most Important things to remember before you use compare data workbook 00:03:00 IMPORTANT - First Column as KEY Column with UNIQUE Values 00:09:00 Deep Dive into Compare Data Workbook's Environment 00:10:00 How to Change Header Rows for your data 00:06:00 Modify VBA Codes to Suit Your Needs Basics of Using macro enabled Excel files and Code Modules 00:04:00 Changing the Main two sheets name, variance tags in VBA Code 00:05:00 Changing various elements across VBA Code modules 00:05:00 Clear Sheet data button VBA Code 00:04:00 Data Cleaning, Format and Structure Your Datasets with Power Query Convert Row data into Structured, clean and formatted data with Power Query 1 00:07:00 Convert Row data into Structured, clean and formatted data with Power Query 2 00:07:00 Practical and Real world application of Compare Data Workbook Mutual Funds Portfolio - Finding Variances at two different times 00:07:00 Comprehensive Payroll Analysis - Creating Powerful Dashboard 1 00:05:00 Comprehensive Payroll Analysis - Creating Powerful Dashboard 2 00:07:00 Comprehensive Payroll Analysis - Creating Powerful Dashboard 3 00:08:00 Comprehensive Payroll Analysis - Creating Powerful Dashboard 4 00:07:00 Comprehensive Payroll Analysis - Creating Powerful Dashboard 5 00:08:00 Conclusion IMPORTANT Facts and Limitation of Compare Data Workbook 00:03:00 Conclusion 00:01:00 Frequently Asked Questions Are there any prerequisites for taking the course? There are no specific prerequisites for this course, nor are there any formal entry requirements. All you need is an internet connection, a good understanding of English and a passion for learning for this course. Can I access the course at any time, or is there a set schedule? You have the flexibility to access the course at any time that suits your schedule. Our courses are self-paced, allowing you to study at your own pace and convenience. How long will I have access to the course? For this course, you will have access to the course materials for 1 year only. This means you can review the content as often as you like within the year, even after you've completed the course. However, if you buy Lifetime Access for the course, you will be able to access the course for a lifetime. Is there a certificate of completion provided after completing the course? Yes, upon successfully completing the course, you will receive a certificate of completion. This certificate can be a valuable addition to your professional portfolio and can be shared on your various social networks. Can I switch courses or get a refund if I'm not satisfied with the course? We want you to have a positive learning experience. If you're not satisfied with the course, you can request a course transfer or refund within 14 days of the initial purchase. How do I track my progress in the course? Our platform provides tracking tools and progress indicators for each course. You can monitor your progress, completed lessons, and assessments through your learner dashboard for the course. What if I have technical issues or difficulties with the course? If you encounter technical issues or content-related difficulties with the course, our support team is available to assist you. You can reach out to them for prompt resolution.

Register on the Excel: Top 50 Microsoft Excel Formulas in 50 Minutes! today and build the experience, skills and knowledge you need to enhance your professional development and work towards your dream job. Study this course through online learning and take the first steps towards a long-term career. The course consists of a number of easy to digest, in-depth modules, designed to provide you with a detailed, expert level of knowledge. Learn through a mixture of instructional video lessons and online study materials. Receive online tutor support as you study the course, to ensure you are supported every step of the way. Get an e-certificate as proof of your course completion. The Excel: Top 50 Microsoft Excel Formulas in 50 Minutes! is incredibly great value and allows you to study at your own pace. Access the course modules from any internet-enabled device, including computers, tablet, and smartphones. The course is designed to increase your employability and equip you with everything you need to be a success. Enrol on the now and start learning instantly! What You Get With The Excel: Top 50 Microsoft Excel Formulas in 50 Minutes! Receive a e-certificate upon successful completion of the course Get taught by experienced, professional instructors Study at a time and pace that suits your learning style Get instant feedback on assessments 24/7 help and advice via email or live chat Get full tutor support on weekdays (Monday to Friday) Course Design The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace. You are taught through a combination of Video lessons Online study materials Certification Upon successful completion of the course, you will be able to obtain your course completion e-certificate free of cost. Print copy by post is also available at an additional cost of £9.99 and PDF Certificate at £4.99. Who Is This Course For: The course is ideal for those who already work in this sector or are an aspiring professional. This course is designed to enhance your expertise and boost your CV. Learn key skills and gain a professional qualification to prove your newly-acquired knowledge. Requirements: The online training is open to all students and has no formal entry requirements. To study the Excel: Top 50 Microsoft Excel Formulas in 50 Minutes!, all your need is a passion for learning, a good understanding of English, numeracy, and IT skills. You must also be over the age of 16. Course Content Excel: Top 50 Microsoft Excel Formulas in 50 Minutes! 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: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 Getting Traffic To Your Site 01:00:00 Additional Resources Resources : Excel: Top 50 Microsoft Excel Formulas in 50 Minutes! 00:00:00 Frequently Asked Questions Are there any prerequisites for taking the course? There are no specific prerequisites for this course, nor are there any formal entry requirements. All you need is an internet connection, a good understanding of English and a passion for learning for this course. Can I access the course at any time, or is there a set schedule? You have the flexibility to access the course at any time that suits your schedule. Our courses are self-paced, allowing you to study at your own pace and convenience. How long will I have access to the course? For this course, you will have access to the course materials for 1 year only. This means you can review the content as often as you like within the year, even after you've completed the course. However, if you buy Lifetime Access for the course, you will be able to access the course for a lifetime. Is there a certificate of completion provided after completing the course? Yes, upon successfully completing the course, you will receive a certificate of completion. This certificate can be a valuable addition to your professional portfolio and can be shared on your various social networks. Can I switch courses or get a refund if I'm not satisfied with the course? We want you to have a positive learning experience. If you're not satisfied with the course, you can request a course transfer or refund within 14 days of the initial purchase. How do I track my progress in the course? Our platform provides tracking tools and progress indicators for each course. You can monitor your progress, completed lessons, and assessments through your learner dashboard for the course. What if I have technical issues or difficulties with the course? If you encounter technical issues or content-related difficulties with the course, our support team is available to assist you. You can reach out to them for prompt resolution.

Register on the Excel 2016 Formulas and Functions today and build the experience, skills and knowledge you need to enhance your professional development and work towards your dream job. Study this course through online learning and take the first steps towards a long-term career. The course consists of a number of easy to digest, in-depth modules, designed to provide you with a detailed, expert level of knowledge. Learn through a mixture of instructional video lessons and online study materials. Receive online tutor support as you study the course, to ensure you are supported every step of the way. Get a certificate as proof of your course completion. The Excel 2016 Formulas and Functions course is incredibly great value and allows you to study at your own pace. Access the course modules from any internet-enabled device, including computers, tablets, and smartphones. The course is designed to increase your employability and equip you with everything you need to be a success. Enrol on the now and start learning instantly! What You Get With The Excel 2016 Formulas and Functions course Receive a digital certificate upon successful completion of the course Get taught by experienced, professional instructors Study at a time and pace that suits your learning style Get instant feedback on assessments 24/7 help and advice via email or live chat Get full tutor support on weekdays (Monday to Friday) Course Design The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace. You are taught through a combination of Video lessons Online study materials Certification After the successful completion of the final assessment, you will receive a CPD-accredited certificate of achievement. The PDF certificate is for £9.99, and it will be sent to you immediately after through e-mail. You can get the hard copy for £15.99, which will reach your doorsteps by post. Who Is This Course For: The course is ideal for those who already work in this sector or are aspiring professionals. This course is designed to enhance your expertise and boost your CV. Learn key skills and gain a professional qualification to prove your newly-acquired knowledge. Requirements: The online training is open to all students and has no formal entry requirements. To study the Excel 2016 Formulas and Functions course, all you need is a passion for learning, A good understanding of English, numeracy, and IT skills. You must also be over the age of 16. Course Content Getting Started with Microsoft Excel 2016 Use Excel Commands 00:10:00 Create and Save a Basic Workbook 00:19:00 Enter Cell Data 00:12:00 Use Excel Help 00:05:00 Basic Formulas and Functions Create Worksheet Formulas 00:15:00 Insert Functions 00:17:00 Reuse Formulas and Functions 00:17:00 Formulas and Functions Activities Create Formulas in a Worksheet 01:00:00 Activity - Create Formulas in a Worksheet 00:05:00 Insert Functions in a Worksheet 00:30:00 Activity - Insert Functions in a Worksheet 00:05:00 Reuse Formulas 00:30:00 Activity - Reuse Formulas 00:05:00 Customize Formula Options 00:30:00 Activity - Customize Formula Options 00:05:00 Order your Certificates & Transcripts Order your Certificates & Transcripts 00:00:00 Frequently Asked Questions Are there any prerequisites for taking the course? There are no specific prerequisites for this course, nor are there any formal entry requirements. All you need is an internet connection, a good understanding of English and a passion for learning for this course. Can I access the course at any time, or is there a set schedule? You have the flexibility to access the course at any time that suits your schedule. Our courses are self-paced, allowing you to study at your own pace and convenience. How long will I have access to the course? For this course, you will have access to the course materials for 1 year only. This means you can review the content as often as you like within the year, even after you've completed the course. However, if you buy Lifetime Access for the course, you will be able to access the course for a lifetime. Is there a certificate of completion provided after completing the course? Yes, upon successfully completing the course, you will receive a certificate of completion. This certificate can be a valuable addition to your professional portfolio and can be shared on your various social networks. Can I switch courses or get a refund if I'm not satisfied with the course? We want you to have a positive learning experience. If you're not satisfied with the course, you can request a course transfer or refund within 14 days of the initial purchase. How do I track my progress in the course? Our platform provides tracking tools and progress indicators for each course. You can monitor your progress, completed lessons, and assessments through your learner dashboard for the course. What if I have technical issues or difficulties with the course? If you encounter technical issues or content-related difficulties with the course, our support team is available to assist you. You can reach out to them for prompt resolution.

The Excel: Top 50 Microsoft Excel Formulas in 50 Minutes! is a wonderful learning opportunity for anyone who has a passion for this topic and is interested in enjoying a long career in the relevant industry. It's also for anyone who is already working in this field and looking to brush up their knowledge and boost their career with a recognised certification. This Excel: Top 50 Microsoft Excel Formulas in 50 Minutes! consists of several modules that take around 1 hour to complete. The course is accompanied by instructional videos, helpful illustrations, how-to instructions and advice. The course is offered online at a very affordable price. That gives you the ability to study at your own pace in the comfort of your home. You can access the modules from anywhere and from any device. Why choose this course Earn an e-certificate upon successful completion. Accessible, informative modules taught by expert instructors Study in your own time, at your own pace, through your computer tablet or mobile device Benefit from instant feedback through mock exams and multiple-choice assessments Get 24/7 help or advice from our email and live chat teams Full Tutor Support on Weekdays Course Design The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace. You are taught through a combination of Video lessons Online study materials Mock exams Multiple-choice assessment Certification Upon successful completion of the course, you will be able to obtain your course completion PDF Certificate at £9.99. Print copy by post is also available at an additional cost of £15.99 and the same for PDF and printed transcripts. Course Content Excel: Top 50 Microsoft Excel Formulas in 50 Minutes! Have Microsoft Excel Problems? 00:01:00 How to Get the Most from this 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 Formulas Exercise - Answers 00:01:00 Logic Formulas In Excel 00:12:00 Logic Formulas Exercise 00:01:00 Logic Formulas Exercise - Answers 00:01:00 Financial Formulas In Excel 00:06:00 Financial Formulas Exercise 00:01:00 Financial Formulas Exercise - Answers 00:02:00 Informational Formulas In Excel 00:04:00 Informational Formulas Exercise 00:01:00 Informational Formulas Exercise - Answers 00:01:00 Order your Certificates & Transcripts Order your Certificates & Transcripts 00:00:00 Frequently Asked Questions Are there any prerequisites for taking the course? There are no specific prerequisites for this course, nor are there any formal entry requirements. All you need is an internet connection, a good understanding of English and a passion for learning for this course. Can I access the course at any time, or is there a set schedule? You have the flexibility to access the course at any time that suits your schedule. Our courses are self-paced, allowing you to study at your own pace and convenience. How long will I have access to the course? For this course, you will have access to the course materials for 1 year only. This means you can review the content as often as you like within the year, even after you've completed the course. However, if you buy Lifetime Access for the course, you will be able to access the course for a lifetime. Is there a certificate of completion provided after completing the course? Yes, upon successfully completing the course, you will receive a certificate of completion. This certificate can be a valuable addition to your professional portfolio and can be shared on your various social networks. Can I switch courses or get a refund if I'm not satisfied with the course? We want you to have a positive learning experience. If you're not satisfied with the course, you can request a course transfer or refund within 14 days of the initial purchase. How do I track my progress in the course? Our platform provides tracking tools and progress indicators for each course. You can monitor your progress, completed lessons, and assessments through your learner dashboard for the course. What if I have technical issues or difficulties with the course? If you encounter technical issues or content-related difficulties with the course, our support team is available to assist you. You can reach out to them for prompt resolution.

Register on the Microsoft Excel 2021 Course for Everyone - Complete Excel Course today and build the experience, skills and knowledge you need to enhance your professional development and work towards your dream job. Study this course through online learning and take the first steps towards a long-term career. The course consists of a number of easy to digest, in-depth modules, designed to provide you with a detailed, expert level of knowledge. Learn through a mixture of instructional video lessons and online study materials. Receive online tutor support as you study the course, to ensure you are supported every step of the way. Get a digital certificate as a proof of your course completion. The Microsoft Excel 2021 Course for Everyone - Complete Excel Course is incredibly great value and allows you to study at your own pace. Access the course modules from any internet-enabled device, including computers, tablet, and smartphones. The course is designed to increase your employability and equip you with everything you need to be a success. Enrol on the now and start learning instantly! What You Get With The Microsoft Excel 2021 Course for Everyone - Complete Excel Course Receive an e-certificate upon successful completion of the course Get taught by experienced, professional instructors Study at a time and pace that suits your learning style Get instant feedback on assessments 24/7 help and advice via email or live chat Get full tutor support on weekdays (Monday to Friday) Course Design The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace. You are taught through a combination of Video lessons Online study materials Certification Upon successful completion of the course, you will be able to obtain your course completion e-certificate. Print copy by post is also available at an additional cost of £9.99 and PDF Certificate at £4.99. Who Is This Course For The course is ideal for those who already work in this sector or are an aspiring professional. This course is designed to enhance your expertise and boost your CV. Learn key skills and gain a professional qualification to prove your newly-acquired knowledge. Requirements The online training is open to all students and has no formal entry requirements. To study the Microsoft Excel 2021 Course for Everyone - Complete Excel Course, all your need is a passion for learning, a good understanding of English, numeracy, and IT skills. You must also be over the age of 16. Course Content Section 01: Getting Started Introduction 00:03:00 Course Curriculum 00:04:00 Getting started on Windows, macOS, Android, and IOS 00:01:00 How to ask great questions 00:02:00 FAQ's 00:01:00 Starting Excel 00:04:00 Section 02: Excel Basics Introduction 00:02:00 Worksheet basics 00:22:00 Entering values and formulas 00:12:00 Data formats 00:10:00 Data handling basics - cut copy and paste 00:07:00 Save and print in excel 00:10:00 Excel Ranges 00:05:00 Section 03: Excel essential functions Introduction 00:01:00 Basic formula operations 00:06:00 Mathematical functions level 1 00:20:00 Mathematical functions level 2 00:12:00 Text functions level 1 00:09:00 Text functions level 2 00:13:00 Logical functions 00:11:00 Date time functions 00:06:00 V Lookup formula 00:12:00 HLookup formula 00:04:00 HLookup + Match formula 00:09:00 Match + Index formula 00:05:00 Section 04: XLookup only for Excel 2021 and Office 365 Introduction 00:02:00 XLookup 00:08:00 Handling #NA and Approximates match in XLookup 00:11:00 Wildcard matching in XLookup 00:06:00 Section 05: Get Data and tools Introduction 00:02:00 Split text into columns 00:07:00 Flash Fill 00:07:00 Remove Duplicates 00:08:00 Data Validation 00:07:00 Get- import Data from Text 00:06:00 Get - import Data from CSV 00:03:00 Section 06: Formatting data and tables Introduction 00:01:00 Formatting Font 00:04:00 Formatting Alignment 00:06:00 Formatting Number 00:05:00 Formatting Date 00:03:00 Formatting tables 00:05:00 Section 07: Pivot Tables Introduction 00:01:00 Creating Pivot Table 00:07:00 Value field settings 00:04:00 Number format 00:02:00 Pivot Table Design 00:03:00 Excel Exercise 00:01:00 Solution for Excel Exercise 00:02:00 Section 08: Excel Charts Introduction 00:01:00 Excel Charts - Categories 00:03:00 Elements of a chart 00:04:00 Easy way to create charts 00:02:00 Column or Bar charts 00:04:00 Formatting charts 00:04:00 Line charts 00:02:00 Area charts 00:02:00 Pie and Doughnut charts 00:04:00 Format AreaPlot or XY chart 00:08:00 Scatter or bubble charts 00:02:00 Section 09: Advanced Excel charts Introduction 00:01:00 Frequency Distribution and Histograms 00:04:00 Waterfall charts 00:02:00 Hierarchy charts: sunburst and tree map 00:03:00 Combination charts 00:02:00 Sparklines 00:05:00 Section 10: Pivot Charts Pivot charts 00:02:00 Section 11: Maps Chart above 2019 Maps chart 00:04:00 3D Maps chart 00:03:00 Section 12: Business-Geo charts Introduction 00:01:00 Stock charts 00:02:00 Radar charts 00:02:00 Surface charts 00:02:00 Heat maps 00:04:00 Section 13: Named Ranges Indirect Name range Function 00:06:00 Named ranges 00:05:00 Section 14: Import Data into Excel Import Data from Website - Excel 2019 above 00:09:00 Import Data table from PDF file - Excel 2021 00:04:00 Section 15: Advanced Excel Product Sale Tax invoice: Tax Calculations 00:05:00 Project: Sales forecast tracker 00:07:00 Frequently Asked Questions Are there any prerequisites for taking the course? There are no specific prerequisites for this course, nor are there any formal entry requirements. All you need is an internet connection, a good understanding of English and a passion for learning for this course. Can I access the course at any time, or is there a set schedule? You have the flexibility to access the course at any time that suits your schedule. Our courses are self-paced, allowing you to study at your own pace and convenience. How long will I have access to the course? For this course, you will have access to the course materials for 1 year only. This means you can review the content as often as you like within the year, even after you've completed the course. However, if you buy Lifetime Access for the course, you will be able to access the course for a lifetime. Is there a certificate of completion provided after completing the course? Yes, upon successfully completing the course, you will receive a certificate of completion. This certificate can be a valuable addition to your professional portfolio and can be shared on your various social networks. Can I switch courses or get a refund if I'm not satisfied with the course? We want you to have a positive learning experience. If you're not satisfied with the course, you can request a course transfer or refund within 14 days of the initial purchase. How do I track my progress in the course? Our platform provides tracking tools and progress indicators for each course. You can monitor your progress, completed lessons, and assessments through your learner dashboard for the course. What if I have technical issues or difficulties with the course? If you encounter technical issues or content-related difficulties with the course, our support team is available to assist you. You can reach out to them for prompt resolution.

Microsoft Excel 2016 Advanced is one of our best selling and most popular course. This course is suitable for anyone aspiring to or already working in Microsoft Excel and looks at skills needed to improve Microsoft Excel. By taking this course you will gain the necessary skills to perform effectively in this field. The Microsoft Excel 2016 Advanced is organised into 6 modules and includes everything you need to become successful in this profession. To make this course more accessible for you, we have designed it for both part-time and full-time students. You can study at your own pace or become an expert in just 8hours! If you require support, our experienced tutors are always available to help you throughout the comprehensive syllabus of this course and answer all your queries through email. Why choose this course Earn an e-certificate upon successful completion. Accessible, informative modules taught by expert instructors Study in your own time, at your own pace, through your computer tablet or mobile device Benefit from instant feedback through mock exams and multiple-choice assessments Get 24/7 help or advice from our email and live chat teams Full Tutor Support on Weekdays Course Design The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace. You are taught through a combination of Video lessons Online study materials Mock exams Multiple-choice assessment Certification After the successful completion of the final assessment, you will receive a CPD-accredited certificate of achievement. The PDF certificate is for £9.99, and it will be sent to you immediately after through e-mail. You can get the hard copy for £15.99, which will reach your doorsteps by post. Course Content Automating Worksheet Functionality Update Workbook Properties 00:15:00 Activity-Update Workbook Properties 00:05:00 Create and Edit a Macro 00:15:00 Activity-Create and Edit a Macro 00:05:00 Apply Conditional Formatting 00:30:00 Activity-Apply Conditional Formatting 00:05:00 Add Data Validation Criteria 00:15:00 Activity-Add Data Validation Criteriaty 00:05:00 Auditing Worksheets Trace Cells 00:15:00 Activity-Trace Cells 00:05:00 Troubleshoot Invalid Data and Formula Errors 00:15:00 Activity-Troubleshoot Invalid Data and Formula Errors 00:05:00 Watch and Evaluate Formulas 00:15:00 Activity-Watch and Evaluate Formulas 00:05:00 Create a Data List Outline 00:15:00 Activity-Create a Data List Outline 00:05:00 Analyzing and Presenting Data Create Sparklines 00:15:00 Activity_Create Sparklines 00:05:00 Create Scenarios 00:15:00 Activity-Create Scenarios 00:05:00 Perform a What-If Analysis 00:15:00 Activity-Perform a What-If Analysis 00:05:00 Perform a Statistical Analysis with the Analysis ToolPak 00:15:00 Activity-Perform a Statistical Analysis with the Analysis ToolPak 00:05:00 Create Interactive Data with Power View 00:15:00 Activity-Create Interactive Data with Power View 00:05:00 Working with Multiple Workbooks Consolidate Data 00:15:00 Activity-Consolidate Data 00:05:00 Link Cells in Different Workbooks 00:15:00 Activity-Link Cells in Different Workbooks 00:05:00 Merge Workbooks 00:15:00 Activity-Merge Workbooks 00:05:00 Exporting Excel Data Export Excel Data 00:15:00 Activity-Export Excel Data 00:05:00 Import a Delimited Text File 00:14:00 Activity- Import a Delimited Text File 00:05:00 Integrate Excel Data with the Web 00:15:00 Activity-Integrate Excel Data with the Web 00:05:00 Create a Web Query 00:15:00 Activity-Create a Web Query 00:05:00 Importing and Exporting XML Data Import and Export XML Data 00:15:00 Activity-Import and Export XML Data 00:05:00 Activities Activities and Exercise Files - Microsoft Excel 2016 Advanced 00:00:00 Mock Exam Mock Exam- Microsoft Excel 2016 Advanced 00:20:00 Final Exam Final Exam- Microsoft Excel 2016 Advanced 00:20:00 Order your Certificates & Transcripts Order your Certificates & Transcripts 00:00:00 Frequently Asked Questions Are there any prerequisites for taking the course? There are no specific prerequisites for this course, nor are there any formal entry requirements. All you need is an internet connection, a good understanding of English and a passion for learning for this course. Can I access the course at any time, or is there a set schedule? You have the flexibility to access the course at any time that suits your schedule. Our courses are self-paced, allowing you to study at your own pace and convenience. How long will I have access to the course? For this course, you will have access to the course materials for 1 year only. This means you can review the content as often as you like within the year, even after you've completed the course. However, if you buy Lifetime Access for the course, you will be able to access the course for a lifetime. Is there a certificate of completion provided after completing the course? Yes, upon successfully completing the course, you will receive a certificate of completion. This certificate can be a valuable addition to your professional portfolio and can be shared on your various social networks. Can I switch courses or get a refund if I'm not satisfied with the course? We want you to have a positive learning experience. If you're not satisfied with the course, you can request a course transfer or refund within 14 days of the initial purchase. How do I track my progress in the course? Our platform provides tracking tools and progress indicators for each course. You can monitor your progress, completed lessons, and assessments through your learner dashboard for the course. What if I have technical issues or difficulties with the course? If you encounter technical issues or content-related difficulties with the course, our support team is available to assist you. You can reach out to them for prompt resolution.

Microsoft Excel is a powerful tool widely used to create and format spreadsheets, interpret and share data or information to make further accurate conclusions. Mastering Excel can be a valuable investment in both your personal and professional life. Taking this Microsoft Excel 2016 Intermediate course will help you create advanced workbooks and worksheets. Upon successful completion, you will be able to explain massive amounts of data and ensure actionable information from it. Why choose this course Earn an e-certificate upon successful completion. Accessible, informative modules taught by expert instructors Study in your own time, at your own pace, through your computer tablet or mobile device Benefit from instant feedback through mock exams and multiple-choice assessments Get 24/7 help or advice from our email and live chat teams Full Tutor Support on Weekdays Course Design The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace. You are taught through a combination of Video lessons Online study materials Mock exams Multiple-choice assessment Certification After the successful completion of the final assessment, you will receive a CPD-accredited certificate of achievement. The PDF certificate is for £9.99, and it will be sent to you immediately after through e-mail. You can get the hard copy for £15.99, which will reach your doorsteps by post. Course Content Microsoft Excel 2016 Intermediate Apply Range Names 00:30:00 Use Specialized Functions 00:30:00 Use Text Functions 00:30:00 Use Logical Functions 00:30:00 Use Lookup Functions 00:30:00 Use Date Functions 00:30:00 Use Financial Functions 00:30:00 Create and Modify Tables 00:30:00 Sort and Filter Data 00:30:00 Use Subtotal and Database Functions to Calculate Data 00:30:00 Create Charts 00:30:00 Modify and Format Charts 00:30:00 Create a Trendline 00:30:00 Create Advanced Charts 00:30:00 Create a PivotTable 00:30:00 Filter Data by Using Slicers 00:30:00 Analyze Data with PivotCharts 00:30:00 Insert and Modify Graphic Objects 00:30:00 Layer and Group Graphic Objects 00:30:00 Incorporate SmartArt 00:30:00 Customize Workbooks 00:30:00 Manage Themes 00:30:00 Create and Use Templates 00:30:00 Protect Files 00:30:00 Preparing a Workbook for Multiple Audiences 00:30:00 Activities Activities and Exercise Files - Microsoft Excel 2016 Intermediate 00:00:00 Mock Exam Mock Exam- Microsoft Excel 2016 Intermediate 00:20:00 Final Exam Final Exam- Microsoft Excel 2016 Intermediate 00:20:00 Order your Certificates & Transcripts Order your Certificates & Transcripts 00:00:00 Frequently Asked Questions Are there any prerequisites for taking the course? There are no specific prerequisites for this course, nor are there any formal entry requirements. All you need is an internet connection, a good understanding of English and a passion for learning for this course. Can I access the course at any time, or is there a set schedule? You have the flexibility to access the course at any time that suits your schedule. Our courses are self-paced, allowing you to study at your own pace and convenience. How long will I have access to the course? For this course, you will have access to the course materials for 1 year only. This means you can review the content as often as you like within the year, even after you've completed the course. However, if you buy Lifetime Access for the course, you will be able to access the course for a lifetime. Is there a certificate of completion provided after completing the course? Yes, upon successfully completing the course, you will receive a certificate of completion. This certificate can be a valuable addition to your professional portfolio and can be shared on your various social networks. Can I switch courses or get a refund if I'm not satisfied with the course? We want you to have a positive learning experience. If you're not satisfied with the course, you can request a course transfer or refund within 14 days of the initial purchase. How do I track my progress in the course? Our platform provides tracking tools and progress indicators for each course. You can monitor your progress, completed lessons, and assessments through your learner dashboard for the course. What if I have technical issues or difficulties with the course? If you encounter technical issues or content-related difficulties with the course, our support team is available to assist you. You can reach out to them for prompt resolution.

Description: Explore all that you need at an advanced level to become a proficient Microsoft OneNote 2010 user. This course will help you learn more advanced skills for working with your Notebooks. It demonstrates the new and enhanced features in Microsoft OneNote 2010 for gathering and sharing information. Students will explore OneNote 2010 interface features, including creating switchboards, macros, original reports, custom buttons, and in-depth custom queries for detailed data analysis. Students will also explore the best practices to employ during initial design and creation steps. In this course you will learn the necessary skills, knowledge and information of Microsoft One Note 2010.  Who is this course for? This course would be ideal for Microsoft Office users, students, and office workers. This course is designed for anyone who wants to learn Microsoft one note 2010 at an advanced level. Entry Requirement: This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Assessment: At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful. Before sitting for your final exam, you will have the opportunity to test your proficiency with a mock exam. Certification: After you have successfully passed the test, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hard copy at the cost of £39 or in PDF format at the cost of £24. PDF certificate's turnaround time is 24 hours, and for the hardcopy certificate, it is 3-9 working days. Why choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognized accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. Career Path: The Microsoft One Note 2010 Advanced Level will be very beneficial and helpful, especially to the following professionals: Event planner Project manager Real estate agent Travel agent Teacher Lawyer Microsoft One Note 2010 Advanced Level Module One - Getting Started 00:30:00 Module Two - Upgrading from One Note 2007 or 2003 01:00:00 Module Three - Staying Organized 01:00:00 Module Four - Note Taking Tools 01:00:00 Module Five - Text and Page Formatting 01:00:00 Module Six - Drawing and Handwriting Notes 01:00:00 Module Seven - Office Integration 01:00:00 Module Eight - Researching a Topic 01:00:00 Module Nine - Linked Notes 01:00:00 Module Ten - Collaborating 01:00:00 Module Eleven - Other Tools 01:00:00 Module Twelve - Wrapping Up 00:30:00 Activities - Microsoft One Note 2010 Advanced Level 00:00:00 Mock Exam Mock Exam- Microsoft one note 2010 advanced level 00:20:00 Final Exam Final Exam- Microsoft one note 2010 advanced level 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Description: By this Microsoft Office 2016 Word Advanced Level - Complete Video Course you will be introduce with the advanced level of Microsoft Word 2016. This advanced level will help you to broad up your knowledge which you got from the intermediate level. Here you will learn how to work with tables of content, footnotes and endnotes, how to insert bibliographies and indexes, how to use comments, track changes including accepting and rejecting changes, compare and combine documents, how to use mail merge and create envelope and labels, protect document ,use bookmarks, add watermarks, and customize the Ribbon, and more. You can join this course, if you have intermediate skills and knowledge with Microsoft Word 2016 and want to take another step forward or want to learn the topics covered in this course in the 2016 interface. So, don't be late, come and join this course now. Assessment: At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Microsoft Office 2016 Word Advanced Level - Complete Video Course is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our Microsoft Office 2016 Word Advanced Level - Complete Video Course is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Manipulating Images Integrate Pictures and Text FREE 00:15:00 Adjust Image Appearance 00:09:00 Insert Other Media Elements 00:02:00 Using Custom Graphic Elements Create Text Boxes and Pull Quotes 00:06:00 Add WordArt and Other Text Effects 00:05:00 Draw Shapes 00:07:00 Create Complex Illustrations with SmartArt 00:08:00 Collaborating on Documents Prepare a Document for Collaboration 00:09:00 Mark Up a Document 00:06:00 Review Markups 00:04:00 Merge Changes from Other Documents 00:06:00 Adding Document References and Links Add Captions 00:06:00 Add Cross References 00:08:00 Add Bookmarks 00:05:00 Add Hyperlinks 00:06:00 Insert Footnotes and Endnotes 00:05:00 Add Citations and a Bibliography 00:11:00 Securing a Document Suppress Information 00:07:00 Set Formatting and Editing Restrictions 00:06:00 Restrict Document Access 00:02:00 Add a Digital Signature to a Document 00:04:00 Using Forms to Manage Content Create Forms 00:09:00 Modify Forms 00:03:00 Automating Repetitive Tasks with Macros Automate Tasks by Using Macros 00:10:00 Create a Macro 00:19:00 Mock Exam Mock Exam- Microsoft Office 2016 Word Advanced Level - Complete Video Course 00:20:00 Final Exam Final Exam- Microsoft Office 2016 Word Advanced Level - Complete Video Course 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Description: This Microsoft Office 2013 Word Advanced - Complete Video Course covers the advanced functions and features of Word 2013. With this advanced level, you will learn advanced skills in using Microsoft Word 2013 and be able to demonstrate the use of advanced and specialized features within the application. You should be able to create, manage, and distribute professional documents for a variety of specialized purposes and situations, and be able to customize Word 2013 environment to meet specific needs to enhance productivity. By this series, you will learn about collaborating on documents and adding reference marks and notes. You will also learn how to manage long documents, secure a document and work with forms, and more. If you already have a good grounding in Microsoft Word, this course will provide you with the knowledge and skills to use Word 2013 at an expert level. Assessment: At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Microsoft Office 2013 Word Advanced - Complete Video Course is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our Microsoft Office 2013 Word Advanced - Complete Video Course is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Collaborating on Documents Modify User Information FREE 00:06:00 Share a Document 00:03:00 Compare Document Changes 00:09:00 Review a Document 00:11:00 Merge Document Changes 00:01:00 Review Tracked Changes 00:09:00 Coauthor Documents 00:10:00 Adding Reference Marks and Notes Add Captions 00:07:00 Add Cross-References 00:09:00 Add Bookmarks 00:08:00 Add Hyperlinks 00:06:00 Insert Footnotes and Endnotes 00:06:00 Add Citations and a Bibliography 00:14:00 Simplifying and Managing Long Documents Insert Blank and Cover Pages 00:06:00 Insert an Index 00:12:00 Insert a Table of Contents 00:05:00 Insert an Ancillary Table 00:09:00 Manage Outlines 00:08:00 Create a Master Document 00:08:00 Securing a Document Suppress Information 00:08:00 Set Formatting and Editing Restrictions 00:04:00 Add a Digital Signature to a Document 00:09:00 Restrict Document Access 00:03:00 Forms Create Forms 00:14:00 Manipulate Forms 00:04:00 Mock Exam Mock Exam- Microsoft Office 2013 Word Advanced - Complete Video Course 00:20:00 Final Exam Final Exam- Microsoft Office 2013 Word Advanced - Complete Video Course 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00