Excel Formulas & Functions For Dummies, 6th Edition

Chapter 19

Ten Ways to Get Fancy with Excel

IN THIS CHAPTER

Summing across multiple sheets

Getting data from the Internet

Removing duplicates

Freezing headers

Determining the correct number

Using custom fill lists

Getting the nitty-gritty about your workbook

This chapter lists ten cool things Excel can do. Excel is a powerhouse of a number cruncher and has enough functions to make any other office productivity software seem like a distant cousin. Even with all that power, there are yet more things Excel can do!

The ten goodies in this chapter show just how helpful Excel can be. Excel can use data from the Internet, integrate custom lists, deal with duplicates, and make sure you always see your column headers. There is some serious gold in here!

Calculating Data from Multiple Sheets ...