1134 Microsoft Office courses in Cardiff delivered On Demand

Overview Uplift Your Career & Skill Up to Your Dream Job - Learning Simplified From Home! Kickstart your career & boost your employability by helping you discover your skills, talents, and interests with our special Adventures in Excel Course. You'll create a pathway to your ideal job as this course is designed to uplift your career in the relevant industry. It provides the professional training that employers are looking for in today's workplaces. The Adventures in Excel Course is one of the most prestigious training offered at Skillwise and is highly valued by employers for good reason. This Adventures in Excel Course has been designed by industry experts to provide our learners with the best learning experience possible to increase their understanding of their chosen field. This Adventures in Excel Course, like every one of Skillwise's courses, is meticulously developed and well-researched. Every one of the topics is divided into elementary modules, allowing our students to grasp each lesson quickly. At Skillwise, we don't just offer courses; we also provide a valuable teaching process. When you buy a course from Skillwise, you get unlimited Lifetime access with 24/7 dedicated tutor support. Why buy this Adventures in Excel ? Lifetime access to the course forever Digital Certificate, Transcript, and student ID are all included in the price Absolutely no hidden fees Directly receive CPD Quality Standard-accredited qualifications after course completion Receive one-to-one assistance every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Certification After studying the course materials of the Adventures in Excel there will be a written assignment test which you can take either during or at the end of the course. After successfully passing the test you will be able to claim the PDF certificate for free. Original Hard Copy certificates need to be ordered at an additional cost of £8. Who is this course for? This Adventures in Excel course is ideal for Students Recent graduates Job Seekers Anyone interested in this topic People already work in relevant fields and want to polish their knowledge and skills. Prerequisites This Adventures in Excel does not require you to have any prior qualifications or experience. You can just enrol and start learning. This Adventures in Excel was made by professionals and it is compatible with all PCs, Macs, 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. Career path As this course comes with multiple courses included as a bonus, you will be able to pursue multiple occupations. This Adventures in Excel is a great way for you to gain multiple skills from the comfort of your home. Adventures in Excel Module 01: Introduction 00:03:00 Module 02: Basic Functions 00:12:00 Module 03: Date Functions 00:09:00 Module 04: Random Numbers 00:09:00 Module 05: IFS so many IFS 00:11:00 Module 06: Text Functions 00:13:00 Module 07: Logical Functions 00:09:00 Module 08: Creating a Drop-Down List 00:05:00 Module 09: VLOOKUP and XLOOKUP 00:09:00 Module 10: Pivot Tables 00:08:00 Assignment Assignment -Adventures in Excel 00:59:00 Order Your Certificate Order Your Certificate QLS

Overview Uplift Your Career & Skill Up to Your Dream Job - Learning Simplified From Home! Kickstart your career & boost your employability by helping you discover your skills, talents, and interests with our special Access 365 Beginner Course. You'll create a pathway to your ideal job as this course is designed to uplift your career in the relevant industry. It provides the professional training that employers are looking for in today's workplaces. The Access 365 Beginner Course is one of the most prestigious training offered at Skillwise and is highly valued by employers for good reason. This Access 365 Beginner Course has been designed by industry experts to provide our learners with the best learning experience possible to increase their understanding of their chosen field. This Access 365 Beginner Course, like every one of Skillwise's courses, is meticulously developed and well-researched. Every one of the topics is divided into elementary modules, allowing our students to grasp each lesson quickly. At Skillwise, we don't just offer courses; we also provide a valuable teaching process. When you buy a course from Skillwise, you get unlimited Lifetime access with 24/7 dedicated tutor support. Why buy this Access 365 Beginner ? Lifetime access to the course forever Digital Certificate, Transcript, and student ID are all included in the price Absolutely no hidden fees Directly receive CPD Quality Standard-accredited qualifications after course completion Receive one-to-one assistance every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Certification After studying the course materials of the Access 365 Beginner there will be a written assignment test which you can take either during or at the end of the course. After successfully passing the test you will be able to claim the PDF certificate for free. Original Hard Copy certificates need to be ordered at an additional cost of £8. Who is this course for? This Access 365 Beginner course is ideal for Students Recent graduates Job Seekers Anyone interested in this topic People already work in relevant fields and want to polish their knowledge and skills. Prerequisites This Access 365 Beginner does not require you to have any prior qualifications or experience. You can just enrol and start learning. This Access 365 Beginner was made by professionals and it is compatible with all PCs, Macs, 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. Career path As this course comes with multiple courses included as a bonus, you will be able to pursue multiple occupations. This Access 365 Beginner is a great way for you to gain multiple skills from the comfort of your home.

