What is Microsoft Project. A Project overview

https://youtu.be/68B0c5NJS3I Microsoft Project (MSP) is a project management software developed and sold by Microsoft. It is designed to assist project managers in developing plans, assigning resources to tasks, tracking progress, managing budgets, and analysing workloads. Whether you’re a seasoned project manager or someone new to the role, Microsoft Project provides a powerful, easy-to-use app that

Read More


An Introduction to Microsoft Visio

https://youtu.be/EPf3jXC5HkE Microsoft Visio is a powerful tool for creating professional diagrams and flowcharts. It allows you to transform complex information into visual representations that communicate effectively. Whether you’re working on organization charts, network diagrams, workflows, or home and office plans, Visio can help you simplify and convey your ideas. Here are the three basic steps

Read More


How data validation works in Microsoft Excel

https://youtu.be/DYgqWMEn410 Certainly! Data validation in Excel is a powerful feature that allows you to control the type of data entered into a cell. By setting rules, you can maintain accuracy and consistency in your spreadsheets. Here’s how it works: 1. Select the cell(s) where you want to apply data validation. 2. Go to the Data

Read More


How does Goal Seek work in Excel

https://youtu.be/dytkUe6hMzU Goal Seek is a powerful built-in what-if analysis tool in Microsoft Excel that allows you to simulate the input needed to achieve a specific output. It’s particularly useful when you know the desired value for the output but need to find the correct input value. Here’s how you can use Goal Seek in Excel:

Read More


What is the difference between auto and manual scheduled tasks in Microsoft Project

https://youtu.be/DRMldiOieTg In Microsoft Project, you have two ways of scheduling tasks: manual scheduling and automatic scheduling. Let’s explore the difference between these two approaches: 1. Manual Scheduling: – In manual scheduling, you have the flexibility to set the start dates of individual project tasks according to your preferences. – Microsoft Project doesn’t automatically schedule tasks

Read More


Do you know these hidden features in OneNote?

https://youtu.be/u9HyBp81MWo OneNote is a powerful note-taking app that can help you organize your thoughts, ideas, and projects. But did you know that OneNote also has some hidden features that can make your life easier and more productive? Here are some of them: – Calculator: You can use OneNote as a calculator by typing a simple

Read More


Master Legal Blackline in Word: The Ultimate Guide

https://youtu.be/zoaH0GJu7hY Legal blackline is a feature in Microsoft Word that allows you to compare two documents and see the differences between them. It is useful for lawyers, editors, and anyone who needs to track changes in a document. Here are the steps to do legal blackline in Word: 1. Open the two documents that you

Read More


What is the difference between the FILTER function and XLOOKUP

https://youtu.be/V8CaYOCPcPI The FILTER function and the XLOOKUP function are both useful tools for extracting data from a range or table based on certain criteria. However, they have some key differences that make them suitable for different scenarios. The FILTER function returns an array of values that meet one or more conditions specified by the user.

Read More


How to update Actual hours worked against planned hours worked

https://youtu.be/hiuz0ZvxGeg One of the features of Microsoft Project is the ability to track the progress of your tasks by comparing the actual hours worked against the planned hours. This can help you identify any deviations from the schedule and take corrective actions if needed. To update the actual hours worked in Microsoft Project, you can

Read More


Inner and outer joins what’s that about in Microsoft Access

https://youtu.be/EiEJcwmBBws Relationship types in Microsoft Access are ways of defining how data in one table is related to data in another table. There are three main types of relationships in Access: one-to-many, many-to-many, and one-to-one. – A one-to-many relationship is the most common type of relationship in Access. It means that each record in one

Read More


How to return multiple rows with a VLOOKUP function

https://youtu.be/3vBpNU3_GT0 Return multiple rows with a VLOOKUP function. Step 1 – create a helper column using a COUNTIF function. Step 2 – create a concatenated column as part of the lookup table. Step 3 – create the VLOOKUP using a concatenated lookup value. This process returns multiple items from a list. You could also use

Read More


Return multiple rows of data without using a Lookup function

https://youtu.be/i7Xex3oZhB8 One way to return multiple rows of data without using a Lookup function is to use the filter function. The filter function allows you to specify a range of cells and a condition that determines which rows to return. For example, if you have a table of sales data and you want to return

Read More


How to report on resource allocation across multiple projects

