Back

Message Board

Excel for the CEO

"Packed with practical steps and real life Excel tips"

This book covers real-life business cases that can be managed with Microsoft Excel. Learn how to actually use Excel's features to monitor your business.

Unleash the Power of Excel for Running Your Business

From the basics of Excel to powerful features like Pivot Tables, learn how to use Excel in running your business. This book uses the do & learn style of teaching, enabling you to learn the techniqes in an easy yet definitive way, which will remain forever in the mind.

"Covers the basics and more in-depth tasks"

The most powerful Microsoft Excel features are outlined in this manual. A few of the topics include:

• Profitability
• Project Review
• Delivery Schedules
• Financial Analysis
• Pivot Tables
• Quick Tips
• Business Scenarios
• Goal Seeking
• Auditing Tools

Learn from author P.K. Hari

About the author:

P.K.Hari is an accountant by profession, and is working as the Group Financial Controller for a large group of companies. P.K. is a certified Master of Microsoft Excel and is one of the featured experts with www.experts-exchage.com. With a very rich and varied work experience acquired by his employment in three different continents of the world, P.K.Hari commands the best knowledge of the theory and use of various Computer Applications, especially Microsoft Excel. His experience as a middle level and top-level manager and also as a business owner has provided the perfect angle of top management thoughts and a easy-learning solution model with which he has tailored the learning approach.

Click here to order the book!
Table of Contents
Starting off on the Right Foot
• Basic Terminology
• Creating, Saving, Opening, and Closing Workbooks and Worksheets
• Navigating in Excel – Within a Worksheet and Between Workbooks
• Selecting Cells, Rows and Columns, Non-adjacent Cells
• Editing, Updating, and Deleting Data – Ways Available
• Sheet Background, Name, Hiding, and Unhiding
• Entering Formulas in Excel
• Creating Charts – the Basics

Excel-lent Tips
• Activating the Menus
• Accessing the Toolbars with the Keyboard
• Basic and Common Shortcut Keys
• Twenty Terrific Excel Tips
• Links for More Tips

Formulas, Functions, and More…
• What Is a Formula and How Does It Work?
• Introducing Array Formulas
• Common Error Messages in Formulas
• How are Functions Different from Formulas?
• What are the Categories and Components of Functions?
• Financial Functions
• Date and Time Functions
• Math, Trig, and Statistical Functions
• Math and Trig functions
• Database Functions
• Text Functions
• Logical Functions
• Information Functions
• Nesting Functions
• Troubleshooting and Evaluating Formulas and Functions

Data Management in Excel
• Database Management – the Basics
• Data Management Functions Available in Excel
• Sorting a Database
• Filtering Data – AutoFilter and Advanced Filter
• Subtotals, Grouping and Outlining
• Data Validation Feature
• Converting Text to Columns / Importing Text Data
• Sound Interesting?

Advanced Data Management in Excel
• Database Functions – the Concept
• Detailed Listing of Database Functions
• Using Database Functions
• Working with Data Tables
• Creating and Managing Lists
• Consolidation of Data
• Importing External Data
• Handling XML data
• More Terrific Links
• PivotTables, PivotCharts, and Reporting
• Introducing PivotTables
• When Should You Use a PivotTable?
• Creating a PivotTable
• Filtering and Modifying Fields within a PivotTable
• Sorting Data and Listing Specific PivotTable Items
• PivotTable Report Formatting Options
• PivotTable Field Settings
• Things You Should Know When Using PivotTables
• Creating a PivotChart
• Links for More Information

Auditing Tools
• Introducing Auditing Tools
• Formula Auditing Toolbar
• Error Checking Feature
• Tracing Precedents
• Tracing Dependents
• Removing Tracing Arrows
• Trace Error Option
• New Comment / Edit Comment Option
• Circling Invalid Data
• Clearing Validation Circles
• Showing Watch Window
• Evaluate Formula Option
• Tracking Changes Made to a Workbook
• Viewing and Printing Formulas in Any Sheet
• Viewing and Printing Comments and Errors

Formatting and Printing Reports
• Print Preview Options and Zooming
• Controlling Print Selection, Page, Cells, and Copies
• Setting, Removing Page Breaks; Page Break Preview
• Print Area – Setting, Clearing
• Page Control – Orientation, Size, Scaling, Quality
• Alignment Control – Margins, Centering Report
• Headers and Footers, First Page Numbers
• Controlling Sheet Properties During Printing
• Printing Charts
• Four More Topics

Adding Interactivity and Publishing Reports on the Web
• Saving as a Web Page
• Publishing an Entire Workbook on a Web Page
• Publishing One Worksheet / Range / Other Items
• Publishing a Chart on a Web page
• Publishing a PivotTable Report on a Web Page

An Introduction to VBA
• What Is a Macro and What Is It Used for?
• Recording a Macro – the Toolkit
• Writing a Macro - the VBE Window
• Running a Macro
• Other Advanced Topics and Links

Case Studies
• Peter F Drucker’s Advice to CEOs
• Reviewing Projects and Their Profitability
• Checking Delivery Schedules Using Gantt Charts
• Comparing Excel Worksheets/Workbooks
• Financial Analysis Models – Creation and Automation
• Having Your Own Menu Bar
• Control Reports Using PivotTables
• Using Conditional Statements for Reporting
• Controlling Entry of Dates – the Dating Problem!
• Some Interesting Examples

Goal Seek and Scenario Builder
• Using Goal Seek
• Using Scenario Builder
• Other New Techniques and Developments

One Journey Ends – Another Begins
• Appendix A – Finding and Launching Excel
• Appendix B – Excel’s Roots
Click here to order the book!
Product Details
Paperback: 349 Pages ; Dimensions (in inches): 7.375" x 9.25" x 18mm
Publisher: Holy Macro! Books; ISBN 1932802177 (October 1, 2006)
Price: $24.95
Click here to order the book!
E-book
This book is available as a downloadable e-book.
The content in Excel for the CEO has been repackaged into Excel for the Small Business Owner e-book.
Publisher: Holy Macro!
Price: $19.95

Click here to order the e-book!