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.

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