Did you know you can setup FREE surveys with Excel Online? I may have another “real” one soon, but I decided to have some fun and advertise my tips and tricks sessions for Office 365 and Windows 10 at the same time tonight. To take the survey, click on the following short custom URL – http://bit.ly/DESAEnt
I get a lot of questions about Microsoft scams – it seems like the amount of email threats, scams, and phone calls from people pretending to be Microsoft (or another computer company) must be making someone somewhere money. We have taught our kids if it sounds too good to be true, it probably isn’t true. That’s why I was really proud when both of them didn’t believe me when I told them about Microsoft Rewards (“how do you get real money from just using the computer and Bing?!?!” my son asked). This is that too good to be true offer that’s real.
You don’t get paid directly – Bing Rewards is something you opt into with a Microsoft Account. It allows you to collect rewards for what you already do – surf the web, search, use a mobile device or tablet. My son is quickly becoming the expect in Microsoft Rewards. He shared the news with his younger sister who is now old enough to earn rewards as well (you have to be at least 13 years old – https://www.bing.com/rewards/tou)
Sam has already turned some of his Bing Rewards into gift cards. I think he was more excited about this than working for me in our new business (which he earns a lot more than just Bing Rewards for). Stay tuned for another “too good to be true” offer involving online training from DESA Enterprises.
Today Sam has his first post on our site – he blogged about setting up AirServer on our Xbox One. It looks like this version only allows for multiple iOS or OSX devices to be mirrored. Up to four devices can be simultaneously be mirrored at once (pretty nice feature). Read Sam’s post AirServer for Xbox One – and check out the trial on your Xbox One!
I found an app over the holiday that will allow you to mirror your iPhone, iPad, or Mac on to your Xbox One at home. All you will need is to download the free trial version of the AirServer app in the store and follow these three easy steps on your apple device
Here’s a post for the holiday week – it includes a hardware tip from my father, John and a software tip for any platform. The hardware tip is for any printer. My dad stopped by to have us assist him with some mailings. He had some labels to print and walked me through mail merge (something I have not had the need to learn yet). When we were getting ready to load the labels into my printer, I suggested we run a test page to figure out how to load the labels (should the label be on the top or bottom? Which side is the top of the page, etc. My dad showed me the picture on the bottom of the tray that helps you load letterhead, labels, or any other kind of special paper.
There is also an Office Insider program. Similar to the Windows Insiders, this gets you early access to the Office features that are coming to Mac, Android, iOS and/or Windows! Since this can be your productivity suite, a secondary system or a virtual system might make sense for features that are early in the cycle, but fortunately I use Parallels on my Mac computer so I can virtualize Windows and Mac OS X on the same system. Perfect for testing Office and other applications.
I used Skype (and prior to that Lync and early on Office Communicator) – it truly transformed the way I work. Instead of everything in email, with Skype you can ask a quick question directly. If a coworker starts something in email that can be quickly answered (or maybe should have been an instant message in the first place), you can respond in context with an IM.
Here’s the response – and yes we are having Thai.
I was teaching a tips and tricks session today on Outlook for Mac focused on various aspects of scheduling. Shared calendars came up and we discussed various forms of shared calendars as well as Office 365 Groups. On the Mac version of Outlook, you don’t see groups, but you can see them from the Web version. You can also decide when you create an appointment whether to only have it on the group calendar or also on group members individual calendars. Here’s how I put an appointment only on the group calendar (these screen shots are from Outlook and Internet Explorer on the PC. The left shows the email a user receives when they join or are added to an Office 365 Group (it has a link to view the group from a browser) the right shows managing the group’s calendar (separate from an individuals calendar).
What if you want everyone in the group to be able to reference appointments or a schedule without cluttering up each member’s local calendar? This would be one of a few ways to accomplish that (manage the group’s calendar but don’t send the invites to members)
If the appointment makes sense to have on my local calendar as well, I would check the Send an invitation to the group – if not it’s only on the group calendar.
Some of these tips I have known for a long time – some I have learned more recently. This is one in the I learned recently column. If you are using Outlook on a Mac or PC, you can switch between the various views with the following keyboard shortcuts: CTRL + 1, 2, 3, 4 and 5 (on Windows) or Command + 1, 2, 3, 4, 5 (on OS X)
I promised a tip for Windows next. I tested this on a Mac hoping it was a cross platform tip, but it’s still a Windows only trick today. I discovered one of these and then the other in Word 2013, but it’s been around since at least Word 2003 as well (there’s a link to another article for Word 98 which was a Mac version, so maybe it originated on the Mac, like Word and the Office Suite itself
) When you are in Word and you want to focus on the layout or the look of a document more than the words, sentences, paragraphs, etc. Use the following =lorem() and press enter.
It’s handy and can control how much text is placed into the document. If you use two numbers in the parenthesis separated by a comma, you get the number of paragraphs and then number of sentences specified – (2,4) would produce two paragraphs each with 4 sentences of “non-localized, pseudo-Latin sample text”. Since it’s Windows only, the files could be saved from a Windows version and then used online or on a Mac or mobile/tablet version of the apps.
Watch for more features in Office applications coming next week.
PowerPoint was always an app I enjoyed working with and up till discovering this feature, I always preferred the Windows version. But the Reorder Objects feature on the Mac – wow! Here I have an animation I’m working on and the graphics weren’t in the correct order (I want each graphic to be in front of the previous graphic). The Reorder Objects gives you a visual representation of each layer and the further to the right indicates that layer is on top of anything to the left.