All About CLAiT Plus Using Microsoft Excel 2007
Home > Computing and Information Technology > Business applications > Spreadsheet software > All About CLAiT Plus Using Microsoft Excel 2007: For CLAiT 2006
All About CLAiT Plus Using Microsoft Excel 2007: For CLAiT 2006

All About CLAiT Plus Using Microsoft Excel 2007: For CLAiT 2006


     0     
5
4
3
2
1



Out of Stock


Notify me when this book is in stock
X
About the Book

Table of Contents:
COMMA-SEPARATED VALUE DATAFILES 1 SAVING DATA IN EXCEL 2 WRAPPING CELL CONTENTS 4 MERGING CELLS 6 ADDING BORDERS 8 ADDING SHADING 10 FORMATTING TEXT 12 CHANGING FONT SIZE AND TYPE FACE 12 ALIGNING DATA 13 TEXT ORIENTATION 14 INSERTING ROWS AND COLUMNS 16 DELETING ROWS AND COLUMNS 17 FORMATTING DATA 19 CURRENCY FORMAT 19 NUMBER FORMAT 21 PERCENTAGE FORMAT 22 DATE FORMATS 23 CREATING FORMULAS 25 USING THE FORMULA WIZARD 25 OTHER FORMULAE - SIMPLE CALCULATIONS 29 FORMULAE - PRECEDENCE OF OPERATORS 30 COPYING FORMULAE 31 USING NAMED CELLS 32 ABSOLUTE AND MIXED CELL REFERENCES 36 THE COUNT FUNCTION 37 THE COUNTA FUNCTION 41 THE MAX FUNCTION 42 THE MIN FUNCTION 43 THE AVERAGE FUNCTION 44 CREATING IF FUNCTIONS 45 THE EFFECT OF PRECISION ON CALCULATIONS 49 THE SUMIF FUNCTION 50 THE COUNTIF FUNCTION 52 HIDING AND UNHIDING COLUMNS AND ROWS 54 DISPLAYING FORMULAE 58 ADJUSTING COLUMN WIDTH AND ROW HEIGHT 59 PAGE LAYOUT 60 HEADERS AND FOOTERS 61 SETTING PRINT AREA 63 ADDING GRIDLINES AND ROW/COLUMN HEADINGS 64 USING PAGE BREAKS AND FITTING TO PAGES 65 SORTING DATA 68 FILTERING DATA 70 LINKING FORMULAS ACROSS WORKSHEET AND WORKBOOKS 73 CREATING GRAPHS 78 A SIMPLE COMPARATIVE COLUMN CHART 78 LABELLING DATA POINTS 84 FORMATTING GRAPHS 85 FORMATTING AXES 86 SCALE MAX & MIN 86 AXIS NUMBER FORMAT 89 ALIGNING AXIS LABELS 91 FORMATTING THE CHART TITLE AND AXIS LABELS 92 FORMATTING THE LEGEND 93 CHANGING THE CHART TYPE - LINE/COLUMN GRAPHS 93 PIE CHARTS 98 ROTATING PIE CHARTS 104 XY SCATTER CHARTS 106 ADDING TEXT BOXES TO CHARTS 110 PRINTING CHARTS 114

About the Author :
Andrea Jones has been teaching the CLAiT qualification for about 20 years and has delivered all levels to Advanced.


Best Sellers


Product Details
  • ISBN-13: 9781905535491
  • Publisher: All about Resources
  • Publisher Imprint: All About Resources
  • Height: 297 mm
  • Sub Title: For CLAiT 2006
  • ISBN-10: 190553549X
  • Publisher Date: 10 Apr 2007
  • Binding: Spiral bound
  • Spine Width: 11 mm
  • Width: 210 mm


Similar Products

Add Photo
Add Photo

Customer Reviews

