19396 Disc courses in Cardiff delivered Online

Description Microsoft Excel has hundreds, if not thousands, of functions and features. This course aims to cover some of the best – that is the ones I find most useful. In “Adventures in Excel”, I cover the simple-to-use but powerful functions that I use most often: Basic features including products and powers Key date functions including the calculation of due dates and days past due Generating random numbers and random dates The new IFS functions (new to Office365) Text functions The most useful logical functions and IS functions How to create a drop-down list The new XLOOKUP function Pivot tables   These functions are easy to use, and, unless your role is extremely specialised, they are probably the ones you’ll use 90% of the time. I hope you find the course helpful.   Learning Outcomes Participants in this course will learn: Basic Excel functions including SUM, AVERAGE, MIN, MAX, PRODUCT, POWER and SQRT Useful date functions including TODAY, EOMONTH, EDATE, and DAYS Generating random numbers using RAND and RANDBETWEEN; generating random dates; and randomly picking an item from a list or table The new RANDARRAY function in Office365 The new IFS functions in Office365 including AVERAGEIFS, MAXIFS, MINIFS, COUNTIFS, and SUMIFS Text functions including TRIM, LOWER, UPPER, PROPER, LEFT, MID, RIGHT, FIND, TEXTJOIN and CONCATENATE Logical functions AND, OR, and NOT and IS functions ISTEXT, ISNUMBER, ISBLANK and ISERROR How to create a drop-down list The new SORT and FILTER functions in Office365 VLOOKUP and the new XLOOKUP function How to create a Pivot table and analyse data with one     Course Requirements There are no pre-course requirements.   Additional Resources Course Spreadsheet with the examples covered.     About Ross Ross Maynard is a Fellow of the Chartered Institute of Management Accountants in the UK. He is director of Ideas2Action Process Excellence Ltd and has 30 years’ experience as a process improvement consultant and facilitator. Ross is also a professional author of online training courses for accountants. Ross lives in Scotland with his wife, daughter and Cocker Spaniel

Introduction to American Smocking textiles technique, lead by NICKY SIMPSON.

