According to a survey, Microsoft claims that around 70% of users use Excel to maintain a large lists or database. In order to be truly apt in Excel, you need to be familiar with the tools to manage data efficiently. It has become all the more essential as you are getting burdened with huge amount of data with data collection becoming more automated. However, what do you do with all the data?
You should know how to sort the data, create quick subtotals, filter what you want to see, erase bad or redundant records and restructure fields with too much data. You should know the powerful validation tools that keep out bad data from the start and learn how to drastically reduce data entry with drop-down clickable lists while setting up new lists.
You can do a lot more with Microsoft Excel worksheets besides just calculating data – you can handle powerful data management needs easily. With just a little knowledge, you can utilize the power of Excel to sort data (based on color, content, or icon), validate data, use powerful expanded features to examine the data in any list, regardless of size.
Attend this session by our expert speaker Dennis Taylor and learn the most efficient and quickest ways to sort, validate, analyze, reorganize and filter data regardless of size. Also learn to reorganize columnar data that has not been grouped properly, insert automatic subtotals and filter the data to view just what you need to.
Who should attend?
Any Excel user who deals with large lists needs these tools and techniques to effectively manage the lists and become more productive. Nearly all Excel users, except for those just getting started, are candidates for this webinar
Dennis Taylor has taught thousands of Excel seminars and classes since the early 90's, is the author/presenter of over 250 Excel webinars, and authored the book Teach Yourself Microsoft Excel 2000. He has taught hundreds of public Excel seminars in the US and Canada since 2006 and has recorded over 100 Excel courses bo... More info