Learn Excel 2007 Overview - Basic Excel Training and Help

"Try My Product^® today for FREE*!"

If you are not happy with the lessons, just call to return one CD within 10 days and keep the other two CDs FREE* to avoid a purchase charge.

*Pay up to $9.95 USD for shipping & processing.

MEMBER LOGIN »

Search Tips

Back

With this Learn Microsoft^® Excel^® 2007 tutorial you will learn:

Your CDs will include all 3 versions!

Lesson One

Lesson Two

Lesson Three

Section 1 - Introduction
Section 2 - The Excel Environment
	Ribbon
	Contextual tabs
	Galleries
	Excel documents are called workbooks
	Each page is called a worksheet
	Title bar
	The standard Windows sizing tools
	Just below the title bar is the new user interface, known as the Ribbon
	The Ribbon's two levels of commands
	Contextual tabs group together commands
	The Office Button replaces the File menu from previous versions of Excel
	Instant access to tools on the Quick Access toolbar
	Customize the Quick Access toolbar
	Move the Quick Access toolbar below the Ribbon
	Minimize a workbook on the workspace
	Unlimited number of worksheets
	Moving around the worksheet using the Name box
	The formula bar is where we enter text, numbers and equations
	Using worksheet tabs to move through workbook
	Using scroll bars and scroll arrow to move throughout a workbook
	Opening the Status Bar Configuration menu
	Changing worksheet view buttons
	Identifying buttons and icons by mousing over them
		Normal view
		Page Layout view
		Page Break preview
	Zoom slider
	Multiple ways to access commands: the mouse or keyboard shortcuts
	The Ribbon's dialog box launcher icon
	Opening the gallery arrows
Section 3 - Creating a New Spreadsheet
	Icons on the formula bar
		Delete
		Confirm
		Insert Function button
	Function Wizard button (fx)
	Moving around the spreadsheet with Name box
	Labels defined
	Entering text labels
	Editing labels
	Long label defined
	Fill handle
	AutoFill feature
	Spell-checking a worksheet
	Adding words to AutoCorrect
	Adding words to Dictionary
Section 4 - Saving Files - Windows® XP
	When to save a document
	Save with the Office Button
	Save icon
	Save As dialog box
	Moving within the dialog box
	Create New Folder
	Change files and folders display views
	Save As Type option box for different formats
	Changing Excel options
	Changing AutoSave options
	Learning to save often
	Shortcut: Ctrl+S
	AutoRecover documents
Section 5 - Saving Files - Windows Vista®
	When to save a document
	Save with the Office button
	Save icon
	Save As dialog box
	Moving within the dialog box
	Create New Folder
	Change files and folders display views
	Save As Type option box for different formats
	Authors field while saving
	Adding tags while saving
	Saving in thumbnails
	Browse folders
	Changing View icons
	Changing Excel options
	Changing AutoSave options
	Learning to save often
	Shortcut: Ctrl+S
	AutoRecover documents
Section 6 - Formatting
	Formatting defined
	Bold, underline and italicize text
	Toggle switch defined
	Merge and Center features for titles
	Selecting a range of cells
	Selecting noncontiguous cells
	Shortcut: Ctrl+B
	Centering labels
	Opening tool tips
	Widening cells and columns
	Typing cell address in Name Box
	Shortcut: Ctrl+A to Select All
	Changing font name and size
	Preview feature in dialog box
	Formatting using Cell Styles
Section 7 - Working with Formulas
	Formula defined
	“What-if” scenarios defined
	Using the equal sign
	Sum function
	Functions vs. Formulas defined
	Outlining cell ranges
	Arguments in formulas defined
	Cell ranges defined
	Elements of a function formula
	Using the fill handles to copy formulas
	Function library
	Recently Used Function icon
	Formulas adjusting while copying
	Using the fill handle to copy formulas
	Copy and paste formulas using clipboard
	Shortcut: Ctrl+V to Paste
Section 8 - Entering Data
	Entering data
	Using Ctrl+Enter to enter an entire line
	Copying data between cells
	Add borders around cells
	Using the Formatting toolbar
	Currency icon
	Inserting row to worksheet
	Adjusting formulas for new row
	Adjusting amounts to make balance
	Using a “What-if” scenarios
Section 9 - Manipulating Worksheets
	Renaming worksheets
	Color coding worksheets
	Adding worksheets to workbooks
	Opening the Insert Worksheet dialog box
	Deleting worksheets
	Moving worksheets within workbooks
	Copying worksheets
	Renaming worksheets
	Adjusting scroll bars
	Navigation controls for worksheets
Section 10 - Printing
	Using the Print icon on the Quick Access toolbar
	Using the Office Button to print
	Print Preview option
	Making formatting adjustments in Print Preview
	Setting margins in Print Preview
	Centering the text on the page
	Portrait vs. Landscape
	Using the Scaling commands
	Add gridlines in Print Preview
	Zoom in and Zoom out
	Open Print dialog box
	Selecting printer
	Print range
	Printing the active sheet
	Printing multiple copies
	Collate pages
	Closing the document and application
	Opening the application
	Opening recent document

