• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 13. Advanced Techniques > Advanced Techniques

Advanced Techniques

Excel has many advanced features that you can use to tap into Excel's real power. In this chapter, I tell you about some of the advanced techniques I think you'll find most useful in your day-to-day work with Excel:

  • Names (Figure 1) let you assign easy-to-remember names to cell references. You can then use the names in place of cell references in formulas.

    Figure 1. The reference to the selected range would be a lot easier to remember if it had a name like FirstQtrSales rather than just A4:D7.

  • 3-D cell references (Figure 2) let you write formulas with links to other worksheets and workbooks.

    Figure 2. 3-D cell references make it possible to link information between worksheets or workbooks.

  • Consolidations (Figure 3) let you summarize information from several source areas into one destination area.

    Figure 3. Excel's consolidation feature lets you combine information from multiple source areas into one destination area—with or without live links.

  • Custom views enable you to create predefined views of workbook contents that can include a variety of settings.

  • Macros let you automate repetitive tasks.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint