• Professional Development
  • Medicine & Nursing
  • Arts & Crafts
  • Health & Wellbeing
  • Personal Development

1313 Editor courses in Potters Bar delivered Online

Microsoft Excel Advanced

By Microsoft Office Training

Course Objectives At the end of this course you will be able to: Work with advanced lookup and reference functions Create macros to automate common tasks Use advanced techniques to analyse data Create PivotTables and PivotCharts Work with data validation tools Import and export data ' Customer Feedback Best Training Ever! Just finished a bespoke 1-1 training course in Excel Advanced, Macros & VBA. Pedro is an excellent trainer, imparting his skills and knowledge in the best way - appropriately to audience skills, knowledge and ability. Pedro is always approachable, encouraging and supportive, giving delegates the optimum learning environment. I would not hesitate to recommend Pedro as a trainer, whatever your level of ability. Amanda Morris - Treasury & Systems Accountant at Reall - Real Equity for All The course was very interesting and engaging and will definitely be put to use. The trainer was very helpful and charismatic. Marving Lopez - AM Best Europe Pedro was excellent. Very knowledgeable, clear and great rapport with class. Darren Barkey - Direct Wines Great content and learnt a lot. Really enjoyable :) Kristie-Lee Ryan - Stirling Ackroyd 1 year email support service Take a closer look at the consistent excellent feedback visiting our site ms-officetraining co uk With more than 20 years experience, we deliver courses on all levels of the Desktop version of Microsoft Office and Office 365; ranging from Beginner, Intermediate, Advanced to the VBA level. Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering classrom, one to one, tailored and bespoke courses. Tailored In Company training: You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs. Please visit our site (ms-officetraining co uk) to get a feel of the excellent feedback our courses have had and look at other courses you might be interested in. Advanced Functions COUNT, COUNTA, COUNTIF, COUNTBLANK, SUMIF, SUBTOTAL IF, OR, AND, IFERROR VLOOKUP to lookup Exact Values and Approximate values MATCH, INDIRECT, ROW/COLUMN, INDEX, OFFSET Analysing Data PMT function to calculate a monthly payment of a loan What If Analysis using Goal Seek Use scenarios to consider many different variables Using Solver Add-in to optimize variables PivotTables Create a PivotTable to analyse worksheet data Add or remove fields in a PivotTable Change the data source for a PivotTable Working with external data sources Using different Statistical Functions Calculate a Running Total, % of Grant Total, Difference From… Using the Slicer and Timeline to filter the PivotTable Using Filters in a PivotTable Group by Date, Auto Group by ranges of values, Custom Group Create a PivotChart The GETPIVOTDATA function Formula auditing Precedents and dependents Error checking Watch a formula and its result by using the Watch Window Evaluate a nested formula one step at a time Data Validation Number Validation Data List Validation Message Prompts and Alerts Conditional Data Validation Data Validation Errors Consolidation Consolidate data by position Consolidate data by category Use a formula to consolidate data Outline (group) data in a worksheet Create an outline of rows Create an outline of columns Copy outlined data Hide or remove an outline Connect external data to your workbook Using the Power Query Editor to import data From Text and CSV, From Access, From Web, From another Workbook Using the Power Query Editor to; Transform your data by Selecting which fields to import, by Splitting Columns, Changing Data Type and more. Deleting Applied Steps Refreshing your data Working with Form Controls; Buttons, Option Buttons and Scroll Bars Introduction to Macros Change Macro Security settings How to Record a macro Some Macro Examples Delete a macro Edit the macro to view the VBA code Copy part of a macro to create another macro Assign a macro to a button Who is this course for? Who is this course for? This course is intended to end users who want to develop their skills so they can use advanced techniques to analyse extensive and complex datasets in Excel and to automate simple tasks with the use of Macros. Requirements Requirements Preferably, delegates should have attended the Excel Intermediate course. Career path Career path Excel know-how can instantly increase your job prospects as well as your salary. 80 percent of job openings require spreadsheet and word-processing software skills Certificates Certificates Certificate of completion Digital certificate - Included

Microsoft Excel Advanced
Delivered OnlineFlexible Dates
£550

October's Writing Workshops

By Words Have Power

