JKJL EXCEL SOLUTIONS

25 Years of Excelling Smarter, Not Harder: How Al Baker Helps Clients Learn, Improve, & Have Fun with Spreadsheets

Have a spreadsheet project but you don't have Excel? You've heard of Google Sheets but haven't used it yet. A colleague uses Excel and it seems a little overwhelming. Can Sheets do everything that Excel can do? Will Sheets handle your project ? How does Sheets stack up to Excel? And what about Excel-for-the-Web? OMG - what to DO? This guide helps you decide!

Profile of JKJL Excel Services and its CEO/Founder, Al Baker

Excel is everywhere; most everybody knows it to some degree.
Power BI is not everywhere (yet), but if you need to communicate your data analyses via dazzling charts and other visualization tools, you will want to take a look at Power BI. For data visualizations, Power BI is more robust and easier to use than Excel.

Excel's been around since 1987 - some are asking if it isn't time to say BUH-BYE to the Spreadsheet.
The easy answer is ... NO WAY.

This is a concise and up-to-date (as of March 2025) list of the 10 best Excel tips.

Most Excel users are self-taught and almost anyone can consider themselves an expert once they've used it for awhile. However, a common problem many have with Excel is that Excel's best feature is also its worst - EASE-OF-USE. Since Excel is so relatively easy to use, it's also easy to make mistakes. Following these "Best Practices" can help users avoid these problems.

After many years of working with people who use Excel, I came to realize what they tend to want MOST so I created a series of the top Tips, Tricks, and Techniques in Excel that are used by real people in real business situations. This is NOT for astro-physicists or finance Ph.Ds.

Dashboards are very desirable when users need to gain business intelligence and insights about their data such as KPIs, trends, outliers, anamolies, and other performance metrics. The problem is that some dashboards, while pretty and sophisticated-looking, are just too complicated.

There are a few nice tidbits for Excel users in Office 2019, but don’t expect anything dramatic. Excel 2019 was the last major version release prior to Excel/Microsoft 365.

If you need to lookup information from a list or table, you will love either VLOOKUP or XLOOKUP. Which one to choose? If you have Excel 365, there is no contest. This document will explain why and how the function works.

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 users encounter. BUT admittedly, it's not the friendliest function in Excel to learn or use. This post will FIX all that.

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