10885 Concept courses

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 course Tailored training courses: in in company training, 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 Visualisations, 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

Practical MySQL Course Intermediate, to leave you fully conversant with queries, DML and DDL statements. Hands-on, Practical MySQL Course Intermediate. PCWorkshops MySQL Course Intermediate Certificate. Max 4 people per course, we keep it personalised.

Course Objectives At the end of this course you will be able to: Record and edit a Macro Assign macros to keyboard shortcuts, Quick Access Toolbar, Buttons and Shape objects. Use the Visual Basic Editor; change the properties of an object; add a module to a project; write the code for a procedure and then run it; and use the Object Browser to search procedures Manipulate data by declaring variables of different data types; combine data by using expressions; use functions to accept input and display output; and declare variables and procedures with the appropriate scope Use decision structures to create procedures that make decisions; and use loop structures to perform repetitive tasks Create an error handling routine in case things go wrong with VBA code ' 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 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 trainer was very knowledgeable, kept everyone involved and was enthusiastic. A great experience.. Simon Harper - Lloyd's of London My learning experience was awesome. Perdinand Reagan - Subsea7 Very nice and relaxed approach to teaching. Was definitely a good learning experience. Jerome Pupe - S5 Agency World The Trainer – Very positive + patient + helpful + thorough Agnes Souza - Direct Wines ' 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 Macros and VBA Introducing Visual Basic for Applications Recording a Macro Naming conventions for Macro Procedures Running a Macro Absolute or Relative Cell Referencing Saving and Opening Files with Macros Making macros always available Adding Macros to Keyboard Shortcuts, Quick Access Toolbar, Buttons and Shapes Editing a Macro in the Visual Basic Editor Understanding the Development Environment Customising the Editor Tips for General Typing in VBA Using Visual Basic Help Working with Procedures Program Design Understanding Modules Naming Rules Creating a Module Understanding Procedures Programming Macro Concepts Creating a Subroutine Creating a Function Understanding Arguments Exiting Procedures Calling Procedures Objects, Properties, Methods and Events Understanding Objects Properties, Methods, and Events Navigating the Object Hierarchy Understanding Collections Accessing a Member of a Collection Understanding Hierarchy Using the Object Browser Using the With Statement Working with Properties Working with Methods Creating an Event Procedure Reserved Macro Names Using Expressions, Variables and Intrinsic Functions Understanding Expressions and Statements Declaring Variables Understanding Data Types Determining the Value of Variables Working with Variable Scope Using Built-in VBA Functions Understanding Constants Using Message Boxes Controlling the Answer to a Message Box Using Input Boxes Declaring and Using Object Variables Controlling Program Execution Understanding Control-of-Flow Structures Using the If...End If Decision Structures Nested If Statements Using the Select Case ... End Select Structure Using the Do ... Loop Structure Using the For ... Next Structure Using the For Each ... Next Structure Guidelines for Use of Control-of-Flow Structures Debugging and Handling Errors Understanding Errors Using Debugging Tools Setting Breakpoints and Using Break Mode Stepping Through Code Trapping Errors with the On Error Statement Understanding the Err Object Working with Inline Error Handling Writing an Error-Handling Routine Working with Forms and Controls Understanding UserForms Creating a Form Displaying and Removing a Form Aligning and Sizing Controls Using the Toolbox Working with a Form's Properties, Methods, and Events Working with Form and Control Properties, Methods and Event Setting the Tab Order Populating a Control Who is this course for? Who is this course for? This course is designed to give proficiency in the Visual Basic Editor (VBE), predominantly making use of Excel objects, understanding Object's Properties, Events and Methods, basic VBA Object oriented programming, event handling, control structures, and debugging tools. Requirements Requirements Preferably, delegates should have attended the Excel Advanced course. Certificates Certificates Certificate of completion Digital certificate - Included

The Microsoft Office Specialist (MOS) is a globally recognised qualification. Having a Microsoft Office Specialist certification on your CV demonstrates that you have gained the necessary expertise to competently use Microsoft applications, giving you a competitive advantage when job hunting as well as in the workplace. It will significantly increase your confidence, skills and employability. It will serve to objectively validate your IT skills and assist in your advancement in your chosen career.

