3787 Office Skills courses in Cardiff delivered Online

Enhance your accounting skills and proficiency in Microsoft Excel with our Accounts Clerk and MS Excel Training course. Learn the fundamentals of bookkeeping, accounting principles, and Excel functions. Ideal for aspiring accounts clerks and professionals seeking to improve their Excel proficiency for efficient data management and analysis.

Overview The Advanced Diploma in Microsoft Excel is the best way for you to gain deep insight and knowledge of this topic. You will learn from industry experts and obtain certificates after completing the course. Enrol now for a limited-time discounted price. Like all the courses of The Teachers Training, this Advanced Diploma in Microsoft Excel is designed with the utmost attention and thorough research. All the topics are broken down into easy to understand bite-sized modules that help our learners to understand each lesson very easily. We don't just provide courses at The Teachers Training; we provide a rich learning experience. After purchasing a course from The Teachers Training, you get complete lifetime access with tutor support.  Our expert instructors are always available to answer all your questions and make your learning experience exquisite. After completing the Advanced Diploma in Microsoft Excel, you will instantly get an e-certificate that will help you get jobs in the relevant field and will enrich your CV. What You Will Learn Get to know about relevant job opportunities. Format data labels, create excel values and build basic formulas in excel. Learn all the functions like SUM(), MIN(), MAX() etc Be able to insert images and shapes and customise icons Change layout views, convert spreadsheets into PDFs and print specific ranges of cells Learn how to group and filter pivot table data Skills You Will Gain Keyboard shortcuts Conditional formatting Flash Fill Filters/ AutoFilter Fast Track your Excel skills Why Choose Teachers Training Some of our website features are: This is a dedicated website for teaching 24/7 tutor support Interactive Content Affordable price Courses accredited by the UK's top awarding bodies 100% online Flexible deadline Entry Requirements No formal entry requirements. You need to have: Passion for learning A good understanding of the English language Be motivated and hard-working Over the age of 16. Assessment To successfully complete the course you must have to attend the MCQ assessment. The assessment is delivered through our online learning platform. You will receive the results of your assessment immediately upon completion. Certification CPD Certification from The Teachers Training: Successfully completing the MCQ exam of this course qualifies you for a CPD-accredited certificate from The Teachers Training. You will be eligible for both PDF copy and hard copy of the certificate to showcase your achievement however you wish. You can get your digital certificate (PDF) for £4.99 only Hard copy certificates are also available, and you can get one for only £10.99 You can get both PDF and Hard copy certificates for just £12.99! The certificate will add significant weight to your CV and will give you a competitive advantage when applying for jobs.

This comprehensive Microsoft Excel 2016 course is designed to take you from a complete beginner to an advanced Excel user, equipping you with essential skills for data analysis, financial modeling, and business productivity. Whether you're managing budgets, analyzing sales data, or automating repetitive tasks, this course provides hands-on training with real-world examples. In this ultimate course, you will get the opportunity to establish a solid foundation in Excel. The course will first teach you the basic functions and formulas. Gradually, you will learn to work with multiple Worksheets. Furthermore, the course will introduce you to the essentials of Pivot Tables and Pivot Charts. In addition, you will know how to analyse data in Excel. The course will also show you the fundamentals of forecasting data and data mapping. At the end of the course, you will be able to take your Excel skills to the next level. This course will also provide you with a QLS- endorsed certificate and elevate your resume. Join now! Learning Outcomes Familiarise yourself with the basic to advanced level excel tools Learn the process of managing and modifying Workbooks Enrich your knowledge of Pivot Tables and Pivot Charts Develop your skills in data analysis Learn about lookup functions and formula editing Grasp the principles of data mapping and forecasting Certificate of Achievement Endorsed Certificate of Achievement from the Quality Licence Scheme Upon successful completion of the final assessment, you will be eligible to apply for the Quality Licence Scheme Endorsed Certificate of Achievement. This certificate will be delivered to your doorstep through the post for £119. An extra £10 postage charge will be required for students leaving overseas.  CPD Accredited Certificate After the successful completion of the final assessment, you will receive a CPD-accredited certificate of achievement. The PDF certificate is for 9.99, and it will be sent to you immediately after through e-mail. You can get the hard copy for 15.99, which will reach your doorsteps by post.  Method of Assessment At the end of the course, there will be an MCQ assessment. To pass this exam, you must score at least 60%. When you submit the assessment, it will be examined, and the results will be given to you immediately. Who Is This Course For? This course is ideal for beginners with no prior Excel knowledge, office professionals looking to enhance efficiency, students preparing for careers in finance/data, and entrepreneurs managing business data. It’s also valuable for accountants, analysts, and administrative staff seeking to upgrade their skills. Whether for academic, professional, or personal use, this course provides step-by-step training for all levels. Career path This Microsoft Office 2016 Excel Beginner to Advanced course is designed to help you expand your knowledge and understanding of this sector. After completing the course, you will be able to explore career options such as Data Entry Clerk – £18K–£24K Administrative Assistant – £20K–£28K Financial Analyst – £30K–£50K Accountant – £25K–£45K Business Intelligence Analyst – £35K–£60K Excel Trainer / Consultant – £30K–£55K Course Contents Microsoft Excel Beginners Getting Started with Microsoft Office Excel 2016 Performing Calculations Modifying a Worksheet Formatting a Worksheet Printing Workbooks Managing Workbooks Microsoft Excel Intermediate Working with Functions Working with Lists Analyzing Data Visualizing Data with Charts Using PivotTables and PivotCharts Microsoft Excel Advanced Working with Multiple Worksheets and Workbooks Using Lookup Functions and Formula Auditing Sharing and Protecting Workbooks Automating Workbook Functionality Creating Sparklines and Mapping Data Forecasting Data Resources

