Show Me How to Use Excel

Tutorial for Show Me Excel 2007 and Show Me Excel 2003

Tutorial for Show Me Excel 2007 and Show Me Excel 2003

Microsoft Excel is one of the most standard and widely used office products
in the world.

Learn Excel quickly and easily and give yourself the ability to manipulate
and present information like never before.

On-screen demonstrations from an expert make learning remarkably easy.

You'll be amazed at the difference this product can make in your work and your life.

Show Me How is a tutorial that will make you into a confident user of technology
without the hassle. 

See all the benefits of using Excel 2007 and 2003 and learn to do things
that you never thought were possible. 

You will experience the full impact of using Excel 2007 and 2003. 

This comprehensive training program is user friendly -
pick the topic you want to study, then sit back and watch as an expert shows you
how it's done.

• Getting Started - understanding the Excel window
• Mastering the Basics - creating opening and saving to protecting a file
  or worksheet
• Working with data - entering, setting and combining data
• Formatting Documents - Setting height and width, inserting columns and rows,
  selecting borders and styles
• Working with graphics - creating graphs, inserting pictures and printing charts

• Starting Excel
• Opening a default file
• Setting up a default folder
• The Excel window
• Keyboard shortcuts
• The online help
• Pop up menus
• Installation on request
• Automatic repair
• Office advanced clipboard
• Presentation
• Creating a new file
• Retrieving recently saved files
• Opening an existing file
• Saving a file
• Print preview
• Printing a file
• Adding a sheet in a workbook
• Hiding or displaying files
• Deleting a group of worksheets in a workbook
• Changing the order of worksheets in a workbook
• Sending faxes
• Creating e-mail messages
• Moving within a worksheet
• Setting a data entry range
• Cutting / pasting the contents of a cell
• Copying / pasting the contents of a cell
• Transposing data
• Deleting data in a worksheet
• Moving cells
• Jumping to a cell
• Finding items in a worksheet
• Replacing text
• Copying one or more cells
• Custom lists
• Data entry
• Correcting as you type
• Formulae
• Viewing formulae
• Numeral data series and dates
• Naming a range of cells
• Using the function assistant
• Auto calculation
• The Web components of Excel
• Deleting rows and columns
• Inserting rows and columns
• Deleting cells
• Inserting one or more cells
• Setting row height
• Setting column width
• Formatting numbers
• Alignment
• Centering across more columns
• Formatting characters
• Using borders
• Using patterns
• Auto Formatting
• Entering data in a block of cells
• Copying a format
• Clearing a format
• Creating and using styles
• Protecting a file
• Protecting a worksheet
• Adding comments
• Customized displays
• Freezing panes
• Outline mode
• Displaying toolbars
• Setting up the page
• Changing the margins
• Headers and footers
• Setting the print area
• The Drawing toolbar
• Inserting a picture
• Creating a database
• Adding records
• Searching for a record
• Modifying a record
• Deleting a record
• Sorting data
• Interrogating a database
• Customizing a filter
• Canceling a filter
• Setting a criteria range
• Using a criteria range
• Combining data
• Consolidating data
• Goal seek and solver
• The PivotTable wizard
• Creating a graph
• Changing a chart
• Printing a chart
• and much more!

• Work with Windows 2000, XP, Vista