May 24, 2020

Excel's been around since 1987 - isn't it time to say BUH-BYE to the Spreadsheet ?  Good riddance Excel !

I mean let's face it...Excel is too complicated, it's confusing, it's hard to look at all those numbers, IF-THEN-ELSE statements are maddening; and what about VLOOKUP - Fuggedaboutit.  Besides, there are all those other tools out there that make ilfe so much easier for finance-types, number-crunchers, and anyone who needs to organize stuff, right?  

Ever try to do a macro?...

May 18, 2020

After many years of working with people who use Excel, I came to realize what they tend to want MOST so I created a special workbook entitled "Excel for Non-Dummies" (a take-off of the popular book series.) 

I started putting in separate worksheets, each sheet carefully detailing a specific, relevant TIP, TRICK, or TECHNIQUE (TTT's.)  What began with just a few worksheets has grown over the years to well over 100 sheets.  An easy-to-navigate series of menus makes it very easy for the user...

March 9, 2019

There are a few nice tidbits for Excel users in Office 2019, but don’t expect anything dramatic. Excel’s new features focus primarily on data analysis, including funnel charts and 2D maps, new functions and connectors, the ability to publish from Excel to PowerBI, and enhancements to PowerPivot and PowerQuery.

Click the icon at left to read the full document.

December 4, 2018

If your organization has upgraded to Office 2016 or Office 365, you now have access to Excel 2016. Now what? Are there any new features? The answer is yes, especially if you need business intelligence tools and new ways to present your data.

Click the icon at left to read the full document.

June 8, 2016

Most Excel users are self-taught and almost anyone can consider themselves an expert.  However, as Excel is ubiquitous in business, there is a good chance for errors, problems, and frustration among worksheet builders, owners, and their intended audience. 

 

Studies have shown an alarming percentage of Excel work contains material error.  Most spreadsheets have poor foundations and limited life spans.

 

This document offers some suggestions for "Best Practices" that can help alleviate t...

May 14, 2016

Excel version 2013 was released in early 2013 and requires Windows 7 or later.  Companies and individuals usually take their time before moving up to the new release.  

 

Now that it's years later, most users are still with versions 2007 or 2010.  However, it's useful to know what the significant new features are with this upgraded version.

 

PCWorld magazine has a very good article on those new features.

 

Click here to view the document.

 

 

February 2, 2015

VLOOKUP is one of the most commonly-used functions by all users no matter how long they've used Excel.

 

 

It's often the first "power" function that newer users want to learn once they've been through the basics of Excel.  

This document will guide you through the complete use of VLOOKUP,

how to use it and when,

with fully documented examples.

 

Ever search through YouTube for tutorials on using VLOOKUP?  They're awful !

Instead, click here to view this document - you'll LIKE it.

 

February 1, 2015

 

 

Dashboards used to be the "In" thing in business.  Everybody either had them or wanted them.  But they've seemed to die down the last few years.  Why is that?  After all, dashboards are supposed to make deciphering lots of data much easier, right?  Dashboards look cool, even pretty, and you can build them in Excel, so what's the problem?

 

Click here to view the document.