REVIEWS      0     
Click Here To Be The First to Review this Product
All About CLAiT Plus Using Microsoft Excel 2007: For CLAiT 2006
All about Resources -
All About CLAiT Plus Using Microsoft Excel 2007: For CLAiT 2006
Writing guidlines
We want to publish your review, so please:
  • keep your review on the product. Review's that defame author's character will be rejected.
  • Keep your review focused on the product.
  • Avoid writing about customer service. contact us instead if you have issue requiring immediate attention.
  • Refrain from mentioning competitors or the specific price you paid for the product.
  • Do not include any personally identifiable information, such as full names.

All About CLAiT Plus Using Microsoft Excel 2007: For CLAiT 2006

Required fields are marked with *

Review Title*
Review
    Add Photo Add up to 6 photos
    Would you recommend this product to a friend?
    Tag this Book Read more
    Does your review contain spoilers?
    What type of reader best describes you?
    I agree to the terms & conditions
    You may receive emails regarding this submission. Any emails will include the ability to opt-out of future communications.

    CUSTOMER RATINGS AND REVIEWS AND QUESTIONS AND ANSWERS TERMS OF USE

    These Terms of Use govern your conduct associated with the Customer Ratings and Reviews and/or Questions and Answers service offered by Bookswagon (the "CRR Service").


    By submitting any content to Bookswagon, you guarantee that:
    • You are the sole author and owner of the intellectual property rights in the content;
    • All "moral rights" that you may have in such content have been voluntarily waived by you;
    • All content that you post is accurate;
    • You are at least 13 years old;
    • Use of the content you supply does not violate these Terms of Use and will not cause injury to any person or entity.
    You further agree that you may not submit any content:
    • That is known by you to be false, inaccurate or misleading;
    • That infringes any third party's copyright, patent, trademark, trade secret or other proprietary rights or rights of publicity or privacy;
    • That violates any law, statute, ordinance or regulation (including, but not limited to, those governing, consumer protection, unfair competition, anti-discrimination or false advertising);
    • That is, or may reasonably be considered to be, defamatory, libelous, hateful, racially or religiously biased or offensive, unlawfully threatening or unlawfully harassing to any individual, partnership or corporation;
    • For which you were compensated or granted any consideration by any unapproved third party;
    • That includes any information that references other websites, addresses, email addresses, contact information or phone numbers;
    • That contains any computer viruses, worms or other potentially damaging computer programs or files.
    You agree to indemnify and hold Bookswagon (and its officers, directors, agents, subsidiaries, joint ventures, employees and third-party service providers, including but not limited to Bazaarvoice, Inc.), harmless from all claims, demands, and damages (actual and consequential) of every kind and nature, known and unknown including reasonable attorneys' fees, arising out of a breach of your representations and warranties set forth above, or your violation of any law or the rights of a third party.


    For any content that you submit, you grant Bookswagon a perpetual, irrevocable, royalty-free, transferable right and license to use, copy, modify, delete in its entirety, adapt, publish, translate, create derivative works from and/or sell, transfer, and/or distribute such content and/or incorporate such content into any form, medium or technology throughout the world without compensation to you. Additionally,  Bookswagon may transfer or share any personal information that you submit with its third-party service providers, including but not limited to Bazaarvoice, Inc. in accordance with  Privacy Policy


    All content that you submit may be used at Bookswagon's sole discretion. Bookswagon reserves the right to change, condense, withhold publication, remove or delete any content on Bookswagon's website that Bookswagon deems, in its sole discretion, to violate the content guidelines or any other provision of these Terms of Use.  Bookswagon does not guarantee that you will have any recourse through Bookswagon to edit or delete any content you have submitted. Ratings and written comments are generally posted within two to four business days. However, Bookswagon reserves the right to remove or to refuse to post any submission to the extent authorized by law. You acknowledge that you, not Bookswagon, are responsible for the contents of your submission. None of the content that you submit shall be subject to any obligation of confidence on the part of Bookswagon, its agents, subsidiaries, affiliates, partners or third party service providers (including but not limited to Bazaarvoice, Inc.)and their respective directors, officers and employees.

    Accept

    New Arrivals


    Inspired by your browsing history


    Your review has been submitted!

    You've already reviewed this product!