S05.Excel2010 - Excel 2010 Microsoft Excel 2010 is a...

Info iconThis preview shows pages 1–8. Sign up to view the full content.

View Full Document Right Arrow Icon
Microsoft Excel 2010 is a spreadsheet application that is ideal for collecting, analyzing, reporting, and sharing both qualitative and quantitative data and information. Everything from personal household budgets to large corporate financial plans are created and used in Excel every day around the world. The Excel 2010 Skills > Excel 2010 In this section: Overview of Spreadsheets Cells and Cell Data Formulas Functions Formatting Spreadsheets Spreadsheet Graphics Advanced Spreadsheet Tools
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
In these Excel lessons, you’ll learn what types of situations are best suited for using spreadsheets, and how to structure your own spreadsheets for easier and faster data analysis when changes are required. Overview of Spreadsheets Skills > Excel 2010 > Overview of Spreadsheets In this section: Spreadsheet Tools and Features Well-Formed Spreadsheets Spreadsheet Uses
Background image of page 2
Spreadsheet Tools and Features Skills > Excel 2010 > Overview of Spreadsheets > Spreadsheet Tools and Features A worksheet is essentially a grid, with rows and columns. Rows are numbered , starting with 1. Columns are named with letters , starting with A. The intersection of a row and column is called a cell, and is referred to by its column and row intersection. The tools on the Formula tab allow you to use pre-made functions to generate formulas efficiently and accurately. The Insert tab contains tools for displaying information graphically through illustrations, charts, and sparklines, a type of mini-chart within a cell. On the Home tab, you’ll find tools that enhance worksheet formatting, with various number formats and styles.
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Spreadsheet Tools and Features Skills > Excel 2010 > Overview of Spreadsheets > Spreadsheet Tools and Features Intersection of a row and column is a cell Cell E6
Background image of page 4
Well-Formed Spreadsheets Skills > Excel 2010 > Overview of Spreadsheets > Well-Formed Spreadsheets Well-formed spreadsheets are neatly organized and properly formatted to help support financial reporting and decision making. There are four steps to planning a spreadsheet: 1. Identify the problem 2. Gather the relevant data 3. Determine the needed calculations 4. Prepare an easy-to-read design
Background image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Spreadsheet Uses Skills > Excel 2010 > Overview of Spreadsheets > Spreadsheet Uses Spreadsheets are best suited for decisions that need quantitative support. In a business situation, the most common types of spreadsheets include: Financial statements Budgets Inventory management reports Sales reports Financial decision support Personal and academic uses for spreadsheets include: Home budgets School grade books Investment portfolios
Background image of page 6
Cells and Cell Data Skills > Excel 2010 > Cells and Cell Data In this section: Creating and Editing Spreadsheets Selecting Objects Entering and Editing Data Adjusting Rows and Columns Grouping Rows and Columns Copying Cell Data Using the Fill Handle
Background image of page 7

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 8
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 57

S05.Excel2010 - Excel 2010 Microsoft Excel 2010 is a...

This preview shows document pages 1 - 8. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online