Generated by Rank Math SEO, this is an llms.txt file designed to help LLMs better understand and index this website. # The Training Lady (Beltan Consultancy): Tips and Tricks for using Microsoft Office and Windows. ## Sitemaps [XML Sitemap](https://www.thetraininglady.com/sitemap_index.xml): Includes all crawlable and indexable pages. ## Posts - [How to use the Embed card in Microsoft Sway](https://www.thetraininglady.com/media-cards-sway/): The Embed card in Sway allows you to add a wide range of media and interactive content to your presentation. Your Sway can include videos, audio, forms, maps, documents and content from many other online services. - [How to use PowerPoint Animation like a pro](https://www.thetraininglady.com/powerpoint-animation/): The use of PowerPoint Animation can enhance a presentation by adding movement and visual interest to text, images and other elements. When used correctly, animations help draw attention to important information, guide audience focus and make presentations more engaging. The key is using animations to support your message rather than distract from it. Subtle effects such as Fade, Zoom and Float In can create a professional presentation, while excessive animations can quickly become overwhelming. - [How to create a OneNote Class Notebook](https://www.thetraininglady.com/create-class-notebook/): Microsoft provide an additional Class Notebook Add-in which adds tools to distribute pages, review student work and integrate your notebook with Learning Management Systems. - [How to add date based questions in Microsoft Forms](https://www.thetraininglady.com/add-date-questions-forms/): Microsoft Forms includes a variety of question types which help you collect information in different ways. Depending on the type of data you need, you can choose from options such as Text, Choice, Rating, Likert, Ranking, File Upload, Net Promoter Score (NPS) and Date questions. Each question type is tailored to a specific purpose, making it easier to gather accurate and consistent responses from your audience. - [How to bulk rename files in a folder (Windows 11)](https://www.thetraininglady.com/bulk-rename-files/): If you have dozens or even hundreds of files with generic file names such as IMG_0001, IMG_0002, and IMG_0003, renaming them one at a time can be a frustrating and time-consuming task. Thankfully Windows 11 includes a simple built-in feature that lets you rename multiple files at once. - [How to set Out of Office in Outlook](https://www.thetraininglady.com/set-out-of-office-in-outlook/): There is nothing quite like the day before you're about to head off on a well-earned break. You finish your last few tasks, tidy up your inbox, and get ready to shut down your computer. Before you leave, though, there is one important step you shouldn't forget: setting up your Outlook Out of Office message. - [How to get separate Chat and Teams back in Microsoft Teams](https://www.thetraininglady.com/how-to-get-separate-chat-and-teams-back-in-microsoft-teams/): For years, Microsoft Teams displayed Chat and Teams as separate icons in the app bar on the left side of the screen. Then Microsoft introduced a new experience that combined chats, channels and teams into a single Chat area. Lots of users noticed the change immediately but didn't know they could switch back to the original view. - [How to use Tags in OneNote](https://www.thetraininglady.com/tag-content-onenote/): If you are using OneNote then you'll know how quickly notebook can fill up with notes, project ideas, research, and to-do lists. This makes finding important information a challenge, but that is where tags come into play. - [How to show duplicates in Excel](https://www.thetraininglady.com/show-duplicates-in-excel/): A very common request in any of my Excel courses is "how to show duplicates in Excel". When we are working with any data set you may need to be alerted when duplicate records exist. This process is surprisingly simple to set up and have Excel alert you with a change in formatting when a duplicate exists. - [What is a paragraph mark in Word?](https://www.thetraininglady.com/paragraph-mark-in-word/): If you have ever opened a Word document and suddenly seen strange symbols like dots, arrows, or a backward “P” (¶), you are not alone. Today I want to introduce you to a range of symbols, and in particular, the paragraph marks found in Word documents. - [How to Duplicate a Plan in Microsoft Planner](https://www.thetraininglady.com/duplicate-a-plan-in-microsoft-planner/): Microsoft Planner is often used for recurring projects, team processes, onboarding tasks, event planning, and department workflows. Many teams get to the end of a project and then assume they need to recreate the entire Planner structure for the next rollout. Instead of rebuilding the same buckets, tasks, due dates, labels, and checklists from scratch every time, Planner allows you to duplicate an existing plan and use it as a starting point for your next project. - [How to make a timeline in PowerPoint](https://www.thetraininglady.com/make-a-timeline-in-powerpoint/): Timelines are a great way to show events, project stages, milestones, or important dates in a visual format. They can be useful in everything from a business presentation, training session, project update, and even make fantastic classroom resources. I've had many examples where people think that you need some fancy software to create a nice looking timeline, when in actual fact PowerPoint makes it surprisingly easy to build a professional-looking timeline. - [How to delay sending email in Outlook](https://www.thetraininglady.com/delay-sending-email-in-outlook/): During a recent Outlook training session I was asked if it's possible to delay sending an email? This question is a common one and is often followed by a story about an email sent a little too quickly, a forgotten attachment, or someone realising that the wording could have been a bit clearer. I can definitely relate. - [How to use the Group cards in Sway](https://www.thetraininglady.com/group-card-sway/): The Group card provides a way to easily display a set of cards in a neatly organised way. There are five (5) different group types to choose from. You can choose to either create each group type from scratch or select existing image cards and group them yourself. Each group type provides a different layout for your images. - [How to add or remove members in Microsoft Planner](https://www.thetraininglady.com/add-remove-members-planner/): Managing members in Microsoft Planner is important to ensure the right people have access to your plan and can contribute effectively. Most plans in Microsoft Planner use a Microsoft 365 Group to manage its membership. The Microsoft 365 Group identifies who will have access to the resource and their associated permission level. By using Microsoft 365 Groups you can create multiple plans using the same underlying Group without the need to add all members each time and then assign permissions. - [How to use Sections in Microsoft Teams](https://www.thetraininglady.com/sections-in-microsoft-teams/): If you’re anything like me, your Microsoft Teams list can start looking like a messy wardrobe with teams everywhere, channels scattered, and you can never find what you need when you need it. That’s where sections come in. They’re like drawers in a wardrobe, that help you group things neatly so you can grab what you need without rummaging around. - [How to delete individual quiz responses in Microsoft Forms](https://www.thetraininglady.com/delete-individual-quiz-responses-in-forms/): When users, or "respondants" complete a quiz or survey using Microsoft Forms, the response is saved and can be viewed at any time. By default, each user is provided an option to Submit another response at the end of the form submission. Forms allows you to restrict form submissions to one response per person. This is useful for assessment-based forms where you do not want respondents to complete the form multiple times. - [How to rename a OneNote Notebook](https://www.thetraininglady.com/rename-a-onenote-notebook/): I remember the first time I wanted to rename a notebook in OneNote, I thought it would be as simple as right-clicking and typing a new name. However working with OneNote notebooks has always been a little different to other file formats. The other approach many people try is to rename the notebook from inside OneNote, spoiler alert: this doesn't work either. So here I want to take you through a few options you can use the access and rename your OneNote notebook. - [How to remove a page break in Word](https://www.thetraininglady.com/remove-a-page-break-in-word/): Anyone who has had to work with a longer Word document will have encountered page breaks. A page break allows you to choose when a new page will begin. So what happens when you open a document and need to remove a page break in Word? The tricky part about page breaks is that by default they are invisible in the document. This can make deleting them harder than it needs to be. - [How to show Hidden Files in Windows 11](https://www.thetraininglady.com/show-hidden-files-in-windows-11/): Sometimes when I am running a training session, I encounter technical issues with a participants computer. Because I have an IT background in network support, I am generally able to fix most of these issues when they arise. One step that is common practice is to troubleshoot issues related to files or folders that are hidden by default. So here I want to show you how to display, or show hidden files in Windows 11 to help you with troubleshooting various issues. - [How to import tasks from Excel into Planner](https://www.thetraininglady.com/import-tasks-from-excel-into-planner/): With the popularity of Microsoft Planner continuing to go up, I often have people ask me how they can get a list of tasks which have been tracked using Excel, and move them into Microsoft Planner without the need to create them manually one-by-one. Whilst Planner doesn't directly give us an import function, Power Automate provides a way that we can "trigger" tasks to be created based on an Excel file. - [How to allow other users to edit a Microsoft Form](https://www.thetraininglady.com/allow-other-users-to-edit-form/): When creating a form using Microsoft Forms, the form is stored within your personal Microsoft 365 account. The form is then shared to collect responses. But what if you want to allow other users in your organisation to edit the Form? What if it needs to be a collaborative space so that any of your team members can access and make changes when needed? - [How to upgrade Planner Plan from Basic to Premium](https://www.thetraininglady.com/upgrade-plan-from-basic-to-premium/): For those people using Microsoft Planner you will have noticed some Premium options available. Microsoft Planner has several licensing options available from the basic Microsoft Planner included with any Microsoft 365 subscription, to Microsoft Planner Plan 1, Planner and Project Plan 3 or Planner and Project Plan 5. So for those who have been upgraded from basic Planner to the next level, you'll want to know how to upgrade your existing basic Plans to allow access to these new premium features. You may also wonder what some of the differences are? - [What is a circular reference error in Excel?](https://www.thetraininglady.com/circular-reference-error-excel/): I recently had an email from a client asking me to assist with an error in one of their Excel files. I opened the file to take a look and immediately the error appeared: "There are one or more circular references where a formula refers to its own cell either directly or indirectly. This might cause them to calculate incorrectly. Try removing or changing the references, or moving the formulas to different cells." - [How to save a message in Microsoft Teams](https://www.thetraininglady.com/save-a-message-teams/): Today I want to show you how you can use the Save this message function in Microsoft Teams to allow you to quickly locate, or go back to, specific messages or posts from any Teams channels. Think of it like being able to bookmark a message that you can come back to at any point in the future. - [How to include video in PowerPoint](https://www.thetraininglady.com/include-video-in-powerpoint/): I've already outlined the steps on how to embed a YouTube video in PowerPoint, but what if you want to include your own video in PowerPoint? With us now able to create our own video content so easily using our smart phones, it's natural that we will want to include it in our PowerPoint presentations. - [How to customise the Quick Access Toolbar in Outlook](https://www.thetraininglady.com/customise-quick-access-toolbar-outlook/): If you have attended a training course with me then you'll know I LOVE a good productivity hack. Using the Quick Access Toolbar (QAT) in any of the Microsoft 365 apps is a must, but when it comes to Outlook, we get an extra added bonus. Outlook has three, yes that's right, three (3) Quick Access Toolbars to customise. - [How to add a bookmark in Word](https://www.thetraininglady.com/add-a-bookmark-word/): When working with longer documents in Microsoft Word, it is helpful to provide users with more efficient ways to navigate than simply scrolling page by page. In this post I'll show you how to add a bookmark in Word to allow users to click a link which will take them to a specific location within the document. - [How to share a OneNote notebook](https://www.thetraininglady.com/share-onenote-notebook/): One of my favourite parts of using OneNote is the ability share content with colleagues or friends. When you share a OneNote notebook you allow for collaboration with others, making it easy for multiple people to work together on projects, share ideas, or access important information. When sharing a notebook, you can invite others via email or generate a sharing link, giving them either view-only or full editing access. - [How to add Buckets in Microsoft Planner](https://www.thetraininglady.com/add-buckets-in-microsoft-planner/): ​Microsoft Planner uses buckets to group and organise tasks within a plan. They act like categories or columns that help structure your work visually and logically. By default, Microsoft Planner creates a bucket called To Do, however you can rename this default bucket as well as create your own buckets to identify different stages of a project. - [How to use the COUNTIFS Function in Excel](https://www.thetraininglady.com/countifs-function-excel/): When managing data in Excel, it’s common to need a quick way to count entries based on more than one condition. That’s where the COUNTIFS function in Excel becomes incredibly useful. Whether you’re sorting customer orders, tracking project tasks, or analysing survey results, COUNTIFS allows you to count exactly what you need with precision. - [How to time-limit access to a Microsoft Form](https://www.thetraininglady.com/time-limit-access-form/): Microsoft Forms is still a relatively new app within the Microsoft 365 ecosystem but allows you to easily create surveys, quizzes and feedback forms and is available as part of any existing Microsoft 365 subscription. One particularly useful feature is the ability to limit access to a form based on a specific date range or even the ability to limit the amount of time you wish people to have to complete it. - [How to embed Sway into a website](https://www.thetraininglady.com/embed-sway-in-website/): There are multiple ways to share a Sway with others, whether with individuals or groups of people. In addition to sharing via a link, you can also embed a Sway directly into your website. This allows your interactive content to be displayed on the web page itself, eliminating the need to share links separately. - [How to create a Plan in Microsoft Planner](https://www.thetraininglady.com/create-plan-microsoft-planner/): In the second post of the Microsoft Planner category I will step you through the process to create a Plan using the Planner interface. We'll also look at some of the other basic functions including how to make a copy of a plan, pin a plan, and delete a plan. - [How to use the Cameo feature in PowerPoint](https://www.thetraininglady.com/cameo-feature-powerpoint/): The Cameo feature in PowerPoint is a relatively new feature and allows users to integrate live video feeds into a presentation. By embedding your live webcam feed directly onto slides you can create a more personal and interactive experience for your online audience. - [How to create a channel in Microsoft Teams](https://www.thetraininglady.com/create-channel-microsoft-teams/): To create a new channel in Microsoft Teams: - [What is Microsoft Planner?](https://www.thetraininglady.com/what-is-microsoft-planner/): YAY Planner is now a category with The Training Lady! I've been training Microsoft Planner for years but so far hadn't added any content for it to the website. Well the time is here and this marks the first of my Planner blog posts. To get started I want to explain what Microsoft Planner is and how it can be used. - [How to Shuffle Questions in a Microsoft Form](https://www.thetraininglady.com/shuffle-questions-microsoft-form/): Microsoft Forms is a part of the Microsoft 365 suite of programs and allows you to create surveys, quizzes, and polls with ease. It is a popular choice for educators, businesses, and individuals alike. One of its wonderful features is the ability to shuffle questions within a form, which can significantly enhance the effectiveness of assessments. In this post I am going to explain the ins and outs of this feature and step you through the process to enable this within your own Microsoft Form. - [How to take a screenshot on Windows 11](https://www.thetraininglady.com/screenshot-windows-11/): Several years ago I wrote about using the Snipping Tool in Windows 10. Now that Windows 11 is available I wanted to give an update on how to take a screenshot on Windows 11 using the newest version of the Snipping Tool. - [How to delete a notebook in OneNote](https://www.thetraininglady.com/delete-notebook-onenote/): Knowing how to delete a notebook in OneNote is an important part of managing your notebooks effectively. Regularly reviewing and removing notebooks you no longer need helps keep things organized and makes it easier to find important information. - [How to create an Index in Word](https://www.thetraininglady.com/create-index-word/): Being able to create an index in Word is an invaluable skill for organising and navigating long documents. The Index feature in Word allows you to automatically generate a list of page numbers corresponding to a word or phrase within the document. - [How to create appointments in your Outlook Calendar from dates in Excel](https://www.thetraininglady.com/create-appointments-outlook-calendar-from-excel/): Recently I was asked about how to automatically create calendar appointments in Outlook (Classic version) using dates in an Excel workbook. This was something I'd not been asked before and it peaked my curiousity. I did some research online around the idea of using Power Automate, and unfortunately found no options. A few weeks later it was still bugging me and I remembered that sometimes we (me) overcomplicate things. We sometimes jump to the latest and greatest functions (Power Automate or AI) to try to achieve things, when if we break it down into simple terms, we may find the answer has been available the whole time. - [How to edit the design of a Sway](https://www.thetraininglady.com/edit-design-sway/): One of the great aspects of creating with Microsoft Sway is the fact you don’t need to spend a huge amount of time trying to style the presentation. Sway has a built-in design gallery which lets you switch between different styles until you find the one you like. These styles provide a consistent look and feel, ensuring that all elements, from text to images, blend together seemlessly. - [How to create links between slides in PowerPoint](https://www.thetraininglady.com/create-links-between-slides-powerpoint/): Whenever we create a presentation, we want to captivate our audience and highlight the important information we are delivering. While many users are familiar with the basics of creating slides, many users are not aware that you can create links between slides. This process can elevate your presentation to a whole new level of professionalism and interactivity. This is especially important in presentations which are meant to be browsed at the leisure of the audience (sometimes referred to as a kiosk or interactive presentation), rather than delivered by a presenter with a live audience. - [How to create Quick Steps in Outlook](https://www.thetraininglady.com/quick-steps-outlook/): Quick Steps in Outlook allow you to automate actions that you use on a regular basis. These actions may include forwarding emails to a specific person or group, moving emails to a specific folder or replying to an email. Quick Steps even allow you to group multiple actions into one quick step to help save time. - [How to use XLOOKUP in Excel (with examples)](https://www.thetraininglady.com/xlookup-excel/): Are you still using VLOOKUP or HLOOKUP in Excel? It's time to upgrade and learn how to use XLOOKUP in Excel which provides a powerful and more flexible lookup function. Many Excel users haven’t yet explored how to use XLOOKUP, even though it simplifies complex lookups and eliminates some of the limitations found in the original lookup functions. In this guide, you’ll learn what makes XLOOKUP better, how it works, and how to use it with real-world examples. - [How to create a To Do List in OneNote](https://www.thetraininglady.com/to-do-list-onenote/): Microsoft OneNote is a versatile note-taking application that can help you stay on top of your to-do list by allowing you to organise your daily tasks. I'm personally a huge fan of OneNote and it's one of my favourite courses to run. OneNote will allow you to create content using various different content types such as text, video, audio, bullet lists, tables and lots more. However, a To Do List is one that many users don't realise is available. - [The best Teams shortcuts](https://www.thetraininglady.com/teams-shortcuts/): If you’re using Microsoft Teams, stick around, I’m going to share some handy Teams shortcuts that’ll save you time in the Teams desktop app. Keyboard shortcuts aren’t just for Word, Excel, Outlook or PowerPoint; Teams has plenty of great ones that can really boost your productivity. - [How to add a Rating question in Microsoft Forms](https://www.thetraininglady.com/rating-questions-forms/): For those who are new to exploring Microsoft Forms, you may have noticed the Rating question type. The Rating question type allows users to provide a rating based on how much they like or dislike the scenario you have proposed. The Rating question type is particularly useful in scenarios where participants need to express their opinions or preferences on a scale. - [Use Cut, Copy and Paste in Microsoft Word](https://www.thetraininglady.com/cut-copy-paste-word/): Microsoft Word is known as the go-to option for any type of word processing tasks. To ensure you are maximising your productivity when creating new documents or working with existing documents, it's crucial to master fundamental features such as Cut, Copy, and Paste. Whilst you may have experience with these features already, maybe there will be some little tricks that you didn't know which will improve your workflow even further. - [How to get the NEW Microsoft Teams app](https://www.thetraininglady.com/new-microsoft-teams-app/): There are still a lot of Microsoft Teams users who do not know that a new Teams app has been developed. It's not just an update to the existing app, it's a completely new app built from the ground up. So why upgrade? - [How to create a folder in Windows](https://www.thetraininglady.com/create-new-folder-windows/): You can create Folders to group files by project, category, or any other logical grouping. For example, you might create a folder for your work-related documents, another folder for personal photos, and another for music. - [How to customise the Image card in Sway](https://www.thetraininglady.com/image-card-sway/): The Image card in Microsoft Sway allows you to display images. Image sources can include OneDrive, Flickr, Bing Images, Pickit, YouTube or directly uploaded from your computer. The use of images and photos with your Sway helps to convey information effectively and can improve engagement with your audience. - [How to compress images in PowerPoint](https://www.thetraininglady.com/compress-images-powerpoint/): A common issue that arises with many PowerPoint presentations is an inflated file size. It's too big to email or it's slowing down the computer during the presentation. So let's look at how to compress images in PowerPoint to reduce the overall file size. - [How to add text-based content to OneNote](https://www.thetraininglady.com/add-text-content-to-onenote/): If you've just discovered Microsoft OneNote then you may be wondering how you can utilise this wonderful program. First and foremost OneNote is a note-taking program which allows you to keep your notes organised into a simple filing structure know as notebooks. - [How to use Flash Fill in Excel](https://www.thetraininglady.com/flash-fill-in-excel/): Flash Fill in Excel is by far one of my favourite Excel features. Learning how to use Flash Fill in Excel should be on everyone's to do list. It is one of those features which amazes participants during any of my Excel training courses and it's the most frequent feature that people come back and say they've started using on a regular basis. - [How to use Search Folders in Outlook](https://www.thetraininglady.com/search-folders-in-outlook/): Microsoft Outlook offers numerous features to help you manage your inbox efficiently. Among its many functionalities, Search Folders are a valuable tool to streamline your email. Search Folders in Outlook allow you to gather specific emails from various folders across your mailbox and present them in a single virtual folder, saving you time and effort when locating important messages. - [How to add text-based questions in a Form](https://www.thetraininglady.com/text-questions-forms/): Text-based questions also allow additional settings such as the addition of a Subtitle (add additional instructions or a prompt for the question), Restrictions (specify restrictions such as only allow a number between certain values), and Maths (allows you to enter a Maths equation). - [How to share screen on Teams](https://www.thetraininglady.com/share-screen-teams/): One of the great functions of a Teams meeting is the ability to share your screen with those in the meeting. This allows you to provide live demonstrations such as presenting a report, deliver a presentation or author a document live with your colleagues. - [Add a SmartArt graphic in Word](https://www.thetraininglady.com/smartart-graphic-word/): Being able to represent content in a graphical way can add immense meaning and visual appeal to any document. All the Microsoft 365 apps provide the ability to easily create a SmartArt graphic to provide a visual representation of information rather than the traditional numbered or bulleted list or other display options. - [How to customise a Text card in Sway](https://www.thetraininglady.com/text-card-sway/): If you are new to Microsoft Sway you may be looking for some tips on how to create a Text card and then customise it within your Sway. Text cards are an obvious popular option as they allow you to add text based content to your Sway. If you are just getting started, be sure to check out how to customise the Title card first. - [How to format tables in Word](https://www.thetraininglady.com/format-tables-word/): In a previous post I outlined how to create a basic table in Microsoft Word. Let's go to the next steps and look at how we can format a table with different styling and also add more rows or columns. - [How to add slide transitions in PowerPoint](https://www.thetraininglady.com/slide-transitions-powerpoint/): PowerPoint is one of those programs that has so many bells and whistles that it can sometimes be a little overwhelming. One of the features you can use to add a simple effect to your presentation is the use of slide transitions. - [How to insert online videos in OneNote](https://www.thetraininglady.com/insert-online-video-onenote/): With so much video content around us, it can be daunting to think how we can keep track of those amazing resources. How can we keep them organised in such a way that we can find them again when we want them? Today I want to show you how you can embed a video into OneNote, and further enhance your content and note taking skills. - [How to use branching in Microsoft Forms](https://www.thetraininglady.com/branching-microsoft-forms/): So let's look at how you can create a form using branching in Microsoft Forms. - [How to sort data in Excel](https://www.thetraininglady.com/sort-data-in-excel/): One of the first features that many users begin using is the ability to sort data in Excel. Being able to automatically have your data displayed in a specific order, whether that be number, alphabetical or date order, is a huge time saver. Excel allows you to sort by one column at a time or multiples. - [How to add members to a team in Microsoft Teams](https://www.thetraininglady.com/add-members-to-a-microsoft-team/): Let's see how you can now add members to a Team and assign permissions as needed. - [How to send email using Outlook](https://www.thetraininglady.com/how-to-send-email/): When users first start using any program, it can be a bit daunting with lots of buttons to choose from. Sometimes we want to perform the simplest of tasks such as learning how to send email using Outlook, but the overwhelm of a new program can cause problems or overcomplicate the situation. Let's look at some simple first steps, including understanding some email etiquette, and then dive into how to send email using Outlook. - [How to display cards side-by-side in Microsoft Sway](https://www.thetraininglady.com/cards-side-by-side-sway/): Let's look at how you can display cards side-by-side: - [How to start up and shut down a computer](https://www.thetraininglady.com/start-up-shut-down-computer/): Those first few steps towards using a computer can be daunting. I conduct lots of training teaching people some of the fundamental computer skills needed to confidently operate a computer. Part of the process is showing people the correct way to start up and shut down their computer. It kind of sounds like a very simple process however for those who are new to using computers there are lots of buttons, lights and sounds that come along with a computer and so this is one of those steps which is the easiest step to begin with. - [How to use Morph in PowerPoint](https://www.thetraininglady.com/morph-zoom-powerpoint/): If you haven't seen the morph slide transition in PowerPoint then you are in for some fun. I wrote about Morph in PowerPoint on my business website in mid 2021 because it's such a fun new feature to show during PowerPoint training. - [How to create a poll using Forms in Outlook](https://www.thetraininglady.com/add-poll-outlook-email/): Did you know you can create a quick poll using Microsoft Forms all from the comfort of Outlook? Yep that's right, you don't need to specifically create the form in the Forms website. - [Using the Snipping Tool in Windows 10](https://www.thetraininglady.com/snipping-tool-windows-10/): The snipping tool in Windows 10 is often one of those unknown apps which can be extremely useful for many users. I spend a lot of time on my computer and I create a lot of content to use in my training courses and my blog posts. - [How to use Conditional Formatting in Outlook](https://www.thetraininglady.com/conditional-formatting-outlook/): Many users have discovered the amazing conditional formatting functions available in Excel, but not many know that you can also use conditional formatting in Outlook. - [How to extract text from an image in OneNote](https://www.thetraininglady.com/extract-text-picture-onenote/): OneNote includes a powerful feature that lets you extract text from image files using built-in OCR (Optical Character Recognition). OCR is a great way to avoid having to retype text from printed materials such as a magazine or book. - [How to create a “Choose your own adventure” storybook in PowerPoint](https://www.thetraininglady.com/choose-your-own-adventure/): Over my years providing professional development for teachers, I've had the opportunity to show participants the variety of ways we can use PowerPoint to engage students. One fun exercise is the ability to create an interactive story where the user can guide the story and ultimately end up with a different ending each time. I loved the "choose your own adventure" story book series when I was younger and it is possible to replicate this concept when working within PowerPoint. - [How to share audio in a Teams meeting](https://www.thetraininglady.com/share-audio-teams-meeting/): Why are participants unable to hear audio when sharing a video in a Teams meeting? - [How to create a Pivot Table in Excel](https://www.thetraininglady.com/pivot-table-excel/): Learning how to create a Pivot Table in Excel is one of the most useful skills you can have when working with large amounts of data. Pivot tables offer a vast range of benefits that significantly enhance data analysis and reporting efficiency. - [Create multiple choice questions in a Microsoft Form](https://www.thetraininglady.com/multiple-choice-question-microsoft-forms/): Creating multiple choice questions in Microsoft Forms provides an efficient way to gather structured feedback or conduct assessments. With a user-friendly interface and integration with other Microsoft 365 apps, you can create engaging surveys or quizzes in just a few clicks. - [How to dictate in Word](https://www.thetraininglady.com/dictate-document-word/): The Dictate function in Word allows you to use speech-to-text functions to create content using your microphone.  Learning how to dictate in Word will provide a quick and easy way to put your thoughts into words and capture ideas efficiently. It is great if I am wanting to freely create content without the need to type it out. - [How to convert text to date format in Excel](https://www.thetraininglady.com/convert-text-to-date-excel/): Last week I received an SOS from a good friend. She had data that was exported from an LMS and being used for analysis within Excel. A particular column contained a date and time in each cell that needed to be filtered and sorted by month. This was proving impossible as the data was being treated as text rather than Excel recognising the date formats. So how on earth can we convert the text to a date format? - [How to customise the Title card in Sway](https://www.thetraininglady.com/title-card-sway/): Microsoft Sway allows you to easily create digital stories which can be shared with other users. The Title card in Sway is used in a similar way that we would use a Title slide in PowerPoint. The Title card is created by default when you create a new Sway and cannot be deleted. You also cannot add any additional Title cards. The Title card includes some unique features which other card types do not include. Let's explore the Title card capabilities and how you can customise the Title card to suit your story. - [How to join a team in Microsoft Teams](https://www.thetraininglady.com/join-team-microsoft-teams/): Are you unsure how to join a team in Microsoft Teams? When we start using new programs it can be a bit daunting. One of the first things you may want to do with Microsoft Teams is to join a team. Maybe a colleague has suggested you need to join a specific team, but how? - [How to print Excel sheet on one page](https://www.thetraininglady.com/print-on-one-page-excel/): I've run a lot of Excel training. One of the most common questions is "How do I print an Excel sheet on one page?". The idea sounds simple doesn't it? - [How to use Immersive Reader in Microsoft Edge](https://www.thetraininglady.com/immersive-reader-edge/): If you have had a moment to look around this website you may have already discovered my article outlining how to use Immersive Reader in OneNote. This amazing tool uses proven techniques to help users read and comprehend texts. But this amazing feature is no longer limited to just OneNote. - [Understanding the Microsoft Sway Storyline](https://www.thetraininglady.com/microsoft-sway-storyline/): As with any new program, the first time we open an application can feel a bit overwhelming. In this article, I'd like to explain the Microsoft Sway Storyline and how to navigate and use it effectively. - [How to create a new Notebook in OneNote](https://www.thetraininglady.com/new-notebook-onenote/): To create a new notebook in OneNote: - [How to recall email in Outlook](https://www.thetraininglady.com/recall-email-outlook/): We’ve all experienced that moment—you hit Send on an email too early, or worse, send it to the wrong person. Thankfully, Microsoft Outlook includes a feature that can help: the Recall Email function. - [How to create a team in Microsoft Teams](https://www.thetraininglady.com/create-team-microsoft-teams/): Do you want to know how to create a team in Microsoft Teams? You've come to the right place. In this post I am going to outline the simple steps you need to take to create a new team in Microsoft Teams. - [Add a header and footer to a Word document](https://www.thetraininglady.com/header-footer-document/): When working with long documents you will need to add a header and footer section. The header and footer in Word allows you to add information to the top and bottom of each page within a document. These sections allow you to keep information consistent on all or multiple pages within the document and save you time so you do not have to copy and paste the information into the main body section of each page. - [The best OneNote keyboard shortcuts](https://www.thetraininglady.com/onenote-shortcuts/): Regardless of the program you are using, we all want to make sure we are being productive with our time. Using OneNote keyboard shortcuts is the perfect way to improve productivity and streamline your workflow. - [How to convert PowerPoint to Microsoft Sway](https://www.thetraininglady.com/convert-powerpoint-to-sway/): There is no doubt that Microsoft Sway is a fun program to create engaging presentations or Sways. But the thought of converting all your existing content into a Microsoft Sway may be too much to handle. Thankfully this is an easy process and will allow you to move your PowerPoint presentations into Microsoft Sway with a few clicks of the mouse. - [How to add Seesaw into Microsoft Teams](https://www.thetraininglady.com/add-seesaw-teams/): Many schools are now utilising Microsoft Teams for online classes which is amazing. However if like my children's school, you use the Seesaw app for student learning, portfolios and communication, how can you integrate this into your Microsoft Teams environment? - [Creating an Excel drop down list](https://www.thetraininglady.com/excel-drop-down-list/): If you have ever seen a drop down menu in Excel and wondered how to set one up, you are in the right place. Creating an Excel drop down list is a simple way to improve accuracy, speed and consistency in your worksheets. In this post I will show you exactly how to create, edit and manage drop down lists so your data entry becomes cleaner and consistent. - [How to access OneNote Online](https://www.thetraininglady.com/access-onenote-online/): Being able to access OneNote online offers convenient and flexibile access to your notes from anywhere with an internet connection. Whether you're at work, traveling, or away from your primary device, accessing your OneNote notebooks online ensures that your crucial information is always within reach. - [How to navigate in Microsoft Teams](https://www.thetraininglady.com/navigate-microsoft-teams/): If you are new to Microsoft Teams, this article is for you. Here I will outline how to log in to Microsoft Teams, the Teams window, how to change your account settings, and show you some quick shortcuts for moving around the program efficiently. - [How to see all participants in a Microsoft Teams meeting](https://www.thetraininglady.com/see-participants-teams-meeting/): Microsoft Teams provides an amazing collaboration and communication platform which builds in many fantastic features including video conferencing, file sharing, chat and more. One of the common questions I am asked relates to being able to see all participants in a Teams meeting at the same time. By default Teams provides a Gallery view of all participants who have their video enabled however if you are involved in a larger meeting you may find it frustrating that you cannot see everyone at once. - [How to share a Microsoft Form](https://www.thetraininglady.com/share-microsoft-form/): Microsoft Forms is a great program which allows you to create interactive forms including surveys, quizzes, evaluations and much more. Once you have created the form, you are going to need to share that form with others. Those people may be located within your organisation or be an external party. Let's explore the options on how to share your Microsoft Form with others. - [How to create a concentration game using PowerPoint](https://www.thetraininglady.com/concentration-game-powerpoint/): Recently I saw a question asking how to create a "memory game", or a game of concentration using Microsoft 365. While there are third-party programs that can do this, I assumed that there would be a way to create this using PowerPoint. I've created lots of fun games using Microsoft PowerPoint in the past. The idea of creating a game of concentration was going to take some deep thinking. This is the stuff that keeps me up at night. - [How to create a spelling test online using Microsoft Forms](https://www.thetraininglady.com/spelling-test-forms/): A great question I saw online related to creating a spelling test using Microsoft 365. The teacher did not want students to have access to a spell check function for obvious reasons. This ruled out using Microsoft Word or PowerPoint. With this in mind, I suggested creating a spelling test using Microsoft Forms, in conjunction with Microsoft Stream. ## Pages - [Microsoft Planner Tips & Tricks](https://www.thetraininglady.com/microsoft-planner/): Microsoft Planner is a task management tool designed to help individuals and teams plan, organise, and track their work effectively. - [Microsoft Teams Online Courses](https://www.thetraininglady.com/online-courses/microsoft-teams-online-courses/): Learn to use Microsoft Teams efficiently by attending an online course with The Training Lady - [Microsoft Teams Tips & Tricks](https://www.thetraininglady.com/microsoft-teams/): Microsoft Teams is a program which is part of the Microsoft 365 suite (formerly called Office 365) of products. Teams is designed to provide a centralised area where users can collaborate with colleagues or a group on projects to share ideas and communicate. - [Microsoft Word Online Courses](https://www.thetraininglady.com/online-courses/word-online/): Explore our Microsoft Word online courses covering features from introduction through to advanced. - [Microsoft PowerPoint Online Courses](https://www.thetraininglady.com/online-courses/powerpoint-online/): Learn to use Microsoft PowerPoint efficiently by attending an online course with The Training Lady - [Microsoft Outlook Online Courses](https://www.thetraininglady.com/online-courses/outlook-online/): Our Outlook training courses can be conducted across any version of Microsoft Office including Microsoft Outlook 2013, Outlook 2016, Outlook 2019 and Outlook 365 and Outlook Online. - [Microsoft OneNote Online Courses](https://www.thetraininglady.com/online-courses/onenote-online/): Microsoft OneNote is an amazing note taking application which allows you to centrally manage your notes. Our OneNote online training courses will inspire you to use OneNote in your day to day activities. - [Microsoft Excel Online Courses](https://www.thetraininglady.com/online-courses/excel-online/): If you’re ready to improve your Microsoft Excel skills, draw more insights from your data and discover how to use Excel more efficiently, our Excel courses are for you. - [Online Courses Australia](https://www.thetraininglady.com/online-courses/): More than ever, staff need to be upskilled to work productively. Why not start with an online course with The Training Lady. - [Thank you](https://www.thetraininglady.com/thank-you/): Please check your inbox and spam folders for an email to confirm your subscription.  - [Microsoft OneNote Tips & Tricks](https://www.thetraininglady.com/microsoft-onenote/): Microsoft OneNote is a digital note-taking application that allows users to create, organise, and share notes across multiple devices. For those wondering how to use OneNote, it functions as a digital notebook where users can capture text, images, audio, and even handwriting. - [Microsoft Sway Tips & Tricks](https://www.thetraininglady.com/microsoft-sway/): Microsoft Sway provides an easy way for users to create and share interactive reports, personal stories, presentations, and more. - [Microsoft Forms Tips & Tricks](https://www.thetraininglady.com/microsoft-forms/): See my tips and tricks for using Microsoft Forms more efficiently. Explore this amazing application which allows you to create online surveys, quizzes and polls making it easy to share with others.  - [Leading a Digital School Conference (2019)](https://www.thetraininglady.com/lds2019/): Thank you for attending one of my sessions the IWBNet Leading a Digital School Conference held at Crown Promenade Hotel, Melbourne in August 2019. If you would like more information relating to the session you attended, just click the link below. - [Microsoft Windows 10 Tips & Tricks](https://www.thetraininglady.com/microsoft-windows-10/): See my tips & tricks for using Microsoft Windows 10 more efficiently below. Content is added on a regular basis so be sure to follow me via Facebook, Twitter, RSS or via our Newsletter updates. No posts found. - [Microsoft Windows 8 Tips & Tricks](https://www.thetraininglady.com/microsoft-windows-8/): See my tips & tricks for using Microsoft Windows 8 more efficiently below. Content is added on a regular basis so be sure to follow me via Facebook, Twitter, RSS or via our Newsletter updates. No posts found. - [Microsoft Windows 7 Tips & Tricks](https://www.thetraininglady.com/microsoft-windows-7/): See my tips & tricks for using Microsoft Windows 7 more efficiently below. Content is added on a regular basis so be sure to follow me via Facebook, Twitter, RSS or via our Newsletter updates. No posts found. - [Newsletter](https://www.thetraininglady.com/newsletter/): If you would like to receive our monthly newsletter simply sign up below. - [Computer Training](https://www.thetraininglady.com/training/): Why not have “The Training Lady” come to you. With over 18 years experience I am available for onsite computer training in the greater Sydney area. I specialise in customised onsite computer courses for the Microsoft Office suite of products including Access, Excel, Outlook, PowerPoint, Publisher, Visio, Word and web applications including WordPress. - [Need Assistance?](https://www.thetraininglady.com/requests/): No problems, contact me with an outline of the issue or special request and I'm more than happy to help. I can be contacted via the Contact Me page above. - [Microsoft Windows Tips & Tricks](https://www.thetraininglady.com/microsoft-windows/): Microsoft Windows is the chosen operating system for any PC based computer.  - [Microsoft PowerPoint Tips & Tricks](https://www.thetraininglady.com/microsoft-powerpoint/): Whether your a child in school or an adult at work, Microsoft PowerPoint can be fun for all. - [Microsoft Outlook Tips & Tricks](https://www.thetraininglady.com/microsoft-outlook/): Microsoft Outlook is more than just an email program! - [Microsoft Word Tips and Tricks](https://www.thetraininglady.com/microsoft-word/): Want to get more out of Microsoft Word? Whether you're writing a letter, updating your resume, creating a report, or adding cross-references and cover pages, Microsoft Word has powerful tools to help you work smarter. Discover easy-to-follow tutorials, helpful tips, and time-saving tricks to take your documents from plain to professional. Explore the latest Microsoft Word features and learn how to use Word like a pro. - [Microsoft Excel Tips & Tricks](https://www.thetraininglady.com/microsoft-excel/): Without a doubt, Excel is the most popular data analysis tool on the planet! Learning how to use Excel should be high on anyone's priority list. - [Contact](https://www.thetraininglady.com/contact/): Submit - [Recent Posts](https://www.thetraininglady.com/blog/): Recent Posts How to use the Embed card in Microsoft Sway Microsoft Sway The Embed card in Sway allows you to add a wide range of media and interactive content to your presentation. Your Sway can include videos, audio, forms, maps, documents and content from many other online services. Sway will allow you ...Read More September 1, 2026 / Communication, Design, Education, Images, Microsoft Sway, Presentation, Video, YouTube How to use PowerPoint Animation like a pro Microsoft PowerPoint The use of PowerPoint Animation can enhance a presentation by adding movement and visual interest to text, images and other elements. When used correctly, animations help draw attention to important information, guide audience focus and make presentations more engaging. The ...Read More August 24, 2026 / Microsoft PowerPoint How to create a OneNote Class Notebook Microsoft OneNote OneNote is not just for business; it’s use in the classroom offers numerous benefits for both teachers and students. It acts as a versatile digital notebook, allowing teachers to organise lesson plans, resources, and assignments all in one place. Using ...Read More August 17, 2026 / Class NoteBook, Collaboration, Education, Microsoft OneNote, Note Taking, Teamwork How to add date based questions in Microsoft Forms Microsoft Forms Microsoft Forms includes a variety of question types which help you collect information in different ways. Depending on the type of data you need, you can choose from options such as Text, Choice, Rating, Likert, Ranking, File Upload, Net Promoter ...Read More August 10, 2026 / Collaboration, Communication, Dates, Forms, Microsoft Forms, Quiz How to bulk rename files in a folder (Windows 11) Microsoft Windows If you have dozens or even hundreds of files with generic file names such as IMG_0001, IMG_0002, and IMG_0003, renaming them one at a time can be a frustrating and time-consuming task. Thankfully Windows 11 includes a simple built-in feature ...Read More August 4, 2026 / Customisation, Documents, Images, Microsoft Windows, Productivity How to set Out of Office in Outlook Microsoft Outlook There is nothing quite like the day before you're about to head off on a well-earned break. You finish your last few tasks, tidy up your inbox, and get ready to shut down your computer. Before you leave, though, there ...Read More July 24, 2026 / Calendar, Communication, Contacts, Email, Meetings, Microsoft Outlook How to get separate Chat and Teams back in Microsoft Teams Microsoft Teams For years, Microsoft Teams displayed Chat and Teams as separate icons in the app bar on the left side of the screen. Then Microsoft introduced a new experience that combined chats, channels and teams into a single Chat area. Lots ...Read More July 20, 2026 / Collaboration, Communication, Customisation, Microsoft Teams How to use Tags in OneNote Microsoft OneNote If you are using OneNote then you'll know how quickly notebook can fill up with notes, project ideas, research, and to-do lists. This makes finding important information a challenge, but that is where tags come into play. What is a ...Read More July 13, 2026 / Class NoteBook, Microsoft OneNote, Note Taking, Productivity How to show duplicates in Excel Microsoft Excel A very common request in any of my Excel courses is "how to show duplicates in Excel". When we are working with any data set you may need to be alerted when duplicate records exist. This process is surprisingly simple ...Read More July 6, 2026 / Conditional Formatting, Data Analysis, Formatting, Microsoft Excel, Productivity What is a paragraph mark in Word? Microsoft Word If you have ever opened a Word document and suddenly seen strange symbols like dots, arrows, or a backward “P” (¶), you are not alone. Today I want to introduce you to a range of symbols, and in particular, the ...Read More June 29, 2026 / Documents, Formatting, Long Documents, Microsoft Word How to Duplicate a Plan in Microsoft Planner Microsoft Planner Microsoft Planner is often used for recurring projects, team processes, onboarding tasks, event planning, and department workflows. Many teams get to the end of a project and then assume they need to recreate the entire Planner structure for the next ...Read More June 22, 2026 / Microsoft Planner How to make a timeline in PowerPoint Microsoft PowerPoint Timelines are a great way to show events, project stages, milestones, or important dates in a visual format. They can be useful in everything from a business presentation, training session, project update, and even make fantastic classroom resources. I've had ...Read More June 14, 2026 / Microsoft PowerPoint How to delay sending email in Outlook Microsoft Outlook During a recent Outlook training session I was asked if it's possible to delay sending an email? This question is a common one and is often followed by a story about an email sent a little too quickly, a forgotten ...Read More June 7, 2026 / Microsoft Outlook How to use the Group cards in Sway Microsoft Sway The Group card provides a way to easily display a set of cards in a neatly organised way. There are five (5) different group types to choose from. You can choose to either create each group type from scratch or ...Read More February 17, 2026 / Design, Images, Microsoft Sway, Presentation How to add or remove members in Microsoft Planner Microsoft Planner Managing members in Microsoft Planner is important to ensure the right people have access to your plan and can contribute effectively. Most plans in Microsoft Planner use a Microsoft 365 Group to manage its membership. The Microsoft 365 Group identifies ...Read More February 8, 2026 / Collaboration, Microsoft Planner, Task Management, Teamwork How to use Sections in Microsoft Teams Microsoft Teams If you’re anything like me, your Microsoft Teams list can start looking like a messy wardrobe with teams everywhere, channels scattered, and you can never find what you need when you need it. That’s where sections come in. They’re like ...Read More January 27, 2026 / Accessibility, Communication, Customisation, Microsoft Teams, Productivity How to delete individual quiz responses in Microsoft Forms Microsoft Forms When users, or "respondants" complete a quiz or survey using Microsoft Forms, the response is saved and can be viewed at any time. By default, each user is provided an option to Submit another response at the end of the ...Read More January 14, 2026 / Communication, Education, Microsoft Forms, Quiz, Survey How to rename a OneNote Notebook Microsoft OneNote I remember the first time I wanted to rename a notebook in OneNote, I thought it would be as simple as right-clicking and typing a new name. However working with OneNote notebooks has always been a little different to other ...Read More December 31, 2025 / Class NoteBook, Education, Microsoft OneNote, Note Taking How to remove a page break in Word Microsoft Word Anyone who has had to work with a longer Word document will have encountered page breaks. A page break allows you to choose when a new page will begin. So what happens when you open a document and need to ...Read More December 22, 2025 / Design, Documents, Education, Long Documents, Microsoft Word, Productivity How to show Hidden Files in Windows 11 Microsoft Windows Sometimes when I am running a training session, I encounter technical issues with a participants computer. Because I have an IT background in network support, I am generally able to fix most of these issues when they arise. One step ...Read More December 15, 2025 / Customisation, Microsoft Windows How to import tasks from Excel into Planner Microsoft ExcelMicrosoft Planner With the popularity of Microsoft Planner continuing to go up, I often have people ask me how they can get a list of tasks which have been tracked using Excel, and move them into Microsoft Planner without the need to ...Read More December 9, 2025 / Microsoft Excel, Microsoft Planner, Productivity, Task Management How to allow other users to edit a Microsoft Form Microsoft Forms When creating a form using Microsoft Forms, the form is stored within your personal Microsoft 365 account. The form is then shared to collect responses. But what if you want to allow other users in your organisation to edit the ...Read More December 2, 2025 / Collaboration, Microsoft Forms, Teamwork How to upgrade Planner Plan from Basic to Premium Microsoft Planner For those people using Microsoft Planner you will have noticed some Premium options available. Microsoft Planner has several licensing options available from the basic Microsoft Planner included with any Microsoft 365 subscription, to Microsoft Planner Plan 1, Planner and Project ...Read More November 24, 2025 / Collaboration, Communication, Microsoft Planner, Task Management What is a circular reference error in Excel? Microsoft Excel I recently had an email from a client asking me to assist with an error in one of their Excel files. I opened the file to take a look and immediately the error appeared: "There are one or more circular ...Read More November 16, 2025 / Formulas, Functions, Microsoft Excel 1 2 3 … 9 › - [TIPS & TRICKS for Microsoft Office & Windows](https://www.thetraininglady.com/): Search below or use the buttons below to filter articles by category.. - [About Me](https://www.thetraininglady.com/about-me/): Hi! My name is Belinda Anderson, and I'm "The Training Lady". I decided to start this blog after a suggestion from my wonderful mother... You see, I'm a software trainer and I love what I do, so why not share that online, with those who can benefit from what I have to offer. ## Categories - [Microsoft Excel](https://www.thetraininglady.com/ms-excel/) - [Microsoft Forms](https://www.thetraininglady.com/ms-forms/) - [Microsoft OneNote](https://www.thetraininglady.com/ms-onenote/) - [Microsoft Outlook](https://www.thetraininglady.com/ms-outlook/) - [Microsoft Planner](https://www.thetraininglady.com/ms-planner/) - [Microsoft PowerPoint](https://www.thetraininglady.com/ms-ppt/) - [Microsoft Sway](https://www.thetraininglady.com/ms-sway/) - [Microsoft Teams](https://www.thetraininglady.com/ms-teams/) - [Microsoft Windows](https://www.thetraininglady.com/ms-windows/) - [Microsoft Word](https://www.thetraininglady.com/ms-word/) ## Tags