Description Do you want to know how to be an expert in creating forms and gathering data? Are you looking for the easiest method regarding MS InfoPath? You may look at the MS InfoPath 2013: Working With InfoPath 2013 in SharePoint course. This course may assist you to get an approximate idea about this field. The MS InfoPath 2013: Working With InfoPath 2013 in SharePoint course incorporates some basic ideas regarding the use of MS InfoPath. It enables to know you how to make forms and collect data by using Infopath within SharePoint. It also teaches you how to edit, create, and publish a form along with a strong command of associated properties. It gives you a proper direction to use Infopath forms by utilizing WebParts. After the end of the course, you will be an expert on some advanced functions of InfoPath that enables you to modify data source and work with it vivid sections. Assessment: This course does not involve any MCQ test. Students need to answer assignment questions to complete the course, the answers will be in the form of written work in pdf or word. Students can write the answers in their own time. Once the answers are submitted, the instructor will check and assess the work. 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? MS InfoPath 2013: Working With InfoPath 2013 in SharePoint 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 MS InfoPath 2013: Working With InfoPath 2013 in SharePoint 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. Introduction Introduction FREE 00:01:00 SharePoint and InfoPath Using InfoPath with SharePoint 00:04:00 Exploring the InfoPath Interface 00:03:00 Creating a Form from an Existing List 00:03:00 Creating a new List and Form within InfoPath 00:04:00 Creating a Form in InfoPath Using SharePoint Designer 00:02:00 Editing a Form 00:02:00 Publishing a Form 00:02:00 Restoring the Default SharePoint Form 00:03:00 Working with List Forms Components of the InfoPath Form 00:03:00 Formatting Text in the Form 00:03:00 Spellcheck Your Form 00:02:00 Inserting or Deleting a Table 00:02:00 Formatting a Table 00:03:00 Add or Remove Rows and Columns 00:02:00 Merging and Splitting Cells 00:04:00 Adding or Removing a Field 00:03:00 Resizing and Formatting a Field 00:03:00 Changing Field Controls 00:05:00 Inserting a Section 00:03:00 Inserting a Picture 00:02:00 Inserting a Button 00:05:00 Inserting a Calculated Value 00:04:00 Setting Default Field Values 00:05:00 Creating a Validation Rule 00:04:00 Creating a Formatting Rule 00:04:00 Creating an Action Rule 00:05:00 Modifying or Deleting a Rule 00:02:00 Setting the Form Load Rules 00:03:00 Advanced InfoPath Features Exploring the Fields Pane 00:02:00 Creating a Data Source 00:05:00 Modifying and Deleting a Data Source 00:02:00 Creating a View 00:03:00 Configuring View Settings 00:03:00 Creating Cascading Columns 00:06:00 Understanding Repeating Sections and Tables 00:03:00 Creating a Repeating Section 00:04:00 Using Repeating Tables to Add Multiple Items to a List 00:08:00 Using Repeating Sections to Show Existings Records 00:07:00 Hiding a Form Section Based on Field Values 00:05:00 InfoPath Forms Within SharePoint Using the InfoPath Form WebPart on a SP Page 00:04:00 Using Form Views for Different Groups 00:06:00 InfoPath Form WebPart and WebPart Filters 00:08:00 Conclusion Course Recap 00:01:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

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

Microsoft Project 2021 is a complete lifecycle project management tool that manages complex projects efficiently. This all-encompassing course molds you into an expert in project management with fundamentals to advanced techniques to handle projects of all sizes and gain confidence and proficiency in project planning, execution, and reporting.

Master Microsoft Excel with this comprehensive online certification bundle. Learn advanced formulas, data analysis, automation, and visualizations for professional success.

