9102 Courses in Cardiff delivered On Demand

Learn to create captivating AI-generated art using DALL-E, Midjourney, and other AI art software. This course covers the fundamentals of AI art creation and provides hands-on training on how to generate stunning visuals. Develop your creativity and artistic skills in a fun and engaging way.

With our course 'Excel: Top 50 Microsoft Excel Formulas in 50 Minutes!' you can take a dynamic learning trip and advance your Excel skills to new levels. In just 50 minutes, unlock the secrets of Excel's most potent formulas, revolutionizing your approach to data manipulation and analysis. This isn't your average Excel tutorial; it's a fast-paced, immersive experience crafted to optimally utilize every minute of your learning journey. Dive into the intricacies of text, mathematical, date and time, logic, and financial formulas, demystifying their complexities with engaging exercises and comprehensive answers. Each module is strategically structured, ensuring you grasp the essence of Excel's powerhouse formulas efficiently. Whether you're a novice eager to conquer Excel or a seasoned user aiming to enhance your skills, this course offers a streamlined, time-efficient path to mastery. Learning Outcomes Text Formulas Proficiency: Master text manipulation with Excel, enhancing your ability to streamline and present information effectively. Mathematical Formula Mastery: Acquire a deep understanding of mathematical formulas, enabling you to perform complex calculations effortlessly. Date and Time Formula Expertise: Unlock the potential of Excel's date and time functions, facilitating precise chronological data management. Logic Formulas Competence: Develop proficiency in logic formulas, empowering you to create dynamic decision-making processes within your spreadsheets. Financial Formula Proficiency: Gain financial acumen by mastering Excel's financial formulas, essential for robust financial analysis and planning. Why choose this Excel: Top 50 Microsoft Excel Formulas in 50 Minutes! course? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards and CIQ after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the Course at your own pace, on your own schedule. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience. Unlock career resources for CV improvement, interview readiness, and job success. Who is this Excel: Top 50 Microsoft Excel Formulas in 50 Minutes! course for? Individuals seeking to boost their Excel proficiency quickly. Students aiming to enhance their data manipulation skills. Professionals wanting to streamline their spreadsheet tasks efficiently. Entrepreneurs and small business owners looking to optimize data analysis. Anyone keen on mastering Excel's powerful formulas for personal or professional growth. Career path Data Analyst: £25,000 - £40,000 Financial Analyst: £30,000 - £50,000 Business Intelligence Specialist: £35,000 - £55,000 Project Manager: £40,000 - £60,000 Operations Manager: £45,000 - £70,000 Management Consultant: £50,000 - £80,000 Prerequisites This Excel: Top 50 Microsoft Excel Formulas in 50 Minutes! does not require you to have any prior qualifications or experience. You can just enrol and start learning. This Excel: Top 50 Microsoft Excel Formulas in 50 Minutes! was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Certification After studying the course materials, there will be a written assignment test which you can take at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £4.99 Original Hard Copy certificates need to be ordered at an additional cost of £8. Course Curriculum Excel: Top 50 Microsoft Excel Formulas in 50 Minutes! Excel promo 00:01:00 Getting the most of the course 00:01:00 How to Get the most of the course 00:01:00 Text formulas in Excel 00:08:00 Text Formulas Exercise 00:01:00 Text Formulas Exercise (answers) 00:01:00 Mathematical Formulas In Excel 00:04:00 Mathematical Formulas Exercise 00:01:00 Mathematical Formulas Exercise (answers) 00:01:00 Date and Time Formulas In Excel 00:06:00 Date and Time Formulas Exercise 00:01:00 Date and Time Exercise Formulas (answers) 00:01:00 Logic Formulas In Excel 00:12:00 Logic Formula Exercise 00:01:00 Logic Formula Exercise (answers) 00:01:00 Financial Formula In Excel 00:06:00 Financial Formula Exercise 00:01:00 Financial Formula Exercise (answers) 00:02:00 Informational Formula In Excel 00:04:00 Informational Formula Exercise 00:01:00 Informational Formula Exercise (answers) 00:01:00 Getting Traffic To Your Site 01:00:00 Additional Resources Resources : Excel: Top 50 Microsoft Excel Formulas in 50 Minutes! 00:00:00

