Get CHAP GPT for Word and Excel – step by step tutorial

https://youtu.be/LTJW-7eAXAo Get ready to supercharge your Word and Excel skills with CHAP GPT – the ultimate tutorial you’ve been waiting for! In this tutorial, you will learn how to get CHAP GPT for Word and Excel in a step-by-step guide. CHAP GPT is a powerful tool that can enhance your productivity and efficiency when working

Read More


Microsoft project tutorial -Visually display overspend

https://youtu.be/_yz5CKQCebA I’ve cracked the code on how to visually spot overspending in Microsoft Project 2024 like a pro! In this Microsoft Project tutorial, learn how to effectively visually display overspend in your project plan. Follow along with the step-by-step guide to efficiently track and manage overspending to ensure the success of your project. Don’t let

Read More


PowerPoint Overview in less than 20 minutes. 2024

https://youtu.be/KO9lktpStFw Get ready to master PowerPoint like a pro in just 20 minutes – you won’t believe how easy it is! In this PowerPoint tutorial, we will provide a comprehensive overview of the key features and functionalities of PowerPoint in under 20 minutes. Whether you are a beginner looking to learn the basics or an

Read More


Transform Your Data Analysis with Pro Pivot Tips

https://youtu.be/KxzYw4AtwSs Boost your data analysis skills to the next level with these game-changing pivot tips! Learn how to use calculations, group data, create reports and add conditional formatting to your Pivot Table. Learn how to take your data analysis to the next level with these professional pivot tips! In this video, we will show you

Read More


How to add a search box to a Microsoft Access Form 2024

https://youtu.be/Vi0DTuhuGl8 Say goodbye to endless scrolling in Microsoft Access – I’ll show you how to easily add a search box to your form in 2024! Learn how to easily add a search box to a Microsoft Access form in 2024 with this step-by-step tutorial. This video will guide you through the process of creating a

Read More


Master Microsoft Excel Functions for Beginners!

https://youtu.be/uByGfzm-94g I’ll teach you the top Excel functions every beginner needs to know to become a spreadsheet pro in no time! In this tutorial, we will cover the essential and common functions in Microsoft Excel that every beginner should know. Learn how to use functions like SUM, SUMIF, SUMIFS, AVERAGE, AVEERAGEIF, AVERAGEIFS and more to

Read More


Excel tutorial for beginners – Easy Steps

https://youtu.be/iAtDyZ-eGXs Welcome to this beginners guide to using Microsoft Excel. In this guide you will learn how to format an Excel spreadsheet and create simple formulae. The tutor covers how to quickly add data, fill cells and some great shortcut tips. Excel tutorial for beginners – Easy Steps. Microsoft Excel tutorial. #msexcel #excel Join this

Read More


How to create a database FULL COURSE

https://youtu.be/Z_TbeUeFppc Uncover the secrets of Microsoft Access in this step-by-step tutorial. The tutor covers how to design a database, create tables and queries, format forms and reports. At the end of the tutorial the whole database is automated with simple macros. this is a Microsoft Access tutorial. The tutorial is for NEW USERS. How to

Read More


How to MAIL MERGE in Microsoft Word – NEW USER

https://youtu.be/wBdjlhxSgjE Getting to grips with mail merge. Simple steps for NEW USERS. This is a Microsoft Word tutorial covering mail merge. The tutor starts off by explaining how mail merge works and demonstrating using a data source created in Word. the tutor goes on to cover how to use a data source from and Access

Read More


Microsoft Visio – NEW USER

https://youtu.be/WsjIoDAxF6Y Basic concept of Microsoft Visio. This video is for NEW USERS. The tutorial covers basic concepts to get you started with Microsoft Visio. The tutor covers basic shapes, layers, background pages, stencils and a quick look at a flow chart. Microsoft Visio tutorial. #msvisio Join this channel to get access to perks: https://www.youtube.com/channel/UC1c7NBQ7tjBhPGegvCXid_A/join If

Read More


Microsoft Project: Understanding Spending Patterns

https://youtu.be/bk5eXQIzdqs I’ll show you the quickest and easiest way to calculate project costs in Microsoft Project – and it only takes 10 minutes! Learn how to easily calculate costs in Microsoft Project in under 10 minutes with this step-by-step tutorial. Discover efficient ways to track and manage cost spend within your project using Microsoft Project.

Read More


Tick Box in Google Sheets – Everything you need to know!

https://youtu.be/_y5KefMNbzQ I’ll show you how mastering the tick box feature in Google Sheets can skyrocket your productivity! In this tutorial, you will learn everything you need to know about using the Tick Box feature in Google Sheets. From setting up Tick Boxes to customizing them for your specific needs, this video will guide you through

