5808 Writing courses

Develop your SQL skills, with useful insights into the MySQL syntax, SQL join statements, and more

DATE: 18th June TIME: 4pm LOCATION: Studio A Join us for an afternoon discussing screenwriting and storytelling with Bob Schultz, who will focus on skills involving pitching, story development and selling yourself as a writer. Be sure to book your ticket in advance for this event!

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.

Are you sitting comfortably? From postural issues to eye strain, the regular use of display screen equipment can cause many issues. Learn the steps to make the use of DSE as comfortable as possible with this 30-minute online Short Course. Are You Sitting Comfortably? Every day hundreds of thousands of us spend multiple hours using display screen equipment (DSE), a computer at work, a laptop or tablet at home, with little regard for the health problems it may cause us. From postural issues to eye strain, repetitive strain injury to headaches - if you’re using display screen equipment regularly you may suffer from one or more of these conditions. The good news is that there are steps you can take to make working with DSE as comfortable as possible. This course outlines the steps you should take. The Course Highfield’s Display Screen Equipment (DSE) Short Course is designed to ensure that users of DSE set up their work stations effectively and ergonomically, avoiding the health risks associated with their use. Learners undertaking this course will learn what DSE is, the health risks associated with its use, how to use DSE appropriately and the importance of correct posture and regular breaks. Finally, the course will outline the kind of support employers should provide for users of DSE at work. Areas Covered What is DSE? DSE health risks Workstation design Correct working position for DSE Portable equipment Identifying risks and safe working practices Eye tests and eyewear Assessing DSE

Document Control: Document Control Course Online Would you like your Document Control: Document Control Course talents to be better? If so, you are welcome to enrol in our specially created Document Control: Document Control Course, which is intended to provide participants an in-depth understanding. This Document Control: Document Control Course will teach you about the basics of document control and the identification of document control: document control. Also, the Document Control course describes how to classify and secure the document control: document control system. Moreover, the Document Control: Document Control course emphasises on Document Control lifecycle, legal concepts, Document Control: Document Control Course best practices and the underlying expertise. You will be more productive at preparing the final documentation, management after completing our Document Control: Document Control training. As a document control: document control expert you can handle teams, engineering and management of document control: document control. Unlock your potential in the Document Control: Document Control Course process! Main Course: Document Control Course Free Courses included with Document Control: Document Control Course Document Control Course Offers free Paralegal Document Control Course Offers free Business Writing Document Control Course Offers free Proofreading & Copyediting Special Offers of this Document Control: Document Control Course: This Document Control: Document Control Course includes a FREE PDF Certificate. Lifetime access to this Document Control: Document Control Course Instant access to this Document Control: Document Control Course 24/7 Support Available to this Document Control: Document Control Course [ Note: Free PDF certificate as soon as completing the Document Control: Document Control Course] Document Control: Document Control Course Online This Document Control: Document Control Course consists of 11 modules. Course Curriculum of Document Control: Document Control Course Module 01: Introduction to Document Control Module 02: The Basics of Document Control Module 03: Document Identification Module 04: Document Classifying, Filing & Information Security Module 05: Documents Lifecycle Module 06: Document Distribution Module 07: Project Document Control Module 08: As-Built and Final Documentation Module 09: Document Control Procedures and Specifications Module 10: Electronic Document Management Systems Module 11: Interactions with Project Teams, Engineering Teams, Managers Assessment Method of Document Control: Document Control Course After completing Document Control: Document Control Course, you will get quizzes to assess your learning. You will do the later modules upon getting 60% marks on the quiz test. Apart from this, you do not need to sit for any other assessments. Certification of Document Control: Document Control Course After completing the Document Control: Document Control Course, you can instantly download your certificate for FREE. The hard copy of the certification will also be delivered to your doorstep via post, which will cost £13.99. Who is this course for? Document Control: Document Control Course Online A wide spectrum of people who are keen to advance their knowledge and abilities in Document Control: Document Control: Document Control Training are catered to by this Document Control: Document Control Course. Requirements Document Control: Document Control Course Online To enrol in this Document Control: Document Control Course, students must fulfil the following requirements: Good Command over English language is mandatory to enrol in our Document Control Course. Be energetic and self-motivated to complete our Document Control: Document Control Course. Basic computer Skill is required to complete our Document Control: Document Control Course. If you want to enrol in our Document Control Course, you must be at least 15 years old. Career path Document Control: Document Control Course Online Successful completion of a Document Control: Document Control Course on document control training can lead to interesting employment prospects in a variety of document control training-related sectors.

