5771 Courses

Description: In this course, you will learn the advanced features and functions of Microsoft Excel 2010. You will learn how to plan your worksheet and be clear on your objectives and the importance of saving as much as possible. You will know how to use macros to automate repetitive tasks, What If Analysis and how to outline to quickly manage detail data. You will also know the guided exercises provided in this course to refresh your skills. Who is the course for? Professionals who want to learn about the advanced features of Microsoft Excel 2010. People who have an interest in knowing all the functions in Microsoft Excel 2010. 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 hardcopy at a cost of £39 or in PDF format at a 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 recognised 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 Excel 2010 Advanced Level course is a useful qualification to possess and would be beneficial for any Office job, such as: Admin Assistant PA Secretary Administrator Account Assistant Bookkeeper Accountant Office Manager. Microsoft Excel 2010 Advanced Level Module One - Getting Started 00:30:00 Module Two - SmartArt and Objects 01:00:00 Module Three - Auditing 01:00:00 Module Four - Creating Charts 01:00:00 Module Five - Creating Pivot Tables 01:00:00 Module Six - Working with PivotTables and PivotCharts 01:00:00 Module Seven - Macros 01:00:00 Module Eight - Solving Formula Errors 01:00:00 Module Nine - Using What If Analysis 01:00:00 Module Ten - Managing Your Data 00:30:00 Module Eleven - Grouping and Outlining Data 00:30:00 Module Twelve - Wrapping Up 00:30:00 Activities Activities-Microsoft Excel 2010 Advanced Level 00:00:00 Mock Exam Mock Exam-Microsoft Excel 2010 Advanced Level 00:20:00 Final Exam Final Exam-Microsoft Excel 2010 Advanced Level 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Description:  Whether you use excel for work or study, this online course covers beginner, intermediate and advanced lessons in excel. Microsoft Excel 2010 is the spreadsheet application in the MS Office 2010 suite. You will begin with the fundamentals, assembling a strong foundation that will give you further knowledge as you advance into intermediate and advanced level topics. By the end of this course, you will have mastered the most important Excel 2010 tools and come out with confidence to finish any Excel assignments with proficiency and grace. Who is this course for? This course is perfect for individuals who are looking forward to developing their skills of using Microsoft Excel application. This course is for office professionals who want to nail all the meetings and projects at the workplace. This course will be ideal for professionals in business, finance and many other areas that need to analyse data in accounts. Entry Requirement: This course is available to all learners, of all academic backgrounds. However, an education and experience in accounting is an advantage. 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 a cost of £39 or in PDF format at a 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 recognised 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 diploma in Microsoft Excel 2010 will be very beneficial and helpful, especially to the following professionals: Admin Assistant. PA. Secretary. Administrator. Account Assistant. Bookkeeper. Accountant. Office Manager. Microsoft Excel 2010 for Beginners Module One - Getting Started 00:30:00 Module Two - Opening and Closing Excel 01:00:00 Module Three - Your First Worksheet 01:00:00 Module Four - Working with Excel Files 01:00:00 Module Five - Viewing Excel Data 01:00:00 Module Six - Printing Excel Data 01:00:00 Module Seven - Building Formulas 01:00:00 Module Eight - Using Excel Functions 01:00:00 Module Nine - Using Time Saving Tools 00:30:00 Module Ten - Formatting Your Data 01:00:00 Module Eleven - Advanced Formatting Tools 01:00:00 Module Twelve - Wrapping Up 00:30:00 Microsoft Excel 2010 Intermediate Level Module One - Getting Started 00:30:00 Module Two - Working with Permissions and Options 01:00:00 Module Three - Sharing Workbooks 00:30:00 Module Four - Performing Advanced Formula and Function Tasks 01:00:00 Module Five - Working with Array Formulas 01:00:00 Module Six - Working with Functions 01:00:00 Module Seven - Working with Macros 01:00:00 Module Eight - Working with Forms 01:00:00 Module Nine - Applying Advanced Chart Features 01:00:00 Module Ten - Working with PivotTables and PivotCharts 01:00:00 Module Eleven - Using the Automated Analysis Tools Add -In 00:30:00 Module Twelve - Wrapping Up 00:30:00 Microsoft Excel 2010 Advanced Level Module One - Getting Started 00:30:00 Module Two - SmartArt and Objects 01:00:00 Module Three - Auditing 01:00:00 Module Four - Creating Charts 01:00:00 Module Five - Creating Pivot Tables 01:00:00 Module Six - Working with PivotTables and PivotCharts 01:00:00 Module Seven - Macros 01:00:00 Module Eight - Solving Formula Errors 01:00:00 Module Nine - Using What If Analysis 01:00:00 Module Ten - Managing Your Data 01:00:00 Module Eleven - Grouping and Outlining Data 00:30:00 Module Twelve - Wrapping Up 00:30:00 Activities Activities-Microsoft Excel 2010 for Beginners 00:00:00 Activities-Microsoft Excel 2010 Intermediate Level 00:00:00 Activities-Microsoft Excel 2010 Advanced Level 00:00:00 Mock Exam Mock Exam- Level 3 Diploma in Microsoft Excel 2010 00:30:00 Final Exam Final Exam- Level 3 Diploma in Microsoft Excel 2010 00:30:00 Order Your Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Description: This course follows up from the Beginners Excel 2010 course by delving even deeper into features and functions of this powerful spreadsheet software. This Microsoft Office 2010 Excel Advanced - Complete Video Course builds on the skills and concepts taught in Excel 2010: intermediate. In this series you will learn to work with advanced formulas, as well lookup functions such as VLOOKUP, MATCH, and INDEX. In addition, you will learn about data validation and database functions such as DSUM. You will learn how to work with Pivot Tables and PivotCharts, how to import and export data, and how to query external databases. Finally, you will learn about the analytical features of Excel, running and recording macros, SmartArt graphics and conditional formatting with graphics, and more. Before you taking this course you should have a firm grasp of the basics. This course will pull up your basic knowledge. So join this course to be an expert. 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 2010 Excel 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 2010 Excel 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. Logical and Statistical Functions Logical Functions FREE 00:17:00 Math and Statistical Functions 00:19:00 Financial and Date Functions Financial Functions 00:04:00 Date and Time Functions 00:10:00 Array Formulas 00:09:00 Displaying and Printing Formulas 00:08:00 Lookups and Data Tables Using Lookup Functions 00:14:00 Using MATCH and INDEX 00:06:00 Array Formulas 00:07:00 Advanced Data Management Validating Cell Entries 00:08:00 Exploring Database Functions 00:06:00 Exporting and Importing Exporting and Importing Text Files 00:11:00 Exporting and Importing XML Data 00:03:00 Querying External Databases 2 hours agoMore 00:09:00 Analytical Tools Goal Seek and Solver 00:15:00 The Analysis ToolPak 00:05:00 Scenarios 1 hour agoMore 00:06:00 Macros and Custom Functions Running and Recording a Macro 00:19:00 Working with VBA Code 00:07:00 Creating Functions 00:05:00 Mock Exam Mock Exam- Microsoft Office 2010 Excel Advanced - Complete Video Course 00:20:00 Final Exam Final Exam- Microsoft Office 2010 Excel Advanced - Complete Video Course 00:20:00 Order Your Certificates and Transcripts Order Your Certificates and Transcripts 00:00:00

