4493 Courses

10 Soft Skills You Need 1 Day Training in Aberystwyth

Learning Outcomes Learn how to perform calculations in MS Excel Understand the process of formatting and managing Worksheets Get introduced to the tools and features of MS Word Pick up the skills to create excellent presentations with PowerPoint Know the techniques for modifying data in Access Develop the skills to work with queries and Access forms Description Whether you want to work in a school or a multinational company, one skill is required in almost every industry, and that is MS Office. So, if you want to land a good job, first develop a solid foundation in MS Office and create an attractive CV. The Microsoft Office 2019: Word, Excel, PowerPoint And Access - Masterclass Bundle can help you. This bundle is developed to provide detailed lessons in MS Word, Excel, PowerPoint, and Access. The course will introduce you to the features of Microsoft Word and show you how to insert tables, add graphic objects and more. Here, you can develop the skills for managing and formatting Workbooks in Excel. In addition, you will get to learn the strategies to create presentations in PowerPoint. Furthermore, you will be able to learn the essentials of MS Access. The course will teach you a wide range of MS Office skills. It will also help you elevate your resume with a valuable certificate of achievement. Join now and start learning! Certificate of Achievement After the successful completion of the final assessment, you will receive a CPD-accredited certificate of achievement. The PDF certificate is for 9.99, and it will be sent to you immediately after through e-mail. You can get the hard copy for 15.99, which will reach your doorsteps by post.  Method of Assessment At the end of the course, there will be an online MCQ assessment. In order to pass this exam, you must score at least 60%. When you submit the assessment, our team will examine it and deliver you feedback.  Career path This course will help you develop a clear understanding of this area. After completing the course, you will be able to explore career options such as Data Analyst Manager Data Entry Officer Office Admin

LOOKING FOR: ADULT FICTION, NON-FICTION Diana joined the prestigious DHH Literary Agency in June 2024. She started agenting with Rupert Heath Literary Agency in 2011 before moving to UTA and Marjacq in 2017. Before that she was senior commissioning editor at Transworld. Diana was chosen as one of The Bookseller’s Rising Stars of 2012, was a nominee for RNA Agent of the Year 2019, and was shortlisted for Literary Agent of the Year 2022 at the British Book Awards. Her list includes a wide range of bestselling and prize-winning authors in the UK and internationally. Diana represents adult fiction and non-fiction. For fiction, she is looking for upmarket women's commercial, with depth and heart, including reading group, historical, saga, uplit and contemporary stories that are irreverent and make her laugh; accessible literary fiction, high-concept crime fiction and thrillers. She has a thing for spy novels and would love to find a great vampire story.  On the non-fiction side: memoir, smart, funny feminists, lifestyle, cookery and social justice, and open to anything with a strong, original voice. She also encourages submissions from writers who have been traditionally under-represented. Diana would like you to submit a covering letter, 1 - 2 page synopsis and the first three chapters (a maximum of 5,000 words) of your manuscript in a single word document.  (In addition to the paid sessions, Diana 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 17th September 2025

