Course Description

This is a private course for students who've already completed Excel Beginner training with Danielle. If you'd like to organise onsite training for your staff - contact us here: [email protected]

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

    Exploring Excel

    • Starting Excel from the Desktop

    • Screen Elements

    • The Excel Ribbon

    • The QAT (Quick Access Toolbar)

    • Right Click Menu

    • Excel Options

    • Creating New Workbooks

    • Saving a Workbook

    • Opening a Workbook

    • Pop Quiz: How much do you know about Excel Screen Elements and Menus?
  • 2

    Creating Formulas

    • Simple Functions (Auto Sum)

    • Mathematical Operators

    • Comparison Operators

    • More Complex Functions (The Function Builder)

    • Order of Operations (BODMAS)
  • 3

    Fill Techniques

    • The Fill Handle

    • Fill a Series

    • Built in & Custom Fill Lists

    • Flash Fill
  • 4

    Working with Data

    • Resizing Column Widths

    • Resizing Row Heights

    • Hiding and Unhiding Columns

    • Hiding and Unhiding Rows

    • Navigating a Range of Data

    • Navigating Large Data Ranges

    • Basic Number Formatting