Audio Lesson: Manipulating Data in Excel on Mac with Voiceover

This lesson will guide you through some of the most commonly used strategies on how to manipulate your data in an Excel spreadsheet when using Mac with Voiceover.

It assumes that you have either already purchased my introductory lesson on Getting Started with Excel, or, you already have some basic knowledge on how to perform basic tasks like launching Excel, creating a new workbook, inserting sheets, typing data into cells, editing data, or other similar tasks.

Here's what you'll learn:

1. How to delete the entire contents of a single cell within a worksheet and how to undo the deletion.
2. How to select an entire worksheet.
3. How to turn your data from a selected worksheet into a table, so that VoiceOver will know to do a consistent job of announcing the active cell coordinates along with any entered data (Note that this doesn't happen by default).
4. How to select a single cell of data, cut or copy it, and paste it somewhere else in another part of a worksheet or in a new workbook.
5. How to select an entire row of data, copy or cut it, and paste it somewhere else in another worksheet or workbook.
6. How to select an entire column, how to unselect it, and how to copy or cut it and paste it elsewhere.
7. How to select consecutive cells in a row or in a column, and how to unselect already selected cells.
8. How to select cells from the point of your cursor's focus, to the last cell in a row/column.
9. How to select a range of cells going down a row and to the adjacent column to the right.
10. How to use the "Fill Right" feature to write a series of numbers or dates in a column, and then get that exact same series to appear (as a duplicate) in the exact same position in the adjacent column to the right of the current one.
11. How to insert a blank row above the current one your focus is on.
12. How to insert a blank column to the left of the current one your focus is on.
13. How to select an entire set of cells in a column and shift them all over to the adjacent column to the right, or one unit down (when in a row).
14. How to insert an unchanging or static date into a cell (such as today's date), without having to type the date in manually.

This lesson is sold as an mp3 file for download. No refunds, returns, or exchanges, please. Thank you!