spreadsheet

You are currently browsing articles tagged spreadsheet.

In conjunction with my camera guide for the new Nikon D500, Nikon D500 Experience, I have created a free Nikon D500 Setup Guide – a comprehensive spreadsheet with suggested settings for the applicable Menus, all of the Custom Settings, plus some shooting and exposure settings. It has complete and separate camera setup recommendations for different types of shooting, including:

General / Travel / Street
Landscape / Architecture
Action / Sports
Moving Wildlife / Birds
Studio / Portraits
Concert / Performance

Here is an example detail of just a small part of the Setup Guide spreadsheet:

 Nikon D500 Setup Guide Spreadsheet Experience Full Stop tips tricks recommend suggested setting menu Custom Setting

The direct link to download the Excel spreadsheet is:

http://docs.fullstopbooks.com/forms/Nikon_D500_Experience-Setup_Guide.xls

To print the spreadsheet guide, you may wish to print it across several pages and then tape them together, so that the data is legible:

-First, be sure to set the print area, to avoid all the blank pages. Do this by manually selecting all the cells with data in them (drag the cursor from cell A1 to G190 and they will all appear blue.) Then access the menu for File > Print Area > Set Print Area.

-Then go to File > Print Preview and select the Setup button.

-Then set the page for “Landscape” and “Fit To” 2 pages wide by 3 pages tall.

This should result in 6 pages to be printed (as long as you have set the print area first).

Be sure to check the Print Preview to see that the data will print at a reasonable size, and that there are only 6 or so pages that will print.

Nikon D500 viewfinder autofocus AF points crop 1.3x grid

In the past I have resisted requests for these types of quick-start “cheat sheets,” because I prefer that readers of my Full Stop camera guides read through all of the Menu and Custom Settings options, and determine which settings suit their shooting situations and preferences. This is one of the best ways to really learn the ins-and-outs of one’s new camera, so I still encourage you to do so. But I can appreciate the value and the handy reference features of this type of recommendation guide.

Please feel free to take the advice of dedicated Wildlife or Concert photographers, for example, above mine if it differs! And for further information, explanations, justifications, and caveats for the settings I specify, please have a look at my clear and comprehensive guide Nikon D500 Experience.

Nikon D500 Experience book manual guide how to use set up quick start setting recommend menu custom setting setup guide

Version History of Spreadsheet

2016-05-22 – v1.0 – First version released

2016-05-24 – v1.1 – Minor formatting corrections

In conjunction with my camera guide for the new Nikon D7200, Nikon D7200 Experience, I have created the free and comprehensive Nikon D7200 Setup Guide, with recommended settings for the applicable Menus, all of the Custom Settings, plus some shooting and exposure settings. It has complete and separate camera setup recommendations for different types of shooting, including:

General / Travel / Street
Landscape / Architecture
Action / Sports
Moving Wildlife / Birds
Studio / Portraits
Concert / Performance

Here is a detail of just a small part of the Setup Guide spreadsheet:

Nikon D7200 Setup Guide spreadsheet menu custom settings setup quick start tips tricks

The direct link to download the Excel spreadsheet is:

http://docs.fullstopbooks.com/forms/Nikon_D7200_Experience-Setup_Guide-UL.xls

alternate link:

http://www.dojoklo.com/Full_Stop/forms/Nikon_D7200_Experience-Setup_Guide-UL.xls

To print the spreadsheet guide, you may wish to print it across several pages and then tape them together, so that the data is legible:

-First, be sure to set the print area, to avoid all the blank pages. Do this by manually selecting all the cells with data in them (drag the cursor from cell A1 to G151 and they will all appear blue.) Then access the menu for File > Print Area > Set Print Area.

-Then go to File > Print Preview and select the Setup button.

-Then set the page for “Landscape” and “Fit To” 2 pages wide by 3 pages tall. Alternately, you can set for “Adjust to 60% Normal Size.”

Either of those options should result in 6 pages to be printed (as long as you have set the print area first).

Be sure to check the preview to see that the data will print at a reasonable size, and that there are only 6 or so pages that will print.

