RSS
 

Posts Tagged ‘Excel’

Video: How to make an HDR image using Microsoft Excel… seriously

22 Jan

Photographers have many different kinds of software for producing high dynamic range images, but Microsoft Excel probably doesn’t make your list of photo editing apps. Well… be prepared to change your mind.

On the off chance you don’t know what Microsoft Excel is, it’s a spreadsheet application that’s primarily used for business application. But in May of last year, Columbia University computer science student Kevin Chen showed that is was also capable of producing an HDR photo using some complicated math and a couple dozen GBs of RAM.

Before coming to Columbia, Chen worked as an intern at Apple, working on camera technology. It was that experience—understanding the math behind digital photography in general and high dynamic range imagery specifically—that allowed him to implement the “system of linear equations” that is typically used in HDR imaging.

After turning the original photo grayscale, and using each cell in Excel as a different “pixel”, he was able to implement this math (and zoom way out) to reveal his final product. Here is the color before and grayscale after:

Sure, you probably don’t want to make Excel your primary HDR processing software. But Chen’s presentation reveals something that is easy to lose sight of when you’re processing digital files and working with photographs: as far as your computer is concerned, it’s all pixel values and math.

Check out the full presentation up top, and then head over to Chen’s website if you want to know more about the young computer scientist.

Articles: Digital Photography Review (dpreview.com)

 
Comments Off on Video: How to make an HDR image using Microsoft Excel… seriously

Posted in Uncategorized

 

Excel at Underwater Photography Like You’re Part Fish

18 Dec

Underwater photography is an acquired taste that is both an art form and a means of obtaining data. Usually, scuba divers are the ones taking underwater photos, but this art form can also be carried out while diving on surface supply, just swimming, snorkeling or safely inside a submersible. While underwater photography can be understandably difficult to successfully carry out, Continue Reading

The post Excel at Underwater Photography Like You’re Part Fish appeared first on Photodoto.


Photodoto

 
Comments Off on Excel at Underwater Photography Like You’re Part Fish

Posted in Photography

 

Microsoft Excel 2010 – Stop Accidentally Showing the Ribbon Shortcut Keys

16 Oct

While navigating through worksheets in Excel 2010, pressing slash on the keyboard shows the ribbon shortcut keys. Learn how to prevent this from happening.

While navigating through cells in a Microsoft Excel 2010 worksheet, have you ever seen letters and numbers appear next to options in the Ribbon like the below screenshot?

If so, you may have accidentally pressed the slash (/) key. Doing so activates the menu to satisfy compatibility with Lotus 1-2-3 users, who would normally press this key to access menu options. However, many younger accountants and computer users barely remember this program, if at all, and do not need this ‘feature’ occurring when their fingers slip pressing arrow keys. To disable this:…

Read more at MalekTips.
New Computer and Technology Help and Tips – MalekTips.Com

 
Comments Off on Microsoft Excel 2010 – Stop Accidentally Showing the Ribbon Shortcut Keys

Posted in Technology

 

Microsoft Excel 2010 – For Worksheet Drafts Print Default Headings And / Or Gridlines

01 Aug

Don’t want to spend time manually creating border lines or headers for a particular draft worksheet? Have Excel 2010 print default gridlines and column headings.

Though a simple tip, if you didn’t know how to do this before, you’ll be happy to know this option is available. By default, Microsoft Excel 2010 does not print gridlines, expecting that you will add your own borders to presented data. The letter column headings are also not printed, as you are expected to create your own descriptors for data.

Sometimes you may be working on an in-progress worksheet or one where time is of the essence and the worksheet style does not matter. In these situations you can quickly toggle the printout of gridlines and headings to help organize your data:…

Read more at MalekTips.
New Computer and Technology Help and Tips – MalekTips.Com

 
Comments Off on Microsoft Excel 2010 – For Worksheet Drafts Print Default Headings And / Or Gridlines

Posted in Technology

 

Microsoft Excel 2010 – Clear Cell Formatting

14 Jun

A few mouse clicks or a keyboard shortcut are all it take to clear formatting from a cell or group of cells.

Have you ever had a cell or group of cells in a Microsoft Excel 2010 worksheet that contain a lot of formatting applied, such as combinations of different fonts, colors, underline styles, effects, etc.? If you need to remove formatting from these cells try the following:

1. Select the cell or group of cells from where you want to remove formatting, or press Ctrl +A to affect the entire worksheet….

Read more at MalekTips.
New Computer and Technology Help and Tips – MalekTips.Com

 
Comments Off on Microsoft Excel 2010 – Clear Cell Formatting

Posted in Technology

 

Microsoft Excel 2010 – Filtering Data in a Worksheet, with an Example

22 Sep

Instructions on how to filter data in an Excel 2010 worksheet, with screenshots showing filters performed on an example worksheet.

When viewing a worksheet in Microsoft Excel 2010 with a large series of data, it might prove useful to only display a subset matching desired criteria. Examples may include only showing salespeople with over $ 25,000 in monthly sales, budget items costing $ 5,000 or more, or students scoring at least an 80 on a test.

To display this subset you can use Excel 2010’s Filter tool. …

Read more at MalekTips.
New Computer and Technology Help and Tips – MalekTips.Com

 
Comments Off on Microsoft Excel 2010 – Filtering Data in a Worksheet, with an Example

Posted in Technology

 

Microsoft Excel 2010 – Double or Accounting Underline Text

14 Sep

Choose from several underline styles in an Excel 2010 workbook.

It’s simple to underline text in Microsoft Excel 2010 – either press the CTRL + U keys or press the U button in the Font section of the “Home” tab in the Ribbon. However, you may not know that a couple of other underline styles are available besides the single basic underline, such as styles that underline everything except currency symbols. See the screenshot on the right for an example.

1. Select a cell you want to underline in a different style. Note that you can only apply one underline style per cell….

Read more at MalekTips.
New Computer and Technology Help and Tips – MalekTips.Com

 
Comments Off on Microsoft Excel 2010 – Double or Accounting Underline Text

Posted in Technology

 

Microsoft Excel 2010 – Show Trends Inside a Cell via Sparklines

10 Aug

Display miniature graphs, sparklines, showing trends in a series of data in an Excel 2010 worksheet.

While it is relatively easy to place multiple graphs inside a Microsoft Excel 2010 worksheet, adding too many may make your document seem unwieldy. However, multiple graphs may prove useful, especially when determining trends. For example, a worksheet containing rows of prices of different stocks across several quarters might benefit from graphs showing the trends of each stock’s price. The same could be said for a group of students’ grades (see the below screenshot), sales figures from your sales team, etc.

With the use of “Sparklines” you can add smaller miniature graphs for each row of data illustrating trends for each row:…

Read more at MalekTips.
New Computer and Technology Help and Tips – MalekTips.Com

 
Comments Off on Microsoft Excel 2010 – Show Trends Inside a Cell via Sparklines

Posted in Technology

 

Microsoft Excel 2010 – Show Trends Inside a Cell via Sparklines

09 Aug

Display miniature graphs, sparklines, showing trends in a series of data in an Excel 2010 worksheet.

While it is relatively easy to place multiple graphs inside a Microsoft Excel 2010 worksheet, adding too many may make your document seem unwieldy. However, multiple graphs may prove useful, especially when determining trends. For example, a worksheet containing rows of prices of different stocks across several quarters might benefit from graphs showing the trends of each stock’s price. The same could be said for a group of students’ grades (see the below screenshot), sales figures from your sales team, etc.

With the use of “Sparklines” you can add smaller miniature graphs for each row of data illustrating trends for each row:…

Read more at MalekTips.
New Computer and Technology Help and Tips – MalekTips.Com

 
Comments Off on Microsoft Excel 2010 – Show Trends Inside a Cell via Sparklines

Posted in Technology

 

Microsoft Excel 2010 – Hide Worksheet Tabs, Scroll Bars if Not Needed

08 Aug

If you’re only using one worksheet in an Excel 2010 workbook, why display the worksheet tabs if you’ll never use them? Also learn how to hide one or both scroll bars if not needed.

While some complicated Microsoft Excel 2010 workbooks may have dozens, if not more worksheets, you may sometimes create workbooks that only require one worksheet tab. In this case, why show the worksheet tabs if you don’t need to use them? By hiding these tabs, and also the horizontal and / or vertical scroll bars, you can slightly increase the room onscreen used to display your workbook.

1. Open the workbook you wish to modify….

Read more at MalekTips.
New Computer and Technology Help and Tips – MalekTips.Com

 
Comments Off on Microsoft Excel 2010 – Hide Worksheet Tabs, Scroll Bars if Not Needed

Posted in Technology