Fully Customizable Courseware For Trainers
Microsoft Office Excel 2007: Intermediate
Deliver high-impact training with professionally designed, fully editable courseware you can brand, customize, and deliver in-person or online
$795.00
Are you ready to learn additional skills in our Microsoft Office Excel 2007: Intermediate training materials?
If you understand the program foundations, it makes sense to learn more skills. It will improve your efficiency.
Are you an instructor?Are you sure that your students want to improve their skills? Instructors all over the world have been using our pre-written, customizable training material and courseware since 1998.
There is a lot to learn. Here are just a few of the topics and lessons covered in this Microsoft Office Excel 2007: Intermediate courseware:
- Opening a Template
- Understanding Relative and Absolute Cell References
- Basic Mathematical Operators
- Finding the Right Function
- Using the IF Function
- Selecting Nonadjacent Ranges
- Using Functions with Array Formulas
- Using the IF function in Array Formulas
- Creating Tables
- Quickly Adding Records to a Data table
- Using an Advanced Filter
- What are Database Functions?
- Incorporating Text
- Adding a Signature Line
- Changing the Outline Color
- Inserting a Photographic Image
- Protecting your Worksheets
- Modifying Excel Data after Insertion
- Importing Data from a Text File
- Importing Data from External Data Sources
And many more topics!
Our Microsoft Office Excel 2007: Intermediate courseware is fully customizable so the instructor can add whatever content they deem necessary (or take away whatever is not).
Section 1: Advanced File Tasks
Lesson 1.1: Using My Computer within Excel
Using the My Places Toolbar
Navigating with My Computer
Performing Basic Tasks with My Computer
Changing Views
Step-By-Step
Skill Sharpener
Lesson 1.2: Saving your Files
File Formats
File Properties
AutoRecover
Upgrading a Workbook
Step-By-Step
Skill Sharpener
Lesson 1.3: Using Templates
Opening a Template
Downloading a Template
Using a Template
Creating a Template
Step-By-Step
Skill Sharpener
Section 1: Case Study
Section 1: Review Questions
Section 2: Working with Functions and Formulas
Lesson 2.1: Using Formulas in Excel
Understanding Relative and Absolute Cell References
Basic Mathematical Operators
Using Formulas with Multiple Cell References
The Formula Auditing Buttons
Fixing Formula Errors
Displaying and Printing Formulas
Step-By-Step
Skill Sharpener
Lesson 2.2: Exploring Excel Functions
What are Functions?
Finding the Right Function
Some Useful and Simple Functions
Step-By-Step
Skill Sharpener
Lesson 2.3: Using Functions in Excel
Inserting Functions
Using Functions and AutoFill to Perform Difficult Calculations
Using the IF Function
Working with Nested Functions
Step-By-Step
Skill Sharpener
Lesson 2.4: Working with Names and Ranges
What Are Range Names?
Defining and Using Range Names
Selecting Nonadjacent Ranges
Using AutoCalculate
Step-By-Step
Skill Sharpener
Lesson 2.5: Working with Array Formulas
What are Array Formulas?
Using Basic Array Formulas
Using Functions with Array Formulas
Using the IF function in Array Formulas
Step-By-Step
Skill Sharpener
Section 2: Case Study
Section 2: Review Questions
Section 3: Managing Tables
Lesson 3.1: Working with Tables
What is a Table?
Creating Tables
Modifying Tables
What is the Total Row?
Step-By-Step
Skill Sharpener
Lesson 3.2: Working with Records and Fields
What are Records and Fields?
Adding Fields by Inserting Columns
Adding Records by Inserting Rows
Quickly Adding Records to a Data table
Deleting Records or Fields
Step-By-Step
Skill Sharpener
Lesson 3.3: Working with Tables and Filters
Sorting Data in a Table
What is an AutoFilter?
Custom AutoFilters
Using an Advanced Filter
Copying Filtered Records
Step-By-Step
Skill Sharpener
Lesson 3.4: Using Excel as a Database
Filtering with Wildcard Characters
Validating Your Data
What are Database Functions?
Step-By-Step
Skill Sharpener
Section 3: Case Study
Section 3: Review Questions
Section 4: Enhancing your Workbook
Lesson 4.1: Customizing your Workbook
Inserting a Symbol or Special Character
Adding and Editing Shapes
Creating and Altering Diagrams
Changing the Diagram Type
Incorporating Text
Adding a Signature Line
Step-By-Step
Skill Sharpener
Lesson 4.2: Working with Text Boxes
Adding a Text Box
Selecting a Text Box
Manipulating a Text Box
Formatting a Text Box
Step-By-Step
Skill Sharpener
Lesson 4.3: WordArt
Adding WordArt to your Spreadsheet
Changing the Font Color
Changing the Outline Color
Adding Effects
Step-By-Step
Skill Sharpener
Lesson 4.4: ClipArt
Finding ClipArt
Inserting ClipArt
Manipulating ClipArt
Inserting a Photographic Image
Step-By-Step
Skill Sharpener
Lesson 4.5: Using Objects
Creating New Embedded Objects
Embedding Existing Files
Editing Embedded Objects
Embedding Parts of Files
Step-By-Step
Skill Sharpener
Section 4: Case Study
Section 4: Review Questions
Section 5: Finalizing Your Workbook
Lesson 5.1: Protecting your Workbook
Protecting your Workbook
Protecting your Worksheets
Unlocking Cells
Protecting your Excel Files
Step-By-Step
Skill Sharpener
Lesson 5.2: Finishing Your Workbook
Using the Document Inspector
Using the Compatibility Checker
Marking a Workbook as Final
Step-By-Step
Skill Sharpener
Lesson 5.3: Using Excel in Word
Inserting Excel Data in Word
Linking Excel Data in a Word Document
Modifying Excel Data after Insertion
Insert an Excel Chart into a Word Document
Step-By-Step
Skill Sharpener
Lesson 5.4: Using Excel and Access
Linking an Excel Workbook to an Access Database
Importing Table, PivotTable, and PivotChart Data from Access
Transforming an Excel Workbook into an Access Database
Step-By-Step
Skill Sharpener
Lesson 5.5: Using Excel With other Programs and Files
Using Outlook to Send Excel Data
Opening an Excel File in a Different Format
Importing Data from a Text File
Importing Data from External Data Sources
Publishing a Workbook as a PDF File
Faxing a Workbook
Step-By-Step
Skill Sharpener
Section 5: Case Study
Section 5: Review Questions
Index
 Select the format that works best for your organization or learners
Instructor-Led Training Kits
Complete training kit with everything you need to facilitate.
- Instructor Guide
- Participant Manual
- PowerPoint Slides
- Print-Ready Files
- Editable in Word/PowerPoint
- More
SCORM eLearning Courses
Ready-to-deploy eLearning for any SCORM-compliant LMS.
- SCORM 1.2 Package
- LMS Compatible
- Completion Certificates
- Progress Tracking
- Mobile Responsive
Storyline Source Files
Editable .story files for full customization in Articulate 360.
- Editable Source Files
- Articulate 360 Format
- Brand Customization
- Content Editing
- Interactive Elements
c0102i
What You Get
Fully Customizable
Make any changes you like including easily taking our branding off and replacing it with yours.
Unlimited Users
Train as many participants at your location as you like - forever!
Unlimited Printing Rights
Print-on-demand only what you need for as many participants with no limits.
No Annual Renewal Fees
One-off pricing. Never pay again to use the materials.
Fully Customizable
Make any changes you like including easily taking our branding off and replacing it with yours.
Unlimited Users
Train as many participants at your location as you like - forever!
Unlimited Printing Rights
Print-on-demand only what you need for as many participants with no limits.
No Annual Renewal Fees
One-off pricing. Never pay again to use the materials.