6119 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

OverviewDon't be left behind in the world of Project Management. Learn to embrace Agile principles and software and lead the pack. This certificated Agile Practitioner Level 2course will tutor you in the expert use of Agile practises and learn how to harness the collective power of your team. If you are confused by the use or terminology of Kanban and Waterfall, this course delivers all of the training that you'll need to incorporate their methodologies into your working routines. By adopting these proven Project Management philosophies, you will rapidly see a change in your department's productivity and work ethics. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is this course for?There is no experience or previous qualifications required for enrolment on this Agile Practitioner Level 2. It is available to all students, of all academic backgrounds.RequirementsOur Agile Practitioner Level 2 is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible on tablets and smartphones so you can access your course on wifi, 3G or 4G.There is no time limit for completing this course, it can be studied in your own time at your own pace.Career pathHaving these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management , Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 7 sections • 28 lectures • 03:18:00 total length •Course Introduction: 00:11:00 •Agile Overview: 00:01:00 •Intro to Agile: 00:11:00 •The Agile Manifesto: 00:17:00 •Domains of Agile Practices: 00:16:00 •Summary: 00:02:00 •Understanding Lean Software Development: 00:01:00 •Lean Origins and Principles: 00:23:00 •Summary: 00:02:00 •Understanding Kanban: 00:01:00 •Kanban Origins: 00:09:00 •Six Core Practices of Kanban: 00:11:00 •Summary: 00:02:00 •Introduction to Scrum: 00:01:00 •Scrum Overview: 00:10:00 •Scrum Concepts and Principles: 00:14:00 •Scrum Processes: 00:06:00 •Summary: 00:01:00 •Understanding XP Software Development: 00:01:00 •Intro to Extreme Programming (XP): 00:10:00 •Extreme Programming (XP) Practices and Adoption: 00:07:00 •Summary: 00:02:00 •Other Agile Models: 00:01:00 •DSDM: 00:11:00 •Crystal: 00:06:00 •Feature Driven Development: 00:07:00 •Comparing Agile Methods: 00:09:00 •Summary: 00:05:00

Hone your operational leadership skills and ensure a streamlined business process to increase productivity. Gain mastery of Negotiation Techniques, Supply Chain Management.

Microsoft Excel® in Depth: Virtual In-House Training The goal of this course is to provide a deeper understanding of Excel and its intricacies and a new ability to use it efficiently producing the best solutions for your projects. This practical course provides a solid background of the features of Excel and a deeper understanding of its features, benefits and uses. This is not a beginner's course in Excel. You will learn some advanced features such as Pivot Tables, Charting, Tables, Sorting, Filtering and Functions. The goal of this course is to provide a deeper understanding of Excel and its intricacies and a new ability to use it efficiently producing the best solutions for your projects. What you Will Learn You'll learn how to: Use functions like IF, AVERAGE, SUMIF, SUMIFS, SUMPRODUCT, INDEX, MATCH, CHOOSE, DATE, and many more Create meaningful charts Use pivot tables Use Conditional Formatting, Data Validation Take advantage of using Named ranges, do sorting, filtering, tables Getting Started The building blocks of Excel, built-in functions, will be examined The basics of formatting your data will be examined Shortcuts and data manipulation will be explored Built-in features like those mentioned in the 'What you will learn' section above will be explored in detail Excel Functions - VLOOKUP, IF, INDEX, MATCH, CHOOSE, SUMIF, SUMIFS, SUMPRODUCT, DATE, so many more Using Named ranges, Data Validation, Sorting, and Filtering Learn the Name manager; Learn the difference between local and global names; Ensure correct access to linked workbooks; Ensure data accuracy; Learn how to use cascading data validation (for example, once a user chooses 'cars', another cell allows only Ford, Toyota, etc.); Sorting by more than 3 fields; Filtering by font, pattern, or value; See your data based on things like dates in the 3rd quarter, or fields where quantity x price is greater than some fixed value Conditional formatting and data formatting Make relevant data stand out Isolate highs and lows Make error cells invisible Learn about Data bars, Icon sets, and Color scales Highlight differences between worksheets Learn all the codes in the Format/Number list Using cell Styles Learn all about alignment, protection, borders, colors and more Pivot Tables Learn how to summarize large amounts of data with a few clicks Learn various ways of presenting the data Learn the various pivot table tools Learn how to customize and format a pivot table to suit your needs Learn how to group data Learn how to use the various options to present your data Charts Learn how to create a chart with one keystroke! Learn the 11 types of built-in charts Learn how to create a chart with one keystroke! Learn how to customize the charts to make the information tell the right story Learn how to use the design, layout, and formatting available to charts in Excel 2007 Learn embedded charts versus chart sheets Learn how to use modify all the pieces of a chart Array formulas Learn how to use the most powerful formulas in Excel Learn how to combine many formulas into one compact array-formula Learn the real power of these formulas and why regular formulas can't do the job Learn how to use built-in array formulas, like TREND or TRANSPOSE

