How to Protect your Eyes from Blue Light

Did you know that constant exposure to the bright blue-spectrum light from your phone and computer screens can stunt your productivity and have negative effects on your eyes? On today’s One-Minute Wednesday, we’re reviewing an easy-to-use app called F.lux (Flux) that mitigates those harmful effects on your eyes.

Dominate Your Inbox: Outlook Categories

Keep your email organized and stay ahead of important emails with this simple tool! On this week’s One-Minute Wednesday, John McCormack will be talking about how you can use Categories to highlight VIP emails and keep track of important notifications. When you’re buried under a flood of emails, this can really help critical messages stand out in your inbox.

Dominate Your Inbox: Creating a CC Folder

Take control of your inbox and reclaim your productivity with this quick tip! This week on One-Minute Wednesday, Matt Grimes will be showing you how to create a CC folder for emails where you’re not the direct recipient. This is a great way to manage emails where you don’t need to respond immediately, freeing you up to work through your day.

Creating an Excel Chart

Visualize your data with Excel charts! On this week’s One-Minute Wednesday, Greg Deleon will be showing you how to quickly turn a range of cells into a chart. This is a great way to understand and communicate your data when working with Excel.

Collaborating in OneDrive

One of the major advantages to OneDrive is how it facilitates real-time collaboration on documents hosted in the cloud. On this week’s One-Minute Wednesday, Isaac McIntosh will show you how to share documents, customize your sharing settings, and work on files with others in real time.

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 Applications for Mac

Improve productivity by automatically booting Mac applications! On this week’s One-Minute Wednesday, Andy Shin will be showing you how to add applications to your Login Items list on your Mac. This will allow you to access commonly-used applications immediately when you start your computer.

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.

Dominate Your Inbox: Archiving Completed Email

Keep your inbox clean, uncluttered, and easy to read with the Archive quick step! On this week’s One-Minute Wednesday, Yung Min will be showing you how to create an Archive folder, plus a quick step that will allow you to mark emails as read and move them into your archive with a single click (or keyboard shortcut). Never let old emails that have been addressed clutter up your inbox again!

Create Custom Keyboard Shortcuts for Mac

Save time with customized keyboard shortcuts! For this episode of One-Minute Wednesday, Drew Lawson will be showing you how to create custom keyboard shortcuts for any application on a Mac. If you’ve ever found yourself regularly using a command that doesn’t have a native shortcut, you’ll love knowing how to create one yourself.

Fix Website Errors by Clearing Your Cache

Dealing with a misbehaving website? Try clearing your cache! On this week’s One-Minute Wednesday, Isaac McIntosh will be talking about clearing your browser’s stored cache and cookies. Learn how to do this and why it can help resolve some minor website errors.

Organize Data with Excel Tables

Learn how to efficiently organize data with Excel tables. On this One-Minute Wednesday, we’ll be showing you how to use tables in Microsoft Excel, which allow you to automate things like sorting, formulas, and more.

Save Time with Excel AutoSum

Save time with this handy Excel function! On this episode of One-Minute Wednesday, Amber Brito will be going over AutoSum functionality in Excel. This is a quick way to calculate the sum of a range of numbers in Excel.

Outlook Meeting Responses

For this episode of One-Minute Wednesday, Matt Grimes will be talking about the meeting invitation responses available to you in Microsoft Outlook. These options allow you to quickly respond to a meeting invite with comments, a new time proposal, and so on.