INDEX, MATCH & VLOOKUP
Friday, January 29th, 2016 / by ExcelHelp
Excel users frequently have a need to lookup data in one spreadsheet and use it in another. To make this job easier, Excel offers built in functions for finding information: INDEX, MATCH, and VLOOKUP. The advantages and disadvantages of these functions are presented below. INDEX INDEX returns a value from a range or an array […]
Read More
Excel and SharePoint Solutions
Thursday, December 17th, 2015 / by ExcelHelp
With advances in both Excel and SharePoint , it is now possible to create solutions that leverage SharePoint’s hosting and security features along with Excel’s powerful calculation engine, pivot tables, and charting capabilities. When SharePoint is used as a central repository for lists, multiple users throughout the organization can have permissions to access those lists […]
Read More
Using Cell References and Named Ranges
Friday, October 2nd, 2015 / by ExcelHelp
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?
Monday, September 14th, 2015 / by ExcelHelp
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
Tuesday, July 21st, 2015 / by ExcelHelp
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?
Thursday, July 16th, 2015 / by ExcelHelp
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
Tuesday, July 7th, 2015 / by ExcelHelp
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
How To Use Excel for (Almost) Everything
Thursday, June 25th, 2015 / by ExcelHelp
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
Tuesday, June 23rd, 2015 / by ExcelHelp
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
Top 5 Uses of PowerPivot in Excel 2013
Tuesday, December 30th, 2014 / by ExcelHelp
The average management position has become as numbers-driven as finance. Big data is driving more decisions in strategy and development at every level. As a result, Microsoft has been enhancing Excel software to make it more of a data analysis tool for managers who aren’t techies. PowerPivot, one of the most popular add-ons over the […]
Read More