• Professional Development
  • Medicine & Nursing
  • Arts & Crafts
  • Health & Wellbeing
  • Personal Development

1074 Microsoft 365 courses

Microsoft Access Advanced - In-company / Bespoke

By Microsoft Office Training

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

Microsoft Access Advanced - In-company / Bespoke
Delivered in London or UK Wide or OnlineFlexible Dates
£550

Microsoft Word Advanced - In-company (now with live online classes)

By Microsoft Office Training

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

Microsoft Word Advanced - In-company (now with live online classes)
Delivered in London or UK Wide or OnlineFlexible Dates
£550

Microsoft Office 2013 Certification Bundle with 5 Exams

By Hudson

The Microsoft Office Specialist 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.

Microsoft Office 2013 Certification Bundle with 5 Exams
Delivered Online On Demand
£839

Microsoft Office 2016 Certification Bundle with 5 Exams

By Hudson

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.

Microsoft Office 2016 Certification Bundle with 5 Exams
Delivered Online On Demand
£839

Data Analysis and Visualization with Microsoft Excel

By Nexus Human

Duration 2 Days 12 CPD hours This course is intended for This course is designed for students who already have foundational knowledge and skills in Excel and who wish to perform robust and advanced data and statistical analysis with Microsoft Excel using PivotTables, use tools such as Power Pivot and the Data Analysis ToolPak to analyze data, and visualize data and insights using advanced visualizations in charts and dashboards in Excel. To ensure success, you should have baseline skill using Microsoft Excel worksheets, particularly in creating workbooks with formulas and function Overview #NAME? Analyzing data to find issues, insights and opportunities, is now a critical part of many job roles. Beyond the analysis, data analysts in all job roles must be able to effectively present and communicate their findings in visually compelling ways. Microsoft© Excel© is designed for this purpose. Excel can connect to a wide range of data sources, perform robust data analysis and create diverse and robust data-backed visualizations to show insights, trends, and create reports. These capabilities enable people who use Excel for data analysis to turn data into thoughtful action. 1 - DATA ANALYSIS FUNDAMENTALS Introduction to Data Science Create and Modify Tables Sort and Filter Data 2 - VISUALIZING DATA WITH EXCEL Visualize Data with Charts Modify and Format Charts Apply Best Practices in Chart Design 3 - ANALYZING DATA WITH FORMULAS AND FUNCTIONS Analyze Data with Formulas and Named Ranges Analyze Data with Functions Implement Data Validation, Forms, and Controls Create Conditional Visualizations with Lookup Functions 4 - ANALYZING DATA WITH PIVOTTABLES Create a PivotTable Analyze PivotTable Data 5 - PRESENTING VISUAL INSIGHTS WITH DASHBOARDS IN EXCEL Visualize Data with PivotCharts Filter Data Using Slicers and Timelines Create a Dashboard in Excel 6 - CREATING GEOSPATIAL VISUALIZATIONS WITH EXCEL Create Map Charts in Excel Customize Map Charts in Excel 7 - PERFORMING STATISTICAL ANALYSIS Visualize Trendlines and Sparklines with Excel Analyze Data with the Data Analysis ToolPa 8 - GETTING AND TRANSFORMING DATA Connect to Data with Queries Clean and Combine Data Shape and Transform Data 9 - MODELING AND ANALYZING DATA WITH POWER PIVOT Install Power Pivot in Excel Create Data Models with Power Pivot Create Power Pivots Perform Advanced Data Analysis and Visualization 10 - PRESENTING INSIGHTS WITH REPORTS (OPTIONAL) Plan a Report Create a Report

Data Analysis and Visualization with Microsoft Excel
Delivered OnlineFlexible Dates
£590

Microsoft Office 365 Online (with Teams for the Desktop)

By Nexus Human

Duration 1 Days 6 CPD hours This course is intended for This course is intended for business users and knowledge workers in a variety of roles and fields who have competence in a desktop-based installation of the Microsoft Office 2010, 2013, or 2016 edition of the Microsoft Office productivity suite, and who are now extending Microsoft Office to a collaborative cloud-based Office 365 environment. Overview In this course, you will build upon your knowledge of the Microsoft Office desktop application suite to work productively in the cloud-based Microsoft Office 365 environment. You will: Sign in, navigate, and identify components of the Office 365 environment. Create, edit, and share documents with team members using the Office Online apps, SharePoint, OneDrive© for Business, and Delve. Collaborate and work with colleagues using the Yammer and Planner apps. Use email and manage contacts with Outlook on the web. Collaborate using Teams. Configure Teams. This course introduces working with shared documents in the familiar Office 365 online apps?Word, PowerPoint©, and Excel©?as an alternative to installing the Microsoft© Office desktop applications. This course also introduces several productivity apps including Yammer?, Planner, and Delve© that can be used in combination by teams for communication and collaboration. Prerequisites Outlook - Part 1 PowerPoint - Part 1 Word 2016 - Part 1 Using Microsoft Windows 10 1 - GETTING STARTED WITH OFFICE 365 Topic A: Sign In to Office 365 Topic B: Navigate the Office 365 Environment 2 - COLLABORATING WITH SHARED FILES Topic A: Work with Shared Documents in SharePoint Topic B: Edit Documents in Office Online Topic C: Collaborate on the SharePoint Site Topic D: Work with OneDrive for Business and Delve 3 - USING PRODUCTIVITY APPS Topic A: Work with Productivity Apps in Combination Topic B: Broadcast Messages with Yammer Topic C: Manage Tasks with the Planner App 4 - USING OUTLOOK ON THE WEB Topic A: Send and Receive Email Topic B: Manage Contacts Topic C: Schedule Appointments Topic D: Personalize Outlook on the Web 5 - COLLABORATING WITH TEAMS Topic A: Overview of Microsoft Teams Topic B: Converse and Share in Teams Topic C: Call and Meet in Teams Topic D: Collaborate with Office 365 Apps and Teams 6 - CONFIGURING TEAMS Topic A: Configure Teams Topic B: Configure Channels Topic C: Configure Tabs