Nikon D7200 Experience book manual guide set up spreadsheet menu custom setting tips tricks shooting exposure

 

In the past I have resisted requests for these types of quick-start “cheat sheets,” because I prefer that readers of my Full Stop camera guides read through all of the Menu and Custom Settings options, and determine which settings suit their shooting situations and preferences. This is one of the best ways to really learn the ins-and-outs of one’s new camera, so I still encourage you to do so. But I can appreciate the value and the handy reference features of this type of recommendation guide.

Please know that I am not an expert in all of the different photography categories I have included, so feel free to follow the advice of dedicated Bird or Concert photographers, for example, if it differs from mine. Or follow your own preferences as they develop with experience. And for further information, explanations, justifications, and caveats for the settings I specify, please have a look at my clear and comprehensive guide Nikon D7200 Experience.

Nikon D7200 Experience book manual guide quick start master tips tricks recommend autofocus metering

 

Version History of Spreadsheet

2015-03-24 – v1.0 – First version released

In conjunction with my camera guide for the new Canon 7D Mark II, Canon 7D Mark II Experience, I have created a Canon 7D Mark II Setup Guide – a comprehensive spreadsheet with recommended settings for the applicable Menus, Custom Function settings, plus some shooting and exposure settings. It has complete and separate camera setup recommendations for different types of shooting, including:

General / Travel / Street
Landscape / Architecture
Action / Sports
Moving Wildlife / Birds
Studio / Portraits
Concert / Performance

Here is a detail of just a small part of the Setup Guide spreadsheet:

Canon-7D-MarkII-setup-guide-02
Canon 7D Mark II Experience, Setup Guide Spreadsheet – a detail of the spreadsheet

 

Excel Version – The direct link to the Excel spreadsheet is:

http://docs.fullstopbooks.com/forms/Canon_7D_Mark_II_Experience-Setup_Guide.xls

alternate link:

http://www.dojoklo.com/Full_Stop/forms/Canon_7D_Mark_II_Experience-Setup_Guide.xls

To print the guide, you may wish to print it across several pages and then tape them together, so that the data is legible:

First, be sure to set the print area, to avoid all the blank pages. Do this by manually selecting all the cells with data in them (drag the cursor from cell A1 to G185 and they will all appear blue.) Then access the menu for File > Print Area > Set Print Area.

Then go to File > Print Preview and select the Setup button,

Then set the page for “Landscape” and “Fit To” 2 pages wide by 3 pages tall. Alternately, you can set for “Adjust to 60% Normal Size.”

Either of those options should result in 6 pages to be printed (as long as you have set the print area first).

Be sure to check the preview to see that the data will print at a reasonable size, and that there are only 6 or so pages that will print.

PDF Version – You can download a PDF version below, which is divided into 2 pages, and can be perhaps more easily navigated on a tablet or phone with some panning and zooming. However for printing it may prove to be too tiny, and you may wish to print the XLS version instead.

http://www.dojoklo.com/Full_Stop/forms/Canon_7D_Mark_II_Experience-Setup_Guide.pdf

Canon 7D Mark II book manual guide setup how to tips tricks spreadsheet menu custom function setting

In the past I have resisted requests for these types of quick-start “cheat sheets,” because I prefer that readers of my Full Stop camera guides read through all of the Menu and Custom Settings options, and determine which settings suit their shooting situations and preferences. This is one of the best ways to really learn the ins-and-outs of one’s new camera, so I still encourage you to do so. But I can appreciate the value and the handy reference features of this type of recommendation guide.

Please know that I am in no way an experienced expert in all of the different photography categories I have included, so take the advice of dedicated Bird or Concert photographers, for example, above mine if it differs! And for further information, explanations, justifications, and caveats for the settings I specify, please have a look at my clear and comprehensive guide Canon 7D Mark II Experience.

Canon 7D Mark II book manual guide setup tips tricks spreadsheet menu custom function setting

Version History
v1.0 – First version released – 2015-12-23

Use this Setup Guide in conjunction with Canon 7D Mark II Experience:

