3069 Microsoft courses in March delivered Online

This course introduces you to SQL and Microsoft SQL Server in a practical way. You'll be able to learn the basics of SQL quickly and understand how to use SQL queries and statements with Microsoft SQL Server to extract data and analyze it for making productive marketing decisions.

Recognised Accreditation This course is accredited by continuing professional development (CPD). CPD UK is globally recognised by employers, professional organisations, and academic institutions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. Course Curriculum Microsoft Yammer - Social Networking in Companies and Organizations What is Yammer And When Should You Use It. 00:03:00 First Steps In Yammer 00:09:00 Communicate Effectively With Yammer 00:14:00 How Does Yammer Work With Other Apps. 00:03:00 Yammer On Mobile Devices 00:02:00 Conclusions 00:02:00 Obtain Your Certificate Order Your Certificate of Achievement 00:00:00 Get Your Insurance Now Get Your Insurance Now 00:00:00 Feedback Feedback 00:00:00

The Microsoft Excel course is designed to teach you everything you need to know about Excel from scratch. This comprehensive, instructor-guided training will help you gain a thorough understanding of Excel’s essential features and functions, enabling you to kickstart your career or enhance your current skills. Whether you are just starting out or looking to build on your knowledge, this course will equip you with the most in-demand skills required in today's competitive job market.

Duration 3 Days 18 CPD hours This course is intended for This course is intended for both novice and experienced project managers, managers, schedulers, and other project stake holders who need to incorporate the discipline of project management with Microsoft Project 2019. Overview Understand the discipline of project management as it applies to using Microsoft Project 2019. Create a Work Breakdown Structure. Identify Task Types & Relationships. Define Resources within Project. Make Work Package Estimates. Create an Initial Schedule. Create a Resource Leveled Schedule. Create Projects from templates, Excel files. Create Global templates. Create formulas and graphical indicators. The steps to record a macro. Format Output and Print Reports. Integrate Multiple Projects. Set up a Project with a Calendar, Start date, and scheduling method. Understand Manually Schedule vs. Auto Schedule. Manage multiple projects. Be able to create a master project list with shared resources. This three-day instructor-led course is intended for individuals who are interested in expanding their knowledge base and technical skills about Microsoft Project. The course begins with the basic concepts and leads students through all the functions they?ll need to plan and manage a small to medium-size project, including how to level resources and capture both cost and schedule progress. 1 - Introduction to Microsoft Project Describe how Project relates to the discipline of Project management. Learn what the new features are in Project 2019. Navigate to the primary views available using the Ribbon. Choose Views that display task, resource, or assignment information. Select table within views to change the information that is available to see and edit. Relate the features of Project to the 5 steps for building a plan in Project. Learn new accessibility features in Project 2 - A Quick and Easy Overview of Managing with Project Create a new project and prepare it for data entry. Enter project tasks. Sequence the tasks. Define resources. Estimate Task duration and assign resources. Baseline the project. Track project progress. 3 - Setting Up a Project Use multiple methods to create a new project from an Excel file and a SharePoint Tasks list. Establish one or more calendars to constrain resource availability. Configure Project to calculate the schedule from the Start Date forward, or from the Finish Date backward. 4 - Manually Schedule vs. Auto Schedule Students practice switching tasks between Manually Schedule and Auto Schedule modes. By switching modes, students learn the impact made on the project schedule and the individual tasks. 5 - Creating a Work Breakdown Structure Build and use summary and subordinate tasks. Understand and use milestones. Develop WBS Outlines. Assign completion criteria. Evaluate the WBS. Understand and use WBS templates. 6 - Identifying Task Relationships Understand the different types of task relationships. Understand and use various methods to create relationships. Determine and display task sequence. Understand and use lag, lead, and delay. Understand the new feature of Task Paths. 7 - Defining Resources within Project Define resource types. Define individual resources that will be used on the project. Record the cost (s) of using each type of resource. Record the limit of availability for each type of resource by establishing a resource calendar and defining the maximum units of that resource. 8 - Making Work Package Estimates Enter estimates for duration and costs for each task. Distinguish between task types and describe when each is appropriate. Describe the relationship between work, units, and duration. Describe the way Effort Driven scheduling is affected by work, units, and duration. Assign tasks to resources using the Team Planner view. 9 - Creating an Initial Schedule Calculate float and identify a project?s critical path. Understand and identify task constraints. Create milestones. Use the Task Inspector to troubleshoot the initial schedule. 10 - Create a Resource Leveled Schedule Adjust a project schedule to account for limited people and other resources. View the overall cost and schedule of a project. Identify resources that have been overallocated for a project schedule. Use multiple ways to adjust tasks and assignments to remove over allocation for any resource. 11 - Managing the Project Learn how to set a baseline. Lean how to enter and track project performance data. Learn how to apply different tracking methods. Learn how to perform a variance analysis on a project. Learn how to Reschedule Work Learn how to inactivate tasks Learn how to synch projects to SharePoint 12 - Formatting Output and Printing Reports Print Views Formats Sorting Filtering Grouping Custom Fields Reporting Other File Formats 13 - Managing Multiple Projects Learn how to use common resources among multiple projects. Learn how to link tasks between multiple projects. Learn how to create a consolidated view of multiple projects. 14 - Advanced Topics Learn how to customize the Ribbon and the Quick Access Toolbar. Learn how to customize WBS numbering. Learn the concepts of Formulas and Graphical indicators. Learn the purpose of the Global template and Organizer. Learn how to record a Macro.

