All posts by Gayle

5 Ways to Copy Images from PDF or Word Document

Ever had a long document with several pictures and wanted to copy images only? Well, there’s an app for that as they say and here’s 5 ways to copy images from PDF or Word that will cover most any circumstance. Further good news is most methods don’t require any additional software!

Copy Multiple Images

First things first…If the document is a PDF, you want to convert it to a Word file. If you have Word 2013 or above, you can do this without any other software.

Convert a PDF to a Word File

You must open the file inside of Word. Double-clicking it in a directory would open it in the PDF software.

Open MS Word:

  1. File | Open or CTRL O and browse to the PDF file.
  2. Depending on your version of Word:
    • The PDF may load with an Info Bar to Enable Editing. Click that link and the PDF is loaded and can be edited like any Word file but is still in PDF format.
    • Click Save icon and the Save As dialog box will display and automatically change the format to .docx, OR
    • Word will notify that the file is being converted to the Word format. Click OK. The PDF will then load as a Word document. When file is converted, choose File | Save As or press F12 function key. Change the filename if desired or you can keep the same name as the original PDF as they are two different formats.

Now you have both PDF and Word formats of the document.

Copy Just the Images

Here’s what will automatically put the images in a separate folder:

  1. Do Save As again (get in the habit of using F12 as it works across Office and saves time and maybe even saves a little carpal tunnel).
  2. Change the file type in Save as type: to Web Page (*.htm; *.html) OR Web Page Filtered (*.htm,*.html). Either works; only difference being that Web Page preserves all Office formatting tags and Web Page Filtered saves with regular tags and some formatting may be lost. The former format would maintain quality as well.
Save As Web Page Type Option

Note: After saving in this format, your Word document will display in Web Layout View. If you want to switch back to Page Layout View, click its icon on lower right of Status Bar or select View | Print Layout in Views group on Ribbon.

Locate the Graphics

Saving in either Web Page format will automatically create a folder with the same name as your Word file with _files added to the end of the folder name and saved to same directory. This contains all the pictures as separate files in the .jpg or .png format depending on type of graphic. Filenames will be labelled Image001, Image002, etc., and can now be renamed, copied or moved. Like magic…who knew?

Here’s another method if you already have a Word file containing images, by changing the file extension:

Change the File Extension from “.docx” to “.zip”

This way extracts all the images from the document as a batch just by changing the file extension! Ensure your file is in the .docx extension (Word 2007 and above), and it’s not a bad idea to make a copy of the Word file and use the copy to change the extension, for safety’s sake.

Note: If you just send the Word document to a zipped folder without changing the extension, the document gets zipped and unzipped as a whole, and the images are not extracted.

  • Ensure that document is closed, and in the file directory, right click on the filename and choose “Rename” (or press F2 function key to select the name).
  • Change the extension to “.zip”. (Make sure you don’t delete the “.”) Press ENTER.
  • You will get a warning dialog box but just click Yes button.
Changing file extension to .zip warning
  • The new zipped folder will display with the same filename as your Word file.
  • Double click on that folder and Windows will display the Extract group on the Ribbon.
  • Click Extract All icon.

The same folder displays but is now unzipped Double click the Word  folder and then Media folder. All images are there in .jpg format.

Copy Images with Save As Picture
Method

This is a direct method to copy images you can do one by one if you want a single or small number of pictures:

  • Right click over desired picture.
  • Choose Save As Picture
Save As Picture command
  • Save As dialog box opens with Pictures folder as location. Change filename or location as needed. Image will automatically be saved in .jpg format.
  • Can now be opened in any image editing program .

Copy and Paste Method

This is last resort if you have an older Office version and the Save As Picture… command does not display on right click. A simple and copy and paste will work for one or two pictures:

  1. Right-click on the image and choose Copy.
  2. Open any image editing software such as Paint in Windows or freeware such as Paint.NET.
  3. Paste the image and click Save button (or CTRL S) to save the image.
  4. Paint will save in .png format but you can change to .jpg or choose from many other formats .

Use Zip Software to Extract Images

Third party unzipping software is usually no longer needed but there are free, reliable options such as 7-Zip for compressing/extracting files and graphics. After installing, when you right click on a picture, that software option should display in the shortcut menu. Click it and a separate folder should be created containing the pictures.

Hopefully, one of these was “picture perfect” for you and now your images are all in one place for easy access.

If you would like more information on different ways to save a Word or Office document as a PDF, see my blog here…https://gaylelarson.com/word-document-pdf-format/

Let me know which technique(s) worked best for you in the Comments below. Thanks for reading!

5 Steps for a Successful PivotTable

Trying to get more information out of that large spreadsheet? Functions such as VLOOKUP and SUBTOTAL are great summary tools but if your data changes frequently or you want to look at it in different ways, these 5 steps for a successful PivotTable will help you get great results.

PivotTable Numbers Picture

Why Use a PivotTable?

PivotTables allow you to look at your data in a variety of ways that aren’t possible in the regular grid format of a worksheet. Set up properly, you can also instantly access “underneath” details that automatically display on a separate worksheet.

Prepare Data for PivotTables

You only get out of PivotTables what you put into them, so there are some key points to follow before clicking that Insert button to get the best results and avoid errors.

5 Steps to a Successful PivotTable start with making sure all the data is in the rawest form:

  1. Remove any blank columns or rows.
  2. Need a header row with a name in each column in the first row of the data. (Each column name becomes a field in the PivotTable). Always a good idea to format the row bold or italic to distinguish it from the data.
  3. Don’t mix data types in a column. You want only dates in Dates column, numbers in Sales column, text with text, etc.
  4. Don’t use detail data for column headings in source data, use “Year”, not “2020”, use “Month”, not “January”, etc.
  5. Convert the data range into an Excel Table before creating the PivotTable (not necessary but has added benefits). When rows are added to expand the original worksheet table, the PivotTable will automatically update to include them when you click Refresh. If created from a regular worksheet range, only data edited within that range gets updated in the PivotTable.*

