HOME SCHEDULE   |   CRCA SPONSORS   |   ABOUT CRCA   |   CONTACT  
       
 
MICROSOFT EXCEL 2007/2010 WORKSHOP - WEDNESDAY, FEBRUARY 29, 2012
Trainer: Bentley Beckles, Advantage Caribbean Institute, 
               Microsoft Certified Trainer (MCT),
               Microsoft Certified Learning Consultant (MCLC)
  
This workshop is for anyone who knows that there is more to get out of this application  but hasn’t found the “right tutor.” This workshop will cover the basics of customizing Microsoft Office Excel to suit the participants methods/preferences for working. We will then explore the application window for those little gems that make hard work seem like nothing at all. Then it’s on to writing and understanding the structure of formulas and those functions you have just got to know.

To make the most of this session - bring your laptop!
 Certificates issued by Advantage Caribbean Institute Ltd

Members -  $200 USD
Non-Members - $225 USD
Note: Registration fee does not include lunch.

TO REGISTER ►

TOPICS TO BE COVERED  

Understanding the Ribbon – Microsoft Excel 2007 & 2010
Set Excel Default Options – All versions
Customize Quick Access Toolbar – 2007 & 2010
Customize toolbars - Microsoft Excel 2003
Navigation and working with the Name Box
Managing Worksheets
Worksheet Design
Writing and Understanding Formulas
Functions you must know:
  SUM, MIN, MAX, COUNT, COUNTA, IF, COUNTIF,
  SUMIF, SUBTOTAL, TODAY, NOW, DATEDIF, VLOOKUP
Hyperlinks
Working with AutoFill and AutoFill Options
Working with Paste Special
Text to Columns & Concatenate
 
Range Names
Charts
Inserting and working with images
Share Workbooks & Track Changes
Working with Comments
Understanding and working with Page Layout
Printing
Working with the Data Form
Filtering & Custom Views
Conditional Formatting
Label Alignment – Merge & Center
Working with Views – Freeze Panes
Sorting & Multi-Level Sorts
Backstage features Microsoft Excel 2007 & 2010
SCHEDULE  
9:45 AM Registration and Setup
10:00 am Workshop Begins
5:00 pm Workshop Ends
 
     
  DELEGATE       SPEAKER       SPONSOR         SCHEDULE      CRCA SPONSORS       ABOUT      CONTACT