Ms Excel
SIntroduction to Microsoft Excel 2007
Class learning objectives
1. What is Excel? • Spreadsheet uses & samples • Touring the Excel window • Learning important definitions • Navigating around the workbook 2. The Basics • Entering & editing data in cells • Inserting cells, rows, & columns • Formatting cells • Renaming, adding, & reorganizing worksheets 3. Formulas • Using mathematical operators • Using four sum methods • AutoCalculate 4. Customizing Your Spreadsheet • Gridlines 5. Finishing Up • Using Excel’s help • More learning resources
Main Library Computer Learning Center
1
What is Excel?
Excel is a spreadsheet program that can be used to organize, manipulate and analyze data. Excel is often used in the workplace to track statistics, create sales reports, financial modeling, scientific engineering, and making charts and graphics. However, it can also be useful at home to create budgets or even make a list of family members’ birthdays. Excel is a versatile and powerful program with a lot to offer. The Excel Window When you first open up Excel you will see a blank sheet that looks a lot like a grid. If you have ever used other Microsoft programs such as Microsoft Word, you will recognize several parts already such as the Title Bar. Other parts might be unfamiliar, so let’s look at the parts of an Excel window.
Ribbon Tab
Formula Bar
Office 2007 Ribbon
Name Box Cells Active Cell Column Names
Row Names
Worksheet Tabs
Main Library Computer Learning Center
2
The Microsoft Office 2007 Ribbon
Microsoft Office 2007 uses a visual tool called the ribbon to display all of the commands that are used to edit a document. The ribbon uses two different visual elements: tabs and command groups.
1. Each tab contains a set of groups that share a theme in common. The Home tab, for example, contains all of the commands that are used most often by most people. 2. Within each tab are groups of command icons that share a common design
Class learning objectives
1. What is Excel? • Spreadsheet uses & samples • Touring the Excel window • Learning important definitions • Navigating around the workbook 2. The Basics • Entering & editing data in cells • Inserting cells, rows, & columns • Formatting cells • Renaming, adding, & reorganizing worksheets 3. Formulas • Using mathematical operators • Using four sum methods • AutoCalculate 4. Customizing Your Spreadsheet • Gridlines 5. Finishing Up • Using Excel’s help • More learning resources
Main Library Computer Learning Center
1
What is Excel?
Excel is a spreadsheet program that can be used to organize, manipulate and analyze data. Excel is often used in the workplace to track statistics, create sales reports, financial modeling, scientific engineering, and making charts and graphics. However, it can also be useful at home to create budgets or even make a list of family members’ birthdays. Excel is a versatile and powerful program with a lot to offer. The Excel Window When you first open up Excel you will see a blank sheet that looks a lot like a grid. If you have ever used other Microsoft programs such as Microsoft Word, you will recognize several parts already such as the Title Bar. Other parts might be unfamiliar, so let’s look at the parts of an Excel window.
Ribbon Tab
Formula Bar
Office 2007 Ribbon
Name Box Cells Active Cell Column Names
Row Names
Worksheet Tabs
Main Library Computer Learning Center
2
The Microsoft Office 2007 Ribbon
Microsoft Office 2007 uses a visual tool called the ribbon to display all of the commands that are used to edit a document. The ribbon uses two different visual elements: tabs and command groups.
1. Each tab contains a set of groups that share a theme in common. The Home tab, for example, contains all of the commands that are used most often by most people. 2. Within each tab are groups of command icons that share a common design