tip : get the latest versions of Word, PowerPoint and Excel for FREE, legally

If you are looking for a FREE (and legal) version of the latest version of MS Office, you just might be in luck :

Microsoft is offering the newest version of MS Office for FREE to students and staff of schools and universities that have licensed MS Office.

This program has run in the US since 2013 under the moniker “Student Advantage”, and is now available in the Netherlands also.

What you get is a FREE one year license to Microsoft’s online cloud service “Office 365”, in the “Pro Plus”-version, including FREE downloads of the latest versions of Office to be installed on maximum 5 Macs or PCs and on maximum 5 Android or iOS devices (like iPhones and iPads).

These latest versions are Office 2011 for Mac and Office 2013 for Windows, both including Word, PowerPoint, Excel, Outlook, OneNote, Skype and OneDrive (Microsoft’s cloud-drive formerly known as SkyDrive).

In the Netherlands, these FREE versions are available for two specific groups :

1- (parents of) students of the primary schools [“basisschoolleerlingen” in Dutch] https://www.surfspot.nl/officeleerling

2- students of (some) higher education [“Hogescholen en Universiteiten” in Dutch] https://www.surfspot.nl/officestudent

The procedure to get this (nearly) FREE software, is quite complex, but it’s well worth the hassle :

– first you need an account at Surfspot.nl (the website for educational discounts)

– then, you need to ‘buy’ the FREE version of Office 365 Pro Plus

– with that, you’ll get a voucher (which might take several days due to popular demand)

– using that voucher, you can activate Office 365 at Microsoft, and you will get FREE download-links to the latest versions of Word, PowerPoint, Excel, Outlook, OneNote, Skype, OneDrive, etc.

–  those apps you can install on maximum 5 Macs or PCs and 5 iOS or Android devices

 

…as mentioned : it’s a hassle, but it’s well worth it !

Enjoy !

😉

Donate Button (MacManusNL)

fixed : where are my Office 2011 AutoRecovery files ?

UPDATE : the updated version of this post for Office 2016 / Office 365 (Word 15 / PowerPoint 15 / Excel 15) can be found here :

fixed : where are my Office 365 AutoRecovery files ?


Question :

I accidentally messed up the Office documents (Word/PowerPoint/Excel) I was working on, and I didn’t save it before, so I wanted to get the auto-saved version from the AutoRecovery-folder as I’ve done before in Office 2008 and 2004.

I forgot where to find the AutoRecovery-folder, so I used Office 2011’s build-in Help-option to get a hint. It told me I would be able to find the folder via this path :

~/Users/username/Documents/Microsoft User Data/Office 2011 AutoRecovery

But when I open that folder I have a “Office 2004 AutoRecovery” and a “Office 2008 AutoRecovery”-folder, but there’s no such folder for Office 2011…

I checked in the Office 2011 Preferences to make sure Auto-saving is switched on, and it is… so where did the folder go ? where are my auto-save documents ?

 

Answer :

You might have guessed : there’s a fault in the Office 2011 Help file. Nowadays, the AutoRecovery-folder is located in an entirely different location on your Mac. The correct path is this :

~/Users/username/Library/Application Support/Microsoft/Office/Office 2011 AutoRecovery

But there is yet another tiny hurdle to get to it : in the current version of OSX, the user’s Library-folder is a hidden folder. So if you want to access it, the easiest way to do so is :

– in the Finder, click on “Go” in the top menu bar

– when the pulldown menu appears, press the ALT-key on your keyboard (a.k.a. OPTION-key) and an extra option named “Library” will appear in the pulldown menu

– while holding the ALT-key, click on “Library” and your personal (hidden) Library-folder will open in the Finder

– there you can navigate to Application Support–>Microsoft–>Office to find the “Office 2011 AutoRecovery”-folder you are looking for

That’s it.

Enjoy !

😉

Note : It is not clear if this problem is due to OSX 10.9 “Mavericks” or that it is occurring with all installations of Office 2011 for Mac. Either way, the solution is as mentioned above.

