Excel on YouTubeExcel Class NYC Faceook PageExcel Class on LinkedInExcel Class on TwitterExcel Class on YelpExcel on BloggerExcel on Wordpress

Tag: Excel Training

SumProduct Function Applications

SumProduct Function Applications When teaching Excel classes students occasionally ask about the SumProduct function. There are many aspects of SumProduct that mirror the SumIfs functions capabilities but SumProduct can produce different answers when combined with the unary operator. This tutorial is not meant to be a thorough discussion of SumProduct but is meant to provide …

Continue reading

PEMDAS and the Mathematical Order of Operations with Microsoft Excel

Microsoft Excel works similarly to using a calculator but there are important differences. On a calculator to perform a calculation you might type numbers, then math symbols like plus (+) or minus (-) and then you would press the equal key to complete your calculation. In Excel we don’t end with the equal sign, we …

Continue reading

Excel VBA Tutorial: Learn To Use VBA To Overcome Macro Recorder Limitations

Reposted from http://www.vbaclass.com/blog/excel-vba-tutorial-learn-to-use-vba-to-overcome-macro-recorder-limitations/ If you record a macro where you sort your data, the macro records the last contiguous row in the data set. Next time you run the macro, if you have more rows of data the recorded macro wont correctly sort to the new last row. Also, anytime you record a macro to …

Continue reading

Excel Class Favorite Keyboard Shortcuts To Help You Save Time With Microsoft Excel

Excel class shares some of our favorite Excel keyboard shortcut techniques. Our list is not exhaustive, but we believe it offers some of the most common and frequently used shortcuts to save you substantial time and effort when using Microsoft Excel.

Excel Class NYC – Free Excel Training Tutorial – Excel Text Functions

Excel Class nyc offers a free excel training blog tutorial post. This Excel Class Blog is part I of a three part series of Excel training about text functions.

Excel Training NYC Blog – Learn Microsoft Excel Paste Special – Free Excel Tutorial

Excel Training NYC offers a free Excel tutorial on Microsoft Excel’s Paste Special feature. Study our practice workbook, then take a short test.

Excel Class Training NYC Blog – Learn To Use 3-Dimensional Formulas To Consolidate Data

Excel Class NYC Training Blog offers free Microsoft Excel Tutorial on 3-Dimensional Functions. Download the practice test to see if you can master data consolidation with Microsoft Excel.