Mastering Excel's Database Features

Microsoft says that up to 70% of users surveyed use Excel to maintain a database. To be truly proficient in Excel, you must be familiar with these tools to manage data efficiently. It's all the more important as data collection has become more automated and you're getting swamped with tons of data. But what can you do with all that data? You can do more with Microsoft Excel spreadsheets than just calculate data -- you can tackle powerful database needs with ease too! Join Excel expert, Dennis Taylor for a scintillating webinar, Mastering Excel's Database Features on February 15, 2013 at 1:00 pm EDT to master the Excel's database features. In one fun and fast paced hour, he will reveal several powerful tricks and tools to help you become more productive and efficient while dealing with large databases. Here is an insight to what you will be able to learn through this riveting session: The fastest, most efficient ways to sort data; sort by content, by color, or based on the order of data in a custom list; sort in random order or by re-arranging columns left-to-right Re-structure improperly grouped columnar data Master the myriad ways of filtering data to display just the data you need Eliminate duplicate records from a large database Insert a row of subtotals in a sorted list without tediously creating new rows and formulas Create drop-down lists to accelerate data entry, with improved accuracy and consistency Valuable functions that help you understand your data COUNTIF, SUMIF And much more!!! Master the tools of Database Management: Sorting, Automatic Subtotals, and Filtering, as well as other techniques that provide clarity and quick answers so that you can understand your data better.

Read More

View Less