UPDATE :

it turns out that there’s a bug in Excel 2011 for Mac : even though the Autosave does save  a file with an .xlsx file extension, it’s not a true .xlsx file ! trying to open it will lead to an “Microsoft cannot open this file”-error. The solution is to change the file extension to either .xlsb (Excel binary format) or .xlb (older Excel backup format), to enable Excel to recognize the file and enable it to open.

[ a big Thank You to Paul Preston for noticing this problem and for Bryan P for posting the solution on Superuser.com ]

Donate Button (MacManusNL)

fixed : PowerPoint presentation too large for eMail

Question :

I just made a beautiful PowerPoint presentation which I want to eMail to my friend. When I tried to eMail it, that seemed to work okay at first, but a few moments later I got an error message saying that the eMail could not be sent.

How can I fix this ?

 

Answer :

eMail providers have set a limit to the attachments’ file size per eMail to prevent cluttering the eMail traffic and flooding the recipient’s eMail inbox. For most providers this limit is set to about 5MB of attached files per eMail message. Some providers have expanded this limit to 10MB, and providers like Gmail, Hotmail and Yahoo! even allow you to attach up to 25MB of files to each eMail.

But if your PowerPoint presentation is even larger than 25MB (which might easily occur if you have done your best to make it a beautiful presentation), you will probably do the recipient  a pleasure if you send a smaller file, especially if they are planning on viewing it on a mobile device. The easiest way to ‘shrink’ the size of a presentation is to convert it into a PDF-file. (a PDF-file is even more versatile than a PowerPoint-presentation, as it also can be viewed by people that don’t have PowerPoint software installed)

To convert your PowerPoint-presentation into a PDF-file, do this :

In MacOSX :

– open your presentation in PowerPoint

– then go to “File” in the upper menu bar and select “Print” from the pulldown menu that appears

– in the “Print” menu that appears, adjust everything as desired, then click on the “PDF” button (bottom left)

– in the pulldown menu that appears, choose “Mail PDF” and a new eMail message will be made for you including your Presentation as an attachment

…or you can choose “Save as PDF…” to first save the PDF-version of your presentation to your Mac so you can attach it to any eMail later on

Note : the above procedure also works in other OSX programs like Word, Excel, Pages, Numbers, Keynote, etc.

For Windows users, the general idea is similar but slightly different :

http://office.microsoft.com/en-001/powerpoint-help/save-as-pdf-HA010064992.aspx

If the standard conversion of your PowerPoint into a PDF still turns up with a PDF-file that is too large to eMail, you can adjust the conversion settings, as described here :

How to create even smaller PDFs in OSX

You might also want to try the “Reduce File Size” that is in the “File”-tab of each Office 2011 application (so in Word, PowerPoint and Excel). This option will only reduce the size of the pictures inside the document. The smallest this option can reduce to is 96ppi a.k.a. “Best for sending in e-mail”. This is an interesting option, but converting to PDF usually leads to even more file size reduction.

And if the recipient insists on getting the original PowerPoint-file, you could do as a lot of professionals do, and send your presentation trough the FREE WeTransfer service :

http://www.wetransfer.com

that’s it !

enjoy !

😉

Donate Button (MacManusNL)

fixed : move opened Preview-document from outer corner of Desktop

Question :

I somehow managed to move an open Preview document to the outer corner of the Desktop in such a way that there’s no part of Preview’s document window in sight that can be clicked and dragged. So, there’s no way to drag the open document onto the center of the Desktop…

And closing the document and opening it isn’t an option either, since nove of the red/yellow/green window buttons are in sight either…

How can I fix this ?

 

Answer :

Here’s what to do :

– click and hold the Preview app icon in the Dock

– in the pop-up menu that opens, click on “Show All Wondows”

– in the view that opens, select the troublesome document

…now the document will open in the centre of the Desktop, and you can drag it or close it.

That’s it !

Enjoy !

Donate Button (MacManusNL)

