• Professional Development
  • Medicine & Nursing
  • Arts & Crafts
  • Health & Wellbeing
  • Personal Development

4079 Courses delivered Online

Excel Essentials for Office Administrators

4.7(160)

By Janets

Register on the Excel Essentials for Office Administrators 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 Essentials for Office Administrators 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 Essentials for Office Administrators 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 Excel Essentials for Office Administrators, 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 Beginner Identify the Elements of the Excel Interface 00:24:00 Activity - Identify the Elements of the Excel Interface 00:10:00 Create a Basic Worksheet 00:40:00 Activity - Create a Basic Worksheet 00:16:00 Use the Help System@ 00:08:00 Activity - Use the Help System 00:12:00 Create Formulas in a Worksheet 00:08:00 Activity - Create Formulas in a Worksheet 00:10:00 Insert Functions in a Worksheet@ 00:10:00 Activity - Insert Functions in a Worksheet 00:12:00 Reuse Formulas 00:12:00 Activity - Reuse Formulas 00:14:00 Manipulate Data 00:16:00 Activity - Manipulate Data 00:08:00 Insert, Manipulate, and Delete Cells, Columns, and Rows 00:18:00 Activity - Insert, Manipulate, and Delete Cells, Columns, and Rows@ 00:12:00 Search For and Replace Data 00:20:00 Activity - Search For and Replace Data 00:12:00 Spell Check a Worksheet 00:06:00 Activity - Spell Check a Worksheet 00:08:00 Modify Fonts 00:10:00 Activity - Modify Fonts 00:18:00 Add Borders and Colors to Cells 00:12:00 Activity - Add Borders and Colors to Cells 00:14:00 Apply Number Formats 00:30:00 Activity - Apply Number Formats 00:08:00 Align Cell Contents 00:12:00 Activity - Align Cell Contents 00:10:00 Apply Cell Styles 00:00:00 Activity - Apply Cell Styles 00:00:00 Define the Basic Page Layout for a Workbook 00:32:00 Activity - Define the Basic Page Layout for a Workbook 00:08:00 Refine the Page Layout and Apply Print Options 00:18:00 Activity - Refine the Page Layout and Apply Print Options 00:10:00 Format Worksheet Tabs 00:06:00 Activity - Format Worksheet Tabs 00:06:00 Manage Worksheets@ 00:16:00 Activity - Manage Worksheets 00:08:00 Manage the View of Worksheets and Workbooks 00:14:00 Activity - Manage the View of Worksheets and Workbooks 00:06:00 Customize General and Language Options 00:14:00 Activity - Customize General and Language Options 00:10:00 Customize Formula Options 00:04:00 Activity - Customize Formula Options 00:08:00 Customize Proofing and Save Options 00:10:00 Activity - Customize Proofing and Save Options 00:08:00 Customize the Ribbon and Quick Access Toolbar 00:06:00 Activity - Customize the Ribbon and Quick Access Toolbar 00:14:00 Customize the Functionality of Excel by Enabling Add-Ins 00:12:00 Activity - Customize the Functionality of Excel by Enabling Add-Ins 00:12:00 Customize Advanced and Trust Center Options@ 00:08:00 Activity - Customize Advanced and Trust Center Options 00:10:00 Activities and Exercise Files - Microsoft Excel 2016 for Beginners 00:00:00 Excel Intermediate Apply Range Names 00:34:00 Use Specialized Functions 00:44:00 Use Text Functions@ 00:34:00 Use Logical Functions@ 00:22:00 Use Lookup Functions 00:20:00 Use Date Functions@ 00:12:00 Use Financial Functions 00:26:00 Create and Modify Tables 00:26:00 Sort and Filter Data@ 00:26:00 Use Subtotal and Database Functions to Calculate Data 00:34:00 Create Charts 00:30:00 Modify and Format Charts 00:22:00 Create a Trendline 00:22:00 Create Advanced Charts@ 00:34:00 Create a PivotTable 00:38:00 Filter Data by Using Slicers 00:14:00 Analyze Data with PivotCharts 00:20:00 Insert and Modify Graphic Objects 00:38:00 Layer and Group Graphic Objects 00:14:00 Incorporate SmartArt 00:16:00 Customize Workbooks 00:26:00 Manage Themes 00:10:00 Create and Use Templates 00:24:00 Protect Files 00:36:00 Preparing a Workbook for Multiple Audiences 00:34:00 Activities and Exercise Files - Microsoft Excel 2016 Intermediate 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.