Description: The Microsoft Excel program was designed to help people in their worksheets and spreadsheets. This course will teach you how to use SmartArt, pictures, text boxes and shapes to enhance your ability. You will learn to utilize many objects which have contextual tool tabs that appear when you select an object. Learn how to solve formula errors before they happen by using named ranges instead of cell references. Who is the course for? Professionals who want to learn about the Microsoft Excel 2013 advanced features. People who have an interest in knowing all the functions of Microsoft Excel 2013. 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 a cost of £39 or in PDF format at a 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 Excel Advanced course is a useful qualification to possess and would be beneficial for any Office job, such as: Admin Assistant PA Secretary Administrator Account Assistant Bookkeeper Accountant Office Manager. Microsoft Excel - Advanced Level Module One - Getting Started 01:00:00 Module Two - SmartArt and Objects 01:00:00 Module Three - Auditing 01:00:00 Module Four - Creating Charts 01:00:00 Module Five - Working with Charts 01:30:00 Module Six - Creating Pivot Tables and Pivot Charts 01:00:00 Module Seven - Macros 01:00:00 Module Eight - Solving Formula Errors 01:00:00 Module Nine - Using What If Analysis 01:00:00 Module Ten - Managing Your Data 02:00:00 Module Eleven - Grouping and Outlining Data 01:00:00 Module Twelve - Wrapping Up 00:30:00 Activities Activities-Microsoft Excel - Advanced Level 00:00:00 Mock Exam Mock Exam- Microsoft Excel - Advanced Level 00:20:00 Final Exam Final Exam- Microsoft Excel - Advanced Level 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Get ready to declutter and organise your space with our online course - say goodbye to the mess!

