excel

Excel For Everyone: A Guide that doesn't call you a Dummy

Excel book

An Excel guide that teaches you to be an Excel guru instead of just throwing a bunch of geek-speak at you. This book is backed with over 20 years of Excel and data analysis experience in a wide field of industries. Written in a casual and entertaining style which readers of all levels can appreciate. This isn't your grandpa's Excel for dummies book!


Anyone who knows me, knows I made my living as an Excel geek. But now in my waning years I am returning to my first love; writing. While I've already written and published over 5 books (paperback, ebook, & audiobook), I wanted to write a book that kind of turns the page on my Excel guru days. But my book on Excel isn't a "for dummies" book, but rather it's for all the people who I've helped and who have supported me along the way in my "Excel life".

Read More

Excel Breakthroughs

Excel concepts that can improve your life...maybe.

Repeal and replace socialism

After 25+ years of developing Excel-based solutions, I've developed 3 workbooks that can really help in many industries. While I have primarily worked in the logistics industry, these workbooks can be applied to many other industries. The following is a description of these 3 workbooks. Let me know if you need further assistance. The 3 workbooks are contained in a compressed zip folder with no advertisements and no other files, such as viruses or spyware. The VBA code is all sheet-based and is completely viewable.

1. easycalc - Matrix-based calculator sheet used to calculate charges, rates.

2. importer_copier 20170614 - Duel-workbook importer/copier, data combiner.
3. Workbook-based Database Form 20170803 - Make a sheet-based form and pull/save data from/to another sheet.

Read More

Kutools vs XLSuperTool

Getting the most out of Excel. XLSuperTool vs Kutools

Excel Add-in

Kutools is an add-in for Microsoft Excel which gives Excel over 200 powerful new features like; real-time currency conversion, cell content comparison, in-cell data encryption and more. (Bail now if this sounds too nerdy) Kutools for Excel can be downloaded from its Chinese maker, ExtendOffice.com which offers the add-in for a free 60 day trial and $39.00 after.

XLSuperTool is NOT an add-in but a stand-alone workbook with over 50 powerful new features like; real-time currency conversion, cell content comparison, in-cell data encryption and more. (How’s that for unbiased comparison?) XLSuperTool was designed by RoderickE (me) over the course of 5 years, incorporating over 20 years of Excel use. It’s main features were developed to meet efficiency needs in the logistics/goods transportation industry, so many of the “tools” are geared for that. XLSuperTool can be downloaded from its USA maker, XLSuperTool for FREE for all time. Why? Because I don’t want to see people struggling with simple Excel processes. If you like the product, please consider thanking me here or by hiring me for larger projects here. Thanks

Read More

Copy Sheets From Source

Temporary holding place for Copy Sheets From Source

Read More
tag: 

Excel Help: Formulas and VBA

What if there was an Excel Tool that did most of the things you try to do each day? Comparing two columns to figure out which is different. Or close all your open workbooks, saving some and not others? How about increasing a range of cells by a certain percentage markup? Using my 20+ years with Excel proficiency I have developed a free Excel tool that I share with users. It's free because I want to help people who like me search for solutions from people rather than companies. You can get my XLSuperTool at this link. But what if you need more detailed help with your Excel spreadsheet or workbook project? I have helped people from all sorts of industries; Logistics, freight forwarding, banking and finance, personal fitness, warehousing, and sales. See experience. Since 2007, I have had a presence on MrExcel which is a very helpful forum for quick Excel-based questions.

Read More

Excel Charts to Pivot Tables

Ok, as you know you can double click a value on a pivot table to see the data details but what if you click on a chart?
Since it is a collection of all the data, you can’t see the data behind it, however this macro code will allow you to go to the pivot table driving the chart.

Read More

Excel as a Database

Excel as database

So you want to use Excel to act like a database, after all a database is mainly a list of lists right? Well, most databases such as SQL databases are very complex and almost convoluted in how they relate to data via primary keys and such. Did I lose you? Okay, then back to Excel, something you and I both can understand right? I've been using Excel for over 20 years and have now designed an easy to use process to make Excel behave like a simple database. Granted, this wasn't really feasible in the past as not until Excel version 2007 could you store more than 65,536 rows of data on each tab. Now you can store 1,048,576 rows. Now we're talking!!!

Read More

Sales Contact Database for Excel

This will allow you to easily keep a list of sales contacts as a long spreadsheet yet quickly display it in a printable format. FREE.

Read More

XLSUPERTOOL





The XLSUPERTOOL was developed following 20+ years of Microsoft Excel usage. The tool contains many useful functions and concepts not standard with Excel. The tool is designed for Stand-alone or Add-in use.
Version 20180828=Download zip file

CONCEPT RATIONALE

To allow for a portable stand-alone or a simple self-installing add-in that gives the user tools such as Excel bookmarks, multiple tab closer, tab divider and sorter and over 50 other tools in one place.

Read More

Simple-Quote

Have you ever wanted a real simple quote ability or quickly audit charges? This simple Excel form will allow you to do that. Simply, define your charge basis (such as per kg, per lbs, per hour -- whatever you need), then input the base charge and charge description and this form will automatically multiply the base charge by the charge basis amount!

This form is self-contained, small and ready to go. It comes with a 6 slide powerpoint to help you get started. The best part is, IT'S FREE! I only ask that you consider using my services for future projects you may have.

100% spyware free. The only code is easily viewed by right clicking the calc-template tab and select view code. There is no other hidden code.

Download zip file


UPDATED - Quote Database to save and recall quotes
Download zip file

Read More

My Excel Experience

I have been working with Microsoft Excel since as early as 1996 when I began using the spreadsheet application to track employee performance at a telephone company where I was the Training Supervisor. Like most people, at first I simply had a spreadsheet with names, numbers and comments but as the data grew, analyzing the data was more important than storing it. With over 1000 employees among 3 call centers, this was going to require more than a simple knowledge of =sum(). I created detailed pivot tables and eventually VBA macros to analyze all the data. This was all self-taught due to the expense of the training at that time.

Since those early days, I've been employed at several businesses where these Excel skills have been needed. This includes years spent at various transportation/logistics companies developing ratesheet calculators, transit time studies, and general reports. I've also spent a fair amount of time doing side jobs for people involved in banking, publishing, appliance manufacturing, and general assembly. All of these things have challenged and grown my skills with Excel.

WHY EXCEL

Sometimes I'm asked why I prefer to develop these tools in Excel rather than Microsoft Access or something more robust like SQL. Well, first most business people are familiar with basic Excel use on a daily basis. Spreadsheets dominate the data and information dissemination process at most companies. Bottom line; it is easy for people to use. There is typically no need to train them on the basic operation. I can create a more functional, behind the scenes macro that will simply interact with tasks the person is already doing with their spreadsheets.

Read More
Subscribe to RSS - excel