Legend Consulting Group

Legend Consulting Group All things Microsoft Office

Getting back into the swing of Excel & it's many applications.  Here's something awesome coming down the pike...
02/28/2021

Getting back into the swing of Excel & it's many applications. Here's something awesome coming down the pike...

Brand new in Excel for 2021 - LAMBDA is the most powerful function ever. LAMBDA lets you create your own functions and use them throughout a spreadsheet. B...

Came across this tidbit by chance.  If you work with charts, this is phenomenal.
05/09/2020

Came across this tidbit by chance. If you work with charts, this is phenomenal.

Mini charts are a great alternative to Sparklines. They’re just regular charts made really small. Download the Excel workbook here: https://www.myonlinetrain...

The mathematics of the game of Monopoly...
02/01/2020

The mathematics of the game of Monopoly...

Walter Hickey / BI Monopoly is one of the classic American games.  It's played among close friends, loved ones, and trusted business partners.  It's also one of the few times in life where it's perfectly acceptable to want to systematically annihilate and crush the aforementioned friends, loved on...

When you're using Timer near midnight...
09/05/2019

When you're using Timer near midnight...

The basic and classic and most popular mode to time your code is achieved through Timer function which is natively supplied by VBA. It returns a Single representing the number of seconds elapsed since midnight. Hence, your code will look like following when you want to measure the time and it gives....

https://www.engineerexcel.com/inverse-tangent-excel-atan-atan2/
08/19/2019

https://www.engineerexcel.com/inverse-tangent-excel-atan-atan2/

There are two functions for calculating the inverse tangent or arctan in Excel. These two functions are ATAN and ATAN2 (“atan” is short for arctangent), and they each have specific uses depending on the desired results that you’d like to obtain and the inputs available. In general, I’d recom...

Not sure if this video has a shelf life, so review it while you can...
08/14/2019

Not sure if this video has a shelf life, so review it while you can...

In this video I am going to take an Excel Macro and make it run 1000x faster. The code I'm using is a standard code you will see in the real-world. This code...

When you need to manage files & folders with VBA...
08/03/2019

When you need to manage files & folders with VBA...

VBA FileSystemObject provides an easy object based model to access computer’s file system with this you can create, read, delete, iterate files & folders.

Be careful with liberal use of conditional formatting...
07/22/2019

Be careful with liberal use of conditional formatting...

Patrick wanted to know if I had any information on Conditional Format calculation and performance, and I have not looked at it for several years, so here goes! I have done a series of experiments,…

Address

New York, NY

Telephone

(917) 526-2694

Website

Alerts

Be the first to know and let us send you an email when Legend Consulting Group posts news and promotions. Your email address will not be used for any other purpose, and you can unsubscribe at any time.

Share