Absolutely Australia's Lowest Prices

Shop over 1.5 Million Toys in our Huge New Range

Microsoft Excel 2019 Inside Out


Product Description
Product Details

Table of Contents

  • 1 What's New in Excel 2019 and Office 365
  • 2 Using the Excel Interface
  • 3 Customizing Excel
  • 4 Keyboard Shortcuts
  • 5 Understanding Formulas
  • 6 Controlling Formulas
  • 7 Understanding Functions
  • 8 Using Everyday Functions: Math, Date and Time, and Text Functions
  • 9 Using Powerful Functions: Logical, Lookup, Web, and Database Functions
  • 10 Other Functions
  • 11 Connecting Worksheets and Workbooks
  • 12 Array Formulas and Names in Excel
  • 13 Transforming Data with Power Query
  • 14 Summarizing Data Using Subtotals or Filter
  • 15 Using Pivot Tables to Analyze Data
  • 16 Using Slicers and Filtering a Pivot Table
  • 17 Mashing Up Data with Power Pivot
  • 18 Using What-If, Scenario Manager, Goal Seek, and Solver
  • 19 Automating Repetitive Functions Using VBA Macros
  • 20 More Tips and Tricks for Excel 2016
  • 21 Formatting Worksheets
  • 22 Using Data Visualizations and Conditional Formatting
  • 23 Graphing Data Using Excel Charts
  • 24 Using 3D Maps
  • 25 Using Sparklines
  • 26 Formatting Spreadsheets for Presentation
  • 27 Printing
  • 28 Excel Online
  • A DAX Functions
  • B Power Query M Functions

About the Author

Bill Jelen, Excel MVP and the host of MrExcel.com, has been using spreadsheets since 1985, and he launched the MrExcel.com website in 1998. He loves performing his live Power Excel seminars around the United States. He has produced more than 2,200 episodes of his daily video podcast, Learn Excel from MrExcel. He is the author of 57 books about Microsoft Excel and writes the monthly Excel column for Strategic Finance magazine. Before founding MrExcel.com, Bill Jelen spent 12 years in the trenches, working as a financial analyst for finance, marketing, accounting, and operations departments of a $500 million public company. He lives in Merritt Island, Florida, with his wife, Mary Ellen.

Ask a Question About this Product More...
Write your question below:
Look for similar items by category
People also searched for
How Fishpond Works
Fishpond works with suppliers all over the world to bring you a huge selection of products, really great prices, and delivery included on over 25 million products that we sell. We do our best every day to make Fishpond an awesome place for customers to shop and get what they want — all at the best prices online.
Webmasters, Bloggers & Website Owners
You can earn a 5% commission by selling Microsoft Excel 2019 Inside Out on your website. It's easy to get started - we will give you example code. After you're set-up, your website can earn you money while you work, play or even sleep! You should start right now!
Authors / Publishers
Are you the Author or Publisher of a book? Or the manufacturer of one of the millions of products that we sell. You can improve sales and grow your revenue by submitting additional information on this title. The better the information we have about a product, the more we will sell!
Item ships from and is sold by Fishpond.com, Inc.
Back to top