Microsoft excel tutorial handout pdf. Microsoft excel for beginners 20 hours this is a basic computer workshop. Microsoft excel is one of the most popular spreadsheet applications that helps you manage data create visually persuasive charts and thought provoking graphs. A new worksheet will be added for the pivot table. Initially the spreadsheet will appear blank.
A shortcut to start excel 2003 is located in the microsoft office 2003 folder found on the desktop. Microsoft excel can also be used to balance a checkbook create an expense report build formulas and edit them. We use it to create reports that need calculations and charts. In this workshop we will learn how to move around and work inside the spreadsheet.
The excel screen name box standard toolbar formula bar active cell menu bar title bar select all button status bar tab scrolling buttons sheet tabs worksheet scroll bars minimize buttons restore buttons close. Excel will also automatically select new worksheet as the destination for the pivot table. Microsoft excel tutorial handout opening microsoft excel 1. You should see a new excel spreadsheet file titled book1 or some such default name.
Excel will automatically select the data for the pivot table. Microsoft excel is a powerful electronic spreadsheet program you can use to automate accounting work organize data and perform a wide variety tasksof excel is designed to perform calculations analyze information and visualize data in a spreadsheet. Excel is supported by both mac and pc platforms. Be very familiar with the steps to take to load a component of the microsoft office software.
Click on microsoft excel. There are other spreadsheet programs out there including google spreadsheets part of google docs openoffice calc apple iworks numbers lotus 1 2 3 and wordperfect quattro. The pivottable field list is located to the right. Microsoft excel is a spreadsheet program.
Also this application includes database and charting features. It is always a good idea to immediately name the file that you are. Go ahead and open excel. Once excel is loaded you are ready to complete the exercises that follow.
Microsoft excel tutorial handout opening microsoft excel.