718 Courses in Cardiff delivered Online

Visualize charts and visuals in Tableau Desktop

From downloading and installing to creating beautiful dashboards, this course takes you through all the essential concepts of the MicroStrategy Desktop application. You will learn to import data from Excel and transform this data into appealing charts, filters, and graphs that are easy to understand.

Overview With the ever-increasing demand for Data Analysis in Microsoft Excel 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 Data Analysis in Microsoft Excel may be. Learning about Data Analysis in Microsoft Excel 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 Data Analysis in Microsoft Excel . 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 Data Analysis in Microsoft Excel 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 Data Analysis in Microsoft Excel 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 Data Analysis in Microsoft Excel 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 Data Analysis in Microsoft Excel 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 Data Analysis in Microsoft Excel , Jobseekers in the relevant domains, Anyone with a ground knowledge/intermediate expertise in Data Analysis in Microsoft Excel , Anyone looking for a certificate of completion on doing an online training on this topic, Students of Data Analysis in Microsoft Excel , or anyone with an academic knowledge gap to bridge, Anyone with a general interest/curiosity Career Path This Data Analysis in Microsoft Excel 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 Excel Introduction to Microsoft Excel 00:00 Module 2_ Data Visualization and Advanced Functions Data Visualization and Advanced Functions 00:00 Module 3_ PivotTables and Regression PivotTables and Regression 00:00 Module 4_ Time Series Analysis in Excel Time Series Analysis in Excel 00:00

Overview This comprehensive course on The Complete Microsoft OneDrive Course will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This The Complete Microsoft OneDrive Course 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 The Complete Microsoft OneDrive Course. It is available to all students, of all academic backgrounds. Requirements Our The Complete Microsoft OneDrive Course 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 12 sections • 83 lectures • 05:21:00 total length •The Complete Microsoft OneDrive Course -Mastering OneDrive Promo: 00:01:00 •Quick Reminder - You Can Ask Me Anytime: 00:01:00 •Another Quick Reminder: You Facebook Group: 00:01:00 •Quick Win - Create a Folder and Rename It: 00:01:00 •Another Quick Quick Win - Share and Collaborate: 00:01:00 •What's OneDrive: 00:03:00 •OneDrive Free and Paid Plans: 00:04:00 •OneDrive Sign up: 00:05:00 •OneDrive Personal Vault: 00:02:00 •OneDrive PC folder Backup: 00:02:00 •OneDrive Desktop App Download and Installation: 00:02:00 •OneDrive Mobile App Download and Installation: 00:04:00 •Quick Win - Change the View of Displayed Files and Folder: 00:01:00 •Another Quick Win Create a New Album: 00:01:00 •Complete OneDrive Environment: 00:06:00 •Upload and Download in OneDrive: 00:03:00 •Creating New File and Folder in OneDrive: 00:02:00 •Selecting Files and Folder in OneDrive: 00:01:00 •Sharing and collaborating files and folder in OneDrive: 00:04:00 •Other options in top bar of the files and folder: 00:04:00 •Other options in top bar of the files and folder part 2: 00:08:00 •Picture options in OneDrive: 00:03:00 •Right Click options in OneDrive: 00:01:00 •Personals Valid in OneDrive: 00:02:00 •Personals Valid Options in OneDrive: 00:03:00 •Shared Folder in OneDrive: 00:02:00 •OneDrive Settings - Storage Management: 00:03:00 •OneDrive Settings (cont.): 00:04:00 •Microsoft OneDrive Mobile Version: 00:07:00 •Complete Microsoft Word Environment: 00:05:00 •Ribbon Guide: 00:01:00 •Menu and Groups Guide: 00:02:00 •Learn Functions and Options Then Projects: 00:01:00 •Microsoft Word Home Menu Tools: 00:17:00 •Microsoft Word Home Reviewing and Viewing Mode: 00:02:00 •Microsoft Word File Menu: 00:05:00 •Microsoft Word Insert Menu - Page Break and Table: 00:08:00 •Microsoft Word Insert Picture Menu: 00:05:00 •Microsoft Word Word Inserting Header and Footer, symbol and emoji: 00:05:00 •Microsoft Word Layout Menu: 00:02:00 •Microsoft OneDrive References Menu: 00:04:00 •Microsoft Word Review Menu: 00:04:00 •Microsoft Word View and Help: 00:02:00 •Timetable Making in Microsoft Word: 00:06:00 •Bill System in Microsoft Word: 00:06:00 •Microsoft Excel In OneDrive Environment: 00:03:00 •Microsoft Excel Home (Part 1): 00:11:00 •Microsoft Excel Number Formats: 00:03:00 •Microsoft Excel Conditional Format: 00:03:00 •Microsoft Excel Formatting a Table: 00:07:00 •Microsoft One Drive Insert: 00:06:00 •Microsoft Data, Review and View: 00:04:00 •Salary Table in Microsoft Excel: 00:06:00 •Salary Table in Microsoft Excel (cont.): 00:07:00 •Microsoft PowerPoint Environment: 00:02:00 •Microsoft PowerPoint Home and Insert Menu: 00:06:00 •Microsoft PowerPoint Insert and Design Menu: 00:05:00 •Microsoft Power Point Animation and Transition and More: 00:04:00 •Projects of PowerPoint: 00:12:00 •OneNote in OneDrive: 00:04:00 •Forms Survey in OneDrive: 00:03:00 •Plain Text in OneDrive: 00:01:00 •OneDrive Profile Management: 00:05:00 •Account OneDrive Settings: 00:03:00 •Quick Win - Create Unknown Password: 00:01:00 •Security Is Everything!!!: 00:01:00 •Quick Win - Insecurity Is Coming from You and Others: 00:01:00 •Understand Security Type or Category: 00:02:00 •Life Savers - You Should Know These: 00:04:00 •Have Proper Password - Start Securing You Now: 00:03:00 •Don't Use the Same Password Anymore: 00:02:00 •Should You Use Longer Password or Complicated!: 00:03:00 •The Best and Only Solution to Make and Keep Password Un-Crack-Able: 00:08:00 •Last-pass Setup and Configure: 00:10:00 •Last-Pass Options Part 1: 00:03:00 •Last-Pass Options Part 2: 00:04:00 •Last-Pass Option Part 3: 00:04:00 •2FA Makes You Even Stronger in Password: 00:05:00 •Last-Pass & Authy Mobile App: 00:02:00 •Security Is Everything, Keep Secured Your Devices: 00:07:00 •Security on Your Data and Privacy: 00:08:00 •Congratulations - You Are Now a Master of OneDrive: 00:01:00 •Assignment -The Complete Microsoft OneDrive Course: 00:00:00

