5293 Writing courses delivered Online

Advanced Business Plan - Become an Entrepreneur Course Overview This Advanced Business Plan course equips aspiring entrepreneurs with the essential knowledge and skills to develop a comprehensive and effective business plan. Covering every critical aspect from goal setting to identifying your target audience, the course provides learners with strategic insights that enhance long-term business success. Participants will learn how to articulate clear objectives, outline core business elements, and understand the purpose and benefits of a well-crafted business plan. By the end of the course, learners will be confident in preparing a detailed and persuasive business plan that supports both short- and long-term growth, helping them lay a strong foundation for launching or scaling their entrepreneurial ventures. Course Description Delving deeper into the fundamentals of business planning, this course guides learners through the structure, content, and strategic considerations of creating a robust business plan. Topics include defining clear goals, understanding the reasons behind business plans, and recognising key components necessary for success. It also emphasises the importance of tailoring the plan to its intended audience and evaluating essential factors before commencing the planning process. Learners will develop analytical skills for assessing business viability and will be equipped to communicate their vision effectively to potential investors or stakeholders. The course adopts a structured, professional approach, preparing participants to create plans that are both comprehensive and adaptable to evolving business needs. Advanced Business Plan - Become an Entrepreneur Curriculum Module 01: Introduction Module 02: Business Plan for Entrepreneurs Achieve Your Long- and Short-Term Goals Module 03: How a Business Plan Can Help with Long Term Success Module 04: Reasons You Need a Business Plan Module 05: The Elements of a Business Plan Module 06: The Purpose of a Business Plan Module 07: Things to Consider Before Starting a Business Plan Module 08: Who Are You Writing the Business Plan For Module 09: Conclusion (See full curriculum) Who is this course for? Individuals seeking to launch and grow their own business ventures. Professionals aiming to enhance their entrepreneurial and strategic planning skills. Beginners with an interest in entrepreneurship and business management. Anyone preparing to attract investment or partnerships through effective business planning. Career Path Entrepreneur / Business Owner Business Development Manager Startup Consultant Strategic Planner Small Business Advisor

Proofreading & Copyediting Level 5 Course Overview This Proofreading & Copyediting Level 5 course offers an in-depth understanding of the essential skills required for proofreading and copyediting. Learners will explore key techniques for enhancing text accuracy, consistency, and clarity. Through detailed lessons, this course covers proofreading basics, the application of style guides, grammatical rules, and the intricacies of copyediting. Learners will also gain knowledge in legal checks and how to develop a successful career in this field. By the end of the course, participants will have a solid foundation in proofreading and editing, enabling them to produce high-quality written content that meets industry standards. Course Description This comprehensive course dives into the world of proofreading and copyediting, focusing on fundamental skills and advanced techniques. Learners will examine key concepts like applying style guides, understanding grammar rules, and maintaining text accuracy. Modules cover proofreading both on paper and on-screen, copyediting for language use, accuracy, and legal checks. A significant part of the course involves developing an understanding of professional editing practices, which will enable learners to work in various industries such as publishing, marketing, and legal sectors. The course structure is designed to offer a gradual progression, helping learners to refine their skills and gain confidence in producing error-free and well-polished content. Proofreading & Copyediting Level 5 Curriculum Module 01: Proofreading Basics Module 02: Applying the Style Guide Module 03: Spelling and Grammar Module 04: Proofreading on Paper Module 05: Proofreading On-Screen Module 06: Copy-Editing Basics Module 07: Copy-Editing – The Use of Language Module 08: Copy-Editing – Checking Accuracy and Facts Module 09: Copy-Editing – The Beginning and The End Module 10: Copy-Editing – Legal Checks Module 11: Finding Work and Developing Your Career (See full curriculum) Who is this course for? Individuals seeking to improve their proofreading and editing skills. Professionals aiming to advance in editing and publishing careers. Beginners with an interest in editing and writing industries. Anyone seeking to refine their written communication. Career Path Proofreader Copyeditor Content Editor Publishing Assistant Editorial Assistant Freelance Proofreader/Copyeditor Legal Proofreader Publishing Manager

