1161 Courses in Glasgow

Course Objectives At the end of this course you will be able to: Work with advanced lookup and reference functions Create macros to automate common tasks Use advanced techniques to analyse data Create PivotTables and PivotCharts Work with data validation tools Import and export data ' Customer Feedback Best Training Ever! Just finished a bespoke 1-1 training course in Excel Advanced, Macros & VBA. Pedro is an excellent trainer, imparting his skills and knowledge in the best way - appropriately to audience skills, knowledge and ability. Pedro is always approachable, encouraging and supportive, giving delegates the optimum learning environment. I would not hesitate to recommend Pedro as a trainer, whatever your level of ability. Amanda Morris - Treasury & Systems Accountant at Reall - Real Equity for All The course was very interesting and engaging and will definitely be put to use. The trainer was very helpful and charismatic. Marving Lopez - AM Best Europe Pedro was excellent. Very knowledgeable, clear and great rapport with class. Darren Barkey - Direct Wines Great content and learnt a lot. Really enjoyable :) Kristie-Lee Ryan - Stirling Ackroyd 1 year email support service Take a closer look at the consistent excellent feedback from our growing corporate clients visiting our site ms-officetraining co uk 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. Please visit our site (ms-officetraining co uk) to get a feel of the excellent feedback our courses have had and look at other courses you might be interested in. Advanced Functions COUNT, COUNTA, COUNTIF, COUNTBLANK, SUMIF, SUBTOTAL IF, OR, AND, IFERROR VLOOKUP to lookup Exact Values and Approximate values MATCH, INDIRECT, ROW/COLUMN, INDEX, OFFSET Analysing Data PMT function to calculate a monthly payment of a loan What If Analysis using Goal Seek Use scenarios to consider many different variables Using Solver Add-in to optimize variables PivotTables Create a PivotTable to analyse worksheet data Add or remove fields in a PivotTable Change the data source for a PivotTable Working with external data sources Using different Statistical Functions Calculate a Running Total, % of Grant Total, Difference From… Using the Slicer and Timeline to filter the PivotTable Using Filters in a PivotTable Group by Date, Auto Group by ranges of values, Custom Group Create a PivotChart The GETPIVOTDATA function Formula auditing Precedents and dependents Error checking Watch a formula and its result by using the Watch Window Evaluate a nested formula one step at a time Data Validation Number Validation Data List Validation Message Prompts and Alerts Conditional Data Validation Data Validation Errors Consolidation Consolidate data by position Consolidate data by category Use a formula to consolidate data Outline (group) data in a worksheet Create an outline of rows Create an outline of columns Copy outlined data Hide or remove an outline Connect external data to your workbook Using the Power Query Editor to import data From Text and CSV, From Access, From Web, From another Workbook Using the Power Query Editor to; Transform your data by Selecting which fields to import, by Splitting Columns, Changing Data Type and more. Deleting Applied Steps Refreshing your data Working with Form Controls; Buttons, Option Buttons and Scroll Bars Introduction to Macros Change Macro Security settings How to Record a macro Some Macro Examples Delete a macro Edit the macro to view the VBA code Copy part of a macro to create another macro Assign a macro to a button Who is this course for? Who is this course for? This course is intended to end users who want to develop their skills so they can use advanced techniques to analyse extensive and complex datasets in Excel and to automate simple tasks with the use of Macros. Requirements Requirements Preferably, delegates should have attended the Excel Intermediate course. Career path Career path Excel know-how can instantly increase your job prospects as well as your salary. 80 percent of job openings require spreadsheet and word-processing software skills Certificates Certificates Certificate of completion Digital certificate - Included

This course focuses on empowering managers to foster a culture of ownership, leverage effective delegation practices, and enhance productivity within their teams. Participants will explore strategies and techniques to delegate effectively, promote accountability, and optimise team performance. This course is available to book for delivery in-house for your organisation and people exclusively, for either a half or full days training workshop. Prices are dependent on size of group ranging from a minimum of 4 to a maximum of 12 delegates. If you have a smaller number of delegates the Puritas 1:1 Leadership Coaching Programme is recommended.