Excel Essentials for Office Administrators
Delivered Online On Demand21 hours 26 minutes
£25

Microsoft Excel Level 1, 2 & 3

4.7(160)

By Janets

Register on the Microsoft Excel Level 1, 2 & 3 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 proof of your course completion. The Microsoft Excel Level 1, 2 & 3 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 Level 1, 2 & 3 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 Microsoft Excel Level 1, 2 & 3, 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 Microsoft Excel Beginners - Level 1 Getting Started With Microsoft Office Excel 2016 Navigate the Excel User Interface 00:28:00 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 Performing Calculations Create Worksheet Formulas 00:15:00 Insert Functions 00:17:00 Reuse Formulas and Functions 00:17:00 Modifying A Worksheet Insert, Delete, and Adjust Cells, Columns, and Rows 00:10:00 Search for and Replace Data 00:09:00 Use Proofing and Research Tools 00:07:00 Formatting A Worksheet Apply Text Formats 00:17:00 Apply Number Format 00:08:00 Align Cell Contents 00:09:00 Apply Styles and Themes 00:12:00 Apply Basic Conditional Formatting 00:11:00 Create and Use Templates 00:07:00 Printing Workbooks Preview and Print a Workbook 00:10:00 Set Up the Page Layout 00:08:00 Configure Headers and Footers 00:07:00 Managing Workbooks Manage Worksheets 00:05:00 Manage Workbook and Worksheet Views 00:07:00 Manage Workbook Properties 00:05:00 Microsoft Excel Intermediate - Level 2 Working with Functions Work with Ranges 00:18:00 Use Specialized Functions 00:11:00 Work with Logical Functions 00:23:00 Work with Date & Time Functions 00:08:00 Work with Text Functions 00:11:00 Working with Lists Sort Data 00:10:00 Filter Data 00:10:00 Query Data with Database Functions 00:09:00 Outline and Subtotal Data 00:09:00 Analyzing Data Create and Modify Tables 00:15:00 Apply Intermediate Conditional Formatting 00:07:00 Apply Advanced Conditional Formatting 00:05:00 Visualizing Data with Charts Create Charts 00:13:00 Modify and Format Charts 00:12:00 Use Advanced Chart Features 00:12:00 Using PivotTables and PivotCharts Create a PivotTable 00:13:00 Analyze PivotTable Data 00:12:00 Present Data with PivotCharts 00:07:00 Filter Data by Using Timelines and Slicers 00:11:00 Microsoft Excel Advanced - Level 3 Working with Multiple Worksheets and Workbooks Use Links and External References 00:12:00 Use 3-D References 00:06:00 Consolidate Data 00:05:00 Using Lookup Functions and Formula Auditing Use Lookup Functions 00:12:00 Trace Cells 00:09:00 Watch and Evaluate Formulas 00:08:00 Sharing and Protecting Workbooks Collaborate on a Workbook 00:19:00 Protect Worksheets and Workbooks 00:08:00 Automating Workbook Functionality Apply Data Validation 00:13:00 Search for Invalid Data and Formulas with Errors 00:04:00 Work with Macros 00:18:00 Creating Sparklines and Mapping Data Create Sparklines 00:07:00 MapData 00:07:00 Forecasting Data Determine Potential Outcomes Using Data Tables 00:08:00 Determine Potential Outcomes Using Scenarios 00:09:00 Use the Goal Seek Feature 00:04:00 Forecasting Data Trends 00:05:00 Resources Resources - Microsoft Office 2016 Excel Beginner to Advanced 00:00:00 Assignment Assignment - Microsoft Office 2016 Excel Beginner to Advanced 00:00:00 Recommended Materials Workbook - Microsoft Office 2016 Excel Beginner to Advanced 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 Level 1, 2 & 3
Delivered Online On Demand10 hours 25 minutes
£25

