Today’s quick tip shows you how to use the SORT function to keep your dropdown list items in A-Z sort order in Excel and Sheets. This video assumes prior knowledge of Data Validation for dropdown lists!
In this quick tip we show you how to make use of the powerful TOROW and TOCOL functions that allow you to combine data from a range of cells into a single row or column. The process is exactly the same in Google Sheets and Microsoft Excel.
In today’s quick tip we show you how to use Excel’s Navigation Pane to quickly and easily move around within your workbooks. Quickly switch between named ranges, tables, search for content and more.
In this quick tip you will learn how to send a link to a document that will take the user directly to the “make a copy” option. Great for a document that needs to be treated as a template.
In this week’s quick tip we show you how to format objects in PowerPoint or Slides using colours from anywhere on your screen. Maybe you want to use the exact colour from your logo – you can very easily with this trick!
In this quick tip we show you an alternative to the text to columns feature. Using CTRL E to apply Flash Fill you can easily split data into separate columns.
In this quick tip we show you how to find and use a feature without having to search through the menus, ribbon or toolbar if you can’t remember where it’s located.
In this week’s quick tip we show you how to create a regularly occurring Milestone in a Microsoft Project plan.
#MSProject #training #MSOffice #ITtraining
Today’s top tip shows you a way to easily navigate a document in Microsoft Word or Google Docs that contains heading styles, by using the outline and navigation panes to go straight to the paragraphs that use those styles.
In this quick tip, we show you how you to save time and effort when entering data across multiple rows and columns in Microsoft Excel and Google Sheets.