Here’s a worksheet I converted to a Table:

Excel Table Picture

Create the PivotTable

As a result, your worksheet is ready for primetime and creating the PivotTable:

  1. Click anywhere in the body of the data (if only using portion of worksheet, select that range first).
  2. Choose Insert tab and click the PivotTable icon in Tables group, to display a dialog box with your data range automatically selected. Placing it on a separate worksheet is also selected. (Can choose on same worksheet here if desired).
  3. Click OK and your new PivotTable Sheet is created.

Based on the above sample worksheet, this is the created PivotTable:

New PivotTable Picture

The PivotTable is now waiting for you to drag and drop the fields into the four area boxes at the bottom. Text columns would go in either Columns or Rows boxes and values such as sales or counts would go in the Values box.

Tweak the PivotTable

Here’s the PivotTable results after dragging Products into Columns, Salesperson into Rows and Sales into Values:

PivotTable Created from Fields Picture

So now, from here you can add filters, create subsets of data, such as dragging Year below Salesperson in Rows box would display sales by year underneath each Salesperson, and so much more!

The main thing here is to start right with clean format and data so your PivotTable behaves. Make a copy of a worksheet and play. You will be amazed!

You can also use a great feature available since Excel 2010 called Slicers which are visual filters. A blog on this feature and more PivotTable wonders coming soon!

*Click here for my blog on Excel Tables:    https://gaylelarson.com/magic-excel-tables/ 

 

 

 

Insert Slide Hyperlinks in PowerPoint Presentations

BUSY? READ LATER! DOWNLOAD THIS POST AS PDF >> CLICK HERE <<

Applies to all Ribbon versions of PowerPoint

Insert Slide Hyperlinks in PowerPoint

Insert slide hyperlinks in PowerPoint presentations to create a fast, smooth transition to another slide in your PowerPoint deck when running the slide show. You could have a list of products on Slide 2 and jump to the sales or production locations on Slide 9 by inserting a hyperlink in text or in an object on the first slide that links to the other.

Shoes linked together like your slides!

What Objects Can be Linked?

Links can be created in most objects such as text, shapes, text boxes (or the text inside), along with pictures and SmartArt. To link directly from text inside objects, ensure the actual text is highlighted so that you have a targeted area for the mouse click.

Where Can Links be Directed?

Create hyperlinks and direct to:

  1. Slide in same presentation
  2. Slide in another presentation
  3. A website address
  4. A file (document, spreadsheet, etc.)

Create a Link to Another Slide

  1. Select the slide and the text or object where you want to apply the link
  2. CTRL K (Hold Ctrl key and tap and release k key) to display the Hyperlink dialog box

Insert Hyperlink dialog box

  1. Click on Place in This Document under Link to: to display slide numbers under Select a place in this document:
  2. Click desired slide number to link to and click OK


Test the Slide Link(s)

  1. Run the slide show with the icon on the Quick Access toolbar or the Status bar (or my favorite – F5 function key)
  2. When slide with hyperlink displays, click the link to leap to the linked slide
  3. To return to original slide, right click and choose Last Viewed* so you can pick up where you left off

Tips:

-Your presentation theme will determine the color of hyperlinked object(s).

-Although the hyperlinks display in the slide(s), the actual links only work when running the slide show.

*The link(s) are only one-way so to jump back to original slide, you must create a back link or right click on destination slide during the presentation and choose Last Viewed.

Note: There is a new feature only available in PowerPoint 2019 and Office 365 called Zoom which allows for drag and drop linking, creating a summary slide and other helpful commands. A blog post on this update coming soon! But, good thing, the above steps for linking work in all versions of PowerPoint including the newest.

Make your bulleted slides more interesting and compelling by using Designer and/or SmartArt  to convert them to graphics . See my post here:   https://gaylelarson.com/powerpoint-designer-converts-lists-to-graphics/

BUSY? READ LATER! DOWNLOAD THIS POST AS PDF >> CLICK HERE <<

5 Amazing Must Have Excel Tips

Have you stared at the data in your worksheet and wondered how you were going to get the same information in multiple cells, or how to automatically insert a cell with a full name from two cells with the first and last name, or how to best graphically display those sales figures? Well, hopefully, these 5 amazing must have Excel tips will give you some answers!

Enter same content in multiple cells simultaneously

Need the same labels or values in several cells?

  • Select the first cell
  • CTRL click on the other desired cells
  • Type Desired content
  • Press CTRL ENTER

Presto! Same content in all the cells.

Same content in multiple worksheets

Need different content in several cells to display in multiple worksheets in the same cell references? Group worksheets and just type it once!

Group desired worksheets by selecting worksheet name tabs:

  • If worksheets are not adjacent, click first one, and then CTRL click on each worksheet you want to have identical content.
  • If adjacent, click on first one, and SHFT click on last one (or right click and choose Select All).
  • Now type in as many cells as you want on the active worksheet (can be different data in each cell). Same contents are now in corresponding cells in all selected worksheets.
  • To Ungroup, click on a worksheet tab outside of the group, or right click on a worksheet tab and choose Ungroup Sheets.

TIP: This is a terrific shortcut for adding the same headers and footers or printer or page setup settings to multiple worksheets simultaneously. Also works for creating duplicate content for days, months, quarters or any repetitive unchanging data; basically creating an in-workbook template!

Number Worksheet Rows

Can’t figure out number of rows because your data starts several rows from the top or some other area of the worksheet?

Excel allows you to number the rows and will auto adjust when you add or delete them if you use the =ROW() function. The key is to deduct the number of rows above the one you are starting in so the numbering will always be correct.

Example: We’ll use Row 12:

  • Insert a column or click in the column where you want the numbering
  • Type: =ROW()-11 in row 12 of that column. The number 1 is displayed
  • Fill down desired number of rows.

You now have the actual number of rows you are working in!

Speaking of numbering, getting Excel to automatically create a series of sequential numbers, requires some gentle nudging…