Overview This comprehensive course on Mastering Microsoft Office: Word, Excel, PowerPoint, and 365 will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Mastering Microsoft Office: Word, Excel, PowerPoint, and 365 comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast-track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this Mastering Microsoft Office: Word, Excel, PowerPoint, and 365. It is available to all students, of all academic backgrounds. Requirements Our Mastering Microsoft Office: Word, Excel, PowerPoint, and 365 is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 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 Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 34 sections • 135 lectures • 08:20:00 total length •Introduction: 00:03:00 •Getting started on Windows, macOS, and Linux: 00:01:00 •How to ask great questions: 00:01:00 •FAQ's: 00:01:00 •Excel Overview: 00:05:00 •Start Excel Spreadsheet: 00:04:00 •Enter Text and Numbers: 00:07:00 •Relative References: 00:04:00 •Working with ranges: 00:07:00 •Save and Save as Actions: 00:08:00 •File Extensions, Share, Export, and Publish files: 00:06:00 •Adding Rows and Columns: 00:03:00 •Modifying Rows and Column lengths: 00:05:00 •Copy, Cut, and Paste: 00:07:00 •Copying Formulas: 00:03:00 •Page setup options: 00:06:00 •Fit to print on One Page: 00:03:00 •Print Workbooks: 00:03:00 •Sorting Data Ascending Order: 00:04:00 •Sorting Data Descending Order: 00:02:00 •Filter Data: 00:04:00 •Creating Basic Formulas: 00:06:00 •Datetime Formulas: 00:06:00 •Mathematical formulas phase1: 00:20:00 •Mathematical formulas phase2: 00:12:00 •VLOOKUP formula: 00:12:00 •HLOOKUP formula: 00:04:00 •XLOOKUP: 00:08:00 •Handling #NA and Approximates match in XLOOKUP: 00:11:00 •Split Text into columns: 00:07:00 •Flash Fill: 00:07:00 •Data Validation: 00:07:00 •Remove Duplicates: 00:08:00 •Import Data from Text files: 00:06:00 •Import Data from .CSV files: 00:03:00 •Formatting Font: 00:04:00 •Formatting Alignment: 00:06:00 •Formatting Numbers: 00:05:00 •Formatting Date: 00:03:00 •Formatting Tables: 00:05:00 •Pivot Tables: 00:07:00 •Pivot Charts: 00:02:00 •Excel Charts - Categories: 00:03:00 •Elements of a chart: 00:04:00 •Creating Charts: 00:02:00 •Column or Bar charts: 00:04:00 •Formatting charts: 00:04:00 •Line Charts: 00:02:00 •Pie and Doughnut charts: 00:04:00 •Overview: 00:04:00 •Start PowerPoint Presentation: 00:05:00 •Screen setting and Views: 00:05:00 •Presentation Tips and Guidelines: 00:06:00 •Creating a New Presentation: 00:04:00 •Working with Slides: 00:04:00 •Save a Presentation: 00:04:00 •Print Slides: 00:03:00 •Formatting Text: 00:05:00 •Slide Text Alignments: 00:03:00 •Multi-Column Text Alignments: 00:02:00 •Adding Bullets and Numbered List Items: 00:03:00 •Insert Shapes: 00:03:00 •Insert Icons: 00:03:00 •Insert Graphics: 00:04:00 •Add 3D Models: 00:03:00 •Insert Pictures: 00:03:00 •Picture Options: 00:04:00 •Picture Cropping: 00:03:00 •Applying Built-in Picture Styles: 00:04:00 •Add SmartArt Graphic: 00:03:00 •Modifying SmartArt: 00:03:00 •Creating a Target Chart using SmartArt: 00:03:00 •Create a Table on Slide: 00:04:00 •Formatting Tables: 00:02:00 •Inserting Tables: 00:02:00 •Table Layouts: 00:01:00 •Add a Chart: 00:02:00 •Formatting Charts: 00:02:00 •Insert Chart from Microsoft Excel: 00:03:00 •Adding Video to a Presentation: 00:03:00 •Adding Audio to a Presentation: 00:02:00 •Screen Recording and Adding: 00:02:00 •Applying Transitions to Presentation: 00:04:00 •Object Animation: 00:03:00 •Effect Options: 00:02:00 •Advanced Animation: 00:02:00 •Triggers to control animation: 00:02:00 •Onscreen Presentation: 00:02:00 •Hiding Slides: 00:02:00 •Changing Order of Slides: 00:02:00 •Copying Slides: 00:02:00 •Overview of MS Word: 00:04:00 •Start MS Word 2021: 00:05:00 •Create a new blank document: 00:04:00 •Creating a paragraph text: 00:05:00 •Non-printing characters: 00:03:00 •Save a document: 00:03:00 •Open a document: 00:01:00 •Find and replace: 00:04:00 •AutoCorrect options: 00:03:00 •Formatting text: 00:04:00 •Copy cut and paste: 00:04:00 •Character formatting: 00:02:00 •Format painter: 00:04:00 •Work with numbers: 00:02:00 •Add bullets: 00:03:00 •Outline creation: 00:04:00 •Creating a table: 00:03:00 •Adding rows and columns to a table: 00:02:00 •Formatting table data: 00:02:00 •Borders and shading: 00:02:00 •Sorting in a table: 00:04:00 •Draw a table: 00:04:00 •Convert text to table: 00:03:00 •Convert table to text: 00:02:00 •Insert a spreadsheet: 00:02:00 •Quick tables - readily available formats: 00:02:00 •Working with styles: 00:02:00 •Creating styles: 00:02:00 •Clear formatting: 00:01:00 •Margins: 00:02:00 •Orientation: 00:01:00 •Page size setting: 00:01:00 •Adding columns: 00:03:00 •Page break - section break: 00:02:00 •Adding watermark: 00:03:00 •Headers and footers: 00:03:00 •Create envelops: 00:02:00 •Creating labels: 00:02:00 •Creating a mail merge document: 00:03:00 •Thesaurus and spell check: 00:01:00 •Word count: 00:01:00 •Speech - read aloud: 00:01:00 •Language - translate: 00:01:00 •Tracking: 00:01:00

