Microsoft Excel 2003 - Introduction by qlc15660

VIEWS: 29 PAGES: 6

More Info
									                                      This course is for people who are new to spreadsheet work, or who have not used a
Microsoft Excel 2003 - Introduction

                                      spreadsheet program designed for the Windows environment. The primary strength of a
                                      spreadsheet program is mathematical calculations. A spreadsheet program is used to
                                      prepare budgets, financial projections, and other reports arranged in rows and column.

                                      Microsoft Excel 2003 Introduction is a four-hour class.

                                      Prerequisites

                                             Introduction to Windows or equivalent experience

                                      Content

                                             Activate Microsoft Excel 2003
                                             Understand Excel 2003 window components
                                             Use Natural Language search to display topics from Excel Help
                                             Open a workbook and comprehend the workbook concept
                                             Insert and rename sheet tabs
                                             Select data and navigate in the worksheet
                                             Plan a worksheet
                                             Identify Data Types
                                             Enter data in a worksheet
                                             Change column width and row height
                                             Create and save a workbook
                                             Relative and absolute cell addresses
                                             Analyze formula syntax
                                             Write functions and formulas
                                             Use AutoSum and AutoCalculate
                                             Use AutoFill
                                             Develop simple mathematical functions
                                             Search for functions using natural language
                                             Create an expense worksheet
                                             Apply number formats to support worksheet data
                                             Align cell entries, apply text formats, and apply cell borders for visual clarity
                                             Edit cell entries
                                             Clear cell contents, comments, and formatting
                                             Undo and redo multiple actions
                                             Spell check a worksheet
                                             Insert and delete rows
                                             Carry out a keyboard shortcut to repeat editing functions
                                             Use the Office Clipboard to copy cell contents


                                      Phone:    602.266.1500                            Microsoft Excel 2003 Introduction
                                      Fax:      602.266.1555                               Website: www.trainingtoyou.com
                                                                                             e-mail: info@trainingtoyou.com
                                      Excel 2003 is a feature-rich worksheet program. As you learn more about Excel, you will
                                      notice that there are several ways to do most worksheet tasks. In this class, you will learn
                                      more efficient ways to use Excel. You will improve your formula writing skills.
Microsoft Excel 2003 - Intermediate


                                      This class will provide you with the tools you need to produce accurate, complex
                                      worksheets. You will learn to audit worksheets, protect and unprotect worksheet cells, and
                                      write IF statements. You will also use an Excel list or database to manage large lists. In
                                      Excel 2003, the list feature is refined and easy to use. You can type a large amount of data
                                      and sort and filter the data quickly to display or print only the data you need.

                                      Prerequisites

                                             Introduction to Windows or equivalent experience
                                             Microsoft Excel 2003 Introduction


                                      Content

                                         •   Use relative and absolute cell addresses
                                         •   Copy data to a predefined range
                                         •   Use Goal Seek
                                         •   Audit a worksheet
                                         •   Use comments in a worksheet
                                         •   Use AutoFill
                                         •   Use Dates in functions
                                         •   Use the TODAY function
                                         •   Use IF and OR functions
                                         •   Use the Insert Function Dialog Box
                                         •   Conditional Formatting
                                         •   Create Lists
                                         •   Use List Features
                                         •   Sort on one column or multiple columns
                                         •   Filter list data to select specific date
                                         •   Filter with custom criteria
                                         •   Advanced Filters
                                         •   Remove a filter
                                         •   Show all data in a list
                                         •   Use AutoFilter
                                         •   Use Subtotals
                                         •   Data Validation
                                         •   Wrap text within cells


                                      Phone:    602.266.1500                          Microsoft Excel 2003 Intermediate
                                      Fax:      602.266.1555                             Website: www.trainingtoyou.com
                                                                                           e-mail: info@trainingtoyou.com
Microsoft Excel 2003 Charting and Templates

                                              This class is for people who want to use Excel to prepare professional charts for business
                                              presentations and reports. In this class you will learn how Excel interprets worksheet data,
                                              and how Excel converts data into a ‘picture’ format. Although Excel has a Chart Wizard to
                                              help you create charts, you will probably need to customize charts to suit your own
                                              purposes. You will learn how Excel interprets your data, so that you can convey a clear,
                                              accurate graphic message.

                                              In addition to protecting worksheets and creating templates, this class also discusses Excels
                                              ability to Import and Export data to and from Excel, and queries an external database.

                                              Prerequisites

                                                     Introduction to Windows or equivalent experience
                                                     Microsoft Excel Introduction
                                                     Microsoft Excel Intermediate

                                              Content

                                                     Plan and create bar, column, line, and pie charts
                                                     Understand chart objects
                                                     Analyze worksheet data and choose the appropriate chart type
                                                     Understand how Excel plots data based on the shape of the selection area and the
                                                     contents of the selected cells
                                                     Use the Chart Wizard to embed a chart on an Excel worksheet
                                                     Create a chart on a separate chart sheet
                                                     Read series formulas that underlie charts
                                                     Size or move a chart or a chart object
                                                     Change chart types
                                                     Format charts to impove their appearance
                                                     Print charts
                                                     Print charts with the corresponding worksheet data
                                                     Protect a Worksheet
                                                     Create a User-Defined Chart
                                                     Save a User-Defined Chart as a Template
                                                     Create a Template
                                                     Use a Template to Create a Workbook
                                                     Import data into Excel
                                                     Export data from Excel into a text file
                                                     Query an External Database




                                              Phone:    602.266.1500                  Microsoft Excel 2003 Charting and Templates
                                              Fax:      602.266.1555                              Website: www.trainingtoyou.com
                                                                                                   e-mail: info@trainingtoyou.com
                                 This advanced level class focuses on data consolidation and data analysis. If you have
                                 multiple worksheets in a single workbook or multiple related workbooks, you probably
                                 need to accumulate and summarize data from various sources. The key to successful
                                 consolidation is accuracy. You need to link data sources so you have confidence in the
                                 results.