Sequential Numbers

I you want to populate a column with sequential numbers, just enter the numbers in cells, such as

1

2

Select both cells and drag the Fill Handle for as many numbers as you wish. Excel will automatically iterate the count. Start with any number.

It will also work with jump numbering, such as this:

1

5

Select both numbers and drag down for the desired number. The next numbers would be 9 and 13.

Note: This also works with dates and text.

TIP: Here’s a trick for fast sequential numbering; just type your first number, hold down the CTRL key and drag the Fill Handle. Excel will recognize the pattern. (For non-sequential numbers, you still need two examples).

Like then so far? Let’s look at a couple more must have Excel tips!

Flash Fill

Flash Fill is a time-saving feature that reads patterns in adjacent columns and automatically fills the remaining cells in a column based on those patterns. It is useful when you need to concatenate (join) cells, or separate information in cells without wanting to write a cumbersome formula. Kind of like AutoFill on steroids! This amazing tool will make short work of many repetitive tasks, all without formulas (or the Text to Columns feature)! Here’s some things it can do:

Splitting Input Data

You received a huge spreadsheet where someone has put first and last name in one column, and you need them separated for sorting and filtering. (This could be any data, i.e., department name and phone extension, or salesperson and monthly sales figure. Doesn’t matter as long as the data has a separator, such as a space). Flash Fill to the rescue…

Example:

Full names are in Column A.

Steps:

  • Insert: two columns to right and enter appropriate column header labels.
  • Type: Fred, in appropriate cell (in example, Cell B2)
  • Press: ENTER
  • Type: Mary (note that Excel has figured out what you are doing and is displaying the remainder of first names, and is awaiting your approval)
  • Press: ENTER, and presto, all the rest of the first names are added!

Flash Fill Splitting Input Data

Repeat the above steps in the cells for Last name (In example, Cell C2)

List is now complete:

Flash Fill First and Last Name cells

TIP: You can have flash fill complete only the last name, i.e., just insert one column, and instead of typing “Fred”, you would type “Frump”, ENTER, then “Lamb”, ENTER, and you would be done.

Note: Give Excel one or two examples of what you are trying to accomplish so flash fill can see a pattern. It will work with text, dates, numbers and time. Be aware that if you change source data, cells containing flash fill data will not update as there are no formulas involved.

Combining Data from Different Columns

The reverse is also true. You have a worksheet with first and last names (or any data) in two columns and you want them combined into one. This used to require the CONCATENATE function but now Flash fill can do it automatically. Drop kick that CONCATENATE function off your spreadsheet. Tough enough to spell it, let alone use it!

Here’s the data in two columns and how to combine into one:

Flash Fill combined cells

Steps:

  • Insert: a blank column to the right of split data
  • Type first full name in the new column (C2)
  • Press ENTER
  • Type second full name, and before you are finished, Excel sees you want the remainder filled in
  • Press ENTER to complete the list

Extend the Combined Data

You just got word that you need to add the email addresses for all the people in your company that you just did your flash fill magic on (or any such list). To make it worse, the addresses are last name first. Flash fill is not intimidated and has your back:

  • Insert your new, blank column to the right of the Full Name column
  • Type the email address in the first cell
  • Press ENTER
  • Start typing the second email address, and the dependable flash fill displays
  • Press ENTER to complete the email list for the remaining cells.

Flash Fill auto email addresses

You have saved so much time, you go to coffee!

Keyboard shortcut lovers…Here’s an even faster way to activate flash fill. Type the entry in the first cell. Press CTRL ENTER, and then press CTRL E and the column is filled in a flash!

TIP: If you accidentally lose the Flash Fill display, click the Data tab, and in the Data
Tools group, click the Flash Fill icon (ensure you are in the second entry in your column). If the ribbon and Flash Fill are greyed out, click outside your data range and then click in the second cell again and retype.

There is so much more that Flash Fill can do, so play with it and see if it will display that very thing you want.

Note: If Flash Fill is not working and the above tip doesn’t activate it, it may be corrupted or missing system files. There is an easy fix and download thanks to Microsoft Gold Certified Partner, Scott Chan. Just follow the information and link on his website: Scott Chan PC Support

The Quick Analysis Tool

You’ll find this a really helpful feature whether you are an experienced user or fairly new to Excel. Just select the data to analyze, and the Quick Analysis icon appears in the bottom-right corner of the selected data.

Click that icon, and a dialog appears showing a range of tools for analyzing the data, such as Formatting, Charts, Totals, Tables and Sparklines. Click any option, and a series of selectable choices appear; preview those choices by mousing over them. Next, click the option you want to apply it to your data. This feature speeds up the process of formatting, charting and writing formulas.

Steps:

  • Select: the cells to analyze. When the mouse is released, you see the Quick Analysis Tool icon at bottom right of the selection:

Data selected with Quick Analysis tool displayed

  • Point: at the icon to display the tool tip:

Quick Analysis icon

  • Click: the icon to display the options:

Quick Analysis tool options displayed

  • Roll your mouse over each of the options and when you see the one you want, just click!
    • Formatting: Adds Conditional Formatting to your selection based on Excel’s default rules
    • Charts: Displays the main types of charts that will work with your data
    • Totals: Sum, Average, Count…The equivalent of AutoSum feature. Running totals and percentages also available
    • Tables: Automatically converts your data to a table with the filters in every column
    • Sparklines: Displays miniature charts in the cells to the right of each row of data (3 types available)

Example of choosing Formatting: Selecting Greater Than under Formatting, Excel will automatically display the rule it used to color every cell with a number over 6065 pink. You can then make adjustments right on the screen. You can change the base number here and also if pink isn’t your color, change it here!

Conditonal Formatting displayed from Quick Analysis tool

