1332 Microsoft Office courses in Cardiff delivered Online

Level 1 Diploma in Admin, Secretarial & PA Skills with Minute Taking and Microsoft Excel Embark on a career-enhancing journey with our Level 1 Diploma, designed to elevate your proficiency in Admin, Secretarial & PA roles. Deepen your expertise in these fields, gaining essential skills in minute taking and Microsoft Excel to enhance your administrative acumen. Learning Outcomes: Define Admin, Secretarial & PA roles. Explain task management for Admin, Secretarial & PA. Implement time management in Admin, Secretarial & PA. Evaluate diary management strategies. Develop meeting management plans for Admin, Secretarial & PA. More Benefits: LIFETIME access Device Compatibility Free Workplace Management Toolkit Key Modules from Diploma in Admin, Secretarial & PA Skills: An Overview of Admin, Secretarial, PA: Gain foundational knowledge of roles and responsibilities in Admin, Secretarial, PA fields. Task Management for Admin, Secretarial, PA: Master task prioritization and workflow optimization for effective Admin, Secretarial, PA roles. Time Management for Admin, Secretarial, PA: Acquire time management skills for increased productivity in Admin, Secretarial, PA tasks. Diary Management for Admin, Secretarial, PA: Learn to manage schedules and appointments proficiently as an Admin, Secretarial, PA. Meeting Management & Minute Taking: Develop skills in meeting facilitation and accurate minute-taking for Admin, Secretarial, PA. Office Management and Supervision: Understand office supervision techniques and management best practices for Admin, Secretarial, PA roles.

Are you ready to embark on an enlightening journey of wisdom with the Data Analysis bundle, and pave your way to an enriched personal and professional future? If so, then Step into a world of knowledge with our bundle - Data Analysis with SQL & Tableau for Data Analytics. Delve into eight immersive CPD Accredited courses, each a simple course: Course 1: Introduction to Data Analytics with Tableau Course 2: Big Data Analytics with PySpark Tableau Desktop and MongoDB Course 3: Big Data Analytics with PySpark Power BI and MongoDB Course 4: Google Data Studio: Data Analytics Course 5: SQL for Data Science, Data Analytics and Data Visualization Course 6: Business Analysis Course Level 5 Course 7: Financial Analysis Course 8: Data Analysis and Forecasting in Excel Traverse the vast landscapes of theory, unlocking new dimensions of understanding at every turn. Let the Data Analysis with SQL & Tableau for Data Analytics bundle illuminate your path to wisdom. The Data Analysis with SQL & Tableau for Data Analytics bundle offers a comprehensive exploration into a rich tapestry of vast knowledge across eight carefully curated courses. The journey is designed to enhance your understanding and critical thinking skills. Each course within the bundle provides a deep-dive into complex theories, principles, and frameworks, allowing you to delve into the nuances of the subject matter at your own pace. In the framework of the Data Analysis with SQL & Tableau for Data Analytics package, you are bestowed with complimentary PDF certificates for all the courses included in this bundle, all without any additional charge. Adorn yourself with the Data Analysis bundle, empowering you to traverse your career trajectory or personal growth journey with self-assurance. Register today and ignite the spark of your professional advancement! So, don't wait further and join the Data Analysis with SQL & Tableau for Data Analytics community today and let your voyage of discovery begin! Learning Outcomes: Upon completion of the Data Analysis with SQL & Tableau for Data Analytics Bundle, you will be able to: Attain a holistic understanding in the designated areas of study with the Data Analysis bundle. Establish robust bases across each course nestled within the Data Analysis bundle. Decipher intricate concepts through the articulate content of the Data Analysis bundle. Amplify your prowess in interpreting, scrutinising, and implementing theories. Procure the capacity to engage with the course material on an intellectual and profound level. Become proficient in the art of problem-solving across various disciplines. Stepping into the Data Analysis with SQL & Tableau for Data Analytics bundle is akin to entering a world overflowing with deep theoretical wisdom. Each course within this distinctive bundle is an individual journey, meticulously crafted to untangle the complex web of theories, principles, and frameworks. Learners are inspired to explore, question, and absorb, thus enhancing their understanding and honing their critical thinking skills. Each course invites a personal and profoundly enlightening interaction with knowledge. The Data Analysis bundle shines in its capacity to cater to a wide range of learning needs and lifestyles. It gives learners the freedom to learn at their own pace, forging a unique path of discovery. More than just an educational journey, the Data Analysis with SQL & Tableau for Data Analytics bundle fosters personal growth, enabling learners to skillfully navigate the complexities of the world. The Data Analysis bundle also illuminates the route to a rewarding career. The theoretical insight acquired through this bundle forms a strong foundation for various career opportunities, from academia and research to consultancy and programme management. The profound understanding fostered by the Data Analysis bundle allows learners to make meaningful contributions to their chosen fields. Embark on the Data Analysis journey and let knowledge guide you towards a brighter future. CPD 80 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Individuals keen on deepening their firm understanding in the respective fields. Students pursuing higher education looking for comprehensive theory modules. Professionals seeking to refresh or enhance their knowledge. Anyone with a thirst for knowledge and a passion for continuous learning. Requirements Without any formal requirements, you can delightfully enrol in this Data Analysis with SQL & Tableau for Data Analytics Bundle. Career path Armed with the Data Analysis with SQL & Tableau for Data Analytics bundle, your professional journey can reach new heights. The comprehensive theoretical knowledge from this bundle can unlock diverse career opportunities across several fields. Whether it's academic research, consultancy, or programme management, the Data Analysis bundle lays a solid groundwork. Certificates CPD Certificate Of Completion Digital certificate - Included 8 Digital Certificates Are Included With This Bundle CPD Quality Standard Hardcopy Certificate (FREE UK Delivery) Hard copy certificate - £9.99 Hardcopy Transcript: £9.99

