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?
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...
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.
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.
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...
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?