How to Dump Office for Docs and Excel for Spreadsheets

Word processors have come a long way and now include many of the same features previously found in desktop publishing software, such as the ability to create tables and insert media. You can also collaborate with others on the same documents and make notes and comments if corrections are needed. This can work in real time over a network.

When your hands are full or busy with multiple tasks, you can skip the keyboard and dictate your thoughts, notes, and other documents. Tap or click here for instructions on dictating in Microsoft Word and Google Docs.

Microsoft Office has been around for a long time and it is understandable that people are quite familiar with its uses. But as more businesses and educational institutions adopt Google programs like Docs and Sheets, it can’t hurt to look the other way. And you can save money by switching.

Office history

Microsoft Office was launched in 1990 as a suite of apps, including Word and Excel. MS Office has grown into versions for the web, smartphones, and Windows PCs. There is a subscription model called Office 365.

While there is a free, lightweight version known as Office on the web, if you want the full capabilities of the apps, you have to buy or subscribe to the programs directly. Both methods are expensive.

Daily tech news that matters to you

Privacy, security, the latest trends and the information you need to live your best digital life.

Google programs such as Docs and Sheets are free to use with a Google account. If you are considering a switch, you will save money. However, there are other factors to consider. Will Microsoft to Google Adaptation Be Difficult? Read on to find out.

From Word to Documents

If you’re a Word veteran, you shouldn’t have much trouble picking up Docs. The two apps share many of the same features.

Start with the toolbar at the top of the screen. You will see very similar icons for formatting your text: bold, italics, underline, alignment, font and text size and color. The File and Insert menus contain many of the same options, and both apps have easy access to undo and redo buttons in the form of curved arrows.

Let’s see how some actions work in MS Word vs Google Docs.

RELATED: Google Trick: Shortcuts to Quickly Access Docs, Sheets, and Your Calendar

Export a document

To export/save a document in another file format, such as a .docx or .doc, in Word:

Go to File > Save As. Choose a location or folder where you want to save the file. Click Save as type at the bottom of the window and select a file type. Click Save.

Google will automatically save your changes as you type, as long as you’re signed in. You can still manually save and move a document:

Go to File > Download. Choose a file type. Depending on your browser settings, your file will either be automatically downloaded to your default Downloads folder, or you will be given the option to choose a destination.

Check word count and grammar

With Microsoft Word, your word count is always visible at the bottom of the screen. For more details, select Review in the top toolbar and then click Word Count. While you’re there, you can click Spelling and Grammar for a quick check.

Go to Tools > Word Count to see your word count in Google Docs. Check the box for Show word count as you type to see it while you work. Go to Tools > Spelling and Grammar to check your work.

Add images

To add a picture in Microsoft Word:

Click the space in your document where you want to insert an image. Go to Insert > Pictures. Choose This Device to insert images from your computer or other devices on your network. Choose Online Images to choose from online sources.

To add an image in Google Docs:

Click the space in your document where you want to insert an image. Go to Insert > Picture. Choose Upload from computer to browse the files from your computer. Choose Search the web to get a sidebar for Google Images. You also have options to add photos from your Google Drive and Photos accounts. Select URL to insert a link to an image. Select Camera to take a new photo.

Excel vs Sheets

You should find it easy to familiarize yourself with Spreadsheets if you’re used to Excel. You will soon find the same functions under similar names or new menu options. Below are instructions for some basic operations. You will see how similar they are.

Apply filters

Filters allow you to focus on specific data sets. Here’s how to do it in Excel:

Highlight the data you want to filter. Select Data on the toolbar and then Filter. Click the down arrow in the column header to display a list of filter choices. You can also right-click the cells, select Filter, and choose from the options: Value, Color, Font Color, or Icon.

And now here are instructions for Sheets:

Select a range of cells. Click Data > Create a filter. Move to the top of the range and click the Filter icon to see the filter options. Now you can filter by color, condition or values.

This is what your screen should look like:

Send email notifications when you make a comment

By default, if you share an Office document from your OneDrive account or use Office 365, everyone with that document will receive email notifications of changes. You can disable this from the Notification settings in your OneDrive account.

In Google Sheets, go to Tools > Notification Rules and select from the email options.

Add heatmaps

Heatmaps are graphical representations of values ​​that give you a quick overview of the general data. To add a heat map in Excel:

Highlight the desired data. Go to Home > Conditional Formatting. Click Color Scales and select a type. Click More Rules to set the values.

It’s just as easy to create a heat map in Sheets:

Select a range of cells. Go to Format > Conditional Formatting. Select Color Scale in the right pane, choose a default format, and set the values.

You May Also Like: Outlook Gets a Massive Redesign – Here’s a Sneak Peek

Leave a Reply

Your email address will not be published.