|
Training
Materials for:
Windows Vista
Windows XP
Microsoft Word 2007
Microsoft Excel 2007
PowerPoint 2007
Microsoft Access 2007
Internet
Explorer 7
Outlook 2007
Expression Web
Microsoft Project
Microsoft Publisher
Microsoft FrontPage
Microsoft Visio
Computer
Concepts
ECDL / ICDL
Downloads
PLUS MANY MORE ...
|
Microsoft Excel 2007 Intermediate Level
Training Courseware Materials for Office 2007
Training Course Outline.
EXCEL 2007 - MANIPULATING DATA, NAMED RANGES & TEMPLATES
- Paste Special Techniques
- Importing a text file and delimiting
EXCEL 2007 - TEMPLATES
- Using, creating, opening and editing templates
EXCEL 2007 - NAMED RANGES
- What does naming a cell range mean?
- Rules for naming cells and ranges
- Naming cell range(s) in a worksheet
- Navigating through workbooks using named ranges
- Creating named ranges automatically based on cell values
EXCEL 2007 - SUB-TOTALING
- Creating subtotals
- Removing subtotals
EXCEL 2007 - ADVANCED FORMATTING & DISPLAY TECHNIQUES
- Cell Styles
- Table Styles
- Conditional Formatting
- Custom number formats
- Freezing row and column titles
- Hiding and un-hiding rows and columns
- Hiding / un-hiding worksheets
EXCEL 2007 - SORTING AND QUERYING DATA
- Sorting data by multiple columns
- Custom sorts
- Using AutoFilter
- Using advanced query / filter options
EXCEL 2007 - LINKING & EMBEDDING DATA
- Linking data or a chart within a worksheet
- Linking data or a chart between worksheets [within a workbook]
- Linking data or a chart between spreadsheets [workbooks]
- Linking data or a chart into a word processing document
- Consolidating data in adjacent worksheets using a 3D sum function
EXCEL 2007 - CHARTS FORMATTING TECHNIQUES
- Changing pie slide angles
- Formatting chart axis fonts and scales
- Chart title
- Chart legend
- Modifying a data series in a chart
EXCEL 2007 - WORKBOOK PASSWORD PROTECTION
- Password for opening a workbook
- Read-only recommended
EXCEL 2007 - PROTECTING / UN-PROTECTING WORKSHEETS
- Protect worksheet elements
- Removing workbook protection
EXCEL 2007 - FUNCTIONS
- Getting help with using a particular function.
- TODAY
- DAY
- MONTH
- YEAR
- SUMIF
- ROUND
- COUNT
- COUNTA
- COUNTIF
- PROPER
- UPPER
- LOWER
- CONCATENATE
- FV
- NPV
- PMT
- PV
- RATE
- HLOOKUP
- VLOOKUP
- IF
- AND
- OR
- ISERROR
- DSUM
- DMIN
- DMAX
- DCOUNT
- Using nested functions
USING ONE-INPUT OR TWO-INPUT DATA TABLES / WHAT-IF TABLES
- One input Data Table command
- two input data table command
EXCEL 2007 - A FIRST LOOK AT PIVOT TABLES
- Creating a PivotTable
- Dropping data into the Pivot Table
- Modifying data and refreshing the Pivot Table
- grouping data within a Pivot table
EXCEL 2007 - SCENARIOS
- Creating named Scenarios from defined cell ranges
- Viewing an alternative scenario
- Creating a scenario summary
EXCEL 2007 - AUDITING
- Tracing precedent cells
- Tracing dependants of a cell
- Displaying all formulas within a worksheet
- Using comment
EXCEL 2007 - MACROS
- Displaying the Developer tab
- Recording and running a macro
- Lowering your macro security level
- Customising the Quick Access Toolbar
- Changing the Quick Toolbar Macro icon
- Removing a macro icon from the quick access toolbar
- Raising your macro security level
Other Microsoft Office 2007 Courseware materials
|