https://youtu.be/sjw7sh3dnMU One of the challenges of managing multiple projects is to ensure that the resources are allocated efficiently and effectively across them. Microsoft Project offers several features and tools to help you create a report that shows the resource allocation across multiple projects. Here are the steps to create such a report: Create a master

Read More


Best way to update a project plan in Microsoft Project

https://youtu.be/Ed80cgrjYxk The tracking Gantt and tracking table in Microsoft Project are useful tools for monitoring the progress of your project and comparing it with the original plan. The tracking Gantt shows the baseline, scheduled, and actual start and finish dates of each task in a graphical format, while the tracking table displays the same information

Read More


This video explains how to use formulas in Word

https://youtu.be/59JKOwXxZys One of the features of Microsoft Word is the ability to insert and calculate formulas in a table. This can be useful for creating invoices, budgets, reports, and other documents that involve numerical data. Here are the steps to use formulas in a table in Word: 1. Create a table by clicking on the

Read More


Create a style in Excel and make it available for multiple files

https://youtu.be/GKOpZh3eUQk A style in Excel is a collection of formatting options that can be applied to a cell or a range of cells. Styles can help you create consistent and attractive worksheets, as well as save time and effort. To create a style in Excel, follow these steps: 1. Select the cell or range of

Read More


This video explains how to use the DROP and Take Functions in Excel

https://youtu.be/jA3LY_7nJ5E The DROP and TAKE functions in Excel are useful for extracting or excluding a portion of an array or range of cells. The syntax for both functions is similar, but they work in opposite ways: =DROP(array, rows, ) =TAKE(array, rows, ) The array argument is the source array or range from which you want

Read More


How to use Concatenation in Microsoft Access Reports

https://youtu.be/yivY-bHsn5Q Concatenation is a process of combining two or more text values into one. In Microsoft Access, you can use an expression that uses the ampersand (&) operator to concatenate text values from different fields or controls in a report. For example, if you have a report that shows the first name and last name

Read More


Mastering Free Slack and Total Slack in MS Project

https://youtu.be/2ry5isw1Hds Free slack and total slack are two concepts that are used in project management to measure the amount of time that a task can be delayed without affecting the project schedule. Free slack is the amount of time that a task can be delayed without delaying the start of any successor tasks. Total slack

Read More


What hand signs mean in different countries

https://youtu.be/JI3WEAj5KpE Hand gestures are a form of nonverbal communication that can convey various meanings and intentions depending on the context and culture. However, the same gesture may have different or even opposite meanings in different countries, which can lead to misunderstandings or even offense. For example, the thumbs-up gesture, which is commonly used to express

Read More


LibreOffice Calc tutorial, formulas and functions

https://youtu.be/zUq4hP6xqGw Sum, average and count are some of the most commonly used functions in LibreOffice Calc. They allow you to perform basic calculations on a range of cells or a single cell. Here is how to use them: – To use the sum function, type =SUM( followed by the range of cells you want to

Read More


How to remove a text string in Microsoft Excel

https://youtu.be/oYk1tRsyRa0 One possible function that you can use in Excel to remove text strings in the middle of a sentence is the REPLACE function. The REPLACE function allows you to specify the position and length of the text that you want to replace with another text. For example, if you have a cell that contains

Read More


What are Bookmarks used for in Microsoft Word

https://youtu.be/NZNs462_Wj4 Bookmarks are a useful feature in Microsoft Word that allow you to mark a specific location or a range of text in your document. You can use bookmarks to create links, cross-references, indexes, tables of contents, and more. Bookmarks can also help you navigate through long documents or jump to important sections. To create

Read More


Change the criteria each time a query runs. Parameter queries

https://youtu.be/cuUNrYeTuOo A parameter query is a type of query that prompts the user for input when it is run. This allows the query to be more flexible and dynamic, as it can adapt to different situations and criteria. To create a parameter query in Access, follow these steps: 1. Open the query that you want

Read More


What is the difference between edays and duration in Microsoft Project

https://youtu.be/_uufsk42-G8 The difference between edays and duration in project management is that edays are the estimated number of days (time elapsed) required to complete a task (including nonworking days), while duration is the actual number of working days (time) that the task takes, (not including non working days). Days are used to plan and schedule

Read More


Create a Project Plan from a Visio Timeline

https://youtu.be/jSIxMlrE57A A project plan is a document that outlines the scope, objectives, deliverables, and resources of a project. It also defines the tasks, milestones, dependencies, and deadlines for each phase of the project. A Visio timeline is a graphical representation of the project schedule that shows the start and end dates of each task, as

