82 Courses in Cardiff delivered Live Online

Course Overview The "Microsoft Excel Complete Course" is designed to equip learners with the essential skills to master Microsoft Excel, one of the most widely used tools in data analysis and business operations. This course covers a comprehensive range of topics, including Excel's new features, formula creation, data visualisation, and workbook management. It offers practical knowledge that will help learners work more efficiently, whether they are managing large datasets, analysing trends, or presenting information. By the end of this course, learners will be confident in using Excel for various business tasks, gaining a strong foundation for further professional development. Course Description This course covers all key aspects of Microsoft Excel, from the basics to advanced techniques. Learners will explore Excel’s new features in the 2019 version, as well as how to perform calculations, modify worksheets, and apply formatting. The course delves into functions, lists, and data analysis tools, including PivotTables and charts. Learners will also learn how to work with multiple worksheets and workbooks, use lookup functions, and automate workbook functionality. With a focus on essential Excel tools and techniques, learners will gain the ability to efficiently manage and analyse data for business or personal use. Course Modules Module 01: Microsoft Excel 2019 New Features Module 02: Getting Started with Microsoft Office Excel Module 03: Performing Calculations Module 04: Modifying a Worksheet Module 05: Formatting a Worksheet Module 06: Printing Workbooks Module 07: Managing Workbooks Module 08: Working with Functions Module 09: Working with Lists Module 10: Analyzing Data Module 11: Visualizing Data with Charts Module 12: Using PivotTables and PivotCharts Module 13: Working with Multiple Worksheets and Workbooks Module 14: Using Lookup Functions and Formula Auditing Module 15: Sharing and Protecting Workbooks Module 16: Automating Workbook Functionality Module 17: Creating Sparklines and Mapping Data Module 18: Forecasting Data (See full curriculum) Who is this course for? Individuals seeking to improve their data management and analysis skills. Professionals aiming to enhance their productivity in Excel for business applications. Beginners with an interest in data analysis or office administration. Anyone looking to build a strong foundation in Excel for career advancement. Career Path Data Analyst Financial Analyst Office Administrator Project Manager Business Analyst Operations Manager Administrative Assistant HR Specialist