This course will introduce you to some of the statistics relating to slips, trips and falls and dispel some of the myths surrounding them. It also touches on the law as it relates to slips, trips and falls. It contains real examples of where things have gone wrong and some practical steps that could have been taken to prevent these incidents. The course also covers some of the straightforward changes that can be made in most businesses to significantly reduce the risk of a slip, trip or fall incident occurring.

In this course, we will learn about the Google Apps Script to create custom functions within G Suite that will help you increase your productivity. This course contains 100+ coding examples. For this course, you need JavaScript and basic HTML and CSS knowledge, a Google account, and a basic web development understanding.

This course is for candidates who have completed their Level 1 Health and Safety in a Construction Environment course and want to prepare for the touch screen test. The course reviews the key learning objectives of the Level 1 course and concludes with a 50 question test that has been produced in the style of the touch screen test.

Learn how to identify the different types of fire extinguishers that might be installed within your workplace and what situations they might be used in. At the end of the final module you will be presented with a simulation that will test what you’ve learnt.

24 Hours Left! Don't Let Year-End Deals Slip Away - Enrol Now! Biggest Deal Price is Active Now! Previous Price: £4565 GBP & Offered Price: £129 GBP!! ** Save Now: £4426 GBP! Offer Ends Soon, Hurry Up!!!! ** Get Free 1 QLS Endorsed Certificate Course with 10 Additional CPD Accredited Bundle Courses In A Single Payment. If you wish to gain a solid and compact knowledge of Career Coaching and boost yourself for your desired career, then take a step in the right direction with this industry-standard, comprehensive course designed by professionals. This bundle package includes 1 Premium, The Quality Licence Scheme-endorsed course, 10 additional CPD accredited certificate courses, with expert assistance, and a FREE courses assessment included. Learn a range of in-demand technical skills to help you progress your career with 12 months of unlimited access to this bundle of courses. If you enrol in this package, you will not be charged any extra fees. This Bundle Package includes: Course 01: Career Coaching at QLS Level 5 10 Additional Premium CPD Accredited Courses - Course 01: Coaching & Mentoring Diploma Course 02: Online Life Coaching Diploma Course 03: Career Development and Passion Training Course 04: Resume Writing & Job Search Training Course 05: Inspirational Leadership Skills Course 06: Goal Setting, Motivation, and Resilience for Life Course 07: Productivity Development Course 08: Confidence Building & Assertiveness Course 09: Communicate and Work with People from Other Culture Course Course 10: The 11 Essential Career Soft Skills Success becomes a lot simpler with this bundle package, which allows you to monetise your skills. This bundle is appropriate for both part-time and full-time students, and it can be completed at your own pace. This premium online bundle course, named Career Coaching, supports your professional growth with Quality Licence Scheme endorsement, as well as CPD accreditation. You'll be able to practice on your own time and at your own speed while still gaining an endorsed certificate. You'll get an unrivalled learning experience, as well as a free student ID card, which is included in the course price. This ID card entitles you to discounts on bus tickets, movie tickets, and library cards. With this high-quality package, all students have access to dedicated tutor support and 24/7 customer service. Throughout the extensive syllabus of this package, you'll find the required assistance and also the answers to all of your questions. The course materials are designed by experts and you can access these easily from any of your smartphones, laptops, PCs, tablets etc. Master the skills to arm yourself with the necessary qualities and explore your career opportunities in relevant sectors. Why Prefer This Bundle Course? Upon successful completion of the bundle, you will receive a completely free certificate from the Quality Licence Scheme. Option to receive 10 additional certificates accredited by CPD to expand your knowledge. Student ID card with amazing discounts - completely for FREE! (£10 postal charges will be applicable for international delivery) Our learning materials have an engaging voiceover and visual elements for your convenience. For a period of 12 months, you will have 24/7 access to all course material. Complete the bundle, at your own pace. Each of our students gets full 24/7 tutor support After completing our bundle, you will receive efficient assessments and immediate results. Course Curriculum: The course has the following curriculum: ***Career Coaching*** Module 01: Introduction to Career Coaching Module 02: The Career Seeker Module 03: Ethical Aspects of Coaching and Mentoring Module 04: Coaching and Mentoring Models Module 05: Motivating Your Clients Module 06: The Coach/Client Relationship Module 07: Effective Communication Skills Module 08: Personal Skills Module 09: Management Skills Module 10: Functional Skills Module 11: Essential UK Employment Law How is the Bundle Assessment Process? We offer an integrated assessment framework to make the process of evaluation and accreditation for learners easier. You have to complete the assignment questions given at the end of the course and score a minimum of 60% to pass each exam. Our expert trainers will assess your assignment and give you feedback after you submit the assignment. You will be entitled to claim a certificate endorsed by the Quality Licence Scheme after you have completed all of the exams. Show off Your New Skills with a Certification of Completion Endorsed Certificate of Achievement from the Quality Licence Scheme After successfully completing the course, you can order an original hardcopy certificate of achievement endorsed by the Quality Licence Scheme. The certificate will be home-delivered, with completely free of charge in this package. For Additional the Quality Licence Scheme Endorsed Certificate you have to pay the price based on the Level of these Courses: Level 1 - £79 Level 2 - £99 Level 3 - £119 Level 4 - £129 Level 5 - £139 Level 6 - £150 Level 7 - £159 Certification Accredited by CPD Upon finishing the course, you will receive an accredited certification that is recognised all over the UK and also internationally. The pricing schemes are - 10 GBP for Digital Certificate 29 GBP for Printed Hardcopy Certificate inside the UK 39 GBP for Printed Hardcopy Certificate outside the UK (international delivery) CPD 255 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Is This Bundle Right for You? The training is perfect for highly motivated people who want to improve their technical skills and prepare for the career they want! This package is also ideal for those who want to learn more about this subject in-depth and stay up to date with the latest details. From the comfort of your own home, study the bundle course and expand your professional skillset! Requirements The Career Coaching Bundle has no formal entry criteria, and everyone is welcome to enrol! Anyone with a desire to learn is welcome to this course without hesitation. All students must be over the age of 16 and have a passion for learning and literacy. You can learn online using any internet-connected device, such as a computer, tablet, or smartphone. You can study whenever it's convenient for you and finish the bundle package at your own speed. Career path The bundle course aims to help you get the job or even the long-awaited promotion of your dreams. With the support and guidance of our package, you will learn the skills and knowledge that are important to your career. Certificates Career Coaching Diploma Training - CPD Certified Hard copy certificate - Included CPD Accredited Certificate Digital certificate - Included Upon successfully completing the Bundle, you will need to place an order to receive a PDF Certificate for each course within the bundle. These certificates serve as proof of your newly acquired skills, accredited by CPD QS. Also, the certificates are recognised throughout the UK and internationally. CPD Accredited Certificate Hard copy certificate - Included International students are subject to a £10 delivery fee for their orders, based on their location.

