Designing Better Spreadsheets in Excel – Excel Tips & Tricks

In this 1-hour class, we look at several excellent Excel tips and tricks to help you design your spreadsheets in the right way. Good spreadsheet design is essential if your Excel workbooks are going to be used by multiple people.

Once again, this class was presented by the excellent Deborah Ashby for Simon Sez IT and features a host of Excel tips, tricks, and techniques aimed at making you a spreadsheet superstar.

• In this class, we teach you:
• How to layout your spreadsheet
• How to use summary sheets to direct users to the right areas of a workbook
• Cell styles and formatting in Excel
• Adding controls via Data Validation (Dropdown lists!) in Excel
• How to protect an Excel workbook or worksheet
• Using version control and setting up a version control system in Excel

Download the Excel file used by Debs and follow along.

If you are interested in learning more from Simon Sez IT, you can sign up and receive FOUR FREE COURSES HERE.

Other Excel classes you might like:

• Logical Functions in Excel
• What-If Analysis in Excel
• Introduction to Power Pivot & Power Query in Excel

Adam Lacey

Adam Lacey is an Excel enthusiast and online learning expert. He combines these two passions at Simon Sez IT where he wears a number of different hats. When Adam isn't fretting about site traffic or Pivot Tables, you'll find him on the tennis court or in the kitchen cooking up a storm.