Course Description

This course is for Excellers who create spreadsheets for themselves or other people to enter into. I't about specifying rules to determine what can and can't be entered in cells, in order to simplify data entry and ensure that only the correct information is being recorded.

Pre-enrol for the course today and you'll get full access when it goes live :)

Danielle O'Connell | Spreadsheet Designer

Hi there ... I'm Danielle,  - but you may call me Dani (like my friends do)As a full-time spreadsheet designer and Excel trainer - I get to spend my days helping other people streamline and simplify their repetitive data processing. In my Excel courses, I've included all of the best tricks, shortcuts and Excel secrets that I've learnt over the years that have saved me bucket loads of time, because my goal now is to help you overcome tedious and boring Excel tasks too.As you can see, Excel isn't just my job - it's my life.I can't wait to help you stop wasting your life on tedious, boring, monotonous tasks too.Cheers!Dani

Course curriculum

  • 1

    Welcome

    • How to Use the Training Portal

    • What we'll Cover
  • 2

    Drop Down Lists

    • Select from a list of items

    • Set the list source to a range of cells

    • Create a dynamic source range that's dependent on another cell
  • 3

    Allowing Entry of Numbers Only

    • Restrict cell entry to whole numbers or decimal numbers that meet specific criteria

    • Use a formula to determine whether the number entered is allowed
  • 4

    Allowing Only Dates

    • Allow entry of dates only within a specified period

    • Create a formula that determines the allowable dates
  • 5

    Text Length

    • Rules to Require Text of Specific Length

    • BSB & Account Number
  • 6

    Design Custom Data Validation Rules

    • Contains Specific Text

    • Doesn't Already Exist (check for duplicates)