1400 Objective courses in Liverpool delivered Live Online

Course Objectives At the end of this course you will be able to: Do advance Table design Do advance Query design and Action Querys Do advance Form design with the use of macros and buttons Export and import data to and from different sources. 1 year email support service Take a look at the consistent excellent feedback from our 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. Advanced Table Design Advanced Field Properties Table Properties Advanced Query Design Advanced Naming Conventions Join Tables in Queries Manage Query Joins Use Self-Joins in Queries Summarise Data in Queries Parameter Queries Action Queries Crosstab Queries Advanced Form Design Create Subforms and Linked Forms Form Controls Command Buttons Form Properties Interface, Start-Up and Navigations Forms Working with Macros Create Single Macros Run Macros Work with Sub Macros Use Conditional Macros Run Macros from Buttons Assign Macros to Events Extending Data Reach Import Data Export Data Work with Linked Tables Managing Databases Object Dependencies Database Documenter Performance Analyzers Regular Management of a Database Access Database Security Who is this course for? Who is this course for? The course is aimed at all users who would like to obtain the necessary skills to create advanced table, query, form and reports as well as to automate tasks with the use of macros. 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

This course will allow you to explore the potential of self-service business intelligence using Power BI Desktop to analyse and connect to different sources of data, creating Relationships between those different datasets, Query the data using Shaping and data Modelling, to create Visualizations, and publish Reports to different platforms . Course Objectives At the end of this course you will be able to: Connect to data from different sources. Use the Query Editor Perform Power BI desktop data Shaping and Transformation. Create Power BI desktop Modelling. Create Power BI desktop Visualizations and Reports. ' 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 and Business Intelligence. 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. Introduction to Power BI Power BI Jargon explained A quick look at Power BI Desktop A quick look at the Power BI service Helpful resources Power BI and Excel Introduction to using Excel data in Power BI Upload Excel data to Power BI Import Power View and Power Pivot to Power BI Getting started with Power BI Desktop Overview of Power BI Desktop Accessing Help and Helpful resources Connect to data sources in Power BI Desktop Shaping and Transforming Data with Query Editor Introduction to the Query Editor Data Sources Power BI Desktop can Connect to Introduction to Steps and M code Combining Data Using Merge and Append Queries Data Type Properties Working with Delimiters Clean and transform your data with the Query Editor Text Specific Transformation Tools Number Specific Transformation Tools Date Specific Transformation Tools Split and Merge columns Creating an Index Column Adding Conditional Columns Columns From Examples Grouping and Aggregating data Pivoting and Unpivoting Using filters Modeling the data Introduction to modeling your data How to manage your data relationships Create calculated columns Optimizing data models Create calculated measures Show Values As and Quick Measures Create calculated tables Explore your time-based data Introduction to DAX DAX calculation types DAX functions Visualizations Introduction to visuals in Power BI Create and customize simple visualizations Modify colors in charts and visuals Shapes, text boxes, and images Page layout and formatting Group interactions among visualizations Visual hierarchies and drill-down Using custom visualizations Create a KPI Visualization Geo-Data and Maps Reports, Publishing and Sharing Introduction to the Power BI service Quick insights in Power BI Create and configure a dashboard Ask questions of your data with natural language Create custom Q&A suggestions Share dashboards with your organization Introduction to content packs, security, and groups Publish Power BI Desktop reports Print and export dashboards and reports Create groups in Power BI Use content packs Update content packs Publish to web Who is this course for? Who is this course for? This course facilitates you with knowledge on the potential for Power BI Desktop to analyse and connect to different sources of data, creating Relationships between those different datasets, Query the data using Shaping and data Modelling, and to create Visualizations, and publish Reports to different platforms. Requirements Requirements Before attending this course, delegates should have: - A general knowledge of database concepts (fields, records and relationships) - Familiarity with Excel. Career path Career path Business Intelligence Data Analysis ETL & Data Warehousing