Workshop to help creative writers perfect their dialogue.

October's Writing Workshops
Delivered OnlineFlexible Dates
£15

Diploma in Journalism

4.3(43)

By John Academy

Description: Career in journalism is a standout amongst the most exciting fields, where you really get rewarded for something you adore. On the off chance that you see yourself as to be an inquisitive imaginative, who appreciates pursuing a story and hunting down reality, the Diploma in Journalism is your future check. This course is designed for students who are interested in a career in journalism and journalism-related fields. We open doors for students wishing to pursue writing studies or those looking for a career in newspapers and other media.  Who is the course for? Beginners New freelancers Those keen to break into journalism Those who seek to brush up their journalism skills Bloggers Entry Requirement: This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Assessment: At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After you have successfully passed the test, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a 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/materials from the industry leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognised accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. Career Path: This Diploma in Journalism is a useful qualification to possess and would be beneficial for the  for entry level jobs in the journalism such as Journalist Editor Sub-editor Freelance Writer Reporter Scriptwriter Desktop Publisher and Editor Media presenter. Newspaper Journalism What is news? 01:00:00 What is a journalist? 01:00:00 The shape of the news story 00:15:00 Writing the intro in simple steps 01:00:00 Writing the intro, the golden rules 00:30:00 Writing the news story in simple steps 01:00:00 Writing the news story - clear writing 00:30:00 Quotes 01:00:00 Attribution 00:30:00 TV Journalism News Gathering 00:30:00 Enterprising Stories 00:30:00 Watch your interviewee's body language. 00:15:00 Working with Sources 00:15:00 Covering Events 01:00:00 Computer-Assisted Reporting 00:30:00 Glossary of Broadcast News Teams 00:15:00 Law, Ethics And Responsibility 00:15:00 Operating Standards for News and Public Affairs 00:15:00 Lighting 00:15:00 Media What is the Media? 00:15:00 What Makes News? 00:30:00 Plan your Approach 01:00:00 Adhere to Deadlines 00:30:00 The Interview 00:15:00 Social Media and Journalism Definition of Social Media 00:15:00 Communication flow within journalism 00:15:00 The impact of social media on journalism 00:30:00 Becoming a Journalist What Is A Journalist? 01:00:00 What Type Of Degree Do I Need? 00:30:00 How To Get Started Writing Before Graduation 01:00:00 The Rules Of Journalism 01:00:00 Building A Portfolio 00:30:00 What Is Style? 01:00:00 What Does A Copy Editor Do? 01:00:00 Additional Degrees To Consider 01:00:00 Online Journalism - The Way Of The Future 01:00:00 What To Expect On Your First Job 00:30:00 Women in Journalism The Secret Significance of Journalism 01:00:00 Imperfections of the Existing Woman−Journalist 01:00:00 The Roads towards Journalism 01:00:00 The Aspirant 01:00:00 Style 01:00:00 The Outside Contributor 01:00:00 The Search for Copy 01:00:00 The Art of Corresponding with an Editor 00:30:00 Notes on the Leading Types of Papers 00:30:00 Woman's Sphere in Journalism 01:00:00 Conclusion 00:15:00 Refer A Friend Refer A Friend 00:00:00 Mock Exam Mock Exam- Diploma in Journalism 00:20:00 Final Exam Final Exam- Diploma in Journalism 00:20:00 Order Your Certificates and Transcripts Order Your Certificates and Transcripts 00:00:00

Diploma in Journalism
Delivered Online On Demand32 hours
£25

8th April Marilia Savvides #Agent121. Looking for: ADULT FICTION

5.0(2)

By I Am In Print

