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

pivot table

ResolvedVersion 2013

Dan has attended:
Excel Intermediate course
Excel Advanced course
Excel Financial Modelling course

Pivot table +

Hello there,

I did excel advance but, regarding the attached spreadsheet, can’t extend the format or sheet “SUBTOTALS” up to 2016. Consequently I developed a “PROVISIONAL” sheet that I need to add to “SUBTOTALS”
Foremost I would appreciate the instructions, so I can repeat the process latter. I have been unable to follow the notes and links I have.

Many thanks,
Dan BellOso

RE: pivot table +

Hi Dan

I can't see your attached file on the support forum. Please can you send it again this time to info@stl-training.co.uk and ask for it to be forwarded to Doug Dunn.

Thanks

Doug
Best STL

Will be marked as resolved in 5 days

Notice: This is an automated message. Due to inactivity, this forum post will be marked as 'resolved' if there are no further responses in the next 5 days.

Thu 14 Jan 2016: Automatically marked as resolved.

 

Training courses

Training information:

See also:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.

Excel tip:

New Normal Worksheet

Do you want all your worksheets to confirm to a certain look? Then change the Defaults!!!
1. Press Shift+F11 to create a new worksheet
2. Press Ctrl+A to select (higlight) all cells, Press Ctrl+1, make any formatting changes then click OK.
3. Press F12 (Function 12 key) click in the Save As Type, drop down, then select Template (*.xlt)
4. Click in the Save in drop-down, then find the folder; c:_program files_microsoft office_office_start. (For the underscores shown use backslash)
Name your templete sheet.xlt, then press Enter.
Sheet.xlt is used when you insert a new worksheet (Shift+F11)

Note: These changes are permanent changes on your PC.

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.14 secs.