Overview This Life Skills: Transform Your Life course will unlock your full potential and will show you how to excel in a career in Life Skills: Transform Your Life. So upskill now and reach your full potential. Everything you need to get started in Life Skills: Transform Your Life is available in this course. Learning and progressing are the hallmarks of personal development. This Life Skills: Transform Your Life will quickly teach you the must-have skills needed to start in the relevant industry. In This Life Skills: Transform Your Life Course, You Will: Learn strategies to boost your workplace efficiency. Hone your Life Skills: Transform Your Life skills to help you advance your career. Acquire a comprehensive understanding of various Life Skills: Transform Your Life topics and tips from industry experts. Learn in-demand Life Skills: Transform Your Life skills that are in high demand among UK employers, which will help you to kickstart your career. This Life Skills: Transform Your Life course covers everything you must know to stand against the tough competition in the Life Skills: Transform Your Life field.  The future is truly yours to seize with this Life Skills: Transform Your Life. Enrol today and complete the course to achieve a Life Skills: Transform Your Life certificate that can change your professional career forever. Additional Perks of Buying a Course From Institute of Mental Health Study online - whenever and wherever you want. One-to-one support from a dedicated tutor throughout your course. Certificate immediately upon course completion 100% Money back guarantee Exclusive discounts on your next course purchase from Institute of Mental Health Enrolling in the Life Skills: Transform Your Life course can assist you in getting into your desired career quicker than you ever imagined. So without further ado, start now. Process of Evaluation After studying the Life Skills: Transform Your Life course, your skills and knowledge will be tested with a MCQ exam or assignment. You must get a score of 60% to pass the test and get your certificate.  Certificate of Achievement Upon successfully completing the Life Skills: Transform Your Life course, you will get your CPD accredited digital certificate immediately. And you can also claim the hardcopy certificate completely free of charge. All you have to do is pay a shipping charge of just £3.99. Who Is This Course for? This Life Skills: Transform Your Life is suitable for anyone aspiring to start a career in Life Skills: Transform Your Life; even if you are new to this and have no prior knowledge on Life Skills: Transform Your Life, this course is going to be very easy for you to understand.  And if you are already working in the Life Skills: Transform Your Life field, this course will be a great source of knowledge for you to improve your existing skills and take them to the next level.  Taking this Life Skills: Transform Your Life course is a win-win for you in all aspects.  This course has been developed with maximum flexibility and accessibility, making it ideal for people who don't have the time to devote to traditional education. Requirements This Life Skills: Transform Your Life course has no prerequisite.  You don't need any educational qualification or experience to enrol in the Life Skills: Transform Your Life course. Do note: you must be at least 16 years old to enrol. Any internet-connected device, such as a computer, tablet, or smartphone, can access this online Life Skills: Transform Your Life course. Moreover, this course allows you to learn at your own pace while developing transferable and marketable skills. Course Curriculum Introduction Introduction 00:01:00 Goal Setting & Decision Making Set BIG Goals 00:06:00 Make Real Decisions 00:06:00 Consistency Is Key 00:05:00 Nothing Is Impossible 00:06:00 KEY Life Skills How To Be Accountable 00:06:00 Live In Tbe Moment 00:06:00 Being Adventurous 00:06:00 Words Of Success 00:05:00 Life-Long Leaning 00:06:00 No Such Thing As Failure 00:06:00 Conclusion Conclusion 00:01:00

