Category «Microsoft»

Use Different Color Pages in Word Document

“But I want to change different pages to different colors in a Word document”
Feeling a bit chagrined but undaunted, I set out to find a workaround.

Apply Dynamic Conditional Formatting in a PivotTable

Love using MS Excel’s conditional formatting feature? Learn to use it in PivotTables so that the formatting is as dynamic as your source data.

Using Multiple Monitors for Presentations

Hello Everyone! Welcome (or welcome back) to my blogs that help you work more efficiently and that answer some common questions regarding productivity in your work space. Today we will look at presenting on multiple monitors using Teams so that you can see (but your audience cannot): Your Slides Your Notes The Next Slide Did …

Sharing Presenter Views in Teams

Stephanie Hutcheson, MCT October 4, 2021 Engage your audience with presenter modes Meeting participants tend to be more focused and have a better experience when they see a presenter along with a presentation. An interactive presenter also helps guide an audience along with visual cues while reducing information overload. By using a presenter mode such …

Get Add-ins for PowerPoint

by Stephanie Hutcheson, MCT Updated November 28, 2023 Extend the power of your Microsoft Applications by using the Add-ins feature. Add-ins are supplemental programs that add custom commands or custom features to Office programs. You can obtain add-ins for PowerPoint at Popular Office downloads (A Microsoft Site) or on third-party vendor websites. If you are a developer, …

Protecting Excel Data from Updates

When you’re not in the mood for change! Protecting the Workbook Structure Protecting the workbook structure prevents the user from viewing hidden worksheets, adding, moving, deleting, hiding, or renaming them. You can protect the structure of your Excel workbook with a password if you choose, but it is not necessary. Review–Protect Workbook Choose Protect Workbook …

Custom (Personal) Office Template Choices

Templates are terrific timesavers and great for consistency. You have created the template, saved it but when you try to access the template you do not see the choice Personal or Office. This is a frustrating scenario so below are some instructions that hopefully will solve this problem. Change Template Options Change your options to …

Leading Zeros in Excel

Hi there Excel users! Stephanie Hutcheson here. Trying to save the world some headaches. I frequently get asked to explain how to show leading zeros in Excel. It’s so frustrating when a leading zero drops from your worksheet. While you can format it as text or type an apostrophe in front of it, you may …

Combining Shapes: MS PowerPoint

Creative Solutions with Shapes and Logos Insert the shape with which you want to begin (In this case a rounded corner rectangle) Figure 1 Insert the next shape you want to use for your completed shape (In this case I chose the diamond) Use the align features to center and align horizontally until you are …

MS Project Tips for New Users

Many users feel confident about slipping into MS Project–until they don’t. Once they experiment, frustration sets in quickly. Project is one of those programs that is not self-explanatory. It relies on fundamental Project Theory and uses calculations accordingly. As I often state in my classes, Project makes you Engage the Brain, UGH!! Here are a …