Excel is a spreadsheet program from Microsoft and a component of its Office product group. Microsoft Excel enables users to format, organize and calculate data in a spreadsheet.
By organizing data using software like Excel, anyone and other users can make information easier to view as data is added or changed. Within study or employment, many people use Microsoft Excel and indeed data is often tabulated in spreadsheets where in point of fact Microsoft Word tables would be a far better fit.
Learning how to use Excel is one thing, but blind screen-reader users face other difficulties. Due to inadequate formatting and presentation, screen-reader users can become lost within spreadsheets to the extent that it is either difficult to find the data or to associate it with the context, such as determining how cells relate to each other. Many people leave blank cells in spreadsheets purely for visual layout purposes and it is difficult to overcome this major obstacle.
Our training course, Excel Yourself, gives plenty of strategies to overcome these and many other issues. You will learn the basics of how to work within Microsoft Excel with a particular focus on the screen-reading strategies built into the JAWS screen-reader so as to greatly assist in terms of efficiency, navigation and data composition.
Sample spreadsheets will be included as part of this training course, the topics for which are as follows:
- Course Introduction.
- Terminology.
- Customisation.
- Protected View.
- Basic navigation and cell entry.
- Cell management and more navigation.
- Navigating unfamiliar worksheets.
- Basic calculations.
- Setting up the budget worksheet.
- Defining the speaking of both row and column titles.
- Removing existing row and column assignments and assigning either row or column titles.
- AutoSum.
- Selecting cells manually for pasting a formula.
- Selecting cells with JAWS for pasting a formula.
- Calculating annual expenditure for each expense type.
- Grand totals.
- Assigning row and column titles to a specific worksheet area.
- Concluding notes on project to date.
- Describing worksheets with AI and Picture Smart, including pie charts.
- Editing named regions for title reading.
- Keystrokes to read column and row titles individually.
- Everything you need to know about monitoring cells.
- Cell Markers.
- Custom Summary.
- Inserting columns and rows.
- Deleting columns and rows.
- Checking revised formulae.
- More examples of deleting columns.
- Managing worksheets.
- Selecting rows and columns, changing and verifying formatting.
- Ensuring all cells can accept text only.
- Sorting alphabetically.
- Creating multi-line cells.
- Finding text.
- Working with Email links.
- Applying consistent data from a top-most cells to other selected cells.
- Attaching notes to cells.
- More Excel formulae.
- Hiding rows and columns.
- Detecting cell visibility.
- AutoFit, adjusting column widths and wrap text.
- Eliminating speech verbosity.
- Freeze Pane.
As is customary with Hartgen Consultancy training courses, you will learn the above concepts within the context of real-world examples which make sense.
The cost of Excel Yourself is £80 which is approximately $100.
Alternatively an invoice can be sent to you which you can pay using any major credit or debit card.
Conclusion.
Due to the nature of the subject matter and the complexities of layout, this training course will be fairly demanding. However, it is hoped when you have completed the course you will have a far greater understanding of how Excel functions and its relationship with the high quality support given within JAWS for Windows. Even if in your employment you only are required to use Excel a small amount, having taken this training course you will be in a far better position to work with it than you were before.