Microsoft Office for Beginners: Then and Now
- Difference Between Office Versions
- Compare Office Versions
- Best Version Of Microsoft Office
- Which Microsoft Office Package Do I Need
Office + Microsoft 365 Education. The best way to buy Office is with Microsoft 365 Education. Training and resources. Get help with Office. All the online resources you need to download and install Office, manage your account, and troubleshoot. Office training tutorials.
While many features have been added since its initial launch, much of the core product has stayed intact.
In addition to the initial trio, Word, Excel and PowerPoint, today, Microsoft Office also includes Access, Publisher, OneNote and Outlook – all of which seamlessly integrate with each other.
Multiple versions have become available as well, including new and improved desktop apps, as well as mobile apps and a web-based alternative for both Windows and Mac users.
Microsoft 365 E5/A5/G5, Microsoft 365 E5/A5/G5 Compliance, Microsoft 365 Information Protection and Governance E5/A5/G5, and Office 365 E5/A5 provide the rights for a user to benefit from automatically applying retention labels or policies, applying default retention labels or policies, starting the retention period of a retention label based. Compare Microsoft Office features for PC and Mac on the official Microsoft Store. Look at Office Home and Business versus Professional editions. Feb 26, 2021 The apps included in a specific Microsoft Office suite depend on the Microsoft Office package you select (as does the price). Microsoft 365 Family and Personal include Word, Excel, PowerPoint, OneNote, and Outlook. Office Home & Student 2016 (for PC only) includes Word, Excel, PowerPoint, OneNote.
What is Microsoft 365?
In 2011, Microsoft launched its cloud-based subscription service Office 365, to compete with Google Drive. While the apps in Office 365 were nearly identical to its desktop suite, certain features were rolled out only to 365 at first, like Morph and Designer in PowerPoint.
Since then, Microsoft has continued to allocate more and more resources to its cloud-based service, luring in subscribers by offering them exclusive perks.
In 2017, Microsoft announced that Office users will no longer receive access to OneDrive and Skype after 2020 if they don’t subscribe to Office 365. This statement coincides with Microsoft’s “Modern Lifecycle Policy,” which requires you to have the latest version of the product in order to receive full support.
As of April 21, 2020, Office 365 has been rebranded to “Microsoft 365”. Microsoft 365 comes with the same Office apps as its predecessor, with Microsoft promising new apps and services to come.
These changes haven’t hurt Microsoft one bit. Check out its latest numbers.
- In Q3 2020, Microsoft reported 258 million monthly active Microsoft 365 business users, and 75 million daily active Teams users.
- Today, 1.2 billion people across 140 countries and 107 languages use Microsoft Office.
- Microsoft donates an average of $2.6 million in software every day to more than 86,000 nonprofits worldwide.
- In 2020, Microsoft launched AI for Health, a five-year, $40 million initiative to help researchers improve the health of people around the world, including the fight against COVID-19.
What is the difference between Microsoft Office and Microsoft 365?
You can still pick between Microsoft Office (desktop) and Microsoft 365 (web version).
While both offer the same programs that Office users are accustomed to, the upfront costs and platforms they’re used on vary.
Microsoft Office (Desktop)
Microsoft Office (desktop) can be purchased for a one-time payment for the program to be installed on a single device.
You are either given a physical key card with your own specific download code, or you can download the program straight from the Microsoft website.
This key gives you access to the program for as long as you like. In the event of a Microsoft upgrade or a new version of Microsoft Office, you would then have to purchase the new package if you want to receive support.
Standard Office bundles come with Word, Excel, PowerPoint, and OneNote. Microsoft Office programs must be purchased for the user’s operating system (OS) – either a Mac or PC.
If the user gets a new computer, or switches to a different OS, they’ll have to repurchase Office.
Microsoft 365 (Online Subscription)
Microsoft 365 is a subscription product, which you can pay for monthly or annually. As noted above, this product was formerly known as “Office 365” until it was rebranded in April 2020.
Program upgrades are included with this fee, so whenever Microsoft updates its Office apps, you will automatically receive the newest versions.
Because 365 is cloud-based, it can be accessed via any device. This technology allows flexibility for businesses and their employees, as documents and programs aren’t simply tethered to the computer to which the program is licensed.
Microsoft 365 Personal subscriptions can be used on up to five devices across Mac and PC, and it includes Word, Excel, PowerPoint, OneNote, Outlook, Publisher, and Access. Subscribers also receive additional OneDrive storage (1 TB) and 60 free Skype minutes every month.
Microsoft 365 Family subscriptions can be shared by 6 people in total. It includes all of the features of the Personal plan, plus additional OneDrive storage (6 TB).
Microsoft 365 Business plans include Office apps, plus additional features like access to Microsoft Teams and advanced security protections.
Microsoft introduced 365 with the goal of eventually phasing out one-time purchases.
If you don’t frequently update Office, its traditional product should work just fine. But, if you’re interested in getting access to exclusive upgrades, 365 will float your boat.
Regardless, keep in mind that Microsoft made it clear it will phase out the traditional Office Suite in the not-so-distant future.
What applications are included in Microsoft Office?
Microsoft Office has evolved tremendously since its beginnings in 1988, now with a robust slate of offerings for individual and business users. Here’s a look at the programs you’ll find inside Office.
Microsoft Word
Word is unsurprisingly Microsoft’s word processing app.
It was initially introduced to modest reviews because the interface was vastly different from the former leading word processor, WordPerfect. But with the release of Windows 95 and Office 95 (in 1995), sales steadily increased.
Today, Word is the most widely used word processing program. It includes an array of features for document creation and editing, including: Spell-check, a rich text editor, and page features such as justification, paragraphs and indentation.
You also benefit from the what-you-see-is-what-you-get (WYSIWYG) display – as in the screen displays everything in the same way as the document will look when printed.
Microsoft Excel
Excel is Microsoft’s spreadsheet program that can be used to organize, format and calculate data.
You can create formulas to aggregate large amounts of data, graph and chart data, create macros, and develop pivot tables.
Originally a neck-and-neck competitor with Lotus 1-2-3, Excel is now the spreadsheet.
Microsoft PowerPoint
Microsoft PowerPoint helps you create professional presentations.
PowerPoint first launched in 1990, using slides to display text, graphics and multimedia. Since then, it’s added a variety of features to streamline and enhance presentations, such as: transition effects, timers and software integrations.
Microsoft OneNote
OneNote allows you to jot down your thoughts before you forget them. Then, notes can be shared with others.
Much like a digital notebook, the application automatically saves and syncs notes. OneNote was introduced as a standard Office application in 2013, allowing even more users to be able to share their typed notes, drawings and screen grabs with other online users.
Microsoft Outlook
Mainly used as an email application, Outlook is considered a personal information manager, coordinating your calendars, task managers, contacts, notes, journals, and browsing sessions.
Outlook can be used as a stand-alone app, or it can be networked to connect multiple users to shared mailboxes and calendars under a single organization, for example.
Microsoft Access
Access is Microsoft’s database management system that provides a graphical user interface (GUI) and software development tools that allows for stored data or imported data from other databases. With Access, you can use data to create forms, tables, queries and reports.
Microsoft Publisher
Publisher is Microsoft’s desktop publishing program, emphasizing page layout and design.
The program includes templates for frequent business needs, like business cards, calendars and brochures/newsletters.
Publisher is considered a cheaper, easier-to-use version of design software, like Adobe InDesign.
SharePoint
SharePoint is Office’s document management and storage system, allowing users and groups to set up password-protected document sharing in a secure, organized location. It’s a popular tool for businesses, with 80 percent of Fortune 500 companies using it.
Why should I learn Microsoft Office?
Learning Microsoft Office has significant benefits for your daily workflow, productivity, and career possibilities. Microsoft Office skills are indispensable across a plethora of industries and professions, and give those who possess them an advantage in the workplace.
Better employability
82 percent of mid-range jobs now require at least a general understanding of Microsoft Office applications. Simply put, this means those with advanced Microsoft Office skills are highly-regarded candidates for employment.
Higher productivity
Chances are, there are Microsoft Office applications that you use every day. Imagine how much time and energy you could save formatting documents in Word, or working with data in Excel, if you knew the right shortcuts and tips to get there faster.
Global compatibility
With over 1.2 billion Office users globally, Microsoft Office is used widely by companies and education institutions around the world. Learning Microsoft Office gives you transferable skills that you can use anywhere, throughout your career.
Microsoft Office Training
Microsoft Office training is a great way to upskill, refresh your knowledge, and make your resume more attractive. Here are a few of the most common training options in use today.
Online courses
These days, there is no need to attend expensive, in-person seminars to learn Microsoft Office. Online Microsoft Office courses are a convenient and engaging way to pick up some new skills and certifications. There are courses for every level, whether you are a complete beginner or you want to fill in any knowledge gaps you might have.
Team training
Businesses can easily train their entire team, or specific departments, in Microsoft Office through their learning management system (LMS). An LMS makes it easy for managers to assign training and track employee progress through their courses.
Free resources
We’ve put together a few handy and free resources to help you hone your essential Office skills below.
Excel
PowerPoint
Word
Outlook
Microsoft Office Certification
Microsoft offers a variety of official certifications for individuals to demonstrate their expertise within a program.
You aren’t likely to see many jobs that specify an official Microsoft certification as a requirement, however it might be beneficial in certain cases.
If you are planning on training others on how to use Office applications, or your technical Office skills are highly weighted in your role, then you might consider taking this path.
Those with certifications earn up to an average of 15 percent more than their uncertified coworkers.
There are three certification levels to choose from, ranging from training in specific applications to mastery of the full suite.
Difference Between Office Versions
Microsoft Office Specialist (MOS)
This training enables you to demonstrate your abilities with: Word, Excel, PowerPoint, Access, Outlook, SharePoint and OneNote.
According to Microsoft, those with a MOS certification can earn up to $16,000 more in annual salary than those without the certification.
Microsoft Office Specialist Expert
These trainings include advanced skill work in Microsoft Word and Excel. We’re not just talkin’ bold and italics here. You’re tested on the ability to use advanced features, like creating new mail merges inside Word, and adding bookmarks and watermarks to documents.
In Excel, you’ll also need to create advanced PivotTables and perform data analysis with its extensive functions.
Microsoft Office Specialist Master
People with this certification have demonstrated mastery of all Microsoft Office applications. To reach Master status, certifications must be obtained in four of the following: Word, Excel, PowerPoint, Access, Outlook, SharePoint or OneNote.
How do you download Microsoft Office?
Don’t worry: a floppy disk is no longer required.
Today, Microsoft lets you download Microsoft software directly from its website. Instead of purchasing a physical CD or dealing with an install code, you can now select the Microsoft Office programs that best fit your needs, and login into your account via email.
Downloading Office is quick and easy from the Microsoft website. If buying the program as a one-time purchase, you can go to the Microsoft Store on your computer or device.
If you want to subscribe to Microsoft 365, visit https://www.microsoft.com/en/microsoft-365/compare-all-microsoft-365-products.
For older versions of Office, you can go to www.office.com/downloadoffice.
Microsoft 365 users will get always-up-to-date Office applications, OneDrive storage, 60 monthly Skype minutes, and phone and chat support.
- Microsoft 365 Family is available for $79.99 a year, or for monthly payments of $7.99, and comes with logins for up to six users.
- Individuals can download Microsoft 365 Personal for $59.99 a year or $5.99 a month.
- Businesses can choose from a range of subscriptions to suit their needs: Microsoft 365 Business Basic for $5 per user per month, Business Standard for $12.50 per user per month, and Business Premium for $20 per user per month.
- All business plans include access to Excel, Word, PowerPoint, Outlook, OneNote, Teams and OneDrive cloud storage. The higher tier plans come with more advanced security and device management options.
How to get Microsoft Office for free?
You may not be able to snag it for free, but there are many Microsoft Office deals and discounts available for those unable (or unwilling) to pay full price. Here are six of the most popular deals you can utilize.
Discount 1: 365 Education
Students and teachers at eligible institutions can get free access to Office apps like Word, Excel, PowerPoint, and OneNote with Microsoft 365 Education. Enter your school email address at the 365 Education page to see if you are eligible.
Discount 2: Multiple Licenses
Microsoft 365 Family comes with licenses for six computers, making the $100 a year subscription very affordable if split amongst family members or roommates.
Because 365 upgrades automatically, you get the most up-to-date version at all times, and the subscription comes with Word, Excel, PowerPoint, OneNote, Outlook, Publisher and Access.
Discount 3: Military
Current, former, and retired military members (and their family members) get 10 percent off Microsoft Office.
Discount 4: Buy an Old Version
If you aren’t interested in having the latest version of Microsoft, older editions can be purchased at deep discounts. Check out Amazon for previous versions and buy for up to 50 percent off.
Discount 5: Buy the Employee Version
Nearly 122,000 people work for Microsoft worldwide. Current employees can purchase an Office license for only $10, which is valid for the entirety of the employee’s tenure with the company.
Discount 6: Free Online Versions
Microsoft offers free online versions of its Office apps like Word, Excel, PowerPoint and OneNote. Once you sign up for a Microsoft account, you can access your documents on any computer with internet access.
Sources
- 1
- The history of Microsoft
- 2
- Microsoft revenue
There was a time when you had to pony up the high cost of the Microsoft Office suite in order to effectively exchange documents with others. But over the past several years Office has received lots of very appealing competition. In response, Microsoft reduced the price of Microsoft Office, but for many, the price is still a little steep. Before you spend the money on Microsoft Office take a look at these other options. Even without considering the lower cost you may find that some of these fit your needs better. But in the end, if Microsoft Office works better for you you can buy or subscribe to Microsoft Office here. Typically I recommend that if you need a license for a single computer you purchase, but if you need a license for multiple computers (or if you need it for mobile devices) it makes more sense to subscribe.
Here are some of the most popular alternative options available on the Mac. Apple iWork, Google Docs, and LibreOffice. Each one has its own advantages and disadvantages, so there is no one product that will work best for everyone. I myself use all of them depending on who I’m working with or the type of document I’m creating.
iWork
$19.99 per Mac app ($9.99 on iOS), or free with a new Mac or iOS device (the first user to log into the App Store on a new device gets the license added to their account) iWork is now free
Though I almost never see the name “iWork” anymore since Apple de-bundled the components, iWork is Apple’s very own competitor which is comprised of:
- Pages (word processor) Mac / iOS
- Numbers (spreadsheet) Mac / iOS
- Keynote (presentation) Mac / iOS
Idiosyncrasies. As you might suspect from an Apple product, these apps produce some of the most beautiful output with the least effort, since their templates are extremely high quality. Though their focus on CSS-like “Styles” can confuse people who simply want to highlight some text and change a font face or text size. Styles allow you to easily maintain consistency. Want your chapter headers to all be two points larger? Instead of going through each header manually you can just change the format of the “Header” style. Other word processors use this feature as well, but Apple makes it more prominent. So it’s common for people to use this quite complex (though efficient) formatting option and get in over their heads.
Collaboration. The major drawback is for those who regularly collaborate with non-Apple users. Each of these apps saves to their own proprietary format. Each time you want to send a file to a Microsoft Office user you must remember to export it to Word, PDF, etc., and email that output. In macOS Sierra, they added a collaboration feature that works similarly to Google Docs, though unless your collaborator is familiar you may meet some resistance from people you share to.
Privacy. The easiest way to keep your documents available on all of your Macs and iOS devices is to save your documents to iCloud. Apple doesn’t mine your data as you are a paying customer, and they use a very high level of encryption, but if it still doesn’t sit well with you you are able to save the documents to your own computer instead. Even if you do decide to save to iCloud Drive, your computer keeps a local copy for offline use as long as you have available storage, and these local copies also get backed up to Time Machine.
Mobile. Mobile versions of the app are available individually for $9.99, or free with a new iOS devicefor free. This allows you to edit any documents which you saved to your iCloud Drive folder. As an added bonus, the Keynote app on iOS can serve as a remote control to a presentation on another iOS device or Mac. You can even use Apple Watch to control the slideshow.
Good for people who:
- need to create documents for themselves only
- collaborate with other Apple iWork users
- want to share their final product with others
Bad for people who:
- Regularly exchange and edit documents with people who do not use iWork
Google Docs, Sheets, and Slides
Free
Google runs one of the most popular alternatives to Microsoft Office. But their vision, as they are a cloud company, is that instead of installing software on your computer you visit a website and edit your documents in your web browser. It doesn’t have advanced formatting functions, but for most users, it is good enough. It includes
- Docs (word processor)
- Sheets (spreadsheet)
- Slides (presentation)
- Drive (file manager)
Collaboration. It really shines in collaboration features. You can invite other users to collaborate using a link, and as other users are editing and commenting, you see their changes in real-time. And you can simultaneously edit, with each user getting their own cursor. This is a dream for people who work with editors, because without emailing multiple attachments, everyone is always sure to be using the current version, and one person can jump in and make changes without having to worry about the other person finishing their edits first. This is really handy with Sheets, allowing multiple users to compile data into a single spreadsheet.
Compare Office Versions
Mobile. The Google Mobile apps allow you to log into your Google account to view, edit, and share all of your documents.
Idiosyncracies. One thing that throws a lot of people is that there is no “Save” button. Instead, you are editing the document live. Much like a real pen and paper, you don’t save, you just create. If you want to go back, you can browse revisions that are saved automatically. So you are able to see who made what changes when, and roll them back if needed.
Privacy. Though the product is technically free, there is a cost. As we all know Google’s major source of income is through data mining and advertising. The documents that you create are part of your user profile that Google uses to sell you products. Now, that doesn’t mean that someone at Google is necessarily reading through your documents, but they get fed into an algorithm so that Google understands you. This is less of a concern for G Suite users (paying customers using Google on their own domain), because they have a much different user agreement, and can even sign up for HIPAA compliance.
No lock-in. Once you start editing documents in Google’s system you’ll likely always want to keep them there for convenience. However, you can download any document in Microsoft format, or you can export all of your Google data at Google Takeout.
Good for people who:
Best Version Of Microsoft Office
- Collaborate with people on many different platforms
- Want easy access to their documents on the go
Bad for people who:
- Have privacy concerns (if using a free Google account)
- Need sophisticated formatting options
- Need to keep local copies of documents
LibreOffice
Free. libreoffice.org
LibreOffice is a fork of the OpenOffice project and is preferred to its ancestor by many. It is essentially an Office 2000 clone, so many people find it to be much easier to use than the current versions of Microsoft Office with the “ribbon” bars. But it’s quite a full-featured program that most people will find sufficient.
File format. While LibreOffice has their own (open) file format, with a few tweaks you can change the default format to be Microsoft Office for maximum compatibility:
- With LibreOffice open go to the LibreOffice menu > Preferences > Load/Save > General.
- Near the bottom make sure “Document Type” is set to “Text Document”
- Change “Always Save As” to “Microsoft Word 2007-365 *.docx”
- Change “Document Type” to “Spreadsheet”
- Change “Always Save As” to “Microsoft Excel 2007-365 *.xlsx”
- Change “Document Type to “Presentation”
- Change “Always Save As” to “Microsoft PowerPoint 2007-365 *.pptx”
- Click OK.
Collaboration. What it doesn’t have a lot of are cloud and collaboration features. In order to collaborate you create your files, email them to someone. They edit the file and email it back. Very 1999. But if that’s the workflow that works for you then you’ll have no complaints. They recently announced the development of LibreOffice Online, a new project that is similar to Google Docs, where you have real-time collaboration through a web browser. But instead of going to a public website, they are offering the software that you must install onto your own server. This will be great for people and organizations who like the idea of Google’s suite but don’t want their data in someone else’s hands.
Near universal compatibility. This program has some surprising power for people who have ancient documents. It is even able to open documents from WordPerfect, StarOffice, ClarisWorks, AppleWorks, Microsoft Works, Lotus, and much more. You can then “save as” a more modern format.
Good for people who:
- have been using Microsoft Office since the 90s and don’t want to change their workflow.
- are concerned with privacy and don’t want their documents stored on a server
Bad for people who:
Which Microsoft Office Package Do I Need
- need easy access to their documents on mobile
- are in need of a more efficient collaboration workflow