Read More


Quickly enter data with FILL SERIES in Excel

https://youtu.be/AWlAO50WKvU Say goodbye to slow data entry in Excel – learn how to fill series effortlessly and boost your productivity! Learn how to efficiently fill series in Excel for fast and accurate data entry with this step-by-step tutorial. By using the Fill Series feature, you can quickly populate cells with a sequence of numbers, dates,

Read More


Create Relationship, Lookups, Forms, and Reports in Access like a Pro

https://youtu.be/DbQSY2_FxEM Master Access and create professional relationships, lookups, forms, and reports like a true expert – it’s easier than you think! Learn how to master creating relationships, lookups, forms, and reports in Microsoft Access like a pro with this in-depth tutorial. Whether you are a beginner or looking to enhance your skills, this video will

Read More


Format Your Word Docs FAST with These Time Saving Tips!

https://youtu.be/W5339zM8YP4 Say goodbye to endless formatting struggles – these tips will have your Word docs looking polished in minutes! Learn how to format your Word documents quickly with these time-saving tips! In this video, we’ll show you efficient ways to format your documents in Microsoft Word, helping you save time and work more effectively. Whether

Read More


How to Sum Filtered Data in Excel (Step-by-Step Tutorial)

https://youtu.be/zEh_0mBliA0 I’ll show you the easiest way to sum your filtered data in Excel, no more headaches with this step-by-step tutorial! In this step-by-step tutorial, you will learn how to sum filtered data in Excel. Whether you are a beginner or advanced user, this tutorial will guide you through the process of totalling filtered data

Read More


How to Make a Database in LibreOffice for Beginners in 2024

https://youtu.be/t_8m-yAq0YE Creating your first database in LibreOffice is way easier than you think – even if you’re a complete newbie! In this tutorial, learn how to create a Base database using LibreOffice for beginners in 2024. Follow step-by-step instructions to set up a database, create tables, input data, and run queries within LibreOffice. Whether you’re

Read More


How to Add Shape Data and Data Graphics in Visio (2024)

https://youtu.be/JgCuY0MPRII I’ll show you the easiest way to level up your Visio diagrams with shape data and data graphics! Learn how to add shape data and data graphics in Visio with this step-by-step tutorial. Whether you are a beginner or looking to enhance your skills, this video will guide you through the process of incorporating

Read More


How to link or embed files into Microsoft Project

https://youtu.be/AxEsYHnU7CA Say goodbye to confusion – I’ll show you the quickest and easiest way to add files to Microsoft Project! Learn how to quickly and easily add files to Microsoft Project in this step-by-step tutorial. Whether you want to link or embed files into your project for easy access, this video will guide you through

Read More


Excel Hack: Prevent Anyone From Deleting Your Protected Sheets

https://youtu.be/ilbpjZ9OtOM Say goodbye to accidental sheet deletions in Excel with this simple hack – your protected sheets will be safe forever! Learn a simple Excel hack to prevent anyone from deleting your protected sheets. This easy tutorial will show you the steps to safeguard your important data and keep it secure from unwanted changes. Never

Read More


Animate Excel Data in PowerPoint Like a Pro! [Excel Animation Tutorial]

https://youtu.be/p9B0VhvS8ig I’ll show you how to bring your boring Excel charts to life in PowerPoint like a pro! Learn how to animate Excel data in PowerPoint like a pro with this step-by-step tutorial! In this video, we will show you how to bring your boring Excel charts to life by adding animations in PowerPoint. Watch

Read More


How to compare two lists from different files in Excel

https://youtu.be/XgyDaf0s9V0 Say goodbye to manual comparison! I’ll show you how to compare two lists from different Excel files in under a minute! Learn how to easily compare two lists from different files in Excel with this step-by-step tutorial. Whether you’re looking to identify matching or unique values, this video will guide you through the process

Read More


Where Does Microsoft Teams REALLY Store Your Files?

https://youtu.be/UeF9p12nY6c I know the secret location where Microsoft Teams hides all your files, and it’s mind-blowing!. Are you curious about where Microsoft Teams actually stores files? In this video, we will explore and explain where your files are stored when using Microsoft Teams. Understanding the storage location can help you better manage and access your

Read More


Create a Database in Microsoft Access for Beginners in 2024

https://youtu.be/J0C-TmLdfTg Watch me guide you through creating a Microsoft Access database with simple steps even beginners can nail! In this easy step-by-step tutorial, beginners will learn how to create a Microsoft Access database from scratch. Whether you’re new to databases or just starting out with Microsoft Access, this video will guide you through the process

Read More