Duration 1 Days 6 CPD hours This course is intended for This course is intended for individuals who want to become more rational and disciplined thinkers. Overview Upon successful completion of this course, students will boost their performance with an increase in their decision-making ability. In this course, students will learn develop their ability to analyze and evaluate information. 1 - GETTING STARTED Icebreaker Housekeeping Items The Parking Lot Workshop Objectives 2 - COMPONENTS OF CRITICAL THINKING Applying Reason Open Mindedness Analysis Logic Case Study 3 - NON-LINEAR THINKING Step Out of Your Comfort Zone Don't Jump to Conclusions Expect and Initiate Change Being Ready to Adapt Case Study 4 - LOGICAL THINKING Ask the Right Questions Organize the Data Evaluate the Information Draw Conclusions Case Study 5 - CRITICAL THINKERS (I) Active Listening Be Curious Be Disciplined Be Humble Case Study 6 - CRITICAL THINKERS (II) Seeing the Big Picture Objectivity Using Your Emotions Being Self-Aware Case Study 7 - EVALUATE INFORMATION Making Assumptions Watch out for Bias Ask Clarifying Questions SWOT Analysis Case Study 8 - BENEFITS OF CRITICAL THINKING Being More Persuasive Better Communication Better Problem Solving Increased Emotional Intelligence Case Study 9 - CHANGING YOUR PERSPECTIVE Limitations of Your Point of View Considering Others Viewpoint Influences on Bias When New Information Arrives Case Study 10 - PROBLEM SOLVING Identify Inconsistencies Trust Your Instincts Asking Why? Evaluate the Solution(s) Case Study 11 - PUTTING IT ALL TOGETHER Retaining Your New Skills Reflect and Learn From Mistakes Always Ask Questions Practicing Critical Thinking Case Study 12 - WRAPPING UP Words from the Wise Review of Parking Lot Lessons Learned Completion of Action Plans and Evaluations

Duration 1 Days 6 CPD hours This course is intended for This course is intended for individuals who desire to supervise others more effectively. Overview Upon successful completion of this course, students will be equipped to supervise others more effectively and efficiently, contributing to job satisfaction and productivity. In this course, students will develop the skills required to be more efficient and proficient supervisors. 1 - GETTING STARTED Icebreaker Housekeeping Items The Parking Lot Workshop Objectives 2 - SETTING EXPECTATIONS Defining the Requirements Identifying Opportunities for Improvement and Growth Setting Verbal Expectations Putting Expectations in Writing 3 - SETTING GOALS Understanding Cascading Goals The SMART Way Helping Others Set Goals 4 - ASSIGNING WORK General Principles The Dictatorial Approach The Apple-Picking Approach The Collaborative Approach 5 - DEGREES OF DELEGATION Level One: Complete Supervision Level Two: Partial Supervision Level Three: Complete Independence 6 - IMPLEMENT DELEGATION Deciding to Delegate To Whom Should You Delegate? Providing Instructions Monitoring the Results Troubleshooting Delegation 7 - PROVIDING FEEDBACK Characteristics of Good Feedback Feedback Delivery Tools Informal Feedback Formal Feedback 8 - MANAGING YOUR TIME The 80/20 Rule Prioritizing with the Urgent-Important Matrix Using a Productivity Journal Using Routines and Rituals to Simplify Your Workday 9 - RESOLVING CONFLICT Using a conflict Resolution Process Maintaining Fairness Seeking help from Within the Team Seeking Help for Outside the Team 10 - TIPS FOR SPECIAL SITUATIONS What to Do If You?ve Been Promoted from within the Team What to Do If You're Leading a Brand New Team What to Do if You're Taking on an Established Team 11 - A SURVIVAL GUIDE FOR THE NEW SUPERVISOR Ask the Right Questions of the Right People Go to Gemba Keep Learning 12 - WRAPPING UP Words from the Wise Review of Parking Lot Lessons Learned Completion of Action Plans and Evaluations

