GettheMostoutofExcel!TheUltimateExceTipHelpGuide
GettheMostoutofExcel!TheUltimateExceTipHelpGuide, Dokumenty(eboki programy i inne), @Excel
[ Pobierz całość w formacie PDF ]
Part 1 — What’s New in Excel 2002 & 2003?
What’s New in Excel 2002 & 2003, Speech
1
Part 2 — Working Inside
Selecting, Navigating, Custom Keyboard Shortcuts, Copying & Pasting, Editing
(
Preventing Duplicates, Validating, Find, Find & Replace
), Formatting (
Cell
Formatting, Numbers Formatting, Euro, Conditional Formatting
), Styles
2
Part
3
— Excel Environment
Information (
Watch Window
) Comments (
Picture, Smart Tag
) Windows (
Hide,
Protect Cells, Task Pane
) Menus & Toolbars, Sheets (
Insert, Coloring, Copying,
Moving, Sorting, Protecting, Hiding
) Workbooks (
Opening, Closing, Saving,
Recover, Path, Protecting, Password, Template
)
Part
4
— Text, Dates, Times
Text (
Combining, Extracting, Separating, Formulas
), Importing Text Files
(
Reverse Text, Formatting, Minus
), Updating Internet Data, Dates (
Entering,
Formatting, Formulas, Validating
), Times (
Entering, Formulas, Converting
)
3
4
Part
5
— Summing & Counting
Calculating, Summing
(Fast, Summing Rounding Numbers)
, SUMIF Formula,
Counting
(Formulas, COUNTIF)
, Euro Currency Add-In
5
Part
6
— Formulas
Names, Formulas (
Entering, Editing, Nesting, Absolute & Relative, Array,
Custom Function, Paste Values, Protecting, Formatting, Auditing, Errors),
Links,
Lookup Formulas & Power Techniques (
Vlookup, Index, Match, Sumif, Offset,
Combo Box
)
Part
7
— Printing & Mailing
Printing (
Page Setup, Watermark, Numbering, Path, Troubleshooting, Objects,
Custom Views, Report Manager, Custom Report Manager
), Mailing
(
Workbook Size
)
6
7
Part
8
— Lists, Analyzing Data
List Objects, Sorting, Formatting Lists, Filtering, Subtotals, Groups & Outlines,
Consolidating, Comparing Lists, PivotTables
8
F1
Get the Most out of Excel!
The Ultimate Excel Tip Help Guide
F1 — Get the Most out of Excel!
F1 Get the Most out of Excel!
The Ultimate Excel Tip Help Guide
Copyright 2004 by Joseph Rubin, CPA
All rights reserved. No part of this book may be
reproduced or transmitted in any form or by any means,
electronic or mechanical, including photocopying,
recording, or by any information storage or retrieval
system without written permission from the publisher.
Written by:
Joseph Rubin, CPA
Published by:
Limelight Media Inc.
10680 W Pico Blvd # 270
Los Angeles, CA USA 90064
sales@limelightmediainc.com
www.limelightmediainc.com
Distributed by:
Limelight Media Inc.
ISBN:
0-9746368-3-5
Trademarks:
All brand names and product names used in this book are
trade names, service marks, trademarks, or registered trade
marks of their respective owners. Limelight Media inc. is
not associated with any product or vendor mentioned in
this book.
ii
F1 — Get the Most out of Excel!
About The Author
Joseph Rubin, CPA,
principal of
www.exceltip.com
(a
leading Excel Web site) is the author of the very successful
books:
Financial Statements.xls
Mr Excel On Excel
Joseph Rubin
has over 25 years of financial experience in
the accounting industry. He has served as CFO, Controller
and has run his own CPA practice for years.
Joseph Rubin, CPA, is an independent consultant
specializing in the development of applications using
Microsoft Excel for the financial industry and has
instructed thousands of professionals on Microsoft Excel.
Contact the author — jrubin@exceltip.com
iii
✸
✸
[ Pobierz całość w formacie PDF ]