TIP: You can apply any one of these and then edit if you want to change the rule or behavior. For example, to see more options for the above, Greater Than Quick Analysis tool, (or any of the other Conditional Formatting options):

  • Click the Home tab on the Ribbon, Styles Group, and click the drop down arrow on Conditional Formatting icon, (Note that many more conditional formatting choices are available on this drop down list).
  • Select Manage Rules (bottom of list).
  • Select the rule, and click Edit Rule to display options. (Can also Delete Rule here)
  • Click OK to confirm any changes.

Note: If you want this tool to put in the formulas for you, such as totals, averages, counts, etc., don’t enter them yourself until you see if the automatic calculations under Totals: work for you!

See more awesome Excel tips and tricks here: https://gaylelarson.com/copy-and-paste-filtered-subtotals-or-visible-cells-only-in-excel/ or use Search for a specific topic.

Which feature is most helpful to you?

How to Tell if Windows 10 Creators Update is installed

The Windows 10 Creators Update has been rolling out to compatible devices, but it is not easy to tell if any of the updates you have been receiving are it, as you won’t see the name, only a version and build number.

Windows 10 Creators Update rolling out

Ways to Check if Creators Update is Installed on Your PC

Let’s look at a couple of easy ways to tell if you have the Creators Update installed:

The About settings Page

I like this method as it also displays a dialog box that includes information on the amount of RAM installed, processor model and speed, and your Windows edition:

  • Click the Start button (or tap Windows key on keyboard)
  • Click Settings gear at left to display Windows Settings
  • Click on System icon
  • Click on About at bottom of list on left

Windows 10 About Settings for Creators Update version

The Windows 10 Creators Update is installed on your computer If you see Version 1703 and OS Build 15063.xxx or above (as it will depend on how far in the future you are checking).

Use the Run Command

If you like using the Run Command, here’s the quick way to do that:

  • Press Windows key + R on the keyboard to open the Run command
  • Type “winver” in the Open box (without quotes)
  • Press Enter key or click OK

Run box for displaying Windows version

This method is lean and clean and displays just licensing and the information you asked for:

About Windows dialog box for version from Run command

Note: Each update of Windows 10 has its own internal version number. For example, the big Anniversary Update version is 1607.

Creators Update has Many New Features

Windows 10 Creators Update includes many great new and updated features across Windows and the Edge browser. It has upped the ante on 3D, Inking and Mixed Reality, along with fast, visual ways to share with your favorite people, and making Cortona smarter and more helpful.  We’ll cover some of those in a future post.

Do you have Creators Update yet? Are you using any of the updated and added features? Tell us how.

No matter which version of Windows 10 you have, there are some “garage” features or apps you might not know about, such as the valuable Snip tool – a free download from Microsoft (not to be confused with the Snipping tool already included in Windows). Check it out in this blog: https://gaylelarson.com/microsoft-snip-screen-capture-tool/

Inspect and Remove Sensitive Document Properties with Document Inspector

It may come as a shock to some just how much information Microsoft collects in Document Properties during the creation of a file. This blog reveals how to inspect and remove sensitive document properties with Document Inspector. We have enough to handle just getting the document to be correct and look the way we want to present it without worrying about broadcasting sensitive data!

Office collects personal data

There are positive uses for this information and even for creating our own custom Document Properties, but we’ll cover that in a future blog as this is about protecting your information in Word, Excel and PowerPoint.

If the document is not leaving your computer or office, it may not be an issue to have unexpected details revealed about the creation path and timeframe for editing, how many revisions and more. On the other hand, if this is confidential or going to another department, or worse yet, to a client or outside organization, there could be a problem Houston!

NOTE: Document Inspector tends to be an all or nothing thing. Might want to create and save a copy of the document before you inspect, remove and send, because it may remove elements that you want to keep in your original.

What Data is Collected

As you work, here is what starts to accumulate about your document and you (or the user who is working on it).

Click File tab to display the Info screen (Backstage) with the Properties of the current document (left screenshot):

Word Document Properties

Much of the data is what you would expect to see if you were looking at the file in a directory, but note there are fields such as Total Editing Time, Author, Last Modified, Last Printed (and by whom).

If you click the link for Show All Properties at the bottom of the screen, you see more information is revealed such as Company and Manager (shown on the screenshot on the right). There are also several fields where you, the user, can enter details to identify the file for searching and clarity.

Let’s go one step further…At the top of the Properties column (in either screen), click the dropdown arrow and then click Advanced Properties button:

The Advanced Properties dialog box will display with five tabs that collect different data:

  1. The General tab contains the information you would see with the Details view in a directory.
  2. The Summary tab is where you can choose to add your own information to identify and describe the document.
  3. Statistics tab contains some file details but adds personal data about the construction of the file.
  4. The Contents tab pulls document properties from fields. For example, if you added a Title in the Title tab, it will appear here.
  5. The Custom tab is where you can add properties from the list such as Department or Editor or create your own.

As mentioned, you may want to utilize these properties for various reasons but, for now, we’ll just concentrate on what Word is collecting and tracking, and how to get rid of the information, if needed.

Note: Previously you could display the Document Panel from Advanced Properties directly at the top of your document and fill in the property tags there. It was removed from Office 2016.

Review with Document Inspector

Let’s look at all the document and personal information being collected:

  • Click the File tab and ensure Info is selected.

Inspect Document screen

  • Click Inspect Document under the Check for Issues dropdown arrow.
  • The Document Inspector displays where you can choose what content to check for.
  • Leave them all checked and click the Inspect button at the bottom of the dialog box.

Document Inspector dialog box pre-run

The same list displays again with the requested data flagged with a red exclamation mark and a list of the information found.

Document Inspector after running

Remove Hidden Data

If you want that data deleted, click the Remove All button. Click Reinspect to ensure it is gone or remove other information.

You can now send that file without fear that it is revealing your inner most document secrets, but you might want to take it one step further if the document has ever been shared, or you have cropped images! (See below).

Document Properties in Excel and PowerPoint

Both these programs use the same method for collecting data about your file but because of their diverse purposes, track some different information. You inspect and remove the same way with the Document Inspector.

