All posts by Gayle

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: http://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: http://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…

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

http://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:

http://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:  http://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!

Convert Slide Lists to Graphics with PowerPoint Designer

Built into Office 365, is the ability to convert slide lists to graphics with PowerPoint Designer. Make that bulleted or numbered list in into an eye-catching graphic.

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

Design Ideas with PowerPoint Designer

Jazz Up Bulleted Lists with PowerPoint Designer

Here is my original, boring bulleted slide:

Convert bulleted list to graphic

I want to jazz up my boring bullets and have Designer automatically give me the task pane to choose an image. It will analyze my list and display its best suggestions at the right. This can be any kind of list, whether actual steps or relevant points.

If my bulleted list is obviously steps or a process, Designer will display automatically, but if not, I can manually display design suggestions even if not a process list:

  • Select the bulleted list

Manually display Design Ideas

  • Click Design tab, choose Design Ideas from Designer group

Design Ideas icon on Ribbon

  • Scroll through and click on the suggested Design Ideas in the task pane to insert into slide, such as:

Graphic for bullet steps

Jazz up a Numbered List

I’ll get some different results if it is a numbered rather than bulleted list:

  • Select the list
  • Click the Numbering icon in the Paragraph group, Home tab
  • The Designer will display with different suggestions…

Use Designer with a numbered list

  • No more boring slide – totally rearranged with one mouse click!

PowerPoint Design Ideas for Lists

Play around with these for interesting results. This is fast and easy but the suggestions may be limited and I may want more graphic selections. There’s an app for that, so to speak! Although a little more manual, I can achieve similar results with SmartArt like below…

Convert Bulleted List into Graphic with SmartArt

For more selections:

  • Select the bulleted list
  • Right click over selection, choose Convert to SmartArt from list
  • Roll over available options to see Live Preview. If you want additional selections, click More SmartArt Graphics… at the bottom

Convert PowerPoint list to SmartArt

Preview SmartArt designs for bulleted list

  • (Note you don’t get Live Preview here as the object change shows at right). After inserting your choice, any time you click on that part of the slide, the special tabs and groups for SmartArt will display on the Ribbon so you can edit the design as much as you want.

TIP: Which type of list should I use – bullets or numbering? Use a numbered list if you want order of priority or specific steps. Use the bulleted list for items that don’t need to be in order of process.

Think this is an awesome feature? Well it is, but it gets even better when you add photos, charts or other graphics, and let Designer make those slides sing! You can see them and use them too, with this blog:

Also, a couple of other blog posts that may interest you as they involve SmartArt and graphics with PowerPoint but don’t require Designer:  http://gaylelarson.com/convert-slide-bullets-to-smartart-graphics/; and http://gaylelarson.com/powerpoint-quickstarter-for-research/

Let me know in the Comments below how you are using Designer or other graphic tools to liven up that presentation!

Windows 10 Includes Zip and Unzip (Compress) Function

You no longer need to download or install a third party zipping utility as Windows 10 includes Zip and Unzip, just one of the many features that were not included in previous versions of the operating system.

If you received an email attachment that has been compressed or want to download a program or gallery of pictures from the internet, they will most likely be zipped. Usually no problem getting them to your computer but what to do then?

Windows 10 includes Zip and Unzip

You may have questions depending on the location of the file or program, such as:

  • How do I tell if it is a zipped (compressed) file?
  • Where do I find the file I downloaded?
  • How do I unzip the file I got from  a website or as an email attachment?

Legitimate questions, and if you are not familiar with zipping utilities, the steps can be a mite confusing. Let’s look at some ways to handle receiving or downloading zipped files…

Unzip a Folder or File Downloaded from the Internet

First, you can always spot a compressed file as the folder will have a zipper on the front of it.         Windows Zipped Folder

As for location, if you have downloaded a compressed file or folder from the Web, it will automatically be in your Downloads folder – Fortunately, very easy to access in Windows 10. The download could be a program or one large file or a folder containing many pictures or documents, so will refer to all as “file” in the steps below for unzipping them.

For some reason, Microsoft changed the names of some of the Windows folders (to keep us on our toes) so will include what they were called in previous Windows in case that has caused some angst:

  • Click on File Explorer icon on the Taskbar (automatically added as a default icon when the operating system was installed). Previous versions were called Windows Explorer.
  • Scroll up to the Quick Access area and click on the Downloads folder (also auto added on install). Quick Access was formerly called Favorites
  • If you did this immediately after the download, it will be highlighted in the list. Looking later, you can sort by any column by clicking its heading, once for Ascending and again for Descending; (will toggle back and forth with each click).
  • Click once on desired file and note the Ribbon will change to reflect it is a compressed file. (If Ribbon does not display, right click on word “Extract” at top, and click Minimize the Ribbon to remove the checkmark and display it).

Windows 10 includes Zip and Unzip

  • On the Ribbon, click the word Extract which will display an Extract All icon: *

Extract All icon in File Explorer

TIP: You can also right click over the zipped file and choose Extract All. Double-clicking the file will also bring you to this screen.

  • This displays a dialog box so you can choose where you want to save the file once unzipped:

Extract zipped folders dialog box

  • The folder noted will be the Downloads folder so you want to click the Browse… button
  • Select the destination folder to extract to but if a main location like Desktop, you need to select an existing folder there or create a new folder or subfolder:

  • Click the Select Folder button at bottom. The dialog box displays confirming your selection.
  • Click Extract button:

  • That folder will open and your file | folder will be listed. Double click to open and use to your heart’s content!

