Download Safari Books Online apps: Apple iOS | Android

Entire Site

Safari Books Online

    Free Trial

    Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.


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

    Part IV: Using Excel > Working with Lists and Databases

    Chapter 23. Working with Lists and Databases

    In this chapter

    Creating a List on a Worksheet

    Speeding Up Repetitive Data Entry with AutoComplete

    Automatically Filling In a Series of Data

    Sorting Lists

    Finding and Filtering Data in a List

    Summarizing, Grouping, Outlining, and Subtotaling Lists

    Using Forms to Add and Edit List Data

    Importing and Exporting Data

    Creating Links to External Databases

    Creating and Using Web Queries

    Troubleshooting

    Secrets of the Office Masters: Smart Lists


      

    You are currently reading a PREVIEW of this book.

                                                                                            

    Get instant access to over
    $1 million worth of books and videos.

      

    Start a Free Trial


      
    • Safari Books Online
    • Create BookmarkCreate Bookmark
    • Create Note or TagCreate Note or Tag
    • DownloadDownload
    • PrintPrint