This is a very basic function in Excel – sometimes you may need printed documentation of both of these items – the comments can be used as a reference as what needs to be done. Having formulas printed out can be a method of seeing how a complex formula was created – these printouts can be used as reference in future tasks (we cannot remember everything!).
This will work with any version of Excel up to 2016/365!
Tables have their uses in Excel where data can be instantly formatted. You can also filter (query) the data set to find data that meets specific conditions. They are useful if you need to do some quick calculations – they can also be attractively presented.
Using HDR to adjust (equalize) the contrast so you get more detail in a photo. You can also add adjustment layers at the end to tweak the image. Done with Photoshop CS6, the techniques work with earlier and newer versions.
If the file has layers, make a duplicate as HDR will flatten the image. This brief video demonstrates methods to tweak and improve your photo. You can also create some very interesting effects with the photo.
Very often competent Excel users get frustrated when they cannot get a 0 at the beginning of a cell or when they type in month and year (i.e. September 2017), it appears as 9/1/17. Naming worksheets and copying them is also reviewed. This 4 minute video covers all these topics.
Sometimes you want to add up the rounded values in Excel, for example
1.7 = 2
1.2 = 1
3.9 = 4
3.4 = 3
5.2 = 5
6.4 = 6
4.3 = 4
26.1 25 are the actual totals, you want 25 to appear. This video shows you to do this task.