Overview This Shape Your Social Confidence course will unlock your full potential and will show you how to excel in a career in Shape Your Social Confidence. So upskill now and reach your full potential. Everything you need to get started in Shape Your Social Confidence is available in this course. Learning and progressing are the hallmarks of personal development. This Shape Your Social Confidence will quickly teach you the must-have skills needed to start in the relevant industry. In This Shape Your Social Confidence Course, You Will: Learn strategies to boost your workplace efficiency. Hone your Shape Your Social Confidence skills to help you advance your career. Acquire a comprehensive understanding of various Shape Your Social Confidence topics and tips from industry experts. Learn in-demand Shape Your Social Confidence skills that are in high demand among UK employers, which will help you to kickstart your career. This Shape Your Social Confidence course covers everything you must know to stand against the tough competition in the Shape Your Social Confidence field.  The future is truly yours to seize with this Shape Your Social Confidence. Enrol today and complete the course to achieve a Shape Your Social Confidence certificate that can change your professional career forever. Additional Perks of Buying a Course From Institute of Mental Health Study online - whenever and wherever you want. One-to-one support from a dedicated tutor throughout your course. Certificate immediately upon course completion 100% Money back guarantee Exclusive discounts on your next course purchase from Institute of Mental Health Enrolling in the Shape Your Social Confidence course can assist you in getting into your desired career quicker than you ever imagined. So without further ado, start now. Process of Evaluation After studying the Shape Your Social Confidence course, your skills and knowledge will be tested with a MCQ exam or assignment. You must get a score of 60% to pass the test and get your certificate.  Certificate of Achievement Upon successfully completing the Shape Your Social Confidence course, you will get your CPD accredited digital certificate immediately. And you can also claim the hardcopy certificate completely free of charge. All you have to do is pay a shipping charge of just £3.99. Who Is This Course for? This Shape Your Social Confidence is suitable for anyone aspiring to start a career in Shape Your Social Confidence; even if you are new to this and have no prior knowledge on Shape Your Social Confidence, this course is going to be very easy for you to understand.  And if you are already working in the Shape Your Social Confidence field, this course will be a great source of knowledge for you to improve your existing skills and take them to the next level.  Taking this Shape Your Social Confidence course is a win-win for you in all aspects.  This course has been developed with maximum flexibility and accessibility, making it ideal for people who don't have the time to devote to traditional education. Requirements This Shape Your Social Confidence course has no prerequisite.  You don't need any educational qualification or experience to enrol in the Shape Your Social Confidence course. Do note: you must be at least 16 years old to enrol. Any internet-connected device, such as a computer, tablet, or smartphone, can access this online Shape Your Social Confidence course. Moreover, this course allows you to learn at your own pace while developing transferable and marketable skills. Course Curriculum Module 01: Why Confidence is Important 1.1 Why Confidence is Important 00:23:00 Module 02: Overcoming Self-Doubt 2.1 Overcoming Self-Doubt 00:32:00 2.2 Overcoming Self-Doubt 00:28:00 Module 03: Relationship with yourself 3.1 Relationship with yourself 00:23:00 3.2 Relationship with Yourself 00:23:00 Module 04: Carry Yourself With Confidence 4.1 Carry Yourself With Confidence 00:18:00 4.2 Carry Yourself With Confidence 00:22:00 Module 05: Build Strong Relationships 5.1 Build Strong Relationships 00:15:00 5.2 Build Strong Relationships 00:11:00 5.3 Build Strong Relationships 00:16:00

