Results Found: 19
Course Information 1-Day Introduction to Excel Course Course Prerequisites This course assumes that the user understands the basics of using a Windows-based computer. Students should be comfortable using the keyboard, mouse, and Start menu. No previous experience with other versions of Excel is necessary. Overview Microsoft Excel is a useful tool for generating spreadsheets from a number of data sources. Using calculations and functions, users can easily manage any type of data including budgets, financial data, statistical data, reports, charts, graphs and small lists. Objectives This Excel course introduces the necessary features and skills which enable a user to begin working effectively and efficiently with Excel. Course Content Lesson 1: Getting Started with Microsoft Excel 2019/365 Get to know Excel Create a Workbook Get Help in Excel Lesson 2: Working with Data Create Formulas in a Worksheet Use Formulas and Functions Manipulate Data Insert, Manipulate, and Delete Cells, Columns and Rows Sort and Filter Data Create and Format Tables Lesson 3: Modifying a Worksheet Format Text Format Cells Align Cell Content Serach For and Replace Data Spell Check a Worksheet Lesson 4: Printing Workbook Contents Define the Basic Page Layout for a Workbook Refine the Page Layout and Apply Print Options Lesson 5: Managing Large Workbooks Format Worksheet Tabs Manage Worksheets Manage the View of Worksheets and Workbooks Lesson 6: Customising the Excel Environment Customise General and Language Options Customise Formula Options Customise Proofing and Save Options Customise the Ribbon and Quick Access Toolbar Customise the Functionality of Excel by Enabling Add-Ins Customise Advanced and Trust Centre Options Lesson 7: Visualising Data with Charts Create Charts Modify and Format Charts Create a Trendline
Overview The Intermediate Excel 2019/365 course builds on the techniques and concepts presented in the Excel 2019/365 Introduction course. It focuses on how to create and use advanced formulas, analyze data, organize worksheet data with tables and enhance workbooks. Course Prerequisites This Intermediate course assumes the user has completed or has an understanding of the topics covered in the Excel 2019/365 Introduction course, including: Using basic formulas and functions in a worksheet Editing and formatting Excel data Printing and saving Excel files Objectives By the end of this course users should be comfortable in creating advanced formulas, analyzing data with functions, analyzing data using functions and basic PivotTables, working with tables and enhancing workbooks. Course Content Lesson 1: Creating Advanced Formulas Apply Range Names Use Specialised Functions Link to Data in Multiple Workbooks Lesson 2: Analysing Data with Logical and Lookup Functions Use Text Functions Use Logical Functions Use Lookup Functions Use Date Functions Use Financial Functions Lesson 3: Organising Worksheet Data with Tables Create and FormatTables Modify Tables Use Table References Lesson 4: Analysing Data with PivotTables Create a Basic PivotTable Lesson 5: Enhancing Workbooks Customise Workbooks Apply Condtional Formatting Protect Files Course Prerequisites This Intermediate course assumes the user has completed or has an understanding of the topics covered in the Excel 2019/365 Introduction course, including: Using basic formulas and functions in a worksheet Editing and formatting Excel data Printing and saving Excel files
Delivered online with webinars, you can work full-time and study this IWFM Level 5 Diploma in Facilities Management. This qualification is designed for specialist facilities managers and those working at middle or senior management level who are responsible for specialised and complex functions. It is also suitable for those aspiring to work in such a role that currently work within the profession.
In 2021, the number of people using social media around the world increased to 4.48 billion. That's a huge number of people who can be reached on these platforms! In this course, you will learn how to develop and implement a social media strategy that is suited to your brand proposition and target customer. You will look at Facebook, Instagram, Twitter, LinkedIn & TikTok, and learn which platform (or platforms) are best suited to your business. Topics will include case studies of Irish and global businesses effectively using social media to build customer communities and successfully manage their online brands, best-practice for social media publishing, measuring performance and how to handle negative commentary on social media. Key Topics: ? The Social Media Landscape ? Defining Social Media Marketing objectives ? Using Facebook, Twitter, Instagram, TikTok, and LinkedIn for business ? Publishing best practices & the importance of Storytelling ? Video content & livestreaming ? Managing negative commentary ? Social media management tools ? Creating a publishing plan ? Implementing paid social media advertising campaigns on Facebook, Instagram, and LinkedIn ? Creating a social media marketing strategy Learning Outcomes: On completion of the course, you will: ? Understand the importance of creating varied, quality content for the various platforms, including what the platforms are optimised for. ? Recognise the key differences of each platform, and how this will impact your audiences and messages on the different platforms. ? Understand the power of the targeting features available on each of the platforms, and best practices for creating advertising campaigns to maximise your investment.
The SOLIDWORKS Essentials course is recommended to anyone new to SOLIDWORKS. Whether you have migrated from 2D CAD, another 3D system, or have no experience with CAD at all this course is suitable for you. Starting from the very basics of the program, the course develops looking at modelling essentials required for day to day use of the software, right through to some advanced topics for automating designs. Part and Assembly modelling and also the 2D drawing environment are introduced during this course. Lesson 1: SOLIDWORKS Basics and the User Interface: - The first lesson of this course introduces the user to the principal components of the SOLIDWORKS user interface and helps them to understand how different dimensioning methodologies convey different design intents. Lesson 2: Introduction to Sketching - Lesson 2 introduces the user to creating new sketches, using sketch geometry and establishing sketch relations between separate pieces of geometry. Finally the user will learn how to extrude sketches to form 3D solid bodies. Lesson 3: Basic Part Modelling - In lesson 3 of the course the user will become familiar with the basics of part modelling, learning how to use certain features to create cuts, holes and fillets. They will be taught how to use the editing tools to make changes to parts, and finally, how to create an engineering drawing from their parts. Lesson 4: Symmetry and Draft - Lesson 4 brings the focus back to design intent. In this lesson the user is introduced to symmetry within their sketches and how to use end conditions within features. They will also learn how to edit the definition and parameters of a feature and regenerate their model. Lesson 5: Patterning - Lesson 5 familiarises the user with pattern features within SOLIDWORKS and demonstrates how to automate the process of fully defining a sketch. The user will also learn how to create and use the references geometry type?s axes and planes. Lesson 6: Revolved Features - Lesson 6 teaches the user to create multi-body parts using more complex features such as revolve and sweep. They are shown how to calculate the physical properties of a part and how to perform rudimentary, first pass stress analysis. Lesson 7: Shelling and Ribs - Lesson 7 focusses on familiarising the user with manufacturing related features such as draft, shell and ribs. Lesson 8: Editing: Repairs - Upon successful completion of lesson 8 the user will understand how to diagnose problems in a part and repair them using the rollback feature. The user will also be introduced to the FeatureXpert tool to aid in repair. Lesson 9: Editing: Design Changes - In lesson 9 the user is encouraged to utilize all available tools to edit and make changes to a part, they are taught how different modelling techniques influence the ability to modify a part. Lesson 10: Configurations - Lesson 10 focuses on configurations, teaching the user how to suppress and unsuppress features in different configurations, change dimension values, and understand the ramifications of making changes to parts that have configurations. Lesson 11: Global Variables and Equations - This lesson looks at using global variables to tie dimension values together and using equations to give dimensions mathematical rules. The user will become comfortable with these tools and understand the scope of control they can have over their model. Lesson 12: Using Drawings - Lesson 12 looks into drawings in more detail, teaching the user to create and modify several types of drawing views and then add annotations. Lesson 13: Bottom-Up Assembly Modelling - Lesson 13 introduces the user to assembly modelling, bringing separate parts together into an assembly and adding mating relationships between them. The user will also be taught how to use configurations of parts within assemblies and how to add sub-assemblies. Lesson 14: Using Assemblies - The final lesson of this course shows the user how to create exploded views of their assemblies and perform mass property calculations, this information, along with other part properties, is then used to create a BOM that can be copied over to a drawing.
Managing Difficult Calls & Emails ?Build confidence with customers, minimise complaints & deliver a great experience by phone or email? Overall Aim: The aim of this online workshop is to help staff develop a greater understanding of the importance of communicating effectively with colleagues, customers and suppliers by the telephone, especially when people are irate. Participants will learn how to deal with complaints in a caring, assertive and professional manner without reacting inappropriately; resulting in satisfied and loyal customers and better working relations. This includes both internal and external customers. Who Should Attend: A practical and interactive online workshop, the course is designed for people who communicate directly with internal and external customers by telephone, and email ? includes all levels of staff, showroom, frontline, retail, customer service, production, technical support, administration, reception etc Objectives After completing the workshop, each participant will be able to: · Choose the most appropriate tool between telephone and email for customer communications · Build confidence with customers, whilst portraying a helpful and friendly attitude · See things through the eyes of the customer & prevent complacency · Encourage customer feedback and make it easy for customers to complain · Talk to customers in their own language - know what to say and how to say it · Learn to really listen to customers, ask the right questions & show empathy · Create relevant and well-structured emails applying the right language, style and approach · Apply proper email etiquette and follow company email policies · Be calm and assertive when dealing with different personalities and irate customers · Avoid defensive behaviour and trigger words that irate customers even under pressure · Resolve customer complaints and difficult situations in a confident and competent manner · Keep promises, keep customers informed, meet expectations & respond quickly and effectively Workshop Content: · The importance of a positive attitude to build trust & create great impressions · Think of a complaint as a gift ? an opportunity to resolve complaints · The traffic lights philosophy for measuring a customer?s reaction · Distinguish between control and influence for a positive outcome · Understand what customer?s really want - ask the right questions & listen intently · Tone of voice ? it?s not what we say, it?s how we say it · Write clear and persuasive emails and apply the right style, tone and language · Good protocol for responding to emails - manage flames, anger and quick responses · Maintain confidentiality when forwarding or copying emails, or sending attachments · Avoid trigger words & be assertive ? the appropriate behaviour for interacting with customers · Work under pressure to defuse difficult situations ? deal with criticism, remain calm & show empathy · Excel in service recovery management & always follow up - from complaint to satisfaction Training method Training is delivered online over two to four live classroom sessions (3 hours each) with discussions, exercises and break-out rooms using Zoom. Participants will be required to switch on their laptop video camera and microphone. All our online courses use a blend of online resources, virtual classroom and social learning. Up to 10 people can be included in online training courses. This online training module can be part of a larger programme. It can be teamed with other topics (ie communication, customer service, sales or business writing) so training is extended over a longer period. For some of these longer programmes, there will be group discussions, exercises & feedback based on individual/group needs. Each participant receives a workshop manual.
Office 365 Course Outline Introduction to Office 365 What is Office 365? Brief Description of Office 365 The Office 365 Environment Getting Started and Logging In to Office 365 Overview of Office 365 Environment + Screen Layout Personal Profile – Update your Profile, Add Photo Search for People and Content Communication Tools Email Use Outlook to Read, Send, Reply, Forward Organise Email with Folders, Categories Attach Files and Links Create and Insert a Signature Calendar Maintain your Calendar Create Calendar Items (Appointment, Event, Meeting) Invite Others, Share Calendar Contacts Create Contacts, Add from Email, Add Details to Contacts Search Contacts Create Groups (distribution lists) Tasks Create and Manage Tasks Team Communication Teams Overview Instant Messaging Online Meetings Sharing Information Store Files Online OneDrive Use Files Online Office Web Apps (What Features are Included/Excluded in Office Online) Office 2013 (New Features) Office 2016 (New Interface + Features) Word / Excel / PowerPoint 2016 OneNote 2016 Collect Information Excel Surveys – Overview