Like Word, Excel and PowerPoint collect data on:
  • Comments, and Annotations
  • Document Properties and Personal Information.
  • Invisible Content
  • Custom XML Data
Excel adds:
  • Headers and Footers
  • Hidden Rows and Columns
  • Hidden Worksheets
PowerPoint adds:
  • Off-slide Content
  • Presentation Notes
 Word adds:
  • Revisions and Versions,
  • Metadata, Microsoft SharePoint properties, custom properties, and other content information.
  • Headers, Footers, and Watermarks
  • Hidden Text
  • Task Pane add-ins

How to Inspect and Remove

The same for all programs. Go to File | Info |Check for Issues | Inspect Document.  Note the list of things that will be inspected, leave them all selected and click the Inspect button.

Check Before Sending

There are some things not covered by the Document Inspector that could cause embarrassing or legal issues if the original information remained intact. Cropped images may display as you edited in the document, but the complete original image remains unless deleted. Same is true of Tracked Changes that have been edited if someone turns on All Marks.

Delete Cropped Areas of Images

  • Click on an image
  • In the Picture Tools | Format tab | Adjust group, click Compress Pictures

Compress pictures and delete cropped areas

  • Ensure there is NO checkmark in Apply only to this picture.
  • Ensure there IS a checkmark in Delete cropped areas of pictures.
  • Click OK.

Remove Tracked Changes

Accept or reject tracked changes to remove them from your document:

  • To look at each revision one at a time, on the Review tab, click Next in the Changes group, and then Accept or Reject.

Use Ribbon to remove tracked changes

Word keeps or removes the change and then moves to the next tracked change.

  • To accept all the changes at the same time, click the arrow below Accept, and then click Accept All Changes.
  • To reject all the changes at the same time, click the arrow below Reject, and then click Reject All Changes.

IMPORTANT:  Choosing the No Markup view helps you see what the final document will look like, but it only hides tracked changes temporarily. The changes are not deleted, and they’ll appear again the next time someone opens the document. To delete the tracked changes permanently, you’ll need to accept or reject them.

Whew! Now your clean and lean document can be sent without all that hidden data. If you want more information on security for your Office files, see the related blogs…

https://gaylelarson.com/word-document-protection/

https://gaylelarson.com/delete-personal-content-from-public-computers/

Have you had any surprise experiences with sharing sensitive information? Let me know in the Comments.

 

Best Features of Office Mix Will Be Integrated into PowerPoint 365

Microsoft announced it will retire Office Mix on May 1, 2018, but the best features of Office Mix will be integrated into PowerPoint 365 so it will no longer be an add-in download. This will also include Microsoft Stream and Forms for easier creation and sharing of interactive online videos for Office 365 users. It has something for everyone who wants tools for creating slick media from PowerPoint.

Office Mix has something for everyone!

What is Office Mix and Should I Care?

Mix is a PowerPoint add-in that Microsoft introduced about three years ago and is/was available for Office 2013 and above. It is pretty amazing and looks to be even more so as a feature baked directly into PowerPoint. You can create presentations videos, screen recordings, narrations, ink and audio, to name a few features, and upload to the cloud for storing and/or sharing. You can also download the converted video to your hard drive or wherever if you choose. It is directed toward educators but available for anyone with a 365 account. It even includes interactive quizzes and simulations.

Note: See the link below to my earlier blog with an overview of Office Mix.

Most of the information below is from Microsoft and includes links to relevant pages and support a for transitioning from Mix to Stream if you are a current user, and how to access these great interactive tools if you want to start.

What do you need to do to prepare for this change?

If you have a qualifying account* and would like us to migrate your existing mixes to Microsoft Stream, please click here to visit the Office Mix migration page, sign in, and follow the prompts to automatically migrate your data. When the process completes, your mixes will be stored on Microsoft Stream as videos. You can continue to access Office Mix until M‍ay 1, 2‍018.

Mixes migrated to Stream will not include analytics data, quizzes or apps. However, over time these mixes will become interactive again. If you would like to save this content, you can download your mixes as PowerPoint files (.pptx), and your analytics data as Excel files (.xlsx) to save to your storage location of choice at any time before M‍ay 1, 2‍018. Please visit our help article for more details.

If you’re an Office Mix user, you can find full details on how to migrate your mixes ahead of the shutdown at Microsoft’s support page.

Migrate your content from Office Mix

Applies To: PowerPoint 2016

Just over three years ago we launched the Office Mix Preview to help everyone from educators to business create and share interactive online recordings of their presentations. Thanks to the positive feedback from our users during the Preview, we are excited to share that we are bringing the best of Office Mix directly into PowerPoint, Microsoft Stream, and Microsoft Forms for Office 365 subscribers on Windows PCs.

This new integrated experience in PowerPoint will remove the need for downloading an add-in. You’ll be able to easily access the feature via the Recording tab in PowerPoint after you turn on the feature by customizing your PowerPoint toolbar ribbon.

In the coming months, you’ll also be able to publish these recordings to Microsoft Stream, which offers a simple way to upload and share videos securely across your organization to improve communication, participation, and learning.

If you’d like us to migrate your existing mixes to Microsoft Stream, please click here to visit the Office Mix migration page, sign in, and follow the prompts to automatically migrate your data. When the process finishes, your mixes will be stored on Microsoft Stream as videos. You can continue to access Office Mix until May 1, 2018.

This article contains details on how to back up content you currently have on mix.office.com. Please note that all content must be moved off Mix by May 1, 2018, to avoid losing it. If you take no action by that date, your files will no longer be accessible. We will continually update this article as more information becomes available.

I’m a current Office Mix user—What does this change mean for me?

The Office Mix site and existing content stored on its servers will be retired according to the following schedule:

  • October 20, 2017:   If you have an existing Office Mix account, you’ll still be able to view, edit, publish, download, and delete your existing content. If you have a qualifying* Office 365 work or school account, you can sign in to migrate your mixes as videos to Microsoft Stream. If you don’t have access to an Office 365 work or school account, you can download your Mixes as PowerPoint files (.pptx), and your analytics data as Excel files (.xlsx) to save to a storage location of your choosing.