Consolidation and Pivot Tables



                                 If you have been creating your financial consolidations manually, you will be impressed
                                 with Excel’s summary and consolidation features. You have more control over your data
                                 than you think. Now is the time to divide those over-sized worksheets into smaller, more
                                 manageable units, and relate the individual unites to achieve over-sized results.
    Microsoft Excel 2003




                                 And finally, you will learn to customize your Excel workspace and customize the Excel
                                 startup procedures. Creating new toolbars and modifying existing toolbars allow for more
                                 efficient and effective production of worksheets.

                                 Prerequisites

                                        Windows Introduction or equivalent experience
                                        Microsoft Excel Introduction
                                        Microsoft Excel Intermediate

                                 Content

                                            Open multiple workbooks simultaneously
                                            Display parts of multiple workbooks on the desktop
                                            Copy and paste between workbooks
                                            Use copy and paste special
                                            Link data in multiple workbooks
                                            Write linking formulas
                                            Consolidate data based on its position in a worksheet
                                            Consolidate data based on data categories
                                            Outline worksheets to display or print various levels of worksheet detail
                                            Use Pivot Tables to summarize and analyze large banks of data
                                            Modify and expand a pivot table
                                            Customize your workspace
                                            Modify existing menus
                                            Create new toolbars
                                            Edit existing toolbars and Excel options




                                 Phone:    602.266.1500           Microsoft Excel2003 Consolidation and Pivot Tables
                                 Fax:      602.266.1555                             Website: www.trainingtoyou.com
                                                                                     e-mail: info@trainingtoyou.com
                                 Expand your knowledge base and round out your Excel 2003 education with this advanced
                                 course. In this course, you will learn how to use some of the more powerful advanced Excel
                                 functions in order to create the most efficient spreadsheets. If your goal is to become
Advanced Functions and Macros

                                 proficient at working with VLookups, Decision-Making, Financial, and Nested functions,
                                 you will be pleasantly surprised.
 Microsoft Office Excel 2003 -



                                 In addition to learning how to use the advanced functions in Excel, you will also be
                                 introduced to Macros. Macros are automation procedures that simplify complex Excel tasks
                                 and make Excel easy for novices to use. This class will guide you through the process of
                                 running and recording a macro, examining its VBA code, and adding those macros as
                                 buttons to your toolbars.

                                 Microsoft Office Excel 2003 Advanced Functions and Macros is a four-hour class.

                                 Prerequisites

                                        Introduction to Windows or equivalent experience
                                        Microsoft Office Excel 2003 Introduction
                                        Microsoft Office Excel 2003 Intermediate
                                        Microsoft Office Excel 2003 Consolidation and Pivot Tables

                                 Content

                                        Create and name range data to simplify use
                                        Use Names and Labels in functions
                                        Use text functions such as LEFT, RIGHT, and MID to extrapolate data based on
                                        position
                                        Use the CONCATENATE function to create strings of data based on specified
                                        criteria
                                        Work with Array Formulas to perform multiple calculations within one function
                                        Use Array Formulas to extrapolate data to calculate
                                        Use Decision-Making functions such as SUMIF to calculate data based on the
                                        evaluation
                                        of criteria in another data range
                                        Work with Nested functions such and IF, AND, and OR to analyze data based on
                                        multiple conditions
                                        Examine Financial functions such as the PMT and the IMPT function to calculate
                                        loan
                                        and interest payments
                                        Work with VLookups and Data Tables to find single or multiple values in a list



                                 Phone:    602.266.1500                Excel 2003 Advanced Functions & Macros
                                 Fax:      602.266.1555                         Website: www.trainingtoyou.com
                                                                                   e-mail: info@trainingtoyou.com
                                 Content   (continued)


                                      Use one and two variable data tables to calculate functions by modifying one or
                                      more
Advanced Functions and Macros

                                      arguments in a function
                                      Run and record a macro
 Microsoft Office Excel 2003 -



                                      Save macros in a Personal Workbook, the current workbook, or in a new workbook
                                      Examine and edit VBA code
                                      Copy VBA from one macro to another
                                      Assign a macro to the menu bar or to a toolbar button




                                 Phone:   602.266.1500             Excel 2003 Advanced Functions & Macros
                                 Fax:     602.266.1555                      Website: www.trainingtoyou.com
                                                                               e-mail: info@trainingtoyou.com

								
To top