XFER Blog

Microsoft Excel is a powerful tool for organizing and analyzing data, and its ceiling for mastery is incredibly high. Thankfully, you don’t need to know every little thing about Excel to get value out of it, and thanks to built-in features like Auto Filter, you can still get plenty of value out of it even if you’re not a power user. Let’s go over how you can use Auto Filter to more effectively navigate spreadsheets filled with data.

Microsoft Excel is an amazing tool that gives you a ton of power over your spreadsheets and the data contained within, but the default size of each cell is a bit… small. You can adjust the size of these cells to suit your needs by adjusting the width and height of each column and row. Better yet, you can easily do it all at the same time without resizing each individual cell. Here’s how it’s done.

Collaboration is a key component of a successful business model, and with so many cloud solutions offering the ability to collaborate in real-time, it’s easy to forget about the old tried-and-true desktop solutions as productivity platforms. Sure, you can see changes in real-time in the cloud-based version of Excel, but did you know that you can also see changes made in a spreadsheet over a period of time in the app itself?

How much do you know about Microsoft Excel? There are loads of features that most users aren’t aware of, one of which is the ability to remove duplicate values in columns. Let’s walk you through this process so you can more easily compare data sets between two or more columns within your spreadsheets.

When it comes to making a spreadsheet, Microsoft Excel is the go-to program for many users. However, many of these users spend much more time creating and formatting these spreadsheets than they have to. For today’s tip, we’ll outline some experience-improving shortcuts that can improve how you use Excel.

Many office workers feel like they live in Microsoft Excel, spending hours using spreadsheets to enter data and crunch numbers. By taking advantage of tools like Excel’s freeze feature, workers can make the most of their time by navigating a spreadsheet more efficiently.

It can be difficult to keep track of your budget and expenses, especially when prices and needs are always changing. But perhaps the biggest annoyance is the intense paper trail that you leave behind when building your budget. By taking advantage of Microsoft Excel's formulas, you can easily keep track of your budget and alter it as prices change and demand increases.

When you need to make your point in a big way, you can make a sharp looking graph. You may think that graph making is difficult, but thanks to tools like Microsoft Excel, creating a convincing chart is as easy as pie! To help you out, we'll walk you through how to make a graph in Microsoft Excel.

Collaborating with a team to complete a project helps everything go smoothly. Although, poor communication and mistakes can actually make the project drag on. Passing on a Microsoft Excel workbook from one employee to another is an example where communicating all the details can help. Here are three important steps to take when inheriting an Excel workbook

Does it feel like your new Windows 8 OS is missing something? It might be because Microsoft Office 365 is not out yet; it is scheduled to be released Q1 of 2013. The updated Office applications have been overhauled to flow with Windows 8, and we want highlight five of these new features found specifically in Excel 2013.