*Office 365 plan features vary by license. See licensing details to learn if you already have access to Microsoft Stream and what features you can use, or to upgrade your plan.

  • January 1, 2018:   You’ll no longer be able to sign up as a new user or download the Office Mix add-in from the website. Existing users who already have the Mix add-in installed will still be able to use it to upload, edit, view, and download their existing content.
  • May 1, 2018:   The Office Mix site and all its content will be officially discontinued. The site will no longer be accessible after that date. Any links to your Office Mix content that you previously shared with others will stop working after this date.

How do I move my files and content from Office Mix?

For Office 365 work or school accounts

Do the following:

  1. Please visit https://mix.office.com and sign in with your Office 365 work or school account that you were using for Office Mix.

  1. Click the Migrate button.
  2. On the confirmation page, click Migrate Now.

  1. Once you click Migrate Now, you’ll be asked to sign in by using your Office 365 account; after sign-in is successful, the migration will start for all Mixes in the “Ready for Migration” state. Migration may take some time to complete, and during migration you’ll be able to get status on the migration on the website. Please visit https://mix.office.com again to confirm the results.

For Microsoft accounts (Outlook.com, Hotmail.com, Live.com, etc.) and Google and Facebook accounts

Do the following:

  1. Please visit https://mix.office.com and sign in with the account that you were using for Office Mix.
  2. Click My Mixes.
  3. Under the uploaded mixes page, click Presentation to download your mix as a PowerPoint file (.pptx). If you enabled mobile playback during upload, you may see a Video button that you can use to download a video (.mp4) of your Mix as well.
  4. To download your quiz results and analytics data, click Analytics and then click the Excel icon to download an Excel file (.xlsx). For more detailed instructions, see Export your analytics to Excel.

For Microsoft, Google, and Facebook accounts with access to a valid school email address

We can back up your mixes as videos to your Microsoft Stream account. All you need to get started is to enter a valid school email address. Please see Get Office 365 for Education for free. Students and teachers are eligible for Office 365 for Education, which includes Word, Excel, PowerPoint, OneNote, and now Microsoft Teams, plus additional classroom tools.

You can also choose to sign in to Office Mix and follow the auto-migration prompts yourself. When the process is complete, you will find all compatible content you had previously published to Office Mix backed up to your Microsoft Stream account. The original content on Office Mix will thereafter only be available to view, download, and delete.

Which Office 365 plans will include Microsoft Stream?

Stream is available currently to all the same plans that Office 365 Video was available in except (Government Community Cloud, Germany, and China).

These are the plans that include Stream:

  • Office 365 Education
  • Office 365 Education Plus
  • Office 365 Enterprise K1
  • Office 365 Enterprise K2
  • Office 365 Enterprise E1
  • Office 365 Enterprise E3
  • Office 365 Enterprise E5

Over the course of time we will be adding Stream instances and licensing to match the existing set of regions and plans supported today by Office 365 Video.

For Office 365 Accounts without Microsoft Stream

Sign in to your Office Mix profile where you can download and save your content to your device or your preferred storage and sharing platforms. You can also delete your Office Mix account and content.

What about content that I have already linked from Office Mix to other Web sites?

For users who have embedded or shared content in a Learning Management System using the Office Mix LTI tool, you can embed content using Microsoft Stream. If you want to remove linked content, simply delete the files from your My Mixes page. On May 1, 2018, all Office Mix content and links will stop working, so please make sure to manually update any embedded Mixes on your other Web sites before this date.

What if my Office Mix content exceeds my Microsoft Stream upload storage limit?

If you exceed your available storage limit on Microsoft Stream, the migration of your Office Mix content will be interrupted. Any files that were successfully transferred will remain on your Microsoft Stream account, but any files that couldn’t be included won’t be backed up and the migration process will stop.

Content migration can be resumed after you have freed up or purchased additional storage space on your Microsoft Stream account. To resume an interrupted migration, sign back in to Office Mix and then start migration again. To learn more about the quotations and limitations for Microsoft Stream, click here.

I am an Office 365 Administrator. What do I need to know?

If you are an Office 365 administrator, you can share this article with your organization. Currently, we do not support migrating content from a tenant level, so each Office Mix account holder needs to sign in and migrate his or her own mixes.

When will the Recording tab come to PowerPoint for Mac?

Currently, the Recording tab is only available to Office 365 subscribers on Windows PCs. In the future we may consider rolling out these features to other platforms over time.

When will Microsoft Stream support interactive quizzes and analytics?

We are working to bring interactivity to the Microsoft Stream video player so you can build, upload, play back, and share more Mix-like content on Microsoft Stream (that includes quizzes, ability to jump to different parts of the presentation, and more). Over time, we’ll enhance the analytics capabilities for videos on Microsoft Stream. For more information about the current capabilities of Microsoft Stream, please click here.

How do I turn on the Recording tab in PowerPoint?

My Note: I have Office 365 (Educator edition), and the Recording tab automatically appeared on the Ribbon, with this notation:

If you have Office 365 and The Recording tab is not automatically on the Ribbon, follow these Microsoft instructions:

Turn on the Recording tab of the ribbon:

On the File tab of the ribbon, click Options. In the Options dialog box, click the Customize Ribbon tab on the left. Then, in the right-hand box that lists the available ribbon tabs, select the Recording check box. Click OK. For more information about the PowerPoint Recording tab, see Record a slide show with narration and slide timings.

How do I upload a video to Microsoft Stream?

You can find the upload button at the top of any page or just drag new videos to one of your groups or channels. You can upload multiple videos at the same time and even browse Microsoft Stream while your videos are uploading in the background. In the Microsoft Stream portal, select Create > Upload a video or the “upload” icon from the top navigation bar. Drag and drop or select files from your computer or device. For more information, see Upload a video.