Course Objectives At the end of this course you will be able to: Identify the components of the Microsoft Project environment Create a new project plan Create the project schedule Use different views to analyse the project plan Create, allocate and manage resources in a project plan Finalise a project plan Track progress View and report project plan information ' 1 year email support service Customer Feedback Very good course. Learnt a lot. Looking forward to the next level. Alexandra - CIAL ' 1 year email support service Take a closer look at the consistent excellent feedback from our growing corporate clients visiting our site ms-officetraining co uk 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. Introduction to Microsoft Project Recap on project management concepts Project environment overview The 3 databases: Tasks, Resources and Assignments Different ways of displaying the Project Plan Access Help Creating a Project Plan Create a New Project Plan Project Information Create and apply the project calendar Defining recurring exceptions to the calendar Defining the calendar's work weeks Create the Summary tasks Create the Work Breakdown Structure Task creation and scheduling Exploring the Entry Table and its fields Task editing and the Task Information window Task Durations Defining Milestones Manual Scheduling vs Automatic Scheduling Changing the Task's Calendar Create a split in a Task Create Task Relationships Adding Lag or Lead to a Relationship Identifying the Critical Path Adding Constraints and Deadlines to Tasks Create Recurring Activities Adding Notes and links to Tasks Managing Resources Exploring the Entry Table and its fields Resource editing and the Resource Information window Resource Types Fixed Costs vs Variable Costs Adding Resource Costs Defining when costs accrue Changing the Resource Calendar and Availability Project calendar vs Resource and Task Calendar Assigning Resources to Tasks Effort Driven Scheduling Resolving Resource Overallocation Tracking the Project Progress Setting a Project Baseline Entering Actuals Different ways of viewing the Progress Checking if the Project is on track Viewing and Reporting Project Detail Adding Tasks to the Timeline and sharing it Modifying the Timescale and Zoom level Formatting the Gantt View Filtering and Grouping Tasks Print and Troubleshoot the Gantt View Using built-in Reports in Microsoft Project Who is this course for? Who is this course for? This course is designed for a person who has an understanding of project management concepts, who is responsible for creating and modifying project plans, and who needs a tool to manage these project plans. Requirements Requirements General knowledge of the Windows OS Career path Career path Microsoft Office know-how can instantly increase your job prospects as well as your salary. 80 percent of job openings require spreadsheet and word-processing software skills Certificates Certificates Certificate of completion Digital certificate - Included

Course Objectives At the end of this course you will be able to: Collaborate on documents Add reference marks and notes Make long documents easier to use Secure a document Work with forms '1 year email support service Take a closer look at the consistent excellent feedback from our growing corporate clients visiting our site ms-officetraining co uk 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. Collaborating on Documents Modify User Information Share a Document Compare Document Changes Review a Document Merge Document Changes Review Tracked Changes Coauthor Documents Adding Reference Marks and Notes Add Captions Add Cross-References Add Bookmarks Add Hyperlinks Insert Footnotes and Endnotes Add Citations and a Bibliography Simplifying and Managing Long Documents Insert Blank and Cover Pages Insert an Index Insert a Table of Contents Insert an Ancillary Table Manage Outlines Create a Master Document Securing a Document Suppress Information Set Formatting and Editing Restrictions Add a Digital Signature to a Document Restrict Document Access Forms Create Forms Manipulate Forms Who is this course for? Who is this course for? This course is designed for users who would like to create and work with lengthy and well structured documents, collaborate with others on documents, and create forms in Microsoft Word Requirements Requirements Preferably, delegates should have attended the Word Intermediate course. Career path Career path Microsoft Office know-how can instantly increase your job prospects as well as your salary. 80 percent of job openings require spreadsheet and word-processing software skills Certificates Certificates Certificate of completion Digital certificate - Included

Emotional Intelligence Training

