Are your spreadsheets inefficient or poorly designed? Do they require considerable maintenance? Are they difficult to understand? Do you need to manipulate list data? If any answer is ‘Yes’ then this day school could help you!
Excel is Microsoft’s powerful, figure-based spreadsheet. It performs simple-to-sophisticated calculations by means of user-created formulae. To assist formula creation Excel contains many built-in functions which are pre-programmed to perform specific calculations. Knowledge of these functions, and of different ways of addressing cell contents, will enhance the design, efficiency, and understanding of spreadsheet formulae. A well-designed spreadsheet requires minimum maintenance.
In addition to calculations, Excel’s row-and-column format lends itself to creating and storing lists of data. Excel contains many features, such as charts and pivot tables, for analysing and manipulating list data.
The day introduces some Excel functions and features for designing efficient, user-friendly spreadsheets which require minimum maintenance. It also gives a very brief introduction to charts and pivots.
Participants must be familiar with Excel basics, i.e.: creating and editing spreadsheets; entering different types of data (text / numbers / dates / formulae); writing simple formulae (add / subtract / multiply / divide).