Bradley Virtual Assistants, LLC

Bradley Virtual Assistants, LLC Bradley Virtual Assistants, LLC (BVA) is committed to providing you with the best possible administrative and training services possible.

Superior Administrative Support and Training Services

05/21/2018

Create simple formulas without leaving Word
(Word 2016/2013/2010)

Though Excel is the numbers powerhouse of the Office suite, Word can hold its own when you need to run some basic calculations in a Table.

For example, to add all of the numerical values to the left of the current cell, simply select the Table Tools Layout contextual tab on the main ribbon, and click on Formula in the Data group. In the resulting Formula dialog box, in the Formula text box, type =SUM(LEFT) and click OK. Similarly, you can use =SUM(RIGHT), =SUM(ABOVE), and =SUM(BELOW) to calculate numerical data to the right of, above, and below your selected cell. You can explore the Paste Function dropdown list in the Formula dialog box to see other formula options, such as AVERAGE, MIN, and ROUND.

When necessary, you can use specific cell references, such as A1 or B3, instead of directional arguments. This way, you click in cell B5 and type the formula =SUM(B2:B4) to find the total without including cell B1. You could even add nonadjacent cells using the formula =SUM(A3,B2,C5).

Important: These Word formulas use field code. If you make a change to the data in your table that will affect a calculation, right-click on that field to recalculate it.

NICE!

01/08/2018

Create a quick table total without even writing a formula
(Excel 2016)

Once you’ve created a well-formatted Excel table, you can easily add another row that totals the table columns above—no equation needed. To add a total row to your Excel table, simply click inside the table and press [Ctrl]+[Shift]+T. Excel automatically places the total row, and adds the proper formatting, all in one step.

Swish...

01/03/2018

Keep your Inbox trim in 2018 - eliminate redundant Conversations and keep your Inbox trim (Outlook 2016)

Outlook has unleashed a new tool to cut down the clutter in your Inbox. When someone sends an email to multiple recipients, and then someone responds, the collection of emails is called a Conversation (many of us call this an email “thread”). Outlook’s new Conversation Clean Up feature removes all previous emails from a Conversation if the content of the previous emails is included in the most recent email.

To use Conversation Clean Up, click on the Home tab on the main ribbon. In the Delete group, click on Clean Up. Three options appear: Clean Up Conversation, Clean Up Folder, and Clean Up Folder And Subfolders. Choose the option you prefer, depending on the level of change you want to see. You might choose to start small by first testing out this feature on a single Conversation before moving on to your entire folder and subfolders.

12/21/2017

For my Excel users -

If you'd rather not use concatenate try this...

Copy first and last names into separate cells without retyping (Excel 2016/2013/2010)

If you have a spreadsheet containing a list of people’s names, and each first and last name is in a single cell, you can break the first and last names into separate cells without having to retype each name yourself. If your list is long, you’ll not only save time but also reduce the very likely possibility of introducing errors.

To start, open a worksheet that contains a list of first and last names in Column A. Ensure that Column B and Column C are empty. Make Row 1 a header row labeled Name. Label cell B1 First Name and cell C1 Last Name.

Let’s say A2 contains the name Janet O’Neal. Click in B2, then type =LEFT(A2,FIND(" ",A2)-1) in the Formula Bar and press [Enter]. To place the last name in C2, click in that cell and then type =RIGHT(A2,LEN(A2)-FIND(" ",A2)). To copy the formulas for every name on the list, select cells B2:C2 and drag the selection box in the lower-right corner of the cells to the end of the list of names.

If your list of names follows a Lastname, Firstname format (such as O’Neal, Janet), you’ll need to reformat the names to Firstname Lastname format (Janet O’Neal) before you follow the instruction above. To do this, insert a column to the right of your names. Assuming the name you wish to transpose is in A3, click in B3 and then type =MID(A3,FIND(",",A3)+2,LEN(A3)) & " " & LEFT(A3,FIND(",",A3)-1).

10/01/2017

Remember to treat eachother kindly in all situations. We need one another! BVA

09/05/2017