Course Overview Egypt is a country rich with mystery and exciting historical events. Enrich your knowledge about this fascinating country through the Egyptology course. You will get a tour of Egypt without even stepping out of the house. In this Egyptology course, you will receive detailed lessons on different areas of Ancient Egypt. The informative modules will educate you on the Egyptian dynasty, government, society and much more. You will learn about the art and architecture of Ancient Egypt. In addition. You will get introduced to the fundamentals of the trading system, military forces, writings and language used in Ancient Egypt. Through this course, you will not only learn about this historical nation but also receive a certificate of achievement. So enrol now and start learning! Learning Outcomes Learn about the different dynasties of Egypt Enrich your knowledge of Egyptian gods and goddesses Understand the system of Egyptian government and society Explore the fundamentals of Egyptian art and architecture Discover the principles of trade and military force of Ancient Egypt Gain in-depth knowledge of the language, writing and numeral system of Ancient Egypt Assessment and Certification At the end of the Egyptology course, you will be required to sit for an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful. After you have successfully passed the final exam, you will be able to order an Accredited Certificate of Achievement at an additional cost of £19 for a PDF copy and £29 for an original print copy sent to you by post or for both £39. Career Path This Egyptology course will provide you with an in-depth understanding of the subject. On successful completion, you will have the skills, confidence and practical knowledge to fast-track a successful career in relevant sectors. Professions in this field include: History Teacher Historian

Forensic Psychology: Forensic Psychology Would you like to work in the field of forensic psychology? If so, then you should try our special forensic psychology course. The forensic psychology course provides an interdisciplinary study of psychology and the legal system. The forensic psychology course includes criminal behaviour analysis, criminal profiling, and mental health evaluations in legal contexts. Moreover, the forensic psychology course covers eyewitness testimony, jury decision-making, and offender rehabilitation. Students in our forensic psychology course explore the application of psychological principles in criminal investigations and courtroom procedures. Additionally, this forensic psychology course teaches correctional settings. Enrol in our forensic psychology course to learn about ethical considerations and professional standards of this field. Learning outcome of forensic psychology course This forensic psychology course will teach about: Foundations of forensic psychology. The forensic psychology course teaches how to analyse criminal behaviour. Forensic interviewing and interrogation are also explained in this forensic psychology course. Criminal profiling and forensic psychopathology are also included in the forensic psychology course. Forensic psychology course teaches ethics in forensic psychology. Research methods in forensic psychology and forensic report writing are included in this forensic psychology course. Special Offers of this Forensic Psychology: Forensic Psychology Course This Forensic Psychology: Forensic Psychology includes a FREE PDF Certificate. Lifetime access to this Forensic Psychology: Forensic Psychology Course Instant access to this Forensic Psychology: Forensic Psychology Course Get FREE Tutor Support to this Forensic Psychology: Forensic Psychology Course Forensic Psychology: Forensic Psychology Unlock the mysteries of the human mind with our Forensic Psychology course. Dive deep into Forensic Psychology concepts, methodologies, and applications. Gain invaluable insights into Forensic Psychology practices and principles. Enroll now to embark on a journey into the fascinating world of Forensic Psychology. Don't miss out! Who is this course for? Forensic Psychology: Forensic Psychology Aspiring psychologists who are curious about how psychology and the judicial system interact should take this forensic psychology course. Requirements Forensic Psychology: Forensic Psychology Course To enrol this Forensic Psychology: Forensic Psychology Course, students must fulfil the following requirements. To join in our Forensic Psychology: Forensic Psychology Course, you must have a strong command of the English language. To successfully complete our Forensic Psychology: Forensic Psychology Course, you must be vivacious and self driven. To complete our Forensic Psychology: Forensic Psychology Course, you must have a basic understanding of computers. A minimum age limit of 15 is required to enrol in this Forensic Psychology: Forensic Psychology Course. Career path Forensic Psychology: Forensic Psychology Enrolling in a forensic psychology course might lead to a multitude of professional opportunities.

Course overview When the mind refuses to cooperate, we feel stuck at work. Through bullet journaling, you can organise your thoughts. You can keep track of your daily activities and make small steps forward every day. This Bullet journaling - The ultimate guide for beginners course explains what bullet journaling is and guides you through the steps to get started with it. You will learn how to create a journal to plan your thoughts and track your progress and growth. The course will take you through setting up your bullet journal and making page spreads and layouts for your journal. You will learn how to create an index, key, future log and daily entry. Once you complete, you will be able to create a journal based on your preferences and make journaling a lifelong habit. Learning outcomes Understand the fundamentals of bullet journaling Learn the essential steps to set up your journal Identify what kind of journal you want Explore the equipments and supplies necessary for setting up your bullet journal Learn the creative ways to design your journal Be able to create lists and trackers Gain the life-long journaling habit Who Is This Course For? The Bullet journaling - The ultimate guide for beginners course is highly beneficial for anyone interested in learning what a bullet journal is and how to get started with it. The skills gained from this training will provide excellent opportunities for career advancement.  Entry Requirement This course is available to all learners of all academic backgrounds. Learners should be aged 16 or over. Good understanding of English language, numeracy and ICT skills are required to take this course. Certification After you have successfully completed the course, you will obtain an Accredited Certificate of Achievement. And, you will also receive a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hardcopy for £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 and materials from the industry-leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; United Kingdom & internationally recognised accredited qualification; Access to course content on mobile, tablet and desktop from anywhere, anytime; Substantial career advancement opportunities; 24/7 student support via email. Unit 01: Introduction Module 01: Who is Samantha Kristoferson? 00:02:00 Module 02: Warming Up Exercise 00:01:00 Module 03: History of Bullet Journal 00:02:00 Module 04: Before You Get Started! 00:03:00 Module 05: What the heck is Bullet Journaling? 00:10:00 Module 06: A Recipe for an Extraordinary Life. 00:04:00 Unit 02: Setting Up Your Bullet Journal Module 01: Basic Set Up: Type of Journal 00:04:00 Module 02: Supplies Necessary 00:05:00 Module 03: Hacks and Tips Overview 00:06:00 Unit 03: Step-by-step with the Bullet Journal System Module 01: Creating an Index 00:01:00 Module 02: Creating a Key 00:01:00 Module 03: Creating a Future Log 00:02:00 Module 04: Creating a Month at a Glance 00:02:00 Module 05: Creating a Daily Entry 00:02:00 Module 06: Creating Lists and Trackers 00:03:00 Unit 04: Closer look at Hacks and Tips Module 01: Post-its 00:04:00 Module 02: Divider Tab 00:03:00 Module 03: Tape Important Pages 00:03:00 Module 04: Cut out Marks 00:03:00 Module 05: Envelope Pockets 00:02:00 Unit 05: Making Journaling a Life Long Habit Module 01: How to create journal habits 00:05:00 Module 02: Congratulations! 00:04:00 Unit 06: BONUS Module 01: Reflection about my 2018 Bullet Journal 00:05:00 Module 02: Setting up my Journal for 2019 00:02:00 Module 03: Overview of my Weekly Planner Exercise 00:02:00 Module 04: Overview of the 7 Ingredients Exercise 00:02:00 Module 05: Emilio´s Journal 00:05:00 Module 06: Why Bullet Journaling Is So Popular 00:03:00 Module 07: How to Reduce Overwhelm Using Journaling 00:02:00 Unit 07: Self-Improvement Template Tutorials Module 01: Visualize Your Ideal Week Tutorial 00:02:00 Module 02: Top 10 Self Care List 00:02:00 Module 03: Lifestyle Design Template Tutorial 00:02:00 Module 04: A Minimalist Habit Tracker Template Tutorial 00:01:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

The Fashion and Lifestyle Blogger Online Course teaches you how to build a blog from the ground up and grow it into a brand. You’ll learn how to plan great content, take beautiful photos, and share your style and ideas online. The course also covers how to grow your following, work with brands, earn money, and build your own unique identity as a blogger. If you love fashion, enjoy writing, or want to share your lifestyle with the world, this course gives you the tools to do it with confidence. Course Curriculum ✓ Module 01: Blogging 101 ✓ Module 02: Starting Out and Setting Up ✓ Module 03: Content Creation ✓ Module 04: Photography and Imagery ✓ Module 05: Staying Social ✓ Module 06: Networking and Events ✓ Module 07: Working with Brands ✓ Module 08: Monetising Your Blog ✓ Module 09: Building a Brand ✓ Module 10: Growing as a Blogger ✓ Module 11: The Fashion and Lifestyle Blogger Roundup (Learn more about this online course) Learning Outcomes By the end of this course, you will: Start your own fashion and lifestyle blog from scratch. Create engaging and stylish content. Take great photos that match your brand. Build a strong presence on social media. Network with other bloggers and attend events. Partner with brands and manage collaborations. Earn money from your blog in different ways. Build a personal brand that feels true to you. Keep your audience growing and engaged. Stay inspired and grow as a blogger long-term. Who is this course for? This course is for anyone who loves fashion, beauty, or lifestyle and wants to share their passion through blogging. Whether you’re starting fresh or want to boost an existing blog, this course helps you move forward with clear steps and creative ideas. Eligibility Requirements You don’t need any blogging experience to join this course. Just bring your interest in fashion or lifestyle and a desire to express yourself online. Career Path This course can open doors to blogging, social media management, content creation, and brand partnerships. It’s great for those who want to become influencers, work with fashion or lifestyle brands, or start their own creative business.

Are you ready to embark on an enlightening journey of wisdom with the Web Development 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 - Web Development (CSS, HTML & Bootstrap 4). Delve into eight immersive CPD Accredited courses, each a standalone course: Course 01: Learn Web Development from Scratch Course 02: HTML Web Development Crash Course Course 03: CSS Web Development Crash Course Course 04: Bootstrap 4 Responsive Web Development Course 05: Front End Web Development Training for Everyone Course 06: Web Design in Affinity Designer Course 07: Advanced Diploma in User Experience UI/UX Design Course 08: UX (User Experience) Fundamentals Traverse the vast landscapes of theory, unlocking new dimensions of understanding at every turn. Let the Web Development (CSS, HTML & Bootstrap 4) bundle illuminate your path to wisdom. The Web Development (CSS, HTML & Bootstrap 4) 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 Web Development (CSS, HTML & Bootstrap 4) 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 Web Development 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 Web Development (CSS, HTML & Bootstrap 4) community today and let your voyage of discovery begin! Learning Outcomes: Upon completing this Web Development bundle, the learner will be able to: Attain a holistic understanding in the designated areas of study with the Web Development bundle. Establish robust bases across each course nestled within the Web Development bundle. Decipher intricate concepts through the articulate content of the Web Development 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 Web Development 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 Web Development 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 Web Development bundle fosters personal growth, enabling learners to skillfully navigate the complexities of the world. The Web Development 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 Web Development bundle allows learners to make meaningful contributions to their chosen fields. Embark on the Web Development journey and let knowledge guide you towards a brighter future. CPD 85 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Web Development bundle is suitable for: Aspiring Web Developers: Beginners seeking foundational web development skills. Front-End Developers: Professionals enhancing skills in responsive design and user experience. Graphic Designers: Designers expanding into web design using tools like Affinity Designer. UX/UI Designers: Specialists improving their knowledge in user experience and UI design. Entrepreneurs: Business owners wanting to build or manage their websites. Anyone with a thirst for knowledge and a passion for continuous learning. Requirements Without any formal requirements, you can delightfully enrol in this Web Development bundle. Career path This Web Development bundle will help to pursue various career paths: Junior Web Developer HTML Developer CSS Developer Bootstrap Web Developer Front-End Web Developer UI/UX Designer 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 Hardcopy Transcript - £9.99