Duration 1 Days 6 CPD hours This course is intended for This course is designed for students who wish to use Microsoft Word to create and modify complex documents and use tools that allow them to customize those documents. Overview In this course, you will learn to create and modify complex documents and use tools that allow you to customize those documents. You will: Organize content using tables and charts. Customize formats using styles and themes. Insert content using Quick Parts. Use templates to automate document formatting. Control the flow of a document. Simplify and manage long documents. Use mail merge to create letters, envelopes, and labels. After you master the basics of creating, editing, and printing Microsoft© Word documents, you're ready to move on to tackling the more advanced features. In this course, you will work with features such as formats, styles, and templates to create professional documents with a consistent look and feel. You will add visual interest to your documents by using the tables and charts features. Quick Parts and templates provide efficiency and consistency when adding content, and long complex documents can be simplified and managed in Master Documents. Finally, you will use the mail merge feature to automate sending individual letters to customers. Creating professional-looking documents can give you and your organization a competitive edge. Implementing time-saving features such as document templates and automated mailings can help reduce expenses. Mastering these techniques will make you a valued employee in your organization. This course covers Microsoft Office Specialist Program exam objectives to help you prepare for the Word Associate (Office 365 and Office 2021): Exam MO-100 and Word Expert (Office 365 and Office 2021): Exam MO-101 certifications. Organizing Content Using Tables and Charts Topic A: Sort Table Data Topic B: Control Cell Layout Topic C: Perform Calculations in a Table Topic D: Create a Chart Topic E: Add an Excel Table to a Word Document (Optional) Customizing Formats Using Styles and Themes Topic A: Create and Modify Text Styles Topic B: Create Custom List or Table Styles Topic C: Apply Document Themes Inserting Content Using Quick Parts Topic A: Insert Building Blocks Topic B: Create and Modify Building Blocks Topic C: Insert Fields Using Quick Parts Using Templates to Automate Document Formatting Topic A: Create a Document Using a Template Topic B: Create and Modify a Template Topic C: Manage Templates with the Template Organizer Controlling the Flow of a Document Topic A: Control Paragraph Flow Topic B: Insert Section Breaks Topic C: Insert Columns Topic D: Link Text Boxes to Control Text Flow Simplifying and Managing Long Documents Topic A: Insert Blank and Cover Pages Topic B: Insert an Index Topic C: Insert a Table of Contents Topic D: Insert an Ancillary Table Topic E: Manage Outlines Topic F: Create a Master Document Using Mail Merge to Create Letters, Envelopes, and Labels Topic A: Use Mail Merge Topic B: Merge Envelopes and Labels Additional course details: Nexus Humans Microsoft Office Word 2021: Part 2 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 Microsoft Office Word 2021: Part 2 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 2 Days 12 CPD hours This course is intended for This course is primarily for Application Consultants, Business Analysts, Business Process Owners/Team Leaders/Power Users, and Developer Consultants. Overview At course completion students will know- The basic functions and navigation options of BusinessObjects Analysis for Microsoft Office- The special functions and layout design options of BusinessObjects Analysis for Microsoft Office In this course, students learn the basic functions and navigation options of the Analysis edition for Microsoft Office. Students will also learn the special functions and layout design options of Analysis. Components and Data Sources for Analysis Using Analysis Components and Data Sources Customization for Workbook Data Analysis Using the Basic Components of Analysis Sorting and Filtering Workbook Members Filtering Selected Workbook Members by Measure for Enhanced Analysis Using Hierarchies for Data Analysis in Workbooks Using Inserted Components to Add Workbook Functionality Configuring Filter Components Using Formulas to Enhance the Workbook Layout Defining Conditional Formatting Options for Workbooks Using a Prompting Dialog in Workbook Queries Extending Workbook Display Options with Functions and Microsoft Excel VBA Using Styles to Customize Workbook Appearance Setting Preferences to Control Workbook Behavior Publishing Analysis Documents to the BI Platform Server Presentation of Workbook Analysis Data Presenting Analysis Data for Business Users Additional course details: Nexus Humans BOAN10 SAP BusinessObjects Analysis for Microsoft Office 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 BOAN10 SAP BusinessObjects Analysis for Microsoft Office 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 1 Days 6 CPD hours This course is intended for This course is intended for students who want to use more advanced functionalities in Word, including image manipulation, collaboration and revision tracking, cross-referencing and linking, document security, forms, and process automation through macros. Overview In this course, you will learn to use the advanced capabilities of Word 2021. You will: Use images in a document. Create custom graphic elements. Collaborate on documents. Add reference marks and notes. Secure a document. Create and manipulate forms. Create macros to automate tasks. Microsoft© Word enables you to do far more than simple word processing. Word includes advanced image manipulation tools, collaboration features, cross-referencing and linking tools, entry forms and data collection, security features, and tools to automate document production. This course covers Microsoft Office Specialist Program exam objectives to help you prepare for the Word Associate (Office 365 and Office 2021): Exam MO-100 and Word Expert (Office 365 and Office 2021): Exam MO-101 certifications. Manipulating Images Topic A: Integrate Pictures and Text Topic B: Adjust Image Appearance Topic C: Insert Other Media Elements Using Custom Graphic Elements Topic A: Create Text Boxes and Pull Quotes Topic B: Add WordArt and Other Text Effects Topic C: Draw Shapes Topic D: Create Complex Illustrations with SmartArt Collaborating on Documents Topic A: Prepare a Document for Collaboration Topic B: Mark Up a Document Topic C: Review Markups Topic D: Merge Changes from Other Documents Adding Document References and Links Topic A: Add Captions Topic B: Add Cross-References Topic C: Add Bookmarks Topic D: Add Hyperlinks Topic E: Insert Footnotes and Endnotes Topic F: Add Citations and a Bibliography Securing a Document Topic A: Suppress Information Topic B: Set Formatting and Editing Restrictions Topic C: Restrict Document Access Topic D: Add a Digital Signature to a Document Using Forms to Manage Content Topic A: Create Forms Topic B: Modify Forms Automating Repetitive Tasks with Macros Topic A: Automate Tasks by Using Macros Topic B: Create a Macro