LOOKING FOR: ADULT FICTION Francesca Riccardi is a literary agent at Kate Nash Literary Agency. She has previously worked in sales roles at HarperCollins, Constable & Robinson, Atlantic Books (where she was recognised as a 2017 Bookseller Rising Star), and most recently was sales and marketing director for Canelo. She has worked with authors including Holly Seddon, Rachel Lynch, Cesca Major, Robert Fabbri, Marion Todd, M C Beaton, Catherine Ryan Howard, and Phil Rickman. Francesca is looking for character-driven popular commercial adult fiction across all genres. She loves books with a strong voice and sense of place, and is particularly interested in stories that are high concept, appealing to a millennial audience, and showcase lesser known experiences and/or female and diverse narratives. Francesca would like you to submit the first 5000 words of your manuscript, a synopsis and your cover letter in that order in one single Word document. (In addition to the paid sessions, Francesca is kindly offering one free session for low income/under-represented 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: Tuesday 26th August 2025

LOOKING FOR: ADULT FICTION, NON-FICTION Publisher / editor Scott Pack is now in his third decade working in the world of books. During that time he has been Head of Buying for Waterstones, worked for publishers big and small - including a lengthy spell at HarperCollins - and taught numerous workshops and classes on all aspects of writing. These days he splits his time between writing his own books, editing other people's, teaching the editors of tomorrow as part of the Oxford Brookes University MA in Publishing, and he is one of the question setters for BBC's Mastermind. His latest book, Tips From A Publisher, is out now.  As a publisher, Scott has published across most genres in fiction and a wide range of non-fiction and is happy to read any style of writing. He will assess your sample and provide feedback on any issues he identifies, the manuscript's commercial potential and what steps he would advise before you submit to agents or publishers. Scott is very direct with his feedback, so expect robust, but always constructive, comments! Scott would like you to submit your fiction as a covering letter, 1-2 page synopsis and the first 5,000 words of your manuscript in a single word document.  For non-fiction, he would like to see:- 1-page synopsis – to give an overview of what the book will offer the reader and how it's different from other books out there on this topic A detailed proposed contents list, including proposed sub-section headings as well as chapter headings – to give a sense of the overall reader journey 1000-1500 words of intro text - to showcase context, tone etc 1000-1500 words from later in the book - to showcase the progression of the book (In addition to the paid sessions, Scott 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: Tuesday 26th August 2025

This 2 hour digital training session is CPD accredited. It utilises lived experience and a filmed version of our acclaimed theatre production MOCKINGBIRD HIGH - a compelling and lyrical account of the devastating impact of domestic abuse on two teenage children and their mother. Plus interactive activities, group discussion to explore the relevance to your work practice and a support pdf.

LOOKING FOR: ADULT FICTION Kate Barker has worked in publishing for over twenty years as an agent, commissioning editor and ghostwriter. Before setting up her own company, Kate Barker Literary Agency, she spent ten years at Penguin, where she was an Editorial Director for Viking, acquiring fiction and non-fiction. She has also worked for Orion, Curtis Brown and for digital publisher Bookouture. She is looking for commercial and reading group fiction for adults and would love to find an unputdownable thriller like Rosamund Lupton's Three Hours, a funny, heartbreaking contemporary novel like Queenie by Candice Carty-Williams or a romantic comedy with a unique premise like The Flatshare by Beth O'Leary. She also loves historical fiction and series crime. Kate would like you to submit a covering letter, one page synopsis and the first three chapters (Max 5,000 words) of your completed manuscript in a single word document. (In addition to the paid sessions, Kate is kindly offering one free session for low income/under-represented 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: Wednesday 27th August 2025

ONLINE CLASS: FOCUSES ON HARASSMENT IN THE WORKPLACE AND HOW TO ADDRESS THE PROBLEM. Harassment doesn’t have to be of a sexual nature – it can include offensive remarks about a person’s gender. For example, anyone could be guilty of harassing another if offensive comments are made about certain group in general. Simple teasing or offhand comments might not be illegal, but harassment is illegal when it creates a hostile or offensive work environment. This workshop teaches how to recognize, understand, and respond to harassment so that you can help to maintain a happy work environment, free from hostility and discomfort. Topics: Harassment Laws: The definition of sexual harassment and quid pro quo. Types of Harassment: Verbal, Non-Verbal, Physical, Psychological (teasing and offhand comments). Creating a happy work environment free from hostility and discomfort. Reporting: What to do when employees witness or experience harassment. Responding: How managers can identify and respond to prohibited conduct. Attendees will be able to: Identify the signs of Harassment and take steps to prevent it, Follow a legal and ethical protocol in responding and reporting it when it is perceived to occur, Involve the correct individuals in being made aware of the occurrence, and Respond appropriately to the situation after it occurs. This workshop is offered in two versions – management-only and staff-only.   Online Format—Workplace Professionalism is a 4-hour interactive virtual class. Register for this class and you will be sent ONLINE login instructions prior to the class date. It was an extreme pleasure to have you as part of the Communication Enhancement Training Program. Your presentation was excellent and well received by the staff. Courtney C. Crouch, Jr., PresidentSelected Funeral and Life Insurance Company

LOOKING FOR: ADULT FICTION, NON-FICTION Liza represents a range of fiction and non-fiction. On the fiction side, she is looking for historical fiction that is well researched, immerses readers in the era, and looks at overlooked characters from the past, or perhaps gives a new spin on someone we think we know. On the literary and upmarket side, she is looking for novels infused with emotions that capture the human experience and make readers think. If your literary novel is something that A24 productions might turn into a movie, this is Liza’s taste. When it comes to fantasy, she loves urban and grounded fantasy (no sci-fi please!), and is always happy to look at anything with a vampire, werewolf, witches, warlocks, fairies, and perhaps a sinister selkie or two. She is also very much looking for romantasy and is the best person at the agency to submit that too. For thrillers, send her anything set in an exotic location, high-concept, or things with a speculative twist. She loves when characters are put in situations she would never want to be in, and then they have to get out of it. Her recent favourite fiction includes: Notes on an Execution, Lady Macbethad, Hamnet, A Discovery of Witches, House of Earth and Blood, The Starless Sea, Piranesi, Our Wives Under the Sea, The Pisces, Such A Fun Age. When it comes to non fiction, she is looking for books that teach her something new or reframe a topic from an alternative point of view. This can include cookery, pop science, and social history. Liza’s recent favourite non-fiction include: The Five, A History of Art Without Men, Messalina, The Authority Gap, Finding The Mother Tree, Cook This Book, Dessert Person. Liza would like you to submit a covering letter, 1 - 2 page synopsis and the first 5000 words of your manuscript in a single word document.  (In addition to the paid sessions, Liza 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: Wednesday 27th August 2025

Emotional Intelligence, EQ, EI, Moccasin Approach, Moccasin Manager,

LOOKING FOR: ADULT FICTION, NON-FICTION Florence has been at A M Heath for five years and represents a range of commercial fiction and non-fiction. For fiction, comforting, funny and warm reads, as well as gripping page-turners, will always be Florence's cup of tea. Her favourite thing is to escape with a story she can’t put down. If you think your book fits that, then do send it to her.  Books in this vein that really left her wanting one more chapter include Marian Keyes’s character, Rachel, from Rachel’s Holiday that left Florence with a compassion for addiction that only the most skilled of writers can conjure. Florence finds Catherine Newman to be a genius for making hospice care so funny in We All Want Impossible Things. Smart page turners such as Anatomy of a Scandal, Such a Fun Age, and Tomorrow, and Tomorrow, and Tomorrow, wowed her with clever, gripping prose and complicated, flawed characters she hadn't met before. She also loves older classics like the Cazalet Chronicles and Georgette Heyer’s Regency novels. Florence is actively looking for writers who are under-represented in the publishing world, through non-traditional channels, as well as her submissions. She’s keen to find non-fiction and fiction writers who speak to a millennial and younger audience, be that a journalist who is looking to expand an idea, a screenwriter who is looking to try their hand at fiction or perhaps an activist with a social media platform.  She is also interested in environmental and social issues. The authors she represents include Jaspreet Kaur, Salma El-Wardany, Rachel Thompson, Annie Lord, Angelica Malin and Phil Ellis. Their books range from the heart-breaking and profound to the inspirational, funny and wise, with almost everything in between. Florence does not wish to receive, YA, Fantasy or Sci-fi.  Florence would like you to submit a covering letter, 1 page synopsis and the first 5,000 words of your manuscript in a single word document.  (In addition to the paid sessions, Florence is kindly offering one free session for low income/under-represented 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: Wednesday 27th August 2025