MM0006 - 06/01/20 - Planning Your Excel Project

In this stream, we explore five things to think about at the beginning of an Excel project.  I apply these things to a member file, live, to show you my thought process.  Hopefully it will save you time, frustration, and allow you to build more powerful Excel applications.

Topics

  •  | Why You Need To Plan Your Excel Project
  •  | Define The Purpose Of An Excel Application
  •  | The Different Types Of Excel Application
  •  | Discussion Of Different Data Input Approaches
  •  | Different Sheet Roles In Excel
  •  | How To Create A Structural Diagram
  •  | Discussion Of Pros And Cons Of VBA
  •  | Should You Use Excel For This Project?
  •  | Do I Need a Welcome Sheet?
  •  | Spreadsheet Real Estate!
  •  | Formatting For Data Input
  •  | Assumptions About User Excel Level
  •  | Quickly Format A Worksheet
  •  | Use Of Spacer Rows
  •  | Worksheet Setup For Custom Navigation System
  •  | How To Establish Data Quality
1 Lesson