Are you getting the most of out Microsoft Excel?

Kompas Consulting can bring personalised in-house training to your staff. We know MS Excel and can pass this knowledge onto your staff allowing them to use Microsoft Excel in a more straegic and focused mannor. Pick your version of Office! We are familar with Office XP, 2003, 2007 and the lastest release, Office 2010.
Following is an offering of what can be acheived in a day and includes customised manuals. For more information please Contact Us

Using Buttons and Boxes

  • Creating Drop Down Boxes
  • Buttons
  • Group Boxes
  • Writing Select Sheet Tab macros for buttons
  • Assigning Macros

Worksheet functions

  • SUM functions
  • Protecting and Unprotecting Cells
  • Paste Special options
  • IF Statements
  • Conditional Formatting
  • Dynamic Headings
  • Data Validation
  • Linking Workbooks

Data Functions

  • Concatenate Data
  • Left, Right and MID Functions
  • VLOOKUP's
  • Creating Charts

Macros

  • Print Macros
  • Protecting Multiple Sheets
  • Suppress Zeros

Manipulating Data

  • Sorting Data
  • Filtering Data
  • Auto Sum
  • Pivot Tables

Social Media Connectors

Skype Me™!

    © 2008 - 2011 Kompas Pty Limited, All rights reserved. Kompas Consulting is a trading name of Kompas Pty Ltd ABN 44 161 770 053