8444 Print courses

Level 2 Microsoft Office Essentials

2 QLS Endorsed Course | CPD Certified | Free PDF + Hardcopy Certificates | 80 CPD Points | Lifetime Access

2 QLS Endorsed Course | CPD Certified | Free PDF + Hardcopy Certificates | 80 CPD Points | Lifetime Access

2 QLS Endorsed Course | CPD Certified | Free PDF + Hardcopy Certificates | 80 CPD Points | Lifetime Access

2 QLS Endorsed Course | CPD Certified | Free PDF + Hardcopy Certificates | 80 CPD Points | Lifetime Access

Description This course is aimed at the excel user who already knows the basics of Excel 2007. This course will help you to go beyond the basics - to reach a higher-intermediate level. With shortcuts, tricks and tips - you will be able to work smarter and faster. If you want to be fairly competent on the software, then this course will be very handy. Its a lot quicker to be shown things, then to try and muddle through and work things out by yourself. Guaranteed, there'll be some items which we cover, that you have no idea that Excel was capable of doing! We don't want you to spend a day of your life in the classroom... learn 99 quick and very useful, practical things which you can apply on your job or on your projects. We'll cover: Working with Data - using series, symbols and special characters, hide rows and freeze panels Formulas and Functions - Calculate the duration between two dates/times, best loan terms, create conditional formula and conditional sums Copying Data - transposing rows into columns and paste specials Using Excel lists - sort and filter a list, remove duplicate records, count filtered records, look up information in a list Data Patterns - Pivot tables, pivot charts, what-if analysis Creating charts - histogram, trendlines, piecharts, error bars Presenting data - formatting columns and numbers Saving and printing worksheets - printing multiple worksheets, area, cell ranges, repeat headings of a row or column Extending excel - hyperlinks, embed a chart, importing a worksheet Customizing Excel - custom workspace, custom view, macros The target audience is those who have a basic level with Excel and want to learn other handy functions and features. We use Excel 2007 only in this course. If you have Excel 2003, this course will be difficult to follow as although the functions and features exist in 2003, the layout changed very dramatically between the two versions. Excel 2007 isn't too dissimilar from 2010. Where necessary, we provide a spreadsheet - but as long as you have Excel 2007, you'll be able to copy and do exactly what you see on the screen by pausing the video and following along. The course will take approx 7.5 hours to complete. Take this course if you want to take your basic understanding of Excel to a higher intermediate-level. What Will I Learn? Work with Formulas and Functions Copy data and formats Use excel lists Create charts Present worksheets nicely Save and print worksheets Who is the target audience? This is for those who are beginners in Excel and want to take it further to higher intermediate level - using Excel 2007 You should know the 'basics' in Excel and we take it from near-beginner, to higher intermediate Requirements Students will need to have Excel 2007 installed, as this is the system used in the teaching Introduction to the course and your tutor Data Enter numbers and fractions 00:05:00 Dates and Times 00:08:00 Name Cells and Ranges 00:04:00 Validate Data entry using a pick list FREE 00:07:00 Extend a series of dates with autofill 00:04:00 Add a symbol or special character 00:04:00 Compare multiple spreadsheets using freeze panels 00:06:00 Hide rows 00:04:00 Keyboard 00:10:00 Speak Cells 00:04:00 Find and replace data 00:10:00 Formulas and Functions Add values 00:03:00 Function wizard 00:06:00 Formulas with comments 00:04:00 OneNote 00:06:00 Define a constant 00:04:00 Apply names in functions 00:05:00 Figure out the best loan terms 00:04:00 Internal Rates of Return 00:04:00 Nth largest value 00:04:00 Large, Small, Max, Min 00:04:00 Conditional formula 00:03:00 Conditional formula with names 00:04:00 Conditional sum 00:03:00 Count If 00:02:00 Inner calculator 00:02:00 Square Roots 00:03:00 Calculate the duration between two times 00:04:00 Calculate days between two dates 00:04:00 Copying Data, Formats etc., Copy a range 00:03:00 Transpose a row into a column FREE 00:02:00 Chart formatting 00:07:00 Copy styles to another workbook 00:07:00 Paste special and copying worksheets 00:06:00 Track changes while Editing 00:06:00 Lists Enter list data using a form 00:05:00 Searching through a data list 00:04:00 Import a word list into excel 00:04:00 Sort a list 00:02:00 Filter a list 00:02:00 Sort by multiple criteria FREE 00:03:00 Find averages in a sorted group 00:05:00 Filter by multiple criteria 00:03:00 Remove duplicate records from a list 00:03:00 Count filtered records 00:07:00 Filter by multiple criteria in the same column 00:06:00 Chart a filtered list 00:02:00 Look up information in a List 00:05:00 Data Patterns Create a PivotTable 00:05:00 Modify a PivotTable and layout 00:03:00 Find the average of a field 00:04:00 Create a calculated field 00:03:00 Calculated fields and charts FREE 00:02:00 Hide rows and columns in a PivotTable 00:02:00 AutoFormat a PivotTable 00:01:00 Create a PivotChart 00:03:00 Turning on the Data Analysis function so that statistical information can be run 00:02:00 Describe Data with Statistics 00:03:00 Discover associations within your data 00:03:00 Product Numbers 00:02:00 What-if analysis 00:05:00 Goal seek 00:06:00 Creating Charts Create a Chart 00:06:00 Modify Chart details 00:04:00 Change the Chart Type 00:03:00 Add a Trendline to a Chart 00:06:00 Remove Chart Data 00:02:00 Add chart data 00:02:00 Missing chart data 00:04:00 Error bars 00:04:00 Pull a slice from a Pie Chart 00:03:00 Label slices of a Pie Chart 00:04:00 Histogram 00:06:00 Paste a chart into Word 00:03:00 Amending a chart in Word 00:02:00 Paste-link a Chart into Word 00:05:00 Worksheets Format Numbers as Percentages 00:04:00 Format Currencies in Currency and Accounting Formats 00:03:00 Format Column Headings 00:05:00 Format Quickly with Format painter FREE 00:02:00 Insert a background image into your worksheet 00:03:00 Create a Transparent image 00:03:00 Saving and Printing Worksheets Save a workbook as a Template 00:07:00 Save a workbook as an XML spreadsheet 00:05:00 Print multiple cell ranges on One Page 00:03:00 Print multiple worksheets of a workbook 00:01:00 Page set up, header, footer, margins - 1 page printing 00:04:00 Repeat Headings of a Row or Column 00:07:00 Print functions to show calculations & comments 00:07:00 Extending Excel Hyperlink a worksheet to another office document 00:03:00 Embed a chart within PowerPoint 00:05:00 Publish an Interactive Workbook 00:05:00 Import a Worksheet into Access 00:09:00 Use Excel Data to create labels in Word 00:10:00 Customizing Excel Launch a specific Workbook when Excel Opens 00:03:00 Save Time by Creating a Custom View 00:03:00 Create a Custom Number Format 00:06:00 Changing Text to Columns 00:05:00 Create a Macro to Format Numbers 00:06:00 Online Live Webinar Course-S3_W4_L1 - 42 - Excel Made simple 01:00:00

