iTandCoffee | Patient help with your personal and business technology
  • Home
  • About Us
  • Classes
  • Appointments
  • Guides | Videos | Tips
    • Guides
    • Videos
    • Newsletter
    • Tips Library
  • Gift Vouchers
  • iTandCoffee Club
    • About the Club
    • Membership Options
    • Members Area
  • Contact
  • Video - Tech Org and Safety Tips
  • Home
  • About Us
  • Classes
  • Appointments
  • Guides | Videos | Tips
    • Guides
    • Videos
    • Newsletter
    • Tips Library
  • Gift Vouchers
  • iTandCoffee Club
    • About the Club
    • Membership Options
    • Members Area
  • Contact
  • Video - Tech Org and Safety Tips
Search by typing & pressing enter

YOUR CART

  • Store
  • >
  • Boot Camps
  • >
  • Boot Camp Slideshows
  • >
  • Boot Camp Slideshows - Microsoft Excel
  • >
  • Microsoft Excel Boot Camp (Part 5): Data validation and Formulae - PDF of Slideshow

Microsoft Excel Boot Camp (Part 5): Data validation and Formulae - PDF of Slideshow

SKU:
A$8.00
A$8.00
Unavailable
per item
Add to Cart

This PDF contains the slides from the 5th part of the Boot Camp series about Microsoft Excel (see www.itandcoffee.com.au/microsoft365-classes for more details about these Boot Camps).


In part 5 of the Microsoft Excel Boot Camp, we focus in this part on using Formulae in your workbook – looking at some of the more common formulae that relate to data in a single worksheet, and across multiple worksheets.


We also look at how to set up data validations, which can help with data entry and consistency – setting up a ‘pick list’ of values and how this can ensure entered data is limited to this list.

  • Facebook
  • Twitter
  • Google+
27 Sycamore St, Camberwell, Victoria Australia

​​Call 1300 885 420

​to book an appointment or class, or to enquire about our services and products


Seniors Card Welcome
SENIORS CARD WELCOME HERE:
Seniors Card holders qualify for a 10% discount on all classes booked and paid for online (excludes PTT sessions and classes already discounted during COVID-19 crisis). 
To activate the discount at the time of booking, select Redeem Coupon or Gift Certificate and enter 10OFFSEN before selecting Pay Now.

Services
Classes
Event Calendar
Private Appointments
Gift Vouchers
Phone/Email support
​Business Services
​Help for families
​Be Connected

Helping Hand
Online Content
​Newsletter
User Guides
Video tutorials/classes
Tips and Hints
​Blog
iTandCoffee Club
About the Club
Free Club Sessions
Sign In/View Account
Members Area
Prices/Policies
Prices
Privacy
Cancellations, Refunds, Returns
About iTandCoffee
Home
About

​Contact us
Testimonials
In the press

Picture
​© 2012-2021 iTandCoffee Pty Ltd. All rights reserved  ACN: 606 340 434