Office Management: Office Management Course Online The Office Management: Office Management Course is ideal for those who want to work as office managers or programme managers. The Office Management: Office Management Course will place a strong emphasis on project management, business administration, and information and knowledge management methods. This Office Management: Office Management Course is for both aspiring beginners and experienced professionals who want to gain a detailed understanding of important business management topics. Pursue your goals by enrolling in our Office Management: Office Management Course now and gain the knowledge, skills, and information you need to advance your career. This Office Management: Office Management Course will help you empower yourself with the skills you need to get your ideal job. Why choose this Office Management: Office Management Course from the School of Health Care? Self-paced course, access available from anywhere in the world. High-quality study materials that are easy to understand. Office Management: Office Management Course developed by industry experts. After each module, there will be an MCQ quiz to assess your learning. Assessment results are generated automatically and instantly. 24/7 support is available via live chat, phone call, or email. Free PDF certificate after completing the Office Management: Office Management Course. [ Note: Free PDF certificate will provide as soon as completing the Office Management : Office Management Online Course] Office Management: Office Management Course Online Course Curriculum of Office Management: Office Management Course Module 01: Fundamentals of Office Administration Module 02: Qualities of an Effective Administrator Module 03: Information regarding shipping and mail services Module 04: Ways to create effective plans and schedule. Module 05: Outline setting up conferences and meetings. Module 06: Business Writing Techniques Module 07: Management of time Module 08: An Overview of Stress Management Module 09: Telephone Business Proficiency Module 10: Communication Techniques Module 11: Strategies to manage conflicts. Module 12: Business etiquette guidelines Module 13: Basics of Microsoft Office Skills Certification of Office Management: Office Management Course After completing the Office Management: Office Management Online course, you can instantly download your certificate for FREE. The hard copy of the certification will also be delivered to your doorstep via post, which will cost £13.99. Assessment Method of Office Management: Office Management Course After completing Office Management: Office Management Online Course, you will get quizzes to assess your learning. You will do the later modules upon getting 60% marks on the quiz test. Apart from this, you do not need to sit for any other assessments. Who is this course for? Office Management: Office Management Course Online Learners can take this Office Management: Office Management Course without any prior knowledge of this topic, and there are no age restrictions. As a result, anyone interested in Office Management and Administration can enrol in the course. Requirements Office Management: Office Management Course Online To enrol in this Office Management: Office Management Course, students must fulfil the following requirements: Good Command over English language is mandatory to enrol in our Office Management: Office Management Course. Be energetic and self-motivated to complete our Office Management: Office Management Course. Basic computer Skill is required to complete our Office Management: Office Management Course. If you want to enrol in our Office Management: Office Management Course, you must be at least 15 years old. Career path Office Management: Office Management Course Online After completing the Office Management : Office Management course/training, you will be able to confidently grasp specific knowledge and skills in order to improve yourself and enhance your skills for a career in the relevant employment sector.