LOOKING FOR: ADULT FICTION Marilia Savvides founded The Plot Agency in 2024. She began her career in publishing at Peters Fraser and Dunlop, where she spent eight years, first as International Rights Agent, and later as Literary Agent, building her own list of authors. In 2019, she joined 42MP, where she worked as Literary Agent for four years, helping to launch and set up the Book Division. She is particularly interested in fiction that is beautifully written and cleverly constructed, but still accessible to a wide readership. She is often drawn to darker tales that weave together excellent characters and an impossible-to-put-down story, from immersive book club novels with a splash of suspense, crime and thrillers, accessible horror, and speculative, genre-bending or dystopian stories. She also adores smart, witty contemporary rom-com in the style of Emily Henry. In the thriller, crime and mystery space she is interested in most areas, except military thrillers and organised crime/ mafia / mob stories. Big hooks and clever set ups are a big bonus! She adores Karin Slaughter (especially her standalone novels) and Gillian Flynn. In the book club / reading group space, she’s particularly drawn to fiction in the vein of Jodi Picoult, Liane Moriarty and Celeste Ng, and absolutely fell in love with Bright Young Women by Jessica Knoll, both for the incredible voice, and the exquisite use of structure and time. Complicated family dynamics, empathetic and smart approaches to controversial issues, stand out protagonists (like Elizabeth Zott in Lessons in Chemistry or Bernadette in Where D’You Go Bernadette), long buried secrets, complicity, the road to justice, and impossible decisions, are all themes she finds herself drawn to. In the horror space, she’s a sucker for amazing female-centric stories in the vein of Yellowjackets, and the kind of contemporary, accessible horror that Stephen King always nails. She wants to get lost in a world that feels within reach of ours. In the speculative and dystopian spaces, she’s interested in genius ideas that set up big questions or reflect the most broken (and sometimes hidden) parts of society. She loves Octavia Butler, Margaret Atwood, George Orwell, and also adored The Leftovers, Station Eleven, Wanderers, and The Power. The what-ifs of life and fiction fascinate her. In the grounded sci-fi space, she’d love to find a smart, immersive, and accessible story like The Martian. She doesn’t represent fantasy or romantasy. In regards to sci-fi, unless it’s very grounded and has crossover potential to a mainstream audience, it’s not for her. In the romance space, she’s particularly drawn to smart, complex and witty characters, where the chemistry is jumping off the page. She loves contemporary settings and all the tropes, though the voice and characters must come first to make the reading experience fully immersive. She wants to be cackling, and rooting for the characters with all her heart. She is very hands-on editorially, and loves working with her authors to shape their manuscripts, and brainstorm ideas. The best part of the job is discovering debut authors, and helping them find a home for their books. Marilia would like you to submit a covering letter, 1 - 2 page synopsis and the first 5,000 words of your manuscript in a single Word document.  (In addition to the paid sessions, Marilia is kindly offering one free session for low income/underrepresented writers. Please email agent121@iaminprint.co.uk to apply, outlining your case for this option which is offered at the discretion of I Am In Print).  By booking you understand you need to conduct an internet connection test with I Am In Print prior to the event. You also agree to email your material in one document to reach I Am In Print by the stated submission deadline and note that I Am In Print take no responsibility for the advice received during your agent meeting. The submission deadline is: Monday 31st March 2025

8th April Marilia Savvides #Agent121. Looking for: ADULT FICTION
Delivered Online + more
£72

Proofreading and Copy Editing

4.9(27)

By Apex Learning