🚀 Unlock Your Presentation Potential with PowerPoint Mastery Basics! 🚀 Are your presentations lacking that wow factor? Do you find yourself struggling to engage your audience and convey your message effectively? It's time to transform your presentations into captivating masterpieces with our groundbreaking course - PowerPoint Mastery Basics!   🌟 Why PowerPoint Mastery Basics? ✅ Unleash Your Creativity: Discover the hidden features of PowerPoint that will turn your slides from dull to dynamic. Learn how to design visually stunning presentations that captivate your audience's attention. ✅ Boost Your Efficiency: Say goodbye to hours spent tweaking your slides. Master time-saving techniques and shortcuts that will streamline your workflow, allowing you to create impactful presentations in record time. ✅ Command Attention: Learn the art of storytelling through slides. Understand how to structure your content for maximum impact, keeping your audience engaged from start to finish. ✅ Professionalism Redefined: Elevate your presentations to professional standards. Discover design principles, formatting tricks, and visual hierarchy techniques that will make your slides stand out in any professional setting. ✅ Interactive Learning: Our course is not just about theory; it's a hands-on experience. Dive into practical exercises and real-world examples that reinforce your learning and ensure immediate application of newfound skills. ✅ Lifetime Access and Updates: Get unlimited access to the course content and benefit from future updates. Stay ahead of the curve as PowerPoint evolves, and continue to refine your skills over time.   🌐 Who Can Benefit? 👩‍💼 Business Professionals: Impress your clients and colleagues with polished presentations that convey your ideas persuasively. 👨‍🏫 Educators: Transform your classroom experience with engaging presentations that enhance learning and retention. 👩‍💻 Entrepreneurs: Pitch your ideas with confidence and leave a lasting impression on potential investors and partners. 👨‍🎓 Students: Stand out in your academic presentations with visually compelling slides that showcase your understanding of the subject matter.   👉 Don't miss out on this opportunity to revolutionize your presentations and leave a lasting impact! Join PowerPoint Mastery Basics today! Course Curriculum Basic Overview 02:46 Using The Right Mouse Button 02:49 The Home Menu - Clipboard Sub Menu - Editing Sub Menu 02:56 The Home Menu - Slides Sub Menu 03:24 The Home Menu - Font and Paragraph Sub Menus 03:19 The Home Menu - Drawing Sub Menu - Dictation Sub Menu 06:14 The Home Menu - Importing from Keynote and Google Docs 00:00 The Insert Menu - 3D Models and Add Ins 00:00 The Insert Menu - The Images Sub Menu 00:00 The Insert Menu - Media Sub Menu 00:00 The Design Menu 00:00 The Transitions Menu 00:00 The Animations Menu - Part One 00:00 The Animations Menu - Part Two 00:00 The Slide Show Menu 00:00 The Presenter View 00:00 The Review Menu 00:00 Sharing and Collaboration 00:00 The View Menu 00:00 View and Outline Command Example 00:00 Advanced Overview and Workspace 00:00 The File Menu - Export Command 00:00 The File Menu - Options Sub Menu 00:00 Adding Sections 00:00 Using Smart Art 00:00 Hyperlinks 00:00 Adding 3D Images 00:00 Using the Actions Button 00:00 Using the Zoom Feature 00:00 Using the Screen Recorder 00:00 Using the Picture Background 00:00 Slide Master - Picture Background 00:00 Slide Master - Part 2 00:00 Using the Slide Sorter View 00:00 Using the Presenter View (1) 00:00 Using the Presenter View (2) 00:00 Present Your Presentation Online 00:00 Insert Menu - Add Ins (1) 00:00 Insert Menu - Add Ins (2) 00:00 Conclusion and Collaboration 00:00

Overview With the ever-increasing demand for Microsoft PowerPoint in personal & professional settings, this online training aims at educating, nurturing, and upskilling individuals to stay ahead of the curve - whatever their level of expertise in Microsoft PowerPoint may be. Learning about Microsoft PowerPoint or keeping up to date on it can be confusing at times, and maybe even daunting! But that's not the case with this course from Compete High. We understand the different requirements coming with a wide variety of demographics looking to get skilled in Microsoft PowerPoint. That's why we've developed this online training in a way that caters to learners with different goals in mind. The course materials are prepared with consultation from the experts of this field and all the information on Microsoft PowerPoint is kept up to date on a regular basis so that learners don't get left behind on the current trends/updates. The self-paced online learning methodology by compete high in this Microsoft PowerPoint course helps you learn whenever or however you wish, keeping in mind the busy schedule or possible inconveniences that come with physical classes. The easy-to-grasp, bite-sized lessons are proven to be most effective in memorising and learning the lessons by heart. On top of that, you have the opportunity to receive a certificate after successfully completing the course! Instead of searching for hours, enrol right away on this Microsoft PowerPoint course from Compete High and accelerate your career in the right path with expert-outlined lessons and a guarantee of success in the long run. Who is this course for? While we refrain from discouraging anyone wanting to do this Microsoft PowerPoint course or impose any sort of restrictions on doing this online training, people meeting any of the following criteria will benefit the most from it: Anyone looking for the basics of Microsoft PowerPoint, Jobseekers in the relevant domains, Anyone with a ground knowledge/intermediate expertise in Microsoft PowerPoint, Anyone looking for a certificate of completion on doing an online training on this topic, Students of Microsoft PowerPoint, or anyone with an academic knowledge gap to bridge, Anyone with a general interest/curiosity Career Path This Microsoft PowerPoint course smoothens the way up your career ladder with all the relevant information, skills, and online certificate of achievements. After successfully completing the course, you can expect to move one significant step closer to achieving your professional goals - whether it's securing that job you desire, getting the promotion you deserve, or setting up that business of your dreams. Course Curriculum Module 1 Introduction to Microsoft PowerPoint Introduction to Microsoft PowerPoint 00:00 Module 2 Setting up and Managing presentations Setting up and Managing presentations 00:00

