info@xszil.com
(323) 459-9794
Becoming An Excel Power User with XSil
Sample Topics Index
Training Module
1 Excel 2007: Making The Switch
Topics
Meet The New Office! The Ribbon Overview The Ribbon's 'Contextutal Tabs' More attractive charts than ever! New Table Features Galleries Fit For An Artist (OK, It's Microsoft… but still!) Take Note, Keyboard Shortcut Fans… 2007 Has "Still Got It"! Toolbar Customization - Great In 2003, Not So Much in 2007 2003 and 2007 Compatibility Overview Check Out The 2003 v 2007 Scoreboard! Training Freebies From Our Friends At Microsoft… Best 2003-2007 Resources From MrExcel.com If You Still Can't Let Go (of Excel 2003) - Get Your Old Menus Back! The Shortcut Multiplier Effect - Just How Much Time Can I Save Context Sensitive Menus At Your Right-Click Fast, Faster & Fastest Shortcuts For Common Excel Tasks Secret Keyboard Combinations For Quick Number Formatting Why You Never Need A Calculator: The Status Bar Add Numbers in a Snap With The AutoSum Button Sum Totals Across Columns and Rows - In ONE click! Math Without Formulas Using 'Paste Special' Tricks Move Around 'Flat Table' Range Cells With Shift + Arrow Keys Just 'Go To' It - Navigate To 'Recent Places' in Your Workbook with "Goto" (F5) Tab Through Specific Types Of Cells With "Goto" (F5) Gettin' Around Your Workbook FASTER than ever Formulas 101 Everything's Relative…Unless It's Absolute! Find Any Formula Name That Cell! Name That Formula! Name That Range! Error Trapping Array Formulas Keyword & Wildcard Searches With Edit / Find All VLOOKUP(): Single Value, Exact Match VLOOKUP(): Single Value, Approximate Match VLOOKUP(): Two (Or More) Values At Once! MATCH(): Search For An Item In A List INDEX(): Finding the Value At An Intersection INDEX() & MATCH(): Find The Value At An Intersection Using Empty Space As An Intersection Operator Quick n Dirty' Subtotals With Data > Subtotals… Conditional Summing with Wildcard Characters Multiple Condition Summing with SUMPRODUCT SUM() & COUNTIF(): Getting the number of 'unique' values Calculating Times & Dates Calculating Fractional Years Bringing Together Text, Date, and Numeric Strings Joining Strings Together Into One Cell With "&" Custom Number Formats With the TEXT() Function Extract Anything from Text Strings with FIND(), SUBSTITUTE(), and more! About External Links… Comparing Two Worksheets Side-By-Side View Formulas and Values Simultaneously Closing Several Files Without Saving Any

下一页