The Accountant's Guide to Advanced Excel

Front Cover
Cengage Learning EMEA, 2000 - Business & Economics - 356 pages
Written by an accountant for accountants, this advanced guide to Excel is the second in The Accountant's Guide series. The book looks at advanced data analysis techniques and some practical uses for Excel VBA. the accompanying CD-ROM contains all of the spreadsheet models in the book, demonstrating how the finished models are built. Comprehensive and easy to use, this book will improve your ability to handle large volumes of data easily, and enhance the professionalism of your presentation of this information to senior management and clients.
 

What people are saying - Write a review

We haven't found any reviews in the usual places.

Contents

Introduction
1
Starteg Poest
7
Desk Checking Spreadsheets
19
PROGRAMMING
27
CHAPTERS EXCEL VISUAL BASIC
35
EXCEL VISUAL BASIC
47
Random Data Generator
59
Overview
65
Next
281
THE WHAT IF MODEL II
291
THE WHAT IF MODEL III
305
LOADING FROM POWERPOINT
323
OVERVIEW
329
CONSOLIDATED ACCOUNTS
337
APPENDICES
343
Preface vii
367

EXCEL DATA TO EXCEL INFORMATION
83
MORE PlVOTTABLES
95
DATA TABLES
115
SOLVER
123
SCENARIOS
129
CHARTING
137
CHARTING AND MAPS
151
Mapping
163
THE POWERPOINT MENUS
177
Working with
197
Overview
205
Historical Data
211
PRESENTING THE HISTORICAL DATA I
231
PRESENTING
243
Next
257
CODING THE
265
The annual report and accounts 11
11
Reports and reviews 19
19
formats headings and totals 38
38
fixed assets and current assets 48
48
creditors provisions for liabilities
69
The profit and loss account 85
85
The cash flow statement 105
105
Other financial statements 113
113
Exercises
119
An introduction to the basic interpretation of accounts 131
131
Issues and possible developments in financial reporting 140
140
Profit and loss account formats 148
148
References 195
195
CONTENTS
205
Copyright

Other editions - View all

Common terms and phrases

Bibliographic information