

Advance Excel 2016 IN DEPTH
Bill Jelen
SKU: 9788183335980
Rs. 1,099
FREE PREVIEW
ISBN: 9788183335980
Authors: Bill Jelen
Rights: Worldwide
Publishing Date: July 2016
Pages: 634
Weight:
Dimension: 23 X 17 X 2.25 cm
Book Type: Paperback
Experienced with Excel? Don’t let Excel 2016 make you feel like a beginner again! This new edition of the bestselling book has been completely overhauled. Gone is unnecessary and rarely used content; emphasis is on the most-used and new aspects of Excel 2016. The result is a focused book where every topic is relevant and worth learning. It is the fastest, smartest way to master Advance Excel 2016’s full power and updated interface. You’ll discover how to leverage Excel’s new tools for charting, business analysis, data visualization, forecasting, and more.
- Quickly clean your data with Excel 2016’s powerful Get & Transform toolsÂ
- Discover Excel 2016’s newest charts: waterfall, histogram, Pareto, sunburst, Tree Map, and Box and WhiskerÂ
- Use Forecast Sheets to forecast the future, including seasonal adjustmentsÂ
- Pivot data on maps with 3D Maps, and animate your maps over timeÂ
- Create formulas, charts, subtotals, and pivot tables faster than everÂ
- Create amazing Power Pivot data mishaps that integrate information from anywhereÂ
- Automate repetitive functions using Excel macrosÂ
- Solve real-world business intelligence analysis problemsÂ
- Use Power Pivot Data Model to create pivot tables from multiple data sets without VLOOKUPÂ Â
- Share workbooks on the Web and social networksÂ
- Leverage Excel to create highly interactive web pages and online surveysÂ
- Quickly apply attractive, consistent formatsÂ
- Chapter 1 What’s New in Excel 2016 (and 2013)
- Chapter 2Â Using the Excel Interface
- Chapter 3Â Customizing Excel
- Chapter 4Â Keyboard Shortcuts
- Chapter 5Â Understanding Formulas
- Chapter 6Â Controlling Formulas
- Chapter 7Â Understanding Functions
- Chapter 8Â Using Everyday Functions: Math, Date and Time, and Text Functions
- Chapter 9Â Using Powerful Functions: Logical, Lookup, Web, and Database Functions
- Chapter 10Â Other Functions
- Chapter 11Â Connecting Worksheets and Workbooks
- Chapter 12Â Array Formulas and Names in Excel
- Chapter 13Â Transforming Data
- Chapter 14Â Summarizing Data Using Subtotals or Filter
- Chapter 15Â Using Pivot Tables to Analyze Data
- Chapter 16Â Using Slicers and Filtering a Pivot Table
- Chapter 17Â Mashing Up Data with Power Pivot
- Chapter 18Â Using What-If, Scenario Manager, Goal Seek, and Solver
- Chapter 19Â Automating Repetitive Functions Using VBA Macros
- Chapter 20Â More Tips and Tricks for Excel 2016
- Chapter 21Â Formatting Worksheets
- Chapter 22Â Using Data Visualizations and Conditional Formatting
- Chapter 23Â Graphing Data Using Excel Charts
- Chapter 24Â Using 3D Maps
- Chapter 25Â Using Spark lines
- Chapter 26Â Decorating Spreadsheets
- Chapter 27Â Printing
- Chapter 28Â Excel Online
Bill Jelen