Are you ready to embark on an enlightening journey of wisdom with the Digital Marketing & Email Marketing bundle, and pave your way to an enriched personal and professional future? If so, then Step into a world of knowledge with our course bundle - ChatGPT, Social Media, Digital Marketing with Email Marketing. Delve into eight immersive CPD Accredited courses, each a standalone course: Course 01: A Beginner Crash Course on ChatGPT Course 02: ChatGPT Complete Guide with Expertise Course 03: PR : Public Relation Course 04: Media Studies Course 05: Screenwriting & Scriptwriting Course 06: ICT: Information and Communication Technology Course 07: Social Media Marketing Course -The Step by Step Guide Course 08: ChatGPT for Marketing and Productivity with AI Tools Traverse the vast landscapes of theory, unlocking new dimensions of understanding at every turn. Let the ChatGPT, Social Media, Digital Marketing with Email Marketing bundle illuminate your path to wisdom. The ChatGPT, Social Media, Digital Marketing with Email Marketing bundle offers a comprehensive exploration into a rich tapestry of vast knowledge across eight carefully curated courses. The journey is designed to enhance your understanding and critical thinking skills. Each course within the bundle provides a deep-dive into complex theories, principles, and frameworks, allowing you to delve into the nuances of the subject matter at your own pace. In the framework of the ChatGPT, Social Media, Digital Marketing with Email Marketing package, you are bestowed with complimentary PDF certificates for all the courses included in this bundle, all without any additional charge. Adorn yourself with the Digital Marketing & Email Marketing bundle, empowering you to traverse your career trajectory or personal growth journey with self-assurance. Register today and ignite the spark of your professional advancement! So, don't wait further and join the ChatGPT, Social Media, Digital Marketing with Email Marketing community today and let your voyage of discovery begin! Learning Outcomes: Attain a holistic understanding in the designated areas of study with the Digital Marketing & Email Marketing bundle. Establish robust bases across each course nestled within the Digital Marketing & Email Marketing bundle. Decipher intricate concepts through the articulate content of the Digital Marketing & Email Marketing bundle. Amplify your prowess in interpreting, scrutinising, and implementing theories. Procure the capacity to engage with the course material on an intellectual and profound level. Become proficient in the art of problem-solving across various disciplines. Stepping into the Digital Marketing & Email Marketing bundle is akin to entering a world overflowing with deep theoretical wisdom. Each course within this distinctive bundle is an individual journey, meticulously crafted to untangle the complex web of theories, principles, and frameworks. Learners are inspired to explore, question, and absorb, thus enhancing their understanding and honing their critical thinking skills. Each course invites a personal and profoundly enlightening interaction with knowledge. The Digital Marketing & Email Marketing bundle shines in its capacity to cater to a wide range of learning needs and lifestyles. It gives learners the freedom to learn at their own pace, forging a unique path of discovery. More than just an educational journey, the Digital Marketing & Email Marketing bundle fosters personal growth, enabling learners to skillfully navigate the complexities of the world. The Digital Marketing & Email Marketing bundle also illuminates the route to a rewarding career. The theoretical insight acquired through this bundle forms a strong foundation for various career opportunities, from academia and research to consultancy and programme management. The profound understanding fostered by the Digital Marketing & Email Marketing bundle allows learners to make meaningful contributions to their chosen fields. Embark on the Digital Marketing & Email Marketing journey and let knowledge guide you towards a brighter future. CPD 80 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Individuals keen on deepening their firm understanding in the respective fields. Students pursuing higher education looking for comprehensive theory modules. Professionals seeking to refresh or enhance their knowledge. Anyone with a thirst for knowledge and a passion for continuous learning. Career path Armed with the Digital Marketing & Email Marketing bundle, your professional journey can reach new heights. The comprehensive theoretical knowledge from this bundle can unlock diverse career opportunities across several fields. Whether it's academic research, consultancy, or programme management, the Digital Marketing & Email Marketing bundle lays a solid groundwork. Certificates CPD Certificate Of Completion Digital certificate - Included 8 Digital Certificates Are Included With This Bundle CPD Quality Standard Hardcopy Certificate (FREE UK Delivery) Hard copy certificate - £9.99 Hard copy Transcript - £9.99
Embark on a transformative DevOps journey! This comprehensive course equips you with skills in Ansible, Docker, GitLab, backups, and more. Master the art of self-hosting your infrastructure, streamlining deployments, and boosting efficiency. Launch your DevOps career today and unleash the endless possibilities!
Description: This Microsoft Office 2013 Word Advanced - Complete Video Course covers the advanced functions and features of Word 2013. With this advanced level, you will learn advanced skills in using Microsoft Word 2013 and be able to demonstrate the use of advanced and specialized features within the application. You should be able to create, manage, and distribute professional documents for a variety of specialized purposes and situations, and be able to customize Word 2013 environment to meet specific needs to enhance productivity. By this series, you will learn about collaborating on documents and adding reference marks and notes. You will also learn how to manage long documents, secure a document and work with forms, and more. If you already have a good grounding in Microsoft Word, this course will provide you with the knowledge and skills to use Word 2013 at an expert level. Assessment: At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Microsoft Office 2013 Word Advanced - Complete Video Course is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our Microsoft Office 2013 Word Advanced - Complete Video Course is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Collaborating on Documents Modify User Information FREE 00:06:00 Share a Document 00:03:00 Compare Document Changes 00:09:00 Review a Document 00:11:00 Merge Document Changes 00:01:00 Review Tracked Changes 00:09:00 Coauthor Documents 00:10:00 Adding Reference Marks and Notes Add Captions 00:07:00 Add Cross-References 00:09:00 Add Bookmarks 00:08:00 Add Hyperlinks 00:06:00 Insert Footnotes and Endnotes 00:06:00 Add Citations and a Bibliography 00:14:00 Simplifying and Managing Long Documents Insert Blank and Cover Pages 00:06:00 Insert an Index 00:12:00 Insert a Table of Contents 00:05:00 Insert an Ancillary Table 00:09:00 Manage Outlines 00:08:00 Create a Master Document 00:08:00 Securing a Document Suppress Information 00:08:00 Set Formatting and Editing Restrictions 00:04:00 Add a Digital Signature to a Document 00:09:00 Restrict Document Access 00:03:00 Forms Create Forms 00:14:00 Manipulate Forms 00:04:00 Mock Exam Mock Exam- Microsoft Office 2013 Word Advanced - Complete Video Course 00:20:00 Final Exam Final Exam- Microsoft Office 2013 Word Advanced - Complete Video Course 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00
24-Hour Knowledge Knockdown! Prices Reduced Like Never Before Want to ensure business compliance and risk management excellence? 92% of UK organisations prioritise compliance and risk management for sustainable growth. So, it's understandable that compliance and risk management are essential for businesses to mitigate legal and operational risks. Hence, our Compliance bundle equips professionals with the skills and knowledge to navigate and implement effective compliance and risk management strategies. With a single payment, you will gain access to Compliance & Risk Management course, including 10 premium courses, a QLS Endorsed Hardcopy certificate and 11 PDF certificates for Absolutely free. This Compliance & Risk Management Bundle Package includes: Course 01: Diploma in Compliance Management at QLS Level 5 10 Premium Additional CPD QS Accredited Courses - Course 01: Conflict Management Training Course 02: Mastering Organizational Chaos Course Course 03: Workplace Team Networking Diploma Course 04: Legal Operations Consultant Course 05: Decision-Making and Critical Thinking Training Course 06: Unconscious Bias Training Course Course 07: Cross-Cultural Awareness Training Course 08: Workplace Stress Management Diploma Course 09: Workplace Productivity Course Course 10: Corporate Risk And Crisis Management So, join in this journey towards a fulfilling career, where your Compliance and Risk Management knowledge will be in high demand. Learning Outcomes Master Compliance and Risk Management principles and strategies. Develop conflict resolution skills for effective Risk Management. Mitigate risks effectively with thorough Risk Management knowledge. Promote diversity and inclusivity through Risk Management initiatives. Foster cross-cultural awareness for better Compliance Management. Why Choose Our Bundle? Get a Free QLS Endorsed Certificate upon completion of Compliance course Get a free student ID card with Compliance Training Get instant access to this Compliance course. Learn Compliance from anywhere in the world The Compliance is affordable and simple to understand The Compliance is an entirely online, interactive lesson with voiceover audio Lifetime access to the Compliance course materials The Compliance comes with 24/7 tutor support Start your learning journey straightaway! This Compliance Management's curriculum has been designed by Compliance Management experts with years of Compliance Management experience behind them. The Compliance Management course is extremely dynamic and well-paced to help you understand Compliance Management with ease. Assessment Process You will be entitled to claim a certificate endorsed by the Quality Licence Scheme after you have completed all of the Diploma in Compliance Management at QLS Level 5 exams. CPD 255 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Compliance & Risk Management Requirements Compliance & Risk Management Career path Compliance & Risk Management Certificates CPD QS Accredited PDF Certificate Digital certificate - Included Diploma in Compliance Management at QLS Level 5 Hard copy certificate - Included
Microsoft Excel - Beginner, Intermediate & Advanced Course Enrolling in a Microsoft Excel - Beginner, Intermediate & Advanced CPD Professional Course is pivotal in today's modern world. Microsoft Excel proficiency is indispensable across industries for data analysis, reporting, and decision-making. In the UK, Microsoft Excel skills are highly sought after, with job opportunities spanning various sectors, including finance, healthcare, and technology. Entry-level positions often require basic Microsoft Excel knowledge, while intermediate and advanced proficiency can unlock higher-paying roles with salaries ranging from £25,000 for beginners to over £40,000 for experienced professionals annually. The demand for Microsoft Excel expertise is increasing, with businesses relying on data-driven insights for strategic planning and operational efficiency. Whether for financial modeling, project management, or statistical analysis, Microsoft Excel proficiency enhances employability and career advancement prospects. As industries continue to evolve digitally, mastering Microsoft Excel is not just advantageous but essential for professionals aiming to thrive in the ever-competitive job market. Key Features This Microsoft Excel - Beginner, Intermediate & Advanced- CPD Professional Course Includes: This Microsoft Excel Course is CPD Certified Free Certificate from Reed CIQ Approved Microsoft Excel Course Developed by Specialist Lifetime Access Course Curriculum Microsoft Excel Course: Module 01: Microsoft Excel 2019 Enhanced Features Module 02: Introduction to Microsoft Excel Module 03: Performing Mathematical Operations Module 04: Adjusting a Worksheet Module 05: Formatting Data in a Worksheet Module 06: Printing in Microsoft Excel Module 07: Workbook Management Techniques Module 08: Utilizing Functions Module 09: Data Management Techniques Module 10: Data Analysis Methods Module 11: Visual Representation with Charts Module 12: Mastering PivotTables and PivotCharts Module 13: Managing Multiple Sheets and Workbooks Module 14: Utilizing Lookup Functions and Formula Auditing Module 15: Sharing and Securing Workbooks Module 16: Automation in Microsoft Excel Module 17: Creating Sparklines and Geographic Data Visualization Learning Outcomes Microsoft Excel Course: Identify and utilize new features in Microsoft Excel 2019 effectively. Perform complex calculations and manipulate data efficiently in Microsoft Excel. Apply formatting techniques and create professional-looking spreadsheets. Analyze and interpret data using advanced functions and tools in Microsoft Excel. Construct dynamic charts, pivot tables, and visual representations of data. Automate tasks and enhance productivity through Microsoft Excel's advanced functionalities. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Microsoft Excel course is accessible to anyone eager to learn more about this topic. Through this course, you'll gain a solid understanding of Microsoft Excel. Moreover, this course is ideal for: Beginners seeking comprehensive Microsoft Excel skills Intermediate users aiming to enhance proficiency Advanced users desiring mastery of Microsoft Excel functionalities Professionals in various fields requiring data management expertise using Microsoft Excel. Individuals pursuing career advancement opportunities using Microsoft Excel Students preparing for roles involving data analysis and reporting in Microsoft Excel. Requirements There are no requirements needed to enrol into this Microsoft Excel course. We welcome individuals from all backgrounds and levels of experience to enrol into this Microsoft Excel course. Career path After finishing this Microsoft Excel course you will have multiple job opportunities waiting for you. Some of the following Job sectors of Microsoft Excel are: Data Analyst - £30K to 50K/year. Financial Analyst - £35K to 60K/year. Business Intelligence Analyst - £40K to 70K/year. Operations Manager - £40K to 60K/year. Project Manager - £45K to 70K/year. Certificates Digital certificate Digital certificate - Included Reed Courses Certificate of Completion Digital certificate - Included Will be downloadable when all lectures have been completed.
Duration 1 Days 6 CPD hours This course is intended for This course is intended for organizations that would like to improve the team productivity of their employees and individuals, who take the role of Project Managers, Business Analysts, Team Leaders, Scrum Masters, Product Owners, Managers, and any team members. Overview The key to the success of an IT organization is its employees. The more highly productive the people in the organization are, the greater the business goals the organization can achieve. By completing this course, the IT organization gains: trained employees who know the main characteristics of high-performance teams and already have ideas about what to change in their work and behavior to contribute to greater productivity of the team as a whole; a quantum leap in business results thanks to increased employee motivation, customer satisfaction, and improved communication in teams; long-term benefit expressed in the transfer of knowledge that the people of the trained team can share with other members of the organization. A skill that almost every organization looks for in a new job candidate is the ability to work in a team. If an individual is an expert in a certain field and is invited to work on a large project that includes other experts, it is very important to know how to work successfully in this team. By completing this course the individual will: learn the differences between an ordinary team and a high-performing one; know how to increase your personal productivity; be able to determine problems that prevent the team from achieving outstanding results. This course represents highly effective training on developing teamwork skills and teaches students how to interact effectively with other team members. Also, students will learn how to increase their work productivity and resolve and/or avoid conflict situations. Course Outline What is a team and are we really a team? How to improve team performance? The importance of trust and psychological security. How to approach disagreements and conflicts in the team? How to encourage initiative and commitment in the team? How are self-organized teams created and what are their specifics? How to focus on the results we want to achieve? Each topic includes discussions and exercises. Additional course details: Nexus Humans High-Performing Teams training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the High-Performing Teams course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.
Do you want to prepare for your dream job but strive hard to find the right courses? Then, stop worrying, for our strategically modified HR Management and Recruitment Training 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 33 course mega bundle that will exceed your expectations within your budget. The HR Management and Recruitment Training 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 HR Management and Recruitment Training bundle will help you build a solid foundation to become a proficient worker in the sector. This HR Management and Recruitment Training Bundle consists of the following 30 CPD Accredited Premium courses - Course 01:HR Management Course 02:UK Employment Law Course 03:Interview and Recruitment Course 04:Recruitment and Termination Course 05:Safer Recruitment Training Course 06:Employee Performance Management Course 07:Cross-Cultural Awareness Training Course 08:Document Control Course 09:Information Management Course 10:Microsoft Word, PowerPoint & Outlook Course 11:Corporate Paralegal Course 12:Admin, Secretarial & PA Course 13:Stakeholder Management Course 14:Contract Analyst Course 15:Management Skills: A New Manager Course 16:Decision Making and Critical Thinking Course 17:Presentation Skills Course 18:Equality, Diversity and Discrimination Course 19:Workplace Confidentiality Course 20:General Data Protection Regulation (GDPR) Awareness Course 21:Workplace Productivity Course 22:Leadership and People Management Diploma Course 23:Change Management Course 24:Team Management Course 25:Employee Relations Course 26:Corporate Governance Course 27:Online Meeting and Virtual Conference Course 28:Facilities Management Course 29:Motivation Course 30:Life Coaching and Career Counselling 3 Extraordinary Career Oriented courses that will assist you in reimagining your thriving techniques- Course 01: Career Development Plan Fundamentals Course 02: CV Writing and Job Searching Course 03: Interview Skills: Ace the Interview Learning Outcome This tailor-made HR Management and Recruitment Training 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 HR Management and Recruitment Training 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 330 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 HR Management and Recruitment Training 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 HR Management and Recruitment Training 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.
Ensure your well-being and productivity with the Computer Workstation Safety Training course. This course provides essential knowledge and practices to maintain a safe and comfortable computer workstation. Learn about ergonomics, preventing repetitive strain injuries (RSI), and eye injuries. Discover the significance of posture and movement, and master stretching and relaxation techniques. Additionally, understand digital security measures to protect your data and privacy while working at your computer. Elevate your workstation experience with this comprehensive training. Learning Outcomes: Comprehend the principles of computer workstation safety. Implement ergonomic adjustments for a comfortable and efficient workstation. Identify and prevent repetitive strain injuries (RSI) through proper practices. Recognize potential eye strain hazards and apply measures to prevent them. Maintain optimal posture and movement for long-term health and productivity. Utilize stretching and relaxation techniques to reduce tension and stress. Implement digital security practices to safeguard personal and professional information. Develop a holistic understanding of computer workstation safety for a healthier work environment. Why buy this Computer Workstation Safety Training? Unlimited access to the course for forever Digital Certificate, Transcript, student ID all included in the price Absolutely no hidden fees Directly receive CPD accredited qualifications after course completion Receive one to one assistance on every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Certification After studying the course materials of the Computer Workstation Safety Training you will be able to take the MCQ test that will assess your knowledge. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Who is this course for? This Computer Workstation Safety Training course is ideal for Office workers and professionals spending significant time at computer workstations. Individuals concerned about their health and well-being while using computers. Employers aiming to promote a safe and productive workspace. Students and educators seeking to educate themselves and others on workstation safety. Prerequisites This Computer Workstation Safety Training was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Career path Ergonomics Specialist: £30,000 - £60,000 per year. Occupational Health and Safety Officer: £25,000 - £45,000 per year. Workstation Safety Consultant: Earnings vary based on projects. Physical Therapist specializing in office ergonomics: £35,000 - £60,000 per year. Digital Security Analyst: £35,000 - £55,000 per year. Course Curriculum Module 01: Introduction to Computer Workstation Safety Introduction to Computer Workstation Safety 00:03:00 Module 02: Ergonomics in Computer Workstation Ergonomics in Computer Workstation 00:04:00 Module 03: Preventing Repetitive Strain Injuries (RSI) Preventing Repetitive Strain Injuries (RSI) 00:05:00 Module 04: Preventing Eye Injuries Preventing Eye Injuries 00:04:00 Module 05: Posture and Movement Posture and Movement 00:04:00 Module 06: Stretching and Relaxation Techniques Module 06: Stretching and Relaxation Techniques Stretching and Relaxation Techniques 00:04:00 Module 07: Digital Security Digital Security 00:03:00
ð Unlock Your Excel Potential with Microsoft Excel 2019 - Intermediate Level Training! ð Master the art of Excel with our comprehensive online course designed specifically for intermediate learners. Elevate your skills, boost productivity, and excel in spreadsheet management like never before. ð Course Curriculum ð ð¹ Section 1 - Excel - Intermediate: Dive into the intermediate level of Excel functionalities, bridging the gap between basic and advanced techniques. ð¹ Section 2 - Lists: Learn the art of managing data efficiently with lists, organizing information for streamlined analysis and presentation. ð¹ Section 3 - DataBase Functions: Harness the power of database functions, empowering you to manipulate data with ease and precision. ð¹ Section 4 - Data Validation: Ensure data accuracy and integrity by implementing effective data validation techniques, preventing errors in your spreadsheets. ð¹ Section 5 - Importing and Exporting: Master the process of importing and exporting data seamlessly, integrating external information into your Excel sheets effortlessly. ð¹ Section 6 - Creating Basic Charts: Transform data into impactful visuals with basic chart creation, enhancing your ability to communicate insights effectively. ð¹ Section 7 - Pivot Tables: Unlock the potential of pivot tables, harnessing their analytical power to summarize and analyze complex data sets effortlessly. ð¹ Section 8 - Working with Large Data: Navigate and manipulate extensive data sets efficiently, optimizing your workflow with strategies tailored for large-scale information. ð¹ Section 9 - LookUp Functions: Explore lookup functions to search for and retrieve specific data, refining your ability to find information swiftly. ð¹ Section 10 - Advanced Functions: Elevate your Excel proficiency with advanced functions, expanding your capabilities to handle complex calculations and tasks. ð¹ Section 11 - Excel Intermediate - Conclusion: Wrap up your intermediate Excel journey, reinforcing key concepts and preparing you for further advancements. ð Why Choose Our Course? ð ð Comprehensive Learning: A structured curriculum tailored to the needs of intermediate Excel users, covering a wide array of functionalities. ð¨âð« Expert Guidance: Led by industry experts well-versed in Excel, ensuring a rich learning experience with practical insights. ð¤ Interactive Learning: Engage with interactive exercises and real-life examples, solidifying your understanding through hands-on practice. ð Career Growth: Acquire skills highly sought after in the job market, giving you a competitive edge in various professional domains. ð Don't miss this opportunity to take your Excel skills to the next level! Enroll now and unleash your potential with Microsoft Excel 2019 - Intermediate Level Training. ð Course Curriculum Section 1 - Excel - Intermediate Excel Intermediate Introduction 00:00 Intermediate Shortcut Keys 00:00 Section 2 - Lists What are Lists 00:00 Sorting a List 00:00 Sorting - Multiple Criteria 00:00 Custom Sort 00:00 What are Filters 00:00 Format a List as a Table 00:00 Section 3 - DataBase Functions Introduction to DataBase Functions 00:00 DSum Function 00:00 DSum Function - Single Criteria 00:00 DSum Function - Multiple Criteria 00:00 DAverage 00:00 DCount Function 00:00 Subtotal 00:00 Section 4 - Data Validation Data Validation - List 00:00 Data Validation - Decimal 00:00 Input and Error Messages 00:00 Section 5 - Importing and Exporting Importing Data from Text Files 00:00 Importing Data from MS Access 00:00 Exporting Data to a Text File 00:00 Section 6 - Creating Basic Charts Creating Basic Charts 00:00 The Chart Ribbon 00:00 Adding and Modifying Data on a Chart 00:00 Formatting Charts 00:00 Section 7 - Pivot Tables Understanding Pivot Tables 00:00 Creating Pivot Tables 00:00 Pivot Table Calculations 00:00 Grouping Pivot Table Data 00:00 Formatting Pivot Table Data 00:00 Drilling Down into Pivot Table Data 00:00 Creating Pivot Charts 00:00 Filtering Pivot Table Data 00:00 Filtering using the Slicer 00:00 Section 8 - Working with Large Data Grouping Data 00:00 Consolidating Data 00:00 Section 9 - LookUp Functions VLookUp 00:00 HLookUp 00:00 Index and Match 00:00 Section 10 - Advanced Functions FV Function 00:00 PMT Function 00:00 Hyperlinks 00:00 Text to Columns 00:00 Section 11 - Excel Intermediate - Conclusion Excel Intermediate - Conclusion 00:00