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

pivot table

ResolvedVersion 2010

Michelle has attended:
Excel Intermediate course

Pivot table

I would like to learn more on this topic, will you compensate me a free course that covered this topic? As I was applied for Excel level 2 which has it but been put to intermediate which doesn't cover.

RE: pivot table

Hello Michelle,

Thank you for your email and forum post. We are discussing this with your account manager and will handle this with you directly via them, rather than via the forum.

Kind regards

Richard

Fri 12 Sep 2014: Automatically marked as resolved.

Excel tip:

Colouring cells containing formulas

Cells in a worksheet can contain values or they can contain formulas. You may wish to identify all the cells in your worksheet that contain formulas by colouring those cells.

Follow these steps:
1. Choose Edit > Go To menu, or press either F5 or Ctrl+G. Excel displays the Go To dialog box.
2. Click Special. Excel displays the Go To Special dialog box.
3. Select the Formulas radio button option.
4. Select OK.

At this point, every formula cell in the worksheet is selected, and those cells can be coloured formatted as desired.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.