Basic Excel For Business

Quantunet.com

My Account

Joins Us

Excel 2003 QuickSkills

Business Excel Curriculum Basic

Content Based Standards	Competency Based Standards
Getting Started Introduction to spreadsheets What is a spreadsheet Opening Excel The Excel environment and terminology The Excel window The Title bar The Menu bar The Tool bar The Formatting bar The Formula bar The Workbook window The Status bar The Task plane The Cell The Worksheet The Workbook Moving around in Excel A highlighted cell Selecting a cell Selecting a group of cells I Selecting a group of cells II Referencing a cell Rows and Columns Using the arrow keys Moving around a document with the arrow keys Using the vertical and horizontal sliders The Horizontal slider The Vertical slider Zooming in and out of the workbook Working with cells Entering text into cells Inserting and deleting columns and rows Performing calculations in excel Performing calculations in cells Addition Subtraction Multiplication Division Using the keyboard number pad Using auto sum on a range of cells The auto sum button Manipulating data Types of cell entries Entering data Using autofill index Autofill identical data Autofill patterned data Sorting data Alphabetically Numerically Ascending Descending Moving data Drag & Drop Copy Paste The undo action Using the spell-check feature in Excel Changing the language settings Working with wookbooks Create new workbooks Save workbooks Close workbooks Close multiple workbooks Open Excel files and workbooks	The Excel environment and terminology Understand the fundamental terms used to describe components in the excel spread sheet program Identify components in the excel graphical user interface Distinguish between a cell, worksheet and workbook Recognize the most common uses for spreadsheet programs Moving around Excel Competently move around an excel document using the mouse or keyboard Select cells and groups of cells using the mouse Working with cells Manipulating data
Assisted Practice Exercises Moving Around Excel Creating a new workbook
Practice Exercises
Worksheets Using The Correct Terminology I Entering Data Manipulating Data I	Worksheets Using The Correct Terminology I Locate named parts of the excel window Identify commonly used icons and tools Distinguish between instructions Left click Right click Scroll Drag mouse Moving Around Understand how to highlight a cell Appreciate the organization of cells in a workbook Know how to reference a cell in a workbook Understand how to highlight groups of cells Know how to reference groups (ranges of cells) Move around a worksheet with the keyboard Move around with the scroll bars Move around with the scroll wheel
Projects The Total Number of Items I	Projects The Total Number of Items I Enter information into an group of organized cells manually Use the auto sum button to find the total value of data in a group of cells Skills Used Entering data Moving around a document Using the autosum button Saving a document Purpose of project Demonstrate the primary function of excel to users Allow the user to practice acquired skills in a constructive multi part project Guide the user in the integration of new skills into a purpose driven set actions
Functions and Formulas I Performing calculations with data in cells Using cell references Using he equation bar Performing calculations of ranges of cells Formulas Using Formulas Creating formulas Editing formulas Editing the range of a formula Copy & pasting formulas to other cells Using autofill with formulas Auto-calculate Functions Functions and arguments Using built in functions The functions menu Inserting functions Using the autosum button The sum function The sum function AV Tutorial The average function The round function The max value function The min value function Absolute and relative referencing The difference between absolute and relative referencing The effect of absolute referencing on copying formulas Using logical conditions Creating IF statements
Assisted Practice Exercises
Practice Exercises
Worksheets Cell Referencing I Working with Formula I Absolute & Relative Referencing I Conditional Statements I Conditional Statements II
Projects Creating a Simple Budget
Formatting Spreadsheets I The formatting toolbar Showing the formatting toolbar Formatting cells Formatting cell dimensions Changing cell width Changing cell height Using auto fit Borders and shading Borders Thickness Color style Shading Color fill Formatting cell contents Index Formatting text Changing font Displaying symbols Changing text size Changing text color Formatting text style Bold Italics Underline Formatting numbers Percentages Commas Currency (Dollar signs) Formatting data in cells Dates Fractions Decimals Align cell contents Center Left Right Positioning text in a cell Top Middle Bottom Wrapping text in a cell Changing display orientation Vertical Horizontal Angled Copying formatting to other cells Formatting tables Using readymade formats The format menu Formatting the page view Center the worksheet on the page Changing page orientation Hide or display grid lines Formatting for printing Adding headers and footers on printed pages Preview page before printing Adding page breaks Printing Spread Sheets How to print preview Using the quick print command
Assisted Practice Exercises Changing text to bold Changing text to italics Changing text to underline Changing text alignment to center Changing text to left justified
Practice Exercises Formatting groups of cells
Worksheets Preparing Your Data Creating a Table of Data I Creating a Table of data II
Projects
Working with Workbooks I The workbook Moving around your workbook Selecting pages in your work book Adding worksheets Deleting worksheets Formatting worksheets Changing the color of worksheet tabs Manipulating worksheets in work books Moving data between worksheets Manipulating worksheets Moving worksheets Inserting new worksheets Deleting worksheets Copying worksheets Pasting worksheets Grouping worksheets How to group worksheets best practices Creating Multiple worksheet formulas Referencing cells in different worksheets Referencing ranges in different worksheets Collaborating with coworkers Password protect from making changes Protecting specific cells in a workbook Sharing workbooks with other users Hiding formulas or data from view Hiding worksheets Printing Printing workbooks Printing worksheets within a workbook
Assisted Practice Exercises
Practice Exercises
Worksheets
Projects
Working with Charts I Creating a chart in a spreadsheet Creating a chart from a table Organizing your data Selecting data for charting Select your chart type Choose a series Format your graph Embedding the chart in a worksheet Creating a new worksheet for a chart Using the chart wizard Formatting charts Changing the title Changing the axis labels Changing the color of the chart graphic Changing the chart legend Resizing the legend Removing elements from the legend Changing the chart area properties Adding grid lines Editing grid lines Creating custom chart types form later use Create overlay charts (one on top of the other)
Assisted Practice Exercises
Practice Exercises
Worksheets
Projects