Overview This comprehensive course on Web Design in Affinity Designer will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Web Design in Affinity Designer 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? At the end of the course there will be an online written test, which you can take either during or after the course. After successfully completing the test you will be able to order your certificate, these are included in the price. Who is This course for? There is no experience or previous qualifications required for enrolment on this Web Design in Affinity Designer. It is available to all students, of all academic backgrounds. Requirements Our Web Design in Affinity Designer 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 Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management, Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 26 sections • 87 lectures • 07:29:00 total length •Introduction to the course: 00:02:00 •What is Affinity Designer and how to set it up for web design?: 00:03:00 •Affinity Designer's web design abilities: 00:09:00 •First 5 principles of good web design: 00:04:00 •The remaining 5 principles of good web design: 00:05:00 •The most important factor to consider before choosing colours: 00:04:00 •Mix colours for the best possible User Experience: 00:05:00 •Choose the 'psychologically right' colours: 00:05:00 •Easy tools for choosing errorproof colour schemes: 00:07:00 •A super short history of web typography: 00:03:00 •Choose the right fonts for body text: 00:05:00 •Choose the right fonts for headings: 00:04:00 •Mix fonts for headings and body text: 00:04:00 •The perfect font for User Interface design: 00:03:00 •Header, branding, navigation and Hero sections.: 00:04:00 •The centre and bottom sections of your website design: 00:04:00 •What are grids and how to use them: 00:03:00 •Design your very own grid: 00:04:00 •1-7 web design trends that rule the web design world: 00:09:00 •Where to find the RIGHT inspiration for your next design: 00:02:00 •Every website design needs scaffolding: 00:03:00 •Building your wireframe in Designer: 00:05:00 •Continue building the library: 00:10:00 •Use the assets to create a wireframe: 00:11:00 •Wireframing online: 00:04:00 •Talk about images and icons: 00:06:00 •Create font styles in Affinity Designer: 00:04:00 •The Design Part Overview: 00:06:00 •Create the Colour Swatches: 00:04:00 •Create the Text Styles: 00:08:00 •Take a Look at the Icons and Images: 00:03:00 •Start with Creating the Logo: 00:03:00 •Build the Menu Links: 00:04:00 •Add the Social Media Icons: 00:07:00 •Start by Adding the Main Image: 00:07:00 •Quickly Resize the Image: 00:03:00 •Make the Image a Bit Darker: 00:03:00 •Add the Main Text: 00:05:00 •Add the Slider Navigation: 00:04:00 •Start Creating the First Featured Section: 00:04:00 •Add the Featured Items: 00:10:00 •Add the Second Featured Item Section: 00:06:00 •Start Creating the Blog Section: 00:08:00 •Replace the Images: 00:03:00 •Start Building the Image Gallery: 00:07:00 •Create the First Column of the Footer: 00:04:00 •Finish the Design and the Whole Footer: 00:04:00 •Discover the Wireframe for the Design: 00:06:00 •Discover the Blog Design: 00:06:00 •Take a Look at Our Assets: 00:06:00 •Create the Logo and Nav: 00:08:00 •Add the Social Media Icons: 00:07:00 •Add the First Images: 00:07:00 •Add the Shading to the Images: 00:08:00 •Add the Navigation Buttons: 00:05:00 •Create a Container the Blog Post: 00:05:00 •Add the First Pieces of Text: 00:04:00 •Add the Remaining Pieces of Text: 00:06:00 •Start Creating the Blog Post Grid: 00:06:00 •Create the First Blog Post Card: 00:05:00 •Add the Remaining Cards: 00:07:00 •Add the Older Post Link: 00:04:00 •Explore the Sidebar Project: 00:03:00 •Create the Search Box: 00:04:00 •Create the About Me Section: 00:07:00 •Create the Text Section of the Sidebar: 00:05:00 •Create the First Container for the Most Popular Posts: 00:04:00 •Create the List of the Most Popular Blog Posts: 00:07:00 •Create the Ads Section: 00:03:00 •Start Creating the Footer: 00:04:00 •Explore Different Footer Concepts: 00:03:00 •Finish Creating the Footer: 00:07:00 •Explore the Single Post Design: 00:03:00 •Create the Featured Image and the Post Container: 00:06:00 •Add the Blog Post Title: 00:06:00 •Add the Paragraphs and Images: 00:10:00 •Add the Social Media Icons: 00:07:00 •Add the pre-Next Post Navigation: 00:08:00 •Add the Related Posts Section: 00:07:00 •Start Creating the Comments Section: 00:05:00 •Create the Texts for the Comments: 00:06:00 •Create the Post Comment Form: 00:09:00 •Delivering the design to the client: 00:04:00 •Delivering the file to the developer: 00:03:00 •Use the Export Persona to Export the Assets in Bulk: 00:02:00 •Thanks for Watching the Course: 00:01:00 •Assignment - Web Design in Affinity Designer: 00:00:00

