This handy textbook covers all you need to get started with spreadsheets.Learning Made Simple books give you skills without frills. They are matched to the main qualifications, and written by experienced teachers and authors to make often tricky subjects simple to learn. Every book is designed carefully to provide bite-sized lessons matched to your needs.Learning Made Simple titles provide both a new colorful way to study and a useful adjunct to any training course. Using full color throughout, and written by leading teachers and writers, Learning Made Simple books will help you learn new skills and develop your talents. Whether studying at college, training at work, or reading at home, aiming for a qualification or simply getting up to speed, Learning Made Simple books will give you the advantage of easy, well-organised training materials in a handy volume with two or four-page sections for each topic for ease of use.
Frequently asked questions
Simply head over to the account section in settings and click on âCancel Subscriptionâ - itâs as simple as that. After you cancel, your membership will stay active for the remainder of the time youâve paid for. Learn more here.
At the moment all of our mobile-responsive ePub books are available to download via the app. Most of our PDFs are also available to download and we're working on making the final remaining ones downloadable now. Learn more here.
Both plans give you full access to the library and all of Perlegoâs features. The only differences are the price and subscription period: With the annual plan youâll save around 30% compared to 12 months on the monthly plan.
We are an online textbook subscription service, where you can get access to an entire online library for less than the price of a single book per month. With over 1 million books across 1000+ topics, weâve got you covered! Learn more here.
Look out for the read-aloud symbol on your next book to see if you can listen to it. The read-aloud tool reads text aloud for you, highlighting the text as it is being read. You can pause it, speed it up and slow it down. Learn more here.
Yes, you can access Spreadsheets with Excel by Stephen Morris in PDF and/or ePUB format, as well as other popular books in Business & Business General. We have over one million books available in our catalogue for you to explore.
The Excel spreadsheet program lets you manage all types of information, whether for business or personal use. The program can process data from many sources: ranging from mainly numeric tables â such as balance sheets, sales returns and production schedules â to the sort of lists more usually associated with database programs. This book shows you how to handle this information and make the most of Excelâs facilities.
Basic steps
To get Excel up and running
1 Click on the Windows Start button, in the bottom left-hand corner of the screen.
2 Select the All Programs option.
3 Select Microsoft Office from the list.
4 Select Microsoft Office Excel 2003.
The program is loaded and the Excel display will take up most of the screen.
Alternatively, copy the Excel shortcut to the Desktop or a folder on the Desktop, then double-click on the Excel icon.
Components
The title bar tells you the title of the file.
The menu bar has a set of drop-down menus giving access to Excelâs features.
The toolbar is a row of buttons and selection boxes which provide shortcuts to the menu options or quick ways of entering values.
The sheet tabs and tab buttons let you move from one worksheet to another (see pages 78 and 81).
The scroll bars allow fast movement within a sheet.
The status bar displays messages and gives information, such as whether [Num Lock] is switched on.
The task pane lists suggestions for possible actions.
The main grid is where data is entered, and results displayed.
Screen components
Excel runs under all recent versions of Windows, making the most of its mouse and icon based options. However, in common with most modern Windows applications, Excel provides a screen that is extremely cluttered and can be very daunting to the new user. In fact, you may never use many of the options that are presented to you and you will quickly find and master the most useful ones.
The main components of the display are listed briefly here, with fuller descriptions given later.
The worksheet grid
In common with all other spreadsheet programs, Excel is organised around a simple grid system. The grid consists of a rectangular array of rows and columns and is called a worksheet. The columns are labelled with letters: A, B, C and so on; the rows are numbered from 1 down the sheet.
The intersection of each row and column forms a cell. Any item of data entered on the sheet is placed in one of these cells; each cell can hold one and only one item of data.
The cells are identified by combining the cell letter and row number (the cell reference). For exam...
