43150 Courses delivered Online

Premium Bundle of all Time | Ofqual Regulation + NCFE Awards + CPD Accreditation | Assessment & Tutor Support Included

Course Objectives At the end of this course you will be able to: Identify and work with basic Word 2013 tools and features Edit text in a Word document Modify the appearance of text in a Word document Organise data in tables and lists Insert special characters and graphical objects Control the appearance of pages in a Word document Proof a document Customise the Word environment '1 year email support service Take a look at the consistent excellent feedback from our corporate clients visiting our site ms-officetraining co uk Customer Feedback Good pace, questions encoraged, trainer ensured everyone was kept at same level. Jenny Price - ACER ' With more than 20 years experience, we deliver courses on all levels of the Desktop version of Microsoft Office and Office 365; ranging from Beginner, Intermediate, Advanced to the VBA level. Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering public, one to one, tailored and bespoke courses. Our competitive rates start from £550.00 per day of training Tailored training courses: You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs. Getting Started with Word Identify the Components of the Word Interface Create a Word Document Help Editing a Document Navigate and Select Text Modify Text Find and Replace Text Formatting Text and Paragraphs Apply Character Formatting Align Text Using Tabs Display Text as List Items Control Paragraph Layout Apply Borders and Shading Apply Styles Manage Formatting Adding Tables Insert a Table Modify a Table Format a Table Convert Text to a Table Managing Lists Sort a List Renumber a List Customise a List Inserting Graphic Objects Insert Symbols and Special Characters Add Images to a Document Page Setup Apply a Page Border and Color Add a Watermark Add Headers and Footers Control Page Layout Proofing a Document Check Spelling and Grammar Other Proofing Tools Check Accessibility Customising the Word Environment Customise the Word Interface Additional Save Options Who is this course for? Who is this course for? This course is intended for delegates who want to learn the fundamentals skills of working with Microsoft Word Requirements Requirements General knowledge of the Windows OS Certificates Certificates Certificate of completion Digital certificate - Included

The Art of Negotiation: In-House Training Confidence, rapport, curiosity, and patience are essential ingredients to successfully handling a difficult conversation and negotiation. In this course, you will learn to identify and manage aspects of a negotiation, distinguish needs from wants, and manage expectations. The course will cover communication best practices, strategies for handling difficult conversations, and the basics of the art of negotiation. What you Will Learn Master the different ways to say 'no' Determine negotiation strategies based on typical client strategies Develop solutions to break deadlocks Getting Started Introductions Course structure Course goals and objectives Establishing personal learning objectives Foundation Concepts Exercise: Most Challenging Scenarios and Outcomes Debrief: Impact versus intent Addressing customer expectations Needs versus wants Key skills for managing customer relationships Elicitation (requirements gathering) Communication and active listening Sensitivity and empathy Handling Difficult Conversations Saying 'no' The Ladder of Inference 4-Step approach for handling difficult conversations Characteristics of a trusted advisor Communication Best Practices Attunement and active listening Exercise: Identifying Effective Techniques Communication pitfalls and best practices Building rapport and influence Words of wisdom Exercise: Reflection on Challenges Negotiation Strategies Negotiation basics Five phases of negotiation Identifying different strategies Traditional versus Progressive Hard - Soft - Principled Exercise: Your Preferred Techniques Selecting appropriate strategy for project negotiations Common pitfalls to avoid The impact of culture on negotiation Looking at conflict through the lens of negotiation Exercise: Mapping a Resolution

The Art of Negotiation: Virtual In-House Training Confidence, rapport, curiosity, and patience are essential ingredients to successfully handling a difficult conversation and negotiation. In this course, you will learn to identify and manage aspects of a negotiation, distinguish needs from wants, and manage expectations. The course will cover communication best practices, strategies for handling difficult conversations, and the basics of the art of negotiation. What you Will Learn Master the different ways to say 'no' Determine negotiation strategies based on typical client strategies Develop solutions to break deadlocks Getting Started Introductions Course structure Course goals and objectives Establishing personal learning objectives Foundation Concepts Exercise: Most Challenging Scenarios and Outcomes Debrief: Impact versus intent Addressing customer expectations Needs versus wants Key skills for managing customer relationships Elicitation (requirements gathering) Communication and active listening Sensitivity and empathy Handling Difficult Conversations Saying 'no' The Ladder of Inference 4-Step approach for handling difficult conversations Characteristics of a trusted advisor Communication Best Practices Attunement and active listening Exercise: Identifying Effective Techniques Communication pitfalls and best practices Building rapport and influence Words of wisdom Exercise: Reflection on Challenges Negotiation Strategies Negotiation basics Five phases of negotiation Identifying different strategies Traditional versus Progressive Hard - Soft - Principled Exercise: Your Preferred Techniques Selecting appropriate strategy for project negotiations Common pitfalls to avoid The impact of culture on negotiation Looking at conflict through the lens of negotiation Exercise: Mapping a Resolution