Read More


How to use the Team Planner in Microsoft Project

https://youtu.be/MY6vQcl2LD0 The team planner is a feature in Microsoft Project that allows you to assign and manage resources for your project tasks. You can use the team planner to view the availability and workload of your team members, drag and drop tasks to assign them to different resources, and resolve any overallocation or scheduling conflicts.

Read More


How to create simple measures in Power BI

https://youtu.be/awLF4Gom-ug How to create simple measures in Power BI Measures are calculations that you can use to analyse your data in Power BI. They are dynamic and can change depending on the context of your report or dashboard. For example, you can create a measure that calculates the total sales for each product category, and

Read More


How to combine tables in Microsoft Excel, using Power Query

https://youtu.be/6fDy5VMTK7U If you want to combine tables in Microsoft Excel, you can use Power Query to merge or append them. Power Query is a data transformation and analysis tool that allows you to connect to different sources of data, apply filters and transformations, and create queries. To use Power Query, you need to have Excel

Read More


How to use linked notes in Microsoft Word. OneNote

https://youtu.be/kwHwmmixWKI Linked notes are a feature in Microsoft Word that allows you to link your notes to a Word document, a PowerPoint presentation or another OneNote page. Linked notes help you keep track of the source of your information and easily switch between your notes and the original content. To use linked notes, follow these

Read More


Use calculated fields in Access. HR database part 5

https://youtu.be/tAEUGYAUaLw In Microsoft Access, tables are the basic objects that store data. However, sometimes you may want to perform calculations on the data in the tables, such as adding, subtracting, multiplying, or dividing values. For example, you may want to calculate the total price of an order by multiplying the quantity and the unit price

Read More


How to create a validation lists that automatically grows in Excel

https://youtu.be/qZR7XaIf8Bk A validation list is a feature in Excel that allows you to restrict the values that can be entered in a cell and provide a drop-down list of options for the user. A validation list can be useful for data entry, data validation, and data analysis. However, a validation list can also be problematic

Read More


How to link and automatically update Excel charts into Visio

https://youtu.be/-sI3D4Ajyfc If you want to create diagrams or flowcharts in Visio that are based on data from Excel, you can link and automatically update Excel charts into Visio. This way, you can ensure that your diagrams always reflect the latest information from your data source. Here are the steps to follow: 1. In Excel, select

Read More


How to paste a list into a SmartArt diagram, using Excel or Word

https://youtu.be/ps8-9jWMEs0 A SmartArt diagram is a graphical way of presenting information in a PowerPoint, Word, or Excel. You can use a SmartArt diagram to show relationships, processes, hierarchies, cycles, or lists. To add a list into a SmartArt diagram, you need to follow these steps: 1. On the Insert tab, click SmartArt in the Illustrations

Read More


How to create a simple HR database part 4 using forms

https://youtu.be/iV0FFrG3y58 In this tutorial, we will learn how to create a simple HR database part 4 using forms. Forms are a convenient way to enter, edit, and view data in a database. They can also provide validation, navigation, and formatting features to enhance the user experience. To create a form, we need to have a

Read More


How to work with a split screen in Microsoft Project

https://youtu.be/I7RJTX1Ir_I If you want to work with a split screen in Microsoft Project, you can follow these steps: – On the View tab, in the Split view group, select the Details check box. Next to the check box, pick the view you want for the bottom half of the screen. For example, you can choose

Read More


5 really cool tips that you must know in Excel

https://youtu.be/puMnD3krtR8 Excel is a powerful and versatile tool that can help you organize, analyse and present data in various ways. However, many users are not aware of some of the hidden features and tricks that can make their work easier and more efficient. Here are five really cool tips that you must know in Excel:

Read More


How to create a relationship between two Microsoft Access tables

https://youtu.be/wbVEo1BXL8U A relationship in Access is a connection between two tables that defines how the data in those tables are related. Creating a relationship can help you ensure data integrity, enforce referential integrity, and perform queries that combine data from multiple tables. To create a relationship in Access, follow these steps: – Open the database

Read More


How to create a HR database in Miicrosoft Access part 2

https://youtu.be/EQeB2sifEjs A lookup list is a feature in Microsoft Access that allows you to select a value from a predefined list of choices, rather than typing it manually. This can help you save time, ensure data consistency, and avoid spelling errors. To create a lookup list in a Microsoft Access table, follow these steps: 1.

