Excel 2013 Training - 5 Audio Conference DVD
Book Details
Description
A 5-DVD Bundle, Loaded with Awesome Tips, Tricks and Ways to Explore the Unexplored in Excel 2013
With its tremendous capabilities and features, Microsoft Excel 2013 is a perfect program to boost your productivity. Apart from tons of formulas and functions, there are over 100 lesser known shortcuts that can help you manage large amounts of data and sort/filter large lists in Excel 2013 to ultimately save you time and make you more productive.
1. Mastering Microsoft 2013 Excel Charts and Graphs
Creating charts in Excel has long been one of its most popular features. Numerical information can be boring, and some of us just don't read and absorb the meaning of such data until we see the information depicted in a chart.
2. Mastering Excel 2013 Formulas and Functions
Working with formulas and functions in Excel is absolutely critical to building powerful financial and analytical worksheets and is probably the most important skill set for many Excel users.
3. Working with Excel's 2013 Data Management Tools (Sorting, Filtering, Subtotals)
Microsoft says that up to 70% of users surveyed use Excel to maintain a database or large lists. 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.
4. Microsoft Excel 2013 Power Tips and Shortcuts
Dennis Taylor will give you the productivity boost you need as you become a more proficient Excel user. Itoffers well over 100 Excel shortcuts.
5. Mastering Excel 2013 PivotTables
MS Excel has the capability to sort and filter large lists of data through various tools-but the best tool that wins hands down when it comes to handling large amounts of data is the PivotTable.