Are you ready to embark on an enlightening journey of wisdom with the Functional Skills IT with Microsoft Excel, IoT & ICT Training bundle, and pave your way to an enriched personal and professional future? If so, then Step into a world of knowledge with our bundle - Functional Skills IT with Microsoft Excel, IoT & ICT Training. Delve into eight immersive CPD Accredited courses, each a simple course: Course 1: IT Administration and Networking Course 2: Microsoft Excel Course Course 3: ICT: Information and Communication Technology Course 4: Start an IT Asset Department Course 5: CompTIA IT Fundamentals ITF+ (FCO-U61) Course 6: Recruitment: IT Basics for IT Recruiters Course 7: Web Application Penetration Testing Course Course 8: Internet of Things Traverse the vast landscapes of theory, unlocking new dimensions of understanding at every turn. Let the Functional Skills IT with Microsoft Excel, IoT & ICT Training bundle illuminate your path to wisdom. The Functional Skills IT with Microsoft Excel, IoT & ICT Training bundle offers a comprehensive exploration into a rich tapestry of vast knowledge across eight carefully curated courses. The journey is designed to enhance your understanding and critical thinking skills. Each course within the bundle provides a deep-dive into complex theories, principles, and frameworks, allowing you to delve into the nuances of the subject matter at your own pace. In the framework of the Functional Skills IT with Microsoft Excel, IoT & ICT Training package, you are bestowed with complimentary PDF certificates for all the courses included in this bundle, all without any additional charge. Adorn yourself with the Functional Skills IT with Microsoft Excel, IoT & ICT Training bundle, empowering you to traverse your career trajectory or personal growth journey with self-assurance. Register today and ignite the spark of your professional advancement! So, don't wait further and join the Functional Skills IT with Microsoft Excel, IoT & ICT Training community today and let your voyage of discovery begin! Learning Outcomes: Upon completion of the Functional Skills IT with Microsoft Excel, IoT & ICT Training Bundle, you will be able to: Attain a holistic understanding in the designated areas of study with the Functional Skills IT with Microsoft Excel, IoT & ICT Training bundle. Establish robust bases across each course nestled within the Functional Skills IT with Microsoft Excel, IoT & ICT Training bundle. Decipher intricate concepts through the articulate content of the Functional Skills IT with Microsoft Excel, IoT & ICT Training bundle. Amplify your prowess in interpreting, scrutinising, and implementing theories. Procure the capacity to engage with the course material on an intellectual and profound level. Become proficient in the art of problem-solving across various disciplines. Stepping into the Functional Skills IT with Microsoft Excel, IoT & ICT Training bundle is akin to entering a world overflowing with deep theoretical wisdom. Each course within this distinctive bundle is an individual journey, meticulously crafted to untangle the complex web of theories, principles, and frameworks. Learners are inspired to explore, question, and absorb, thus enhancing their understanding and honing their critical thinking skills. Each course invites a personal and profoundly enlightening interaction with knowledge. The Functional Skills IT with Microsoft Excel, IoT & ICT Training bundle shines in its capacity to cater to a wide range of learning needs and lifestyles. It gives learners the freedom to learn at their own pace, forging a unique path of discovery. More than just an educational journey, the Functional Skills IT with Microsoft Excel, IoT & ICT Training bundle fosters personal growth, enabling learners to skillfully navigate the complexities of the world. The Functional Skills IT with Microsoft Excel, IoT & ICT Training bundle also illuminates the route to a rewarding career. The theoretical insight acquired through this bundle forms a strong foundation for various career opportunities, from academia and research to consultancy and programme management. The profound understanding fostered by the Functional Skills IT with Microsoft Excel, IoT & ICT Training bundle allows learners to make meaningful contributions to their chosen fields. Embark on the Functional Skills IT with Microsoft Excel, IoT & ICT Training journey and let knowledge guide you towards a brighter future. CPD 100 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Individuals keen on deepening their firm understanding in the respective fields. Students pursuing higher education looking for comprehensive theory modules. Professionals seeking to refresh or enhance their knowledge. Anyone with a thirst for knowledge and a passion for continuous learning. Requirements Without any formal requirements, you can delightfully enrol in this Functional Skills IT with Microsoft Excel, IoT & ICT Training Bundle. Career path Armed with the Functional Skills IT with Microsoft Excel, IoT & ICT Training bundle, your professional journey can reach new heights. The comprehensive theoretical knowledge from this bundle can unlock diverse career opportunities across several fields. Whether it's academic research, consultancy, or programme management, this bundle lays a solid groundwork. Certificates CPD Certificate Of Completion Digital certificate - Included 8 Digital Certificates Are Included With This Bundle CPD Quality Standard Hardcopy Certificate (FREE UK Delivery) Hard copy certificate - £9.99 Hardcopy Transcript: £9.99

