advanced excel course

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Advanced Excel Course

Advanced Excel Course

resolvedResolved · Low Priority · Version 2003

Kate has attended:
Excel Advanced course
Influencing Skills course
Excel VBA Intro Intermediate course
Access Intermediate course
Access Advanced course

Advanced Excel Course

Do you have to have prior knowledge of programming to attend the VBA course

RE: Advanced Excel Course

Hi Kate

Welcome to the forum and 12 months free support.

Our Introductory course for VBA is for complete beginners, so no knowledge of VBA is assumed, however it wouldbe useful if you knew how to record macros and view them.

regards

Best Team

Fri 12 Jun 2009: Automatically marked as resolved.


 

Excel tip:

Bracketed negative numbers

Often Excel users wish to display negative numbers in colour red and bracketed

Intstructions
Step1. Select Format > Cells menu options. Within Numbers tabsheet, select Category = Custom.
Step 2. Select a type such as #,##0;[Red]-#,##0;; that specifies a colour in square brackets.
Step 3. Amend as follows; #,##0;[Red](#,##0;;

Notes: Excel formatting featues are of the form
"Positive; Negative;Zero;Text" separated by semicolon.

View all Excel hints and tips


Server loaded in 0.11 secs.