Duration 1 Days 6 CPD hours This course is intended for This course is intended for students who want to learn basic Word 2021 skills, such as creating, editing, and formatting documents; inserting simple tables and creating lists; and employing a variety of techniques for improving the appearance and accuracy of document content. Overview In this course, you will learn fundamental Word skills. You will: Navigate and perform common tasks in Word, such as opening, viewing, editing, saving, and printing documents, and configuring the application. Format text and paragraphs. Perform repetitive operations efficiently using tools such as Find and Replace, Format Painter, and Styles. Enhance lists by sorting, renumbering, and customizing list styles. Create and format tables. Insert graphic objects into a document, including symbols, special characters, illustrations, pictures, and clip art. Format the overall appearance of a page through page borders and colors, watermarks, headers and footers, and page layout. Use Word features to help identify and correct problems with spelling, grammar, readability, and accessibility. These days, most people take electronic word processing for granted. While we may still write out our grocery lists with pen and paper, we expect to use a computer to create the majority of our documents. It's impossible to avoid word-processing software in many areas of the business world. Managers, lawyers, clerks, reporters, and editors rely on this software to do their jobs. Whether you are an executive secretary or a website designer, you'll need to know the ins and outs of electronic word processing. Microsoft© Word 2021 is designed to help you move smoothly through the task of creating professional-looking documents. Its rich features and powerful tools can make your work easy, and even fun. In this course, you'll learn how to use Word 2021 to create and edit simple documents; format documents; add tables and lists; add design elements and layout options; and proof documents. This course covers Microsoft Office Specialist Program exam objectives to help you prepare for the Word Associate (Office 365 and Office 2021): Exam MO-100 and Word Expert (Office 365 and Office 2021): Exam MO-101 certifications. Getting Started with Word 2021 Topic A: Navigate in Microsoft Word Topic B: Create and Save Word Documents Topic C: Manage Your Workspace Topic D: Edit Documents Topic E: Preview and Print Documents Topic F: Customize the Word Environment Formatting Text and Paragraphs Topic A: Apply Character Formatting Topic B: Control Paragraph Layout Topic C: Align Text Using Tabs Topic D: Display Text in Bulleted or Numbered Lists Topic E: Apply Borders and Shading Working More Efficiently Topic A: Make Repetitive Edits Topic B: Apply Repetitive Formatting Topic C: Use Styles to Streamline Repetitive Formatting Tasks Managing Lists Topic A: Sort a List Topic B: Format a List Adding Tables Topic A: Insert a Table Topic B: Modify a Table Topic C: Format a Table Topic D: Convert Text to a Table Inserting Graphic Objects Topic A: Insert Symbols and Special Characters Topic B: Add Images to a Document Controlling Page Appearance Topic A: Apply a Page Border and Color Topic B: Add Headers and Footers Topic C: Control Page Layout Topic D: Add a Watermark Preparing to Publish a Document Topic A: Check Spelling, Grammar, and Readability Topic B: Use Research Tools Topic C: Check Accessibility Topic D: Save a Document to Other Formats

