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

1336 Courses

Certificate in Microsoft PowerPoint 2010 for Beginners

By iStudy UK

Microsoft PowerPoint 2010 is the most powerful and leading presentation developer created by Microsoft. Microsoft PowerPoint is the most useful software, which assists in creating professional presentations. Through this course, you will get hold of the basic information of how to use Microsoft Word. Explore the basics of how to use the basic features and functions of this software. Learn how to create a basic presentation from scratch by using PowerPoint software. Course Highlights Certificate in Microsoft PowerPoint 2010 for Beginners 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 Certificate in Microsoft PowerPoint 2010 for Beginners 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 9 hours 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  Certificate in Microsoft PowerPoint 2010 for Beginners 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? Certificate in Microsoft PowerPoint 2010 for Beginners 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 Certificate in Microsoft PowerPoint 2010 for Beginners 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. Microsoft PowerPoint 2010 for Beginners Module One - Getting Started 01:00:00 Module Two - Opening and Closing PowerPoint 00:30:00 Module Three - Working with Presentations 00:30:00 Module Four - Your First Presentation 01:00:00 Module Five - Working with Text 00:30:00 Module Six - Formatting Text 00:30:00 Module Seven - Formatting Paragraphs 01:00:00 Module Eight - Advanced Formatting Tasks 00:30:00 Module Nine - Customizing Slide Elements 01:00:00 Module Ten - Setting Up Your Slide Show 00:30:00 Module Eleven - Showtime! 01:00:00 Module Twelve - Wrapping Up 01:00:00 Activities Activities-Certificate in Microsoft PowerPoint 2010 for Beginners 00:00:00 Mock Exam Final Exam

Certificate in Microsoft PowerPoint 2010 for Beginners
Delivered Online On Demand9 hours
£25

PowerPoint Presentation Skills Training Course For Teachers

By Lead Academy