Dynamic Appointment Calendar in Excel – No VBA Needed!

https://youtu.be/BbXnnZDfdqA Say goodbye to complicated scheduling tools, Excel’s dynamic appointment calendar will revolutionize your organization game! Learn how to create a dynamic appointment calendar in Excel without the need for VBA programming! This step-by-step tutorial will guide you through setting up a functional and easy-to-use calendar to keep track of your appointments. Watch now and

Read More


Master Microsoft Word with Essential Shortcut Keys in an Instant

https://youtu.be/3I29AQUkVlI Learn these essential shortcut keys and become a Microsoft Word pro in no time! Master Microsoft Word with ease by learning essential shortcut keys! In this video, we will cover a variety of time-saving shortcuts that will help you navigate and work efficiently in Microsoft Word. Whether you are a beginner or looking to

Read More


Auto-Size Text in Visio When Shape Grows – EASY TUTORIAL!

https://youtu.be/Hp_9ys6MV24 Say goodbye to manual resizing in Visio! I’ll show you the easiest way to make text adjust automatically when your shape grows! Learn how to automatically resize text in Visio when a shape grows with this easy tutorial! This Visio tutorial will guide you through the steps to ensure that your text adjusts perfectly

Read More


Be aware of This Microsoft Project Feature or You’ll Waste Resources

https://youtu.be/YCWn-y_lFbk You’re probably using this Microsoft Project feature wrong and it’s costing you valuable time and resources! In this video, you will learn about a crucial Microsoft Project feature that you need to be aware of to avoid wasting resources. We will discuss the dangers of unspent cost resources in Microsoft Project and provide valuable

Read More


Save time with custom OneNote templates

https://youtu.be/lRaXFtJSjqo Learn how to easily create a template in OneNote with this step-by-step tutorial. Whether you’re a student, professional, or someone looking to stay organized, this video will guide you through the process of making a custom template in OneNote. Streamline your note-taking and increase productivity by following along with our simple instructions. Don’t miss

Read More


Add SharePoint Files to Your Computer! [SharePoint]

https://youtu.be/tgQw6xBVP4c Say goodbye to the hassle of accessing SharePoint online – I’ll show you how to easily add SharePoint files to your computer! Learn how to easily add SharePoint files to your computer in this step-by-step tutorial. By following these simple instructions, you can access and work on your SharePoint files directly from your computer,

Read More


Excel Tutorial: Change Source File in Linked Excel (EASY STEPS!)

https://youtu.be/mlaLex5FIlg Say goodbye to broken links in Excel forever with this simple trick to change your source file in just a few clicks! In this Excel tutorial, you will learn how to easily change the source file in a linked Excel document. Follow these simple steps to update the source file for your linked data

Read More


Discover how to create label in Microsoft Access

https://youtu.be/VT8W0N3raNM In this step-by-step tutorial, you will learn how to easily add labels in Microsoft Access. Whether you are a beginner or looking to enhance your database skills, this video will guide you through the process of creating and customizing labels in Access. Watch now to streamline your data management tasks and improve the organization

Read More


Microsoft Project Tutorial In-Depth for Beginners and Advanced Users

https://youtu.be/wl8iyzMQVz4 Master Microsoft Project like a pro, whether you’re just starting out or looking to take your skills to the next level! In this comprehensive Microsoft Project tutorial, we will cover everything you need to know as a beginner or advanced user. From understanding the basics to mastering advanced features, this full course will equip

Read More


Expert tips for an Excel timeline using a Gantt chart

https://youtu.be/v4XFtAkFO_A Learn expert tips for creating an Excel timeline using a Gantt chart in this video tutorial. Perfect for project managers and those looking to visualize deadlines and tasks in a clear and organized way! Creating a Gantt chart in Excel to represent project timelines can be achieved by using a combination of Excel’s IF

Read More


Automate Excel spreadsheet creation with two tools

https://youtu.be/-a3mi7XELlY Automatically add borders and item numbers with these two great tips. Use conditional formatting to automatically add your borders as you type. Use the SEQUENCE function with COUNTA and IFERROR to automatically add numbers as you type. Microsoft Excel tutorial. Automate Excel spreadsheet creation with two tools #msexcel Join this channel to get access

Read More


Secrets to Customizing Headers on Multiple Pages in Writer

https://youtu.be/RDo4xqf_xgM Learn the secrets to customizing headers on multiple pages in Writer with this helpful tutorial. Master the art of unique headers for each page effortlessly! To add different headers on different pages in a document using a word processor like Writer, you’ll need to utilize the functionality of page styles or sections. Here’s a

Read More


Don’t type out a table of contents #tutorial #msword #microsoft

