Description Greek History Diploma Greek History Diploma course is on offer from Elearncollege. The Greek History Diploma course is a journey through the history of the progress of the great Greek civilisation in the fields of politics, intellect, and creativity. The course starts with a deep dive into the Bronze age and ends with the classical period. The course outlines everything we know as ancient Greece today, including the various places and the lives of the Greeks as their history developed. The Greek History Diploma course surveys the necessary and significant changes of the Greek civilisation, including the foundational events that may be imagined or real, the great wars they fought, and their most essential cultural traditions and social institutions. The course explores the ancient Greek's perceptions of the world surrounding them and their place in it. It attempts to heed the calls of their slaves and the women, often unheard of in many accounts of their history. There are many blind spots and previously unexplored insights into the civilisation of the Greeks, which you will learn in this course; mysteries to solve and drama to uncover that will ultimately lead to a better understanding of yourself. The ancient Greek civilisation began between the 12th and 9th BC, known as the Greek Dark Ages. This period ended with the end of antiquity circa 600AD. What followed was the Early Middle Ages and the era known as the Byzantine period. About three centuries after the collapse of the Late Bronze Age and Mycenaean Greece, the formation of the Greek urban poleis began during the 8th century BC. This marked the Archaic period's start and the Mediterranean Basin colonisation. The period preceded the Classical Greece era, beginning with the Greco-Persian war and extending to the 4th century and 5th century BC. Hellenistic civilisation spread from the western Mediterranean to Central Asia with the conquests of Alexander the Great, the ruler of Macedonia. The Hellenistic era met its end as the Roman Republic took over the eastern Mediterranean, and the Roman Province of Macedonia was annexed from Roman Greece. Later, the Archaea province was also annexed from the Roman Empire. The culture of classical Greece had a lot of influence on Rome, especially in philosophy. Versions of it spread throughout the majority of Europe and the Mediterranean. Because of this, Classical Greece is often thought of as the cradle of Western Civilisation, the pivotal culture that set off the culture of the modern Western world, as its ideologies spread and became the founding archetypes in the fields of philosophy, politics, art, and science. The ancient Greek civilisation dominated most parts of the Mediterranean for thousands of years. Its powerful influence declined around 146 BC, but they were much more advanced in different fields of thought and inquiry, making them influential. The Greeks civilisation remains one of the first contributors to the development and advancement of our species in all areas of religion, politics, science, arts, and our perception and comprehension of our world and the universe. So few cultures have the same legacy as the ancient Greeks, continuing to have powerful concepts like philosophy, democracy, architectural orders, scientific theories, dramatic structure, and even the Olympic Games. Very few other cultures have had the same impact on our morals, values, and sense of being as deep as ancient Greek civilisation. Elearncollege's Greek History Diploma course goes through these three eras- Archaic, Classical, and Hellenistic- chronologically consisting of the Greek civilisation to analyse the times when they existed and their contributions that still impact our world today. What you will learn 1: A Journey to the Ancient Period 2: Finding Prehistoric Civilisations 3: Dark Ages of Ancient Greece 4: The Ruling classes 5: Ancient Greek Warfare 6: Rise And Fall Of Empires 7: Art in Ancient Greece Course Outcomes After completing the course, you will receive a diploma certificate and an academic transcript from Elearn college. Assessment Each unit concludes with a multiple-choice examination. This exercise will help you recall the major aspects covered in the unit and help you ensure that you have not missed anything important in the unit. The results are readily available, which will help you see your mistakes and look at the topic once again. If the result is satisfactory, it is a green light for you to proceed to the next chapter. Accreditation Elearn College is a registered Ed-tech company under the UK Register of Learning( Ref No:10062668). After completing a course, you will be able to download the certificate and the transcript of the course from the website. For the learners who require a hard copy of the certificate and transcript, we will post it for them for an additional charge.
Description Green Building Diploma In the era of heightened environmental consciousness, the need to foster sustainable construction practices has never been greater. The Green Building Diploma offers a comprehensive insight into the dynamic world of green construction, equipping learners with the skills and knowledge to contribute meaningfully to the industry. Designed exclusively for an online learning experience, this course ensures flexibility and comprehensive learning, irrespective of your geographical location. The course kicks off with an 'Introduction to Green Building'. This foundational unit sets the stage by outlining the significance of eco-friendly construction, its benefits, and its impact on the environment. The knowledge acquired here forms the base for all ensuing modules. Following this, students explore the 'Sustainable Design Strategies for Building Envelopes'. Here, learners understand the importance of designing buildings that harmonise with their environment, ensuring energy efficiency and reducing the carbon footprint. 'Renewable Energy in Building Design' is another core aspect of the Green Building Diploma. This module educates learners about the integration of alternative energy sources like solar, wind, and geothermal in building designs. By understanding these concepts, future architects and builders can minimise non-renewable energy usage, driving the world towards a cleaner future. As we understand the macro elements, the course shifts focus to more granular topics. 'Green Infrastructure for Sustainable Development' presents infrastructure solutions that complement green building designs, ensuring that the buildings do not stand as isolated entities but are a part of a larger eco-friendly ecosystem. One cannot ignore the importance of 'Indoor Air Quality and Health'. This module highlights the criticality of ensuring clean air inside buildings, affecting occupants' health and well-being. Students will grasp methods to enhance air quality, making indoor spaces healthier and more comfortable. A bird's-eye view of sustainable construction is covered in 'Sustainable Land Use and Site Planning'. This section aids learners in making informed decisions about selecting sites, ensuring minimal disruption to the environment and maximising utility. 'Biodiversity and Ecosystem Services' introduces the criticality of preserving biodiversity when constructing. Every building has a direct or indirect impact on the local ecosystem. By understanding this, one can make informed decisions that benefit both the environment and inhabitants. No course on green construction would be complete without delving into the economics of it. 'Green Building Economics and Finance' breaks down the financial aspects, debunking myths that sustainable construction is always more expensive. Sustainability is not just about the environment; it's about people too. 'Social Aspects of Sustainable Construction' takes a close look at how green building practices impact society, promoting healthier and more integrated communities. Lastly, the Green Building Diploma introduces students to 'Innovations in Sustainable Construction Technology'. This module is a peek into the future, revealing cutting-edge technologies that make buildings more efficient, durable, and eco-friendly. To conclude, the Green Building Diploma is not just a course; it's a movement towards a more sustainable future. By enrolling, you are not only enhancing your skills but also making a commitment to a greener planet. Join us in reshaping the construction landscape, one green building at a time. What you will learn 1:Introduction to Green Building 2:Sustainable Design Strategies for Building Envelopes 3:Renewable Energy in Building Design 4:Green Infrastructure for Sustainable Development 5:Indoor Air Quality and Health 6:Sustainable Land Use and Site Planning 7:Biodiversity and Ecosystem Services 8:Green Building Economics and Finance 9:Social Aspects of Sustainable Construction 10:Innovations in Sustainable Construction Technology Course Outcomes After completing the course, you will receive a diploma certificate and an academic transcript from Elearn college. Assessment Each unit concludes with a multiple-choice examination. This exercise will help you recall the major aspects covered in the unit and help you ensure that you have not missed anything important in the unit. The results are readily available, which will help you see your mistakes and look at the topic once again. If the result is satisfactory, it is a green light for you to proceed to the next chapter. Accreditation Elearn College is a registered Ed-tech company under the UK Register of Learning( Ref No:10062668). After completing a course, you will be able to download the certificate and the transcript of the course from the website. For the learners who require a hard copy of the certificate and transcript, we will post it for them for an additional charge.
Why Choose InDesign Evening Training Course? Course Link. If you aim to enhance your design abilities, acquire proficiency in a new software, or pursue a career in graphic design, an InDesign course is highly beneficial. Tailored for individuals with foundational knowledge of Adobe InDesign, this training is designed to further develop your existing skills. Duration: 10 hrs Method: 1-on-1, Personalized attention Schedule: Tailor your own hours of your choice, available from Mon to Sat between 9 am and 7 pm InDesign Evening Course Outline (10 hours) Introduction Getting Started with Adobe InDesign CC Advanced Course Adjusting Workspace for Maximum Efficiency Customizing Default Font Size for New Documents Utilizing Special Features for Typekit & Open Type Fonts Exploring Sources for Free Fonts in InDesign Mastering Fonts in Adobe InDesign CC Identifying Fonts with Font Guess Selecting Beautiful Font Pairings Incorporating Free Icons from Adobe Market Using the Color Theme Tool Understanding Colour Modes Importing and Setting Default Colors Finding Great Colors with Adobe Color Managing Appearance of Black & Proofing Colors Creating Multiple Shapes with Gridify Live Distribute Drawing Arrows in InDesign CC Designing Complex Flowers in InDesign CC Utilizing Auto Size for Auto-Expanding Text Boxes Exploring Placeholder Text Alternatives Adding Paragraph Borders & Shading Understanding Paragraph vs Single Line Composer Making Paragraphs Span 2 Columns Mastering Justification & Hyphenation Options Aligning Optical Margins Harnessing the Power of Keep Options Working with Advanced Anchored Objects Using Conditional Text Creating Pie Charts & Bar Graphs Pros & Cons of Interactive Types Creating Interactive PDFs Adding Interactive Page Transitions Adding Navigation to Interactive PDFs Understanding Publish Online in InDesign CC Publishing Adobe InDesign Documents Online Adding Video to InDesign Documents Creating Button-Triggered Animations Making Multi-State Objects Incorporating Adobe Animate CC to InDesign Files Adding Maps & Calendars to Interactive Documents Generating QR Codes in InDesign CC Exploring Essential Keyboard Shortcuts Automatically Placing Text on Multiple Pages Creating Cross References & Index Adding Document Name Automatically with Text Variables Utilizing Adobe InDesign CC Book Feature Changing Preferences for Advanced Users Speeding Up Workflow for Advanced Users Using Character Styles Advanced Paragraph Styles Mapping Word Styles with InDesign Styles Creating Nested Styles & Grep Styles Using Next Style Mastering Object Styles Best Practices for Working Across Multiple Documents Utilizing Adobe Stock with InDesign CC Cropping Images Inside Text Making InDesign Layouts with Adobe Comp CC Advanced Use of CC Libraries Integrating Photoshop & Illustrator in InDesign CC Creating PDF Forms in InDesign CC Advanced Use of the Pages Panel Placing InDesign Documents Inside Each Other Installing and Using Scripts in InDesign CC Improving InDesign Performance Advanced Exporting & Printing Tricks Bonus: Software Updates Adobe InDesign https://adobe.com › indesign › get-started Installing for the first time or on a new computer? Click Get InDesign below to begin downloading. Follow the onscreen instructions to sign-in and install.
This online course covers how technical communicators can use Generative Artificial Intelligence to help them: Be more efficient Create better deliverables for their users We went through all the key stages in a technical writing project. At each step, we investigated whether AI tools like ChatGPT and Claude could make a Technical Writer's job easier and better. After a lot of research and testing, we ended up with the content for this course. The course provides a framework that attendees can use to identify opportunities and best practices for integrating ChatGPT, Claude, LLaMA, and similar tools into their technical authoring processes – creating, managing, and delivering technical content. Why attend this course? Integrating AI and natural language processing technologies promise to make Technical Writers more efficient and more effective at what they do. By attending this course, you’ll gain a better understanding of how generative AI can be used by technical communicators. You learn a framework you can use for using tools such as ChatGPT at the different stages of a technical writing project. Who is this course for? This course is for people who have some experience of technical writing, and who want to improve their skills. What will I learn? You’ll learn and practice: What are AI technologies and their relevance to technical writing? Career opportunities and threats How you can use AI at different stages of the documentation process. We cover topics such as planning, writing, reviewing, and production. How to work more efficiently. How to work more effectively. The course does not go into much detail about using generative AI to create images, audio or videos. Learning Materials The course comprises online training modules (4.75 hours of video, plus handouts), which you can complete at your own pace. The course modules are delivered over the Web in small, manageable video presentations. You can pause the videos at any time and return to the course at times that suit you. The course is roughly equivalent to a 1.5 days long classroom course. Examples The modules describe practical examples and techniques you can use right away. Demonstrations The modules contain demonstrations of the techniques and tools when they’re applied to technical writing. Exercises You’ll be given exercises to work on throughout the course. This is a great way to put your learning to practice. Your Instructor Cherryleaf Cherryleaf is a technical writing services company formed in 2002 by people with a passion for technical communication and learning development. Cherryleaf is recognised as a leader within the technical communication profession. Our staff have written articles for the Society for Technical Communication's (STC) Intercom magazine, the Institute of Scientific and Technical Communicator's Communicator journal and tekom's TCWorld magazine. They've also written books on technical communication. We've presented webinars for Adobe, Madcap Software or the STC, and we've spoken at various conferences around the world. Today, organisations throughout Europe use Cherryleaf’s services so they can provide clear information that enables users and staff to complete tasks productively. Course Curriculum Introduction Introduction (0:56) ChatGPT and AI Basics What do the buzzwords mean? (18:19) Using ChatGPT and similar tools - Software and Websites (15:30) Prompt Engineering (17:23) Why use generative AI? Why use generative AI? (5:37) The limitations of Large Language Models (LLMs) and AI systems (7:48) Data security (10:09) Legal considerations (2:59) Quiz Section summary Frequently Asked Questions When does the course start and finish? The course starts now and never ends! It is a completely self-paced online course - you decide when you start and when you finish.How long do I have access to the course?After enrolling, you have 12 months access to this course for as long as you like - across any and all devices you own.What if I am unhappy with the course?We would never want you to be unhappy! If you are unsatisfied with your purchase, contact us in the first 14 days and we will give you a full refund.
Tired of browsing and searching for a Health and Safety in a Construction Environment - Route to CSCS Green Card course you are looking for? Can't find the complete package that fulfils all your needs? Then don't worry as you have just found the solution. Take a minute and look through this extensive bundle that has everything you need to succeed. After surveying thousands of learners just like you and considering their valuable feedback, this all-in-one Health and Safety in a Construction Environment - Route to CSCS Green Card bundle has been designed by industry experts. We prioritised what learners were looking for in a complete package and developed this in-demand Health and Safety in a Construction Environment - Route to CSCS Green Card course that will enhance your skills and prepare you for the competitive job market. Also, our experts are available for answering your queries on Health and Safety in a Construction Environment - Route to CSCS Green Card and help you along your learning journey. Advanced audio-visual learning modules of these Health and Safety in a Construction Environment - Route to CSCS Green Card courses are broken down into little chunks so that you can learn at your own pace without being overwhelmed by too much material at once. Furthermore, to help you showcase your expertise in Health and Safety in a Construction Environment - Route to CSCS Green Card, we have prepared a special gift of 1 hardcopy certificate and 1 PDF certificate for the title course completely free of cost. These certificates will enhance your credibility and encourage possible employers to pick you over the rest. This Health and Safety in a Construction Environment - Route to CSCS Green Card Bundle Consists of the following Premium courses: Course 01: Health and Safety in a Construction Environment - Route to CSCS Green Card Course 02: Construction Site Management Level 4 Course 03: PUWER Course 04: LOLER Training Course 05: Ladder Safety Course 06: Noise and Hearing Protection Training Course 07: HAVS (Hand-Arm Vibration Syndrome) Training Course Course 08: Asbestos Surveyor Training Course 09: COSHH Training and Safety - Level 2 Course 10: DSEAR Training Course 11: RIDDOR Training Course 12: Lone Worker Safety Course Course 13: Emergency First Aid and Incident Management at Work Course 14: Decision Making and Critical Thinking Enrol now in Health and Safety in a Construction Environment - Route to CSCS Green Card to advance your career, and use the premium study materials from Apex Learning. How will I get my Certificate? After successfully completing the Health and Safety in a Construction Environment - Route to CSCS Green Card course, you will be able to order your CPD Accredited Certificates (PDF + Hard Copy) as proof of your achievement. PDF Certificate: Free (For The Title Course ) Hard Copy Certificate: Free (For The Title Course ) The bundle incorporates basic to advanced level skills to shed some light on your way and boost your career. Hence, you can strengthen your Health and Safety in a Construction Environment - Route to CSCS Green Card expertise and essential knowledge, which will assist you in reaching your goal. Curriculum of Bundle Course 01: Health and Safety in a Construction Environment - Route to CSCS Green Card Health and Safety in a Construction Environment - Introduction to the Course Introduction to the Health and Safety Protocols at a Construction Site Hazards, Risks, Assessment and Controls Slips, Trips, Falls and Working at Height Manual Handling Plant and Machinery Respiratory Risks Fire, Electricity and Gas Safety Chemical Hazard and Worksite Hygiene Vehicles, PPE and General Safety CPD 140 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone from any background can enrol in this bundle. Requirements Our Health and Safety in a Construction Environment - Route to CSCS Green Card course is fully compatible with PCs, Macs, laptops, tablets and Smartphone devices. Career path Having this expertise will increase the value of your CV and open you up to multiple job sectors. Certificates Certificate of completion Digital certificate - Included Certificate of completion Hard copy certificate - Included P.S. The delivery charge inside the UK is £3.99, and the international students have to pay £9.99.
Learn The Art of Smudging Learn everything you need to know to confidently begin incorporating this powerful Smudging Ceremony into your life today! Smudging is a practice of connecting with the Spirit of specific plants and herbs to help cleanse, uplift, protect, and unite the physical and spiritual planes. Ancient traditions all around the world have incorporated the practice of smudging into their ceremonies. Now is your time to connect with “that which is greater than us”.
Do you want to prepare for your dream job but strive hard to find the right courses? Then, stop worrying, for our strategically modified Script Writing bundle will keep you up to date with the relevant knowledge and most recent matters of this emerging field. So, invest your money and effort in our 37 course mega bundle that will exceed your expectations within your budget. The Script Writing related fields are thriving across the UK, and recruiters are hiring the most knowledgeable and proficient candidates. It's a demanding field with magnitudes of lucrative choices. If you need more guidance to specialise in this area and need help knowing where to start, then StudyHub proposes a preparatory bundle. This comprehensive Script Writing bundle will help you build a solid foundation to become a proficient worker in the sector. This Script Writing Bundle consists of the following 30 CPD Accredited Premium courses - Course 1: Creative Writing Course 2: Copywriting Course Level 4 Course 3: Novel Writing and Publishing Course 4: Creative Writing Course: Writing Storybooks For Children Course 5: Diploma in Drama and Comedy Writing Course 6: Creative Writing Course - Short Stories Course 7: Creative Writing Course - Fiction Course 8: Creative Writing Course - Horror Course 9: Creative Writing Course - Novel Course 10: Creative Writing Course - Thriller Course 11: Creative Nonfiction Book Writing Course 12: News Writing: Journalism 101 Course 13: Selling E-books: The Best Way of Earning Online Course 14: Basics of Shopify: Earn through E-books Course 15: Blogger for Beginners Course 16: Business Writing Course 17: Business Writing - How You Can Become a Great Writer Course 18: Business Writing: Influence Your Readers Course 19: Write and Publish a Research Paper: Complete Guide v6 Course 20: How to Write a Research Paper in Law and Humanities Course 21: Freelance Masterclass - Become An Expert Copywriter Course 22: Content Writing & Copy Writing For SEO and Sales Course 23: Webinar Marketing Write, Design & Market Webinars Course 24: Email Writing Training Course 25: Creative Advertising and Graphic Design for Everyone Course 26: CV Writing and Job Searching Course 27: Foundations of Leadership and Negotiation Skills Development Course 28: Personal Development and Productivity Level 2 Course 29: 10 Soft Skills for Workplace Course 30: Public Speaking 7 Extraordinary Career Oriented courses that will assist you in reimagining your thriving techniques- Course 1: Career Development Plan Fundamentals Course 2: CV Writing and Job Searching Course 3: Interview Skills: Ace the Interview Course 4: Video Job Interview for Job Seekers Course 5:Create a Professional LinkedIn Profile Course 6:Business English Perfection Course Course 7:Networking Skills for Personal Success Learning Outcome This tailor-made Script Writing bundle will allow you to- Uncover your skills and aptitudes to break new ground in the related fields Deep dive into the fundamental knowledge Acquire some hard and soft skills in this area Gain some transferable skills to elevate your performance Maintain good report with your clients and staff Gain necessary office skills and be tech savvy utilising relevant software Keep records of your work and make a report Know the regulations around this area Reinforce your career with specific knowledge of this field Know your legal and ethical responsibility as a professional in the related field This Script Writing Bundle resources were created with the help of industry experts, and all subject-related information is kept updated on a regular basis to avoid learners from falling behind on the latest developments. Certification After studying the complete training you will be able to take the assessment. After successfully passing the assessment you will be able to claim all courses pdf certificates and 1 hardcopy certificate for the Title Course completely free. Other Hard Copy certificates need to be ordered at an additional cost of •8. CPD 370 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Ambitious learners who want to strengthen their CV for their desired job should take advantage of the Script Writing bundle! This bundle is also ideal for professionals looking for career advancement. Requirements To participate in this course, all you need is - A smart device A secure internet connection And a keen interest in Script Writing Career path Upon completing this essential Bundle, you will discover a new world of endless possibilities. These courses will help you to get a cut above the rest and allow you to be more efficient in the relevant fields.
Do you want to prepare for your dream job but strive hard to find the right courses? Then, stop worrying, for our strategically modified Creative Writing, Copy Writing bundle will keep you up to date with the relevant knowledge and most recent matters of this emerging field. So, invest your money and effort in our 37 course mega bundle that will exceed your expectations within your budget. The Creative Writing, Copy Writing related fields are thriving across the UK, and recruiters are hiring the most knowledgeable and proficient candidates. It's a demanding field with magnitudes of lucrative choices. If you need more guidance to specialise in this area and need help knowing where to start, then StudyHub proposes a preparatory bundle. This comprehensive Creative Writing, Copy Writing bundle will help you build a solid foundation to become a proficient worker in the sector. This Creative Writing, Copy Writing Bundle consists of the following 30 CPD Accredited Premium courses - Course 1: Creative Writing Course 2: Copywriting Course Level 4 Course 3: Novel Writing and Publishing Course 4: Creative Writing Course: Writing Storybooks For Children Course 5: Diploma in Drama and Comedy Writing Course 6: Creative Writing Course - Short Stories Course 7: Creative Writing Course - Fiction Course 8: Creative Writing Course - Horror Course 9: Creative Writing Course - Novel Course 10: Creative Writing Course - Thriller Course 11: Creative Nonfiction Book Writing Course 12: News Writing: Journalism 101 Course 13: Selling E-books: The Best Way of Earning Online Course 14: Basics of Shopify: Earn through E-books Course 15: Blogger for Beginners Course 16: Business Writing Course 17: Business Writing - How You Can Become a Great Writer Course 18: Business Writing: Influence Your Readers Course 19: Write and Publish a Research Paper: Complete Guide v6 Course 20: How to Write a Research Paper in Law and Humanities Course 21: Freelance Masterclass - Become An Expert Copywriter Course 22: Content Writing & Copy Writing For SEO and Sales Course 23: Email Writing Training Course 24: Medieval History Course 25: Military History Course 26: Creative Advertising and Graphic Design for Everyone Course 27: Boost Your Confidence and Self-Esteem Course 28: Foundations of Leadership and Negotiation Skills Development Course 29: Personal Development and Productivity Level 2 Course 30: Public Speaking 7 Extraordinary Career Oriented courses that will assist you in reimagining your thriving techniques- Course 1: Career Development Plan Fundamentals Course 2: CV Writing and Job Searching Course 3: Interview Skills: Ace the Interview Course 4: Video Job Interview for Job Seekers Course 5:Create a Professional LinkedIn Profile Course 6:Business English Perfection Course Course 7:Networking Skills for Personal Success Learning Outcome This tailor-made Creative Writing, Copy Writing bundle will allow you to- Uncover your skills and aptitudes to break new ground in the related fields Deep dive into the fundamental knowledge Acquire some hard and soft skills in this area Gain some transferable skills to elevate your performance Maintain good report with your clients and staff Gain necessary office skills and be tech savvy utilising relevant software Keep records of your work and make a report Know the regulations around this area Reinforce your career with specific knowledge of this field Know your legal and ethical responsibility as a professional in the related field This Creative Writing, Copy Writing Bundle resources were created with the help of industry experts, and all subject-related information is kept updated on a regular basis to avoid learners from falling behind on the latest developments. Certification After studying the complete training you will be able to take the assessment. After successfully passing the assessment you will be able to claim all courses pdf certificates and 1 hardcopy certificate for the Title Course completely free. Other Hard Copy certificates need to be ordered at an additional cost of •8. CPD 370 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Ambitious learners who want to strengthen their CV for their desired job should take advantage of the Creative Writing, Copy Writing bundle! This bundle is also ideal for professionals looking for career advancement. Please Note: Studyhub is a Compliance Central approved resale partner for Quality Licence Scheme Endorsed courses. Requirements To participate in this course, all you need is - A smart device A secure internet connection And a keen interest in Creative Writing, Copy Writing Career path Upon completing this essential Bundle, you will discover a new world of endless possibilities. These courses will help you to get a cut above the rest and allow you to be more efficient in the relevant fields. Certificates CPD Accredited Digital certificate - Included CPD Accredited Hard copy certificate - Included
Enhance your skills and learn how to use a range of advanced formulas and functions to manage and extract data more efficiently. There are some great ones here that will save a lot of time. Course overview Duration: 1 day (6.5 hours) Our Excel Module 4 – Advanced Formulas and Functions course looks at some of the more advanced functions of Excel that can be used to manipulate and extract data. This is an intensive one-day course and designed for experienced users of Excel. Participants should be confident in creating and using Excel and be able to build simple formula before attending. Objectives By the end of the course you will be able to: Use a range of Text functions to manage text data Create and use different types of date and time functions Work with rounding functions Use logical statements Build nested formula Use SUMIF, COUNTIF and AVERAGEIF Cross reference data from other worksheets using LOOKUP, INDEX and MATCH functions Use IS functions and IFERROR to test cell values Content Working with text Splitting text into multiple cells Merging data into one cell Extracting data using text functions Tidying data Working with dates and times Formatting dates and times Date and time functions Calculating date and time differences Using functions to round numbers up and down ROUND ROUNDUP ROUNDDOWN CEILING FLOOR Use lookup functions Lookup functions Creating a lookup table Range naming Using VLOOKUP Using HLOOKUP Using INDEX and MATCH Working with logical statements Creating an IF statement Using the AND plus OR functions Nesting functions Calculating values based on given criteria SUMIF(S) COUNTIF(S) AVERAGEIF(S) Using IS and IFERROR and test cell values ISBLANK ISNUMBER ISTEXT ISERROR IFERROR
A comprehensive and practical guide to the art and science of company valuation. Learn value investing’s most important skill.