- ホーム
- > 洋書
- > 英文書
- > Computer / Spreadsheets
Full Description
This book provides a complete guide to the more advanced features of Excel 2000, the market-leading spreadsheet package from Microsoft. It reviews the basic concepts of Excel, then moves on to cover such topics as using advance functions in worksheets, macros, auditing, charts and using Excel to create web pages.
Contents
IntroductionThe Versions of ExcelUnit 1: WorksheetsCell addressingFunctionsCopying worksheets and chartsConditional formattingTemplates and protectionNaming cellsMacrosMore functionsPivot tablesThe Lookup functionsViewing and formatting worksheetsWhat-If analysisAuditing and validating dataUnit 2: ChartingFun with ChartsPictogramsUsing Excel to create web pagesAppendicesWorking with ExcelShortcut Keys