fixed : hashtags making text unreadable in Excel

Question :

Somebody sent me an Excel spreadsheet in which some of the data is unreadable since it has been replaced by text consisting of hashtag signs only…

I’ve seen this happening before, and the remedy used to be just to broaden the column, since all number that are too large to fit their cell width are automatically made unreadable…

However, in this case, if I broaden the column width, some of the hashtag text will turned into readable numbers, but other hashtag text will remain, no matter how wide I make the column…

What is wrong ?

And how can I fix this ?

 

Answer :

This seems to be a problem with Excel for Windows files that are opened in Excel for Mac (possibly more specifically with data copied or converted from another application into Excel on a Windows-PC). So PC-users will not be warned on forehand that their Excel output is not suited for use on Macs…

Fixing it turns out to be rather simple (but annoying) :

• open the file in Excel for Mac

• select the cells that are effected (or preferably even the entire column), then go to “Format” in the top menu bar

• from the dropdown-menu that appears, select “Cells…” and a window entitled “Format Cells” will open

• make sure the “Number”-tab is selected and make sure that you select “Number” or “General” from the list (make sure that it is something else than what was previously selected ; anything seems to be okay, as long as it is not “Accounting”)

• no return to your spreadsheet to check if the hashtag texts have disappeared (if not : try again)

That’s it !

Enjoy !

😉

Donate Button (MacManusNL)

fixed : custom Quartz-filters are not available system-wide

Question :

In the past, I used to create my own custom Quartz-filters in ColorSync Utility, and they were instantly available system-wide in MacOSX. Now, in OSX 10.8 Mountain Lion and OSX 10.9 Mavericks ( and OSX 10.10 Yosemite and OSX 10.11 El_Capitan ), I don’t have access to my Quartz-filters anymore…

What is wrong ? And how can I fix this ?

Answer :

In the latest versions of OSX [*], there seems to be a bug preventing OSX to find Quartz-filters stored outside of the ‘official’ “Filters”-folder that is inside the “Library”-folder in the “System”-folder… so, since all custom-made Quartz-filters are stored inside the “Filters”-folder that is inside the (invisible) “Library”-folder in the User’s “Home”-folder, your custom-made Quartz-filters are not found by OSX…

The solution is to just move them into the right (official) “Filters”-folder. [**]

(Yep, it’s that easy…)

For an in-depth step-by-step guide for doing so, follow the procedure outlined here.

NOTES :

[*] this bug was solved/removed with the introduction of macOS 10.12 Sierra

[**] put differently :

In all versions of OSX from OSX 10.8 Mountain_Lion up to OSX 10.11 El_Capitan,
new Quartz-filters created in Colorsync Utility are/were automatically saved in :
~/Users/[username]/Library/Filters/
But all other applications (including e.g. Preview) weren’t able to access or use them as they could only load Quartz-filters from :
~/System/Library/Filters/
and – only if you created the following folder manually – from :
~/Library/Filters/
So you had to manually move your custom Quartz-filters to :
~/Library/Filters/
to be able to use them in Preview.app and alike

Donate Button (MacManusNL)

fixed : Reduce File Size makes PDF unreadable

Question :

I have created a PDF of 4 pages in the Preview app, but I can’t eMail it to anyone because it turns out to be a 39MB file…

I know the probable cause, because some of the pages are entire A4-size pictures scanned as JPEG at 300dpi…

So I tried to use various ways of saving (or exporting) as PDF from within Preview, but they all end up with the same oversized 39MB file… except for one : the “Reduced File Size” filter from the “Export” option gives me a 240kB file that turns out to be completely unreadable…

Isn’t there any simple way to get a readable PDF of about 5MB or so ?

 

Answer :

Yes there is, but unfortunately it’s rather tricky to set up at first (since there is still no option in Preview, nor in “Save as PDF”, to adjust the PDF-output on the fly… and on top of that : there is a bug in the latest versions of OSX that prevents self-made Quartz-filters from ColorSync Utility to be accessible throughout OSX…)