🌟 Unlock the Power of Excel 2019! 🌟 Are you ready to master Microsoft Excel 2019 and elevate your skills to new heights? Introducing our comprehensive online course: 'Microsoft Excel 2019 - Beginner Level Training.' 🚀 Dive into Excel's World-Class Features 🚀 📚 Section 1 - Excel Beginner Get started with a solid foundation. Learn the interface, navigation, and essential tools to kickstart your Excel journey. 📊 Section 2 - Excel Fundamentals Discover the core functionalities of Excel 2019, from cells and formulas to tables and more. Lay the groundwork for proficient data manipulation. ️ Section 3 - Entering and Editing Text Master the art of inputting and refining text within Excel. Gain efficiency and accuracy in handling textual data. Section 4 - Basic Excel Functions Explore the fundamental functions that make Excel a powerhouse. From basic calculations to data analysis, unlock Excel's potential. 🔄 Section 5 - Modifying an Excel Worksheet Learn techniques to manage, organize, and customize worksheets effectively. Boost productivity and streamline your workflow. 🎨 Section 6 - Formatting Data Transform raw data into visually appealing, easy-to-read formats. Elevate your reports and presentations with polished data formatting skills. 🖼️ Section 7 - Images, Shapes, and Smart Art Enhance your spreadsheets with visuals! Master the incorporation of images, shapes, and smart art for impactful data representation. 🖨️ Section 8 - Printing in Excel Navigate the intricacies of printing in Excel. Optimize layouts and settings to produce professional-looking documents. 📑 Section 9 - Templates Harness the power of pre-designed templates. Learn how to utilize and customize templates for various Excel projects efficiently. 🎓 Section 10 - Excel Beginner - Conclusion Wrap up your journey with a comprehensive understanding of Excel's beginner level. Recap key takeaways and prepare to advance your skills further. 🔥 Join Now and Excel in Excel 2019! 🔥 👩‍💻 Whether you're a student, professional, or an Excel enthusiast, this course is your gateway to proficiency in Microsoft Excel 2019. Enroll today and unlock a world of possibilities with data manipulation, analysis, and presentation! 🌟 Don't miss this opportunity! Enroll now and empower yourself with Excel mastery! 🌟 Course Curriculum Section 1 - Excel Beginner Introduction 01:02 Section 2 - Excel Fundamentals Launching Excel 01:59 Start Up Screen 02:54 The Excel Interface 06:46 The Quick Access Toolbar 02:13 The Ribbon 04:43 Creating New Excel Workbooks 01:27 Saving Excel Files 02:22 Opening Excel Files 01:38 Beginner Shortcut Keys 01:37 Section 3 - Entering and Editing Text Entering Text 06:41 Working with Numbers 06:55 An Introduction to Dates 01:15 Find and Replace 04:10 Sorting Data 04:13 Working with Cell References 06:05 Relative Versus Absolute Cell Reference in Formulas 06:24 Understanding the Order of Operation 02:41 Section 4 - Basic Excel Functions The structure of an Excel Function 00:00 Working with the Sum Function 00:00 Working with Min and Max 00:00 Working with Averages 00:00 Working with Count and CountA 00:00 Section 5 - Modifying an Excel Worksheet Moving and Copying Data 00:00 Inserting and Deleting Rows and Columns 00:00 Changing the Width and Height of Cells 00:00 Hiding and Unhiding Rows, Columns and Sheets 00:00 Renaming Worksheets 00:00 Deleting Worksheets 00:00 Moving and Copying Worksheets 00:00 Section 6 - Formatting Data Adding Borders to Cells 00:00 Formatting Percentages 00:00 Merging and Centering Cells 00:00 A Quick look at Styles 00:00 Basic Conditional Formatting 00:00 Section 7 - Images, Shapes and Smart Art Inserting Images and Shapes 00:00 Working with SmartArt 00:00 Section 8 - Printing in Excel Print Preview 00:00 Margins, Scaling and Orientation 00:00 Printing 00:00 Section 9 - Templates Intro to Excel Templates 00:00 Opening an Existing Template 00:00 Creating a Custom Template 00:00 Section 10 - Excel Beginner - Conclusion Conclusion 00:00

Overview This comprehensive course on Excel Data Analysis for Beginner will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Excel Data Analysis for Beginner 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 Excel Data Analysis for Beginner. It is available to all students, of all academic backgrounds. Requirements Our Excel Data Analysis for Beginner 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 3 sections • 11 lectures • 01:11:00 total length •Tracing Formulas: 00:04:00 •Using the Scenario Manager: 00:07:00 •Goal Seek: 00:03:00 •Solver: 00:03:00 •Data Tables: 00:11:00 •Data Analysis Tools: 00:16:00 •Forecast Sheet: 00:02:00 •Sumif, Countif,Averageif, Sumifs, and Countifs formulas: 00:09:00 •If, And, Or, and Nested If formulas: 00:16:00 •Resource - Excel Data Analysis for Beginner: 00:00:00 •Assignment - Excel Data Analysis for Beginner: 00:00:00