If you are particular about word choice, and if typos and clunky sentences drive you to distraction, you may have what it takes to be a proofreader and editor. The Proofreading and Copy Editing Course is for those who want to work professionally in the proofreading and editing field. It also provides an excellent foundation for anyone who needs to Proofread and edit documents in the workplace. No manual, book, magazine, website, brochure, or business letter is sent out to an audience without Proofreading. This Proofreading and Copy Editing Bundle will prepare you for a lucrative and satisfying career in this fascinating area of business. You will be expertly trained to check, edit, and adapt the text to the highest of standards and earn yourself a substantial reputation. We'll help you gain the skills you need to get hired by publishers, business owners and curators of online content. Our professional Proofreader & editor will be there to guide you and assess your work every step of the way. Along with this Proofreading and Copy Editing Bundle, you will get an original hardcopy certificate, transcript and a student ID card. Courses are included with this Proofreading and Copy Editing Bundle Course 1: Proofreading & Copy Editing Course 2: Advanced Diploma in Copywriting Course 3: Writing Short Story Training Course 4: Certificate in CV Writing and Interview Skills Course 5: Functional Skills English Practice Level 2 Course 6: Improve English Spelling, Punctuation, Grammar and Pronunciation Course 7: Phonics Teaching Assistant Course 8: Touch Typing Essentials Course 9: Document Control Course 10: MS Word Diploma Course 11: Time Management All leading companies that produce content of any kind need to experience Proofreaders and Copy Editors. Become trained in this profession and secure rewarding roles. This Proofreading and Copy Editing Bundle Course is designed to train you quickly in all the abilities needed to perform quality control and amendments ahead of publishing. Proofreading and Copy Editing Bundle has been rated and reviewed highly by our learners and professionals alike. We have a passion for teaching, and it shows. Learning Outcomes of Proofreading & Copy Editing Copywriting: Learn about Proofreading terminology Deepen your understanding of language awareness and grammatical knowledge How to implement the style guide Learn how to spot and correct spell and grammatical errors How to master spelling and grammar How to identify the weaknesses in the text How to proofreading on paper, and proofreading on-screen Learn the different methods and techniques of proofreading The copy-editing basics, checking accuracy and facts, do legal checks, and much more Course Curriculum Proofreading & Copyediting Course 1: Proofreading & Copy Editing 01: Proofreading Basics 02: Applying the Style Guide 03: Spelling and Grammar 04: Proofreading on Paper 05: Proofreading On-Screen 06: Copy-Editing Basics 07: The Use of Language 08: Checking Accuracy and Facts 09: The Beginning and The End 10: Legal Checks 11: Finding Work and Developing Your Career ------- 10 more courses--------- How will I get my Certificate? After successfully completing the course you will be able to order your CPD Accredited Certificates (PDF + Hard Copy) as proof of your achievement. PDF Certificate: Free (Previously it was £10 * 11 = £110) Hard Copy Certificate: Free (For The Title Course) If you want to get hardcopy certificates for other courses, generally you have to pay £20 for each. But this Fall, Apex Learning is offering a Flat 50% discount on hard copy certificates, and you can get each for just £10! P.S. The delivery charge inside the U.K. is £3.99 and the international students have to pay £9.99. CPD 110 CPD hours / points Accredited by CPD Quality Standards Who is this course for? There is no experience or previous qualifications required for enrolment on this Proofreading and Copy Editing Bundle. It is available to all students, of all academic backgrounds. Requirements Our Proofreading and Copy Editing Bundle is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible on tablets and smartphones so you can access your course on wifi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career path Proofreading and Copy Editing Bundle would be beneficial for any related profession or industry such as: Newspaper editor Copywriter Publishing Proofreading business Reporter English teacher Certificates Certificate of completion Digital certificate - Included

Proofreading and Copy Editing
Delivered Online On Demand
£49

Existential Dialogue 2025: "Polarisation" with Prof. Kirk Schneider

By Therapy Harley Street