Microsoft Office 2016 Excel Beginners

4.7(160)

By Janets

Learn Microsoft Excel to create and format spreadsheets, analyse and share information to make knowledgeable resolutions. This Microsoft Office 2016 Excel Beginners is intended to teach you creating high-level workbooks and worksheets. Upon completion, you will have the ability to explain massive amounts of data and present that information to increase your understanding of the organisational account. 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 Getting Started with Microsoft Office Excel 2016 Navigate the Excel User Interface 00:28:00 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 Performing Calculations Create Worksheet Formulas 00:15:00 Insert Functions 00:17:00 Reuse Formulas and Functions 00:17:00 Modifying a Worksheet Insert, Delete, and Adjust Cells, Columns, and Rows 00:10:00 Search for and Replace Data 00:09:00 Use Proofing and Research Tools 00:07:00 Formatting a Worksheet Apply Text Formats 00:17:00 Apply Number Format 00:08:00 Align Cell Contents 00:09:00 Apply Styles and Themes 00:12:00 Apply Basic Conditional Formatting 00:11:00 Create and Use Templates 00:07:00 Printing Workbooks Preview and Print a Workbook 00:10:00 Set Up the Page Layout 00:08:00 Configure Headers and Footers 00:07:00 Managing Workbooks Manage Worksheets 00:05:00 Manage Workbook and Worksheet Views 00:07:00 Manage Workbook Properties 00:05:00 Mock Exam Mock Exam - Microsoft Office 2016 Excel Beginners 00:20:00 Final Exam Final Exam - Microsoft Office 2016 Excel Beginners 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 Office 2016 Excel Beginners
Delivered Online On Demand4 hours 55 minutes
£25

Internal Audit Skills

4.7(160)

By Janets

The Internal Audit Skills Course 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 an acknowledged certificate. This Internal Audit Skills Course consists of several modules that take around 4 hours 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 a digital 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 Certificate of Achievement Endorsed Certificate of Achievement from the Quality Licence Scheme Once the course has been completed and the assessment has been passed, all students are entitled to receive an endorsed certificate. This will provide proof that you have completed your training objectives, and each endorsed certificate can be ordered and delivered to your address for only £99.00. Please note that overseas students may be charged an additional £10 for postage. CPD Certificate of Achievement from Janets 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. Endorsement This course and/or training programme has been endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. This course and/or training programme is not regulated by Ofqual and is not an accredited qualification. Your training provider will be able to advise you on any further recognition, for example progression routes into further and/or higher education. For further information please visit the Learner FAQs on the Quality Licence Scheme website. Method of Assessment To successfully complete the course, students will have to take an automated multiple-choice exam. This exam will be online and you will need to score 60% or above to pass the course. After successfully passing the exam, you will be able to apply for Quality Licence Scheme endorsed certificate of achievement. To verify your enhanced skills in the subject, we recommend that you also complete the assignment questions. These can be completed at any time which is convenient for yourself and will be assessed by our in-house specialised tutors. Full feedback will then be given on your current performance, along with any further advice or support. Course Content Module 01: Auditing as a Form of Assurance Auditing as a Form of Assurance 00:12:00 Module 02: Internal Audit Procedures Internal Audit Procedures 00:23:00 Module 03: Technology-based Internal Audit Technology-Based Internal Audit 00:24:00 Module 04: Internal Control and Control Risk Internal Control and Control Risk 00:37:00 Module 05: Audit Interviews Audit Interviews 00:19:00 Module 06: Reporting Audit Outcome Reporting HR Audit Outcome 00:24:00 Module 07: UK Internal Audit Standards UK Internal Audit Standards 00:25:00 Module 08: Career as an Auditor Career as an Auditor 00:18:00 Mock Exam Mock Exam - Internal Audit Skills 00:20:00 Final Exam Final Exam - Internal Audit Skills 00:20:00 Assignment Assignment - Internal Audit Skills 2 weeks, 1 day Order Your Certificate Order your Certificate QLS 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.