Executive PA: Executive PA Training Online Introducing Executive PA: Executive PA Training Course "Empowering the Next Generation" Online course! This Executive PA: Executive PA Training could be the key to your dream job. Transform your ambition and enthusiasm into a rewarding career for life by studying from home at your own pace and time. After Completing this Executive PA : Executive PA Training learn how to handle a wide range of essential office administration tasks, as well as how to write important business letters and handle complex mail and shipping requirements. Making travel arrangements on behalf of others, organising meetings and events, the importance of time management as a PA, and how to become a better communicator are also covered in the Executive PA: Executive PA course. Our Executive PA: Executive PA Training course has been designed to equip you with the essential knowledge and skills needed to become an expert executive secretary or personal assistant and will give you all the practical knowledge & credentials that you need to excel in your new role. Enrol on our Executive PA: Executive PA Training course today and begin your journey to improve your career prospects with the latest skills and the power of self-belief! Courses including with this Executive PA: Executive PA Training Course bundle. Course 01: Executive PA Training Course 02: Office Management and Administration Course 03: Minute Taking Course Course 04: HR Management Course Course 05: Time Management Course Special Offers of this Executive PA: Executive PA Course: This Executive PA: Executive PA Course includes a FREE PDF Certificate. Lifetime access to this Executive PA: Executive PA Course Instant access to this Executive PA: Executive PA Course 24/7 Support Available to this Executive PA: Executive PA Course [ Note: Free PDF certificate as soon as completing the Executive PA: Executive PA Training course] Executive PA: Executive PA Training Online This Executive PA: Executive PA Training course consists of 11 modules. Unlock your potential with our Executive PA: Executive PA Training, the perfect pathway to your dream job. This Executive PA: Executive PA course allows you to study at your own pace, transforming your ambition into a lifelong career. Through our Executive PA: Executive PA Training, you'll master essential office administration tasks, business letter writing, and complex mail handling. Additionally, our Executive PA: Executive PA course covers making travel arrangements, organizing meetings and events, and time management. Become a better communicator and elevate your career with our comprehensive Executive PA: Executive PA Training. Start your journey today! Who is this course for? Executive PA : Executive PA Training Online This Executive PA: Executive PA Training course is designed for existing secretarial/administrative workers seeking advancement or newcomers seeking their first professional position. Requirements Executive PA : Executive PA Training Online To enrol in this Executive PA: Executive PA Training Course, students must fulfil the following requirements: Good Command over English language is mandatory to enrol in our Executive PA: Executive PA Training Course. Be energetic and self-motivated to complete our Executive PA: Executive PA Training Course. Basic computer Skill is required to complete our Executive PA: Executive PA Training Course. If you want to enrol in our Executive PA: Executive PA Training Course, you must be at least 15 years old. Career path Executive PA: Executive PA Training After completing this Executive PA: Executive PA Training course, you may be able to pursue a variety of promising career opportunities, such as: Office Assistant or Executive PA Receptionist Personal Concierge Executive Assistant

Duration 3 Days 18 CPD hours This course is intended for This is an introductory-level XML training course, designed for those needing an introduction to concepts and technologies associated with XML and its related recommendations. Previous experience or knowledge of HTML is helpful but not essential. Overview This course is an intensive, hands-on introduction to XML, XPath, and XSLT. The course is a balanced mixture of theory and practical labs designed to take students from the basic fundamentals of XML through to the related advanced technologies. The students walk through the different standards in a structured manner to enable them to master the concepts and ideas, which are reinforced in the lab exercises. The course starts with the fundamentals of XML, including coverage of DTDs and XML Schema. It then moves on to the XPath and XSLT standards, and how to use them to transform XML documents into other documents such as HTML documents or other XML documents. This course provides indoctrination in the practical use of W3C standards (including XSL and XML Schema) and of implementing tools and technologies. This course is programming language independent, making it useful for Java, .NET, C++, and any other programming orientation. Graduates will hit the ground running, applying XML to projects at both an architectural as well as a line by line coding level. We can easily adapt this course to industry and client specific needs.In addition to valuable knowledge and working examples, students receive a copy of the 'Xtensil' product. This unique software was developed to assist in implementing, testing, and fielding XML applications. Xtensil is used as both a teaching aid and a straightforward, basic, fully functional XML toolkit that students can use on Windows and Linux platforms. Working in a hands-on learning environment student will learn to: Write well-formed XML documents Model business requirements using XML Handle XML reserved characters Validate an XML document with a DTD and with a Schema Centralize data and markup definition with entities Create DTDs and Schemas using XML tools Generate XML documents from databases Write XSL templates to transform XML documents into HTML Integrate XML, XSL and the DOM to implement a complete solution The Extensible Markup Language (XML) is a standard that is enabling a revolution in web applications and business to business interactions. XML is the basis for Wireless Markup Language (WML), Voice Markup Language (VoiceML), Simple Object Access Protocol (SOAP), Web Services, and numerous industry initiatives such as ACORD (insurance), PXML (proposal/RFP) and OTA (travel). Introduction to XML is a three-day, hands-on course geared for software developers who need to understand what XML is and how to use in with today's systems and architectures. This course covers the topics from tags to architectures. The course is a balanced mixture of theory and practical labs designed to take students from a quick review of the basic fundamentals of XML through to the related advanced technologies. The students walk through the different standards in a structured manner to enable them to master the concepts and ideas, which are reinforced in the lab exercises. The course starts with a quick review of the fundamentals of XML before covering XML Schema in detail. It then moves on to the XPath and XSLT covering advanced topics in both. Finally, XML and Web Services security mechanisms and issues are addressed. XML Content Introduction to XML XML Mechanics XML Structure Namespaces Structure Using Schemas XML Formatting CSS and Rendering XML XSL Transformations XSLT and XPath XPath 2.0 and XSLT 2.0 Overview XSL FO (Formatting Objects) Applying XML XML Interoperability XML Performance Improvements Web Services Overview XML Applications Additional course details: Nexus Humans Introduction to XML (TT4300) 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 Introduction to XML (TT4300) 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.