Overview This comprehensive course on Excel PowerQuery and PowerPivot will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Excel PowerQuery and PowerPivot 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 PowerQuery and PowerPivot. It is available to all students, of all academic backgrounds. Requirements Our Excel PowerQuery and PowerPivot 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 • 28 lectures • 01:50:00 total length •pivot table power query power pivot - 1: 00:09:00 •pivot table power query power pivot - 2: 00:01:00 •pivot table power query power pivot - 3: 00:02:00 •pivot table power query power pivot - 4: 00:03:00 •pivot table power query power pivot - 5: 00:01:00 •pivot table power query power pivot - 6: 00:04:00 •pivot table power query power pivot - 7: 00:08:00 •pivot table power query power pivot - 8: 00:05:00 •pivot table power query power pivot - 9: 00:03:00 •pivot table power query power pivot - 10: 00:04:00 •pivot table power query power pivot - 11: 00:04:00 •pivot table power query power pivot - 12: 00:02:00 •pivot table power query power pivot - 13: 00:03:00 •pivot table power query power pivot - 14: 00:05:00 •pivot table power query power pivot - 15: 00:02:00 •pivot table power query power pivot - 16: 00:03:00 •pivot table power query power pivot - 17: 00:03:00 •pivot table power query power pivot - 18: 00:08:00 •pivot table power query power pivot - 19: 00:02:00 •pivot table power query power pivot - 20: 00:04:00 •pivot table power query power pivot - 21: 00:05:00 •pivot table power query power pivot - 22: 00:09:00 •pivot table power query power pivot - 23: 00:04:00 •pivot table power query power pivot - 24: 00:03:00 •pivot table power query power pivot - 25: 00:04:00 •pivot table power query power pivot - 26: 00:09:00 •Resources - Excel PowerQuery and PowerPivot: 00:00:00 •Assignment - Excel PowerQuery and PowerPivot: 00:00:00

