JKJL EXCEL SOLUTIONS

Excel is everywhere; most everybody knows it to some degree. Power BI is not everywhere (yet), but you've heard good things about it. How do you decide which meets your needs best? If you work with large volumes of data that come from a variety of sources, and you need to analyze the data by creating understandable and dynamic data visuals that need to be shared within your organization, your needs might be better served with Power BI. On the other hand, if you work with lots

There's no shortage of Excel critics; after all, Excel's been around since 1987. Let's face it...some think Excel is too complicated, too confusing; a spreadsheet full of numbers makes your eyes bleed; IF-THEN-ELSE statements are maddening; XLOOKUP/VLOOKUP ? Fuggedaboutit. Macros? OMG. What about charts - so much maintenance! And how about simple copy-and-paste? What the **** are those dollar signs all about ?? Click the gravestone to read more about why those critics

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

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

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

Most Excel users are self-taught and almost anyone can consider themselves an expert. However, as Excel is ubiquitous in business, there...

Excel version 2013 was released in early 2013 and requires Windows 7 or later. Companies and individuals usually take their time before...

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

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

This PDF e-book by the respected sites ExcelForum.com and ExcelTip.com, explains 10 popular Excel tricks that users can employ right...

Well, it's my "Thank You" for visiting my site. Periodically, I will be updating this page with new, interesting, and relevant...