Negotiation is an everyday challenge for some whether it be in the office, field or at home. Have you ever walked away from a situation thinking "if I'd only put my thoughts, side, opinion or words across better"? This 2-day course is perfect for managers, supervisors and sales people. It will focus on negotiation skills and the techniques that go with it. In this energy-charged provision you'll learn and practice negotiation, assertiveness and influencing techniques. Course Syllabus The syllabus of the Effective Communication and Influencing course is comprised of seven modules, covering the following: Module One An Introduction to Negotiation Assessment of your current sales and negotiation strengths and improvement areas What is negotiation? Identifying objectives and all factors affecting negotiation The negotiation model - the four stages Module Two The Preparation Stage The significance of preparation and why we need to prepare What do you need to prepare? Preparing a set of objectives: yours and theirs Understanding constants and variables Researching the other party Creating a "win-win" situation Preparing yourself for possible set-backs and objections Module Three The Discussion Stage The importance of rapport building Opening the negotiation The power of effective questioning techniques Improving your listening skills Controlling emotions Spotting the signs - non-verbal communication and voice clues Module Four The Proposing Stage Stating your opening position Responding to offers How to deal effectively with adjournments Module Five The Bargaining and Closing Stage Making concessions - the techniques Adopting key bargaining skills Dealing with objections and underhand tactics Closing techniques Confirming the agreement Creating long term, lasting commitment Scheduled Courses Unfortunately this course is not one that is currently scheduled as an open course, and is only available on an in-house basis. Please contact us for more information.

Microsoft Project Blue Belt® 2013: In-House Training This course introduces Project Server 2013 features that expedite scheduling projects and simplify managing tasks within an enterprise environment. Learn different aspects of Project Server and their benefits to varying roles in the enterprise, and gain hands-on experience and insights on best practices from SMEs around the world. This course introduces Project Server 2013 features that expedite scheduling projects and simplify managing tasks within an enterprise environment. Learn different aspects of Project Server and their benefits to varying roles in the enterprise, and gain hands-on experience and insights on best practices from SMEs around the world. What you Will Learn You'll learn how to: Identify the project's life cycle Understand the Enterprise Project Management (EPM) environment Apply the basic project management principles to selecting, initiating, planning, executing, monitoring and controlling, and closing your Project 2013 schedules Take advantage of new features Explain Project Server 2013 views and project sites Meet deadlines and budget restrictions Keep the workloads of your resources within their available limits Efficiently update your schedule Take advantage of the standard reports, custom views, and visual reports for your projects Take a brief look at the Business Intelligence potential Efficiently and effectively manage your project(s) and programs Work comfortably within Project Server 2013 or Project Online Getting Started with Microsoft® Project Server 2013 Describing the EPM context Discovering Project Server 2013 and Project Online Differentiating the users of Project Server 2013 Working with Project Professional 2013 and Project Server 2013 Recognizing the Life Cycle within EPM Projects and Portfolio Management Portfolio management and governance Originating new initiatives within EPTs and workflows Prioritizing initiatives, analyzing scenarios, optimizing, and selecting the portfolio Initiating Projects Initiating processes with Project Professional, SharePoint lists, Enterprise Projects, and Resource Plans Importing projects and managing project owner and permissions Planning Projects - Scope and Schedule Management Planning context and framework Scheduling in PWA Using the Deliverables feature Planning Projects - Staffing Management Plan Building a project team Managing resource availability Reviewing the assignment cycle Resolving resource overallocation Planning Projects - Cost Components, Baseline, and Consolidated Schedules Developing components of the Cost Management Planning processes Working with the baseline in projects and programs or master schedules Improving the Collaboration in the Project Sites Creating the Project Sites Developing components of the Risk Management Plan and Issues Tracking Linking planning documents Additional apps and customization Executing Projects Understanding executing processes Managing resources using Build Team and other features Working with timesheets Reporting administrative time Configuring personal settings Monitoring and Controlling Projects - Tracking Task and Project Progress Understanding the Monitoring and Controlling processes Task progress and updates in PWA including considerations for different tracking methods Task progress and updates in Project Professional 2013 Monitor and Control Projects - Measuring Performance and Reporting Progress Understanding status reports Reviewing performance metrics and progress reports Taking advantage of preloaded reports at the Business Intelligence Center Considerations for defining custom reports Closing Projects Reviewing the closing processes and closing tasks to updates Supporting the closing process