Become a successful certified HR Assistant with this comprehensive Certified Diploma in HR Assistant course. This course is designed for those aspiring individuals or professionals who want to gain hr assistant skills to build their successful career in the Human resource management field. In this HR assistant course you will learn the procedures of attracting and retaining employees, the proper ways of training and development, and the legal environment of HRM. Apart from these, you will gain information related to contemporary motivation theory and techniques and teamwork. The course starts with the basic HR concepts and the exact ways of recruitment which includes how to select the perfect employee, the appropriate system of orientation and the strategy of developing personal and professional development. After that, you will learn how to motivate the employee through different motivational techniques, how to praise them or how to make constructive criticism. Finally, you will learn how to do teamwork. After successful completion of this course you will gain a complete idea about HR management, and can successfully implement HR strategies and key concepts in real life to enhance the business operation through effective HR management. Course Highlights The price is for the whole course including final exam - no hidden fees Accredited Certificate upon successful completion at an additional cost Efficient exam system with instant results Track progress within own personal learning portal 24/7 customer support via live chat Certified Diploma in HR Assistant has been given CPD accreditation and is one of the best-selling courses available to students worldwide. This valuable course is suitable for anyone interested in working in this sector or who simply wants to learn more about the topic. If you're an individual looking to excel within this field then Certified Diploma in HR Assistant is for you. We've taken this comprehensive course and broken it down into several manageable modules which we believe will assist you to easily grasp each concept - from the fundamental to the most advanced aspects of the course. It really is a sure pathway to success. All our courses offer 12 months access and are designed to be studied at your own pace so you can take as much or as little time as you need to complete and gain the full CPD accredited qualification. And, there are no hidden fees or exam charges. We pride ourselves on having friendly and experienced instructors who provide full weekday support and are ready to help with any of your queries. So, if you need help, just drop them an email and await a speedy response. Furthermore, you can check the validity of your qualification and verify your certification on our website at anytime. So, why not improve your chances of gaining professional skills and better earning potential. Assessment and Certification At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful. After you have successfully passed the final exam, you will be able to order an Accredited Certificate of Achievement at an additional cost of £19 for a PDF copy and £29 for an original print copy sent to you by post or for both £39. Career Path Not only does our CPD and CiQ accredited course look good on your CV, setting you apart from the competition, it can be used as a stepping stone to greater things. Further advance your learning, launch a new career or reinvigorate an existing one. On successful completion of this course, you have the potential to achieve an estimated salary of £22,000. The sky really is the limit. Course Curriculum Human Resources Assistant Introduction Human Resources Assistant 00:10:00 Potential Careers 00:05:00 Attracting and Retaining Employees HRM Overview 00:13:00 Forecasting Demand 00:10:00 Cultural Diversity 00:11:00 Diversity Survey 00:09:00 Recruiting, Selection, and Orientation Job Analysis 00:10:00 Application 00:20:00 Bad Resume 00:05:00 Good Resume 00:12:00 Cover Letter 00:10:00 Selection 00:11:00 Form I-9 00:17:00 Form W-9 00:07:00 Form W-4 00:10:00 Form 1095-B 00:07:00 Compensation and Benefits 00:17:00 Training and Development Personal and Professional Development 00:14:00 Training Evaluation Form 00:12:00 Performance Appraisal Performance Appraisal 00:19:00 Appraisal 00:14:00 Legal Environment of HRM National Labor Relations Act 00:12:00 Labor-Management Relations Act 00:14:00 Occupational Safety and Health Act 00:13:00 Motivating Employees Motivation 00:17:00 Physiological Needs 00:16:00 Motivation-Hygiene Theory 00:12:00 Firm Characteristics 00:22:00 Contemporary Motivation Theory Weakness of Maslow and Herzberg's Theories 00:18:00 Expectancy Theory 00:13:00 Motivation Techniques Management by Objectives 00:17:00 Behavior Modification 00:19:00 Telecommuting 00:20:00 Teams and Teamwork What is a Team? 00:09:00 Stages of Development 00:06:00 Team Cohesiveness 00:09:00 Mock Exam Mock Exam- Certified Diploma in HR Assistant 00:20:00 Final Exam Final Exam- Certified Diploma in HR Assistant 00:20:00