This short, step-by-step guide is designed to give all parents and those working with babies an introduction into the basic skills to help your baby if they have a medical emergency. This course covers the key elements of basic first aid for babies, for example choking, burns, how to put a baby into the recovery position and so much more. This course is not designed to replace a practical course but it will help empower you with skills and confidence to assess what is wrong and implement basic first aid to help. Prompt and appropriate First Aid reduces the pain and suffering experienced by your baby and could save their life. For our most comprehensive online course please visit our First Aid for Babies coursewhich won the Bizzie Baby Silver Award 2016. The course consists of illustrated step by step directions, flow charts, diagrams, videos and test yourself sections fully compatible with all computers and mobile devices. You will be able to stop and start as often as you like and print your Certificate on completion. You have continuous access to this course for 12 months. It is impossible to cover all eventualities within this course, or to equip you with the knowledge and skills to appropriately diagnose and treat in unpredictable real life situations. If you suspect serious illness or injury, you should always seek immediate professional medical advice. The author has made every effort to ensure the accuracy of the information contained within the course, however this course is merely a guide and the author does not accept any liability or responsibility for any inaccuracies or for any mistreatment or misdiagnosis of any person, however caused. The course material has been written by Emma Hammett, qualified nurse, first aid trainer and founder of First Aid for Life in conjunction with other medical and first aid professionals. If you have any queries concerning this course, please contact emma@firstaidforlife.org.uk Course contents: Action in an emergency Keep yourself safe Priorities of treatment What to put in your first aid kit Information to give the emergency services The primary survey – how to help in an emergency Danger Response Airway Breathing Unresponsive and breathing Recovery position How to put a baby into the recovery position Choking Burns Fitting/seizures/convulsions Meningitis Head injuries Final lesson