Duration 2 Days 12 CPD hours This course is intended for This course is intended for individuals who want to gain an indepth knowledge of formatting documents using Word. Overview Upon successful completion of this course, students will be able to create and modify documents by using Microsoft Office Word 2016/365/2019. In this course, students will create, edit, and enhance technical documents using Microsoft Office Word 2016/365/2019. Formatting Text and Paragraphs Apply Character Formatting Control Paragraph Layout Aligh Text Using Tabs Display Text in Bulleted or Numbered Lists Working More Efficiently Make Repetitive Edits Apply Repetitive Formatting Use Styles to Streamline Repetitive Formatting Tasks Customize the Word Environment Managing Lists Sort a List Format a List Adding Tables Insert a Table Modify a Table Format a Table Inserting Graphic Objects Insert Symbols and Special Characters Add Images to a Document Controlling Page Appearance Add Headers and Footers Control Page Layout Add a Watermark Preparing to Publish Check Spelling, Grammar, and Readability Previw and Print Documents Use Research Tools Customizing Formats Using Styles and Themes Create and Modify Text Styles Cerate Custom List or Table Styles Apply Document Themes Inserting Content Using Quick Parts Insert Building Blocks Create and Modify building Blocks Insert Fields Using Quick Parts Using Templates to Automate Document Formatting Create a Document Using a Template Create and Modify a Template Manage Templates with the Template Organizer Controlling the Flow of a Document Control Paragrpah Flow Insert Section Breaks Insert Columns Managing Long Documents Insert Blank and Cover Pages Insert an Index Insert a Table of Contents Insert an Anchillary Table Manage Outlines Create a Master Document Manipulating Images Integrate Pictures and Text Adjust Image Appearance Adding Document References and Links Add Captions Add Cross-References Add Bookmarks Add Hyperlinks Insert Footnotes and Endnotes Add Citations and a Bibilography Additional course details: Nexus Humans Formatting Technical Documents Using Microsoft for Office 365 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 Formatting Technical Documents Using Microsoft for Office 365 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.

Level 2 Microsoft Office Essentials

Complete VBA programming training course description This course helps you extend the capabilities of the entire Office suite using Visual Basic for Applications (VBA). Even if you have no programming experience, you'll be automating routine computing processes quickly using the simple, yet powerful VBA programming language. We start at the beginning to get you acquainted with VBA so you can start recording macros right away. You'll then build upon that foundation to utilize the full capabilities of the language in Word, Excel, Outlook, and PowerPoint. What will you learn Record, write and run macros. Work with VBA Editor. Use the huge library of built-in functions. Create simple dialog boxes and complex forms. Customize Word, Excel, PowerPoint, Outlook, and Access. Program the Office 2016 ribbon. Complete VBA programming training course details Who will benefit: Anyone looking to extend the capabilities of the entire Office suite using VBA. Prerequisites: None. Duration 5 days Complete VBA programming training course contents Macros and getting started in VBA VBA syntax, variables, constants, and enumerations, array variables, finding objects, methods, and properties. Working with VBA 1 VBA syntax, variables, constants, and enumerations, array variables, finding objects, methods, and properties. Decisions, loops and functions Built-in functions, creating your own functions, making decisions in your code, using loops to repeat actions. Using message boxes, input boxes, and dialog boxes Getting user input with message boxes and input boxes, creating simple custom dialog boxes, creating complex forms. Creating effective code Building modular code and using classes, debugging your code and handling errors, building well-behaved code, exploring VBA's security features. Programming the Office applications The Word object model and key objects, working with widely used objects in Word, the Excel object model and key objects, working with widely used objects in Excel, the PowerPoint object, model and key objects, working with shapes and running slide shows, the Outlook object model and key objects, working with events in Outlook, the Access object model and key objects, manipulating the data in an Access database via VBA, accessing one application from another application, programming the Office 2016 ribbon.

