|Displaying Negative Percentages in Red
Summary: Excel does not provide a built-in format to display negative percentages with brackets and in red. However, you can do this easily with a custom format. Here is how to do this:
- Select the cell or cells that contain negative percentages.
- Click on the Home tab in the ribbon.
- Click on the small icon in the lower right corner of the Number group.
- Select Custom.
- In the Type box, enter the following: 0.00%;[Red](0.00%)
- Click OK.
How do you Delete Duplicate Rows from a Data Set?
Back to top
Summary: Many data sets contain duplicate rows. Here is how to eliminate these duplicates.
- Highlight the data set (You may include/exclude the heading row).
- Select the Data tab.
- Select Remove Duplicates under the Data Tools group.
- Select OK.
- Select one or more columns that contain duplicates (you must select at least one column).
- Select OK.
- Select OK again.
The duplicate data rows will be deleted from the worksheet. Note: there is no UNDO with this command, so save your workbook before you do data elimination.
Back to top
Summary: Here's a fast way to remove borders from a group of cells.
Adding Borders around a range of cells is a useful formatting tools. There are times however, when you need to remove these borders. Here is a fast way to accomplish this task.
- Select the cells that contain the borders you want to remove.
- Press Ctrl+_.
- The third character is the underscore key and you must hold down the shift key to insert it.
This process will remove the borders but leave the rest of the formatting.
Creating a Section Break
Summary: There are times when you need to change the formatting in a document. For example, in a new chapter you want a different header and footer. This is accomplished by using a Section Break. Here is how you do this:
Section breaks allow you to change the number of columns, page headers and footers, page numbering, page borders, page margins, and other characteristics and formatting within a section. The section break retains the formatting above it, not after it.
To insert a Section Break:
- Open the document and click where you want to insert a section break.
- Click on the Page Layout tab, and click Breaks in the Page Setup group. The Breaks menu will appear.
- To create a new section, in the Sections Break Types area, select what comes after the break. You have the following options:
- Click Next Page to begin a new section on the next page.
- Click Continuous to begin a new section on the same page.
- Click Even Page to start the next section on the next even-numbered page.
- Click Odd Page to start the next section on the next odd-numbered page.
- After you have selected the Option you want, the section break is inserted.
Summary: There is often a need to send a secure one time message. For example, you might need send someone a password to access an account. You want to do this without setting up a lengthy encryption or having to deal with public and private keys. Here is how to do this::
Go to https://oneshar.es/. The site allows you create a single use message where they create a URL for their encrypted web-site and you then send this URL to your contact. They open the one-time link, read the message and as soon as the message is retrieved the message is deleted and it cannot be accessed again.
Creating Professional PowerPoint Presentations
Summary: PowerPoint presentations are a great way to support a speech, visualize complicated concepts or focus attention on a subject. However a bad presentation can achieve the opposite results. In the next three sets of Office Tips, I will be providing you with a series of tips on developing a professional PowrPoint presentation:
The first thing that gives a professional touch to any presentation is the design.
- Don't copy & paste slides from different sources.
- Keep the design very basic and simple. It shall not distract.
- Pick an easy to read font face.
- Carefully select font sizes for headers and text.
- Leave room for highlights, such as images or take home messages.
- Decorate scarcely but well.
- Restrict the room your design takes up and don't ever let the design restrict your message.
- Consistently use the same font face and sizes on all slides.
- Match colors.
- You may use your company logo, highlight headers, create a special frame for figures/images or the whole slide but don't overload your slides with these elements.
- A poor choice of colors can shatter a presentation.
- Black text on a white background will always be the best but also the most boring choice.
- If you want to play with colors, keep it easy on the eyes and always keep good contrast in mind so that your readers do not have to strain to guess what you've typed on your slide.