Microsoft Office 365

The M365 Pivot Tables & Data Modelling Training Course is a virtual, instructor-led program focusing on advanced Excel features like PivotTables and Data Modelling. The course aims to enhance delegates' ability to analyze data and manipulate Excel effectively. Targeted at individuals seeking in-depth knowledge of PivotTables and Data Modelling, the course requires advanced Excel proficiency as a prerequisite. Objectives include creating and using PivotTables, Slicers, PivotCharts, Timelines, Data Models, and utilizing the PowerPivot Add-in. The course duration is one day.

The Online MS Project Training Course is designed for construction project team members or Project Managers to learn Microsoft Project basics. Participants will gain skills in planning, scheduling, using views, filtering, and printing construction projects. Prerequisites include basic Windows knowledge and familiarity with Microsoft Office applications. Course objectives cover project planning, task management, scheduling, calendar usage, views, and printing. The course duration is one day.

This online Microsoft 365 Power BI Desktop training course aims to provide essential skills in Power BI, including data extraction, transformation, loading, and visualization. The course covers creating dashboards and sharing them with colleagues. Prerequisites include basic Excel knowledge, and the target students are those needing a basic understanding of Power BI Desktop. Objectives include exploring the Power BI Desktop environment, working with data sources, creating visualizations, understanding DAX calculations, using queries, and publishing and sharing dashboards.

The Online Microsoft 365 Excel Training Course aims to enable participants to understand the basic components of Excel and learn how to create and use formulas. Targeted at individuals needing basic Excel knowledge, the course covers exploring the Excel environment, creating worksheets, using formulas and functions, formatting worksheets, managing workbooks, and setting up printing options. Prerequisites include familiarity with using a computer in a Windows environment. The course is one day long and costs £175 + Vat.

The Online Microsoft 365 Excel Training Course is designed to help participants enhance their Excel skills by using advanced formulas, analyzing data, creating charts, and applying tools like Conditional Formatting, Sorting, and Filtering. The course aims to enable delegates to manipulate data more effectively. Targeted at individuals seeking advanced data calculation skills, the course requires prior knowledge of basic formulas. Participants will learn to use advanced formulas, organize data, create and modify charts, sort and filter data, and apply Conditional Formatting.

The Online Microsoft 365 Excel Training Course is designed to help participants explore advanced Excel features, including formulas, data validation, auditing tools, PivotTables, illustrations, and templates. The course aims to enhance Excel proficiency for better data manipulation. Targeted at individuals seeking in-depth Excel knowledge, prerequisites include attending Excel Level 1 and/or Level 2 courses. By the end of the 1-day course, participants will be able to validate data, work with advanced formulas, create PivotTables, use illustrations, and more.

The Online Microsoft 365 Excel Training Course is designed to help participants gain advanced skills in Excel data manipulation. The course covers creating and using macros, collaborating and analyzing data, using form controls, and editing the ribbon. Participants will learn how to automate work, protect data, import and export data, and utilize new Excel functions. The course aims to enable delegates to handle complex Excel components effectively. Prior knowledge of Excel Level 2 and/or Level 3 is recommended.

This half-day Online Microsoft 365 Forms Training Course is designed for delegates who want to learn how to utilize Forms in Microsoft 365. By the end of the course, students will be able to create forms or quizzes, add questions and branching logic, adjust form settings, share forms, and view responses. The course covers topics such as creating new forms, form settings, sharing forms, and managing form responses. Please note that course content may be updated as Microsoft 365 evolves.