Show Me How To Use Excel 2003 & 2007
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!
- Windows 2000, XP, Vista
- Pentium 100MHz processor
- 16 MB of RAM
- 16 bit Color Screen
- Sound Card
- CD-ROM Drive
- Printer (optional)
