Topics:
Using Paste Special
-
Consolidating Data
-
Setting Up Automatic Subtotals
-
Grouping and Ungrouping Data
-
Converting Text to Columns
-
Documents
-
Validating Data
-
Using Pick Lists
-
Removing Duplicate Rows
-
Circling Invalid Data
-
Working with Templates
-
Using Hyperlinks
-
Saving Worksheets as HTML
-
Using Comments
-
Looking at Workgroup Functions
-
Protecting Your Workbook
-
Preparing for Distribution
-
What-If Analysis
-
Using the Goal Seeking Tool
-
Using the Solver
-
Using a Data Table
-
Using PivotTables
Target Audience
Anyone with basic computer skills, including, but not limited to:
- Accountants
- Bookkeepers
- Managers
- Administrators
- Teachers
- Business Analyst
|
After completing this course, you will be able to:
-
use AutoFill to copy or fill data
-
find and replace specific types of data
-
consolidate or summarize data
-
group or outline data
-
convert text to columns
-
use AutoFill to set up a series of data
-
find and replace data in a worksheet
-
use Paste Special to create different types of data
-
create groups and subtotals from the data in the worksheet
-
convert text to columnar formats
-
validate data and remove duplicate rows of data
|
One day hands-on Microsoft® Office Excel 2007 Advance class provides students the training on how to use some advanced features to work with different types of reports. Students will look at some productivity tools to increase data entry, features to enable collaboration with others, and use various commands to analyze large numerical reports.
Students who complete this course can be on their way to preparing for a Microsoft Certified Application Specialist exam.