|
|
Price: Rs. 995.00
ISBN: 978-81-203-5081-6
Pages: 1168
Binding: Paper Back
Buy Now at www.phindia.com
|
|
DESCRIPTION
|
Conquer Excel 2013—from the inside out!
Dive into Excel 2013—and really put your spreadsheets and data-analysis skills to work! This supremely organized reference packs hundreds of timesaving solutions, troubleshooting tips, and workarounds. It’s all muscle and no fluff. Discover how the experts tackle Excel—and challenge yourself to new levels of mastery.
• Write formulas for simple to complex calculations
• Use built-in functions or develop your own
• Apply best practices for design and formatting
• Master core to advanced charting techniques
• Embed, connect, or link to external data sources
• Work with PivotChart, PivotTable, and PowerPivot options
• Create graphics, SmartArt, and sparklines
• Perform statistical, what-if, and other data analyses
• Use Visual Basic for Applications (VBA) to write macros
|
|
CONTENTS
|
|
Part 1: Examining the Excel environment
Chapter 1 What’s new in Microsoft Excel 2013
Chapter 2 Exploring Excel fundamentals
Chapter 3 Custom-tailoring the Excel workspace
Chapter 4 Security and privacy
Part 2: Building worksheets
Chapter 5 Planning your worksheet design
Chapter 6 How to work a worksheet
Chapter 7 How to work a workbook
Part 3: Formatting and editing worksheets
Chapter 8 Worksheet editing techniques
Chapter 9 Worksheet formatting techniques
Part 4: Adding graphics and printing
Chapter 10 Creating and formatting graphics
Chapter 11 Printing and presenting
Part 5: Creating formulas and performing data analysis
Chapter 12 Building formulas
Chapter 13 Using functions
Chapter 14 Everyday functions
Chapter 15 Formatting and calculating date and time
Chapter 16 Functions for financial analysis
Chapter 17 Functions for analyzing statistics
Chapter 18 Performing a what-if analysis
Part 6: Creating charts
Chapter 19 Designing charts
Chapter 20 Formatting charts
Chapter 21 Using sparklines
Part 7: Managing databases and tables
Chapter 22 Managing information in tables
Chapter 23 Analyzing data with PivotTable reports
|
|
ABOUT THE AUTHOR(s)
|
|
Mark Dodge has coauthored several popular books on Excel, including Microsoft Excel 2010 Inside Out. He is a former senior technical writer for the Microsoft Office User Assistance Group.
Craig Stinson is a computer journalist and author who has written or cowritten more than 20 books, including Microsoft Excel 2010 Inside Out and Windows 7 Inside Out, Deluxe Edition.
|
|
|
|
|
|
|
|
|
