Affinity Consulting Blog


Easily Capture Screenshots in Microsoft PowerPoint

Do you ever need to take a screenshot of something important for a PowerPoint presentation? PowerPoint makes it easy to grab screenshots. This can be especially helpful for training sessions for using software around the office.

Sometimes you might need to create a fun shape out of an image for a presentation. Microsoft PowerPoint privdes you with some unique image editing tools and allows users to to crop existing images into unique shapes. Here are the steps:

We know that Word's find and replace function can be used to replace words and phrases. It can also be used to replace non-printing special characters that may find their way into your document and alter the formatting.

In order to find and replace special characters, use the Replace keyboard shortcut, CTRL+H to bring up the dialog box. You will see a More button. Click it or press ALT+M to reveal your Search Options. At the bottom under Replace will be a Special button. Click on it or press ALT+E.

Larger data sets tend to have duplicate content. You might be copying information form multiple lists or speadsheets and want to remove any duplicate content. In situations like this, removing the duplicates comes in quite handy.

To remove your duplicates, go to the Data tab, and select "Remove Duplicates" (under Tools). A pop-up will appear to confirm which data you want to work with. Select the data set and select "Remove Duplicates" and you're good to go. This will remove duplicates for the data set you selected. For example, if you have a list of names and email addresses, you can remove duplicate email addresses to organize you list. our resulting list will have only unique names without any duplicates.

How can I see all the formulas in a speadsheet in Microsoft Excel?

Do you find yourself opening an old spreadsheet or a spreadsheet created by someone else? You look at the document and can't figure out what is data and what the formulas that are being used?

This month, join Ronny Loew, National Sales Director from Procirrus Technologies as he delivers his 5 Important Questions to Ask When Choosing Your Hosting Partner.

In choosing the best hosting partner for your firm, the question used to be whether to go to the cloud. Now, it is deciding which cloud. Hear the five most important questions your firm needs to ask when selecting your cloud hosting partner.

Technology: Is it Serving You, or are You Serving it? Own your technology – Don’t let it own you!

In this three-part series starting in March, learn how to manage your daily tasks and how technology can help you to improve client communication and achieve your professional goals. Enhance your time management and technology skills to regain control of your law practice… and your life. Learn the pathway to a productive, more paperless law practice. Most lawyers and legal professionals feel they are being overrun with paper, and ironically, the more paper lawyers have, the harder it is to find what they’re looking for. Let Affinity Partner, Paul J. Unger help you tame the digital chaos!

A huge part of using Word in a law office involves selecting words, sentences, and paragraphs to copy, move, delete, or format. You can drag your mouse over the text you want to select. Or you can skip the time-consuming and not always precise mouse pointer dragging process and just click.

How do you fill in data automatically in Microsoft Excel?

Microsoft Excel features many different time saving tricks. One of the best and often overlooked tricks in Microsoft Excel is the "AutoFill" feature.

Let's Get Started Today

with a plan that's right for your practice.

Let Us Teach You

Take advantage of our blog resources, sign up for our law office technology white papers, take a course from Affinity University, Attend all of our Live Events.

Start Now


Hire Us To Do It For You

Hire Affinity Consulting Group to make your law office run more efficiently than ever… We can deliver the hardware, the software, and the training that is perfect to make your law office more efficient.

Start Now


Work With Us

We can give you expert guidance, helping you make smart choices for your law firm. We can help you analyze your current situation and make suggestions that will point you in the right direction.

Start Now


Sign up for our newsletter and

keep your law office efficient.

Join over 4,000 successful law firms who receive our newsletter today.

Email:

Read Our Previous Newsletters