MARS Excel 2007 Expert - Templates and Macros

Maths Functions

  • understanding maths functions
  • using SQRT
  • using ABS
  • using INT
  • using TRUNC
  • using ROUND
  • using ODD And EVEN
  • using CEILING
  • using MROUND
  • using PRODUCT
  • using SUMIF
  • using SUMIFS
  • using SUMPRODUCT.

Text Functions

  • understanding text functions
  • using PROPER
  • using UPPER and LOWER
  • using LEFT and RIGHT
  • using MID
  • using LEN
  • using SUBSTITUTE
  • using T
  • using TEXT
  • using VALUE.

Information Functions

  • understanding information functions
  • using CELL
  • using ISBLANK
  • using ISODD and ISEVEN
  • using ISNUMBER and ISTEXT
  • using TYPE.

 Protecting Data

  • understanding data protection
  • providing total access to cells
  • protecting a worksheet
  • working with a protected worksheet
  • disabling worksheet protection
  • providing restricted access to cells
  • password protecting a workbook
  • opening a password protected workbook
  • removing a password from a workbook. 

Data Consolidation

  • understanding data consolidation
  • consolidating with identical layouts
  • creating an outlined consolidation
  • consolidating with different layouts.

Recorded Macros

  • understanding Excel macros
  • setting macro security
  • saving a document as macro enabled
  • recording a simple macro
  • running a recorded macro
  • relative cell references
  • running a macro with relative references
  • viewing a macro
  • editing a macro
  • assigning a macro to the toolbar
  • running a macro from the toolbar
  • assigning a keyboard shortcut to a macro
  • deleting a macro
  • copying a macro
  • tips for developing macros.

Recorder Workshop

  • preparing data for an application
  • recording a summation macro
  • recording consolidations
  • recording divisional macros
  • testing macros
  • creating objects to run macros
  • assigning a macro to an object.

On-Site Training

If you need training for three or more people, ask us about training at your site. You can enjoy the convenience of reduced travel cost and time, as well as a familiar environment for your staff. Additionally, we can customise the course for your business needs.

User Reviews

Not yet rated. You will need to follow this course before you can write a review.

Course Info

Next Step

Enquire Now
Tell a Friend
Email Course Outline