Read More


Add an image and scale it in a Microsoft PowerPoint chart.

https://youtu.be/PcKHQbxfBWk To add an image into the background of a chart in PowerPoint, you need to follow these steps: 1. Select the chart that you want to modify. You can do this by clicking on it or using the arrow keys to navigate to it. 2. Go to the Format tab under Chart Tools on

Read More


How to create a simple HR database in Microsoft Access part 1

https://youtu.be/nGGQtO0hOMY This is an Access database tutorial covering how to create a simple HR database. One of the ways to create a table in Access is using the table design view. This view allows you to define the fields, data types, and properties of your table. To create a table in Access using table design,

Read More


Find, Match, and Arrange Data with Precision in Excel

https://youtu.be/32dXyLa56aM This is a Microsoft Excel tutorial, covering how to find a record in one column, sort it and match it with the same record details in a second column. In this video the tutor uses the MATCH function and custom sort. The tutor starts off by using the MATCH function to check whether an

Read More


How to create your own slicer and group it with a Pivot chart.

https://youtu.be/rb4lfWzyyTY This is a Microsoft Excel tutorial covering Pivot tables and how to create your own slicer and group it with a Pivot chart. A slicer is a tool that allows you to filter data in a PivotTable or PivotChart. You can create your own slicer and group it with a PivotChart by following these

Read More


Format Resource usage or Task usage views in Microsoft Project

https://youtu.be/bcmTTzuu8I8 The Resource usage or Task usage views in Microsoft Project are useful for displaying the work and cost information for each resource or task in your project. You can format these views to customize their appearance and show the data that is most relevant to your needs. Here are some steps to format these

Read More


Fed up of formatting a Gantt chart? Change the default Gantt view

https://youtu.be/WzSHDOx3bm4 This is a Microsoft Project tutorial covering how to change the default Gantt chart view. By changing the default Gantt view, you can customize how your project tasks are displayed and organized. You can also create your own Gantt views by using the View Definition dialog box. Step 1 – Change the Gantt chart

Read More


How to Email directly from Excel adding subject and body text.

https://youtu.be/MaR2aiDEtfI One of the ways to create a link that opens an email client is to use the hyperlink function with mailto. The mailto protocol allows you to specify the recipient, subject, and body of the email in the URL of the link. For example, if you want to create a link that opens an

Read More


How to create an automatic calendar in Microsoft Excel

https://youtu.be/r25NHGmKezA This is a Microsoft Excel tutorial on how to create an automatic calendar. The tutor uses the Sequence function, with Date, Month and Year functions to achieve an automatic calendar. The tutor uses conditional formatting to highlight each month and shade dates out of the calendar range. How to create an automatic calendar in

Read More


How to add a logo background page to a Visio diagram

https://youtu.be/0N0Ey37NGFc This is a Microsoft Visio tutorial covering, how to add your own logo page and set it as a background page so that it appears on every page within your diagram. The tutor starts off by demonstrating how a background page works. The tutor then creates a separate background page and attaches it to

Read More


Use budget cost resources in Microsoft Project to allocate a budget

https://youtu.be/zFfEf7hm-Io One of the features of Microsoft Project is the ability to manage budget resources for your project. Budget resources are cost values that you assign to the project summary task to represent the planned budget for your project. You can use budget resources to compare the planned budget with the actual cost and work

Read More


How to create a flow chart using LibreOffice Draw

https://youtu.be/SK6wK71_6oM To create a flowchart in LibreOffice Draw, follow these steps: – Open LibreOffice Draw and create a new document. – From the menu, click View – Toolbars – Drawing to enable the drawing toolbar. – From the left pane of the drawing toolbar, click on the Flowchart icon to display the flowchart shapes. –

Read More


How to control multiple Pivot tables from one Slicer and one timeline

https://youtu.be/lZSJi4TAHKU Use report connections to link your slicer and timeline to multiple Pivot tables. This is a Microsoft Excel tutorial covering, how to control multiple Pivot tables from one Slicer and one timeline. The tutor starts off by creating a Pivot table and then copies the Pivot table three times, changing the columns and row

Read More


How to generate multiple folders from a list in Excel in seconds.

