MS Office 2016

This online Excel training course focuses on teaching advanced formulas and functions. Participants will learn to create complex formulas by nesting functions, use VLOOKUP and XLOOKUP, and work with Named Ranges for formula creation and workbook navigation. Prerequisites include a good understanding of formulas or attendance at a previous course. The course runs for 3 hours with morning and afternoon sessions, including a 15-minute break.

This online Microsoft 365 Planner Training Course is designed for delegates who want to effectively use Planner in Microsoft 365. The course covers creating plans, adding/removing members, creating to-do lists, buckets, and tasks, working with boards and cards, copying or exporting plans, and viewing task statuses. It also includes an overview of Planner benefits, interface, creating plans, adding buckets and tasks, working with boards and cards, exporting plans, and Planner settings. The course aims to equip students with the necessary skills to utilize Planner efficiently.

This one-day virtual Microsoft Project training course is designed for project team members or managers to understand basic project management principles, planning, resource management, and reporting. Participants should have basic Windows knowledge and familiarity with Microsoft Office applications. The course covers project management basics, task planning, resource management, calendars, project views, and delivering project plans. Key objectives include starting a project, adding tasks and dependencies, working with resources, and reporting project progress.

This half-day Online Microsoft 365 Forms Training course is designed for delegates who want to learn how to use Forms in Microsoft 365. Participants will learn to create forms and quizzes, add questions, apply branching logic, adjust form settings, share forms, and view responses. Prior knowledge of using a keyboard and mouse, Microsoft Office, an internet browser, and Microsoft 365 is required. 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.

The Online Excel 2016 Training is a one-day virtual course focusing on advanced Excel skills. The course aims to enable participants to explore complex Excel 2016 components for better data manipulation. Targeted at individuals seeking advanced Excel data skills, the course covers creating and using macros, collaborating and analyzing data, creating form controls, and editing the ribbon. Prerequisites include Excel 2016 Level 2 and/or Level 3 knowledge. Topics include macro creation, data analysis, import/export functions, and editing the ribbon interface.

This one-day online Microsoft Excel 2016 training course focuses on enabling participants to explore advanced features of Excel, such as advanced formulas, data validation, auditing tools, PivotTables, illustrations, and templates. The course aims to enhance the manipulation of data within Excel 2016. Targeted at individuals seeking a deeper understanding of Excel 2016, it requires prior completion of Excel 2016 Level 1 and/or Level 2 courses or equivalent knowledge. The course covers topics like data validation, advanced formulas, auditing worksheets, creating PivotTables, working with templates, and inserting illustrations.

The Online MS Excel Training is a one-day course focusing on advanced Excel 2016 features to manipulate and analyze data effectively. The course aims to enhance delegates' skills in using advanced functions, creating charts, sorting, filtering, and applying conditional formatting. Prerequisites include basic Excel knowledge or completion of Excel 2016 Level 1. Objectives include using advanced formulas, organizing data, creating charts, sorting and filtering, and applying conditional formatting techniques. The course covers topics such as working with range names, logical functions, charts, data analysis, Excel tables, and conditional formatting.

This one-day online Microsoft Excel training course focuses on creating and editing basic Excel 2016 worksheets and workbooks. The aim is to enable participants to understand Excel components and use formulas effectively. Targeted at individuals needing fundamental Excel 2016 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.