01670 732139 | |
steve@itseasy.co.uk |
https://youtu.be/nH-CFEM2MEU To multiply figures in Excel using the Paste Special feature, you can follow these steps: First, enter the number by which you want to multiply (the multiplier) into any cell and copy it. Then, select the range of cells containing the figures you wish to multiply. Right-click on the selected range and choose ‘Paste
Read More
https://youtu.be/iSKLgDxn7jI Creating your own stencils in Visio can significantly enhance your productivity and efficiency when working on diagrams. Custom stencils allow you to tailor your toolkit to the specific needs of your project, ensuring that all the shapes and symbols you frequently use are readily accessible. This customisation can lead to a more streamlined workflow,
Read More
https://youtu.be/tOaJT4bUzdc To automatically adjust the width of cells in Excel without using VBA, you can utilize the ‘AutoFit’ feature. This feature can be accessed after recording a macro that performs the action of selecting a range of cells and then choosing ‘AutoFit’. Here’s a step-by-step guide: 1. Go to the ‘View’ tab on the Excel
Read More
https://youtu.be/ScI-vYNf2Sc To create a report with grouping in Access, begin by selecting the table or query that contains the data you want to include. Open the Report Wizard, and choose the fields you wish to add to your report. In the ‘Grouping Options’ section, select the field by which you want to group your data.
Read More
https://youtu.be/KjsVenymv0k To utilize the % difference from feature in a pivot table, begin by selecting your pivot table and choosing the value you wish to analyse. Right-click on it and select ‘Show Values As’, then choose ‘% Difference From’. Select the base item that serves as a comparison point. This feature is particularly useful for
Read More
https://youtu.be/YLMlKse0e5Q To utilize the ‘consolidate’ feature in Excel, begin by selecting a cell in a new sheet where you wish the consolidated data to appear. Navigate to the ‘Data’ tab and click on ‘Consolidate’. Choose the function that suits your data analysis needs, such as ‘Sum’ for totalling numbers. Then, add the range of the
Read More
https://youtu.be/l-dB8GVxHZY To animate slides using the animation pane in PowerPoint, start by opening your presentation and selecting the slide you want to animate. Then, go to the “Animations” tab and click on “Animation Pane” to open the sidebar. Choose the object on the slide that you want to animate and click “Add Animation” to select
Read More
https://youtu.be/_9oqH1ADFTk Learn how to create a database in Microsoft Access with this step-by-step tutorial! Follow along as we show you how to easily set up a simple database from scratch. Don’t forget to subscribe for more helpful Access tips and tricks! To create a database in Access, begin by opening Microsoft Access and selecting ‘Blank
Read More
https://youtu.be/n8ZWH4zGvHk – Select the column or range of cells that contain the numbers you want to add a prefix to. – Go to Format – Number – More Formats – Custom number format. – In the dialog box that appears, type the prefix inside double quotes, followed by a zero. For example, if you want
Read More
https://youtu.be/qQrWLPOzfaE Multilevel lists are useful for organizing and presenting information in a hierarchical way. You can create multilevel lists in Microsoft Word by following these steps: 1. Type out your list items, with each item on its own line. You can use any type of list, such as bulleted, numbered, or alphabetized. 2. Select the
Read More
https://youtu.be/Z27kZwrL5II One of the powerful features of Excel is the ability to create Pivot tables from multiple data sources using relationships. Relationships are connections between two tables that have at least one column in common. To create relationships in Excel, you need to use the PowerPivot window, which is an add-in that enhances the data
Read More
https://youtu.be/9sEd1_8qG-U How to use Text functions in Excel. This is a Microsoft Excel tutorial covering text functions. The functions explained in this video are: Left, Right, Len, Find, Search, Mid and Text. Join this channel to get access to perks: https://www.youtube.com/channel/UC1c7NBQ7tjBhPGegvCXid_A/join If you want to support me, check this out: https://www.patreon.com/itseasy Online training courses: Word
Read More
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
“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
“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
“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