Can You Buy Just Excel

When it comes to Excel, there isn't much middle ground.

You have people who absolutely love it and will sing the praises of spreadsheets all day. And, then you have the people who absolutely detest it. They'd rather lock themselves in a phone booth full of mosquitos than have to go cross-eyed looking at all of those columns and rows.

Admittedly, I used to fall into that latter group. I'd open a new Excel workbook with the best of intentions. But, after 20 odd minutes of trying to get one stupid decimal point to appear properly in its cell, I'd throw my hands up once again and claim Excel just wasn't for me.

Then, my life experienced a major plot twist: I married a total Excel whiz—someone who literally spends his entire workday creating complicated macros and some of the most impressive spreadsheets I've ever seen. And, he's made it his personal mission to convert me to his tribe of Excel-lovers (honestly, I'm surprised it wasn't in his wedding vows).

Since then? Well, he's made some progress. I've been able to put my hatred aside and recognize that Excel can actually be an incredibly powerful tool for combing through information and finding exactly what you need—provided you know how to use it correctly.

Can You Buy Just Microsoft Excel

It's that last part that trips people up. But, fortunately, Excel isn't nearly as complicated as you're likely making it out to be.

Best Value Save when you get Excel with Microsoft 365. With Microsoft 365 you get Excel plus Word, PowerPoint, Outlook, and 1TB cloud storage per person for all your files, music, photos, videos and more. Share and collaborate with others across all your devices. If you need PowerPoint or other Office components, then yes, you will have to pay for it, but for many, many users, the Starter Edition with Word and Excel is more than adequate. If you buy a new computer, here's how to setup the Microsoft Office Starter Edition: 1. Click Start – All Programs – Microsoft Office. Office.com provides completely free, but slightly limited, online-only versions of Word, Excel, PowerPoint, Outlook and other tools. Around since 2010, the website has largely flown under the.

• Premium Excel Spreadsheet Marketplace. Buy and sell premium spreadsheets. Open your shop today or browse our selection. Make money selling your spreadsheets.
• Excel gives you the ability to protect your work, whether it's to prevent someone from opening a workbook without a password, granting Read-Only access to a workbook, or even just protecting a worksheet so you don't inadvertently delete any formulas.

In fact, there are plenty of helpful tricks and tools you can utilize—whether you're a total newbie or an established expert. Here are six things you should absolutely know how to do in Excel (and, trust me, you'll be glad you do!).

Want to learn more?

Take your Excel skills to the next level with our comprehensive (and free) ebook!

1. Sort data

Typically, spreadsheets are useful for storing and sorting a whole bunch of information—think a contact list for 800 people that you want to invite to your company's luncheon, for example.

Now, let's say that you want to sort those people accordingly. Perhaps you want them listed in alphabetical order by last name. Or, maybe you want to group them together by city.

Buy Standalone Excel

Excel makes it easy to comb through your entire data set and sort everything into a clean and easy to read spreadsheet.

Here's how you do it:

• Highlight the entire data set you want to sort (not just one column!) by either dragging your cursor across all of the cells or clicking the triangle in the upper left of your spreadsheet to select the entire thing.
• Hit the 'Data' tab.
• Click the 'Sort' button.
• Select how you want to sort your data (in the example below, I sorted by city!).
• Hit 'OK.'

Then, your data will be sorted accordingly—in this case, alphabetical order by city.

IMPORTANT NOTE: It's important that you select the entire data set you want to sort, and not just one column. That way, your rows will stay intact—meaning, in this case, the correct address will stay with the appropriate person.

Had I just selected the first column, Excel would've sorted only that one column alphabetically, making the addresses a mismatched mess.

2. Remove duplicates

It's inevitable: When you're working with a large dataset, there are bound to be a few duplicates that sneak their way in.

Rather than getting bleary-eyed and frustrated by scrolling through that entire spreadsheet and looking for them yourself, Excel can do all of that legwork for you and remove duplicates with the click of a button.