Internal Audit Skills
Delivered Online On Demand3 weeks
£25

Excel: Top 50 Microsoft Excel Formulas in 50 Minutes!

4.7(160)

By Janets

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.

Excel: Top 50 Microsoft Excel Formulas in 50 Minutes!
Delivered Online On Demand1 hour 55 minutes
£25

Microsoft Excel

4.7(160)

By Janets

An essential part of your skillset as an office worker and administrator is an excellent understanding of the many uses of Microsoft Excel. This superb course will enable your abilities to use it as a primary tool to create workbooks and formulas. But you will also be guided in the use of more complicated functions involving automation, formatting, and calculation. By the end of the lessons, you will be more than accomplished at producing stunning graphs and worksheets that will perform the bulk of the work for you. Learning Outcomes: Learn how to create worksheets and workbooks Use functions and formulas to calculate results Create attractive charts and graphs for meetings Write automated workbooks that drive activities Impress senior colleagues with dynamic presentations of data Why Choose this Course? Earn a digital 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 Online study materials Mock exams Multiple-choice assessment Certificate of Achievement Endorsed Certificate of Achievement from the Quality Licence Scheme Once the course has been completed and the assessment has been passed, all students are entitled to receive an endorsed certificate. This will provide proof that you have completed your training objectives, and each endorsed certificate can be ordered and delivered to your address for only £99.00. Please note that overseas students may be charged an additional £10 for postage. CPD Certificate of Achievement from Janets 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. Endorsement This course and/or training programme has been endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. This course and/or training programme is not regulated by Ofqual and is not an accredited qualification. Your training provider will be able to advise you on any further recognition, for example progression routes into further and/or higher education. For further information please visit the Learner FAQs on the Quality Licence Scheme website. Method of Assessment To successfully complete the course, students will have to take an automated multiple-choice exam. This exam will be online and you will need to score 60% or above to pass the course. After successfully passing the exam, you will be able to apply for Quality Licence Scheme endorsed certificate of achievement. To verify your enhanced skills in the subject, we recommend that you also complete the assignment questions. These can be completed at any time which is convenient for yourself and will be assessed by our in-house specialised tutors. Full feedback will then be given on your current performance, along with any further advice or support. Who is This Course for?  This course is designed for senior administrators or PAs that need to store and manipulate company data or employee statistics.  Requirements This Microsoft Excel Course is fully compatible with any kind of device. Whether you are using Windows computer, 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 The course is suitable for those in the roles of; Personal Assistant Secretary Heads of Departments Administrator Receptionist Course Content Microsoft Excel Navigate the Excel User Interface 00:28:00 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 Create Worksheet Formulas 00:15:00 Insert Functions 00:17:00 Reuse Formulas and Functions 00:17:00 Insert, Delete, and Adjust Cells, Columns, and Rows 00:10:00 Search for and Replace Data 00:09:00 Use Proofing and Research Tools 00:07:00 Apply Text Formats 00:17:00 Apply Number Format 00:08:00 Align Cell Contents 00:09:00 Apply Styles and Themes 00:12:00 Apply Basic Conditional Formatting 00:11:00 Create and Use Templates 00:07:00 Preview and Print a Workbook 00:10:00 Set Up the Page Layout 00:08:00 Configure Headers and Footers 00:07:00 Manage Worksheets 00:05:00 Manage Workbook and Worksheet Views 00:07:00 Manage Workbook Properties 00:05:00 Mock Exam Mock Exam - Microsoft Excel 00:20:00 Final Exam Final Exam - Microsoft Excel 00:20:00 Assignment Assignment - Microsoft Excel 2 weeks, 1 day Order Your Certificate Order your Certificate QLS 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
Delivered Online On Demand3 weeks
£25

Stock and Bond Investment Essentials

4.3(43)

By John Academy