Touch Typing: Touch Typing Training Are you excited to learn how to type properly and quickly without having to glance at the keyboard? You are welcome in our dynamic touch typing course. This touch typing course includes hand and finger placement techniques. Also, this touch typing course explains the methods to increase typing accuracy and speed. In addition, this touch typing course covers how to practice typing exercises that concentrate on the home, top, and bottom rows of the keyboard. Students in this touch typing course also learn to use all 10 fingers. Drills and exams are a common part of this touch typing course. Join our touch typing course to increase productivity and lower the chance of repetitive strain injuries! Learning outcomes of touch typing course After completing this touch typing course, students will learn about: The introduction of touch typing methods, their types, and keys using processes. How to drill sentences is also described in our touch typing course. Figures and alphabetical paragraphs are also taught by our touch typing course. Moreover, this touch typing course explains the ergonomics and posture of touch typing. Throughout this touch typing course, you will learn about typing software and tools. Special Offers Of this Touch Typing: Touch Typing course This Touch Typing: Touch Typing course includes a FREE PDF Certificate. Lifetime access to this Touch Typing: Touch Typing course Instant access to this Touch Typing: Touch Typing course Get FREE Tutor Support from Monday to Friday in this Touch Typing: Touch Typing course. [ Note: Free Digital certificate as soon as completing the Touch Typing: Touch Typing course] Touch Typing: Touch Typing Training Unlock your typing potential with our comprehensive Touch Typing: Touch Typing course. This Touch Typing: Touch Typing program teaches essential hand and finger placement techniques, ensuring you master the fundamentals. Learn how to increase typing accuracy and speed through proven methods in our Touch Typing: Touch Typing course. You'll practice exercises focusing on the home, top, and bottom rows of the keyboard, and gain the skill of using all 10 fingers efficiently. With drills and exams integrated into our Touch Typing: Touch Typing course, you'll develop the expertise needed for fast and accurate typing. Enroll today! Who is this course for? Touch Typing: Touch Typing Training Students, professionals, and everyone else who wants to increase their typing efficiency and speed should take our touch typing course. Requirements Touch Typing: Touch Typing Training To enrol in this Touch Typing: Touch Typing Course Course, students must fulfil the following requirements. To join in our Touch Typing: Touch Typing Course, you must have a strong command of the English language. To successfully complete our Touch Typing: Touch Typing Course, you must be vivacious and self driven. To complete our Touch Typing: Touch Typing Course, you must have a basic understanding of computers. Career path Touch Typing: Touch Typing Training This touch typing course helps you get a job in: Administration Data entry Tanscribing Writing Programming Customer service

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