24 Hours Left! Don't Let the Winter Deals Slip Away - Enrol Now! Microsoft Office Skills Diploma (Excel, Word, PowerPoint) + Office Skills for Administration Being proficient in Microsoft Office isn't just an advantage-it's become essential. With over 1.2 billion people worldwide using Microsoft Office and UK businesses increasingly relying on digital tools for efficiency, mastering these applications can significantly boost your career prospects. The Microsoft Office Skills Diploma offers an all-encompassing curriculum designed to elevate your expertise from basic functionalities to advanced data analysis and automation techniques, ensuring you stand out in the competitive job market. This Microsoft Office Skills Diploma covers everything from Office 365 Automation to Advanced Excel, including Data Management, Microsoft Word, PowerPoint, Outlook, Power BI, and VBA, along with collaborative tools like Teams. master Pivot Tables, Charts, and more, gaining a comprehensive skill set in Microsoft Office's most powerful features for professional growth. Courses are included in this Microsoft Office Package: Course 01: Microsoft Office 365 Automation Course Course 02: Microsoft Office Excel - Beginner, Intermediate & Advanced Course 03: Diploma in Complete Excel Course for All at QLS Level 5 Course 04: Microsoft Office (Microsoft Word, PowerPoint & Outlook) In 90 Minutes! Course 05: Office Skills for Administration Diploma Course 06: Microsoft Office Power BI Masterclass 2021 Course 07: Microsoft Excel: Excel Sheet Comparison with VBA Course 08: Microsoft Teams for Everyone Course 09: Microsoft Excel - 25 Must-Know Formulas and Functions Course 10: Excel Pivot Tables, Pivot Charts, Slicers, and Timelines Open a gateway to numerous career opportunities, enhancing your ability to manage. Analyse and present data effectively with this Microsoft Office Skills Diploma bundle. Join us on this journey to become a Microsoft Office expert and take your professional abilities to the next level! Learning outcome of this Microsoft Office Skills Diploma (Excel, Word, PowerPoint) + Office Skills for Administration - CPD Certified Course: Automate tasks and workflows in Microsoft Office 365 efficiently. Master Excel from basic operations to advanced data analysis and visualisation. Utilise Word, PowerPoint, and Outlook to their full potential. Analyse data with Power BI and create impactful visual reports. Automate Excel sheet comparisons using VBA for enhanced productivity. Design and manage advanced Excel features like pivot tables and charts. Why Prefer this Course? Get a chance to order a QLS Endorsed Certificate upon completion of the course Get a Free Student ID Card with this training program The course is Affordable and Simple to understand Get Lifetime Access to the course materials The training program comes with 24/7 Tutor Support Start your learning journey straight away! Course Curriculum Course 01: Microsoft Office 365 Automation Course Module 01: Microsoft Office 365 Automation Course 02: Microsoft Office Excel - Beginner, Intermediate & Advanced Module 01: Excel From A-Z Course Introduction Module 02: Getting Started With Excel Module 03: Values, Referencing And Formulas Module 04: Intro To Excel Functions Module 05: Adjusting Excel Worksheets Module 06: Visually Pleasing Cell Formatting Module 07: How To Insert Images And Shapes! Module 08: Visualize Data With Charts Module 09: Excel's Printing Options Module 10: Benefits Of Using Excel Templates Module 11: Working With Excel Datasets Module 12: Excel Database Functions Module 13: Excel Data Validation Module 14: Excel Pivot Tables Module 15: Excel's Power Pivot Add-In Module 16: Excel's Conditional Functions Module 17: Excel's Lookup Function Module 18: Text Based Functions In Excel Module 19: Auditing Formulas And Views In Excel Module 20: Excel's 'What If?' Tools Module 21: Welcome To Excel VBA Module 22: The VBA Language Module 23: Writing VBA Code Module 24: Important VBA Tools And Logic Module 25: Excel VBA Lopps Module 26: Triggering Macros Module 27: Excel User Forms Module 28: Starting A Career In Excel Course 03: Microsoft Excel Course for Everyone - Complete Excel Course Module 01: Getting Started Module 02: Excel Basics Module 03: Excel Essential Functions Module 04: XLookup Only For Excel 2021 And Office 365 Module 05: Get Data And Tools Module 06: Formatting Data And Tables Module 07: Pivot Tables Module 08: Excel Charts Module 09: Advanced Excel Charts Module 10: Pivot Charts Module 11: Maps Chart Above 2019 Module 12: Business-Geo Charts Module 13: Named Ranges Module 14: Import Data Into Excel Module 15: Advanced Excel =========>>>>> And 7 More Courses <<<<<========= Assessment Process Once you have completed all the modules on the course, you can assess your skills and knowledge with an optional assignment. Our expert trainers will assess your assignment and give you feedback afterwards. CPD 100 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone interested in learning more about the topic is advised to take this bundle. This bundle is ideal for: Microsoft Office users of all levels. Individuals seeking Excel expertise. Professionals aiming to automate tasks. Those looking to boost Office Skills for Administration skills. Quick learners of Word, PowerPoint, and Outlook. Aspiring data analysts. Requirements You will not need any prior background or expertise to enrol in this Microsoft Office Skills Course. Career path After completing this bundle, you are to start your career or begin the next phase of your career. Microsoft Office Expert: £18,000 - £30,000 Data Analyst: £25,000 - £50,000 Business Analyst: £30,000 - £60,000 Office Administrator: £18,000 - £30,000 Power BI Developer: £35,000 - £70,000 Certificates CPD Accredited Digital Certificate Digital certificate - £12.99 Upon passing the Course, you need to order a Digital Certificate for each of the courses inside this bundle as proof of your new skills that are accredited by CPD QS for Free. CPD Accredited Hard Copy Certificate Hard copy certificate - £29 Please note that International students have to pay an additional £10 as a shipment fee. Diploma in Complete Excel Course for All - QLS Endorsed Hard copy certificate - £119 Please note that International students have to pay an additional £10 as a shipment fee