Microsoft Power BI 90 Minutes Training is yet another 'Teacher's Choice' course from Teachers Training for a complete understanding of the fundamental topics. You are also entitled to exclusive tutor support and a professional CPD-accredited certificate in addition to the special discounted price for a limited time. Just like all our courses, this Microsoft Power BI 90 Minutes Training and its curriculum have also been designed by expert teachers so that teachers of tomorrow can learn from the best and equip themselves with all the necessary skills. Consisting of several modules, the course teaches you everything you need to succeed in this profession. The course can be studied part-time. You can become accredited within 2 hours studying at your own pace. Your qualification will be recognised and can be checked for validity on our dedicated website. Why Choose Teachers Training Some of our features are: This is a dedicated website for teaching 24/7 tutor support Interactive Content Affordable price Courses accredited by the UK's top awarding bodies 100% online Flexible deadline Entry Requirements No formal entry requirements. You need to have: Passion for learning A good understanding of the English language numeracy and IT Desire for entrepreneurship over the age of 16. Assessment The assessment is straightforward, you need to complete the assignment questions that will be provided to you at the end of the course, you can complete the assignment anytime you want. After you complete and submit your assignment, our tutors will assess your assignment and give you feedback if needed.  After your assignment has been assessed and you have passed, you will be qualified and will be able to apply for a course completion certificate. Certification CPD Certification from The Teachers Training Successfully completing the MCQ exam of this course qualifies you for a CPD-accredited certificate from The Teachers Training. You will be eligible for both PDF copy and hard copy of the certificate to showcase your achievement however you wish. You can get your digital certificate (PDF) for £4.99 only Hard copy certificates are also available, and you can get one for only £10.99 You can get both PDF and Hard copy certificates for just £12.99! The certificate will add significant weight to your CV and will give you a competitive advantage when applying for jobs. Power BI - Introduction Overview of the Course 00:02:00 Power BI Introduction 00:03:00 Power BI High Level Flow 00:02:00 Installing and Signing Up for Power BI 00:03:00 Power Query Introduction 00:05:00 Power Pivot Introduction 00:01:00 Power View Introduction 00:02:00 Your First Power BI Dashboard! The Big Picture 00:02:00 Get Data 00:07:00 How to Get More Data 00:01:00 Modelling Data 00:03:00 Adding Relationships Manually 00:02:00 Visualization 00:05:00 Visualization Customization 00:01:00 More Visualizations 00:02:00 Visualization Format and Analytics 00:03:00 Ask a Question in Power BI 00:02:00 Your Advanced Power BI Dashboard With Real Live Real World Example 00:06:00 Get Data 00:13:00 Modelling Data 00:05:00 Visualization with multiple charts 00:11:00 Publishing 00:05:00 Power BI Website 00:08:00

Discover Excel 2019 and become confident in using spreadsheets

Increase your Excel and Pivot Table skills and knowledge within hours which will get you noticed by top management and prospective employers. Become more productive at using Excel which will save you hours each day and eliminate stress at work. This course helps you learn about Pivot Tables that can be used for data analysis with a proper approach.

Duration 4 Days 24 CPD hours This course is intended for Candidates should be familiar with Dynamics 365 Customer Insights and have firsthand experience with one or more additional Dynamics 365 apps, Power Query, Microsoft Dataverse, Common Data Model, and Microsoft Power Platform. They should also have working knowledge of practices related to privacy, compliance, consent, security, responsible AI, and data retention policy. Overview After completing this course, you will be able to: Clean, transform, and ingest data into Dynamics 365 Customer Insights Create a unified customer profile Work with Dynamics 365 Audience insights Enrich data and predictions Set up and manage external connections Administer and monitor Customer Insights Customer Data Platform specialists implement solutions that provide insight into customer profiles and that track engagement activities to help improve customer experiences and increase customer retention. In this course, students will learn about the Dynamics 365 Customer Insights solution, including how to unify customer data with prebuilt connectors, predict customer intent with rich segmentation, and maintain control of customer data. This specialty course starts with creating a unified profile and then working with customer data. Module 1: Get started with Dynamics 365 Customer Insights Introduction to the customer data platform Administer Dynamics 365 Customer Insights Explore user permissions in Dynamics 365 Customer Insights Module 2: Ingest data into Dynamics 365 Customer Insights Import and transform data Connect to data sources Work with data Module 3: Create a unified customer profile in Dynamics 365 Customer Insights Map data Match data Merge data Find customers Module 4: Work with Dynamics 365 Customer Insights Explore Audience insights Define relationships and activities Work with measures Work with segments Module 5: Enrich data and predictions with Audience insights Enrich data Use predictions Use machine learning models Module 6: Manage external connections with Customer Data Platform Export Customer Insights data Use Customer Insights with Microsoft Power Platform Display Customer Insights data in Dynamics 365 apps More ways to extend Customer Insights

