Overview

Full Product Details

Author:   Bill Jelen ,  Dwayne K. Dowell
Publisher:   Holy Macro! Books
Imprint:   Holy Macro! Books
Dimensions:   Width: 20.30cm , Height: 1.10cm , Length: 25.40cm
Weight:   0.371kg
ISBN:  

9781932802160

ISBN 10:   1932802169
Pages:   212
Publication Date:   01 October 2006
Audience:   General/trade ,  General
Format:   Paperback
Publisher's Status:   Active
Availability:   Awaiting stock  
The supplier is currently out of stock of this item. It will be ordered for you and placed on backorder. Once it does come back in stock, we will ship it out for you.

Table of Contents

# Copying a Worksheet # Showing Numbers in Thousands # Quickly Seeing Sum or Average - Better in XL 2007! # Adding Subtotals # Quickly Filling a Series # Using a Fixed Value in Your Formula # Replacing a Thousand Formulas with One # Highlighting Outliers # Using Conditional Formatting in Excel 2007 - Better in XL 2007! # Finding Transactions from the Last Week # Using Icon Sets to Mark Values # Excel Secrets: Applying Icons to Only the Top 10% # Turning Your Data on Its Side with Transpose - Better in XL 2007! # Joining Text # Looking up Data # Dealing with #N/A for Missing Values # When You Know There Is a Match but Excel Cannot Find It # Retrieving Many Columns from the Lookup Range # Getting Good Records from Bad Data # Sorting Your Data - Better in XL 2007 - Sort by Color! # Dealing with Dates # Fiscal Responsibility (Fiscal Years NOT Ending on 12/31) # Analyzing Data with Pivot Tables # Analyzing Results by Date # Creating a Random Sample from a Dataset # Finding and Analyzing Records Using AutoFilter # Formula Auditing # Matching Two Lists # Finding Duplicates or Unique Values - Better in XL 2007! # Finding Missing Dates in Data # Automating Excel with VBA # Conclusion # Index

Reviews

Author Information

Dwayne K. Dowell has over 20 years of experience inaccounting for public and private industries, and is the founder of Dwayne K. Dowell, PSC, a CPA firm located in Louisville, Kentucky. He isa Certified Public Accountant, Certified Fraud Examiner, and Certified Internal Auditor, as well asa Certified QuickBooks Pro Advisor and Certified Intact Consultant. Bill Jelen is the principal of MrExcel.com and the author of Mr. Excel on Excel and Guerilla Data Analysis Using Microsoft Excel. He lives in Uniontown, Ohio.

Tab Content 6

Author Website:  

Customer Reviews

Recent Reviews

No review item found!

Add your own review!

Countries Available

All regions