https://youtu.be/8PkOn0xRTEo Create a simple list in Excel and use the concatenate feature to link the folder names to a MD text string. Copy all the concatenated data into a text document and rename it as a .bat file. Run the .bat file, all the folders are generated. How to generate multiple folders from a list

Read More


Microsoft PowerPoint Jaw-Dropping Video Effects Inside Text Boxes

https://youtu.be/nNoE-e4V-a0 If you want to create stunning presentations that will impress your audience, you need to learn how to use video effects inside text boxes in Microsoft PowerPoint. Video effects are animations that can make your text look more dynamic and engaging. You can apply video effects to any text box, whether it’s a title,

Read More


How to add option buttons in Microsoft Excel without VBA

https://youtu.be/sderAtPfl3A One way to create option buttons in Microsoft Excel without using VBA is to use the Form Controls feature. Option buttons, also known as radio buttons, allow the user to select one option from a group of choices. To create option buttons in Excel, follow these steps: 1. Go to the Developer tab on

Read More


Use rules in Mail merge to add different text. Word mail merge

https://youtu.be/cR6Fta8d-D4 If you want to create a mail merge document that contains different text or formatting depending on the data source, you can use the If Then Else field. This field allows you to specify a condition and what to do if the condition is true or false. For example, you can use this field

Read More


How to save a theme and set it as default in Microsoft PowerPoint

https://youtu.be/-It9ssZ3_rM This is a Microsoft PowerPoint tutorial covering how to create a theme, save it and set it as a default theme. There are two main ways to create a theme. The first method involves creating new colours and fonts within the Slide master view. The colour and fonts will be displayed in slide master

Read More


This video explains how to use text styles in Microsoft Project

https://youtu.be/bE9bXC0dKhk This is a Microsoft Project tutorial covering how to use Text styles. Text styles are a way to apply consistent formatting to different elements of your project, such as tasks, milestones, summary tasks, and resources. You can use text styles to change the font, size, colour, and alignment of the text in your project

Read More


This video explains how to use the navigation pane in Microsoft Word

https://youtu.be/dnw-KfIP6oM The navigation pane in Word is a useful tool that allows you to quickly navigate through your document, find text or objects, and reorganize your headings. Here is how to use it: – To open the navigation pane, press Ctrl+F, or select the View tab and choose Navigation Pane . – To browse by

Read More


How to use tab controls in Microsoft Access forms

https://youtu.be/MTTebSlgkV4 Microsoft Access tutorial covering Tab controls. Tab controls are useful for organizing the information on a form. They allow you to create multiple pages within a single form, each with its own set of controls. To use tab controls in Microsoft Access forms, follow these steps: 1. Open the form in Design View and

Read More


How to use basic functions in LibreOffice Calc

https://youtu.be/WKxnmxhzIrE The sum, average, max and min functions are some of the most commonly used functions in LibreOffice Calc. They allow you to perform basic calculations on a range of cells. Here is how to use them: – To use the sum function, which adds up all the numbers in a range, type =SUM(range) in

Read More


Mastering Microsoft Visio: Revealing the Key Diagrams

https://youtu.be/8KHCUlG4YvU Microsoft Visio is a powerful tool for creating diagrams, such as flowcharts, organisation charts and Gantt charts. Here are some steps to help you get started with these types of diagrams: – To create a flowchart, open Visio and select the Flowchart category. Choose a template that suits your needs, such as Basic Flowchart

Read More


How to use the sort and take functions to rank a list in Excel

https://youtu.be/bmSDh4jZfkc One way to rank a list in Excel is to use the sort and take functions. The sort function can arrange the values in a list in ascending or descending order, based on one or more criteria. The take function can extract a specified number of values from a list, starting from the top

Read More


How to set priorities in Microsoft Project

https://youtu.be/xM3xImsLZXw Priority is a feature in Project that allows you to assign a numerical value to each task, indicating how important or urgent it is. Priority can help you to plan and manage your project more effectively, by highlighting the tasks that need your attention the most. You can use priority to sort, filter, group,

Read More


How to connect a flowchart in Microsoft Word, use the drawing canvas

https://youtu.be/FokWGHgJDJk The drawing canvas is a feature in Microsoft Word that allows you to create and manipulate shapes, diagrams, and other graphics. You can use the drawing canvas to organize your drawings, group them, and apply effects to them. To use the drawing canvas, follow these steps: 1. On the Insert tab, in the Illustrations

Read More


How to use the Stack and scale feature in an Excel Chart