Are you captivated by the celestial tapestry of the night sky? Do you marvel at the cosmic dance of the stars or yearn to decode the enigma of the Big Bang? Our Astronomy GCSE course, tailored for self-paced learning, could be your perfect stargazing companion. Under the steadfast guidance of a dedicated tutor, this course will take you on a virtual space voyage, studying the cosmic choreography of our galaxy's celestial bodies - from our home planet, the moon and the sun, to neighbouring planets, comets, and distant stars. Discover the dynamics that govern our planetary systems, leading to day-night and seasonal transitions. Journey through the annals of time to learn how historical observations of celestial patterns shaped our understanding of our cosmic address. Lastly, delve into current theories about the universe's evolution and their implications for humankind's future. The course not only cultivates scientific reasoning and problem-solving skills - valued by universities and employers - but also lays a solid foundation for a potential career in various scientific fields, including meteorology, and professions in planetariums, museums, and engineering. This course isn't just an introduction to astronomy; it's a launching pad to your future. This Edexcel GCSE Astronomy course has been crafted for convenient online study, providing unlimited access to your personal tutor via email and telephone. We ensure a clear course induction and meticulously structured assignments to help you excel in your exams. Our GCSE in Astronomy features: Freshly minted course, devised according to the latest specifications with dynamic, engaging content. A fast track option for exams in 2022. Access to our partnered exam centres for a guaranteed exam venue. Unlimited tutor support. Exam pass guarantee: if you don't succeed the first time, we'll assist you until the next exam. This course is a magnificent initiation into the awe-inspiring world of astronomy for stargazers and those mesmerised by the cosmic ballet.  About the awarding body Awarding body: Edexcel Our course code: X815 Qualification code: 1AS0 Official Qualification Title: Astronomy GCSE Edexcel, the UK's leading awarding organisation, provides academic and vocational qualifications in schools, colleges, and workplaces both domestically and internationally. For nearly two decades, Edexcel has empowered learners to achieve success through education. ⏱ Study Hours: Allocate between 120 and 150 hours for study, plus additional time for assignment completion. 👩‍🏫 Study Method: Our interactive online platform delivers the course, offering a variety of media including videos, quizzes, and interactive activities. If you prefer, you can print the learning materials. 📆 Course Duration: Post-enrolment, you have up to two years to study and take your exams, with continuous unlimited tutor support. 📋 Assessment: Enrolments are open now for exams from Summer 2022. You will need to complete two standard GCSE written exams, each of 1 hour 45 minutes, contributing 50% of the marks. We provide a guaranteed exam space in one of our country-wide exam centres. Throughout the course, you'll complete assignments for tutor feedback, helping you to monitor your progress. You will also complete two observational tasks: one unaided and one using a telescope. 👩‍🎓 Course Outcomes: Successful completion of this course will award you with a GCSE in Astronomy, issued by Edexcel. This syllabus is chosen for its compatibility with distance learning. ℹ️ Additional Information: Official Qualification Title - Astronomy GCSE Difficulty - Level 2 Entry requirements - No formal entry requirements. Ability to observe the night sky and a good grasp of maths are needed. Course Content: The course covers essential math skills for astronomy, celestial observations, exploration of planetary systems, the solar system, the moon, the Earth-moon-sun system, stellar evolution, cosmology, and our place in the galaxy, among others.