I need more help!

If you’re unsure of what steps to take before the Office Mix service is retired, or you are encountering any issues during your content migration, please contact support at https://officemix.uservoice.com.

We sincerely appreciate your feedback and we’ll be happy to provide further assistance with this transition.

* Office 365 plan features vary by license. See licensing details to learn if you already have access to Microsoft Stream and what features you can use, or to upgrade your plan.

Thank you for using Office Mix and being on the journey with us. If you’re unsure of what steps to take before Office Mix is retired, or you are encountering any issues during your content migration, please visit our help article.

My Note: Here is the link to my previous post on Office Mix:

https://gaylelarson.com/share-powerpoints-office-mix/

Have you been using Office Mix? Tell me about your experiences and if you are going to take advantage of the new features!

Document Protection in Word

Word document protection can be turned on by restricting style selection and types of editing. This prevents others from changing your prized content! Regardless of your version of Word, you have a lot of security control when sharing a document.

Word security lock graphic

Word Document Protection in 2007

The steps are very similar in all the later versions of Word, but the ribbon button is different as is  the wording in the 2007 task pane:

  • Click the Review tab on the ribbon.
  • Click the Protect Document button in the Protect group of the Review tab.

Word Document Protection for 2007 task pane

  • Select Restrict Formatting and Editing from the drop-down menu so there is a check mark next to the option.
  • The Restrict Formatting and Editing pane displays.

Restrict Editing in Word 2010 and Above

  • Click the Review tab on the ribbon.
  • Click the Restrict Editing button in the Protect group.
  • Limit  style formatting by clicking in that box under 1. Formatting restrictions.

Word Restrict Editing task pane options

  • The list of styles displays where you can choose approved styles and make other formatting selections:

Word Protection Formatting Restrictions for Styles

  • Limit the types of editing, such as only allowing filling in form fields or Comments  by clicking the box under 2. Editing Restrictions:

Word Protection Restrict Editing Types

  • Click Start enforcement when you have applied all desired restrictions.

Exceptions

You can allow editing to select parts of the document even if you have made it Read Only. If you are on a domain, specific users can be selected by name in More users… under the Groups: section. This option will display after checking the box under 2. Editing restrictions. (See link below).

Note: Ignore the Restrict permission… link under the See also section at the very bottom of the task pane, as it requires Information Rights Management and must be installed and enabled by your company. If not configured, you will get this dialog box:

Word Protection IRM Alert Display

Permit Changes to Parts of a Document

Word document protection can be configured to allow changes to only select areas of your document. There is an excellent step by step instruction for permitting editing parts of your document at the Microsoft Support Site:

Allow Changes to Parts of a Protected Document

Delete Personal Content from Public Computers

Remove Personal Email Accounts and OneDrive Files from Public Computers

When it comes to computer security, ignorance is not bliss. Have you used a computer outside of your normal environment and not realized that you have to delete personal content from public computers?

Picture this scenario…

You made a trip to the library or took a class at the local college and logged in with one provided by them. That was well and good but you wanted to take advantage of all the great features of Windows 10 and online apps which are not available or are limited unless you used a Microsoft login. You discovered to your delight you could add a Microsoft approved email account in Account Settings, and take advantage of accessing web email and calendar events, along with sharing and messaging features. You added the account and happily made short work of all your projects using the Calendar and Mail app tiles and sharing amazing finds on the web.

Eventually, you look at the time and realize you must jet out of there. Closing all open applications, you log off, or even better, shut down the computer, and scurry off to dinner feeling quite proud of your accomplishments. You have a pleasant day or two and return to the institution and sit down at the same computer and again use their login. You click the Start button and see the live tiles rolling…Screech! Wait a minute, that looks like my emails and appointments…what the heck!

