Latest News

Excel & Office 365 Custom Solution Advice

Using Cell References and Named Ranges

Imagine that you’re 12 worksheets into a financial plan and you need to sum all the subtotals from each worksheet. The thought of creating some long formula that will probably need to be changed later may make you cringe. You know there must be an easier way to do this and, fortunately for you, there […]

Read more

Games in Excel?

Excel is a spreadsheet. At least that is the extent many users get with Excel. It is capable of so much more. Rather than organize customers and accounts, you can organize map locations, health, damage, locations and other parameters that games must manage as well. It can be taken even farther and build the games […]

Read more

Top 10 Reasons to Use Access with Excel

Microsoft Access with Excel

One is a database. One is a spreadsheet. However, Microsoft Access and Microsoft Excel go together like spaghetti and meatballs or ice cream and hot fudge. They serve different purposes, but together they create something extremely useful. Common uses of Excel: data analysis for calculations/statistical comparisons to make charts Common uses of Access: data management […]

Read more

Which add-ins are the most beneficial for Excel?

Excel Add ins 2013

Many companies have started using tablets to complete their daily tasks. They’re mobile, they’re light, and they’re slim to carry. When work becomes mobile, it is helpful to have a device that can travel too. I rode along with a wireless provider salesman once and his job greatly relied on being able to carry around […]

Read more

How to Go Paperless with Excel

Going paperless. A modern idea. One that many businesses throw around as a future intention. What happens when you or your company actually decides to follow through, however? It might feel overwhelming to turn the idea of a paperless office into a reality. All those filing cabinets that need to be converted to a digital […]

Read more

Could Excel Help Get You Noticed At Work?

A world without computers. Seems as prehistoric as living without a written language, even if the rise of the machine is fairly modern. Computers make our lives easier – mostly by providing needed information quickly and accurately. Excel seems to make life easier too. Would it surprise you to know that about 90% of businesses […]

Read more

How To Use Excel for (Almost) Everything

There are 1,048,576 rows by 16,384 columns in a single worksheet. The total number of characters that one cell can contain is 32,767. There are 16 million colors to choose from in a workbook. The most limiting aspect of Excel is the available memory on a computer, something the system has no control over. With […]

Read more

What is Microsoft Sway

sway-grid-card

Do you use Office 365 in your business? Now might be the time to either start, or to consult with an expert on how best to use the “anywhere, anytime, on any device” system. Why?  Office 365, Microsoft’s cloud-based version of the Office software, has a whole set of features that cater to business needs: […]

Read more

Updates to Power Query that Will Enhance Excel

As part of the Microsoft Power BI suite, Power Query–an add-in for Excel 2010 and Excel 2013–expands Excel’s features with extended data analytics capabilities and the ability to extract and manipulate data from a variety of sources. These additions supercharge spreadsheets and worksheets, coupling standard Excel operations and features like calculations, formulas, graphing tools, and […]

Read more

The Next Big Thing: Mobility for Microsoft Office 2016

Big things are in store for the next version of Microsoft Office 2016. They just recently released their plans to introduce both a new operating system and Universal Office apps for Windows 10. These apps include Word, Excel, PowerPoint, Outlook and OneNote, all of which can be installed and run on PCs, tablets and phones. […]

Read more