Duration 5 Days 30 CPD hours This course is intended for The Messaging Administrator deploys, configures, manages, and troubleshoots recipients, permissions, mail protection, mail flow, and public folders in both on-premises and cloud enterprise environments. Responsibilities include managing message hygiene, messaging infrastructure, and hybrid configuration and migration. To implement a secure hybrid topology that meets the business needs of a modern organization, the Messaging Administrator must collaborate with the Security Administrator and Microsoft 365 Enterprise Administrator. The Messaging Administrator should have a working knowledge of authentication types, licensing, and integration with Microsoft 365 applications. Overview After completing this course, students will be able to: Configure and manage the transport pipeline Manage and troubleshoot mail flow and transport issues Manage message hygiene and compliance Manage authentication for messaging Configure organizational settings and sharing Manage mobile devices Manage role-based permissions Create and manage recipient objects and resources Plan, implement, and troubleshoot public folders Plan a hybrid environment Perform mailbox migrations Deploy and troubleshoot a hybrid environment This course examines the key elements of Microsoft 365 messaging administration, including message transport and mail flow, messaging security, hygiene, and compliance, messaging infrastructure, and hybrid messaging. This course is designed for IT Professionals who deploy and manage the messaging infrastructure for Microsoft 365 in their organization. Managing the Transport Pipeline Overview of Transport Services Configuring Message Transport Managing Transport Rules Managing and Troubleshooting Mail Flow Managing Mail Flow Troubleshooting Mail Flow Troubleshooting Transport Issues Troubleshooting with Logs Managing Message Hygiene Planning for Message Hygiene Managing Anti-Malware and Anti-Spam Policies Managing Advanced Threat Protection Managing Compliance Messaging Compliance in the SCC Messaging Compliance in Exchange Managing Exchange Online Archiving and Auditing Managing Content Search Managing Organizational Settings Managing Authentication for Messaging Configuring Organizational Settings Configuring Organizational Sharing Managing Mobile Devices Mobile Device Mailbox Policies Managing Mobile Device Access Managing Role-Based Permissions Managing Admin Roles Managing User Roles Exchange Setup - RBAC and AD Split Permission Managing Recipient Objects and Resources Exchange Recipients Creating and Managing Exchange Recipients Managing Email Addresses, Lists, and Resources Managing Public Folders Planning the Public Folder Hierarchy Implementing and Managing Public Folders Troubleshooting Public Folders Planning a Hybrid Environment Exchange Hybrid Deployment Requirements Planning to Run the Hybrid Configuration Wizard Performing Mailbox Migrations Planning Mailbox Migrations Performing IMAP Migrations Performing Cutover and Staged Migrations Performing Advanced Migrations Deploying and Troubleshooting a Hybrid Environment Deploying and Managing an Edge Transport Server Configuring a Hybrid Deployment using the HCW Implementing Advanced Hybrid Functionality Troubleshooting Hybrid Deployments

Duration 3 Days 18 CPD hours This course teaches you how to solve a broad range of problems that can arise in organizations using Microsoft Exchange Online. In this course, you?ll troubleshoot many aspects of Microsoft Exchange Online, including mail flow, compliance, recipient problems, and cloud/on-premises hybrid configurations.

The 'Visual Basic and VBScript Training' course is a comprehensive program that equips learners with the skills to create and manipulate software applications using Visual Basic (VB) and VBScript. Participants will delve into the fundamental concepts, advanced techniques, and graphical user interface (GUI) development, enabling them to build interactive and user-friendly applications. This course covers a range of topics, from basic scripting to advanced resource management, empowering learners to harness the power of these programming languages for various software development needs. Learning Outcomes: Gain proficiency in creating and manipulating software applications using Visual Basic. Understand the core concepts of classes and their role in application development. Explore file handling techniques for efficient data management. Develop graphical user interfaces (GUI) for user-friendly application interaction. Implement dialog boxes to enhance user experience and gather input. Learn advanced scripting techniques to optimize application functionality. Utilize resource management techniques for efficient application design. Develop proficiency in VBScript for creating dynamic web pages and scripting actions. Why buy this Visual Basic and VBScript Training? Unlimited access to the course for forever Digital Certificate, Transcript, student ID all included in the price Absolutely no hidden fees Directly receive CPD accredited qualifications after course completion Receive one to one assistance on 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 Visual Basic and VBScript Training 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 £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Who is this course for? This Visual Basic and VBScript Training does not require you to have any prior qualifications or experience. You can just enrol and start learning.  Aspiring software developers looking to learn Visual Basic and VBScript. Programmers seeking to expand their knowledge of application development. Web developers interested in using VBScript for dynamic web content. IT professionals looking to enhance their scripting and programming skills. Prerequisites This Visual Basic and VBScript Training 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. Career path Software Developer - Median salary of $110,000 - $120,000 per year. Web Developer - Median salary of $75,000 - $85,000 per year. Application Developer - Median salary of $90,000 - $100,000 per year. Systems Analyst - Median salary of $80,000 - $90,000 per year. IT Consultant - Median salary of $90,000 - $100,000 per year. Course Curriculum Section 01: Introduction Introduction To This Course 00:02:00 Setup On Windows 00:06:00 Run Code Online 00:01:00 Section 02: Basics Console Output 00:04:00 Comments 00:03:00 Variables 00:03:00 Console Input 00:02:00 Data Types 00:08:00 Constants 00:03:00 Enumerations 00:04:00 Directives 00:05:00 Operators 00:06:00 If Statement 00:05:00 Switch Statement 00:04:00 Loops 00:08:00 Strings 00:05:00 Date & Time 00:04:00 Arrays 00:06:00 For Each Loop 00:04:00 ArrayList 00:04:00 Hashtable 00:05:00 SortedList 00:03:00 Stack 00:05:00 Queue 00:04:00 Subs 00:07:00 Functions 00:04:00 Exception Handling 00:05:00 Section 03: Classes Simple Class Example 00:09:00 Constructor 00:03:00 Destructor 00:03:00 Shared Properties 00:04:00 Inheritance 00:04:00 Scope 00:03:00 Section 04: File Handling File Handling 00:07:00 Section 05: GUI Setup A GUI Project 00:03:00 Forms 00:05:00 TextBox 00:06:00 Label 00:02:00 Button 00:04:00 ListBox 00:04:00 ComboBox 00:03:00 RadioButton 00:04:00 CheckBox 00:02:00 DateTimePicker 00:03:00 PictureBox 00:03:00 ProgressBar 00:03:00 GroupBox 00:04:00 TreeView 00:04:00 ListView 00:02:00 Events 00:03:00 Section 06: Dialog Box Color Dialog 00:03:00 Font Dialog 00:03:00 Open File Dialog 00:03:00 Save File Dialog 00:05:00 Print Dialog 00:03:00 Section 08: Resource Menus 00:02:00 Anchoring & Docking 00:04:00 Modals 00:03:00 Regular Expressions 00:09:00 Parsing an XML File 00:06:00 Section 07: Advanced Resource - Visual Basic and VBScript Training 00:00:00 Assignment Assignment - Visual Basic and VBScript Training 00:00:00

