Mastering Microsoft® Excel® Macros
Experience the power of Excel macro training … without having to leave your desk!
If you've ever thought, "There's gotta be a better, faster way" to handle repetitive tasks in Excel – Mastering Microsoft® Excel® Macros is for you! Macros are the answer to getting Excel to do repetitive work for you! Plus, macros will increase your accuracy, reduce the need to double-check your work, and save you even more time than you ever thought possible!

A Look at What You’ll Learn:

• Why use a macro? Two powerful reasons you'll be a macro user from now on
• Record a macro in 5 simple steps
• How to develop your very own macro file to help keep your macros organized
• Automate your worksheets and kick into instant-replay mode
• How do you know when to use Excel macro language and when Visual Basic® is the more appropriate tool?
• Create a macro toolbar customized with the shortcuts you use most often
• How to create interactive macros
• Create a new macro with Visual Basic Editor
• Learn how to debug a macro with the Step feature

 
Microsoft® Excel® Tips & Shortcuts for Every User
Cut your Excel work time in half with amazing shortcuts and secrets that will make your job easier and less stressful!
With just a handful of Excel power tips you can save yourself a ton of frustration and hours of time. With Microsoft® Excel® Tips & Shortcuts for Every User, you’ll receive more than just a handful of tips — you’ll spend a whole hour uncovering Excel secrets that will change the way you work in Excel forever!

A Look at What You’ll Learn:

• Navigate rapidly through workbooks and worksheets with keystroke and mouse shortcuts
• Keystroke shortcuts for entering dates and times
• Flawless copy and data movement with the touch of a button!
• Tricks to creating numerical series without commands or typing
• A single keystroke shortcut that instantly displays all your worksheet formulas
• One simple function key that debugs your formulas
• How to instantly locate all of a cell’s dependencies
• Create eye-catching on-sheet charts and graphs in just two clicks
• Select just visible data from a range containing hidden rows and columns
• Increase or decrease values in a range without using formulas
• Create special formulas to display numbers in thousands or millions
• A simple dragging technique that turns formulas into values
• And much, much more!

How to Use Microsoft® Excel® PivotTables to Easily Summarize and Analyze Data
Turn mountains of data into easily usable and functional reports with just a few clicks!
Forget complicated tutorials and thousand-page manuals written in “tech-speak” — this training is the fastest, most accurate way to learn how to harness the potential of PivotTables. In just one fast-paced and informative training session, you’ll learn how to use PivotTables better to sort your data more efficiently … create multiple customized reports in a few easy steps … and gain a powerful new tool to help you make better business decisions.  

A Look at What You’ll Learn:

• Why they are the “hidden gems” inside Excel
• How to create multiple PivotTables so you can analyze large data sets from different business perspectives
• Easily group and view data in a spreadsheet
• Convert PivotTables into easy-to-read charts — instantly
• Create a macro that keeps your PivotTable data automatically updated
• Learn how to group date-related data into months, quarters, and years … perform ad hoc grouping in two quick steps
• How to get PivotTables and graphs to look — and print — exactly the way you want