https://youtu.be/w0vX3lhGVc4 To use stack and scale in an Excel column chart, you need to format the data series in a specific way. First, you need to select the data series that you want to stack and scale. Then, right-click on the series and choose Format Data Series from the context menu. In the Format Data

Read More


How to create a PowerPoint presentation from a Word document

https://youtu.be/UiHa3aUYm6I If you want to create a PowerPoint presentation from a Word document, you can use the Send to PowerPoint feature. This feature allows you to send the heading styles in your Word document to PowerPoint and create slides from them. Here are the steps to use this feature: 1. Open your Word document and

Read More


What are Presentation views in Microsoft PowerPoint

https://youtu.be/BhDdKRd7kL4 Presentation views are different ways of displaying a PowerPoint presentation on your computer screen or a projector. They allow you to edit, rehearse, and present your slides in different modes. There are seven presentation views in PowerPoint: – Normal view: This is the default view where you can create and edit your slides. You

Read More


All you need to know about using text boxes in Microsoft Visio

https://youtu.be/Gdoz442ZCrM This is a Microsoft Visio tutorial on how to use Text Boxes. Text boxes are useful for adding text to a Visio drawing that is not part of a shape or connector. You can use text boxes to label diagrams, provide instructions, or create captions. To create a text box in Visio, follow these

Read More


Link and automatically update Excel and Project data

https://youtu.be/oWrZfB_nEr4 One way to link and automatically update Excel and Project data is to use the Paste Special command. This allows you to create a dynamic link between the two applications, so that any changes made in Excel are reflected in Project. Here are the steps to follow: 1. In Excel, select the range of

Read More


Use option groups to automatically populate tables in Microsoft Access

https://youtu.be/D0lJgU34PTE Option groups are useful for creating multiple choice questions or selecting one option from a list of alternatives in Microsoft Access forms. To create an option group, you need to follow these steps: 1. Open the form in Design View and click on the Option Group tool in the Controls group on the Design

Read More


This video explains how to Merge Two Documents in Microsoft Word

https://youtu.be/SRuIzsUKjuE One of the features of Microsoft Word is the ability to combine two or more documents into one. This can be useful for merging different versions of a document, or for creating a new document from existing ones. Here are the steps to combine two documents in Microsoft Word: 1. Open the first document

Read More


Three different ways to insert files into a Microsoft Access database

https://youtu.be/dywZIfpcreU There are different ways to insert files in Microsoft Access, depending on the type and size of the file, and the purpose of storing it. Here are some common methods: – Embedding: This method allows you to insert a file as an OLE object, which means it can be edited using the application that

Read More


How to Use OneNote for Effective Project Management

https://youtu.be/X77lBXDhDoQ OneNote is a powerful tool for organizing and managing your projects. In this video, you will learn how to use OneNote to create project notebooks, add notes, tasks, files, and links, and collaborate with your team members. You will also discover some tips and tricks to make your project management more efficient and productive

Read More


How to share a Visio Online diagram with a colleague

https://youtu.be/4susQLFxyOI Hello and welcome to this video tutorial on how to share a Visio diagram with a colleague. Visio is a powerful tool that allows you to create and edit diagrams of various types, such as flowcharts, org charts, network diagrams, and more. In this video, I will show you how to share your Visio

Read More


How to create an interactive doughnut chart in Microsoft Excel

https://youtu.be/VfDfgPdVR74 A doughnut chart is a type of circular chart that shows the relative proportions of different categories of data. It is similar to a pie chart, but it has a hole in the centre, which makes it look like a doughnut. A doughnut chart can be used to compare the parts of a whole,

Read More


How groups work in Outlook online. Create, manage and delete a group

https://youtu.be/ElevePYefDE Groups in Outlook are a feature that allows you to create and join online communities of people who share common interests, goals, or projects. You can use groups to communicate with other members, share files and calendars, collaborate on documents, and more. Groups are different from distribution lists or contact groups in that they

Read More


How to add an assignment delay in Microsoft Project

https://youtu.be/Dzuf4ZUk0K0 An assignment delay in Microsoft Project is the amount of time a resource is to wait before starting work on an assignment. It is calculated as the difference between the assignment start date and the task start date. For example, if a task starts on Monday and lasts for 5 days, but a resource

Read More


How to Personalise Your Microsoft Word Experience