Section 1 - Introduction
Section 2 - Multiple Open Windows
	Open new window of same worksheet
	Using the Arrange dialog box
	Displaying different worksheets of same workbook
	Copying worksheet within a workbook
	Copying and moving cells between worksheets
	Saving with multiple worksheets open
	Rearranging worksheet open windows
	“What-If” analysis
	Open multiple workbooks
	Copying a worksheet to another workbook
Section 3 - Creating Charts
	Determining the chart type
	View gallery of chart type
	Using the Chart contextual tab for design
	Changing the data range
	Data series defined
	Select data source
	Changing chart from rows to columns
	Changing chart types
	Using chart layout tools
	Using chart styles
	Changing chart elements
	Setting up chart legend
	Using data labels tools
	Using gridlines tool
	Show data table on chart page
	Determining chart location
	Moving and resizing chart
Section 4 - Manipulating Chart Elements
	Elements of Chart
		Legend
		Plot area
		Chart title
		Vertical axis label
	Chart tips
	Format Axis Title dialog box
	Chart Tools contextual tab
	Selecting shape styles
	Live preview features
	Layout contextual tab
	Using best fit options
	Format data labels
	Controlling legend placement
	Add subtitle to chart
	Resizing pie chart elements
Section 5 - Conditional Formatting
	Merge and Center icon
	Shortcut to add current date into a cell
	Conditional formatting defined
	Using the conditional formatting tools
	Analyzing conditional formatting trends
	Determining variables
	Using Currency tool
	Using Borders icon to open Borders toolbar
Section 6 - Relative and Absolute
	Relative and Absolute cells defined
	Using the F4 key to make a cell absolute
	Comparing relative cell addresses to absolute cell addresses
	Cell errors to increase cell size
	Displaying totals on the status line
	Status bar line:
		Average
		Minimum / Maximum
		Sum
	Customize the status bar
Section 7 - Clipboard and Workspaces
	Arrange worksheets
	Changing data on a table affects chart
	Save Workspace command
	Opening a workspace arrangement from Office button
	Clipboard task pane
	Copying items to the clipboard
	Shortcut: Ctrl+C
Section 8 - The Bottom Line
	Pasting multiple items from clipboard
	AutoSum drop-down list and icons
	Using Chart gallery
	Dragging the entire chart
	Changing the background
	Activate gridlines
	Minor and major gridlines
	Reformatting labels
	Changing orientation of labels
	Formatting data series
	Changing color of data series
	Adding texture to data series
	Using charts to show relationship
	Charts linked to data to make changes easy
	“What-if” scenarios
Section 9 - Hiding Data and Cell Ranges
	Add headers and footers to worksheets
	Preprogrammed header and footer options
	Print Preview icon
	Portrait vs. Landscape
	Hiding data on the worksheets
	Unhide data
	Print selected area

Section 1 - Introduction
Section 2 - Database Basics
	Database defined
	Field or category of information
	Naming field uniquely
	Rows and columns defined
	Wrap text
	Records and fields defined
	Setting Data Validation option
	Data Validation dialog box
	Creating input message
	Deleting and hiding input message
Section 3 - Watch Cells and Parsing
	Range names defined
	Define a name range
	Named range box
	Using the range name in a formula
	Watch cell defined
	Setting up a watch cell
	Moving watch cell
	Formatting watch cell
	Using named range to move to worksheets
	Adding new columns
	Format Painter
	Splitting or parsing data into separate columns
	Convert Text to Column wizard
	Delimited Cells
	Setting data format in parsed cells
Section 4 - Sorting and Tables
	Selecting table styles
	Navigating through a data form
	Sort records in a field
	Setting up a sort key
	Ascending and descending sort
	Sort command
	Designating header row
	Primary sort keys
	Secondary sort keys
Section 5 - Advanced Formulas
	Blank rows in a database
	No blank rows between records
	Deleting rows
	If Logical Functions
	Values If Function Conditions
	Function Wizard
	Select Function category
	Logical Test function
	Functions argument window
	Error indicator
	Currency style format
Section 6 - Finding Records
	Find and replace features
	Data Form options
	Search Criteria mode
	Toggle between Form and Criteria mode
	Criteria defined
	Multiple Criteria Comparison operators defined
Section 7 - Modifying Data Tables
	Adding columns to data tables
	Reformatting new columns
	Copying using fill handles
	Fill handle options menu
	Copying data
	Format Painter button
	Freeze panes
Section 8 - Advanced Filters
	Filtering specific information within a table
	Creating a data filter
	Attaching AutoFilter to table
	Custom AutoFilter dialog box
		And/or operators
	Add subtotals using table styles
	Clearing filters
	Comparison list in filters
	Complicated queries
	Clear data filters


Your CDs will include all 3 versions!

Back

Video Professor, its logos, slogans and product feature names are trademarks and/or registered trademarks of Video Professor, Inc. in the U.S. and other countries. All other trademarks are the property of their respective owners, and the aforementioned entities neither endorse nor sponsor Video Professor or its products.