Discover Excel 2007 – Part I
- " rel="screenshots">
- " rel="screenshots">
アプリ情報詳細
Discover Excel 2007 is interactive multimedia training for users of Microsoft Office Excel 2007. The Discover products combine audio, animation, and software simulation to make the “discovery” of computer programs both effective and entertaining.
Discover Excel 2007 - Part I covers the following topics:
Introducing Excel 2007
• Office 2007 Overview
• Excel 2007 Overview
Screen Layout
• The Ribbon
• The Title Bar & Quick Access Toolbar
• The Office Button
Create & Open A WorkBook
• What Is A Workbook?
• Creating A New Workbook
• Use A Template
• Open An Existing Workbook
View A Workbook
• What Is A View?
• Use Page Layout View
• Page Break Preview
• Custom Views
• Show/Hide Options
• Zoom Command
• Splitting A Worksheet
• Freeze Rows & Columns
• View Workbooks Side By Side
• More Window Display Commands
Save A Workbook
• New Excel 2007 File Format
• Use The Save & Save As Commands
• Save A Workbook To Use In Earlier Versions Of Excel
File Compatibility
• Check Compatibility Between Excel Versions
• About File Converters
Print Workbooks
• Print Worksheets & Workbooks
• Modify Page Setup
Customize Excel [Expert]
• Excel Options
• Customize The Quick Access Toolbar
• Change Excel Options
Help in Excel 2007
• Microsoft Office Excel Help
• Working In The Excel Help Window
• Context Specific Help
• Office Diagnostics
Cell Basics
• What Is A Cell Reference?
• Select Cells
• Navigating A Worksheet
Enter Data
• Entering Data
• What Is A Value?
• What Is A Label?
Edit Data
• Edit Worksheet Data
• Find & Replace Data
Copy & Move Data
• Copying & Moving Data
• Copy & Move Data
• Use The Office Clipboard
Insert & Delete Cells
• Insert & Delete Cells
Modify A Worksheet
• Insert/Delete Rows & Columns
• About Resizing Rows & Columns
• Resize Rows & Columns
• Hide Rows & Columns
Modify A Workbook
• Insert & Delete A Worksheet
• Move/Copy A Worksheet To Another Workbook
• Rename A Worksheet
• Format Worksheet Tabs
Formulas
• What Is A Formula?
• Create A Formula
• Edit A Formula
Cell References
• Types Of Cell References
• Using Relative References
• Mixed References
Functions
• What Is A Function?
• Enter A Function Manually
• Insert A Function
• Use A Date Function
• Financial Functions
• Use A Financial Function
• Logical Functions
• Use A Logical Function
Work With Named Ranges
• Using Named Ranges
• Range Naming Rules
• Define A Range Name Using Labels
• Define Range Names For Data Without Labels
• Use A Named Range In A Formula
Use Lookup Functions [Expert]
• What Is A Lookup Function?
• The VLOOKUP Function
• Use The VLOOKUP Function
Find & Correct Errors [Expert]
• Auditing Worksheets
• Trace Errors
• Show Formulas
• Evaluate A Formula
• Use The Watch Window
Format Characters
• Formatting Text & Numbers
• Format Text
• Formatting Numbers
• Format Numbers
• Use A Custom Number Format
Format Cells
• Formatting Cells
• Aligning Cell Content
• Align Cell Content
• Merge Cells
• Apply Borders & Patterns
• Apply Color
• Format Painter
• Clear Cell Formatting
• Find & Replace Cell Formatting
• Cell Styles
Themes [Expert]
• Office 2007 Themes
Conditional Formatting [Expert]
• Conditional Formatting
• Apply Conditional Formatting
※アプリの紹介内容は掲載時のバージョンであり、画像および文言が現在と異なる場合がございます。