Overview If you know how to play the game, the stocks and bond investment can bring lucrative profits. Master the knowledge and skills required to thrive in the stock market with our Stock and Bond Investment Essentials course. Whether you are a seasoned player or new in the game, this course will come in handy. First this course will explain the basic fundamentals of stock and bond investment. Then you will learn about different investment types and effective techniques for successful investment. Through this course, you will get a clear understanding of the principles of finance and be able to develop the skills to win at stocks and bond markets. Furthermore, the course will help you develop essential skills for risk and portfolio management. So, if you are ready to embark on the journey of stock and bond investment, enrol now! Course Preview Learning Outcomes Familiarise yourself with the major concepts of stock and bond investment Learn about different types and techniques of investment Enhance your knowledge and understanding of finance Grasp effective strategies of stock and bond market Build your expertise in risk and portfolio management Why Take This Course From John Academy? Affordable, well-structured and high-quality e-learning study materials Meticulously crafted engaging and informative tutorial videos and materials 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? Stock and bond investment Financial management Who Should Take this Stock and Bond Investment Essentials? Whether you're an existing practitioner or an aspiring professional, this course is an ideal training 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 Stock and Bond Investment Essentials 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. Stock and Bond Investment Essentials Certification After completing and passing the Stock and Bond Investment Essentials course successfully, you will be able to obtain a Recognised Certificate of Achievement. Learners can obtain the certificate in hard copy at £14.99 or PDF format at £11.99. Career Path​ This exclusive Stock and Bond Investment Essentials course will equip you with effective skills and abilities and help you explore career paths such as  Investment banker Finance manager Finance advisor Investment analyst Module 01: Introduction to Investment Introduction to Investment 00:07:00 Module 02: Types and Techniques Types and Techniques 00:10:00 Module 03: Key Concepts in Investment Key Concepts in Investment 00:09:00 Module 04: Understanding the Finance Understanding the Finance 00:10:00 Module 05: Stock Trading Basics Stock Trading Basics 00:18:00 Module 06: Investing in Bond Market Investing in Bond Market 00:08:00 Module 07: Investing in Stock Market Investing in Stock Market 00:10:00 Module 08: Risk and Portfolio Management Risk and Portfolio Management 00:10:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Stock and Bond Investment Essentials
Delivered Online On Demand1 hour 22 minutes
£24.99

Key Account Management Course

5.0(10)

By Apex Learning

Overview This comprehensive course on Key Account Management Course will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Key Account Management Course 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 Key Account Management Course. It is available to all students, of all academic backgrounds. Requirements Our Key Account Management Course 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 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 14 sections • 13 lectures • 05:44:00 total length •Introduction to Key Account Management: 00:32:00 •Purpose of Key Account Management: 00:26:00 •Understanding Key Accounts: 00:28:00 •Elements of Key Account Management: 00:37:00 •What Makes a Good Key Account Manager: 00:35:00 •Building and Delivering Value to Key Accounts: 00:21:00 •Key Account Planning: 00:22:00 •Business Customer Marketing and Development: 00:29:00 •Developing Key Relationships: 00:42:00 •The Importance of Record Keeping for Key Account Management: 00:18:00 •Internal KAM Aspects: 00:26:00 •The Value Proposition: 00:28:00 •Assignment - Key Account Management: 00:00:00

Key Account Management Course
Delivered Online On Demand5 hours 44 minutes
£12

Professional Certificate in Understanding the Working Capital Management in London 2024

4.9(261)

By Metropolitan School of Business & Management UK

The course explores the nature and importance of the working capital management concept to manage the financial operation of a firm. After the successful completion of this lecture, you will be able to understand the following: The concept of working capital. The concept of working capital management. The importance of working capital management. The factors affecting working capital requirement in an organisation. The various types of working capital. The types of the net and gross working capital. Various sources of working capital. This course explored the concept of working capital Management.  VIDEO - Course Structure and Assessment Guidelines Watch this video to gain further insight. Navigating the MSBM Study Portal Watch this video to gain further insight. Interacting with Lectures/Learning Components Watch this video to gain further insight. Understandinging the Working Capital Management This course provides an overview of working capital management. Quiz: Understanding The Working Capital Management Put your knowledge to the test with this quiz. Read each question carefully and choose the response that you feel is correct. All MSBM courses are accredited by the relevant partners and awarding bodies. Please refer to MSBM accreditation in about us for more details. There are no strict entry requirements for this course. Work experience will be added advantage to understanding the content of the course. The certificate is designed to enhance the knowledge of the learner in the field. This certificate is for everyone eager to know more and gets updated on current ideas in their respective field. We recommend this certificate for the following audience. CEO, Director, Manager, Supervisor Finance Manager Accountant Investment Specialist Operations Manager Team Lead Average Completion Time 2 Weeks Accreditation 1 CPD Hour Level Advanced Start Time Anytime 100% Online Study online with ease. Unlimited Access 24/7 unlimited access with pre-recorded lectures. Low Fees Our fees are low and easy to pay online.

