|
Provided by: 123-CBT Computer Based Training Excel XP Proficient Expert |
 |
DiscoverWare's a Discover Excel XP a ? is an interactive productivity tool for users of Microsoft Excel XP. Excel XP builds on the spreadsheet capabilities of previous versions of the program to provide powerful tools for creating and sharing professional worksheets online and on the Web. Topics cover basic spreadsheet concepts, workbook and file management, using formulas and functions, editing and formatting tools, working with graphics and charts, online collaboration, and working on the Web.
Excel XP/ 2002 (Proficient)
Excel XP Basics
Excel XP/ 2002 (Proficient)
Excel XP Basics
- Introducing Excel XP
- Excel XP Capabilities
- Screen Layout
- The Task Pane
- Title Bar, Menus & Toolbars
- Create & Open A Workbook
- What Is A Workbook?
- Creating A New Workbook
- Use A Template
- Open An Existing Workbook
- Save A Workbook
- Use The Save & Save As Commands
- Save A File For Use In Another Program
- View A Workbook
- Normal View
- Page Break Preview
- Create Custom Views
- Change Zoom Setting
- Split A Worksheet
- Freeze Rows & Columns
- Print Workbooks
- Print Worksheets & Workbooks
- Modify Page Setup
- Set Print Area
- Help In Excel XP
- Ask A Question
- Microsoft Excel Help
- Cell Basics
- What Is a Cell Reference?
- Select Cells
- Enter Data
- Entering Data
- What Is A Value?
- What Is A Label?
- Edit Data
- Edit Worksheet Data
- Find & Replace Data
- Use The Go To Command
- Copy & Move Data
- Copying & Moving Data
- Copy & Move Data
- Use The Office Clipboard
- Insert & Delete Cells
- Insert & Delete Cells
- Work With Subsets Of Data
- Use AutoFilter
- Modify A Worksheet
- Insert/Delete Rows & Columns
- Adjust Row & Column Size
- Hide Rows & Columns
- Modify A Workbook
- Insert/Delete A Worksheet
- Move A Worksheet To Another Workbook
- Rename A Worksheet
- Format Worksheet Tabs
- Link & Consolidate Data
- What Is A Link?
- Link Worksheets
- Use 3D References
- Format Characters
- Formatting Text & Numbers
- Format Text
- Number Formats
- Format Numbers
- Format Cells
- Aligning Cell Content
- Align Cell Content
- Merge Cells
- Clear Cell Formatting
- Apply Borders & Shading
- Find & Replace Cell Formatting
- AutoFormat
- Use AutoFormat
- Styles
- Styles In Excel XP
- Create & Apply A Style
- Add Graphics
- Graphics In Excel XP
- Insert Clip Art
- Add Charts
- What Is A Chart?
- Create A Chart
- Modify A Chart
- Print A Chart
- Formulas
- What Is A Formula?
- What Is Formula Syntax?
- Create A Formula
- Edit A Formula
- Cell References
- Types Of Cell References
- Use Relative References
- Use Absolute References
- Mixed References
- Functions
- What Is A Function?
- Get Help With Functions
- Enter A Function
- Use A Date Function
- Financial Functions
- Use A Financial Function
- Logical Functions
- Use A Logical Function
- Distribute Workbooks
- E-mail A Workbook
- Use Comments
- Add Comments To A Worksheet
- Excel XP & The Web
- What Is HTML?
- Save A Worksheet As A Web Page
- What Is A Hyperlink?
- Create
|
|
||||||
Training
Provided by 123-CBT Computer Based Training
Excel XP Proficient Expert
--
About The Training Provider: 123-CBT Computer Based Training
123-CBT Computer Based Training - 123-CBT offers discount pricing on top quality eLearning
programs from leading computer based training providers. Many of the training courses are available both online or on CD so that you can study at home at your own pace:
E-Learning available for
- ABAP 6. 10
- Access 2003
- Acrobat 6. 0
- ASP
- ASP. NET
- C
- Captivate 1. 0
- Crystal Reports 8. 5
- Crystal Reports v10
-...