Fundamentals of Teaching Grammar and Sentence Structure (30 Hours)

Description: Are looking forward to learning each and every single details of Microsoft Office 2016? Then you are at the right place! Microsoft Office 2016 Essentials is designed for beginners to educate about Microsoft Office 2016. Initially, you will learn about the basic features of Microsoft Word such as creating a new document, personalizing the Microsoft Word interface, adding graphics, etc. Besides, you will learn about the techniques of controlling page appearance, proofing and editing a document. Following that, you will learn about the foundations of Microsoft Office Excel that is essential to create and work with an electronic spreadsheet. You will be able to insert and delete text, adjust cells, create columns, rows and much more. Next, Microsoft PowerPoint will help you to learn to navigate the PowerPoint environment, create and save PowerPoint presentation, delivering advanced text editing etc. Microsoft Outlook will help you to set up and use Outlook on Windows. It will also assist you in creating and sending messages, managing contacts, using the calendar, managing tasks, working with notes and much more. Overall, this course gives you all information to access Microsoft Office 2016. Register today and get benefit from this course. Learning Outcomes: Word 2016 user interface, creating basic documents and utilizing help Managing text through modifying, finding and replacing, and selecting them; and arranging texts through tabs and lists Understanding the commands on the home tab and mini toolbar Paragraph layout tool, borders, shading, styles and formatting management techniques Maximizing your ability to utilize tables within Word 2016 Inserting symbols and special characters along with techniques for adding them Managing your page's appearance with colours, borders, watermarks, headers, footers and page setup dialog box Reviewing documents through spell check, research pane and thesaurus Document accessibility options Customizing the user interface, modifying save options and managing other file types Familiarize the excel user interface, creating basic worksheet and using the help system How to create formulas, reuse them and insert functions in a worksheet Managing cells, columns and rows and ways to manipulate data Utilizing the 'Search and replace' data options and spell checking Modifying fonts, adding borders and colours to cells, using number formats, aligning cell contents and applying cell styles Define and refine page layouts for printing options Managing large workbooks through worksheet tab formatting and using different views Options for general customization, language, formula, proofing and saving Customizing Quick Access toolbar, ribbon, advanced and Trust Center options Utilize Excel's version control features and enabling add-ins Utilize the PowerPoint user interface, creating and saving presentations, and using help Making presentations through presentation options like selecting types, building it, layouts, text editing, viewing and navigation Discover methods for formatting characters, paragraphs, and text boxes Adding images, screenshots, screen recordings, shapes and WordArt Modifying options for objects and animation features Creating and formatting a table and integrating data from other Microsoft Office applications Create format and manipulate a chart Navigate throughout the Outlook user interface and learn to perform basic email functions and utilize help Composing emails, grammar and spell checks, formatting content, attaching files, enhancing messages and managing automatic message responses Customize reading options, work with attachments and manage message responses Managing and organization of messages with the help of tags, flags, other commands and folders Using calendar options to manage appointments and meetings Using People workspace to create, update, view and organise contacts Managing tasks and notes Creating and managing Quick Steps, and customizing the interface according to needs Get familiarized with Microsoft Access 2016, create simple databases, and use the help options Change table data, manage records, and create lookups Join data from different tables, sort and filter them, and perform calculations for queries Creating, adding controls, enhancing appearance and print preparation for reports How to utilize Access Options dialog box Relational database design, creating tables, managing table fields and creating table relationships Creating query joins and sub queries, joining tables with no common fields, relating data within a table, and working with sub datasheets Data normalization and creating junction tables Sharing Access data with other applications and through import and export options Managing reports through organizing information, formatting, including charts, adding calculated fields and sub-report inclusion to existing ones Create mailing label report and publishing reports in PDF format Assessment: At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Microsoft Office 2016 Essentials is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our Microsoft Office 2016 Essentials is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market.

