Tip 020
Office 2007

What you will learn
  • A celebrations and birthday calendar.

Tip 019 – Part 2
Office 2007

What you will learn
  • Copying imported data (from column to row) of another sheet by using an array formula.
  • Compare data using an array formula.
  • Profit searching through an array formula.
  • Refresh Data
  • Method 1 self refresh:
  • Method 2 Automatic refresh: