PivotTables & Slicers

Want a quick introduction to PivotTables? Watch this 10 minute video. I demonstrate the basic features of PivotTables and feature Slicers, new to Excel 2010. And for more, view the earlier post: PivotTable Intro, Step by Step.

Excel Speaks!

Here’s another cool feature of Excel: Speak Cells on Enter.

Speak Cells on Enter

This can prove valuable as a means to verify accurate data entry. The only setup required is to add a button to your Quick Action Toolbar (QAT).

To setup:

  1. RIGHT + CLICK on the QAT and select Customize Quick Access Toolbar.
  2. Set the Choose commands from drop-down to All commands, then scroll down and select Speak Cells on Enter.
  3. Click Add, then OK.

The button now appears on your QAT. Click button to toggle the feature on or off.

When active, each time you enter in a cell, the cell contents will be read back to you. Unlike other reader programs this voice is clear and rather pleasant (take note Acrobat).

Now if only you could select the voice,  I’d take something along the lines of a HAL 9000, or K.I.T.T. model.

Additional voice features of Excel include:

  • Speak Cells
  • Speak Cells – Stop Speaking Cells
  • Speak Cells by Columns
  • Speak Cells by Rows
  • Stop Listening to Voices in My Head*

*available only to select consumers. What, I am not one of them? I am so! You keep out of this.

Cheers!
hɔuᴉnb

Comments and questions are always welcome!