Looking to bring your AI knowledge to life in a visually powerful way? Our Hands-on Machine Learning Project – Auto Image Captioning for Social Media Course takes you deep into the fascinating world of machine-generated descriptions. With social media driving more engagement through visuals than ever, this course helps you grasp how AI can generate captions that not only describe but also engage, contextualise, and communicate effectively. The focus is sharply tuned to image captioning technology and its role in today’s media-driven, attention-tight landscape. Expect to work your way through a structured learning journey where you’ll explore the building blocks of machine learning and how these elements are applied in automated image captioning. Whether you're aiming to polish your ML project portfolio or understand how AI is quietly shaping the way content is created and consumed online, this course gives you just the right amount of edge — no gimmicks, no fluff, just what matters. All content is delivered fully online, making it a flexible and accessible way to deepen your understanding of AI-powered communication tools used across social media platforms. Learning Outcomes: Develop an auto image captioning system using machine learning. Preprocess image and caption data. Define and evaluate the model. Deploy your machine learning app on AWS EC2 instance.Gain real-world experience in machine learning app development. The Hands-on Machine Learning Project - Auto Image Captioning for Social Media Platform course is designed to give you a comprehensive understanding of how to develop an auto image captioning system using machine learning. The course covers topics such as importing libraries, preprocessing text and image data, defining and evaluating the model, and deploying your machine learning app on AWS EC2 instance. You'll have access to the caption dataset and image dataset for training and test purposes, providing you with hands-on experience in machine learning app development. This course is perfect for aspiring data scientists, machine learning engineers, and developers who want to gain real-world experience in machine learning app development. With the skills and knowledge gained from this course, you'll be able to create your own auto image captioning system and start a career in the exciting field of machine learning. Hands on Machine Learning Project - Auto Image Captioning for Social Media Course Curriculum Section 01: Introduction Introduction to Course Section 02: Building the Auto Image Captioning Import the Libraries Accessing the Caption Dataset for Training Accessing the Image DataSet for Training Preprocessing the Text Data Pre-Process and Load Captions Data Loading the Captions for Training and Test Data Preprocessing of Image Data Loading Features for Train and Test Dataset Text Tokenization and Sequence Text Data Generators Define the Model Evaluation of Model Test the Model Section 03: Deployment of Machine Learning App Create Streamlit App Streamlit Prediction Test Streamlit App Deploy Streamlit on AWS EC2 Instance How is the course assessed? Upon completing an online module, you will immediately be given access to a specifically crafted MCQ test. For each test, the pass mark will be set to 60%. Exam & Retakes: It is to inform our learners that the initial exam for this online course is provided at no additional cost. In the event of needing a retake, a nominal fee of £9.99 will be applicable. Certification Upon successful completion of the assessment procedure, learners can obtain their certification by placing an order and remitting a fee of __ GBP. £9 for PDF Certificate and £15 for the Hardcopy Certificate within the UK ( An additional £10 postal charge will be applicable for international delivery). CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Aspiring data scientists. Machine learning engineers. Developers interested in machine learning app development. Anyone interested in the field of machine learning. Professionals looking to upskill in the latest technology. Requirements There are no formal entry requirements for the course, with enrollment open to anyone! Career path Data Scientist: £40,000 to £80,000 per year. Machine Learning Engineer: £55,000 to £90,000 per year. Software Developer: £30,000 to £60,000 per year. Artificial Intelligence Developer: £40,000 to £80,000 per year. Computer Vision Engineer: £45,000 to £85,000 per year. Certificates Certificate of completion Digital certificate - £9 You can apply for a CPD Accredited PDF Certificate at the cost of £9. Certificate of completion Hard copy certificate - £15 Hard copy can be sent to you via post at the expense of £15.