Microsoft Project Orange Belt® 2013: In-House Training This workshop gives participants a full insight into creating effective schedules using Microsoft® Project 2013, allowing you to estimate, coordinate, budget, staff, and control projects and support other users. This workshop gives participants a full insight into creating effective schedules using Microsoft® Project 2013, allowing you to estimate, coordinate, budget, staff, and control projects and support other users. This workshop provides the eBook Dynamic Scheduling with Microsoft® Project 2013, and is kept up to date with the framework of knowledge outlined by the Project Management Institute's PMBOK® Guide and the Practice Standard for Scheduling. What you Will Learn You'll learn how to: Understand what's new in Project 2013 Explain where Project 2013 fits in the Microsoft® EPM solution Initialize Project 2013 to start project planning Create a well-formed project schedule Understand task types and the schedule formula Assign resources and costs to tasks Analyze resource utilization and optimize the schedule Set a baseline and track progress Create and manage project reports Customize views and fields Apply Earned Value Management Understand the basics of managing multiple projects Getting Started Introductions Course structure Course goals and objectives Enterprise Project Management Concepts and Framework Getting Started with Project 2013 Project 2013: What's New and General Overview Setting Up a New Project Schedule (templates, options, save, etc.) Setting the Project Calendar Entering Tasks The Planning Processes Importing Tasks (Word, Excel, SharePoint) Synchronizing with SharePoint Tasks List Creating and managing the WBS (include tasks, manually scheduled tasks, summary tasks and milestones, as well as custom WBS coding) Entering Estimates Tendencies in Estimating The Rolling Wave Approach Entering Duration and Work Estimates Types of Tasks Entering Dependencies The Principle of Dynamic Scheduling Choosing the Right Type of Dependency Entering Dependencies in Project 2013 Different Applications of Dependencies Entering Deadlines, Constraints, and Task Calendars Use of Deadlines and Constraints Entering Deadlines and Constraints in Project 2013 Entering Resources and Costs Types of Resources Entering Resources in Project 2013 Calendars and Resources Entering Costs in Project 2013 Entering Assignments Assignments in a Schedule Assignments and Task Types Entering Assignments in Project 2013 Assignments, Budgets, and Costs Optimizing the Schedule The Critical Path Method and the Resource Critical Path Resource Leveling Optimizing Time, Cost, and Resources in Project 2013 Updating the Schedule The Baseline Updating Strategies and Situations Prepare the Status and Forecast Report in Project 2013 Reporting Using Reports Using Visual Reports Formatting and Printing in Project 2013 Customizing Fields in Project 2013 Earned Value Management (EVM) Overview of EVM Applying EVM with Project 2013 Evaluating the Project Evaluating the Project Performance Project Benefits and Results Templates for Future Projects Summary Tools and Checklist Best Practices Checklist Consolidated Schedules Creating Consolidated Schedules Using a Resource Pool Links across Projects Solving common problems Analyzing the Critical Path across Projects

Microsoft Project Orange Belt® 2016: In-House Training This workshop gives participants a full insight into creating effective schedules using Microsoft® Project 2016, allowing you to estimate, coordinate, budget, staff, and control projects and support other users. This workshop gives participants a full insight into creating effective schedules using Microsoft® Project 2016, allowing you to estimate, coordinate, budget, staff, and control projects and support other users. This workshop provides the eBook Dynamic Scheduling with Microsoft® Project 2013, and is kept up to date with the framework of knowledge outlined by the Project Management Institute's PMBOK® Guide and the Practice Standard for Scheduling. What you Will Learn You'll learn how to: Understand what's new in Project 2016 Explain where Project 2016 fits in the Microsoft® EPM solution Initialize Project 2016 to start project planning Create a well-formed project schedule Understand task types and the schedule formula Assign resources and costs to tasks Analyze resource utilization and optimize the schedule Set a baseline and track progress Create and manage project reports Customize views and fields Apply Earned Value Management Understand the basics of managing multiple projects Getting Started Introductions Course structure Course goals and objectives Concepts of Project Management Getting Started with Project 2016 Project 2016: What's New and General Overview Setting Up a New Project Schedule (templates, options, save, etc.) Setting the Project Calendar Entering Tasks The planning processes Importing tasks (Word, Excel, SharePoint) Synchronizing with SharePoint Tasks List Creating and managing the WBS (include tasks, manually scheduled tasks, summary tasks, milestones, and custom WBS coding) Entering Estimates Tendencies in estimating The rolling wave approach Entering duration and work estimates Types of tasks Entering Dependencies The principle of dynamic scheduling Choosing the right Type of dependency Entering dependencies in Project 2016 Different applications of dependencies Entering Deadlines, Constraints, and Task Calendars Use of deadlines and constraints Entering deadlines and constraints in Project 2016 Entering Resources and Costs Types of resources Entering resources in Project 2016 Calendars and resources Entering costs in Project 2016 Entering Assignments Assignments in a schedule Assignments and task types Entering assignments in Project 2016 Assignments, budgets, and costs Optimizing the Schedule The critical path method (CPM) and the resource critical path (RCP) Resource leveling Optimizing time, cost, and resources in Project 2016 Updating the Schedule The baseline Updating strategies and situations Prepare the status and forecast report in Project 2016 Reporting Using reports Using Visual Reports Formatting and printing in Project 2016 Customizing fields in Project 2016 Earned Value Management (EVM) Overview of EVM Applying EVM with Project 2016 Evaluating the Project Evaluating the project performance Project benefits and results Templates for future projects Summary and Next steps Tools and checklist Best practices checklist Certification options