Legal Secretary and Office Skills Diploma Course Overview The Legal Secretary and Office Skills Diploma is a comprehensive course designed for those aiming to pursue a career as a legal secretary or administrative professional. This course covers a wide range of essential office skills and legal secretarial duties, offering a strong foundation in the tools and techniques needed to succeed in the office environment. Learners will gain proficiency in Microsoft Office tools, including Word, PowerPoint, Outlook, and Excel, as well as essential knowledge of legal office practices. Upon completion, learners will be well-equipped to manage office operations, handle legal documentation, and assist with legal professionals' administrative tasks, enhancing their career prospects in both the legal and administrative fields. Course Description This diploma provides a structured learning experience, covering essential topics such as legal secretary duties, and Microsoft Office tools, including Word, PowerPoint, Outlook, and Excel. Learners will explore essential office management techniques, including document preparation, managing correspondence, organising meetings, and understanding legal terminology. The course also introduces top Excel keyboard shortcuts to boost efficiency in document management and office tasks. As learners progress through the modules, they will gain key skills required to assist legal teams in their day-to-day operations. The course is designed for those looking to enter the legal, administrative, or office management fields and offers in-depth exposure to both the technical and professional skills that employers seek. Legal Secretary and Office Skills Diploma Curriculum Module 01: Legal Secretary Module 02: Microsoft Word Essentials Module 03: Microsoft PowerPoint Essentials Module 04: Microsoft Outlook Essentials Module 05: Microsoft Excel - Top 50 Keyboard Shortcuts (See full curriculum) Who is this course for? Individuals seeking to become proficient in legal secretary and office management roles. Professionals aiming to advance in administrative careers within the legal sector. Beginners with an interest in learning essential office skills and legal office practices. Those who wish to work in law firms or corporate legal departments. Career Path Legal Secretary Office Administrator Executive Assistant Paralegal Administrative Assistant in Law Firms Office Manager in Corporate Settings

Duration 0.625 Days 3.75 CPD hours This course is intended for This course is intended for individuals who want to gain basic knowledge of Windows 10 and Microsoft Office. Course Outline Introduction to the Windows 10 Desktop Managing Files and Folders in Windows 10 Word 2016 Ribbon and Navigation Excel 2016 Ribbon and Navigation PowerPoint 2016 Ribbon and Navigation Outlook 2016 Email/Calendar/Contacts Basics (lecture/demo only)

