Mastering Excel’s Sorting Tool
Trying organize an Excel spreadsheet filled with multiple columns of data? On this week’s episode of One Minute Wednesday, Joon Koh will be showing you how to use the Sorting tool, which gives you more control over data within your spreadsheet columns. There are multiple sorting options to work with, so tune in to learn more!
Using Filters in Microsoft Excel
Have you ever needed to sort data in a spreadsheet by a specific set of criteria, like all rows that contain a particular date? On today’s One Minute Wednesday, Susanna Jeong will explain how to use the filtering tool, which allows you to quickly and easily filter for specific sets of data in your spreadsheet.
Visualize Data with Microsoft Word Charts
Do you need a way to present data clearly and visually to your clients and team? Try using charts in Microsoft Word! On this week’s One Minute Wednesday, Matthew Sola will be showing you how to create a customizable chart that presents your data in a way that’s visual and informative.
Introduction to Microsoft OneNote
Ever wanted a single place to organize your daily agenda, keep a list of tasks, and jot down notes and ideas? On this week’s One Minute Wednesday, Jonathan Marinca will be showing you some of the basic functionality in OneNote, Microsoft’s digital collaborative note-taking application.
Sync OneNote Tasks with Outlook
Have you ever had trouble keeping up with your tasks, projects and assignments? In this week’s episode, we’ll be showing you some quick and easy steps for creating a reminder in OneNote that will notify you of your upcoming tasks via Outlook. Tune in to this week’s One Minute Wednesday to learn more!
Customize Your Outlook Search Folders
Last week on One-Minute Wednesday, we discussed using search folders to pull up emails that fit a predefined search criteria. This week, Jackson Roberts will be showing you how to customize those Outlook search folders, allowing you to organize your inbox with highly-targeted search terms. The possibilities here are endless, so if you’re looking to take control of your inbox, don’t miss this episode!
Outlook Search Folders
This week on One-Minute Wednesday, Isaac McIntosh will be showing you how to create a few examples of Outlook search folders. These folders allow you to instantly pull up any emails in your inbox that fit your search parameters, like unread emails, emails marked as important, or emails from a specific person.
View Options in Microsoft Word
Learn how to customize your view when working in Microsoft Word! On this week’s One Minute Wednesday, Paul Swanson will talk about some of the view options available to you when working in a document. These view options allow you to optimize your workspace and tailor your document display for your needs.
Excel Functions: LEFT, RIGHT, & MID
Learn how to quickly extract important characters from cells in Excel! In this episode, Gipson Lyles will be teaching you some tips on how to use the LEFT, RIGHT, & MID functions in Microsoft Excel. These functions allow you to pull specific portions of data from particular cells and move them into another cell or range.
Excel Functions: SUMIF & COUNTIF
Discover a great shortcut in Microsoft Excel that will boost your productivity and save you time! This week, Aspen Lindblom will be talking about the SUMIF and COUNTIF functions, which add or count cells that match a specified criteria. This will help you make calculations and pull information without having to manually search through your spreadsheet.
Startup Programs for Windows
Streamline your computer’s startup and start your workday sooner! On this week’s One-Minute Wednesday, Jonathan Marinca will be showing you how to add programs to your startup folder in Windows. This will allow you to set commonly-used programs to automatically launch when you start your computer.
Custom Folder Shortcuts
Never waste time searching for a folder again! For this One-Minute Wednesday, Joe Ensch will be talking about creating a custom keyboard shortcut to one of your commonly-used folders. Most people have found themselves clicking through a long series of folders just to get to something they use often, and with this shortcut you’ll never have to do that again.
Desktop View Options
Time to clean up that messy desktop! On this week’s One-Minute Wednesday, Amber Brito will be going over some of the desktop view options in Windows 10. These allow you to customize and organize your desktop, making files easier to access and decluttering your onscreen real estate.
Automatically Spell Check Emails
Never send an email with spelling errors again! On this week’s One-Minute Wednesday, Chase Powers will show you how to set up automated spell checking in Outlook. This setting automatically runs the spell checker as soon as you send an email and is a great way to keep your emails polished and professional.
Basic Excel Functions: MIN, MAX & TRIM
Get started on becoming an Excel pro with these basic functions! Last week on One-Minute Wednesday, we covered a few basic functions in Microsoft Excel, and this week, Jackson Roberts will be showing you how to use the =MIN, =MAX, and =TRIM functions. These allow you to easily find outlying values in a list and clean up messy data.
Basic Excel Functions: SUM & AVERAGE
Learn how to leverage some basic Excel functions to better manage data! On this week’s One-Minute Wednesday, Jonathan Schaumloeffel will be showing you how to use the =SUM and =AVERAGE functions to quickly add up or average out large ranges of numbers.
