Excel freezing when applying a Filter on large data set

If Excel keeps freezing when applying or removing a filter to a large data set, the solutions provided in this article will ...
Yahoo

Creating an Excel Report: Charts, Tables, and Printing Tips

Create a report using charts: Select Insert > Recommended Charts, then choose the one you want to add to the report sheet. Create a report with pivot tables: Select Insert > PivotTable. Select the ...

Create Dynamic Excel Data Validation Lists Using Table Spill Ranges

Excel validation lists avoid blanks and errors with TOCOL(ignore) plus FILTER; the spill range stays stable across worksheets ...
How-To Geek on MSN

5 Microsoft Excel hacks that could blow your mind

Impress your coworkers with these nifty tricks.
How-To Geek on MSN

I stopped freezing panes in Excel. These tools work better

Stop sacrificing screen space—Excel tables, Watch Window, Focus Cell, and split views keep context without locking rows.
PC World

10 Secrets for Creating Awesome Excel Tables

Much of the data that you use Excel to analyze comes in a list form. You might need to sort the data, filter it, sum it, and perhaps even chart it. Excel tables provide superior tools for working with ...
Redmond Magazine

Office 365 Excel Users Can Now Import Table Data from PDF Files

Microsoft announced this week that's it's now possible for Office 365 users to import table data from Adobe Portable Document Format (PDF) files into the Microsoft Excel spreadsheet program. The ...