Learn Excel for Business Accounting with our comprehensive course. From basic worksheet creation to advanced functions like pivot tables, charts, and data analysis, master Excel's features for efficient accounting tasks. Ideal for business professionals and students looking to enhance their Excel skills for financial management.

Duration 1 Days 6 CPD hours This one day course provides a comprehensive overview of macOS, complete with insider tips for getting the most out of the operating system. The course shows how to configure system preferences, navigate around the finder, personalize the interface and as well as achieve fluency with all the operational functions of the macOS. Meet The macOS The User InterfaceUser PreferencesThe Menus and Menu Paths The Toolbar Scroll Bars The Sidebar The Go Menu, Utilities Folder The Clipboard Launching Applications The Finder The Launchpad and Mission Control Finder Essentials The Desktop Quick Look Different Viewing Options Spring Loaded Folders Creating an Archive Customizing your Finder The Desktop Customize your Toolbar Organizing your Desktop Labeling your Documents and Folders Creating Folders Smart Folders The Dock Opening Applications from the Dock Dock Preferences and Customizing your Dock Choosing which Applications appear in the Dock Accessing Folder content using Stacks Your Home Folder Moving, Copying and Deleting Files Emptying the Trash Switching Between Applications Showing and Hiding Applications. Closing Documents vs. Quitting Applications Using Continuity - Mac and iOS Interfacing with your Mac and your Apple mobile devices Messages and answering your iPhone Windows Closing and Minimizing Placing documents in the Dock The Keyboard Control, Option (Alt) and Command Keys Keyboard Shortcuts The Dictation Function Gestures and Voice Mouse and Hand Gestures Using Text-to-Speech Searches Finding Files and documents Advanced Spotlight Searches Widgets & Notifications The Dashboard Enabling and Viewing Widgets Enabling and Viewing Notifications Using Spaces Switching between Spaces Running applications in full screen mode Installing or Upgrading Applications Buying from the Mac App Store Downloading from the Internet Sharing Files Sending files using AirDrop Dropbox File Synchronization Enable File Sharing Getting OnLine Understanding the Apple Airport Connecting wirelessly Using Ethernet Creating a Network Connecting through outside Network Servers and VPN Staying Current with Software Update Troubleshooting Application Crashes Force Quit Deleting Preferences The Key Chain Internet Connections Backing Up Time Machine Setting up Time Machine Performing Backups Shortcuts How to better use and access Files and documents Basic shortcuts for speed and efficiency New User Account Creating a New User Switching Between Multiple User Accounts Additional course details: Nexus Humans Getting Started With the Mac Operating System training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the Getting Started With the Mac Operating System course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

Duration 5 Days 30 CPD hours This course is intended for The primary audience for this course are Application Consultants, Business Process Architects, Business Process Owners/Team Leads/Power Users, Program/Project Managers, and Users. Overview Teach participants the basic functions of inventory management and physical inventory, and how to create different goods movements in the SAP system.Familiarize participants with the special functions of inventory management and physical inventory, and the Customizing settings relevant to inventory management and physical inventory. This course will give students an overview and in depth knowledge of the inventory management process in SAP. After attending this class, students will understand the major business processes, functions & configuration in inventory management. Introduction to Inventory Management Defining Inventory Management and Physical Inventory Moving Goods with the MIGO Transaction Goods Receipts (GRs) Posting a GR Without Reference Posting a GR with Reference Posting a GR with Automatic Generation of a PO Posting Cancellations, Return Deliveries, and Returns Applying Order Price Unit in Inventory Management Applying Tolerances and the Delivery Completed Indicator Adding Date Checks to GRs for a PO Stock Transfers and Transfer Postings Performing Transfer Postings Performing Stock Transfers Between Storage Locations Performing Stock Transfers Between Plants Reservations Creating Manual Reservations Evaluating Reservations Checking Availability and Missing Parts Goods Issues (GIs) Posting Unplanned GIs Posting a GI with Reference Configuring Stock Determination Allowing Negative Stock Special Forms of Procurement and Special Stocks Performing the Process of Subcontracting Performing Vendor Consignment Operating Pipeline Processes Posting Goods Movements for Special Stocks Special Features of Material Valuation Posting Goods Movements for Material Types UNBW and NLAG Configuring Split Valuation Physical Inventory Conducting Physical Inventory Analyzing the Determination of Book Inventory Simplifying Physical Inventory Applying Cycle Counting Applying Inventory Sampling Analyses Applying Stock Lists and Document Lists Applying Periodic Processing Customizing Implementing Settings for Documents Setting Up Movement Types Applying Other Customizing Settings Logistics Execution Managing Logistics Execution Processes Posting a GR Against a PO Posting a GI for a Sales Order Additional course details: Nexus Humans SCM510 SAP Inventory Management and Physical Inventory training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the SCM510 SAP Inventory Management and Physical Inventory course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