QLS Endorsed + CPD QS Accredited - Dual Certification | Instant Access | 24/7 Tutor Support | All-Inclusive Cost

Beginner-to-advanced PowerPoint 2019 instruction including follow-along exercises.

Description: This Microsoft Office 2013 PowerPoint Beginners - Complete Video Course covers the basic functions and features of PowerPoint 2013. This series begins with an introduction in developing a PowerPoint presentation. With this course you will learn about advanced text editing and how to utilize graphical elements, manipulate an existing PowerPoint presentation, create a new presentation based on a template, design a blank presentation selecting various slide layouts, print a presentation using special print options, modify a presentation using different outline views, edit and delete text in the title and bulleted placeholders, modify the presentation through choosing a color scheme and formatting the background, change all slides using the slide master, change alignment, header, footer and objects with the slides, work with drawing, sizing, moving and grouping objects, and much more. If you want to know more detail you have to be a part of this course. You will get all the basic knowledge from this course. Assessment: At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Microsoft Office 2013 PowerPoint Beginners - Complete Video Course is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our Microsoft Office 2013 PowerPoint Beginners - Complete Video Course is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Getting Started with PowerPoint Navigate the PowerPoint Environment FREE 00:17:00 Create and Save a PowerPoint Presentation 00:09:00 Use Help 00:04:00 Developing a PowerPoint Presentation Select a Presentation Type 00:07:00 View and Navigate a Presentation 00:10:00 Edit Text 00:16:00 Building a Presentation 00:21:00 Performing Advanced Text Editing Format Characters 00:14:00 Format Paragraphs 00:19:00 Format Text Boxes 00:10:00 Adding Graphical Elements to Your Presentation Insert Clip Art and Images 00:09:00 Insert Shapes 00:11:00 Modifying Objects in Your Presentation Edit Objects 00:16:00 Format Objects 00:07:00 Group Objects 00:05:00 Arrange Objects 00:07:00 Animate Objects 00:06:00 Adding Tables to Your Presentation Create a Table 00:05:00 Format a Table 00:06:00 Insert a Table from Other Microsoft Office Applications 00:05:00 Adding Charts to Your Presentation Create a Chart 00:07:00 Format a Chart 00:09:00 Insert a Chart from Microsoft Excel 00:04:00 Preparing to Deliver Your Presentation Review Your Presentation 00:08:00 Applying Transitions 00:05:00 Print Your Presentation 00:05:00 Deliver Your Presentation 00:07:00 Mock Exam Mock Exam- Microsoft Office 2013 PowerPoint Beginners - Complete Video Course 00:20:00 Final Exam Final Exam- Microsoft Office 2013 PowerPoint Beginners - Complete Video Course 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Level 2 Microsoft Office Essentials

Unleash your creativity with our Adobe After Effects CC course. Master the art of motion graphics and visual effects to create stunning visuals that captivate your audience. Enhance your design skills and bring your ideas to life!