Whether you are a bit of a newbie or consider yourself an Excel guru, this 1 hour FREE webinar will give you at least 10 things that I promise will satisfy two criteria: You don't know them You will use them to make your life easier

This one-day course focuses on issues such as writing formulas and accessing help while writing them, and taking formulas to the next level by nesting one inside another for a powerful formula result. It also looks at ways of analysing data with reports, summarised by varying criteria. A range of time-saving tips and tricks are shared. This course will help participants: Calculate with absolute reference Group worksheets Link to tables Use the function library effectively Get to grips with the logical IF function Use conditional formatting Create pivot table reports Use data validation Master the VLOOKUP function 1 Calculating with absolute reference The difference between a relative and absolute formula Changing a relative formula to an absolute Using $ signs to lock cells when copying formulas 2 Grouping worksheets Grouping sheets together Inputting data into multiple sheets Writing a 3D formula to sum tables across sheets 3 Linking to tables Linking to a source table Using paste link to link a table to another file Using edit links to manage linked tables 4 The function library Benefits of writing formulas in the function library Finding the right formula using insert function Outputting statistics with COUNTA and COUNTBLANK Counting criteria in a list with COUNTIFS 5 Logical IF Function Outputting results from tests Running multiple tests for multiple results The concept of outputting results from numbers 6 Conditional formatting Enabling text and numbers to standout Applying colour to data using rules Managing rules Copying rules with the format painter 7 View side by side Comparing two Excel tables together Comparing two sheets together in the same file 8 Pivot table reports Analysing data with pivot tables Managing a pivot table's layout Outputting statistical reports Controlling number formats Visualising reports with pivot charts Inserting slicers for filtering data 9 Data validation Restricting data input with data validation Speeding up data entry with data validation 10 VLOOKUP function Best practices for writing a VLOOKUP A false type lookup A true type lookup Enhance formula results with IFNA 11 Print options Getting the most from print Printing page titles across pages Scaling content for print

Microsoft Excel training | Excel Courses for Accountants: Excel Courses Overview Microsoft Excel is the world's most popular spreadsheet program, learning how to use the software with Osborne Training shows that you've taken one of the best Excel training courses available. Comprehensive excel courses come with up to date material to practice at home and during your class. Excel courses for accountants This course is a highly recognised excel course for accountants. We will also provide a step by step manual of all the tricks you can do using Excel spreadsheets to gain better management reporting and budgeting skills. It is a fundamental program for professional Accountants. Excel spreadsheets are the most powerful tool, extensively used for reporting and analysis. Having advanced skills in excel can excel your career and help you to stand ahead of the competitive job market. Advanced skills in Excel is a must for any potential professional accountants and who are already running a practice or considering opening a practice. Certificate of Attendance Excel Course Content Creating worksheets, formatting text Simple and complex formulas Handling rows and columns Average, max and min functions and using charts. Use of IF Formula Summing Techniques Cell References Formula Linking Tables and Bordering Look up References (Vlookup, Hlookup, etc) Data Validation Conditional Formatting Date & Time Formulas Charts & Graphs Protection & Security Creating Pivot Table Pivot Table Analysis