212-828-7089

google placesyoutube

cart

excel class training

212-828-7089

excel class training

Author: admin

Excel New Features Class Helps Users Master Excel Enhancements

Excel Class NYC Launches Excel New Features Class to Help Users Master Excel 365 Learn to create dynamic reports with our exclusive training: Excel New Features. Learn functions like Xlookup, GroupBy, PivotBy and more! Excel Class NYC is pleased to announce the launch of its newest class: “Excel New Features”, a specialized class designed to […]

New Video Release: Master Important Excel Power Query Editor Skills

New Video Release: Master Important Excel Power Query Editor Skills If you’ve ever found yourself buried under messy spreadsheets, spending far too much time cleaning, transforming, and organizing data, you’re not alone. That’s exactly why I’m excited to announce the release of my new demonstration video covering the most important Excel Power Query Editor topics […]

Excel UDF Calls A Macro To Change A Value In Another Cell

Wishful Thinking: Update The Website With Accurate Information Update: November 23rd, 2020: Instead of acknowledging the problem and fixing the incorrect information, in typical Microsoft fashion, the link below on Microsoft’s website now produces a 404 error page, which is why I created a PDF as proof the page existed. It’d be nice if they […]

Excel Class Launches Online VBA Training

Excel Class receives requests for Microsoft Excel VBA training courses from every corner of the country. We are pleased to announce that our new exclusive series: The Excel VBA webinar is now available online. Our training sessions begin once a month at different start times. Each session lasts two hours and includes no less than […]

Report Hidden Rows With An Excel VBA Macro

Report Hidden Rows With An Excel VBA Macro Many Excel users choose to hide a row of data on a worksheet for a variety of reasons. When Excel users collaborate it’s difficult to know that a row has been hidden without careful visual inspection of every row. If a hidden row contains zero values there […]

Two Criteria Lookups

Two Criteria Lookups In the process of teaching Excel over the past 20 years I have found that most students are often shocked and unaware that Vlookup and Index/Match can only locate the first item in a list. They find this unacceptable and I would tend to agree. When a value repeats in many rows, […]

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 […]

Data Tables And Interactive Charts

The Excel Class blog provides an opportunity to supplement the material we teach in our class. This tutorial assumes our readers are familiar with named ranges. (See: Advanced Excel Class) Excel’s data table feature is a what-if analysis tool that allows users to create tables (rows/columns) of results based on a one or two variable […]

Excel Tutorial – Vlookup Multiple Columns To The Right With An Array Formula

In the process of teaching Excel classes, many students ask: How can I write a single vlookup function that returns multiple values to the right, instead of a single value, which causes me to write many vlookup functions in many columns. This tutorial does not teach vlookup, that feature is taught in the Introduction and […]

Excel Class VBA Macro Adds IfError Functions To Every Formula

Excel Class VBA Macro Adds IfError Functions To Every Formula Today a student asked Excel Class if there was a macro to automatically add an IfError function to every formula on every sheet in a selected workbook, assuming there was not already an IfError function used. On short notice the Excel Class instructor provided the […]

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 begin […]

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 […]

Excel Class Free VBA Tutorial – Variables

Few things in life are constant. Heraclitus said: The only thing constant is change. Change is constant and variables are used to capture change. In the context of Excel, the names of workbooks change, the number of workbooks you have open is variable, the number of sheets, pivot tables and charts is usually variable, the name of sheets is variable, the values in cells are variable, and on, and on.

Excel VBA Class Announces East Coast Schedule For Q1 2011

Excel Class is pleased to announce our Q1 2011 Excel VBA Classes schedule. Philadelphia, PA February 16th – 18th – Register Here Boston, MA February 23rd – 25th – Register Here Baltimore, MD March 1st – 3rd – Register Here Miami, FL March 7th – 9th – Register Here Atlanta, GA March 16th – 18th […]