| |
| |
Excel Tips & Tricks With Chuck Chauvin
.
. . . . . . . . . . . . . . . . . . . . . . . . . . . .
. . . . . . . . . . . . . . . . . . . . . . . . .
|
| |
| Become a More Powerful and Proficient Excel User in Just Minutes Per Month |
List Price: $150.00 |
| Your Price: $99.00 (USD) |
| Savings:
$51.00 |
| Length 2.5 hours |
| Item No. 3863 |
|
|
|
| |
Excel Tips & Tricks is a Web-based interactive training program that turns
a regular Excel user into a Power user in just minutes per month! With each subscription to Excel Tips & Tricks, users receive Chuck’s “Practice Notes” in an easy-to-use PDF document to reinforce and practice the material covered in each tip. And, users can download a copy of the same Excel file Chuck uses in each tip and follow along step-by-step to ensure complete understanding of the tip and immediate application to their own spreadsheets.
|
| |
Every two weeks, users get a new tip to:
- Enhance their productivity
- Save time by automating or avoiding repetitive tasks
- Make worksheets more useful and professional looking
- Improve worksheet and data security
- Utilize little known but incredibly powerful tools built in to Excel to
make working with data a snap
You’ll dazzle your coworkers with your Excel prowess.
Content:
Here is the complete list of 25 tips and tricks you get with this incredible resource:
Demo Tip – Split Data in One Column Into Two or More Columns
- Hide Error Indicators and Zeros
- Calculate Time and Date Differences
- Prevent and Control Duplicate Entries
- Create Dynamic Range Names That Automatically Adjust With New Data
- Compare Lists to Find New or Unique Entries
- Create a Conditional Sum With Specified Criteria
- Hide Rows, Columns or Formulas for Cleaner and More Secure Worksheets
- Automatically Bold Subtotals After Using the Subtotaling Feature
- Calculate a Weighted or Conditional Average With Specified Criteria
- Clean Up Imported Files by Filling Blanks and Converting Text to Dates
- Prevent Others From “Saving As” or Printing a Sensitive Workbook
- Highlight Every Other Row, Column, or Specified Data
- Customize Excel to Work Exactly as You Want
- Rearrange and Combine Data and Change the Case of Text
- Add a Calculated Percentage Field in a Pivot Table
- Copy Visible Cells Only and Protect Cells Containing Formulas
- Copy, Delete, and Customize Cell Comments
- Save Files Automatically When They Print
- Delete Numbers Only While Leaving All Text and Formulas Untouched
- Automatically Close and Save – Or NOT Save – All Open Workbooks
- Create and Assign a Custom Number Format to a Custom Button
- View Multiple Worksheets at The Same Time
- Create Custom Functions and Customize The Use of Range Names
- Create Custom Workbook Views
|
| |
Order online here on our secure
Web site, call us toll
free at 1-800-258-7246 or fax us at 1-913-432-0824.
|
|
100% Guarantee! |
|
Customer satisfaction is our
#1 priority. If you are not satisfied with your purchase
for any reason, return it to us within 60 days, and we
will refund your money in full! No questions asked. |
|
|