Broaden your horizons with Spanish, the language of over 400 million native speakers worldwide! With a GCSE in Spanish under your belt, you're setting the stage for further education and a range of career options, including journalism, education, marketing, law enforcement, and more! Our comprehensive GCSE Spanish course provides you with the skills to confidently comprehend and communicate in Spanish, covering diverse topics from self-identity and interpersonal relationships to the significance of locale, culture, and societal issues. With unlimited access to your tutor, you'll master grammatically correct writing, effective listening skills, and the creative articulation of your thoughts, ideas, and opinions. Bilingualism is a notable achievement well-regarded by educational institutions and employers alike. Our digital Edexcel GCSE Spanish course is designed for convenience, allowing you to learn at your pace and in your comfort. Your tutor will assist and guide you, as well as provide feedback on your tasks. The course is systematically structured, ensuring you gain the requisite skills and knowledge to ace your exams. By enrolling in this GCSE Spanish course, you will enjoy: Freshly-curated course content, aligned with the latest specifications Fast track option available (for 2022 exams) Complimentary e-textbook to facilitate learning Access to our consortium of exam centres (guaranteed exam venue) Unlimited tutor support – Your tutor will aid in formulating a study plan and provide constant support Exam pass guarantee (We'll support you until you pass). Understanding Spanish opens doors to both professional and social opportunities globally.  About the awarding body Awarding body: Edexcel Our course code: X810 Qualification code: 1SP0 Official Qualification Title: GCSE Spanish Edexcel, the largest awarding body in the UK, offers academic and vocational qualifications across the globe. They have been facilitating success through learning for nearly two decades, providing a reliable educational foundation. ⏱ Study Hours Allocate between 120 and 150 hours for study, along with additional time for assignments. 👩‍🏫 Study Method Our interactive online platform enhances your learning experience with diverse media resources like videos, quizzes, and interactive activities. If you wish, you can print the learning materials yourself. 📆 Course Duration Upon enrolment, you have up to two years to complete your studies and exams, with continued tutor support throughout. 📋 Assessment Examinations are available from Summer 2022 onwards. You will be required to complete three standard GCSE written exams and one speaking assessment. Exams: Paper 1: Listening and understanding – 45 minutes, 25% of GCSE, 50 marks. Paper 2: Speaking – 10-12 minutes, 25% of GCSE, 70 marks. Paper 3: Reading and understanding – 1 hour, 25% of GCSE, 50 marks. Paper 4: Writing – 1 hour 20 minutes, 25% of GCSE, 60 marks. We arrange an assured exam space for you in one of our UK-wide exam centres.  Assignments: Throughout the course, you'll complete various assignments. While not contributing towards your final grade, they provide opportunities for feedback and self-assessment. 👩‍🎓 Course Outcomes Upon successful completion, you'll receive a GCSE in Spanish, issued by Edexcel. We've chosen this syllabus (1SP0) specifically for its suitability to distance learning. ℹ️ Additional Information Official Qualification Title - GCSE Spanish Difficulty - Level 2 Entry requirements - We recommend a basic knowledge of Spanish before starting this course. Course Content From understanding yourself and everyday transactions to discussing significant societal issues and preparing for your exams, this course provides you with a robust foundation in Spanish. The structured course content encompasses self-expression, shopping, daily routines, travel experiences, environmental issues, media, and traditions. In each unit, you'll focus on essential grammatical elements and vocabulary to enhance your language proficiency and cultural understanding. Through this course, you'll emerge well-prepared to excel in your GCSE exams.

Ever been curious about the intricate and fascinating workings of the legal system? Do you seek to comprehend the foundational theories that inform our understanding of justice, and the principles that guide our approach to criminal prosecution? Our online A-level Law course is the perfect springboard for delving into the realm of English law. In this A-Level Law course, you'll delve into the English legal system, private law, public law, and legal skills. Alongside the rules and principles of law, you'll also examine the impact of law on individuals and society, and evaluate the effectiveness of different laws. You'll hone strong research capabilities, form arguments via logical reasoning and critical judgement, and bolster your communication skills. Whether your sights are set on higher education or a career in the legal or public sector, the skills you gain from this course will be highly sought after by universities and employers. Our home study course is in line with the latest AQA A-Level Law syllabus and has been tailored to be studied online at your own pace. You'll receive unlimited tutor support, a clear induction, and well-structured assignments to facilitate your skills and knowledge development in preparation for the exam. You'll also have guaranteed access to one of our exam centres if you decide to sit your final A-Level examinations in the UK. With this A-Level Law course, you'll experience the benefits of: A brand-new course, designed according to the latest specification with dynamic and engaging content Fast track availability for this course (exams in 2022) Access to a network of partnership exam centres (guaranteed exam venue) Unlimited tutor support – We'll assist you in devising a study plan and provide support throughout. Exam pass guarantee (If you don’t pass the first time, we’ll support you to the next exam at no extra cost) Dive deeper into the intricate and captivating world of the legal system with our home study A-level Law course - your perfect launching pad to expand your legal knowledge. Awarding body: AQA Our course code: X920 Qualification code: 7162 AQA qualifications are recognised and taught in 30 countries worldwide, highly esteemed by employers and universities, and enable students to progress to the next stage of their lives. AQA qualifications cater to a range of abilities and include GCSEs, IGCSEs and A-levels. ⏱ Study Hours Allocate between 250 and 300 hours for study time, plus additional time for completing assignments. 👩‍🏫 Study Method Our course is delivered via our engaging online learning platform. If you prefer, you can print the learning materials. The resources come in various formats including videos, quizzes, and interactive activities. 📆 Course Duration The course runs for a period of up to 24 months from your enrolment date. You will receive your login details to our MyOxbridge portal where you can access your learning materials. 📋 Assessment Enrol now for examinations from Summer 2022. You’ll be required to complete three standard A-Level written exams: Paper 1: 2 hours, 33% of A-Level, 100 marks. Paper 2: 2 hours, 33% of A-Level, 100 marks. Paper 3: 2 hours, 33% of A-Level, 100 marks. The exams contain a mix of short and long answer questions, as well as extended response questions. We provide a guaranteed exam space in one of our exam centres around the UK. Check where your closest exam centre is. We also offer an exam pass guarantee. If you don’t pass the first time, we’ll provide support free of charge for your subsequent exams. Assignments Throughout the course, you’ll need to complete various assignments. Although they do not contribute to your final grade, they provide an opportunity to submit work to your tutor for marking and feedback, aiding in your progress monitoring and prediction of grades if needed. 👩‍🎓 Course Outcomes Upon successful completion of this home learning course, you will receive an A-Level in Law, issued by AQA. This certificate is identical to those issued to students at any other school, college or university. This syllabus has been selected by Oxbridge as it is best suited to online learning, and we believe it affords the best opportunity for success. ℹ️ Additional Information Difficulty - Level 3 Entry requirements - A GCSE in English at grade 4 (C) or the equivalent is required to enrol in this course. UCAS Points - 56  The Course Content includes a comprehensive coverage of the English legal system, criminal law, tort law, and contract law, with in-depth modules that shed light on the nuances and complexities of each area. From understanding how laws are made and enforced to exploring various types of offences and how they are dealt with, this course provides a thorough and engaging insight into English law.