Excel Power User Tips

Do you work with or create your own spreadsheets in your company?  Want to take your spreadsheets a little further for ease of use, efficiency, layout and capabilities?  Try some of these tips.  You can also learn more in the book Super Excel for Dealership Management.

Make more room in your Excel charts

Concatenation magic with the name file

Create your own Excel functions

Check for leap year

Saving Excel workbooks by date

Thermometer-style bar charts  - NEW!  UPDATED!

Add a custom button to Excel

Getting the right percentage