Shock at personal files still on public computer`

End of scenario…

That was my reaction the first time I saw it! After a lot of heart-pounding and testing, was able to delete the online email and shared event content but then discovered (the next day) that all my synced OneDrive files were still available to anyone who logged into that public computer! This is separate issue from the connection for online apps but, thankfully, there is a way to remove those files so they are drop-kicked from the file directory.

Delete Personal Content from Public Computers

Since the email and calendar entries can be accessed without displaying and syching  the OneDrive files and vice versa, we’ll cover them separately.

Remove Personal Email and Calendar Entries

Here are the steps to abolish those messages, calendar entries and shared web content:

  • Click Start and then click on the Settings icon.

Settings gear on Start Screen

  • Click on the Accounts icon.
  • Look for Email, calendar and contacts.
  • Then, scroll down until you see Accounts used by other apps.

Email, calendar and contacts dialog box

  • Under Accounts used by other apps section, click on your Microsoft email address.

Accounts used by other apps dialog box

  • After clicking on your email address, you should see these two buttons displayed –Manage and Remove.
  • Click Remove. The account will instantly remove.
  • If you get another message displaying “Remove account from your device?” click yes/confirm. *
  • Look under “Add an Account.” If your email address remains, click on your email address.

Email account displayed under Add a Microsoft account

  • Click the Manage button.
  • Choose Delete Account.

Account Settings dialog box

  • If you get the “Remove account from your device?” click yes/confirm. *
  • Do a Restart and login with the same login you used originally.
  • Click on the Mail App in Start Menu and ensure that it doesn’t display the emails or email address in the Mail window.
  • Click on the Calendar App in Start Menu and ensure your personal appointments are deleted.

* Don’t let this scare you. Your content is only being removed from that particular computer. It still exists in all your own devices.

Remove OneDrive Files from Public Computer

I want to delete all the synched files from OneDrive in File Explorer but ensure they remain in the cloud-based storage. Microsoft OneDrive allows you to selectively sync files and folders at the device level so you can store files in OneDrive online without keeping them on each of your personal devices.

Steps to remove the shared files and folders from the computer:

  • On the right side of the taskbar, right-click the cloud-shaped OneDrive
    icon.
  • Click Settings. (if you have a full taskbar, you may have to select the arrow for Show hidden icons to see the OneDrive icon).

OneDrive Settings menu

  • Click the Account tab.

OneDrive Account tab

  • Select Choose folders button to display the customizable list.

Remove OneDrive files from public computer

  • Clear the check boxes for any folders you don’t need offline. *
  • Click OK.
  • Click on File Explorer and ensure that OneDrive has no entries.

* Those folders won’t show up in File Explorer anymore, but they’ll still be online at OneDrive.com.

Note: Please keep in mind that screens might be slightly different depending on the version or update you have of Windows and/or Office.

Has this worked for you? Let me know in the Comments below!

PowerPoint Designer Works with Pictures and Charts

PowerPoint Design Ideas in Designer works with pictures and charts and is built into PowerPoint 365. Have the Design Ideas suggestions give you options for arranging text, photos, or other graphics along with any included text automatically for stunning slides!

Note: Requires Office 365 subscription. (For PowerPoint Online, PowerPoint Designer is available to subscribers when they are using files stored in SharePoint Online.)

PowerPoint Designer works with pictures and charts

PowerPoint Design Ideas for Pictures or Charts

PowerPoint Designer automatically suggests options for you when you’re online and you add a picture or chart to your PowerPoint presentation.

  • Click the slide to which you want to add a picture, chart or any type of graphic
  • Click Insert tab and choose Pictures, Chart or another graphic
  • The first time you use Designer, a message will appear asking your permission to get design ideas for you. If you want to use Designer, select Turn on.

Turn on Intelligent Services for Design Ideas

Once you’ve turned on intelligent services, PowerPoint will automatically show you design ideas when you upload photographic content.

Add Photo to Cover Slide

Designer will work on any slide layout. For instance, add a photo of your own or from the web to your Title slide.

Designer opens a task pane for you with suggestions. Click a thumbnail to apply that design idea to your slide:

Title Slide Designer Design Ideas

Previous two graphics from Microsoft.

Tip:   You can open Designer any time by going to Design tab, Design Ideas in Designer group.

Combine Text and Graphics with PowerPoint Design Ideas

If you just have steps in bullets or numbering and want to insert or rearrange an existing graphic, Designer comes to the rescue here too.

Inserting a Picture:

  • Click anywhere on the desired slide
  • Click Insert tab and make your choice of graphic type from the Illustrations group
  • Insert the graphic
  • Designer will display the visual options on right
  • Scroll down and click the thumbnails to preview

Insert graphic directly over slide text

  • Choose one and make that eye-appealing (and mouth-watering) slide!

Design Ideas to combine text and graphics

Big disclaimer here…Don’t try this recipe at home or anywhere else – for design demo purposes only. I’m guessing – not edible!

A Real Tip: You can add more than one photo to a slide and the Designer will automatically adjust the options to reflect the new addition(s).

Add Design to Existing Graphic Slide

You’ve inserted a picture with no text on a new Title and Content Layout slide, and want to see what Designer would do with it:

  • Click on the picture
  • If Design Ideas does not display, click Design tab and choose from end of Ribbon*
  • Design ideas displayed will depend on your slide layout. (Experiment with different slide layouts by right clicking over the slide thumbnail in the Navigator at left, and Designer will auto-adjust to new layout)
  • You can choose a design that adds text or one that is just the best arrangement for your picture

Design Ideas for existing slide pictures

*If you are using the Designer regularly, add it to the QAT: Right click over its icon on the Ribbon and choose Add to Quick Access toolbar. It will now be available with one click whenever needed.

Note: When inserting pictures from online or any source not your own, always ensure that it is copyright-free. To use, you may have to seek permission and/or give credit to the owner of the content. However, there are many sources that are in the public domain and/or are license-free and safe to use, such as Creative Commons License Zero (CC0); emphasis on the 0.

Install Add-ins to PowerPoint and Word for Free Images

Speaking of free and safe images to use, there are plenty available on a couple of Add-ins. Again, it may depend on what version of Office you are using, but here’s how to install from the Microsoft Store:

  • Inside PowerPoint or Word, click the Office Add-ins icon under Home tab (far right on Ribbon)
  • In the Search, type Pickit to display it for download
  • Download and follow the instructions on the pop-up
  • Do the same steps again but in Search, type Pexels

You now have access to free images from both apps in both programs. How cool is that! One odd thing to note…Pickit gets installed at the end of the Home tab, and Pexels gets installed under the Insert tab in both programs. A head-scratcher but they’re free so we don’t criticize! To use either, just click on their icon which will display a task pane to the right; type in a category or specific item you are looking for and let the images flow. You may find some videos as well!

Auto Arrange Chart and Text on a Slide

Designer is versatile and can make a spiffy chart slide (from Excel) in no time too…

  • I created a new Title and Content slide
  • Typed the Title text and the line of text in the Content area
  • Clicked Insert tab, Chart (column). You could also click on the Chart icon in the slide
  • After you choose your chart, an Excel worksheet window auto displays with guide content for you to replace
  • As you fill in your data, the chart is being created on your slide. It may look a mess (like this one) but no need to faint as fixable with a click!

Use Insert Chart to add to PowerPoint slide

  • When completed, close the Excel window to return to your PowerPoint
  • Click on chart, if needed, and click on your Designer shortcut on the QAT (you added it right?) as it may not automatically display.
  • Choose your favorite look from the options
  • Add a title to chart and done! You could also size the chart and the size and/or move them manually, if desired

Designer's Design Ideas for chart layout

Designer is so amazing. No longer do you spend precious time wrangling with the slide layout to create dazzling presentations, and new features get added monthly to Office so be sure to check them out on a regular basis. It makes us look so smart!

Want to use Designer to convert a bulleted or numbered list to an amazing graphic? Here you go:  https://gaylelarson.com/powerpoint-designer-converts-lists-to-graphics/

Hope you had fun with this. What new things have you discovered in Office 365? Let me know in the Comments below!