This course will empower educators to create compelling and engaging presentations for their students. Educators will learn how to deliver information effectively using Powerpoint, capture student attention and enhance the learning experience. This Course At A Glance Accredited by CPD UK Endorsed by Quality Licence Scheme Learn how to structure a presentation and include supporting data and insights Know basic PPT skills such as exploring PowerPoint's views, understanding Notes Pane, customizing the PowerPoint interface, or changing themes and colors Understand the design principles for compelling visuals and slides, such as duplicating and reordering slides or reusing and copying slides Learn how to use themes and layouts, add animations, print, reuse, and copy slides Understand Infographics and Media in PPT presentations such as adding and editing charts, advance chart options, structuring tables, and adding audio and video Get acquainted with new design features such as morph transitions, insert icons, 3D Animations, Pre-Animated 3D Models, and Insert Zoom Slides Understand how to work with pictures, remove the picture backgrounds, or create a photo album Learn how to navigate the ribbon, explore the menu bar, and understand the different tasks that can be performed PowerPoint Presentation Skills Training Course For Teachers Overview This extensive PowerPoint presentation skills training course is suitable for teachers willing to enhance and advance their presentation skills to produce polished lectures, presentations, and content that engages students. This course will help you map out your message intro, and prepare your opening slides, core content slides and closing slides. This PowerPoint presentation skills training course will help you learn how to use illustrations, pictures and graphics to engage your presentation. You also will learn slide formatting, animations, diagrams, and creating and designing charts, graphs, and tables. Finally, you will learn how to comprehend your audience, select your delivery strategies, use handouts to reach your audience and improve your verbal and non-verbal communication abilities. Upon successful completion of this PowerPoint presentation skills training course, you will learn the basic skills to create a PPT presentation program by doing need analysis, understanding your audience, and choosing your delivery methods. Who should take this course? This PowerPoint presentation skills training course is primarily aimed at: Teachers Home Tutor Public Speakers Aspiring Teachers Any Professionals Teaching Assistant SEN Teaching Assistant Anyone associated with the teaching industry However, this course is not restricted to a specific industry or field of employment. This course is open to anybody who wants to acquire knowledge and skills about powerpoint presentations. Entry Requirements There are no academic entry requirements for this PowerPoint presentation skills training course, and it is open to students of all academic backgrounds. However, you are required to have a laptop/desktop/tablet or smartphone and a good internet connection. Assessment Method This PowerPoint presentation skills training course assesses learners through multiple-choice questions (MCQs). Upon successful completion of the modules, learners must answer MCQs to complete the assessment procedure. Through the MCQs, it is measured how much a learner could grasp from each section. In the assessment pass mark is 60%. Course Curriculum Introduction and Welcome Introduction Map Out Your Message Map Out Your Message Intro Prepare Your Opening Slides Prepare Your Opening Slides Activity Prepare Your Core Content Slides Prepare Your Core Content Slides Activity Prepare Your Closing Slides Prepare Your Closing Slides Activity Add Variety to Your Visuals Add Variety to Your Visuals Intro Use Pictures to Add Impact Use Pictures to Add Impact Activity Keep Graphics Simple Keep Graphics Simple Activity Use Illustrations to Increase Comprehension Use Illustrations to Increase Comprehension Activity Use Handouts to Reach Every Learner Your Turn Activity Supplementary Resources Supplementary Resources - PowerPoint Presentation Skills For Teachers Assessment Assessment - PowerPoint Presentation Skills For Teachers Recognised Accreditation CPD Certification Service This course is accredited by continuing professional development (CPD). CPD UK is globally recognised by employers, professional organisations, and academic institutions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. CPD certificates are accepted by thousands of professional bodies and government regulators here in the UK and around the world. Many organisations look for employees with CPD requirements, which means, that by doing this course, you would be a potential candidate in your respective field. Quality Licence Scheme Endorsed The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. It will give you a competitive advantage in your career, making you stand out from all other applicants and employees.     Certificate of Achievement Endorsed Certificate from Quality Licence Scheme After successfully passing the MCQ exam you will be eligible to order the Endorsed Certificate by Quality Licence Scheme. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. It will give you a competitive advantage in your career, making you stand out from all other applicants and employees. There is a Quality Licence Scheme endorsement fee to obtain an endorsed certificate which is £65. Certificate of Achievement from Lead Academy After successfully passing the MCQ exam you will be eligible to order your certificate of achievement as proof of your new skill. The certificate of achievement is an official credential that confirms that you successfully finished a course with Lead Academy. Certificate can be obtained in PDF version at a cost of £12, and there is an additional fee to obtain a printed copy certificate which is £35.   FAQs Is CPD a recognised qualification in the UK? CPD is globally recognised by employers, professional organisations and academic intuitions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. CPD-certified certificates are accepted by thousands of professional bodies and government regulators here in the UK and around the world. Are QLS courses recognised? Although QLS courses are not subject to Ofqual regulation, they must adhere to an extremely high level that is set and regulated independently across the globe. A course that has been approved by the Quality Licence Scheme simply indicates that it has been examined and evaluated in terms of quality and fulfils the predetermined quality standards. When will I receive my certificate? For CPD accredited PDF certificate it will take 24 hours, however for the hardcopy CPD certificate takes 5-7 business days and for the Quality License Scheme certificate it will take 7-9 business days. Can I pay by invoice? Yes, you can pay via Invoice or Purchase Order, please contact us at info@lead-academy.org for invoice payment. Can I pay via instalment? Yes, you can pay via instalments at checkout. How to take online classes from home? Our platform provides easy and comfortable access for all learners; all you need is a stable internet connection and a device such as a laptop, desktop PC, tablet, or mobile phone. The learning site is accessible 24/7, allowing you to take the course at your own pace while relaxing in the privacy of your home or workplace. Does age matter in online learning? No, there is no age limit for online learning. Online learning is accessible to people of all ages and requires no age-specific criteria to pursue a course of interest. As opposed to degrees pursued at university, online courses are designed to break the barriers of age limitation that aim to limit the learner's ability to learn new things, diversify their skills, and expand their horizons. When I will get the login details for my course? After successfully purchasing the course, you will receive an email within 24 hours with the login details of your course. Kindly check your inbox, junk or spam folder, or you can contact our client success team via info@lead-academy.org

PowerPoint Presentation Skills Training Course For Teachers
Delivered Online On Demand
£25

Best Selling Microsoft PowerPoint 2007 Professional

By iStudy UK

