Excel 2016 Chronicles – Vol. I
To say the least there is a little anxiety with learning, experiencing[...]
Read more...
Home /Category
Category
Getting a Count Using Subtotal
This short video shows you how to quickly get a count by[...]
Read more...The New Age of PDF Conversion – PDFConverter Elite 4
Sometime ago a colleague had asked me how to convert PDF documents[...]
Read more...The Excel Lab – 10/24/15
EVENT DESCRIPTION On Saturday, September 19th at the Brooklyn Public[...]
Read more...How to Beginners Excel Guide
If you're unfamiliar with Excel it's often difficult to know where to[...]
Read more...Cutting Audit Sampling Risk Down to Size: Automating the Sampling Process
Every Accountant professional at some point must take a sample. Sampling is[...]
Read more...Sorting by Columns
Very often when people sort things in Excel they sort rows. Here[...]
Read more...Video: 3D Formulas
If you've ever had to link multiple spreadsheets you known it can[...]
Read more...Never Update the Pivot Table Source Range Again
Pivot tables are one of the most helpful tools in Microsoft Excel. [...]
Read more...The Excel Rosetta Stone – Decoding Complex Excel Functions and Formulas
Recently, I’ve been getting quite a few questions about ways to understand[...]
Read more...