Microsoft Office 365 Online (with Teams for the Desktop)
Delivered OnlineFlexible Dates
£295

Microsoft Essentials- CPD Certified

4.7(47)

By Academy for Health and Fitness

***24 Hour Limited Time Flash Sale*** QL Programming Masterclass Admission Gifts FREE PDF & Hard Copy Certificate| PDF Transcripts| FREE Student ID| Assessment| Lifetime Access| Enrolment Letter Are you a professional feeling stuck in your career, struggling to keep up with the ever-changing demands of the industry? Or perhaps you're a beginner, unsure of where to start or how to break into your desired field. Whichever stage you're in, our exclusive Microsoft Essentials Bundle provides unique insights and tools that can help you achieve your goals. Designed to cater to the needs of both seasoned professionals and aspiring newcomers, our Microsoft Essentials bundle is a comprehensive program that will equip you with the essential skills and knowledge you need to succeed. Whether you're looking to advance in your current role or embark on a new career journey, this bundle has everything you need to take your professional life to the next level. But that's not all. When you enrol in Microsoft Essentials Online Training, you'll receive 25 CPD-Accredited PDF Certificates, Hard Copy Certificates, and our exclusive student ID card, all absolutely free. Courses Are Included In this Microsoft Essentials Career Bundle: Course 01: Microsoft Office Essentials Course 02: Microsoft Word Diploma Course 03: PowerPoint Diploma Course 04: Excel for Beginner Course 05: Microsoft Excel Level 3 Course 06: New Functions in Excel 2021 Course 07: Excel: Automated Dashboard Course 08: Excel Sheet Comparison with VBA Course 09: Top 50 Microsoft Excel Formulas Course 10: Excel Pivot Tables Course 11: Excel Must Know Formulas and Functions Course 12: Excel Data Analysis Course 13: Excel Vlookup, Xlookup, Match, and Index Course 14: Master Power Query Course 15: Pivot Tables, Charts, Slicers, Timelines Course 16: PowerBI Formulas Course 17: Outlook Tips and Tricks Course 18: PowerQuery and PowerPivot Course 19: Complete Power BI 2021 Course 20: Outlook Masterclass Course 21: Microsoft Access Course (Beginner to Advanced) Course 22: Microsoft Access Tables and Queries Course 23: Microsoft Access Forms and Reports Course 24: Microsoft Teams Course 25: Proofreading & Copyediting With Microsoft Essentials, you'll embark on an immersive learning experience that combines interactive lessons with voice-over audio, ensuring that you can learn from anywhere in the world, at your own pace. And with 24/7 tutor support, you'll never feel alone in your journey, whether you're a seasoned professional or a beginner. Don't let this opportunity pass you by. Enrol in Microsoft Essentials today and take the first step towards achieving your goals and dreams. Why buy this Microsoft Essentials? Free CPD Accredited Certificate upon completion of Microsoft Essentials Get a free student ID card with Microsoft Essentials Lifetime access to the Microsoft Essentials course materials Get instant access to this Microsoft Essentials course Learn Microsoft Essentials from anywhere in the world 24/7 tutor support with the Microsoft Essentials course. Start your learning journey straightaway with our Microsoft Essentials Training! Microsoft Essentials premium bundle consists of 25 precisely chosen courses on a wide range of topics essential for anyone looking to excel in this field. Each segment of Microsoft Essentials is meticulously designed to maximise learning and engagement, blending interactive content and audio-visual modules for a truly immersive experience. Certification You have to complete the assignment given at the end of the Microsoft Essentials course. After passing the Microsoft Essentials exam You will be entitled to claim a PDF & Hardcopy certificate accredited by CPD Quality standards completely free. CPD 250 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Microsoft Essentials course is ideal for: Students seeking mastery in Microsoft Essentials Professionals seeking to enhance Microsoft Essentials skills Individuals looking for a Microsoft Essentials-related career. Anyone passionate about Microsoft Essentials Requirements This Microsoft Essentials doesn't require prior experience and is suitable for diverse learners. Career path This Microsoft Essentials bundle will allow you to kickstart or take your career in the related sector to the next stage. Certificates CPD Accredited Digital certificate Digital certificate - Included CPD Accredited Hard copy certificate Hard copy certificate - Included If you are an international student, then you have to pay an additional 10 GBP for each certificate as an international delivery charge.