Course Overview The 120 Hours TEFL (TESOL) Masterclass is a comprehensive programme designed for individuals aspiring to teach English as a foreign or second language. This course provides a robust foundation in teaching methodologies, linguistics, grammar, pronunciation, and classroom management. Learners will develop the confidence and competence needed to deliver engaging and effective English lessons across diverse cultural and educational settings. By the end of the course, participants will be equipped with the theoretical knowledge and instructional strategies to teach English successfully to learners of all ages and proficiency levels. This qualification opens the door to teaching opportunities worldwide, enhancing employability in an ever-expanding global market. Whether seeking to start a new career, travel while teaching, or advance existing skills, this course offers valuable expertise and an internationally recognised credential. Course Description This professionally structured TEFL (TESOL) Masterclass covers all the essential aspects of English language teaching. Modules explore topics such as second language acquisition, teaching receptive and productive skills, lesson planning, classroom management, and the integration of technology into teaching. Learners will gain a solid grounding in linguistics, master techniques for teaching grammar, vocabulary, pronunciation, and discover innovative ways to motivate students through games and activities. Throughout the course, participants will build essential skills for creating dynamic learning environments and adapting teaching methods to different learner needs. With a focus on academic excellence and professional development, this course prepares learners for a rewarding career in English language teaching across schools, private institutions, and online platforms. Upon completion, learners will possess a deep understanding of English teaching practices, ready to inspire students and contribute meaningfully to educational communities around the world. Course Modules Module 01: Introduction to English Language Teaching and Learning Module 02: Linguistics Module 03: English Pronunciation Module 04: Teaching Grammar and Vocabulary Module 05: Language Teaching Methodologies Module 06: Teaching Receptive Skills: Reading Module 07: Teaching Productive Skills: Writing Module 08: Teaching Receptive Skills: Listening Module 09: Teaching Productive Skills: Speaking Module 10: Lesson Planning Module 11: Use of Games and Activities Module 12: Technology in Second Language Teaching Learning Module 13: Classroom Management and Student Motivation Module 14: Teaching English: Situational Approach Module 15: Professional Development and Employment (See full curriculum) Who is this course for? Individuals seeking to teach English to speakers of other languages. Professionals aiming to transition into the education sector or broaden their teaching credentials. Beginners with an interest in English language teaching and global communication. Travellers and expatriates looking to pursue international teaching opportunities. Recent graduates considering a career in education and language instruction. Career Path English as a Foreign Language (EFL) Teacher English as a Second Language (ESL) Instructor Online English Tutor Academic English Teacher English Language Programme Coordinator English Curriculum Developer Private Language Institute Teacher International School English Teacher

Course Overview This comprehensive course offers a deep dive into three essential technologies for data science: Python, JavaScript, and Microsoft SQL. Learners will gain foundational knowledge and practical skills in each of these key areas, which are crucial for handling data, creating interactive websites, and working with databases. By the end of the course, students will be proficient in writing Python code for data analysis, creating dynamic web content with JavaScript, and managing data with Microsoft SQL. The course is designed to equip learners with the technical skills needed to succeed in data science, making it a valuable investment for anyone looking to excel in this growing field. Course Description In this course, learners will explore the core principles of Python, JavaScript, and Microsoft SQL, all tailored to the needs of data science professionals. The curriculum covers Python’s data structures, functions, and libraries essential for data analysis, while JavaScript introduces students to web development skills, including client-side validation and data visualisation. The Microsoft SQL section focuses on data management, including filtering, joining, and structuring queries. Learners will develop a solid understanding of these technologies, which will enable them to manipulate data, automate processes, and design interactive applications. The course also includes real-world applications, ensuring learners are well-prepared for future opportunities in data science and web development. Course Modules: Module 01: JavaScript Getting Started Module 02: JavaScript Fundamentals Module 03: JavaScript Strings Module 04: JavaScript Operators Module 05: JavaScript Conditional Statements Module 06: JavaScript Control Flow Statements Module 07: JavaScript Functions Module 08: Data Visualization (Google Charts) Module 09: JavaScript Error Handling Module 10: JavaScript Client-Side Validations Module 11: Python Introduction Module 12: Python Basic Module 13: Python Strings Module 14: Python Operators Module 15: Python Data Structures Module 16: Python Conditional Statements Module 17: Python Control Flow Statements Module 18: Python Core Games Module 19: Python Functions Module 20: Python Args, KW Args for Data Science Module 21: Python Project Module 22: Publish Your Website for Live Module 23: MS SQL Statements Module 24: MS SQL Filtering Data Module 25: MS SQL Functions Module 26: MS SQL Joins Module 27: MS SQL Advanced Commands Module 28: MS SQL Structure and Keys Module 29: MS SQL Queries Module 30: MS SQL Structure Queries Module 31: MS SQL Constraints Module 32: MS SQL Backup and Restore (See full curriculum) Who is this course for? Individuals seeking to enhance their skills in data science. Professionals aiming to expand their knowledge in programming and database management. Beginners with an interest in Python, JavaScript, and SQL. Anyone looking to enter the field of data science or web development. Career Path Data Scientist Web Developer Database Administrator Data Analyst Front-End Developer Full Stack Developer Data Engineer