Microsoft Project White Belt® 2013: Virtual In-House Training This workshop serves as an introduction to the interface and features of Microsoft® Project 2013. This course will be led by an IIL-certified instructor who will outline the benefits of Microsoft Project, provide tips on using various features and common shortcuts, recommend guidelines, and discuss the application of scheduling concepts to manage project work This workshop serves as an introduction to the interface and features of Microsoft® Project 2013. This course will be led by an IIL-certified instructor who will outline the benefits of Microsoft Project, provide tips on using various features and common shortcuts, recommend guidelines, and discuss the application of scheduling concepts to manage project work. What you Will Learn You'll learn how to: Define key scheduling concepts and terms Effectively navigate the user interface and interpret common views Configure essential elements of a new schedule Enter and modify a task list Set dependencies between tasks Create a basic resource list and generate assignments Format targeted areas of the Gantt Chart view Prepare the schedule for printing Getting Started Introductions Course objectives Course outline Navigating the User Interface and Views Navigate and use the Ribbon Use and customize the Quick Access Toolbar Modify general and display options Become familiar with major elements on the Project screen Navigate Gantt Chart, calendar, and network diagram views Search for a help topic Setting up a New Schedule Create new schedules Create a new schedule using existing information Enter and modify the schedule start date Enter and modify exception days in the calendar Entering, Modifying, and Outlining Task Data Enter, edit, correct, and clear information Enter unscheduled tasks Enter duration estimates for a single task or multiple tasks Organize tasks Set up a multi-level outline Add notes to tasks Creating Dependencies by Setting Links Identify a critical path in a simple schedule Understand how scheduling software calculates a critical path Describe dynamic schedules and dependencies Create links using various methods Display the critical path Entering and Assigning Resources Plan for resources Create a list of available resources Assign resources Formatting Gantt Chart View Format text and Gantt Chart bars Format a collection of items Configure print options