Course Description

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

    • Getting Started
  • 2

    Data Manipulation Techniques

    • The Fill Handle

    • Fill a Series

    • Custom Fill Lists

    • Flash Fill

    • Data Manipulation Formulas
  • 3

    Calculation Techniques

    • Simple Functions (Auto Sum)

    • Mathematical Operators

    • Comparison Operators

    • More Complex Functions (The Function Builder)

    • Order of Operations (BODMAS)
  • 4

    Formula Referencing

    • Relative Referencing

    • Absolute Referencing

    • Mixed Referencing
  • 5

    Lookup Functions

    • VLOOKUP Introduction

    • VLOOKUP

    • INDEX & MATCH Introduction

    • INDEX

    • MATCH (Row)

    • MATCH (Column)

    • Nesting MATCH in INDEX
  • 6

    Logical Formulas

    • Comparison Operators

    • Combining Comparison Operators

    • AND

    • OR

    • IF

    • Combining AND & OR Functions

    • Combining IF & AND

    • Combining IF & OR
  • 7

    Defined Names

    • Creating Named Cells

    • Creating Named Ranges

    • Scoping Names

    • Dynamic Named Ranges
  • 8

    Conditional Formatting

    • Highlight Cell Rules

    • Top & Bottom Rules

    • Icon Sets

    • Format with a Formula
  • 9

    Sorting & Filtering

    • Navigating Spreadsheets

    • Basic Sort

    • Multi-level Sort

    • Applying a Filter

    • Filtering Specific Items

    • Compound Filters

    • Subtotalling
  • 10

    Pivot Tables

    • Creating a Pivot Table

    • Pivot Table Design Options

    • Pivot Table Number Formatting

    • Calculating Items

    • Filters & Slicers

    • Updating Pivot Table Data

    • Timelines
  • 11

    Charting

    • Create a Chart

    • Customising Chart Elements

    • Modifying Clustered Column Charts

    • Creating a Combination Chart

    • Creating a 100% Stacked Column
  • 12

    Data Linking

    • Linking Cells witin a Worksheet

    • Link Cells Between Worksheets

    • Link to Cells in External Workbooks

    • Creating Links between Applications
  • 13

    Intro to Macros

    • Security Settings

    • Saving a Workbook as Macro Enabled

    • Recording a Macro

    • Reviewing the Code

    • Filtering, Copying and Creating New Sheets

    • Working with Variables and Inputboxes

    • Programming a Loop

    • Command Buttons

    • Ribbon Buttons and Tabs