Professional Certificate in Understanding the Working Capital Management in London 2024
Delivered Online On Demand14 days
£26

Diploma in Financial Risk Management

4.3(43)

By John Academy

Course overview In business, you have to face different types of financial and production risks. If you cannot understand this style of your business and avoid the risks, it is very difficult for you to make a profit and stay in the market. Learn the important financial and risk management strategies from this Diploma in Financial Risk Management course and be able to make a higher profit in your business. This Diploma in Financial Risk Management course will give you a clear understanding of operational management and risk management procedures. You will learn about different types of risks and how to manage them. This risk management course will help you to analyze any situation and evaluate the risk factors. For understanding your business environment and determining the most risk-free and profitable business strategy this course is perfect for you. Learning outcomes Learn about limit, continuity and differentiability Know how to graph a parabola using conic sections Understand what is a paraboloid in calculus Identify the differentiation rules and use them to solve problems Learn about different coordinate systems Be able to compute a composite function's derivative using chain rule Learn how to use Taylor's formula Who Is This Course For? Anyone interested in learning risk management most efficiently can take this Diploma in Financial Risk Management course. The skills gained from this training will provide excellent opportunities for career advancement.  Entry Requirement This course is available to all learners of all academic backgrounds. Learners should be aged 16 or over. Good understanding of English language, numeracy and ICT skills are required to take this course. Certification After you have successfully completed the course, you will obtain an Accredited Certificate of Achievement. And, you will also receive a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hardcopy for £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 and materials from the industry-leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; United Kingdom & internationally recognized accredited qualification; Access to course content on mobile, tablet and desktop from anywhere, anytime; Substantial career advancement opportunities; 24/7 student support via email. Career Path The Diploma in Financial Risk Management course provides essential skills that will make you more effective in your role. It would be beneficial for any related profession in the industry, such as: Risk Managers Compliance Officers Financial Analysts Business Analyst Business Owners Operational Risk Controllers Managing Directors Diploma in Financial Risk Management Module 1- Introduction to Risk Management Introduction to Risk Management 00:22:00 Module 2: Risk and Types of Risk Risk and Types of Risk 00:22:00 Module 3: Benefits of Risk Management Benefits of Risk Management 00:15:00 Module 4: Enterprise Risk Management Enterprise Risk Management 00:25:00 Module 5: Risk Management Process Risk Management Process 00:13:00 Module 6: Risk Analysis & Assessment Risk Analysis & Assessment 00:30:00 Module 7: The Risk Evaluation Process The Risk Evaluation Process 00:34:00 Module 8: Managing Financial Risks Managing Financial Risks 00:33:00 Module 9 - The Fundamentals of Operational Risk Management The Fundamentals of Operational Risk Management 00:33:00 Module 10 - Managing Technology Risks Managing Technology Risks 00:21:00 Module 11: Managing Legal & Political Risk Managing Legal & Political Risk 00:25:00 Module 12: Environmental Risk Assessment Environmental Risk Assessment 00:28:00 Module 13: Risk Assessment at Workplace Risk Assessment at Workplace 00:17:00 Module 14: Market & Social Risk Assessment Market & Social Risk Assessment 00:38:00 Module 15 - Preparing Risk Management Plan: Step by Step Preparing Risk Management Plan: Step by Step 00:24:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Diploma in Financial Risk Management
Delivered Online On Demand6 hours 20 minutes
£18