Microsoft PowerPoint is a program that helps you create, edit and show presentations. These presentations could be for work, school or any occasions. This advanced course will help you make presentations creatively. You will learn how to use the Pictures, Text Box, Table, and Drawing Tools tab and know how to do advanced drawing tasks. Know how to use the Research Task Pane and notes to slides. All of these advanced skills in PowerPoint will help you maximize the potentials of the program. In this course you will learn the necessary skills, knowledge and information of Microsoft PowerPoint.  Course Highlights Best Selling Microsoft PowerPoint 2007 Professional 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 Best Selling Microsoft PowerPoint 2007 Professional 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 Best Selling Microsoft PowerPoint 2007 Professional 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? Best Selling Microsoft PowerPoint 2007 Professional 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 Best Selling Microsoft PowerPoint 2007 Professional 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 - Adding Pictures 01:00:00 Module Three - Working with Text Boxes 01:00:00 Module Four - Adding SmartArt 01:00:00 Module Five - Adding Tables 01:00:00 Module Six - Inserting Advanced Objects 01:00:00 Module Seven - Advanced Drawing Tasks 01:00:00 Module Eight - PowerPoint's Research Tools 01:00:00 Module Nine - Creating Notes and Handouts 01:00:00 Module Ten - Using Slide Masters 01:00:00 Module Eleven - Advanced Presentation Tasks 01:00:00 Module Twelve - Wrapping Up 00:30:00 Activities Activities-Selling Microsoft PowerPoint 2007 Professional 00:00:00 Mock Exam Mock Exam- Best Selling Microsoft PowerPoint 2007 Professional 00:20:00 Final Exam Final Exam- Best Selling Microsoft PowerPoint 2007 Professional 00:20:00

Best Selling Microsoft PowerPoint 2007 Professional
Delivered Online On Demand11 hours 40 minutes
£25

Microsoft Word 2010 Intermediate Level

4.3(43)

By John Academy

Description: In this course, you will learn the necessary expert skills, knowledge, and information about Word 2010. This course will help you utilize the most advanced tools and features for your documents. You will learn how to edit and develop documents like an expert. Learn to take advantage of the many customization options in the Word Options dialogue box. You will know how master documents allow you to use smaller files to create a large, complicated document. Who is the course for? Professionals who want to learn about the Word 2010 People who have an interest in the features of Word 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 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 Word 2010 Intermediate Level course is a useful qualification to possess and would be beneficial for professions or careers from industries which are: Administrative Assistant PA Secretary Administrator Office Manager. Microsoft Word 2010 Intermediate Level Module One - Getting Started 00:30:00 Module Two - Working with Document Information and Word Customization 01:00:00 Module Three - Working with Reusable Content 01:00:00 Module Four - Working with Templates 01:00:00 Module Five - Working with Sections and Linked Content 01:00:00 Module Six - Managing Versions and Tracking Documents 01:00:00 Module Seven - Using Cross References 01:00:00 Module Eight - Working with Mail Merges 01:00:00 Module Nine - Working with Master Documents 01:00:00 Module Ten - Working with Macros 01:00:00 Module Eleven - Working with Forms 01:00:00 Module Twelve - Wrapping Up 01:00:00 Activities Activities - Microsoft Word 2010 Intermediate Level 00:00:00 Mock Exam Mock Exam- Microsoft Word 2010 Intermediate Level 00:20:00 Final Exam Final Exam- Microsoft Word 2010 Intermediate Level 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Microsoft Word 2010 Intermediate Level
Delivered Online On Demand12 hours 10 minutes
£19

Microsoft Excel 2016 (Basic to Advanced)

By Compete High