https://youtu.be/IJGoIW9ZNIw In this video, you will learn how to customise the ribbon, create shortcuts and customise the quick access toolbar in Microsoft Word. These features will help you to access the commands and functions that you use most frequently and efficiently. The ribbon is the horizontal strip at the top of the Word window that

Read More


How to Use PowerPoint Live for Effective Presentations

https://youtu.be/dDTP-3JRHC4 In this video, you will learn how to use PowerPoint live, a feature that allows you to present your slides online with interactive tools and audience feedback. You will discover how to create a live session, share it with your viewers, and manage the presentation settings. You will also see how to use features

Read More


How to use formulas in SharePoint lists

https://youtu.be/vHrIuoWdBMk In this video, you will learn how to use formulas in a SharePoint list to perform calculations, validations, and transformations on your data. Formulas are expressions that use operators, functions, and references to columns and values to produce a result. You can use formulas in calculated columns, validation settings, and default values. For example,

Read More


How to Import and Normalize Excel Data into Microsoft Access

https://youtu.be/Xi0nkCf2S6A In this video, you will learn how to import Excel data into Access and normalize it. Importing data from Excel is a common task for database developers and administrators, as it allows you to transfer data from spreadsheets to relational tables. Normalizing data is the process of organizing the data into a consistent and

Read More


How to Use a Parameter Query in LibreOffice Base

https://youtu.be/FJJoW-pKvW4 A parameter query is a type of query that prompts the user for a value or a condition before running. This can be useful when you want to filter or limit the data based on a variable criterion. For example, you can use a parameter query to find all the records that match a

Read More


Create an organisational chart in seconds, use Visio.

https://youtu.be/Pjxb8doRbjA Create an organisation chart structure in seconds. Drag and drop shapes to quickly build up your organisational chart. @ITsEasyTraining1st

Read More


How to Integrate Power Bi into Your PowerPoint Slides

https://youtu.be/f8Jn7UIrNRE Power BI is a powerful tool for creating interactive and dynamic dashboards and reports. But did you know that you can also use Power BI to enhance your PowerPoint presentations? In this video, I will show you how to embed Power BI visuals into your PowerPoint slides, how to update them automatically, and how

Read More


How to Convert Text into a Table in Microsoft Word

https://youtu.be/MNoS97EfUgc If you have a list of data or information that you want to organize in a table, you don’t have to create the table manually. You can use a simple feature in Microsoft Word that allows you to convert text into a table in just a few steps. In this video, I will show

Read More


How to Automate Your Excel Tasks with Office Scripts: A Guide for Beginners

https://youtu.be/LXCgHAUcgEU If you want to save time and improve your productivity in Excel, you might want to learn how to use Office Scripts. Office Scripts are a new feature that lets you record and run macros in Excel. With Office Scripts, you can automate repetitive tasks, such as formatting data, creating charts, or sending reports.

Read More


How to Combine Text Fields in Microsoft Access Reports

https://youtu.be/un_3C1kXI0Q In this video, you will learn how to use concatenation in Microsoft Access reports. Concatenation is the process of joining two or more text values together to create a single text value. For example, you can concatenate the first name and last name fields to display the full name of a person. Concatenation can

Read More


Meet Microsoft Bing chat AI: your personal assistant for online queries

https://youtu.be/rBck4gC91jk In this video, we will introduce you to the Microsoft Bing chat AI, a powerful and versatile chat mode that can help you with various tasks and queries. We will show you how to use the Bing chat AI in different modes, such as Balanced, Creative and Precise, and how to switch between them

Read More


How to Link unrelated tasks in Microsoft Project, Hammock Tasks

https://youtu.be/bQrPj-FkPcI Hammock Tasks. Sometimes, you may want to link two tasks that are not directly related, but depend on the same external factor. For example, you may have a task that represents the duration of a contract, and another task that represents the payment of a milestone. These two tasks are not related in terms

Read More


Do you know how to Automatically update a list?

https://youtu.be/kPWzMNe9RrM Use dynamic lists in Excel. Automatically updating lists. This is a Microsoft Excel tutorial covering how to automatically update lists. The tutor starts off by demonstrating how a data validation list does not automatically update when new items are added. The tutor covers how to format a list as a table and explains how

Read More


Excel Image Lookup Made Simple: Boost Your Data Analysis Skills

https://youtu.be/-7MrHwPlEc0 Use XLOOKUP to pull images into your data set. This is a Microsoft Excel tutorial covering how to look up and pull images into a data set. The tutor starts off by creating a list of country using the Geography feature. The tutor then formats the data as a table. The tutor then uses

