Microsoft Office Excel 2007 Training Tutorials
Our Microsoft Office training will teach you to identify spreadsheet components, find help when required, work and manage workbooks, use templates and protect data. The Formulas, Functions, and Charts unit will show
you how to enter and work with formulas. You will also learn to use references, and create and modify charts. The Formatting Worksheets unit of this course will cover methods to format worksheets. It will take you
through the procedures to format text, rows, and columns. You will also learn to apply different styles, special formats, and format date and time styles. Additionally, you will learn to work with multiple
worksheets and link and manage workbooks. You will also learn to prepare and print a worksheet, and print multiple worksheets. Our more advanced training topics introduce you to the additional features and
functions. Learners will be able to demonstrate competence in using Excel to perform tasks such as working with built-in functions, presenting data, auditing and exporting data, and using analytical options and
macros.
Training Audience
The audience for this course consists of small office/home office (SOHO) users to all levels of business users. These users possess basic to intermediate PC skills and want to use Excel 2007 as a productivity tool.
They have a couple of years of experience using a PC and have limited or no experience with Excel.
Our Training Features
- Available in either Online ( One year unlimited access) or CBT CD
- Microsoft Authorized Training
- Used by 1000's of companies
- Includes interactive simulations to practice - MS Office 2007 software not required
- Printable transcripts of all lessons
- Review questions - to test ones understanding of the material
- Beginner to Advance Levels on Videos
Microsoft Excel Beginning Level
Getting Started
- Match basic features with their functions
- Recognize how to use the Help feature
- Create a new workbook in a given scenario
- Open an existing workbook
- Navigate through a workbook
- Enter data in a worksheet
- Save a new workbook in Excel 2007
- Distinguish between the common file formats used to save work
- Open an existing workbook
- Enter data in a workbook in a given scenario
- Save the workbook in a given scenario
- Open a recently used workbook and locate specific values
Manipulating and Formatting Data and Worksheets
- Copy or move data
- Add, delete, or resize rows and columns
- Modify rows and columns to view specific sections of the worksheet
- Format workbooks in given scenarios
- Insert and delete a worksheet
- Rename a worksheet and format the tab color
- Copy or move worksheets
- Modify cells and workbooks
- Modify worksheets to view specified data
- Copy and move data and worksheets in a given scenario
- Apply basic data formatting in Excel 2007
- Format a data range as a table
- Change the position of data in a cell i
- Function of Alignment commands
- Work with tables
- Format a data range as a table
- Modify a table
- Apply number formats
- Identify the number formatting options available
- Apply basic conditional formatting rules
- Recognize situations when conditional formatting is suitable
- Format data and apply conditional formatting
- Move data between workbooks and apply formats
Reviewing and Printing
- Use review tools in a given situation
- Work with comments
- The track changes tool
- Review a workbook in a given scenario
- Customize page setup using the Page Layout View
- Adjust page breaks using the Page Break Preview
- Print a worksheet in a given scenario
- Specify page set up options before printing a workbook
Formulas and Functions
- Elements of a formula
- Default order in which calculations occur
- Match absolute, relative, mixed, and 3-D references with examples
- Insert a formula
- Use names to clarify formulas
- Edit formulas in MS Excel
- Work with formulas in given scenarios
- Use the AutoCalculate feature to perform basic functions
- Logical function
- Financial function
- Date function
- Functions to perform calculations
- Formulas and functions to calculate data
Charts, Pictures, Themes, and Styles
- Insert a chart
- Identify the main elements of a chart
- Change charts
- Change the data range included in the chart
- Move a chart to a new worksheet
- Work with charts
- Insert illustrations
- Apply a theme to Office
- Apply a cell style
- Illustrations to enhance a worksheet
- Use a predefined theme and style to create a professional-looking worksheet
- Charts, illustrations, themes, and styles to improve the visual impact of your workbook
MS Excel 2007 Advanced Level
Advanced Formatting
- Format chart elements
- Chart Tools commands for customizing chart elements
- Save and apply a chart template
- Adjust formatting commands to modify a picture
- Recognize the commands for formatting a picture's style
- Format a picture's size and properties
- Format a chart
- Modify a picture
- Create a custom number format
- Codes for custom number formats
- Create a new conditional formatting rule
- Recognize how conditional formatting cell precedence works
- Find cells that have conditional formats
- Advanced conditional formatting rules
- Advanced formatting
Advanced Data Management
- Sort data
- Filter data in a range or table
- Group and outline data
- Insert subtotals in a worksheet
- Display different levels of data using outlines
- Outline data
- Filter and sort data
- Apply subtotals to data
- Organize worksheet data to facilitate data analysis
- Specify the data that is allowed in a particular range
- Recognize which error alert to use in given examples
- Locate and correct formula errors
- Watch Window to audit formulas
- Locate and correct formula errors
- Add data validation to prevent the errors from recurring
Advanced Customization
- Create a template
- New cell styles
- Customize themes
- Customize workbook settings
- Change the workbook properties
- Customize workbooks
- Record and run a macro
- Match macro security settings with their effects
- Edit and delete macros
- Assign a button to a macro and add it to the Quick Access Toolbar
- Create a macro and add it to the Quick Access Toolbar
MS Excel Power User Level
Analyzing Data
- Create a PivotTable report
- Rearrange PivotTable data
- Customize PivotTable reports
- Modify the look and feel of a PivotTable report
- Create a PivotChart report
- Modify a PivotChart report
- Perform calculations in PivotTables reports
- Recognize when to use each calculation type
- Create a PivotTable report
- Customize a PivotTable report
- Change the summary calculation in a PivotTable report
- Create a calculation with a formula
- Create a PivotChart
- Goal Seek to perform data analysis
- Solver to perform data analysis
- Create scenarios for what-if analysis
- Scenario Manager to modify scenarios
- Create a one-variable data table for data analysis
- Create a two-variable data table for data analysis
- Project values in a series
- Perform advanced functions
- Match advanced functions with examples of when you would use them
- Consolidate data from different workbooks using a Summary function
- Use Goal Seek
- Use Solver to perform what-if analysis
- Create a data table to perform what-if analysis
- Advanced functions and consolidate data
Protecting and Sharing Workbooks
- Protect a workbook in a given example
- Apply worksheet protection in a given example
- Identify the features of digital signatures
- Protect a workbook
- Prevent users from editing a workbook
- Apply worksheet protection
- Share workbooks on a network location
- Merge shared workbooks
- Publish a workbook to a SharePoint library
- Perform basic actions using SharePoint
- Share a workbook on a shared network resource
- Merge shared workbooks
- Publish a workbook to SharePoint
Exchanging Data
- Create links to data
- Identify how to import data
- Embed a file in a workbook
- Create database queries
- Import an entire Access table
- Import data into Access
- Copy data to Word
- Import data into Outlook
- Embed a file in a workbook
- Import data from a text file l
- Import data from a database
- Data in a Word document
- Retrieve data from an Access database using the Wizard
- Create a manual query to retrieve data from an Access database
- Identify how XML works in Excel
- Components of a basic XML system
- Create an XML map and map elements to it
- Import XML data
- Export XML data into mapped cells
- Use XML data with Excel 2007
|
