Learning Excel 2003 Overview - Excel Formula and Function Tutorial

With this Learn Excel^® 2003 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 Task pane Title bar Minimize/Maximize/Close buttons Menu bar Intelligent menus Using the Customize dialog box Turn off Intelligent menus Selecting toolbars to appear on screen Name box on Formula bar Standard toolbar commands Permission icon and feature Zoom in and out feature Formatting toolbar Docketing vs. Floating toolbars Adding additional buttons to toolbar Office Assistant Opening worksheets in workbooks Moving between worksheets Status bar Section 3 - Creating a New Spreadsheet Icons on the formula bar Delete Confirm Insert Function button Moving around the spreadsheet with name box Entering text labels Editing labels Fill handle AutoFill feature Spell-check labels Adding words to AutoCorrect Adding words to Dictionary Section 4 - Saving Files Save icon Save As dialog box Moving within the dialog box Create new folder Change files and folders display views Save as Type option Changing AutoSave options Learning to save often Shortcuts: (Control+S) to Save AutoRecover documents Section 5 - Formatting Bold, underline, and italicize text Center and merge titles Selecting a range of cells Selecting noncontiguous cells Shortcut: (Control+B) for bold Widening cells and columns Centering labels Typing cell address in name box Shortcut: (Control+A) to Select All Changing font name and size TrueType fonts Section 6 - Working with Formulas Formula defined "What-if" scenario defined Using the equal sign Sum function Functions vs. formulas defined Outlining cell ranges Elements of a function formula Arguments in formulas defined Using the fill handle to copy formulas Formulas adjusting while copying Copy and paste formulas using Clipboard Section 7 - Entering Data Entering data Right aligned numbers and left aligned text 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 Section 8 - Manipulating Worksheets Renaming worksheets Color coding worksheets Changing default setting of number of sheets Adding worksheets to workbooks Deleted worksheets Moving worksheets within workbooks Copying worksheets Renaming worksheets Adjusting scroll bars Navigation controls for worksheets Section 9 - Printing Print preview Making formatting adjustments in print preview Setting margin in print preview 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	Section 1 - Introduction Section 2 - Multiple Open Windows Open new window of same worksheet Using the Arrange dialog box Show 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 Using the Chart Wizard Determining the chart type View sample of chart type Changing the data range Data series defined Changing chart from rows to columns Setting up chart title X axis and Y axis Changing gridlines Setting up chart legend Including labels on chart elements 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 Z-Axis label Chart tips Format Elements dialog box Change elements alignment Change element orientation Select noncontiguous cells for charting Adding data labels Add subtitle to chart Resizing pie chart elements Using the Chart toolbar Section 5 - Conditional Formatting Merge cells icon Shortcut: (Ctrl+;) to add date Conditional formatting defined Using the Conditional Formatting dialog box Analyzing conditional formatting trends Determining variables Using Currency icon Using Borders icon to open Borders toolbar Changing colors of borders Fill handle to fill quarters 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 Section 7 - Clipboard and Workspaces Arrange worksheets Changing data on a table affects chart Save workspace command Saving workspace document Clipboard Task Pane Copying items to the clipboard Shortcut: (Ctrl+C) for copy Section 8 - The Bottom Line Pasting multiple items from Clipboard AutoSum icon Create custom charts 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 Format Cell dialog box Wrap text Record defined Rows and columns Setting data validation Data Validation dialog box Creating input message Setting Error Alert tab Deleting and hiding input message Section 3 - Watch Cells and Parsing Range Names defined Named range box Using the range name in a formula Watch cell defined Setting up a watch cell Moving a watch cell Formatting a watch cell Using named range to move to worksheets Adding new columns Format Painter Splitting or "Parsing" data into separate columns Delimited cells Setting data format in parsed cells Parsing Cell Wizard Section 4 - Forms and Sorting Setting up data form Navigating through a data form Adding a new record in 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 function Values IF function conditions Function Wizard Select function category Logical Test function Error indicator Creating formula without wizard Currency style format Section 6 - Finding Records 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 Setting lodged heading lines Section 8 - Queries Select specific information within a table Creating a data filter Attaching AutoFilter to table Custom Autofilter dialog box 'AND' 'OR' operators Add subtotals into queries 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.