Excel: Top 50 Microsoft Excel Formulas in 50 Minutes! Course Overview "Excel: Top 50 Microsoft Excel Formulas in 50 Minutes!" is designed for learners who want to enhance their Excel skills in a short period. This course covers the essential formulas that are frequently used in both everyday tasks and professional settings. It provides quick, easy-to-follow insights on the most common Excel functions, enabling you to work more efficiently with data, improve productivity, and gain confidence in using Excel’s powerful features. By the end of this course, you will have a comprehensive understanding of 50 key Excel formulas and be able to apply them confidently across various tasks and scenarios. Course Description In this course, learners will be introduced to 50 of the most widely used Microsoft Excel formulas, including basic functions like SUM and AVERAGE, as well as more advanced formulas such as VLOOKUP, IF statements, and pivot table formulas. Each formula is explained with clear examples, offering learners a straightforward approach to improving their Excel proficiency. Whether you are managing data, performing financial analysis, or generating reports, these formulas will significantly enhance your ability to complete tasks faster and more effectively. With a focus on learning key formulas, this course provides an excellent foundation for anyone looking to optimise their Excel skills in a time-efficient way. Excel: Top 50 Microsoft Excel Formulas in 50 Minutes! Curriculum Module 01: Introduction to Excel Formulas Module 02: Basic Mathematical Formulas Module 03: Logical Functions and Conditions Module 04: Lookup and Reference Functions Module 05: Text and Date Functions Module 06: Statistical Functions and Analysis Module 07: Advanced Excel Formulas Module 08: Using Formulas for Data Validation and Error Checking Module 09: Formulas for Financial Modelling Module 10: Troubleshooting and Optimising Formulas (See full curriculum) Who is this course for? Individuals seeking to enhance their Excel capabilities. Professionals aiming to improve data management and analysis skills. Beginners with an interest in improving their productivity with Excel. Anyone wanting to quickly learn the key Excel formulas used in daily tasks. Career Path Data Analyst Financial Analyst Project Manager Business Analyst Office Administrator Operations Manager IT Support Specialist

Master VLOOKUP in Excel in just 60 minutes! From menus to list comparisons, learn essential VLOOKUP skills fast.

Master essential Microsoft Office applications, enhance communication, and develop problem-solving skills with the Microsoft Office Complete Training. Suitable for new entrants and professionals alike, gain practical knowledge, expert guidance, and a CPD certificate for career advancement.

