你好! Shipping to Taiwan with premium packaging for just NT$300 

Ship to
Taiwan
0

My Account

  • argentina
  • chile
  • colombia
  • españa
  • méxico
  • perú
  • estados unidos
  • internacional

menu

Select your country

Americas

Europe

Rest of the world

portada Mastering Excel: Named Ranges, OFFSET and Dynamic Charts
Type
Physical Book
Author
Publisher
Language
English
Pages
58
Format
Paperback
Dimensions
22.9x15.2x0.3 cm
Weight
0.09 kg.
ISBN13
9781546874959
Categories

Mastering Excel: Named Ranges, OFFSET and Dynamic Charts

Mark Moore (Author) · Createspace · Paperback

Mastering Excel: Named Ranges, OFFSET and Dynamic Charts - Moore, Mark

New Book Imported to Taiwan
Delivery: 19 Oct - 30 Oct Shipping: 16 to 20 business days.
NT$ 813
NT$ 813

Choose the list to add your product or create one New List

Go to My Wishlists
Calculate shipping cost

Synopsis "Mastering Excel: Named Ranges, OFFSET and Dynamic Charts"

This lesson focuses on many seemingly unrelated topics but then combines them in unexpected ways to create something greater than the sum of its parts. First we review the concept of Named Ranges. What are they? How can they help in Excel?Then we cover the OFFSET function. It is truly one of the most powerful, flexible and mostly unused functions in Excel. It is unused because it does take some getting used to, OFFSET doesn't 'work' like the rest of the Excel functions. However, we will go through this function in detail here.Then we move on to using Forms in Excel. Forms give users familiar ways to interact with an Excel worksheet, much like a form on the web.And finally, we combine Named Ranges, OFFSET, Forms and Charts to create animated charts. Excel users will be able to click the worksheet and see the charts animate in real time. There are no macros, no programming involved; just a creative way of combining existing Excel functionality.This lesson covers a lot of ground. To help everyone understand and follow along with the exercises, I have made available a sample workbook. Follow the link in the book and you can receive the workbook to work on alongside the text.The sample workbook has a bonus extra dynamic chart not covered in the book.

Customers reviews

More customer reviews
  • 0% (0)
  • 0% (0)
  • 0% (0)
  • 0% (0)
  • 0% (0)

Frequently Asked Questions about the Book

Is the book original?

All books in our catalog are Original.

In what language is the book written?

The book is written in English.

What is the format of this book?

The binding of this edition is Paperback.

Questions and Answers about the Book

Do you have a question about the book? Login to be able to add your own question.

Opinions about Bookdelivery

More customer reviews