Who is this Course for? Mastering Unity 3D Intermediate Level Training Course Our Unity 3D training programs are tailored for individuals aspiring to become game developers, creative minds, & enthusiasts keen to explore the realm of game development. Learn 3D & 2D games or looking to master Unity's cross-platform features. Click here for more info: Website Duration: 20 hours Approach: 1-on-1 Individualized Attention & Customized Content Timetable: Scheduling any hour between 9 am and 7 pm, from Mon to Sat Course Overview: Sessions 1-2: Introduction to Unity Familiarize yourself with Unity's interface and workspace Create a new Unity project and set up the initial scene and navigation Sessions 3-4: Asset Management Explore and download free assets Import various asset types into Unity and understand their applications Sessions 5-6: Environmental Design Utilize Unity's terrain tools for environment creation Enhance scenes with textures, materials, and environmental objects Sessions 7-8: Character Development Design 3D character models Rig, animate, and import characters into Unity Sessions 9-10: Player Interaction Set up player controls and script basic movements Implement camera controls for seamless gameplay experiences Sessions 11-12: Physics and Realism Understand and implement physics in Unity Configure collisions, gravity, force, and torque for realistic interactions Sessions 13-14: Audio Enhancement Master audio implementation with sound effects and background music Fine-tune volume and pitch for immersive gameplay Sessions 15-16: Lighting and Visual Effects Employ advanced lighting techniques, including dynamic day-night cycles Enhance visuals with lens flares and particle systems Sessions 17-18: User Interface Design Construct user interfaces using Unity's canvas system Integrate interactive elements such as buttons and menus, ensuring smooth functionality Sessions 19-20: Optimization and Performance Implement optimization techniques and utilize the profiler for performance analysis Improve frame rates and reduce memory usage for seamless gameplay Session 21-22: Multiplayer Integration Explore multiplayer implementation and set up local multiplayer games Session 23-24: Mobile Game Development Discover mobile game development in Unity Build, deploy, and optimize games for mobile devices, focusing on performance and controls Session 25: Advanced Topics Delve into advanced scripting techniques, including coroutines, delegates, and events Explore shader programming and visual effects, and venture into VR development with Unity and Oculus Quest Final Project: Create a Comprehensive Game Test the game thoroughly, identify and resolve bugs Make necessary adjustments and improvements for a polished final product Experience the Real-Time Development Platform: Unleash your creativity and create 3D, 2D, VR, and AR experiences across various industries, including games, automotive, AEC, film, and more. Unity Pro offers a complete solution to develop better, iterate faster, and grow your business. Enjoy amazing games and immersive experiences with multi-platform support. Get started today: Unity Pro. Learning Outcomes: Participants will gain expertise in Unity 3D, mastering asset management, environmental design, character animation, player interaction, physics, audio, lighting, UI, optimization, and advanced scripting. They will develop a complete game, honing skills in debugging and project completion. Career Opportunities: Graduates can pursue roles as Game Developers, Mobile Game Developers, VR/AR Developers, Game Designers, UI/UX Designers, Game Testers, Indie Game Developers, Educational Game Developers, Freelance Developers, or Game Development Instructors, leveraging their Unity 3D skills for diverse and exciting career paths in the gaming industry. Skills Acquired: Participants in the Mastering Unity 3D Intermediate Level Training Course will gain advanced proficiency in Unity 3D game development, including: Advanced 3D Game Development Techniques Real-time Physics and Animation Skills Multiplatform Game Deployment Expertise Job Opportunities: Upon completion, individuals can pursue roles such as: Game Developer Unity 3D Programmer AR/VR Developer Interactive Simulation Designer This course equips participants with the expertise required for exciting opportunities in game development studios, AR/VR companies, and interactive media agencies, setting the stage for a successful career in the gaming and simulation industry. Course Advantages: Comprehensive Unity Mastery: Develop expertise in various Unity aspects, including game design, scripting, animation, and optimization. Hands-On Project Experience: Engage in practical projects mirroring real-world game development, enhancing your skills and portfolio. Interactive Live Instruction: Learn from experienced instructors in real-time, encouraging interactive discussions, Q&A sessions, and personalized guidance. Flexible Learning Paths: Opt for in-person or online classes, ensuring accessible and convenient learning tailored to your needs. Lesson Revisions: Access recorded lessons, allowing flexible review and reinforcement of concepts at your own pace. Lifetime Email Support: Benefit from ongoing support via email, where experts are available to assist with any questions or challenges, even after the course concludes.

Face to face training customised and bespoke. Online or Face to Face

Mental Health "First Aid" Training

Effective report writing, the exchange of information, ideas, opinions and decisions between people at all levels, internally and externally, makes a vital contribution to organisational success.

Course Overview The Interior Design Diploma offers an insightful exploration of the key principles, styles, and elements that shape interior spaces. This course is designed to equip learners with the foundational knowledge required to understand and apply interior design concepts. Learners will explore various design styles, colour theory, space planning, and materials used in interior design, empowering them to create aesthetically pleasing and functional spaces. By the end of this course, learners will have developed a comprehensive understanding of interior design that can be applied in various contexts, whether residential, commercial, or hospitality design. Course Description Throughout the Interior Design Diploma, learners will delve into a wide range of topics including popular interior design styles, design principles, colour theory, space planning, and the use of textiles and fabrics. The course is structured to provide learners with a solid understanding of how to approach interior design projects from concept to completion. Learners will gain skills in creating visually appealing and functional spaces that align with client needs and preferences. They will also explore how to stage and style interiors, ensuring spaces are both attractive and practical. By the end of the course, learners will have the expertise to design effective interior spaces across multiple design sectors. Course Modules Module 01: Popular Interior Design Styles and How to Use Them Module 02: Design Principles and Elements in Interiors Module 03: Introduction to Colour in Interiors Module 04: Introduction to Space Planning in Interiors Module 05: Textiles and Fabrics for Interiors Module 06: Styling and Staging Interior Spaces (See full curriculum) Who is this course for? Individuals seeking to develop a career in interior design. Professionals aiming to expand their design knowledge and skills. Beginners with an interest in creating beautiful and functional interiors. Anyone looking to transform their personal or professional space. Career Path Interior Designer Residential Designer Commercial Space Planner Event Designer Property Staging Specialist Set Designer