Looks like a lot of steps but really is not. You will “zip” right through them!

Unzip an Email Attachment

The process is going to be the same once you get to the unzipping part but how you get there will depend on how your email program handles attachments. Here’s how the most popular ones behave:

  • Outlook.com or Hotmail.com Click the zipped file icon at the top of the email to immediately download or click Download or Save to OneDrive link to start the process. OneDrive, formerly SkyDrive, is Microsoft’s cloud storage and you get 15GB free. If you chose Download, the folder will display at bottom of screen. Click to Open or Show in Folder. Open will bring you directly to screen with Extract All on Ribbon and you can choose where to save it. Show in Folder takes you to the Download folder.
  • Outlook on Desktop (Office): Zipped icon gives you choices to Preview, Open or several Save options. If you open or double click the file, you get this warning, and if you click Open again, you will arrive at that same Extract All screen.

Opening Mail Attachment dialog box in Outlook

  • GmailPlaces the attachment at the bottom of the email with choice to Download or Save to Drive (Google Drive). If you select the Drive option, you can click Organize (or the Learn More… prompt that displays at the top of the Inbox). You also get 15GB free storage here.

GMail download link

Tip: If you are unzipping photos or videos or documents you want access to from anywhere with internet access, then saving to cloud storage is the way to go, especially since it is free! Besides OneDrive and Google Drive, another popular option is Dropbox, so you can spread the files around if you get close to capacity in any one.

Where Do I Find the Original Zipped Files?

Your downloaded files stay in the Downloads folder unless you delete them, so you can extract them as many times as you want. Very handy if previously extracted files get lost, corrupted or altered.

As Windows 10 includes Zip and Unzip utility, it saves having to download any separate programs – one less thing to do or deal with is always a good thing, I say!

We’ll discuss ways to zip your own content to share with others in another post.

If you want to see other nifty features that are built into Windows 10 such as Virtual Desktops that allow you create multiple desktops, visit this blog:  http://gaylelarson.com/create-virtual-desktops-in-windows-10/

Do you save most of your unzipped files to your computer drives, the internet or both? Let me know in the Comments below.

Use Pick Up Style in PowerPoint to Repeat Object Formatting

What is the Pick Up Style?

The Pick Up Style feature allows you to copy formatting of an object including its text to another object, similar to a color picker.

You can use the keyboard shortcuts or add the Pick Up Style and Apply Style icons to the Quick Access toolbar. We’ll look at both.

The shortcuts are the Copy/Paste ones with the SHIFT key added so that only the style and formatting are copied:

  • Pick Up Style: CTRL+SHIFT+C
  • Apply Style: CTRL+SHIFT+V

If you are not a keyboard shortcut fan, just add the icons to the Quick Access Toolbar (QAT) as follows…

Add Pick Up Style to Quick Access Toolbar

The QAT as it is fondly known, is a super tool included in all Office applications for quick access to your most used commands. There are several ways to access its Customize screen to add and remove commands.  We’ll add the Pick Up Style and the Apply Style icons:

  • Right click on the Ribbon or the QAT and choose Customize Quick Access Toolbar, (or click the dropdown arrow at the end of the QAT, and choose More Commands)
  • In the PowerPoint Options dialog box, change the Popular Commands option to All Commands. (You could also choose Commands Not in The Ribbon in this instance, but always choosing the former will save you time and aggravation down the road)

PowerPoint Quick Access toolbar dialog box

  • Scroll down in left pane and click Pick Up Style
  • Click Add to display It at the bottom of the QAT. (If you want it to display in a specific location on the QAT, click the command above that location in the right pane before choosing Add)

PowerPoint Options Pick Up Style command

  • Click Apply Style in left pane (ensure Pick Up Style is selected in right pane)
  • Click Add
  • You can use the arrow boxes to move the commands up or down in the list, if needed
  • Click OK to return to your presentation

     

    You now have these two icons on the QAT. Note that the Pick Up Style has the Up arrow and the Apply Style has the down arrow:

PowerPoint Pick Up Style and Apply Style icons

Apply Style to Object(s)

We’ll use Shapes here for an easy example of how efficient these tools are:

  • Click Insert tab, and in the Illustrations group, click dropdown arrow on Shapes
  • Draw any shape on the slide (see example below)
  • Format the shape and type and format text
  • Draw another shape and add text to it

PowerPoint Shapes inserted before Pick Up Style

  • Select Shape 1 and click Pick Up Style icon on QAT (or press CTRL+SHIFT+C)
  • Select Shape 2 and click Apply Style icon (or press CTRL+SHIFT+V)

PowerPoint Shapes formatted with Apply Styles

Your shapes are now matched in color and text formatting!

NOTE: You can also use the Format Painter to copy and paste formatting but the actions have to be in succession (like using F4 to repeat last action), whereas the Pick Up Style is remembered even if Apply Style is used later, so you can continue to apply to multiple objects while working in the presentation.

TIP: If the QAT gets too cluttered, remove any command with a right click over desired icon; choose Remove from QAT

I hope this tool makes creating presentations faster and more enjoyable for you. Want more automatic formatting features in PowerPoint? Have a look at this blog:  http://gaylelarson.com/convert-slide-bullets-to-smartart-graphics/

Let me know the features you use to speed up your presentation masterpieces in the Comments below!