This very practical workshop has a simple objective: to help you prepare, design and deliver memorable and high-quality presentations. This programme will help you: Use a proven, structured tool-kit when designing and developing presentations Benefit from short cuts and best practice when designing and using Powerpoint presentations Select the right information, examples, exercises and activities - and use them well Prepare and structure a presentation or session appropriate to the audience, and to best achieve your objectives Maintain audience or group interest Develop and practise presentation skills to improve your voice tone, speech power and body language Use practical methods to control nerves and anxiety - develop higher levels of confidence and credibility Command a room, hold attention and create a high impact 1 Introduction Personal objectives Key messages and learning objectives of the workshop 2 Presentation skills What does good look like? Exercise: Characteristics of high/low impact presentations Presenting yourself as a 'winner' The energy / attitude model Exercise: Being a winner 3 Preparation skills - eight steps to preparing a great presentation, plus Powerpoint tips •The magic circle• How to 'assume the role' when presenting• The eight steps• Step 1 - develop your objectives- The five questions that you must answer before preparing your presentation- Defining your objectives and outcomes- Creating a first draft- Step 1 exercise• Step 2 - analyse your audience- Doing your homework: audience, event, venue- Developing a pre-event check-list- Methods and means for researching your audience- Step 2 exercise• Steps 3 and 4 - structure the main body of your presentation and state the main ideas- Ways to structure your presentation for maximum impact- Balancing and managing content and topics- Organising your information: 6 options and methods- Your 'one main point' and creating a 30-second summary- Steps 3 and 4 exercises• Step 5 - decide on supporting information, using the toolkit- Making your case convincing: ways to support your claims- Selecting and using relevant and interesting examples- Quotes, case studies and printed material- Presenting statistics, tables and graphs- Ways of maintaining visual interest- Transitions and links, creating a 'golden thread'- Step 5 exercise: Creating compelling stories and anecdotes4• Step 6 - create an effective 'opening'- Claiming the stage and creating a good first impression- The three most powerful ways of opening a presentation- The five elements of a strong opening- Step 6 exercise: Participants work individually to prepare an opening, focusing onpersonal introduction, and then deliver to the group, with structured feedback• Step 7 - develop transitions- Step 7 exercise / examples• Step 8 - create an effective close- Signalling and sign-posting; the importance of, and how to do it effectively- Five ways to close a presentation successfully- Step 8 exercise / examples• Presentation design and Powerpoint- An interactive review of participants' own real-life past presentations and advanced tipsand techniques on using Powerpoint effectively 4 Facilitation skills The three main types of group activity - triads, teams and main group How to select the right activity, define the objectives, set it up and run the debrief Using energisers - with examples Exercise: Dealing with 'difficult' behaviours Exercise: Working in triads, design and deliver 5 Tips and tricks: presentation and facilitation 10 reasons why facilitation fails Five golden rules for success Defining the session goals and the facilitation plan Open and closed questions - why and when to use Using a 'car park' to manage unresolved issues Using AV aids - tips and tricks Exercises: Including participants working in pairs to prepare a short section form of one of their own presentations 6 Putting it all together Summary of key learning points Action plan