Read More


Quickly combine data from multiple sheets into one place

https://youtu.be/Te0uVTN3Z04 This is a Google Sheets tutorial covering the VSTACK function. Quickly combine data from multiple sheets into one place. The tutor starts off by adding data sets together from the same sheet using the VSTACK function. The tutor moves on to use the VSTACK function across multiple sheets. The final part of the video

Read More


Unlocking Microsoft Access: Create a Basic Sales Database

https://youtu.be/AZ8qIvaPaOc Get started with Microsoft Access and create a simple database. This is a Microsoft Access tutorial covering step by step instructions on how to create a Microsoft Access sales database. The tutor starts off by creating three related tables, a customer, a product, and sales table. The tutor uses primary keys to relate the

Read More


Get started with a database use LibreOffice Base database

https://youtu.be/MvbKjfME0gY Create a simple database using LibreOffice Base database. Learn how to create tables and set data types. Use LibreOffice and start your journey developing a database. In a Base database you can have tables queries, forms, and reports. The Reports feature uses Writer. Get started with a database use LibreOffice Base database. This is

Read More


Reveal a floor plan layer by layer. Use Layers in Microsoft Visio

https://youtu.be/A3e7Od7b_7o Discover the value of layering a floor plan or Visio diagram. This is a Microsoft Visio tutorial covering how to create and hide layers. The tutor starts off by creating a floor plan diagram and adding four layers of shapes. The tutor explains that you can create a layer that captures many sub-layers, but

Read More


Create an organisation chart by just pasting a list. Magic trick!!

https://youtu.be/4KEWaO_8TXM This is a Microsoft Word tutorial covering how to paste a list of names into an organisation chart. The tutor creates a basic hierarchy chart using SmartArt. The tutor demonstrates how to add text and create new boxes. The tutor the repeats then process but removes all the default shapes except one. The tutor

Read More


Add cool charts to an Access database, use charts in reports

https://youtu.be/ZkwM3SCaXqw This is a Microsoft Access tutorial covering how to add a chart to a report. The tutor starts off by creating a blank report and adding a modern chart to the report design. Chart design features appear on the right side of the screen. Users can add elements to the chart and change formatting.

Read More


New function, combine data from multiple sources. Update automatically

https://youtu.be/_uDDbfpix0g This is a Microsoft Excel tutorial covering how to combine data from multiple sources. The function used is the new VSTACK function. The function enables users to combine data from the same sheet, different sheets, and different files. The result is that all the data combines on to one sheet. The tutor captures sales

Read More


Do you understand task types and how they work in Microsoft Project

https://youtu.be/mMm6qtUlSi0 This is a Microsoft Project tutorial covering task types. Do you understand task types and how they work? There are three task types in Microsoft Project, Fixed units (default), Fixed Duration and Fixed Work. Fixed Units and Fixed Duration tasks have an option to use the effort driven feature. The fixed work task type

Read More


Want to get country stats? Use Geography in Microsoft Excel

https://youtu.be/E0CXPHvexBM In this video, we’re going to show you how to use the Geography feature in Microsoft Excel to get world stats. This is a great way to learn about different countries and their populations, and to see how the world is changing over time. We’ll show you how to get world stats in Microsoft

Read More


Testimonials


“The course was really thorough and Steve was very knowledgeable and explained things very well. I’ve not used Microsoft Project before but now I feel very confident that I’ll be able to use it for what I need to do in my job”.

Craig Forster
Estimator, John F Hunt Regeneration Ltd




“I studied with Steve when we completed our CiPD CTP together. During the course I found Steve to be very personable and also very professional.  Steve was first on my list of suppliers. Steve was very competitively priced and very accommodating.”

Simon Snowdon
European Training Manager at HP Enterprise Services




“Steve’s background in IT training clearly provided him with great organisational and managerial skills which he put to good use at Second Chance Enterprises. His ability to see the long term strategy as well as manage the day to day management is one of his biggest strengths.”

Chriss Graham
Project Coordinator at Daisy Group




“Steve delivered a number of Microsoft Office Training Sessions to a range of employees across Newcastle College. The service provided by Steve is second to none. I have no hesitations in recommending him to other employers.”

Christine Jackman
Learning Manager(North) - Winner of Training Programme of the Year NECCA