Latest News

Excel & Office 365 Custom Solution Advice

How To Partition your Mac Environment to Windows

Tuesday, June 14th, 2016 / by ExcelHelp

Partitioning a hard drive allows multiple operating systems to run on a single device. In order to partition a Mac to Windows, Boot Camp Assistant software is required which will provide Windows 7 software or later. 1. The first step requires a restart from your Mac’s normal startup disk. Once the Mac has restarted press […]

Read more

How Custom Excel Templates and Programming Can Improve Efficiency

Friday, June 3rd, 2016 / by ExcelHelp

Do you find yourself writing a letter to clients and/or customers that generally say the same thing? Think about it, how much more efficient would it be if you had a template on your desktop ready to open at a moment’s notice, and all you had to do is update the date, names, and addresses? […]

Read more

How to Automate Meeting Minutes Using Microsoft Excel and SharePoint

Friday, June 3rd, 2016 / by ExcelHelp

When thinking about meeting minutes, the idea of jotting them down in a blank Word document is probably what comes to most people’s minds first. While this seems like a reasonable method, it’s actually not even close to the best and most efficient way of recording meeting minutes so that they can eventually become tasks. […]

Read more

Excel Training in 2016

Thursday, May 26th, 2016 / by ExcelHelp

Usually there is a silent lament mixed with anticipated joy in the business industry when there’s an upgrade to the Microsoft Excel application. New software or an upgrade typically means that a change has been made to make your work life a little easier. However, the actual result can be of the contrary. Users have […]

Read more

Excel Help’s Bug Free Guarantee

Thursday, May 26th, 2016 / by ExcelHelp

We understand that adjusting to new software processes can be frustrating. While the end goal is to make your company’s daily work life quicker and more efficient, old habits have a tendency to stick around. That applies to navigating new software. Learning new processes can cause a few delays and may even appear to slow […]

Read more

Automating Construction Company Submittals (Construction Management)

Friday, April 22nd, 2016 / by ExcelHelp

Regardless of the field of construction, managing submittals for projects is a process which only grows in complexity as the number and value of projects increase. You may currently be able to manage your construction project submittals with a simple Excel workbook or a log in a Word document, maybe even on pen and paper […]

Read more

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

Bug Free Guarantee    Learn More