🚀 Unleash Your Excel Mastery with 'Microsoft Excel 2016 (Basic to Advanced)' Course! 🚀 Are you tired of spending hours grappling with Excel, only to end up with frustrating and inefficient solutions? Do you dream of becoming the Excel wizard in your workplace, effortlessly creating powerful and efficient solutions? Look no further! Introducing our groundbreaking online course: 'Microsoft Excel 2016 (Basic to Advanced).'   🌟 Why Choose 'Microsoft Excel 2016 (Basic to Advanced)'? ✅ Master Advanced Excel Techniques: Dive deep into the world of Excel with our comprehensive modules that cover everything from advanced formulas and functions to data visualization and analysis. ✅ Practical Real-World Applications: Say goodbye to theoretical lessons! We focus on real-world scenarios, ensuring you can immediately apply your newfound skills to solve complex problems in your professional life. ✅ Build Efficiency: Learn the secrets of crafting efficient and streamlined Excel solutions. From automating repetitive tasks to optimizing complex workflows, you'll become a productivity powerhouse. ✅ Expert-Led Instruction: Our experienced instructors are Excel aficionados with a passion for teaching. Benefit from their wealth of knowledge and insider tips, ensuring you stay ahead of the curve. ✅ Interactive Learning: Engage with hands-on exercises, quizzes, and projects that reinforce your understanding and transform you into a confident Excel pro. ✅ Lifetime Access: Gain unlimited access to the course content, updates, and a supportive community. Your learning journey doesn't end - it evolves.   🎓 What You'll Learn: Advanced Formulas and Functions: Supercharge your spreadsheet skills with complex formulas and functions, unlocking Excel's true potential. Data Visualization Mastery: Transform raw data into visually stunning charts and graphs, making your reports and presentations more impactful. Automation Techniques: Streamline your work by mastering Excel's automation features, saving time and reducing errors. Data Analysis Strategies: Unlock the power of PivotTables, data models, and analysis tools to gain valuable insights from your data. Optimizing Workflows: Learn to design efficient workflows and templates that enhance collaboration and productivity.   🌐 Who Is This Course For? Professionals aiming to boost their Excel proficiency. Entrepreneurs seeking to optimize business processes. Students preparing for a data-driven career. Anyone who wants to stay ahead in today's competitive workplace.   Don't miss out on this opportunity to elevate your Excel skills and stand out in the crowd. Join 'Microsoft Excel 2016 (Basic to Advanced)' today and pave the way for a successful and efficient future! Course Curriculum Microsoft Excel 2016 Basic Pre Sell Video 00:00 Lesson 1 - Overview 00:00 Lesson 2 - Interface 00:00 Lesson 3 - File Menu - Part 1 00:00 Lesson 4 - File Menu - Part 2 00:00 Lesson 5 - Home Menu 00:00 Lesson 6 - Insert Menu 00:00 Lesson 7 - Page Layout Menu 00:00 Lesson 8 - Formulas Menu 00:00 Lesson 9 - Data Menu - Part 1 00:00 Lesson 10 - Data Menu - Part 2 00:00 Lesson 11 - Review Menu 00:00 Lesson 12 - View Menu 00:00 Lesson 13 - Templates 00:00 Lesson 14 - Dates 00:00 Lesson 15 - Numbers 00:00 Lesson 16 - Text 00:00 Lesson 17 - B - Calculations-Manual 00:00 Lesson 18 - Calculations 00:00 Lesson 19 - Page Set Up 00:00 Lesson 20 - Print Settings 00:00 Lesson 21 - Conclusion 00:00 Microsoft Excel 2016 Advanced Lesson 1 - Overview 00:00 Lesson 2 - Calculations - Absolute References 00:00 Lesson 3 - Calculations - Relative References 00:00 Lesson 4 - Using Logical Formulas 00:00 Lesson 5 - Using Text Formulas 00:00 Lesson 6 - Using Lookup Formulas 00:00 Lesson 7 - Using Financial Formulas 00:00 Lesson 8 - Using Date and Time Formulas 00:00 Lesson 9 - Sorting Data 00:00 Lesson 10 - Formatting Data into Tables 00:00 Lesson 11 - Using Pivot Tables - Part 1 00:00 Lesson 12 Using Pivot Tables - Part 2 - Design 00:00 Lesson 13 - Formatting Data as Charts 00:00 Lesson 14 - Formatting As Data as Maps 00:00 Lesson 15 - Formatting Data as Formal Reports 00:00 Lesson 16 - Formatting Data for Other Office Documents 00:00 Lesson 17 - Cell Protection and Collaboration 00:00 Lesson 18 - Cell Protection and Collaboration - Part 2 00:00 Lesson 19 - Interface with Google Sheets 00:00 Lesson 20 - Conclusion 00:00

Microsoft Excel 2016 (Basic to Advanced)
Delivered Online On Demand1 hour 41 minutes
£25

Microsoft Access for Beginners

4.3(43)

By John Academy

