01670 732139 | |
steve@itseasy.co.uk |
https://youtu.be/DMN440UoVKk Creating a form in Microsoft Access using Design View allows for a high degree of customisation and control over the database interface. To start, open your Access database and navigate to the ‘Create’ tab, then select ‘Form Design.’ This opens a blank form template where you can begin designing your form. You can add
Read More
https://youtu.be/3wxk1NZmYKI Creating a flowchart in Microsoft Visio involves several steps to ensure clarity and efficiency in representing processes. To begin, open Visio and select the ‘Flowchart’ category, followed by ‘Basic Flowchart’ to access a variety of shapes and connectors that represent different steps in a process. Drag and drop these shapes onto your drawing canvas
Read More
https://youtu.be/3vv1vJWWnMA Unlock the full potential of your notes with OneNote! Dive into our latest tutorial and discover how to seamlessly integrate printouts, attach files, and capture screen clippings. Transform your note-taking experience by embedding all the information you need, right at your fingertips. Stay organized, efficient, and ready to conquer any task with OneNote. In
Read More
https://youtu.be/JRMAInNuNkw Using TODAY() and SUMIF together will change the way you handle Excel data forever! Unlock the power of dynamic data in Excel with our latest tutorial on using the TODAY() function alongside SUMIF! In this video, we will guide you step-by-step on how to create dynamic formulas that automatically update based on the current
Read More
https://youtu.be/eNmT6w-2UxE Creating lookup lists in Microsoft Access is a multi-step process that enhances user interaction with database forms. To begin, open your Access database and navigate to the table where you want to add the lookup field. In ‘Design View’, create a new field and set its ‘Data Type’ to ‘Lookup Wizard’. The wizard will
Read More
https://youtu.be/fGwj9lDWYSY Master documents in Microsoft Word are a powerful feature designed to manage and organize large documents efficiently. Essentially, a master document acts as a container for a set of smaller files, known as subdocuments, allowing you to work on individual sections of a document separately while still maintaining the ability to compile and format
Read More
https://youtu.be/iTTmX2vn8_Y “Unlock the full potential of your data with the power of filtering in Access. Dive into our latest tutorial and discover how to streamline your information, enhance your database management, and make data-driven decisions with ease. Get ready to transform tables into treasure troves of insights!” In this comprehensive tutorial, we delve into the
Read More
https://youtu.be/UPE8p4W__Fc “Transform your notes into organised masterpieces. Discover the power of tables in OneNote to streamline your data and enhance your note-taking experience. Watch now to unlock the full potential of your notes!” Using tables in OneNote is a straightforward process that can greatly enhance the organization and presentation of your data. To begin, simply
Read More
https://youtu.be/3yNWhbUAX8g Mastering Microsoft Excel Developer Controls is easier than you think, and I’m going to show you how to get started in no time! Welcome to our comprehensive tutorial on Microsoft Excel Developer Controls for Beginners! In this video, we will walk you through the essential features and functions of the Developer tab in Excel,
Read More
https://youtu.be/4yVLWkPj0LQ Parameter queries in Microsoft Access are a powerful tool for data retrieval. They allow users to specify criteria for a query at runtime, rather than hard-coding them into the query’s design. This means that the same query can be used repeatedly with different criteria, making it highly flexible and efficient. When you create a
Read More
https://youtu.be/58IRu-o14PU “Unlock the full potential of your data with Microsoft Access! In our upcoming video, we dive into the world of validation rules, the powerful feature that ensures your data is accurate, consistent, and reliable. Discover how to set up custom validation rules that work for you, prevent data entry errors, and maintain the integrity
Read More
https://youtu.be/tpZD__UXAUE Don’t waste time typing use OneNote superb feature, DICTATE. Add Outlook meeting details directly into OneNote to keep on top of diary appointments. OneNote offers a suite of features to enhance note-taking, including Dictate, Transcribe, and Meeting Details. Dictate allows users to convert speech into text using a microphone and a reliable internet connection,
Read More
https://youtu.be/WkojNqtiJeE Using the Excel Find feature, I can show you how to enter massive amounts of data in record time—it’s a total game changer! Unlock the power of Excel with our latest tutorial: “Enter Large Amounts of Data FAST with Excel Find feature”! 📊 In this video, we’ll show you how to efficiently use the
Read More
https://youtu.be/K6P7739NSaw Creating a basic select query in Microsoft Access involves several steps to filter and retrieve specific data from one or more tables. First, open the Microsoft Access database and navigate to the ‘Create’ tab to select ‘Query Design.’ This will open the Query by Example (QBE) window, a user-friendly interface where you can build
Read More
https://youtu.be/Ey1tPClFkQ4 Join me as I take on the challenge of mastering table design in Microsoft Access from scratch—let’s see if I can do it in just one day! Creating a table in Microsoft Access involves several steps to ensure that data is stored efficiently and accurately. To begin, open Microsoft Access and navigate to the
Read More
https://youtu.be/pBFPFWed5aY You won’t believe how using tags in OneNote can totally transform the way you organize your notes! OneNote,tagging in OneNote,digital notebook,productivity tools,OneNote 2024,OneNote tutorial,how to use OneNote,Microsoft Office,productivity apps,OneNote tags,Microsoft OneNote,task management,OneNote tips,Microsoft OneNote features,technology tips,OneNote for students,note organization,organization tips,software tutorial,note-taking Join this channel to get access to perks: https://www.youtube.com/channel/UC1c7NBQ7tjBhPGegvCXid_A/join If you want to
Read More
https://youtu.be/LZqRxElujO4 These Excel functions will change the way you handle data forever, and I’m going to show you why! Welcome to our comprehensive guide on Excel functions! In this video, we dive deep into the four essential Excel functions: SUM, SUMIF, SUMPRODUCT, and SUMSQ. Whether you are a beginner or looking to brush up on
Read More
https://youtu.be/1CdkboUiAQU Join me as I tackle the challenge of mastering Microsoft Visio using these secret hacks that you absolutely need to know for 2024! Using shape data and data graphics in Visio can significantly enhance the visual impact and informative value of your diagrams. Shape data allows you to store information with each shape that
Read More
https://youtu.be/RTRPyj84YZo OneNote can transform your note-taking game, and I’m about to share the best formatting tips that will make your notes stand out! Unlock the full potential of Microsoft OneNote with our Ultimate Microsoft OneNote Formatting Guide! In this comprehensive tutorial, we dive deep into the various formatting techniques that will elevate your note-taking experience.
Read More
https://youtu.be/_RrujAlcKL0 The SWITCH function in LibreOffice Calc is a versatile tool that simplifies complex decision-making within spreadsheets. By comparing a given expression against a list of values, it returns the corresponding result of the first matching value, streamlining the process of data analysis. This function is particularly useful when dealing with multiple conditions that would
Read More
https://youtu.be/L1C3Gjm1Jlw Count functions in Excel are way easier than you think, and I’m about to show you the secrets to mastering them! Unlock the full potential of Microsoft Excel with our comprehensive guide on mastering COUNT functions! In this video, you’ll learn how to efficiently use COUNT, COUNTA, COUNTIF, and COUNTIFS to analyse your data
Read More
https://youtu.be/aaE-aWeFWSE Today, I’m going to challenge myself to see if I can hyperlink to any page in Word without breaking a sweat. Let’s find out if this hack really works! To create a hyperlink in PowerPoint that directs to a specific page in a Word document, you need to use bookmarks in Word and then
Read More
https://youtu.be/Q9LK4SIzYSA Doing research at school, work or university? Let Linked Note in OneNote help you. Linked notes in OneNote are a powerful feature that allows users to connect their notes to specific content within other Microsoft Office applications such as Word, PowerPoint, or even web pages in Internet Explorer. When taking linked notes, OneNote can
Read More
https://youtu.be/DyN5m65QhQc Discover the streamlined process of crafting Project plans and transforming them into versatile templates for repeated application. This comprehensive Microsoft Project tutorial guides you through the creation of a template—a meticulously organized blueprint foundational to standard project plans. Unlike conventional files, the template is retrieved via the ‘NEW’ command, not ‘OPEN’. Engaging a template
Read More
https://youtu.be/rXTkDngb-rk Mastering What IF Analysis in Excel 2024 can seriously change the way you make decisions, and I’m going to show you how to do it in just five minutes! Unlock the power of Excel 2024 in just 5 minutes with our quick guide to What IF Analysis! In this video, you’ll learn how to
Read More
https://youtu.be/v5fjzUW-fcY Mastering Excel using named cells and ranges will change the way you work with spreadsheets forever! Unlock the full potential of Microsoft Excel 2024 with our comprehensive step-by-step tutorial on using Named Cells and Ranges! In this video, you’ll learn how to streamline your spreadsheets, making them easier to read and manage. We’ll cover:
Read More
https://youtu.be/bcdarUarXpo This simple hack will have you fixing Quick Part issues in Word 2024 like a pro in no time! Discover a simple HACK to resolve Quick Part issues in Word 2024! In this video, we will guide you step-by-step through the process of fixing common problems you might encounter with Quick Parts, enhancing your
Read More
https://youtu.be/FwQB_S8PmDk How to use Sections and Pages in OneNote 2024 Unlock the full potential of OneNote 2024 by mastering the art of using Sections and Pages! In this comprehensive tutorial, we’ll guide you through everything you need to know to organize your notes effectively and boost your productivity. Learn how to create, manage, and utilize
Read More
https://youtu.be/hsTwTWrPDAs You can master Excel in no time with SubTotals, and I’ll show you how to make it super easy! Unlock the power of Microsoft Excel in 2024 with our easy-to-follow tutorial on using the SubTotals feature! This video is designed specifically for beginners who want to master Excel quickly and efficiently. In this step-by-step
Read More
https://youtu.be/IM05rqJUNJw You can create stunning charts in Excel that will wow your audience and take your presentations to the next level, and I’m going to show you how! Unlock the full potential of Excel with our comprehensive step-by-step guide to creating stunning charts! In this video, we dive into the magic of Charts in Microsoft
Read More
https://youtu.be/IqeXY3BNKng Grouping rows and columns in Excel can save you hours of work, and I’m going to show you how to do it effortlessly! In this comprehensive tutorial, learn how to easily organize data in Microsoft Excel 2024 by mastering the art of grouping rows and columns. Whether you’re a beginner or looking to enhance
Read More
https://youtu.be/iMAnQ0RuXZ4 These advanced Excel conditional formatting hacks will change the way you work with spreadsheets forever! Unlock the full potential of Microsoft Excel with our latest video, “Advanced Excel Conditional Formatting Hacks You NEED to Know in 2024!” 🚀 In this comprehensive guide, we’ll dive deep into the world of conditional formatting, revealing advanced tips
Read More
https://youtu.be/pdCcC8yFL04 Locking cells in Excel has never been easier, and I’m about to show you the quickest way to master absolute referencing! Unlock the power of Microsoft Excel 2024 with our comprehensive tutorial on how to lock cells using absolute referencing! In this video, we will guide you step-by-step through the process of locking cells,
Read More
https://youtu.be/obPnVlMKu4Y Creating a detailed timeline in Microsoft Visio is way easier than you think, and I’m going to show you how to do it in just a few simple steps! In this comprehensive tutorial, we’ll guide you through the process of creating a detailed timeline in Microsoft Visio for 2024. Whether you’re a beginner or
Read More
https://youtu.be/OAi_X8eZP3o By the end of this series, you’ll be an Excel pro, ready to tackle any spreadsheet challenge like a pro! Welcome to “Master Microsoft Excel in 2024: Complete Beginner Tutorial Series”! If you’re looking to gain essential skills in Excel and boost your productivity, you’ve come to the right place. This comprehensive tutorial series
Read More
https://youtu.be/YJGd50Ld1yQ “Unlock the full potential of your database with our latest tutorial on Microsoft Access ! In this video, we’ll guide you through the simple steps to run a query directly from a form, streamlining your data management process. Stay tuned to learn how to harness the power of Access to make your data work
Read More
https://youtu.be/8GQE2bIO35w 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 Intermediate Course: https://www.udemy.com/course/microsoft-excel-intermediate-course-z/?referralCode=365DF21869A9F9D2BFCB Excel Advanced Course: https://www.udemy.com/course/advanced-microsoft-excel-training/?referralCode=DF5BCAB9DCD0C6BB30FA Microsoft Project Master Class: https://www.udemy.com/course/microsoft-project-masterclass/?referralCode=1A8DDDD5CEC7DF87CBFF Microsoft Visio Essentials: https://www.udemy.com/course/microsoft-visio/?referralCode=1DF86575CCABA9B0C6D7 Access for beginners course: https://www.udemy.com/course/microsoft-access-intro/?referralCode=822715AB3FC8EC89D2F0
Read More
https://youtu.be/YvG-XT43RIM Boost your productivity with LibreOffice Calc lookups using these game-changing tips and tricks! Learn how to master lookups in LibreOffice Calc with these tips and tricks for 2024. In this video, we’ll cover everything you need to know to become an expert at using lookups effectively in LibreOffice Calc. Whether you’re a beginner or
Read More
https://youtu.be/_cgEEsjD5mg I’ll show you how to easily unlock the hidden feature in Microsoft Project that will revolutionise the way you manage late tasks! Unlock the hidden feature in Microsoft Project and learn how to reveal late tasks with ease in this step-by-step tutorial. By understanding how to enable late task visibility, you can effectively manage
Read More
https://youtu.be/PMamie8SBXg I’ll show you the quickest and easiest way to change index reference display in Word – you’ll never struggle with it again! Learn how to quickly and easily change the display of an Index reference in Word with this step-by-step tutorial. Whether you want to customize the formatting or adjust the layout, this video
Read More
https://youtu.be/OTrmezalGjM I will show you the easiest way to filter data in Excel like a pro, even if you’re a beginner! In this step-by-step tutorial, you will learn how to efficiently use Excel filters to streamline your data analysis process. Whether you are a beginner or looking to enhance your Excel skills, this 2024 guide
Read More
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
https://youtu.be/PVqzT1UKqrw
Read More
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
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
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
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
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
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
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
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
“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
“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