Here’s how to :

1- open the ColorSync Utility that is in the Utilities folder within the Applications folder

2- if no window opens, click on File –> New Window

3- then click on the “Filters” tab

4- then click on the “+”-button in the bottom-left corner to create a new Quartz-filter

5- type “Reduce File Size 75dpi”, then click on the small round button (with the small white triangle in it) at the end of the line

6- from the pulldown menu select “Add Image Effects Component > Color Image Sampling” and now some adjusting options appear, leave most of them as-is, only at “Resolution:” type “75 pixels/inch” (so leave the other options empty and leave “Quality:” at “High”)

7- repeat this last step, but this time select “Add Image Effects Component > Grey Image Sampling” from the pulldown menu (so set “Resolution:” to “75 pixels/inch” here also)

8- tripple-check to make sure that the name of the Quartz-filter is “Reduce File Size 75dpi” and the “Resolution:” is set to “75 dpi/inch” at both instances… if that’s not the case : correct it before continuing (just retype at the correct spot)

OPTIONAL : click on the “+”-button again to create another new Quartz-filter, call it “Reduce File Size 120dpi” and repeat the above procedure, just set “Resolution:” to “120 dpi/inch” this time (…and you can even repeat this for other resolutions like 100 dpi/inch)

9- now close ColorSync Utility

10- now, in the Finder, press the ALT-key on your keyboard and select “Go” from the upper menu bar, in the pulldown and extra (ghost) folder called “Library” will appear, click on it and in the Finder window that opens, select the “Filters” folder (there you will see the Quartz-filters you’ve just created in ColorSync Utility)

11- then, in the Finder open another (new) Finder window and open the (regular) “Filters” folder that is in the “Library” folder in the “System” folder also (there you will see all the standard Quartz-filters available throughout OSX)

12- put both of these Finder windows side-by-side, then select the Quartz-filter files you’ve custom created, and drag them into the other “Library” folder (the one in the “System” folder)

13- then you get an authentication warning message that you need administrator rights to add anything into the folder, so type your administrator password and the custom Quartz-filter files will be moved into the System’s “Filters” folder

UPDATE : from OSX 10.11 El_Capitan on, you will see a grey NoEntry-sign when trying to access the System’s “Filters” folder ; this is due to El-Capitan’s SIP (System Integrity Protection) feature ; to solve this follow these extra steps :

  • instead of moving your self-made Quartz-filters into the ~/System/Library/Filters folder, you should move them to the ~/Library/Filters folder
  • since that last folder doesn’t exist by default, you will have to create it first
  • to do so, go to ~/Library in a Finder-window and click on the Sprocket-icon (a.k.a. GearWheel-icon) and select “New Folder” from the pulldown list
  • when prompted, enter you administrator’s name & password to allow this new folder to be created
  • when done, move your self-made Quartz-filters info this newly created folder at ~/Library/Filters

14- close all open windows

15- select the PDF file that’s too big and open it in the Preview app

16- in the Preview app, go to “File” and from the pulldown menu, select “Export” (do not select “Export to PDF” or “Save” or “Print” !!!)

17- in the window that appears, choose a (new) file name and a location to save the size-reduced PDF-file, then set “Format:” to “PDF” and at “Quartz Filter:” select “Reduce File Size 75dpi” and click the “Save”-button

18- then go to the Finder and select the newly created size-reduced PDF-file and right-click and select “Get Info” (or use the CMD+I key-combo), in the window that opens, check the file size (note : any file up to about 5MB can easily be sent as an eMail attachment)

19- then open the size-reduced PDF in the Preview app and check if the text is still readable… if  all text has turned fuzzy, do a new Export from the original PDF but choose another Quartz-filter (like 100dpi or 120dpi… if you didn’t create those, redo the entire process to create them and make them available throughout OSX)

20- that’s it ! you now have created a very handy and quick PDF size reduction option within the Preview app !

Enjoy !

😉

Donate Button (MacManusNL)