Description: Microsoft Access is a database management system (DBMS) from Microsoft. It stores data in its format based on the Access Jet Database Engine. It can also import or link directly to data stored in other applications and databases. Through this course, you will learn the necessary skills, knowledge, and information about Microsoft Access. You will then know the different components of the database so that you understand the structure underlying your data. Who is the course for? New staff or workers who want to learn about the Microsoft Access. People who have an interest in the basics and features of the Access. 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 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 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 Access for Beginners course is a useful qualification to possess and would be beneficial for following careers: Software Engineer Technical Support Technical Sales Business Analyst Web Developer Software Tester. Microsoft Access for Beginners Module One - Getting Started 00:30:00 Module Two - Opening and Closing Access 01:00:00 Module Three - An Introduction to Databases 01:00:00 Module Four - Sharing Data Using Apps 01:00:00 Module Five - Working in Your App 01:00:00 Module Six - An Introduction to Desktop Databases 01:00:00 Module Seven - Performing Basic Table Tasks 01:00:00 Module Eight - Working with Fields 01:00:00 Module Nine - Working with Table Relationships 01:00:00 Module Ten - An Introduction to Queries, Forms, and Reports 01:00:00 Module Eleven - Protecting Your Data 01:00:00 Module Twelve - Wrapping Up 00:30:00 Activities Activities - Microsoft Access for Beginners 00:00:00 Mock Exam Mock Exam- Microsoft Access for Beginners 00:20:00 Final Exam Final Exam- Microsoft Access for Beginners 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Microsoft Access for Beginners
Delivered Online On Demand11 hours 40 minutes
£19

Microsoft Access 2016 Beginner to Advanced

4.3(43)

By John Academy

Description: Microsoft Access is a database management system application; it stores data in its own form on the Access Jet database engine. This application is used by mainly software developers to develop application software. Microsoft Access 2016 Beginner to Advanced course is a complete collection with all the contents necessary to give you an overview of this application. In this course, you will learn about its interface, create and edit databases, sorting and filtering data in a query, performing calculations, summarization of data, data normalization, advanced reporting, etc. By the end of this course, users should be comfortable with navigating the Access 2016 interface, creating a new database from scratch, querying a database, generating reports, sharing data, and much more. Learning Outcomes: Get familiarized with Microsoft Access 2016, create simple databases, and use the help options Change table data, manage records and create lookups Join data from different tables, sort and filter them, and perform calculations for queries Creating, adding controls, enhancing appearance and print preparation for reports How to utilize Access Options dialog box Relational database design, creating tables, managing table fields and creating table relationships Creating query joins and sub queries, joining tables with no common fields, relating data within a table, and working with sub datasheets Data normalization and creating junction tables Sharing Access data with other applications and through import and export options Managing reports through organizing information, formatting, including charts, adding calculated fields and sub-report inclusion to existing ones Create mailing label report and publishing reports in PDF format Designing forms through adding and setting controls, creating subforms, using tab pages to organize information, improve navigation, formatting and applying conditional formatting Data, field, form and record validation Creating macros, restricting records using conditions, validate data, automate data entry and convert a macro to VBA in order to enhance user interface design Link tables to external data sources, manage database, determine object dependency, document database, and analyze database performance Allow multiple user access to database by splitting it, implement security, set passwords, convert Access database to ACCDE file, and add digital signatures Create and modify switchboards and startup options 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 Access 2016 Beginner to Advanced 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 Access 2016 Beginner to Advanced 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. Module - 1 Orientation to Microsoft Access 01:00:00 Create a Simple Access Database 01:00:00 Get Help in Microsoft Access 00:30:00 Modify Table Data 00:30:00 Work with Records 01:00:00 Sort and Filter Records 00:30:00 Create Lookups 01:00:00 Join Data from Different Tables in a Query 01:00:00 Sort and Filter Data in a Query 01:00:00 Perform Calculations in a Query 00:30:00 Create Parameter Queries 00:30:00 Create Action Queries 00:30:00 Create Find Duplicate and Find Unmatched Queries 00:30:00 Summarize Data 00:30:00 Create a Report 01:00:00 Add Controls to a Report 00:30:00 Enhance the Appearance of a Report 00:30:00 Prepare a Report for Print 00:30:00 The Access Options Dialog Box 01:00:00 Relational Database Design 00:30:00 Create a Table 01:00:00 Modify a Table and Fields 00:30:00 Create Table Relationships 00:30:00 Create Query Joins 00:30:00 Join Tables That Have No Common Fields 00:30:00 Relate Data within a Table 00:30:00 Work with Subdatasheets 00:30:00 Create Subqueries 00:30:00 Data Normalization 01:00:00 Create a Junction Table 00:30:00 Import Data into Access 00:30:00 Export Data to Text File Formats 00:30:00 Export Access Data to Excel 00:30:00 Create a Mail Merge 00:30:00 Organize Report Information 00:30:00 Format Reports 00:30:00 Include Charts in a Report 00:30:00 Add a Calculated Field to a Report 00:30:00 Add a Subreport to an Existing Report 00:30:00 Create a Mailing Label Report 00:30:00 Publish a Report as PDF 00:30:00 Activities - Microsoft Access 2016 for Beginners 00:00:00 Module - 2 Add Controls to Forms 01:00:00 Set Form Controls 01:00:00 Create Subforms 00:30:00 Organize Information with Tab Pages 00:30:00 Enhance Navigation with Forms 00:30:00 Format a Form 01:00:00 Apply Conditional Formatting 00:30:00 Field Validation 00:30:00 Form and Record Validation 00:30:00 Create a Macro 01:00:00 Restrict Records Using a Condition 00:30:00 Validate Data Using a Macro 00:30:00 Automate Data Entry Using a Macro 00:30:00 Convert a Macro to VBA 00:30:00 Link Tables to External Data Sources 00:30:00 Manage a Database 00:30:00 Determine Object Dependency 00:30:00 Document a Database 00:30:00 Analyze the Performance of a Database 00:30:00 Split a Database for Multiple User Access 00:30:00 Implement Security 00:30:00 Set Passwords 00:30:00 Convert an Access Database to an ACCDE File 00:30:00 Package a Database with a Digital Signature 00:30:00 Create a Database Switchboard 01:00:00 Modify a Database Switchboard 00:30:00 Set Startup Options 00:30:00 Activities - Microsoft Access 2016 Advanced 00:00:00 Refer A Friend Refer A Friend 00:00:00 Mock Exam Mock Exam- Microsoft Access 2016 Beginner to Advanced 00:30:00 Final Exam Final Exam- Microsoft Access 2016 Beginner to Advanced 00:30:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Microsoft Access 2016 Beginner to Advanced
Delivered Online On Demand42 hours
£19