Move table rows quickly - no cut and paste required!
(Word 2016/2013/2010)

Do you insert a new row, then cut and paste your data every time you have to move a table row? If so, you’ll be pleased to know there’s no need for all that extra work. Instead, select the row you wish to move and press [Alt][Shift][Up Arrow] to move the entire row up one level. Continue pressing this key combination until your row is in the proper location. To move a row down, press [Alt][Shift][Down Arrow]. If you need to move more than one contiguous row at a time, select them all and use the same key combination.

Enjoy!

Live life as the masterful creation you were created to be. The world is waiting - breathlessly.
08/10/2017

Live life as the masterful creation you were created to be. The world is waiting - breathlessly.

07/17/2017

Proper page numbering (Word 2016/2013/2010)

Numbering the pages in your document is quite helpful for referencing specific sections, but you may not always want to start numbering on the first page. For example, you may want to start numbering on the fourth page of a document - after your cover page, list of figures, and table of contents. You can! - by using unlinked sections to effectively turn page 4 of your document into page 1.

Open your document and navigate to the first page you’d like to number. Click on that page, then select the Layout tab. In the Page Setup group, choose Breaks | Next Page. For this example, we’re going to place the page numbers in the footer, so double-click in this page’s footer to open the Header And Footer Design contextual tab on the main ribbon. In the Navigation group, deselect the Link To Previous button.

In the Header And Footer group, click on Page Number and select the style you prefer. (Don’t worry if you see the wrong page number appear when you make this selection.) Next, choose Page Number | Format Page Numbers. In the resulting Page Number Format dialog box, in the Page Numbering area, click in the Start At spinbox and change the number to 1. Click OK.

Tip: You can maintain linked headers while unlinking footers, and vice versa, so starting your page numbering in a footer on the fourth page of your document doesn’t mean that you can’t include your name or other information in a header that starts on the first page

07/05/2017

Acrobat DC - Save your toner and mark up PDFs right in Acrobat

Proofreading a hard copy of a PDF document has its benefits. But if your document is extremely long, printing it out could very well be a waste of time and toner. Especially considering Acrobat has features that allow you to do many of editing tasks electronically! The Comment tools in Acrobat DC provide a means to highlight text, add a sticky note, add or edit text on the page, draw freeform with a pencil, and more.

The Highlight and Sticky Note tools appear in the main toolbar by default. To highlight text, select the Highlight Text tool and then select text in the PDF that you wish to highlight. To add a sticky note, click the Add Sticky Note tool and then click on the pdf in a spot that you want to add a sticky note. Your typed comment will appear in a box automatically labeled with your username. Enter your note, then click the Post button. Click the X in the box to close it, and your comment appears on the right side of the screen. Acrobat also places a small text bubble in a box icon on the page which you can hover over to read the note.

To access the remaining Comments tools choose View > Tools > Comment > Open.

06/08/2017

Striving for excellence is a daily goal at BVA!

03/16/2017

In all things strive for excellence. Even if you do not make it this turn, there is always the next corner. D

05/16/2016

Previously, I posted how to use style and modify files - now ...

Create your own formatting style

If you've ever wanted to create a formatting style that's different than any of the currently available styles, you'll be glad to know that there's an easy way to do it. First, select the cell that has the combination of formats that you want to include in the new style. Then, choose Style from the Format menu and in the Style name box, type a name for the new style. To define and apply the style to the selected cells, click OK. To define the style without applying it, click Add, and then click Close. Also, if no cells have the formats you want for the style, you can specify the formats when you name the style.

Style on....

Address

Union City, GA
30291

Opening Hours

Monday 8:30am - 5:30pm
Tuesday 8:30am - 5:30pm
Wednesday 8:30am - 5:30pm
Thursday 8:30am - 5:30pm
Friday 8:30am - 5:30pm
Saturday 12pm - 6pm

Telephone

404-969-9124

Website

Alerts

Be the first to know and let us send you an email when Bradley Virtual Assistants, LLC posts news and promotions. Your email address will not be used for any other purpose, and you can unsubscribe at any time.

Shortcuts

Share

Category