I can view live database tables as familiar Excel worksheets, make direct edits as if I were updating any other spreadsheet, and filter data using the Excel tools I already understand.

In this article, I’ll show you how to create a static view of data that won’t update while you’re working. SEE: 83 Excel tips every user should master (TechRepublic) More about Software ...

Excel filters help you find exactly what you want, no matter how big your spreadsheet database is. Here's how to set number, text and data filters.

Whether you're tired of losing your spot when collaborating or you want to customize the way you view your data, sheet views in Microsoft Excel are for you.

If the data resumes in A17, you must press End-Down to get to that cell. Press the Alt key to access (and view) the shortcut keys (letters highlighted with black boxes) for the tabs on the Ribbon ...