Microsoft Access 2010 Advanced Level

4.3(43)

By John Academy

Description: Microsoft Access is a database management system that has lots of features and functions to offer. To create mailing labels, work with SQL and publish a Web database in Microsoft Access, you need to learn at an advanced level. Through this course, you will learn the advanced skills, knowledge, and information about Microsoft Access 2010. You can then create and use the advanced forms and tasks to do even more in Access.In this course you will learn the necessary skills, knowledge and information of Microsoft Access 2010.  Who is the course for? Professionals who want to learn about the Microsoft Access 2010 People who have an interest in the advanced features of the Access 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 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 Access 2010 Advanced Level course is a useful qualification to possess and would be beneficial for following careers: Software Engineer Technical Support Technical Sales Business Analyst Web Developer Software Tester. Microsoft Access 2010 Advanced Level Module One - Getting Started 00:30:00 Module Two - Advanced Table Tasks 01:00:00 Module Three - Advanced Form Tasks 01:00:00 Module Four - Advanced Reporting Tasks 01:00:00 Module Five - Understanding Relationships 01:00:00 Module Six - Advanced Query Tasks 01:00:00 Module Seven - Working with SQL 01:00:00 Module Eight - Linking Data 01:00:00 Module Nine - Importing Data 01:00:00 Module Ten - Exporting Data 01:00:00 Module Eleven - Advanced Database Tools 01:00:00 Module Twelve - Wrapping Up 00:30:00 Activities Activities - Microsoft Access 2010 Advanced Level 00:00:00 Mock Exam Mock Exam-Microsoft Access 2010 Advanced Level 00:20:00 Final Exam Final Exam-Microsoft Access 2010 Advanced Level 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Microsoft Access 2010 Advanced Level
Delivered Online On Demand11 hours 40 minutes
£19

Level 3 Diploma in Microsoft Excel 2007

4.3(43)

By John Academy

