September 2016 - Page 2 of 13 - AdvantEdge Training & Consulting
Excel

Grouping Rows in Excel

Hiding certain rows or columns in Excel can make viewing complex, detailed information easier to read. Grouping Rows in Excel allows you to quickly collapse and expand similar data to create more useful views. Select the rows with similar data by clicking and dragging on the rows numbers to the left of your data. Note that your grouping sections must be contiguous. Control-clicking won’t work. Click on Group under the Data tab. Grouping sections 1 and 2 will appear to the left as shown in this example. Repeat this process for all of the contiguous sections in your data. Collapse specific sections by clicking on the “–” sign, or expand them by clicking on the “+” sign. Collapse all similar sections by clicking on the 1 in the column label row. The 2 will expand all of the similar sections. For more ways to make Excel work for you, take a training course from AdvantEdge Training & Consulting!

Grouping Rows in Excel Read Post »

Excel

Capitalizing the first letter of each word in Excel with the Proper function

Have you ever imported data that was in all caps, or all lower case? There is a quick trick for capitalizing the first letter of each word in Excel. =Proper(Cell) formula in Excel In this example, I copy and pasted a list of the 3 most expensive paintings of all time. The ‘Proper’ function allows me to quickly transform the data so that every word is capitalized. Simply type =proper(The cell you need to change). For more ways to make Excel work for you, take a training course from AdvantEdge Training & Consulting!

Capitalizing the first letter of each word in Excel with the Proper function Read Post »

Excel

Microsoft Excel: Conditional Formatting for Understanding Data

Applying Conditional Formatting to your data allows you to identify variances in a range of data with a quick glance, by highlighting the differences or trends that you specify. You can customize the process by creating your own rules to apply to selected data. To apply conditional formatting: Select the data range. Click the Home Tab. In the Styles Group, click Conditional Formatting. Select New Rule. The New Formatting Rule dialog box will open. Select a Rule Type: In this section select the type of criteria you want to use to determine formatting. In my example I am using Format only cells that contain. Edit the Rule Description: In this section determine which criteria to apply to the selected area. In my example I will be formatting based on the Cell Value applying the condition less than or equal to 150. Click the Format. The Format Cells dialog box appears. Select the formatting to be applied. In our example we will be changing the font color to red and making the text bold. You can also add a border or fill. Click OK twice. Formatting will then be applied. Repeat the process to apply additional formatting to a selected area. For more ways to make Excel work for you, take a training course from AdvantEdge Training & Consulting!

Microsoft Excel: Conditional Formatting for Understanding Data Read Post »

Excel Example
Word

Word: Quickly Adding Captions

You can easily and quickly add captions to a picture, table or equation. Once you have created the caption you can cross reference it anywhere in the document. The ‘Insert Caption’ command is located in the Reference tab, in the Captions group. When selected, a dialog box helps setup your caption. Now you can cross reference the figure as follows: Figure 1: MCS Logo To Cross Reference the figure, use the Cross Reference command located in the Reference tab, in the Captions group. When selected, a dialog box will help with the setup, which looks like the following: Note that you can insert a hyperlink to the caption, allowing for quick navigation to the figure, as shown when hovering over the cross reference with the cursor (below). Get the skills to make polished and professional documents with a Word training course from AdvantEdge Training and Consulting

Word: Quickly Adding Captions Read Post »

Word

Bring Calculator right into Word

Word allows you to write out equations right in the text field, as well as find out what the equation’s total is. You only need to set up Calculator. To do this, go to File Options Quick Access toolbar. Select All commands in the drop-down menu, and scroll down for Calculate. Click on the Add button. You’ll see it appear on your Quick Access toolbar as a small gray circle. To use it, you only need to type out a mathematical equation. For instance, type out 10+5, highlight your equation, and click on the button. The result appears in the lower left side of the taskbar. For more ways to make editing documents easier, check out AETC’s Word Training Classes.

Bring Calculator right into Word Read Post »

Word

Word Keyboard Functions

Many of today’s users prefer using the keyboard for as many functions as possible. If you are this type of user, here is a keyboard short cut for removing some different types of formatting quickly and easily. If you prefer to use your mouse, that is still an option but you might want to give this a try! Quickly remove formatting If text has been formatted and you want it to appear back in its original state, just click on the word or section of text and press [Ctrl] + [Space] simultaneously. To remove any formatting with a style, click on [Ctrl] + [Shift] + [N] and it will go back to the default style. Applying Bold and Italics To apply Bold or Italics to text, either select the desired text or click within the desired word, and press [Ctrl] + [B] to make text Bold, and [Ctrl] + [I] to make it Italics.  The same shortcut keys can be used to change Bold or Italic text back to normal formatting. For more ways to make Word work for you, take a training course from AETC!

Word Keyboard Functions Read Post »

Excel, Word

Separating Word document information in Excel

There are times that information has been exported or written in such a manner that it appears something like this:Mouse; Mickey; 222-333-4444Mouse; Minnie; 222-333-4444Duck; Donald; 222-333-4444Sam; Yosemite; 222-333-4444Dog; Pluto; 222-333-4444Duck; Daffy; 222-333-4444Coyote; Wile E.; 222-333-4444Bird; Tweety; 222-333-4444Cat; Sylvestor; 222-333-4444If this information needs to be quickly placed in an Excel table, it can be done by using the Text to Column command. Copy information and paste in Excel. Under the Data tab, click the Text to Columns command This will show the selected data to be altered, so ensure the information selected is correct. Once data confirmed, click the Next button. Select the symbol being used to separate the information, in this case it is a semi-colon. Once selected, you will see the information separate. Confirm and click Next. The next screen will allow you to place data in the cells you want to start with and what type of format to initially use for the information. Once completed, click Finish. The finished product looks like the following: From here, information can be inserted into table or headers can be added.   For more ways to make your work easier and more polished, check out our Word and Excel training courses

Separating Word document information in Excel Read Post »

If you have at least 5 people we can create a session just for you.  Or, you can contact us for a private session. Contact Us

Questions? Don't see what you need?

We can help!

Business Training Classes
AdvantEdge Training & Consulting, Inc.

Recent Posts

Subscribe to our Newsletter

Copyright AdvantEdge Training & Consulting

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Scroll to Top