You will learn how to become a Python developer through this course.

Advance your Python skills with Level 2 Programming! From strings and operators to control flow and games, this course sharpens your coding prowess, culminating in a hands-on Python project. Ideal for those seeking to deepen their understanding and application of Python.

Do you need to create a fantastic Newspaper or flyer design quickly? Our Microsoft Publisher 2010 will help you to learn the details about Microsoft Publisher so that you can easily do your task. Microsoft Publisher is a desktop publishing application that places emphasis on page layout and design and helps you to create, personalise your layouts and shares a wide range of publications and marketing materials in-house. The knowledge about the advanced functions and features of Microsoft Publisher 2010 will give you a significant advantage when designing and publishing your newsletter, flyer, posters, product catalogues, proposal or training manual. In the course, you will know how to use the page layout, building blocks, picture, media tools, Object grouping, aligning, distributing, and ordering tools to get your objects looking great with a minimum amount of effort. By the end of the course, you will be able to personalise and customise your layouts or designs like flyers or e-mail templates. Course Highlights CPD Accredited Microsoft Publisher 2010 Advanced Level is an award winning and the best selling course that has been given the CPD Certification & IAO accreditation. It is the most suitable course anyone looking to work in this or relevant sector. It is considered one of the perfect courses in the UK that can help students/learners to get familiar with the topic and gain necessary skills to perform well in this field. We have packed CPD Accredited Microsoft Publisher 2010 Advanced Level into 13 modules for teaching you everything you need to become successful in this profession. To provide you ease of access, this course is designed for both part-time and full-time students. You can become accredited in just 11 hours, 40 minutes hours and it is also possible to study at your own pace. We have experienced tutors who will help you throughout the comprehensive syllabus of this course and answer all your queries through email. For further clarification, you will be able to recognize your qualification by checking the validity from our dedicated website. Why You Should Choose CPD Accredited Microsoft Publisher 2010 Advanced Level Lifetime access to the course No hidden fees or exam charges CPD Accredited certification on successful completion Full Tutor support on weekdays (Monday - Friday) Efficient exam system, assessment and instant results Download Printable PDF certificate immediately after completion Obtain the original print copy of your certificate, dispatch the next working day for as little as £9. Improve your chance of gaining professional skills and better earning potential. Who is this Course for? CPD Accredited Microsoft Publisher 2010 Advanced Level is CPD certified and IAO accredited. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic backgrounds. Requirements Our CPD Accredited Microsoft Publisher 2010 Advanced Level is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path You will be ready to enter the relevant job market after completing this course. You will be able to gain necessary knowledge and skills required to succeed in this sector. All our Diplomas' are CPD and IAO accredited so you will be able to stand out in the crowd by adding our qualifications to your CV and Resume. Module One - Getting Started 00:30:00 Module Two - Working With Text 01:00:00 Module Three - Working with Pictures 01:00:00 Module Four - Graphics and Objects 01:00:00 Module Five - Moving and Grouping Objects 01:00:00 Module Six - Page Layout 01:00:00 Module Seven - Media Files 01:00:00 Module Eight - Mail and E-mail Merges 01:00:00 Module Nine - Creating a Catalog 01:00:00 Module Ten - Publication Information 01:00:00 Module Eleven - Save and Send Files 01:00:00 Module Twelve - Wrapping Up 00:30:00 Activities Activities - CPD Accredited Microsoft Publisher 2010 Advanced Level 00:00:00 Mock Exam Mock Exam- CPD Accredited Microsoft Publisher 2010 Advanced Level 00:20:00 Final Exam Final Exam- CPD Accredited Microsoft Publisher 2010 Advanced Level 00:20:00