Description:  Whether you use excel for work or study, this online course covers beginner, intermediate and advanced lessons in excel. Learn the main topics related to Microsoft excel 2007. Identify the basic excel techniques, explore the advanced functions of excel 2007 and create automated reports with the press of a button in this course. By completing this course, you will become an excel expert and use excel 2007 as a professional. Who is the 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 2007 will be very beneficial and helpful, especially to the following professionals: Admin Assistant. PA. Secretary. Administrator. Account Assistant. Bookkeeper. Accountant. Office Manager. Microsoft Excel 2007 for Beginners Module One - Getting Started 01:00: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 01:00:00 Module Ten - Formatting your Data 01:00:00 Module Eleven - More Formatting 01:00:00 Module Twelve - Wrapping Up 00:30:00 Activities-Microsoft Excel 2007 for Beginners 00:00:00 Microsoft Excel 2007 Advanced Level Module One - Getting Started 00:30:00 Module Two - SmartArt 01:00:00 Module Three - Inserting Objects 01:00:00 Module Four - Creating Charts 01:00:00 Module Five - Creating Pivot Tables 01:00:00 Module Six - Working with Pivot Tables 01:00:00 Module Seven - Creating Pivot Charts 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 01:00:00 Module Twelve - Wrapping Up 00:30:00 Activities-Microsoft Excel 2007 Advanced Level 00:00:00 Mock Exam Final Exam Order Your Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Level 3 Diploma in Microsoft Excel 2007
Delivered Online On Demand22 hours 30 minutes
£25

Level 3 Diploma in Microsoft PowerPoint

4.3(43)

By John Academy

Description:  Our Microsoft power point course is designed to take your computer skills from basics to all the way to Advanced level, one step at a time. Whether you are new to Microsoft or looking forward to enhancing your current skills in using this program, then you are selecting the right course. Through this course, you will explore the different features of Microsoft PowerPoint which will help you in both personal and professional life as a businessman, student or employee. In this course, you will learn the necessary skills, knowledge, and information of Microsoft Power Point. Who is the course for? This course is perfect for individuals who are looking forward to developing their skills of using Microsoft PowerPoint application. This course is for office professionals who want to nail all the meetings and projects at the workplace. 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 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 Level 3 Diploma in Microsoft PowerPoint will be very beneficial and helpful, especially to the following professionals: Admin Assistant PA Secretary Administrator Office Manager. Microsoft PowerPoint for Beginners Module One - Getting Started 00:30:00 Module Two - Opening PowerPoint 01:00:00 Module Three - Working with the Interface 01:00:00 Module Four - Your First Presentation 01:00:00 Module Five - Working with Text 01:00:00 Module Six - Formatting Text and Paragraphs 01:00:00 Module Seven - Adding Pictures 01:00:00 Module Eight - Advanced Formatting Tasks 01:00:00 Module Nine - Working with Transitions and Animations 01:00:00 Module Ten - Setting Up Your Slide Show 01:00:00 Module Eleven - Showtime! 01:00:00 Module Twelve - Wrapping Up 00:30:00 Activities-Microsoft PowerPoint for Beginners 00:00:00 Microsoft PowerPoint for Intermediate Level Module One - Getting Started 00:30:00 Module Two - Working with the PowerPoint Environment 01:00:00 Module Three - Working with Sections and Presentation Organization 01:00:00 Module Four - Formatting Presentations 01:00:00 Module Five - Formatting Shapes and Text Boxes 01:00:00 Module Six - Creating a Photo Album 01:00:00 Module Seven - Working with Graphical Elements 01:00:00 Module Eight - Working with Audio and Video Content 01:00:00 Module Nine - Working with Transitions and Animations 01:00:00 Module Ten - Collaborating on Presentations 01:00:00 Module Eleven - Working with Presentation Info and Other Formats 01:00:00 Module Twelve - Wrapping Up 00:30:00 Activities-Microsoft PowerPoint Intermediate Level 00:00:00 Microsoft PowerPoint Advanced Level Module One - Getting Started 00:30:00 Module Two - Working with Shapes 01:00:00 Module Three - Working with Text Boxes 01:00:00 Module Four - Adding SmartArt 01:00:00 Module Five - Advanced Drawing Tasks 01:00:00 Module Six - Adding Tables 01:00:00 Module Seven - Inserting Audio and Video 01:00:00 Module Eight - PowerPoint's Research Tools 01:00:00 Module Nine - Preparing for Your Presentation 01:00:00 Module Ten - Using Slide Masters 01:00:00 Module Eleven - Advanced Presentation Tasks 01:00:00 Module Twelve - Wrapping Up 00:30:00 Activities-Microsoft PowerPoint Advanced Level 00:00:00 Mock Exam Mock Exam - Level 3 Diploma in Microsoft PowerPoint 00:20:00 Final Exam Final Exam - Level 3 Diploma in Microsoft PowerPoint 00:20:00 Order Your Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Level 3 Diploma in Microsoft PowerPoint
Delivered Online On Demand33 hours
£21