Duration 1 Days 6 CPD hours This course is intended for This course is intended for business users and knowledge workers in a variety of roles and fields who have competence in a desktop-based installation of the Microsoft Office 2010, 2013, or 2016 edition of the Microsoft Office productivity suite, and who are now extending Microsoft Office to a collaborative cloud-based Office 365 environment. Overview In this course, you will build upon your knowledge of the Microsoft Office desktop application suite to work productively in the cloud-based Microsoft Office 365 environment. You will: Sign in, navigate, and identify components of the Office 365 environment. Create, edit, and share documents with team members using the Office Online apps, SharePoint, OneDrive for Business, and Delve. Collaborate and work with colleagues using the Yammer and Planner apps. Use email and manage contacts with Outlook on the web. Collaborate using Teams. Configure Teams. This course introduces working with shared documents in the familiar Office 365 online apps?Word, PowerPoint©, and Excel©?as an alternative to installing the Microsoft© Office desktop applications. This course also introduces several productivity apps including Yammer?, Planner, and Delve© that can be used in combination by teams for communication and collaboration. Getting Started with Office 365 Topic A: Sign In to Office 365 Topic B: Navigate the Office 365 Environment Collaborating with Shared Files Topic A: Work with Shared Documents in SharePoint Topic B: Edit Documents in Office Online Topic C: Collaborate on the SharePoint Site Topic D: Work with OneDrive for Business Topic E: Find Shared Resources Using Productivity Apps Topic A: Work with Productivity Apps in Combination Topic B: Broadcast Messages with Yammer Using Outlook on the Web Topic A: Send and Receive Email Topic B: Manage Contacts Topic C: Schedule Appointments Topic D: Personalize Outlook on the Web Collaborating with Teams Topic A: Overview of Microsoft Teams Topic B: Converse and Share in Teams Topic C: Call and Meet in Teams Topic D: Collaborate with Microsoft 365 Apps and Teams Configuring Teams Topic A: Configure Teams Topic B: Configure Channels Topic C: Configure Tabs Additional course details: Nexus Humans Microsoft 365 Office for the Web (with Teams) 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 Microsoft 365 Office for the Web (with Teams) 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 1 Days 6 CPD hours This course is intended for This course is intended for business users and knowledge workers in a variety of roles and fields who have competence in a desktop-based installation of the Microsoft Office 2010 or 2013 edition of the Microsoft Office productivity suite, and who are now extending Microsoft Office to a collaborative cloud-based Office 365 environment. Overview In this course, you will build upon your knowledge of the Microsoft Office desktop application suite to work productively in the cloud-based Microsoft Office 365 environment.You will:- Sign in, navigate, and identify components of the Office 365 environment.- Create, edit, and share documents with team members using Word Online, Excel Online, PowerPoint Online, and Microsoft SharePoint.- Collaborate and work with colleagues using the Team, Planner, and Yammer apps.- Use email and manage contacts with Outlook on the web.- Use instant messaging with Skype for Business.- Conduct online meetings with Skype for Business. This course is an introduction to Microsoft© Office 365© with Skype© for Business in a cloud-based environment. It can be used as an orientation to the full suite of Office 365 cloud-based tools, or the Skype for Business lessons can be presented separately in a seminar-length presentation with the remaining material available for later student reference. Getting Started Sign In to Office 365 Navigate the Office 365 Environment Collaborating with Shared Files Work with Shared Documents in SharePoint Edit Documents in Office Online Collaborate on the SharePoint Site Work with OneDrive for Business and Delve Using Productivity Apps Work with Productivity Apps in Combination Broadcast Messages with Yammer Collaborate with the Teams App Manage Tasks with the Planner App Using Outlook on the Web Send and Receive Email Manage Contacts Schedule Appointments Personalize Outlook on the Web Communicating with Skype for Business Overview of Skype for Business Use Instant Messaging Make Voice and Video Calls Using Skype for Business Meetings Initiate Meetings Use Meeting Controls and Options Customize Skype for Business Additional course details: Nexus Humans Office 365 Web Apps (with Skype for Business) 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 Office 365 Web Apps (with Skype for Business) 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 1 Days 6 CPD hours This course is intended for This course is intended for business users and knowledge workers in a variety of roles and fields who have competence in a desktop-based Microsoft Office productivity suite, and who are now extending Microsoft Office to a collaborative cloud-based Office 365 environment. Overview In this course, you will build upon your knowledge of the Microsoft Office desktop application suite to work productively in the cloud-based Microsoft Office 365 environment. You will: Sign in, navigate, and identify components of the Office 365 environment. Create, edit, and share documents with team members using the Office Online apps, SharePoint, OneDrive for Business, and Teams Collaborate using Teams. Configure Teams. This course introduces several productivity apps including SharePoint, OneDrive and Teams that can be used in combination by teams for communication and collaboration. Outline for Teams About What is Microsoft Teams? Overview How to Access Microsoft Teams Etiquette for using teams Integration Capabilities SharePoint OneDrive Interface Storage ? OneDrive & SharePoint Permissions & Access Owner, Member & Guest Communication and Collaboration Team Conversations Private conversations Mentions Inviting people Search Settings and Customization Use the search tool to find specific messages, files or people Working with Files Create new files Upload files Attaching or sharing Files Edit and Collaborate on files Open files in SharePoint OneDrive for personal files Administration (Champions) Add members to a Team Access administrator settings Meetings and calls Initiate a meeting on demand Schedule a meeting and invite attendees Meetings and Outlook Introduction to SharePoint What is SharePoint Understanding your permissions Logging into SharePoint Working with SharePoint sites Working with SharePoint sites Navigate, browse and search in a site Follow a site Working with documents Navigate a library Open and edit a document Upload or create a document in a library Share a file Set alerts for files Use checkout and check-in Team collaboration Versioning Getting Started (OneDrive Outline) Sign in, access and navigate Working with files and folders Upload files Organize files and folders Rename. Copy and download files Delete and recover files Search Use OneDrive with Office Save an office file online to OneDrive Use OneDrive with desktop office Versioning Share files Co-authoring