Learn all the quick tips and tricks you didn’t know about in Word and how to properly setup new documents. Course overview Duration: 1 day (6.5 hours) Our Word Document Production (Part 1) course shows you how Word was designed to be used and demonstrates the powerful tools available. This course will enable you to originate professional documents with ease, ensuring that modifications are quick and uncomplicated. It looks at some of the common frustrations and how to avoid them. This course is aimed at existing Word users who want to get the best out of the package Objectives  By the end of the course you will be able to: Customise Word Use different Word views Use line, paragraph and page breaks correctly Set indents and tabs Use styles for easy formatting Work with section breaks Work with automatic correction features Insert and modify tables Content Word setup Using different views Customising the status bar Customising the Quick Access bar and Ribbon Document setup Using the Navigation Pane Using Show / Hide Line vs paragraph breaks Using page break Using the ruler Setting indents and tabs The different types of indent Using dot leader tab Bullets and numbering Working with simple numbered and bulleted lists Sorting lists Working with multi level lists Styles The importance of styles Creating, amending and applying Character Styles Amending and applying Paragraph Styles Setting bullet point styles Using the Style Inspector Reorganising a document Using Outline View Promoting and demoting headings Displaying Styles names in Draft and Outline views Page and number fomatting Section vs page breaks Setting page orientation Setting page margins Displaying page border Automatic corrections Working with Quick Parts Setting autocorrect options Autoformat while typing Creating simple tables Inserting or drawing a table Modifying table formatting Adding rows and columns Changing row heights and column widths

LOOKING FOR: ADULT FICTION, NON-FICTION Imogen Pelham has been at Marjacq since 2015, and has worked as a literary agent for more than a decade. She represents literary fiction and some upmarket commercial fiction, as well as a wide range of non-fiction. Imogen's looking for fiction with a strong premise, a surprise twist, or sharp humour. Recent favourites include Leave The World Behind by Rumaan Alam, Early Morning Riser by Katherine Heiny, and Sorrow & Bliss by Meg Mason. Her non-fiction list includes history, memoir, medicine and psychology. She is particularly interested in identity, the arts and investigative journalism. Imogen would like you to submit a covering letter, 1 - 2 page synopsis and the first 10,000 words of your manuscript in a single word document. (In addition to the paid sessions, Imogen 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: Monday 22nd September 2025