Create Screen Recordings with PowerPoint’s Office Mix Add-in

With PowerPoint 2013 or 2016, you can create screen recordings and then save video as an mp4 format. First you will need to get Office Mix for free.

Once you download Office Mix, your PowerPoint Ribbon Mix tab will look like this.

mix tab

Click the Screen Recording button to get started. It will give you an option to drag a selection around the portion of the screen you want to record.

video portion drag

 

Then you receive a 3-2-1 countdown. The recording will capture any mouse movements that come into the screen space you selected.

After you stop the recording, the video will be embedded into the PowerPoint slide. Right click the video and choose save media as….mp4.

save as mp4

I use this to create my video demos on my blog and then upload them to YouTube. Here is my last video I created about my favorite 6 Excel tips.

mp4 save

The Office Mix tool is one of my favorite software application tools.

Posted in PowerPoint | Tagged | 2 Comments

My Top 6 Excel Time Saving Tricks

Posted in Excel, Videos | 3 Comments

Making an Excel PivotTable, Slicers, and TimeScale Dashboard from the Reds 2016 Schedule [Video]

Posted in Excel, Videos | Leave a comment

Locate Differences From Within Two Excel Lists Using the Match Function

In this post, lets say you have a list of confirmed RSVP guests. You also have another list of actual guests who showed up. The problem is that you have some people who showed up but did not RSVP. In the graphic below can you spot out the two people that are in Column C (Actual List of Guests) but are not in Column A (Confirmed RSVP Guest Master List)? Probably, I guess it wouldn’t take that long for you find the two, but what if you had 500 or 1000 people on the list? Forget that approach. See my previous post on how to do this in Access here.

Master List vs Show Up List

The Match function returns the relative position of an item in an array that matches a specified value in a specified order is how Excel describes the Match function. That is a mouthful but let me try it in my own words. Tell Excel an item to look up. For example “Amy Woodson” from cell C2. Next tell Excel where to look to check where “Amy Woodson” is would be located from another list ($A$2:$A$10). Choose to find an exact match so type zero for the third argument (Match_type). If Excel finds “Amy Woodson” in the cross referenced list, then return what position it is in. So we will get a whole number if “Amy Woodson” is in both list. She is actually in the eight spot. That is why Excel places the value 8 next to her. Now how this is going to work is that if Excel cannot find the match, it will return an error #N/A. That is what will then tell us that we have someone that is not in both lists.

Match function

BINGO! We could then filter out all the #N/As to find out who was not on both lists. Henry Boxson and David Chapmen are not in the RSVP list in column A.

Match NA

If you liked this post you also might be interested in another post I wrote about ditching the VLookup and using the Match and Index instead to find the lookup value.

And here is my favorite PDF of  Excel Keyboard Shortcuts reference list.

 

 

 

Posted in Excel | Leave a comment

Find and Replace Fonts In Word

When you want to replace fonts in a document, Word has a couple of tools to get the job done. One way is to modify the style. There are many styles in Word, but the two popular styles types include character and paragraph. A paragraph style is a set of instructions telling Word how to format a paragraph. Check my blog post on Styles here. The default style in Word is normal and current version of Word is Calibri, 11 point font. You can see a list of the document Styles by clicking the Style dialog box launcher from the Home tab. Styles help create table of contents.

styles

Once you click recognize the style you want to modify, right click the style and select modify. Make the font changes, click ok and everywhere in the document that used that style will be automatically updated.

Another option is to run Word’s find and replace feature. Control + H or click the replace command from the Home tab.

find and replace

Click the more button, which will make the box bigger and have options to find and replace fonts.

Click in the find what box, then select format, then font. Choose the font you want to find. Repeat the steps with the replace with font line.

ind and replace font format

Check out my Word shortcuts cheat sheet. If you like this post and want more delivered to your inbox, sign up for the newsletter list from the right side bar.

Posted in Word | 1 Comment

Wrap Text Around Pictures in a Word Document

When you insert a picture into a Word document, it places the image inline with text. This means that the image will not have words wrapped around it. Select wrap text from the format tab under picture tools (or right click image) and choose through. Then drag the image anywhere in the document to have words wrap around it. Resizing the image sometimes helps with the text flow.

Before text wrap:

Before word wrap

After text wrap through:

after word wrap

Download my Word keyboard shortcut cheat sheet.

Posted in Word | Tagged | Leave a comment

When Two Excel Spreadsheets Look the Same But Are Different…It’s Time For The Access Unmatched Query.

Have you ever had two similar looking spreadsheets in Excel and wanted to find out which rows contain differences? If your lists are small, you could try to view the two spreadsheets either side by side horizontally or vertically. Click Excel’s View tab then click New Window. Then click Arrange All with vertical.

new window and arrange all

With vertical this is what you get.

looks the sameHowever, when your lists contain too many rows to compare in Excel, then you can export the data to Access. Either run the Excel import Wizard from Access or copy and paste between the programs.

find unmatched query wizard

Select the “Find Unmatched Query Wizard” from the Query Wizard button from the Insert Tab in Access.

Step 1

which table or query contains the records you wnat in the query results

Step 2

which table or query contains the related records

Step 3

which piece of information

Step 4

which fields do you want to see

Step 5

name the query

Click Finish and view the dataset. You may need to run the unmatched query wizard again a with changing the table comparison direction if the first query did not produce the results you thought.

record set value

Posted in Access, Excel | Tagged | 3 Comments