800-682-0882

Latest News

Excel & Office 365 Custom Solution Advice

Microsoft Excel Custom Solutions for Creditworthiness & Banking

Friday, April 22nd, 2016 / by ExcelHelp

ESOFTWARE ASSOCIATES INC d/b/a ExcelHelp.com, a custom Microsoft consulting company based in New York City recently launched their latest Excel application, Credit Worthiness Survey System at the Municipal Finance and Creditworthiness Academy seminar in Ankara, Turkey this month. According to ESOFTWARE’s Executive Director, Russell Kommer, World Bank contracted their services to customize an Excel based, […]

Read more

Utilizing the Immediate Window

Tuesday, March 15th, 2016 / by ExcelHelp

Utilizing the Immediate Window The immediate window is a console of sorts that allows the user to enter VBA code that can be directly evaluated or executed during the development or debugging process. It is useful for checking values and states at various points in the execution of a routine. It can also be used […]

Read more

Tips and Tricks using VLOOKUP

Friday, February 19th, 2016 / by ExcelHelp

The VLOOKUP function is one of the staple functions that Microsoft Excel users rely upon for finding values in a table. With the VLOOKUP function, a value can be looked up in the leftmost column and a related value can be returned from another column. The Syntax for VLOOKUP is VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup]) Lookup […]

Read more

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

Bug Free Guarantee    Learn More