Introduction to Design Thinking: On-Demand Innovation is the cornerstone of highly successful companies, especially those that continue to be successful over the years and decades. Design thinking practices fuel this continual innovation, as they are the critical links from inspiration to delivery, concept to showroom floor, and start-up to global business. Design thinking is a structured approach to promoting innovation and creative problem-solving. It is not a new approach. It has been around for centuries, as the art, architecture, and inventions of mankind illustrate. By examining the steps to achieving great design and maximum utility of product, design thinking approaches provide a framework in which to develop new solutions to problems and new products to sell. This highly interactive course is designed to help participants think like designers to generate innovation, and to help teams to produce more innovation and creativity. Since design thinking is based on doing rather than thinking, we participants are challenged to apply the techniques, in the classroom, to create new ideas and solutions to a case study project. What you will Learn At the end of this program, you will be able to: Explain the underlying principles and value of using Design Thinking for innovation Describe the basic concepts of the Stanford Model for Design Thinking Evaluate a set of basic Design Thinking techniques for application to your projects Apply tools, techniques, and skills aligned with the 5 stages of the Stanford Model Drive innovation through Design Thinking at some level in your work environment Foundation Concepts Problems and solutions The Design Thinking difference Design Thinking skills and abilities Design Thinking mindset Design Thinking frameworks Stages of Design Thinking Problems and solutions The Design Thinking difference Design Thinking skills and abilities Design Thinking mindset Design Thinking frameworks General Practices Team formation Visualization Improvisation Personalization Empathize Practices Overview of Empathize techniques Observation Engagement Interviews Define Practices Overview of Define practices Unpacking techniques Defining the customer techniques Integrating the Define experience Ideate Practices Overview of Ideate practices Reusable techniques for the Ideate stage New Ideate techniques to explore Prototype & Test Practices Overview of Prototype practices Examples of prototypes Overview of Testing practices Forms of testing techniques Adopt and Adapt Design Thinking Overview of Design Thinking implementation Design Thinking implementation challenges Success in implementing Design Thinking Summary and Next Steps Workshop summary Next steps: Personal Action Plans

Overview This course is specially designed to enhance the skills required to analyse risk and crisis and the cause behind this. It will feed you with the necessary skills to minimise the chances of risk and in case it happens able to manage the situation in order to keep the business in a stable position. The course content will cover different crises caused due to internal or external issues and different ways to manage them. It will help the professionals to gain skills in planning beforehand various techniques to overcome risk and crisis and implementing the plan during that phase.

Overview This course is specially designed to enhance the skills required to analyse risk and crisis and the cause behind this. It will feed you with the necessary skills to minimise the chances of risk and in case it happens able to manage the situation in order to keep the business in a stable position. The course content will cover different crises caused due to internal or external issues and different ways to manage them. It will help the professionals to gain skills in planning beforehand various techniques to overcome risk and crisis and implementing the plan during that phase.

Duration 3 Days 18 CPD hours This course is intended for This course is primarily designed for students who want to gain the skills necessary to use VBA to automate tasks in Excel such as collecting data from external sources, cleaning, and manipulating data. The target student may also want to learn how to create custom worksheet functions to streamline worksheet formulas and make complex worksheets easier to support, maintain, and understand. Overview In this course, you will develop and deploy VBA modules to solve business problems. You will: Identify general components of VBA and their appropriate use in solving business solutions. Record VBA macros to automate repetitive tasks. Use reference tools built into Excel to get help on VBA programming language and objects used in the Excel VBA environment. Write VBA code to create a custom worksheet function. Eliminate, avoid, or handle errors in VBA code, and optimize its performance. Control how and when macros run. Develop UserForm objects to create custom dialog boxes and windows. Use VBA to read and write data from local files and cloud services. Use VBA to clean and transform data. Run programs and commands outside of Excel and share VBA projects with other users VBA (Visual Basic for Applications) enables you to enhance and extend the capabilities of Microsoft© Excel© and other applications in the Microsoft© Office application suite. You can use VBA to perform tasks that would be difficult or impossible to do using only worksheet functions, and you can automate a wide range of tasks involving the collection, processing, analysis, and visualization of data. This course will give you a good foundation for understanding, creating, and using VBA in your own Excel workbooks, show you how to work with data across different applications, and how to package the macros and functions you create so you can back them up, move them to other computers, and share them with other users Prerequisites To ensure your success in this course, you should be an experienced Excel user who is comfortable creating and working with Excel workbooks, including tasks such as entering worksheet formulas, using absolute and relative addressing, formatting cells, and creating pivot tables and charts. This level of skill could be acquired by taking the Microsoft Excel for Office 365? (Desktop or Online) courses, Parts 1, 2, and 3 1 - Using VBA to Solve Business Problems Topic A: Use Macros to Automate Tasks in Excel Topic B: Identify Components of Macro-Enabled Workbooks Topic C: Configure the Excel VBA Environment 2 - Automating Repetitive Tasks Topic A: Use the Macro Recorder to Create a VBA Macro Topic B: Record a Macro with Relative Addressing Topic C: Delete Macros and Modules Topic D: Identify Strategies for Using the Macro Recorder 3 - Getting Help on VBA Topic A: Use VBA Help Topic B: Use the Object Browser to Discover Objects You Can Use in VBA Topic C: Use the Immediate Window to Explore Object Properties and Methods 4 - Creating Custom Worksheet Functions Topic A: Create a Custom Function Topic B: Make Decisions in Code Topic C: Work with Variables Topic D: Perform Repetitive Tasks 5 - Improving Your VBA Code Topic A: Debug VBA Errors Topic B: Deal with Errors Topic C: Improve Macro Performance 6 - Controlling How and When Macros Run Topic A: Prompt the User for Information Topic B: Configure Macros to Run Automatically 7 - Developing Custom Forms Topic A: Display a Custom Dialog Box Topic B: Program Form Events 8 - Using VBA to Work with Files Topic A: Use VBA to Get File and Directory Structure Topic B: Use VBA to Read Text Files Topic C: Use VBA to Write Text Files 9 - Using VBA to Clean and Transform Data Topic A: Automate Power Query Topic B: Transform Data Using VBA and Workbook Functions Topic C: Use Regular Expressions Topic D: Manage Errors in Data 10 - Extending the Programming Environment Beyond the Workbook Topic A: Run Other Programs and Commands Topic B: Share Your VBA Projects

