Quick analysis with Excel Conditional Formatting

Would you like a way to quickly analyze Excel data? Perhaps you want a quick snapshot of the accounts with the largest outstanding balance due. Using Excel’s Conditional Formatting feature, you can direct attention to the most crucial overdue accounts or top sales. It allows you to skip to important data with highlighted cells.

In the example below (left side), notice the Balance Owed column. Conditional formatting was used to differentiate amounts by color so that problem accounts can be quickly identified. Data bars can be used to emphasize problem accounts (center). And icons can also be used to highlight problem accounts (right side). Your preference determines which one to use.

Contact me at sharon_daniel@att.net or 561-289-9484 for support on using conditional formatting. Whether you need advice on cleaning up your data, creating formulas or solving formula issues, count on me!

Using White Space in PowerPoint

PowerPoint Tip: When designing a presentation, include white space to make the content easier to read and to emphasize key points. White space is the unused space between your content – whether that is text, shapes or pictures.

The most common presentation design mistake is to fill every inch of every slide with information and various visual elements, like the left slide below. The slide on the right is an example of using white space, with less content and open space to the left, right and below the content.

PowerPoint - remove image background

What if you added a picture on a PowerPoint slide and realize it has a background you do not want? With PowerPoint you can easily remove the picture background, as shown in the example below. With the picture selected, use the Remove Background feature on the Picture Format tab.

Contact me at sharon_daniel@att.net or 561-289-9484 for support on using the Remove Background feature. Whether you need advice on planning, developing or improving PowerPoint presentations, count on me!