Overview Do you face struggle when you open a Power Query seeing the number of things to do then and cannot make good use of your time? Then this Microsoft Excel: Master Power Query in 120 Minutes! Course is just what you need.to break free of your worries. Power Query is a business intelligence tool available in Excel that allows you to import data from many sources and then clean, transform and reshape your data as needed. The course is designed for learners opting to learn Power Query, a feature available in Excel. Power query is a data connection technology that enables you to connect combine refine and discover data from various sources to meet analysis needs.  The course will introduce you to the basic features of Power query and then show how to trim and transform Data in Excel Power Query, Format Dates and Values in Excel Power Query. You will also learn how to extract data from folders and doing auto clean up on Excel Power Query. You will also learn to merge and shape data according to analysis requirements and prepare models by tools such as power pivot. Learning Outcomes: Acquire proficiency in using Excel Power Query for efficient data management. Master the art of transforming raw data into actionable insights. Learn advanced techniques for data manipulation and analysis. Develop the ability to streamline complex data processes. Enhance your analytical thinking and problem-solving skills. How is the course assessed? To successfully complete the course you must pass an automated, multiple-choice assessment. The assessment is delivered through our online learning platform. You will receive the results of your assessment immediately upon completion. Will I receive a certificate of completion? Upon successful completion, you will qualify for the UK and internationally-recognised certification and you can choose to make your achievement formal by obtaining your PDF Certificate at a cost of £9 and Hardcopy Certificate for £15. Why study this course Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards and CIQ after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the Course at your own pace, on your own schedule. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience. Unlock career resources for CV improvement, interview readiness, and job success. Requirements Our Microsoft Excel: Master Power Query in 120 Minutes! Course is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career paths Data Analyst: £25,000 - £40,000 Per Annum Business Analyst: £30,000 - £50,000 Per Annum Financial Analyst: £28,000 - £45,000 Per Annum Marketing Analyst: £24,000 - £40,000 Per Annum Operations Analyst: £26,000 - £42,000 Per Annum Management Consultant: £35,000 - £55,000 Per Annum Course Curriculum Microsoft Excel: Master Power Query in 120 Minutes! Power Query Intro and Excel version 00:03:00 Excel Power Query - Introduction 00:03:00 Excel Power Query - Query Editor Ribbon 00:09:00 Transform Data - Trim in Excel Power Query 00:05:00 Transform Data - Format Dates and Values in Excel Power Query 00:02:00 Transform Data - Parsing URLs in Excel Power Query 00:05:00 Transform Data - Split Text Fields in Excel Power Query 00:10:00 Transform Data - Group By in Excel Power Query 00:03:00 Transform Data - Unpivoting Columns in Excel Power Query 00:05:00 Transform Data - Pivoting Columns in Excel Power Query 00:02:00 Transform Data - Split Columns into Other Columns in Excel Power Query 00:04:00 Transform Data - Filtering Rows in Excel Power Query 00:05:00 Transform Data - Sorting Columns in Excel Power Query 00:02:00 Transform Data - Transform and Add Columns in Excel Power Query 00:07:00 From Folder - Import From Folder in Excel Power Query 00:07:00 From Folder - Doing Auto Cleanup in Excel Power Query 00:13:00 From Folder - Extract Data from Forms in Excel Power Query 00:13:00 From Workbook - Extract Multiple Criteria in Excel Power Query 00:05:00 From Workbook - Extract Multiple Worksheets in Excel Power Query 00:04:00 Joins - Intro to Joins 00:04:00 Joins - Merging 00:08:00 Joins - Full Outer Join 00:06:00 Joins - Right Anti Join 00:09:00 Power Query - Convert Reports into Pivot Tables 00:05:00 Modulo 00:06:00

This course covers the essential topics necessary for working with Microsoft SQL Server. You will understand the various scenarios and techniques to write queries and build and administer databases, along with delving into advanced SQL topics that are in great demand in the industry.