Canon 7D Mark II Experience book manual guide master how to tips tricks learn use setup quick start setting recommend menu custom function

If you have purchased my Canon 7D Mark II Experience e-book guide, be sure to sign up on the updates page, so that I can inform you of any updates made to the guide or to this spreadsheet, and well be able to provide you with a free updated guide, should there be any major updates or corrections.

If you have found this blog helpful and plan to purchase a Canon 7D Mark II or some lenses or accessories for it, please consider using my affiliate links for Amazon or for B and H, found at the left side of this page. Your price will be the same, but they will give me a small referral fee – thanks! And please feel free to spread the word if this blog has been helpful.

In conjunction with my camera guide for the new Nikon D750, Nikon D750 Experience, I have created a Nikon D750 Setup Guide – a comprehensive spreadsheet with recommended settings for the applicable Menus, all of the Custom Settings, plus some shooting and exposure settings. It has complete and separate camera setup recommendations for different types of shooting, including:

General / Travel / Street
Landscape / Architecture
Action / Sports
Moving Wildlife / Birds
Studio / Portraits
Concert / Performance

Here is a detail of just a small part of the Setup Guide spreadsheet:

Nikon D750 Menu Custom Setting setup guide quick start tips tricks cheat sheet book manual guide recommend
Nikon D750 Experience, Setup Guide Spreadsheet – a detail of the spreadsheet

 

Excel Version – The direct link to the Excel spreadsheet is:

http://docs.fullstopbooks.com/forms/Nikon_D750_Experience-Setup_Guide.xls

alternate link:

http://www.dojoklo.com/Full_Stop/forms/Nikon_D750_Experience-Setup_Guide.xls

To print the guide, you may wish to print it across several pages and then tape them together, so that the data is legible:

First, be sure to set the print area, to avoid all the blank pages. Do this by manually selecting all the cells with data in them (drag the cursor from cell A1 to G155 and they will all appear blue.) Then access the menu for File > Print Area > Set Print Area.

Then go to File > Print Preview and select the Setup button,

Then set the page for “Landscape” and “Fit To” 2 pages wide by 3 pages tall. Alternately, you can set for “Adjust to 60% Normal Size.”

Either of those options should result in 6 pages to be printed (as long as you have set the print area first).

Be sure to check the preview to see that the data will print at a reasonable size, and that there are only 6 or so pages that will print.

PDF Version – You can download a PDF version below, which is divided into 2 pages, and can be perhaps more easily read and navigated on a tablet or phone with some panning and zooming. However for printing it may prove to be too tiny, and you may wish to print the XLS version instead.

http://www.dojoklo.com/Full_Stop/forms/Nikon_D750_Experience-Setup_Guide.pdf

Nikon D750 setup menu custom setting guick start how to book manual guide viewfinder autofocus

In the past I have resisted requests for these types of quick-start “cheat sheets,” because I prefer that readers of my Full Stop camera guides read through all of the Menu and Custom Settings options, and determine which settings suit their shooting situations and preferences. This is one of the best ways to really learn the ins-and-outs of one’s new camera, so I still encourage you to do so. But I can appreciate the value and the handy reference features of this type of recommendation guide.

Please know that I am in no way an experienced expert in all of the different photography categories I have included, so take the advice of dedicated Bird or Concert photographers, for example, above mine if it differs! And for further information, explanations, justifications, and caveats for the settings I specify, please have a look at my clear and comprehensive guide Nikon D750 Experience.

Nikon D750 setup menu custom setting guick start how to book manual guide viewfinder autofocus

Version History
v1.0 – First version released

If you have purchased my Nikon D750 Experience e-book guide, be sure to sign up on the updates page, so that I can inform you of any updates made to the guide or to this spreadsheet, and well be able to provide you with a free updated guide, should there be any major updates or corrections.

If you have found this blog helpful and plan to purchase a Nikon D750 or some lenses or accessories for it, please consider using my affiliate links for Amazon or for B and H, found at the left side of this page. Your price will be the same, but they will give me a small referral fee – thanks! And please feel free to spread the word if this blog has been helpful.