Microsoft® Office Excel® 2007 Tips and Tricks

Description: This seminar will give you techniques that are guaranteed to increase your productivity with Microsoft Excel. This seminar covers Excel's formulas and functions with advanced instruction on the most useful functions for automating reports. Shortcuts and tips for preparing outstanding presentations of your report data using Excel charts. When you leave this seminar you will be able to use Excel macros to automate your work. The best thing about this seminar is that it's taught in easy-to-understand language (not technical). How can we guarantee this? Holly Basso has been successfully training others to use Excel for over 16 years. And, in addition to training, Holly has developed numerous business systems for many small, medium and large organizations in North Carolina.
 
Suggested Prerequisites:  Solid understanding of basic and intermediate Microsoft Excel.

Click Here to download the pdf for this course.
 
Attend and You Will Learn

Lesson 1: Timesaving Methods for Building a Worksheet

• Basic "list" rules to keep you sane
• Seven step creation process that is fast and accurate
• Customizing the Quick Access Toolbar
• Data validation as a self-defense move

Lesson 2: Creating Attention Grabbing Excel Reports

• AutoSum for grand totals
• Double click to AutoFill a range
• Rules for "names" and "labels"
• Tracking and eliminating error messages
• Custom formats and conditional formatting
• Creating custom sort orders and AutoFill lists
• Filtering worksheet data
• Using the Subtotals command
• Using Goal Seek to provide "What if?" analysis
• PivotTables and PivotCharts

Lesson 3: Combining Data with Ease and Accuracy

• Workbook features for quick multi-purpose analysis
• Linking data across workbooks effortlessly
• Consolidating data across workbooks with active links
• Saving a workspace

Lesson 4: Functions that Save Time and Add Pizzazz

• Best formula writing technique
• VLOOKUP and HLOOKUP for expert search capabilities
• SUMIF and SUMIFS for both math and decision making analysis
• LEFT and RIGHT substring functions for data display and manipulation
• Extremely useful date and time functions
• Using Macros to expedite analysis

Lesson 5: Amazing Chart Ideas that will Get You Noticed

• Fastest way to create charts
• Positioning multiple charts
• Copying and Pasting
• Dual-axis graphs
• Linking titles and data labels to cells