https://youtu.be/QzC1M45nDvM Adding a table of contents (TOC) in Microsoft Word is a straightforward process that enhances the navigation of your document. To begin, place your cursor at the desired location for the TOC in your document. Navigate to the ‘References’ tab and select ‘Table of Contents’ to choose an automatic style. If your document undergoes

Read More


Don’t type a table of contents do this instead

https://youtu.be/tmcBn5sebz8 Learn how to create a table of contents easily with this simple tip. Say goodbye to typing out a table of contents and save time with this alternative method! Adding a table of contents (TOC) in Microsoft Word is a straightforward process that enhances the navigation of your document. To begin, place your cursor

Read More


Learn how to use a VLOOKUP function in 60 seconds

https://youtu.be/6tVb1FvlQS8 Learn how to use vlookup in just 60 seconds with this quick and easy tutorial. Master this Microsoft Excel function in no time! #itseasytraining #microsoft #excel Learn how to use a VLOOKUP function in 60 seconds

Read More


How to add lists and groups to ToDo #itseasytraining1st #todo

https://youtu.be/PVqzT1UKqrw

Read More


Enchase Microsoft Lists with additional views

https://youtu.be/xUdcHUO1uEI Learn how to enhance your Microsoft Lists with additional views in this tutorial video. Optimizing your lists with different views can help you better organize and visualize your data for improved efficiency and productivity. Tune in to discover how to make the most of Microsoft Lists! Enchase Microsoft Lists with additional views. Microsoft Lists

Read More


Secrets to Safeguarding Sheets and Cells in Microsoft Excel

https://youtu.be/k4afLCDOFQY Learn the secrets to safeguarding sheets and cells in Microsoft Excel to protect your data and ensure security. Keep your information safe with these tips! Secrets to Safeguarding Sheets and Cells in Microsoft Excel. Microsoft Excel tutorial. Protecting sheets and cells in Microsoft Excel is essential for maintaining the integrity of your data, especially

Read More


Mastering Pivot Tables in LibreOffice Calc

https://youtu.be/1sFcDD8bvDE Learn how to master pivot tables in LibreOffice Calc with this tutorial session! Discover how to create a simple pivot table, calculate percentage differences, and utilize percentage totals effectively. Don’t miss out on optimizing your data analysis skills – subscribe now! Mastering pivot tables in LibreOffice Calc can significantly enhance your data analysis capabilities.

Read More


AutoText Secrets Revealed: Word Document Speed Guide

https://youtu.be/B3lusXSJlHE In this tutorial, we will show you how to efficiently use AutoText in Microsoft Word to quickly generate documents with just a few clicks. AutoText is a powerful feature that allows you to save snippets of text, such as paragraphs, phrases, or even entire pages, and then insert them into your document whenever needed.

Read More


Avoid mistakes: Mastering Microsoft project’s summary tasks

https://youtu.be/x5WfF1rwwjY Creating summary tasks in Microsoft Project is a fundamental skill for effective project management. Summary tasks help organize and structure your project by grouping related tasks together, which can simplify complex project timelines. To create a summary task, you need to indent a task below another task. This is done in the Gantt Chart

Read More


Transform Your Skills with ITs Easy Training

https://youtu.be/N0UVbHCEZCg Ready to transform your skills with ITs Easy Training? Our tutorials cover Microsoft Office, LibreOffice, Google, and more! Start learning today. 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 course: https://www.udemy.com/course/microsoft-word-all-levels/?referralCode=84FDB002396C57546EA5 Excel Introduction Course for basic users: https://www.udemy.com/course/microsoft-excel-beginner/?referralCode=EC4EF06E3690029D05D0 Excel

Read More


How to Calculate Years in Microsoft Access

https://youtu.be/tU9Z2dTNR1U Welcome to our Microsoft Access tutorial where we explore the functionality of calculation fields in queries. Follow along as we demonstrate how to design a query that calculates the years an employee has been working at the company. Subscribe to our channel for more database tips and tricks! To add a calculation field in

Read More


Master The Art Of Multiplying Figures Using Paste Special

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


Why you should create your own stencil in Microsoft Visio

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


How to automatically widen cells without using VBA

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


Mastering Database Creation for Powerful Reports

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


How to use the % difference from feature in a Pivot table.

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


Discover How to Quickly Summarise Data using consolidate

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


Best way to animate slides in PowerPoint

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


How to create a database in Microsoft Access

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


Automatically add a prefix to a number in Google Sheets

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


How do lists work in Microsoft Word

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


How to link multiple Excel files into one Pivot table

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


Excel Text Functions: Tips and Tricks for Success

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


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


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 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




“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