Duration 1 Days 6 CPD hours Overview You will spend the first part of the day getting to know participants and discussing what will take place during the workshop. Students will also have an opportunity to identify their personal learning objectives. Many of us flinch when we hear terms like depreciation, cash flow, balance sheet, and (worst of all!) budgets. However, these are all important concepts to understand if you?re going to succeed in today?s business world, particularly as a supervisor. Even better, financial terms are not as scary as they seem. 1 - Getting the Facts Straight The first session will go over basic financial terms Explore their role in company finances Governing organizations in their area. 2 - The Accounting Cycle Four phases of the accounting cycle Key concepts: cash vs. accrual methods 3 - The Key Reports Take a close look at balance sheets and income statements Review cash flow statements and statements of retained earnings 4 - Keeping Score Explain the chart of accounts and single vs. double entry accounting. 5 - A Review of Financial Terms Introduction to some additional financial terms. 6 - Understanding Debits and Credits De-mystify accounting terms: debits and credits. 7 - Your Financial Analysis Toolbox Sources for financial data Tips on weeding out useless information Calculate common ratios Read an annual report, and some useful decision-making tools. 8 - Identifying High and Low Risk Companies Guidelines for identifying high and low risk companies. 9 - The Basics of Budgeting What is a budget? How a budget fits into the big picture The budgeting process 10 - Working Smarter Basic checklist of computer skills required for success How to choose an accounting package 11 - People and Numbers Dealing with finances Expense Reports Making cuts to someone?s pay? Provide tips on what to do. Additional course details: Nexus Humans Accounting Essentials 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 Accounting Essentials 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 For the better part of every day, we are communicating to and with others. Whether it?s the speech you deliver in the boardroom, the level of attention you give your spouse when they are talking to you, or the look you give the cat, it all means something. This workshop will help participants understand the different methods of communication and how to make the most of each of them. 1 - Getting Started Icebreaker Housekeeping Items The Parking Lot Workshop Objectives 2 - The Big Picture What is Communication? How Do We Communicate? Other Factors in Communication 3 - Understanding Communication Barriers An Overview of Common Barriers Language Barriers Cultural Barriers Differences in Time and Place 4 - Paraverbal Communication Skills The Power of Pitch The Truth about Tone The Strength of Speed 5 - Non-Verbal Communication Understanding the Mehrabian Study All About Body Language Interpreting Gestures 6 - Speaking Like a STAR S = Situation T = Task A = Action R = Result Summary 7 - Listening Skills Seven Ways to Listen Better Today Understanding Active Listening Sending Good Signals to Others 8 - Asking Good Questions Open Questions Closed Questions Probing Questions 9 - Appreciative Inquiry The Purpose of AI The Four Stages Examples and Case Studies 10 - Mastering the Art of Conversation Level One: Discussing General Topics Level Two: Sharing Ideas and Perspectives Level Three: Sharing Personal Experiences Our Top Networking Tips 11 - Advanced Communication Skills Understanding Precipitating Factors Establishing Common Ground Using ?I? Messages 12 - Wrapping Up Words from the Wise Review of Parking Lot Lessons Learned Completion of Action Plans and Evaluations Additional course details: Nexus Humans Communication Strategies 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 Communication Strategies 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 Overview Students will come away with knowledge and skills to become a top-notch team performer. This workshop will encourage you to explore the different aspects of a team, as well as ways that they can become a top-notch team performer. 1 - GETTING STARTED Icebreaker Housekeeping Items The Parking Lot Workshop Objectives 2 - DEFINING SUCCESS What is a Team? An Overview of Tuckman and Jensen's Four-Phase Model 3 - TYPES OF TEAMS The Traditional Team Self-Directed Teams E-Teams 4 - THE FIRST STAGE OF TEAM DEVELOPMENT-FORMING Hallmarks of This Stage What To Do As A Leader What To Do As A Follower 5 - THE SECOND STAGE OF TEAM DEVELOPMENT-STORMING The Hallmarks of This Stage What To Do As A Leader What To Do As A Follower 6 - THE THIRD STAGE OF TEAM DEVELOPMENT-NORMING The Hallmarks of This Stage What To Do As A Leader What To Do As A Follower 7 - THE FOURTH STAGE OF TEAM DEVELOPMENT-PERFORMING Hallmarks of This Stage What To Do As A Leader What To Do As A Follower 8 - TEAM BUILDING ACTIVITIES The Benefits and Disadvantages Team-Building Activities That Won't Make People Cringe Choosing a Location for Team-Building 9 - MAKING THE MOST OF TEAM MEETINGS Setting the Time and Place Trying the 50-Minute Meeting Using Celebrations of All Sizes 10 - SOLVING PROBLEMS AS A TEAM The Six Thinking Hats Encouraging Brainstorming Building Consensus 11 - ENCOURAGING TEAMWORK Some Things to Do Some Things to Avoid Some Things to Consider 12 - WRAPPING UP Words from the Wise Review of Parking Lot Lessons Learned Completion of Action Plans Additional course details: Nexus Humans Teamwork and Team Building 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 Teamwork and Team Building 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 new managers, especially those with direct reports, who are responsible for increasing employee motivation and job performance. This course will assist students in understanding and implementing strategies that will help to motivate their work force. 1 - Getting Started Workshop Objectives Pre-Assignment Review 2 - A Psychological Approach Herzberg?s Theory of Motivation Maslow?s Hierarchy of Needs The Two Models and Motivation Case Study Module Two: Review Questions 3 - Object-Oriented Theory The Carrot The Whip The Plant Case Study Module Three: Review Questions 4 - Using Reinforcement Theory A History of Reinforcement Theory Behavior Modification in Four Steps Appropriate Uses in the Workplace Case Study Module Four: Review Questions 5 - Using Expectancy Theory A History of Expectancy Theory Understanding the Three Factors Using the Three Factors to Motivate in the Workplace Case Study Module Five: Review Questions 6 - Personality's Role in Motivation Identifying Your Personality Type Identifying Others? Personality Type Motivators by Personality Type Case Study Module Six: Review Questions 7 - Setting Goals Goals and Motivation Setting SMART Goal Evaluating and Adapting Case Study Module Seven: Review Questions 8 - A Personal Toolbox Building Your Own Motivational Plan Encouraging Growth and Development Getting Others to See the Glass Half-Full Case Study Module Eight: Review Questions 9 - Motivation on the Job The Key Factors Creating a Motivational Organization Creating a Motivational Job Case Study Module Nine: Review Questions 10 - Addressing Specific Morale Issues Dealing with Individual Morale Problems Addressing Team Morale What to Do When the Whole Company is De-Motivated Case Study Module Ten: Review Questions 11 - Keeping Yourself Motivated Identifying Personal Motivators Maximizing Your Motivators Evaluating and Adapting Case Study Module Eleven: Review Questions 12 - Wrapping Up Words from the Wise Additional course details: Nexus Humans Employee Motivation 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 Employee Motivation 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 designed for individuals who need to present information effectively in a professional environment. Overview This program can benefit anyone who presents; a trainer, a meeting facilitator, speaker, or seminar discussion leader. No matter which role you are assuming, this workshop will help you become more efficient and proficient with the skills of providing information to others. In this course, students will learn active listening skills to facilitate the exchange of ideas in meetings and presentations. They will also organize your ideas to create coherent and convincing oral presentations. Getting Started Icebreaker Housekeeping Items The Parking Lot Workshop Objectives Creating the Program Performing a Needs Analysis Writing the Basic Outline Researching, Writing, and Editing Choosing Your Delivery Methods Basic Methods Advanced Methods Basic Criteria to Consider Verbal Communication Skills Listening and Hearing: They Aren?t the Same Thing Asking Questions Communicating with Power Non-Verbal Communication Skills Body Language It?s Not What You Say, it?s How You Say It Overcoming Nervousness Preparing Mentally Physical Relaxation Techniques Appearing Confident in Front of the Crowd Creating Fantastic Flip Charts Required Tools The Advantages of Pre-Writing Using Colors Appropriately Creating a Plan B Creating Compelling PowerPoint Presentations Required Tools Tips and Tricks Creating a Plan B Wow 'Em with the Whiteboard Traditional and Electronic Whiteboards Using Colors Appropriately Creating a Plan B Vibrant Videos and Amazing Audio Required Tools Tips and Tricks Creating a Plan B Pumping it Up a Notch Make Them Laugh a Little Encourage Discussion Dealing with Questions Wrapping Up Words from the Wise Review of Parking Lot Lessons Learned Completion of Action Plans and Evaluations Additional course details: Nexus Humans Presentation Skills 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 Presentation Skills 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 individuals who want to develop a core set of soft skill. Overview Upon successful completion of this course, students will be able to better interact and communicate in the workplace. In this course, students will develop a core set of soft skills by managing and looking at the way people interact and seeing things in a new light. 1 - GETTING STARTED Housekeeping Items Pre-Assignment Review Workshop Objectives The Parking Lot Action Plan 2 - WHAT ARE SOFT SKILLS? Definition of Soft Skills Empathy and the Emotional Intelligence Quotient Professionalism Learned vs. Inborn Traits 3 - SOFT SKILL 1: COMMUNICATION Ways We Communicate Improving Non-Verbal Communication Listening Openness and Honesty 4 - SOFT SKILL 2: TEAMWORK Identifying Capabilities Get Into Your Role Learn the Whole Process The Power of Flow 5 - SOFT SKILL 3: PROBLEM SOLVING Define the Problem Generate Alternative Solutions Evaluate the Plans Implementation and Re-evaluation 6 - SOFT SKILL 4: TIME MANAGEMENT The Art of Scheduling Prioritizing Managing Distractions The Multitasking Myth 7 - SOFT SKILL 5 AND 6: ATTITUDE AND WORK ETHIC What Are You Working For? Caring for Others vs. Self Building Trust Work Is Its Own Reward 8 - SOFT SKILL 7: ADAPTABILITY/FLEXIBILITY Getting over the Good Old Days Syndrome Changing to Manage Process Changing to Manage People Showing You're Worth Your Weight in Adaptability 9 - SOFT SKILL 8: SELF-CONFIDENCE Confident Traits Self-Questionnaire Surefire Confidence Building Tactics Build Up Others 10 - SOFT SKILL 9: ABILITY TO LEARN FROM CRITICISM Wow, You Mean I'm Not Perfect? Listen With An Open Mind Analyze and Learn Clear the Air and Don't Hold Any Grudges 11 - SOFT SKILL 10: NETWORKING Redefining Need Identifying Others' Interests Reaching Out When to Back Off 12 - WRAPPING UP Words From The Wise Review Of The Parking Lot Lessons Learned Recommended Reading Completion Of Action Plans And Evaluations Additional course details: Nexus Humans 10 Soft Skills You Need 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 10 Soft Skills You Need 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.