Microsoft Excel 2010 IF Statements and Pivot Tables.

Join us for a 90-minute class targeted for the intermediate user. This class explores the most popular Excel features, IF Statements and Pivot Tables. The class is designed to introduce the basics by using examples of how to create and manipulate an IF statement, a nested IF Statement, an IF  And and an IF Or.  Next we move to the creation of a Pivot Table and Chart. The class discusses when to use a Pivot Table and how to manipulate it to achieve your goals. We promise you will walk away confident and ready to explore these functions on your own. February sessions are held from 2:00p to 3:30p Thursday 2/23. The price is $45.00 payable via our website.

Introduction to Microsoft Access 2010 is returning!

This is for the beginner. This four session course will create a database using Access 2010. Tables are the foundation of an Access database. Session one we create tables from scratch, from templates, and from importing the data from Excel. Session two we use these tables in Queries which extract the requested data.  (My favorite class!)  Session three we use our tables and queries to build user data entry forms and build customized reports from our queries. The last session we review by modifying our database adding a table, a query, create a new form and new report. Sessions are offered 2:00p to 3:30p on 2/20, 2/22, 2,27, and 2/29.

Virtual Consulting per Hour

Have an Office software roadblock and could use a helping hand?
Have a routine mail-merge or spreadsheet function that takes too long?

CLI is virtual to assist you with a spreadsheet problem, Access query issue, PowerPoint presentation creation, or a mundane task, we are available.    

By using GoToMeeting we have created a fun and interactive way to zero in on one particular topic. It is a Virtual Classroom! I send you a link to the webinar and the datafile that you will need to participate in the class. Five minutes prior to the class you click the link and attend the class. It is interactive, you can see my screen and we can talk or chat with each other.

All classes are limited to 15 attendees.

You can pay using Visa or Mastercard using our secure PayPal link.

  • Excel 2010 class is $45.00 per attendee.
  • Access 2010 class is $99.00 per attendee.
  • Consulting is $50.00 per hour for Word, Excel, Access, and PowerPoint.   Additional rates for Project and Quickbooks.

USD

Feb Web Classes