Polarization, or the “polarized mind,” is a fixation on one view, causing widespread destructiveness. It needs presence and love to address. We aim to explore the lived experiences on irregular perceptions of reality with an open mind. Each Saturday includes: a live dialogue between Prof. Ernesto Spinelli and an International Existential Therapist; a moment to share your thoughts and feelings with the teachers; and a final integration facilitated by Bárbara Godoy. This series of ten dialogues set out to explore the multifaceted dimentions and complexities associated with Existential Therapies. It attempts to engage with various interpretations of insanity through the lens of patients often painful, confounding, and deeply unsettling life experiences. Polarisation - between Prof. Ernesto Spinelli and Prof. Kirk Schneider “I view polarization or that which I call the “polarized mind” as the fixation on a single point of view to the utter exclusion of competing points of view, and I see it as a core dimension of human destructiveness both individually and collectively. Arguably, polarization or the polarized mind is responsible for more devaluation and abuse than any other general psychological dimension, and it crosses cultures, parties, disciplines and so-called diagnosed and undiagnosed populations. In fact it is the undiagnosed populations—polarized cultural, political, and religious leaders and their followers–who have arguably caused the most human destructiveness by far, over those whom we conventionally termed the diagnosed The polarized mind may be partly dispositional but appears to be largely fear-driven and requires abiding presence and love to address it. We are in a race against time to avail people to these “nutrients.” Prof. Kirk Schneider. Prof. Kirk J. Schneider, Ph.D. is a leading spokesperson for contemporary existential-humanistic and existential-integrative psychology. Dr Schneider was a 2022 Candidate for President of the American Psychological Association (APA), a co-founder and current president of the Existential-Humanistic Institute (an award-winning psychotherapy training center), and a two-term Member of the Council of Representatives of the APA. He is also past president (2015-2016) of the Society for Humanistic Psychology (Division 32) of the APA, recent past editor of the Journal of Humanistic Psychology (2005-2012), a founder and frequent presenter/facilitator of the bridge-building dialogue approach the Experiential Democracy Dialogue and a trained moderator for the conflict mediation group Braver Angels. Dr Schneider is also an adjunct faculty member at Saybrook University and Teachers College, Columbia University and an Honorary Member of the Society for Existential Analysis of the UK and the East European Association for Existential Therapy. He received the Rollo May Award for “outstanding and independent contributions” to the field of humanistic psychology from the Society for Humanistic Psychology, APA and is a Fellow of seven Divisions of the APA (5, 9, 32, 42, 12, 29, and 24). His work on existential-integrative psychotherapy has been featured in a special issue of the Journal of Psychotherapy Integration (March 2016), as well as The Wiley World Handbook of Existential Therapy and the APA’s forthcoming Handbook of Psychotherapy. Dr Schneider has published over 200 articles, interviews and chapters and has authored or edited 14 books including The Paradoxical Self, Horror and the Holy, Rediscovery of Awe, Awakening to Awe, The Spirituality of Awe, The Polarized Mind, The Handbook of Humanistic Psychology, Existential-Humanistic therapy, Existential-Integrative Psychotherapy, The Wiley World Handbook of Existential Therapy, The Depolarizing of America: A Guidebook for Social Healing and his latest volume (February, 2023) Life-Enhancing Anxiety: Key to a Sane World. Dr. Schneider’s work has been featured in Scientific American, the New York Times, USA Today, The Guardian, Vanity Fair, Forbes Health, Psychology Today, BBC World News and many other health and psychology outlets. Prof. Ernesto Spinelli was Chair of the Society for Existential Analysis between 1993 and 1999 and is a Life Member of the Society. His writings, lectures and seminars focus on the application of existential phenomenology to the arenas of therapy, supervision, psychology, and executive coaching. He is a Fellow of the British Psychological Society (BPS) as well as an APECS accredited executive coach and coaching supervisor. In 2000, he was the Recipient of BPS Division of Counselling Psychology Award for Outstanding Contribution to the Profession. And in 2019, Ernesto received the BPS Award for Distinguished Contribution to Practice. His most recent book, Practising Existential Therapy: The Relational World 2nd edition (Sage, 2015) has been widely praised as a major contribution to the advancement of existential theory and practice. Living up to the existential dictum that life is absurd, Ernesto is also the author of an on-going series of Private Eye novels. Date and Time: Saturday 12 April from 2 pm to 3 pm – (UK time) Individual Dialogue Fee: £70 Venue: Online Zoom FULL PROGRAMME 2025: 25 January “Knots” with Prof. Ernesto Spinelli and Bárbara Godoy 22 February “Healing” with Dr. Michael Guy Thompson and Prof. Ernesto Spinelli 22 March “Difference” with Prof. Tod DuBose and Prof. Ernesto Spinelli 12 April “Polarisation” with Prof. Kirk Schneider and Prof. Ernesto Spinelli 3 May “Character” with Prof. Robert Romanyshyn and Prof. Ernesto Spinelli 21 June “Opening” with Dr. Yaqui Martinez and Prof. Ernesto Spinelli 19 July “Meaning” with Dr. Jan Resnick and Prof. Ernesto Spinelli 25 October “Invention” with Dr. Betty Cannon and Prof. Ernesto Spinelli 15 November “Hallucination” with Prof. Simon du Plock and Prof. Ernesto Spinelli 13 December “Hysteria” with Bárbara Godoy and Prof. Ernesto Spinelli Read the full programme here > Course Organised by:

Existential Dialogue 2025: "Polarisation" with Prof. Kirk Schneider
Delivered Online
£70

Microsoft Excel VBA Programming Training

By Compete High

🚀 Unlock the Power of Microsoft Excel with Our Excel VBA Programming Training Course! 📊 Are you ready to take your Excel skills to the next level? Dive deep into the world of Excel VBA programming and unleash the full potential of this powerful tool! Our comprehensive online course, 'Microsoft Excel VBA Programming Training,' is designed to equip you with the expertise needed to automate tasks, streamline processes, and boost productivity within Excel. Here's what you'll learn in this dynamic course: 📌 Section 1: Introduction Get acquainted with the fundamentals of Excel VBA programming. Understand its significance and explore the vast possibilities it offers to transform your Excel experience. 📌 Section 2: Macros Master the art of creating and executing macros to automate repetitive tasks and significantly reduce manual work. Learn to streamline your workflow like a pro! 📌 Section 3: VBA Editor Navigate the VBA Editor seamlessly. Gain proficiency in using this interface to write, edit, and debug your VBA code effectively. 📌 Section 4: Variables and Procedures Understand the concept of variables and procedures in VBA. Learn how to declare, assign, and utilize them efficiently to optimize your coding process. 📌 Section 5: Loops and IF Statements Discover the power of loops and conditional IF statements. Harness these constructs to create dynamic and responsive Excel applications. 📌 Section 6: Error Handling Learn robust error-handling techniques to troubleshoot issues and create resilient VBA programs. 📌 Section 7: User Defined Functions Unlock the potential of creating custom functions tailored to your specific needs, enhancing Excel's capabilities beyond its default functions. 📌 Section 8: Assignments Apply your newfound knowledge through hands-on assignments and practical exercises to reinforce your skills. 📌 Section 9: Creating Forms Explore the creation of user-friendly forms and interfaces within Excel, making interactions more intuitive and efficient. Whether you're a beginner or have some experience in Excel, this course is tailored to suit your learning needs. With comprehensive modules, real-world examples, and expert guidance, you'll gain the confidence to create powerful VBA scripts and automate Excel operations like never before! Join us today and embark on a transformative journey in mastering Microsoft Excel VBA programming. Elevate your Excel skills and become a proficient VBA programmer! Enroll now and excel in Excel VBA programming! 💡📈✨ Course Curriculum Section 1 - Introduction What is VBA 00:00 Object Orientated Programming 00:00 Section 2 - Macros Macros Initial Setup 00:00 Recording a Macro 00:00 Saving a Macro 00:00 Section 3 - VBA Editor Launching VBA 00:00 VB Editor 00:00 Custom Menu 00:00 Naming Projects 00:00 Modules 00:00 Code Window 00:00 Comments 00:00 Section 4 - Variables and Procedures Introduction 00:00 Vraibales 00:00 Variable Exercise 00:00 What are Procedures 00:00 What are Procedures - Part Two 00:00 What are Procedures - Part Three 00:00 Message Boxes 00:00 Input Box 00:00 Input Box - Part Two 00:00 Basic Navigation 00:00 Sheets 00:00 Draft LessonCell Navigation 00:00 Advanced Sheets 00:00 Offset 00:00 Section 5 - Loops and IF Statements Introduction 00:00 Operators 00:00 Using Variables 00:00 What is Automation 00:00 For Loop 00:00 Do Loops 00:00 IF Statements 00:00 IF Statements - Part Two 00:00 Select Case 00:00 Section 6 - Error Handling Debugging 00:00 Section 7 - User Defined Functions UDFs 00:00 Section 8 - Assignments Introduction 00:00 Exercise 1 - Record a Macro 00:00 Exercise 2 - Duplicating Data 00:00 Exercise 3 - Generate a Report 00:00 Generate a Report - Part Two 00:00 Exercise 4 - Inner and Outer Loops 00:00 Inner and Outer Loops - Part Two 00:00 Inner and Outer Loops - Part Three 00:00 Inner and Outer Loops - Part Four 00:00 Inner and Outer Loops - Part Five 00:00 Section 9 - Creating Forms Form Controls 00:00 Building the Form 00:00 Initialize the Form 00:00 Command Buttons 00:00 Command Buttons - Part Two 00:00

Microsoft Excel VBA Programming Training
Delivered Online On Demand6 hours 17 minutes
£25

