Web Analytics Made Easy -
StatCounter

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.

 

 

January 28, 2015

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

 

 

 

 

Click here to view this document.

 

 

January 23, 2015

 

Well, it's my "Thank You" for visiting my site.  Periodically, I will be updating this page with new, interesting, and relevant information, articles, and ideas concerning Excel.  I think you will find them of use.

 

In some cases, the posts are my own creation; in others, information presented may be based from other websites (with the link to that website/page fully shown.)  Obviously, anyone can do their own search on any Excel topic and find a ton of hits.  But the information I'...

January 21, 2015

This is where I'm going to post FREE STUFF, so please check back occasionally since I'll be periodically updating this and adding NEW Free Stuff that may very well be interesting and relevant to YOU and/or your organization!

 

Please reload

Featured Posts

Welcome to my Blog !

January 21, 2015

1/1
Please reload

Recent Posts

May 24, 2020

February 2, 2015

Please reload

Archive
Please reload

Search By Tags
Please reload

Follow Us
  • Facebook Basic Square
  • Twitter Basic Square
  • Google+ Basic Square

©  JKJL Enterprises  1996-2020

  • Al's Facebook page
  • Al's YouTube channel
  • Al's Pinterest boards
  • Al's Instagram