Join our Microsoft Excel course and discover your hidden skills, setting you on a path to success in this area. Get ready to improve your skills and achieve your biggest goals. The Microsoft Excel course has everything you need to get a great start in this sector. Improving and moving forward is key to getting ahead personally. The Microsoft Excel course is designed to teach you the important stuff quickly and well, helping you to get off to a great start in the field. So, what are you looking for? Enrol now! You will Learn The Following Things: Learn strategies to boost your workplace efficiency. Hone your skills to help you advance your career. Acquire a comprehensive understanding of various topics and tips. Learn in-demand skills that are in high demand among UK employers This course covers the topic you must know to stand against the tough competition. The future is truly yours to seize with this Microsoft Excel. Enrol today and complete the course to achieve a certificate that can change your career forever. Details Perks of Learning with IOMH One-to-one support from a dedicated tutor throughout your course. Study online - whenever and wherever you want. Instant Digital/ PDF certificate 100% money back guarantee 12 months access Process of Evaluation After studying the course, an MCQ exam or assignment will test your skills and knowledge. You have to get a score of 60% to pass the test and get your certificate. Certificate of Achievement After completing the Microsoft Excel course, you will receive your CPD-accredited Digital/PDF Certificate for £5.99. To get the hardcopy certificate for £12.99, you must also pay the shipping charge of just £3.99 (UK) and £10.99 (International). Who Is This Course for? This Microsoft Excel is suitable for anyone aspiring to start a career in relevant field; even if you are new to this and have no prior knowledge, this course is going to be very easy for you to understand.  On the other hand, if you are already working in this sector, this course will be a great source of knowledge for you to improve your existing skills and take them to the next level.  This course has been developed with maximum flexibility and accessibility, making it ideal for people who don't have the time to devote to traditional education. Requirements There is no prerequisite to enrol in this course. You don't need any educational qualification or experience to enrol in the Microsoft Excel course. Do note: you must be at least 16 years old to enrol. Any internet-connected device, such as a computer, tablet, or smartphone, can access this online course. Career Path The certification and skills you get from this Microsoft Excel Course can help you advance your career and gain expertise in several fields, allowing you to apply for high-paying jobs in related sectors. Course Curriculum Unit 01: Excel from A-Z Course Introduction Excel from A-Z Course Intro 00:03:00 Excel Job Opportunities 00:03:00 Excel Job Types 00:04:00 Microsoft Excel Marketplace 00:04:00 What is Microsoft Excel? 00:04:00 Who is This Course For? 00:03:00 Unit 02: Getting Started With Excel Finding & Opening Excel 00:01:00 Excel's Start Screen 00:03:00 Explaining the Excel Interface 00:03:00 Excel Interface Continued 00:01:00 Excel Workbook vs. Excel Worksheet 00:02:00 Saving an Excel Document 00:04:00 Customizing the Quick Access Toolbar 00:02:00 Customizing the Excel Ribbon 00:03:00 Excel Shortcut Keys 00:02:00 Unit 03: Values, Referencing and Formulas Creating Excel Labels 00:03:00 Entering Numeric Values in Excel 00:03:00 Formatting Date Values in Excel 00:05:00 Building Basic Formulas in Excel 00:05:00 Order of Operations 00:06:00 Relative vs. Absolute Cell References 00:07:00 Unit 04: Intro to Excel Functions Excel Functions Explained 00:03:00 The SUM() Function 00:08:00 The MIN() & MAX() Function 00:04:00 The AVERAGE() Function 00:02:00 COUNT() Functions 00:05:00 Unit 05: Adjusting Excel Worksheets Moving & Copying Data 00:07:00 Insert & Delete Rows and Columns 00:05:00 Adjusting the Width and Height of Cells 00:05:00 Hiding and Unhiding Excel Rows and Columns 00:04:00 Renaming, Moving & Deleting Excel Worksheets 00:05:00 Adding Protection to Specific Cells 00:04:00 Protecting the Structure of a Workbook 00:02:00 Adding a Workbook Password to Open File 00:02:00 Unit 06: Visually Pleasing Cell Formatting Formatting Fonts and Cell Background Color 00:05:00 Adding Cell Borders 00:05:00 Formatting Data Appropriately 00:05:00 The Magic behind Excel's Format Painter 00:03:00 Creating Styles for Formatting Efficiency 00:06:00 Merging Cells for a Cleaner Look 00:03:00 The Power of Conditional Formatting 00:06:00 Unit 07: How to Insert Images and Shapes! Grab User's Attention using Illustrations 00:09:00 Customizing Icons 00:05:00 Create Compelling Graphics with SmartArt 00:06:00 Unit 08: Visualize Data with Charts The Commonly Used Column Chart 00:03:00 Changing the Chart Design.mp4 00:02:00 Formatting Elements of a Chart 00:06:00 Modifying the Data, Type & Location of a Chart 00:06:00 Unit 09: Excel's Printing Options Print Preview Options 00:04:00 Excel's Page Layout View 00:07:00 Printing a Specific Range of Cells 00:03:00 Converting Spreadsheets to PDF Files 00:02:00 Unit 10: Benefits of Using Excel Templates Why Create an Excel Template 00:01:00 How to Create an Excel Template 00:05:00 Unit 11: Working with Excel Datasets How to Prepare Data for Analysis 00:04:00 How to Sort Data in Excel 00:03:00 Multi-Level Sorting 00:03:00 Custom Sorting Datasets in Excel 00:02:00 Applying Filters to Datasets 00:05:00 Creating Subtotals within a Dataset 00:06:00 Converting Datasets into Tables 00:06:00 Little Slice of Pie Charts 00:05:00 Finding & Removing Duplicate Values 00:07:00 Unit 12: Excel Database Functions The SUMIF() Function 00:09:00 The DSUM() Function 00:08:00 The DSUM() Function Cont. 00:07:00 The SUBTOTAL() Function 00:06:00 Unit 13: Excel Data Validation What is Excel Data Validation? 00:02:00 Creating a Drop Down List with Data Validation 00:07:00 Different Types of Excel Data Validation 00:06:00 Adding Custom Alerts to Data Validation 00:07:00 Creating a Dynamic Drop Down List 00:03:00 Complex Validation: Dependent Drop Down List! 00:09:00 Unit 14: Excel PivotTables Creating an Excel Pivot Table 00:06:00 Modifying Excel PivotTables 00:06:00 Grouping & Filtering PivotTable Data 00:06:00 Drilling Down into PivotTable Data 00:02:00 Creating Pivot Charts & Utilizing Slicers 00:08:00 Unit 15: Excel's PowerPivot Add-In What is PowerPivot? 00:04:00 Activating the Excel PowerPivot Add-In 00:02:00 Creating Relationships between Data Tables.mp4 00:06:00 Using Data Models to Create PivotTables 00:05:00 How to Create PowerPivot KPI's 00:08:00 Unit 16: Excel's Conditional Functions Excels IF Function 00:05:00 IF() Function with AND() Criteria 00:05:00 IF() Function with OR() Criteria 00:05:00 Nesting Multiple IF() Functions 00:07:00 The COUNTIF() Function 00:04:00 Key Benefits of Named Ranges 00:04:00 Unit 17: Excel's Lookup Function VLOOKUP() Function 00:09:00 The Beauty of Excel's IFERROR() Function 00:04:00 HLOOKUP() Function 00:06:00 The INDEX Function 00:05:00 MATCH() Function 00:05:00 INDEX() and MATCH() Combined 00:05:00 Two-Way Lookup with INDEX() and MATCH() 00:04:00 Unit 18: Text Based Functions in Excel LEFT(), RIGHT() and MID() Function 00:07:00 Extracting Specific Text using LEN() & SEARCH() 00:13:00 Combining Text with CONCATENATE() 00:06:00 Quick Tips & Other Text Based Functions 00:06:00 Unit 19: Auditing Formulas and Views in Excel Tracing Precedents & Dependents in Formulas 00:04:00 Showing Formulas 00:02:00 Grouping Data 00:03:00 3D Referencing in Formulas 00:05:00 Utilizing the Watch Window in Excel 00:03:00 How to Freeze Panes in Excel 00:03:00 Unit 20: Excel's 'what If?' Tools Excel's Scenario Manager Tool 00:06:00 Goal Seek in Excel 00:06:00 Compare Results with Excel Data Tables 00:04:00 Solver Tool 00:11:00 Unit 21: Welcome to Excel VBA The Power Behind Excel VBA 00:03:00 A Look Inside the Visual Basic Editor (VBE) 00:04:00 Recording a Macro 00:09:00 Saving & Opening a Macro-Enabled Workbook 00:02:00 Unit 22: The VBA Language Modules and Procedures 00:07:00 Objects, Methods and Properties 00:06:00 Excel VBA Variables 00:05:00 Unit 23: Writing VBA Code Referencing a Range 00:13:00 InputBox & MsgBox 00:06:00 Using Variables in VBA Code 00:05:00 If Then Else Statement 00:10:00 Worksheet Functions inside VBA 00:08:00 Creating User Defined Functions 00:09:00 User Defined Functions within VBA Scripts 00:06:00 Unit 24: Important VBA Tools and Logic Find Last Row of Data 00:06:00 Find Last Column of Data 00:03:00 With Statement 00:05:00 Debugging & Error Handling 00:07:00 Debugging & Error Handling Cont. 00:07:00 Unit 25: Excel VBA Loop For Next Loop 00:09:00 Do Until Loop 00:06:00 For Each Loop 00:04:00 Unit 26: Triggering Macros Assigning Macros to Shapes 00:04:00 Form Controls vs ActiveX Controls 00:08:00 Worksheet Events 00:04:00 Workbook Events 00:03:00 Fun with VBA Events! 00:07:00 Unit 27: Excel User Forms Creating an Excel UserForm 00:03:00 Adding Controls to UserForms 00:10:00 How to Show an UserForm 00:03:00 Passing TextBox Values to Desired Cells 00:07:00 Passing Option Buttons to Desired Cells 00:07:00 UserForm ComboBoxes 00:08:00 Clearing Values from UserForm Controls 00:03:00 How to Close an UserForm 00:02:00 UserForms and Protected Sheets 00:05:00 Unit 28: Starting a Career in Excel Creating an Excel Resume 00:05:00 Getting Started with Freelancing 00:06:00 How to Become an Excel Freelancer 00:05:00 Top Freelance Websites 00:05:00 How to Get Your First Client 00:08:00 Personal Branding 00:07:00 Networking Do's and Don'ts 00:04:00 Importance of Having a Website 00:04:00 Resources Resources - Microsoft Excel 00:00:00