All in One Bundle Special Discount Offer Are you looking to enhance your Office Skills for Admin, Secretarial, PA (Executive PA)? If yes, then you have come to the right place. Our comprehensive courses on Microsoft Excel- Office Skills for Admin, Secretarial, PA (Executive PA) will assist you in producing the best possible outcome by learning the Office Skills for Admin, Secretarial, PA (Executive PA). Course 01: This Microsoft Office Bundle Microsoft Excel 2019 Microsoft Word 2019 Microsoft PowerPoint 2019 Microsoft Access 2019 Course 02: Admin, Secretarial, PA The Office Skills for Admin, Secretarial, PA (Executive PA) bundle is for those who want to be successful. In the Office Skills for Admin, Secretarial, PA (Executive PA) bundle, you will learn the essential knowledge needed to become well versed in Office Skills for Admin, Secretarial, PA (Executive PA). Our Office Skills for Admin, Secretarial, PA (Executive PA) bundle starts with the basics of Office Skills for Admin, Secretarial, PA (Executive PA) and gradually progresses towards advanced topics. Therefore, each lesson of this Microsoft Excel- Office Skills for Admin, Secretarial, PA (Executive PA) is intuitive and easy to understand. Why would you choose the course from Compliance Central: Lifetime access to courses materials Full tutor support is available from Monday to Friday Learn at your own pace from the comfort of your home Accessible, informative learning modules designed by expert instructors Get 24/7 help or advice from our email and live chat teams with the bundle Study in your own time through your computer, tablet or mobile device Curriculum Breakdown of the Microsoft Office Skills for Admin, Secretarial, PA (Executive PA) Microsoft Excel 2019 Microsoft Excel 2019 New Features Getting Started with Microsoft Excel Performing Calculations Modifying a Worksheet Formatting a Worksheet Printing Workbooks Managing Workbooks Microsoft Word 2019 Microsoft Word 2019 New Features Getting Started with Word Formatting Text and Paragraphs Working More Efficiently Managing Lists Adding Tables Inserting Graphic Objects Controlling Page Appearance Preparing to Publish a Document Microsoft PowerPoint 2019 Microsoft PowerPoint 2019 New Features PowerPoint Interface Presentation Basics Formatting Inserting Options Working with Objects Table Charts Review and Presentation Microsoft Access 2019 Microsoft Access 2019 New Features Introduction to Access Modify Data Working with Queries Access Forms Working with Reports CPD 25 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The Microsoft Office Skills for Admin, Secretarial, PA (Executive PA) bundle helps aspiring professionals who want to obtain the knowledge and familiarise themselves with the skillsets to pursue a career in Office Skills for Admin, Secretarial, PA (Executive PA). Requirements To enrol in this Microsoft Office Skills for Admin, Secretarial, PA (Executive PA) course, all you need is a basic understanding of the English Language and an internet connection. Career path The Microsoft Office Skills for Admin, Secretarial, PA (Executive PA) bundle will enhance your knowledge and improve your confidence in exploring opportunities in various sectors related to Microsoft Office Skills for Admin, Secretarial, PA (Executive PA). Certificates 2 CPD Accredited PDF Certificate Digital certificate - Included 2 CPD Accredited PDF Certificate for Free CDP Accerdited Hardcopy Certificate Hard copy certificate - £10.79 Delivery Charge: Inside the UK: Free Outside of the UK: £9.99 each

2 QLS Endorsed Course | CPD Certified | Free PDF + Hardcopy Certificates | 80 CPD Points | Lifetime Access