Here's how you do it:

• Highlight the entire data set.
• Hit the 'Data' tab.
• Click the 'Remove Duplicates' button.
• Select what columns you want Excel to find duplicates in.
• Hit 'OK.'

IMPORTANT NOTE: Be careful that you choose enough qualifiers to weed out the true duplicates. For example, if I had just selected to remove duplicates in only Column A above (meaning Excel would've looked for duplicates of 'Oprah'), I would've deleted one Oprah that indeed had the same address, but one that had a different last name and address altogether (a different Oprah entirely!)

The bottom line is, utilize enough information so that you're removing rows that are true identical copies of each other—and don't just share one similar value!

3. Basic math functions

Stop reaching for that calculator—Excel can handle all sorts of math functions for you! All you need to do is enter a few simple formulas.

Think that sounds like it's way beyond your Excel knowledge? Hp simple scan. Think again. Trust me, if I can figure this out, so you can you.

Here are the basic formulas you'll want to know:

• Addition: Type 'SUM=' in a blank cell where you want the total to appear, click the cells you want to add together, and then hit 'Enter.'
• Subtraction: Type '=' in a blank cell where you want the difference to appear, click the cell you want to subtract from, type '-', click the cell you want to subtract, and then hit enter.
• Multiplication: Type '=' in a blank cell where you want the total to appear, click the cell for a number you want to multiply, type '*', click the cell for the other number you want to multiply, and then hit enter.
• Division: Type '=' in a blank cell where you want the remainder to appear, click the cell for the number you want to divide, type '/', click the cell for the number you want to divide by, and then hit enter.

Listen, I know these are a little confusing to put down in words. But, give them a try for yourself and I'm positive you'll quickly see that they aren't complicated at all. Here's a look at what the SUM function looks like in practice:

INSIDER TIP: If you want to drag the same mathematical formula across a row, you can! After entering the formula into one cell, click that cell where the total appeared, click the little green box that appears in the lower right-hand corner, and drag it across the rest of the row where you need that formula to be applied.

Voila—it'll happen automatically! You'll be able to crunch numbers in different columns, without needing to enter the formula again and again.

4. Freeze panes

There's nothing worse than scrolling through a huge spreadsheet that requires you to continuously go back up to the top to see what your column headers are.

Fortunately, you can make your column headers and your row numbers stay right where they are—meaning you can always see them, no matter how far down the spreadsheet you go. You can do this by using Excel's handy 'freeze panes' feature.

Here's how you do it:

• Click on the row underneath your column headers.
• Click on the 'View' tab.
• Click the 'Freeze Panes' button.

Scroll down and across your spreadsheet, and you'll see that the information you need is always right there within view!

5. Insert current date

Sick of glancing at your calendar or the bottom of your computer monitor in order to get today's date and enter it in your spreadsheet?

Excel can do it for you—with just one easy keyboard shortcut. Here it is:

Ctrl + ;

Put your cursor in the cell where you want the date to appear, use that shortcut, and Excel will automatically fill in today's date for you. Easy peasy!

IMPORTANT NOTE: Dates entered using that function are static, meaning they won't change as your spreadsheet ages!

6. Make the same change across worksheets

When you're working with multiple tabs, it's a hassle to comb through them all and make the same change over and over again. Fortunately, you don't have to!

You can select the appropriate sheets in your workbook where that change should appear. Make the change once, and it'll be applied across all of the sheets you selected.

Here's how you do it:

Can You Buy Microsoft Excel

• Hold the 'Command' key on your keyboard (or 'Control' if you're using a PC).
• Select the appropriate tabs of your workbook.
• Make the necessary change to one cell.
• Check to make sure it applied across all of your worksheets.

Want to see this in practice? For simplicity's sake, let's assume I got married to Aaron Rodgers (hey, a girl can dream!). As a result, I changed my last name from 'Boogaard' to 'Rodgers.' Since my name appears in numerous different tabs of this spreadsheet, I'd use this handy trick to only have to enter my new last name one time.

And that's what you need to know how to do in Excel

I get it—Excel can feel a little intimidating. But, once you start playing around, you'll begin to become more and more comfortable and quickly begin to realize just how much easier it can make things for you.

Can You Buy Excel Only

Get your start by mastering these six basic Excel tricks, and you'll be on the path to becoming a total Excel whiz in no time!

Want to present your Excel data in a professional way? Check out these Excel presentation tips.

Level up your Excel skills

Become a certified Excel ninja with GoSkills bite-sized courses

Hopefully I'm not too late with my advice. Hopefully nobody has yet bought Microsoft Office 2019. So why am I recommending that you don't buy it?

Before I explain, if you already understand Microsoft's Office 365 subscription model, then just read the next 3 paragraphs. If you don't know the difference between Office 365 and Office 2019, you'll probably find this entire blog post useful…

Summary

Excel 2019 is a point-in-time snapshot of the features and functionality of Excel. That point-in-time snapshot was taken in March 2018.

Any functionality that Microsoft has added to Excel (and the other applications in Office) since March 2018 will not be available to Office 2019 users. It will only be available to those with an Office 365 subscription.

In other words, when Microsoft released Office 2019 in September 2018, it was already 6 months out of date. Today it is almost A YEAR out of date.

Details

Can You Buy Just Excel

Traditionally Microsoft have released a new version of Office every 3 years, the most recent versions being 2007, 2010, 2013, 2016 and 2019. These versions were either released in those years or late the previous year.

Individuals and organisations can choose to buy the new version or remain on the old version. If you choose to buy the new version you will, of course have to pay (MS Office is not freeware) although if you have a licence for an older version, you are entitled to a cheaper 'upgrade licence'.

Although Microsoft still offer that purchasing model, things changed in 2011 with the introduction of Office 365.

Office 365 is a subscription service from Microsoft. When it comes to the cost and what you get for your money, it get depends on which Office 365 package you buy. There are packages for home users, students and businesses. You can check out the latest prices here

Depending where you buy it from, a single copy of Office 2019 will cost you around $250. However, this is a one-off payment. You won't have to pay again until you decide to upgrade to the next version in say, 2022. That works out at approximately $83 a year and if you choose not to upgrade until Excel 2025 comes out you can cut that cost in half.

For your $250 you get 1 licence which means that you can only install Microsoft Office on a single computer. You do not get access to OneDrive (Microsoft's Cloud-based storage service) nor to Office Online (the browser-based versions of Office).

Compare that to Office 365 Home or Office 365 Business which costs about $100 a year. That figure that won't change unless Microsoft change the price. You can't halve the cost by 'not upgrading' because, just like any other subscription (e.g. Netflix), once you stop paying you lose any entitlement to use it.

Although at face value it's a higher cost per year, you do get more for your money: 6 licences for the latest desktop version of Microsoft Office (PC and Mac), 1TB of file storage on OneDrive, access to Office Online and more.

For me, the biggest benefit of an Office 365 subscription is the regular updates. That is the carrot that Microsoft dangles in front of you to persuade you to purchase a subscription rather than a one-off.

Each month Microsoft release a new 'version' of the Office apps. The versions have numbers in the format of YYMM (e.g 1901 for January 2019). Each time a new version becomes available, you are prompted to download and install it.

Sometimes the new version contains bug fixes, but often it contains really useful and valuable new features. A few recent examples include:

• New functions such as TEXTJOIN and CONCAT
• New data types (stocks and geography)
• New types of charts
• The ability to deselect cells using CTRL
• An updated look and feel to The Ribbon

So to wrap up, when asked whether an Office 365 subscription is worth it, my answer is usually 'Yes' although of course your circumstances may dictate otherwise.