Data Analyst Training: Microsoft Power BI at QLS Level 7 Diploma

By Imperial Academy

Bring Your Data To Life | Designed by Industry Specialist | Level 7 | QLS Endorsed Diploma | Certificate Included

Data Analyst Training: Microsoft Power BI at QLS Level 7 Diploma
Delivered Online On Demand
£150

Perfect 3 Days Linux Course

By Packt

Linux administration and command line

Perfect 3 Days Linux Course
Delivered Online On Demand7 hours
£137.99

Dreamweaver

5.0(3)

By Systems & Network Training

Dreamweaver training course description Dreamweaver is a web authoring program that allows you to build professional quality websites. This course starts with a tour of Dreamweaver and customising your workspaces, moving onto HTML and CSS basics. Page layouts, templates and interactive pages are also covered. The final session covers how to use Dreamweaver as a HTML editor. Hands on session follow all the major theory chapters. What will you learn Use Dreamweaver to create websites. Customise Dreamweaver. Use templates. Add interactivity to web pages. Use Dreamweaver to edit HTML code. Dreamweaver training course details Who will benefit: Anyone wishing to create or edit websites. Prerequisites: None. Duration 3 days Dreamweaver training course contents Getting started Installing the programme, Updating to the latest version,, Online content, On first launch, Choosing the program colour theme, Setting up the workspace, Defining a Dreamweaver site, Checking for updates, Additional resources. Customizing your workspace Touring the workspace, Using the start screen, Exploring new feature guides, Setting interface preferences, Switching and splitting views, Selecting a workspace layout, Personalising Dreamweaver, Working with extract, Creating custom keyboard shortcuts, Using the Property inspector, Using the Related Files interface, Using tag selectors, Using the CSS Designer, Using the Visual Media Query (VMQ) interface, Using the DOM viewer, Using Element dialogs, displays and inspectors, Setting up version control in Dreamweaver, Exploring experimenting and learning. HTML Basics What is HTML? Where did HTML begin? Frequently used HTML elements, What's new in HTML5. CSS Basics What is CSS? HTML vs. CSS formatting, HTML defaults, CSS box model, Applying CSS styling, Multiples, classes and ids. Web design basics Developing a new website, Scenario, Working with thumbnails and wireframes, Creating a page layout Evaluating page design options, Working with predefined layouts, Styling an existing layout, Styling elements using the Extract panel, Extracting text from a Photoshop mockup, Troubleshooting CSS styling, Extracting text styling from a Photoshop mockup, Creating a gradient background using Extract, Extracting image assets from a mockup, Adding CSS background effects in code, Finishing up the layout. Working with templates Creating a template from an existing layout, Inserting editable regions, Inserting editable regions, Inserting HTML entities, Inserting metadata, Validating HTML code, Producing child pages, Moving CSS styles to linked file, Updating a template. Working with text, lists and tables Previewing the completed file, Creating and styling text, Creating lists, Creating and styling tables, Spell-checking webpages, Finding and replacing text. Working with images Web image basics, Previewing completed files, Inserting an image, Controlling image positions with CSS classes, Working with the Insert panel, Using the Insert menu, Inserting non-web file types, Working with Photoshop Smart Objects, Copying and pasting images from Photoshop, Inserting images by drag and drop, Optimizing images with the Property inspector. Working with navigation Hyperlinks, previewing the completed file, creating internal and external hyperlinks, setting up email links, Creating image-based links, Targeting page elements, Locking an element on the screen, Styling a navigation menu, Checking your page, Adding destination links. Adding interactivity Dreamweaver behaviours, Previewing the completed file, Working with Dreamweaver behaviours, Working with jQuery Accordion widgets, Inserting a jQuery Accordion widget, Styling a jQuery Accordion. Publishing to the web Defining a remote site, Cloaking folders and files, Wrapping things up, Putting your site online, Synchronizing local and remote sites. Working with code Creating HTML code, multicursor support, commenting your code, Working with CSS preprocessors, Selecting code, Collapsing code, Expanding code, Accessing Split code view, Previewing assets in Code View.

Dreamweaver
Delivered in Internationally or OnlineFlexible Dates
£2,367
1...56789...132