Microsoft Essentials- CPD Certified
Delivered Online On Demand4 days
£149

Microsoft Office 365 for End Users In-Company (now with live online classes)

By Microsoft Office Training

This 1 day course is designed for the end user who is using or will use Office 365. This course will provide delegates with the knowledge and skills to efficiently use Office 365 on a day-to-day basis. The course is designed with real world scenarios in mind. Delegates will learn how to use Outlook Online, Skype for Business, OneDrive for Business, SharePoint Online, and OneNote. At the end of this course delegates will be able to effectively navigate Office 365 and make use of all of the features of Office 365 Office 365 Overview Introducing Cloud Computing Identify and Outline the Component Products in Office 365 including Outlook Web App, Office Online Apps, OneDrive and Skype for Business Navigating around Office 365 Customising the Office 365 Nav Bar Updating your Profile in Office 365 Using the Outlook Online Application Overview of Outlook Online Working with Email and Folders Outlook People and IM Contacts Using the Calendar Shared Calendars Outlook Tasks in the Web App Setting Outlook Options, Signatures, Automatic Replies and Rules Using Skype for Business Overview of Skype for Business Viewing and Setting Presence Status Using Instant Messages in Business Understanding the Interactive Contact Card in Microsoft Office Applications Integration with Outlook Using Skype for Business for Online Presentations including Content Sharing, Polls and a Virtual Whiteboard Working with OneDrive for Business What is OneDrive for Business? Navigating around OneDrive Accessing Content in OneDrive Using the Office Online Apps Sharing Documents and Collaborating Connecting Microsoft Office to OneDrive Creating Office Documents and Saving Directly to OneDrive Using Groups and Delve Introduction to Groups Collaborating using Groups Getting to Content using Delve Requirements Requirements Before attending this course, students must have: Basic understanding of Microsoft Office Basic understanding of Microsoft Windows Operating systems

Microsoft Office 365 for End Users In-Company (now with live online classes)
Delivered in London or UK Wide or OnlineFlexible Dates
£750

Microsoft Excel in Depth: Virtual In-House Training

By IIL Europe Ltd

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

Microsoft Excel in Depth: Virtual In-House Training
Delivered OnlineFlexible Dates
£850

Microsoft Project Orange Belt 2013 - Español: On-Demand

By IIL Europe Ltd

Microsoft Project Orange Belt ® 2013 - Español: On-Demand This course is intended for both novice and experienced project managers, or any user of Project 2013. Participants must be involved in or be responsible for scheduling, estimating, budgeting, coordinating, controlling, and staffing projects and supporting projects. Project 2013 users. This course is intended for both new and experienced project managers, or any user of Project 2013. Participants must be involved in or responsible for scheduling, estimating, budgeting, coordinating, controlling, and staffing projects and supporting Project 2013 users. What You Will Learn Understand what's new in the Project 2013 release. Initialize Project to start flattening. Create a good project schedule, including WBS, estimates, dependencies, constraints, deadlines, and calendar usage. Assign resources and costs to tasks. Understand the types of tasks and the scheduling formula. Analyze the use of resources and optimize the schedule. Establish a baseline and a progress monitoring strategy. Use Earned Value Explain the potential of managing multiple projects. Ready to Go with Project 2013 Summary of Project 2013 Establish a new Project Schedule (Options, templates, files, etc.) Set the Project Schedule Enter Tasks The Planning Process Importar Tareas (Word, Excel, SharePoint) Create and manage a WBS (includes tasks, manual tasks, summary tasks, milestones, and WBS coding) Enter Estimates Trends in estimates The Gradual Planning Approach Enter Estimates on Duration and Effort Task types Enter Dependencies The principles of Dynamic Programming Types of Dependencies Selecting the right type of dependency Enter Dependencies in Project 2013 Understanding Due Dates, Restrictions and Task Calendar Use Deadlines and Restrictions Enter Deadlines and Restrictions in Project 2013 Enter Resources and Costs Resource Types Enter Resources in Project 2013 Calendars and Resources Enter Costs in Project 2013 Enter Assignments Assignments on a Schedule Assignments and Task Types Enter Assignments in Project 2013 Allocations and Costs Optimize the Schedule The Critical Path Method and the Resource Critical Path Resource Leveling Optimize Time, Cost and Resources in Project 2013 Update Schedule the baseline Strategies and Update Situations Prepare the Status and Forecast Report in Project 2013 Reports Using reports and dashboards Using visual reports Format and print reports Customize fields and views Earned Value Management (EVM) Earned Value Summary Applying Earned Value in Project 2013 Evaluate the Project Why evaluate? Compare results against baselines Generate templates for future projects Consolidated Schedules Creating a Consolidated Schedule Use a resource group Links between projects Solving common problems Baseline and follow-up

Microsoft Project Orange Belt  2013 - Español: On-Demand
Delivered Online On Demand30 minutes
£1,250