Overview Learn to use the full power and functionality of Microsoft's Excel and deliver impressive charts and analysis work. This Advanced Diploma in MS Excel course allows you to exploit the full abilities of Microsoft's best-selling tool and become capable of providing higher-quality results from it. You may use Excel every day in your work or business, but are you really using it to its full potential? With the advanced training from this course, you will quickly produce stunning spreadsheets and visually perfect graphs that will showcase business data to a much more professional degree. Use Excel to make your customer service excellent. How will I get my certificate? At the end of the course there will be a written assignment 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 Advanced Diploma in MS Excel. It is available to all students, of all academic backgrounds. Requirements Our Advanced Diploma in MS Excel 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 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 21 sections • 90 lectures • 22:14:00 total length •Introduction to Microsoft Excel 2019 New Features: 00:07:00 •CONCAT: 00:02:00 •IFS: 00:01:00 •MAXIFS: 00:01:00 •MINIFS: 00:01:00 •SWITCH: 00:02:00 •TEXTJOIN: 00:01:00 •Map Chart: 00:02:00 •Funnel Chart: 00:01:00 •Better Visuals: 00:06:00 •Pivot Table Enhancements: 00:02:00 •Power Pivot Updates: 00:01:00 •Navigate the Excel User Interface: 00:28:00 •Use Excel Commands: 00:10:00 •Create and Save a Basic Workbook: 00:19:00 •Enter Cell Data: 00:12:00 •Use Excel Help: 00:05:00 •Create Worksheet Formulas: 00:15:00 •Insert Functions: 00:17:00 •Reuse Formulas and Functions: 00:17:00 •Insert, Delete, and Adjust Cells, Columns, and Rows: 00:10:00 •Search for and Replace Data: 00:09:00 •Use Proofing and Research Tools: 00:07:00 •Apply Text Formats: 00:16:00 •Apply Number Format: 00:08:00 •Align Cell Contents: 00:09:00 •Apply Styles and Themes: 00:12:00 •Apply Basic Conditional Formatting: 00:11:00 •Create and Use Templates: 00:08:00 •Preview and Print a Workbook: 00:10:00 •Set Up the Page Layout: 00:09:00 •Configure Headers and Footers: 00:07:00 •Manage Worksheets: 00:05:00 •Manage Workbook and Worksheet Views: 00:07:00 •Manage Workbook Properties: 00:06:00 •Work with Ranges: 00:18:00 •Use Specialized Functions: 00:11:00 •Work with Logical Functions: 00:23:00 •Work with Date & Time Functions: 00:08:00 •Work with Text Functions: 00:11:00 •Sort Data: 00:10:00 •Filter Data: 00:10:00 •Query Data with Database Functions: 00:09:00 •Outline and Subtotal Data: 00:09:00 •Apply Intermediate Conditional Formatting: 00:07:00 •Apply Advanced Conditional Formatting: 00:05:00 •Create Charts: 00:13:00 •Modify and Format Charts: 00:12:00 •Use Advanced Chart Features: 00:12:00 •Create a PivotTable: 00:13:00 •Analyze PivotTable Data: 00:12:00 •Present Data with PivotCharts: 00:07:00 •Filter Data by Using Timelines and Slicers: 00:11:00 •Use Links and External References: 00:12:00 •Use 3-D References: 00:06:00 •Consolidate Data: 00:05:00 •Use Lookup Functions: 00:12:00 •Trace Cells: 00:09:00 •Watch and Evaluate Formulas: 00:08:00 •Collaborate on a Workbook: 00:19:00 •Protect Worksheets and Workbooks: 00:08:00 •Apply Data Validation: 00:13:00 •Search for Invalid Data and Formulas with Errors: 00:04:00 •Work with Macros: 00:18:00 •Create Sparklines: 00:07:00 •MapData: 00:07:00 •Determine Potential Outcomes Using Data Tables: 00:08:00 •Determine Potential Outcomes Using Scenarios: 00:09:00 •Use the Goal Seek Feature: 00:04:00 •Forecasting Data Trends: 00:05:00 •Create a Macro Using the Macro Recorder: 01:00:00 •Edit a Macro: 01:00:00 •Debug a Macro: 00:30:00 •Customize the Quick Access Toolbar and Hotkeys: 00:30:00 •Set Macro Security: 01:00:00 •Insert Text: 00:30:00 •Format Text: 00:30:00 •Sort Data: 00:30:00 •Duplicate Data: 01:00:00 •Generate a Report: 01:00:00 •Determine the Dialog Box Type: 00:15:00 •Capture User Input: 01:00:00 •Insert, Copy, and Delete Worksheets: 00:30:00 •Rename Worksheets: 00:30:00 •Modify the Order of Worksheets: 00:15:00 •Print Worksheets: 00:30:00 •Create User-Defined Functions: 00:30:00 •Automate SUM Functions: 00:30:00 •Resources - Microsoft Excel - Beginner Course - Cpd Accredited: 00:00:00 •Assignment - Advanced Diploma in MS Excel: 00:05:00

Unlock the full potential of Microsoft Office 2016 with our comprehensive course! From Word to Excel, PowerPoint, and more, master essential skills to boost your productivity and efficiency. Whether you're a beginner or seeking to enhance your proficiency, this course provides step-by-step guidance to navigate and utilize Office tools effectively. Enroll now and elevate your Microsoft Office skills to excel in your personal and professional endeavors!

This course condenses Microsoft Word, PowerPoint, and Outlook into a powerful 90-minute learning experience. Learn the core functionalities to create professional documents, captivating presentations, and manage your email efficiently. Ideal for busy professionals or anyone new to Microsoft Office. Boost your productivity and become a Microsoft whiz in just 90 minutes! Enroll now and conquer your workday!