Duration 5 Days 30 CPD hours This course is intended for The primary audience for this course are Production Planners, Project Team Members, and Team Leaders. Overview Gain detailed working knowledge of:Demand Management (DM)Materials Requirement Planning (MRP)Master Production Scheduling (MPS) In this course, students learn detailed working knowledge of Demand Management (DM), Materials Requirement Planning (MRP), and Master Production Scheduling (MPS). Course Outline MRP Types Planning Run Settings (MD01/MD02) Effects of Demand on MRP o Introduction to Planning Strategies o Safety Stock Stock Transports Effects of Stock on MRP Stock Types o Quality Inspection Effects of Receipts on MRP ATP effects on MRP o Capacity Planning effects on MRP Lot Sizing Procedures o Dynamic Safety Stock Scrap Source Determination for New Receipts Quota Arrangements Additional course details: Nexus Humans SCM241 SAP Production Planning in ERP for Functional Consultant training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the SCM241 SAP Production Planning in ERP for Functional Consultant course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

Duration 5 Days 30 CPD hours This course is intended for The primary audience for this course are Application Consultants, Business Process Architects, Business Process Owners/Team Leads/Power Users, and Users. Overview Provide an overview of the fundamental concepts and procedures of production planning within SAP ERP.Gain an overview of the manufacturing methods supported by ERP. This course is designed to provide an overview of the fundamental concepts and procedures of production planning within SAP ERP. Introduction to Supply Chain Planning Drafting Supply Chain Planning Planning-Specific Master Data Reviewing Supply Chain Master Data Reviewing Production Master Data Sales and Operations Planning Drafting Flexible Planning Executing Standard Sales and Operations Planning Releasing a Standard Sales and Operations Plan Demand Management Setting Up a Demand Program Planning Make-to-Stock Production Planning Make-to-Order Production Checking Product Availability Material Requirements Planning Drafting MRP Procedures Planning Material Requirements Interpreting the Results of Material Requirements Planning Long-Term Planning Creating a Long-Term Planning Scenario Executing Long-Term Planning Introduction to Production Execution Distinguishing Production Types Production with Production Orders Drafting Production Orders Creating Production Orders Releasing Production Orders Executing Material Staging for Production Orders Executing Confirmation and Goods Receipt for Production Orders Evaluating Production Orders Production with Process Orders Drafting Process Orders Creating and Interpreting Process Orders Executing Process Orders Using Additional Functions with Process Orders Repetitive Manufacturing Drafting Repetitive Manufacturing Preparing Repetitive Manufacturing Planning Line Loading in Repetitive Manufacturing Using Material Staging and Confirmation Integrating Costing, Controlling, and Reporting The Kanban Principle Drafting Kanban Using Kanban in Production Additional course details: Nexus Humans SCM130 SAP ERP Planning and Manufacturing Overview training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the SCM130 SAP ERP Planning and Manufacturing Overview course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

Duration 5 Days 30 CPD hours This course is intended for Project team members & consultants Overview Set up organizational structures in Warehouse ManagementConfigure control of pick, putaway, and stock transfer activities at master data and Customizing levelIntegrate Warehouse Management into other logistics applications in SAP ERP In this course, students will set up organizational structures in the Warehouse Management System and configure control of pick, put-away, and stock transfer activities at the master data and customizing level. Course Outline Organizational units and master data in Warehouse Management Configuration of the interface between Inventory Management and Warehouse Management Batch management and quality management in the warehouse Delivery processes using Warehouse Management Staging components for production from the warehouse Configuring the warehouse activity monitor as a control instrument Inventory at storage bin level Case study: setting up a new warehouse Additional course details: Nexus Humans SCM630 SAP Warehouse Management training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the SCM630 SAP Warehouse Management course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.