Learn Excel 2007 through Excel 2010 from Mr. Excel
Subtitle: 512 Excel mysteries solved
Publisher: Holy Macro! Books
Published: 2011
Place of publication: Uniontown, OH
Language: eng
Format: Paperback
ISBN-13: 9781932802443
Table of contents: title: Find Icons on the Ribbon; title: Seriously, I Really Can't Find This; title: Where Are My Macros?; title: What Happened to Tools, Options?; title: New for Excel 2010! Customizing the Ribbon; title: Go Wide; title: Minimize the Ribbon to Make Excel Feel a Bit More Like Excel 2003; title: New! Use a Wheel Mouse to Scroll Through The Ribbon Tabs; title: Use Dialog Launchers to Access the Excel 2003 Dialog; title: New! Why Do The Charting Ribbon Tabs Keep Disappearing?; title: Icon, Dropdowns, and Hybrids; title: All Commands Start at the Top (Except for 2 Controls at the Bottom); title: Make Your Most-Used Icons Always Visible; title: The Alt Keystrokes Still Work in 2010 (If You Type Them Slowly Enough); title: Use New Keyboard Shortcuts to Access the Ribbon; title: Why Do I Have Only 65,536 Rows?; title: Which File Format Should I Use?; title: Share Files with People Who Are Still Using Excel 97 Through Excel 2003; title: New for Excel 2010! Why Does The File Menu Cover The Entire Screen?; title: Increase the Number of Workbooks in the Recent Documents List; title: New for Excel 2010! How Do I Close The File Menu?; title: New for Excel 2010! I Just Want The Old Print Preview Back; title: New for Excel 2010! Change All Print Settings in Excel 2010; title: Use Live Preview; title: Get Quick Access to Formatting Options Using the Mini Toolbar; title: New for Excel 2010! What Is Protected Mode?; title: Use a Trusted Location to Prevent Excel's Constant Warnings; title: My Manager Wants Me to Create a New Expense Report from Scratch; title: Open a Saved File Whose Name You Cannot Recall; title: Open a Copy of a Workbook; title: Excel'S Obsession with Security Has Hampered Linked Workbooks; title: Use a Workspace to Remember What Workbooks to Open; title: New! Open Excel with Ctrl+Alt+X; title: Have Excel Always Open Certain Workbook(s); title: Set up Excel Icons to Open a Specific File on Startup; title: Use a Macro to Customize Startup; title: Control Settings for Every New Workbook and Worksheet; title: Automatically Move the Cell Pointer in a Direction After Entering a Number; title: Return to the First Column After Typing the Last Column; title: Enter Data in a Circle (Or Any Pattern); title: How to See Headings as You Scroll Around a Report; title: How to See Headings and Row Labels as You Scroll Around a Report; title: I Navigate by Sliding the Scrollbar and Now the Slider Has Become Tiny; title: New! Jump to the Edge of the Data; title: New! Jump to Next Corner of Selection; title: Copy a Formula to All Data Rows; title: New! Zoom with the Wheel Mouse; title: Copy the Characters from a Cell Instead of Copying an Entire Cell; title: A Faster Way To Paste Special; title: Quickly Turn a Range on Its Side; title: New! Hide the Paste Options in Excel 2007; title: New! Quickly Rearrange Rows Or Columns; title: Copy Cells from One Worksheet to Many Other Worksheets; title: Find Text Numbers; title: New! Quickly Copy Worksheets; title: Why Can't Excel Find a Number?; title: Mix Formatting In A Single Cell; title: Enter a Series of Months, Days, or More by Using the Fill Handle; title: Have the Fill Handle Fill Your List of Part Numbers; title: Use Excel as a Word Processor; title: New! Teach Excel to Fill A, B, C; title: Add Excel to Word; title: Use Hyperlinks to Create an Opening Menu for a Workbook; title: Arrange Windows to See Two or More Open Workbooks; title: Compare Two Worksheets Side by Side; title: Spell check a Region; title: Stop Excel from AutoCorrecting Certain Words; title: Use AutoCorrect to Enable a Shortcut; title: Why Won't the Track Changes Feature Work in Excel?; title: Translate with Excel; title: I am a Lobbyist Writing Policy Papers for the White House; title: How to Print Titles at the Top of Each Page; title: Print a Letter at the Top of Page 1 and Repeat Headings at the Top of Each Subsequent Page; title: How to Print Page Numbers at the Bottom of Each Page; title: How to Make a Wide Report Fit to One Page Wide by Many Pages Tall; title: New! Add a Printable Watermark; title: New! Print Multiple Ranges; title: Add a Page Break at Each Change in Customer; title: New! Save My Worksheet as a PDF File; title: Send an Excel File as an Attachment; title: Save Excel Data as a Text File; title: Close All Open Workbooks; title: Use a Laser Printer to Have Excel Calculate Faster; title: New for Excel 2010! I Just Closed an Unsaved Workbook; title: New for Excel 2010! Roll Back to an AutoSaved Version; title: Have Excel Talk to You; title: Enter Special Symbols; title: What Do All the Triangles Mean?; title: New! Why does Excel Insert Cell Addresses When I Edit In a RefEdit Box?; title: New for Excel 2010! Beware of Excel Starter; title: New for Excel 2010! Edit your Excel Workbooks on the Web; title: New for Excel 2010! Collaborate in an Excel Workbook; title: New for Excel 2010! Embed Your Dashboard in a Blog Post; title: New! Print all Excel Keyboard Shortcuts; title: Get Free Excel Help; title: Start a Formula with = or +; title: Three Methods of Entering Formulas; title: Use Parentheses to Control the Order of Calculations; title: Long Formulas in the Formula Bar; title: Copy a Formula That Contains Relative References; title: Copy a Formula While Keeping One Reference Fixed; title: Create a Multiplication Table; title: Calculate a Sales Commission; title: Simplify the Entry of Dollar Signs in Formulas; title: Learn R1C1 Referencing to Understand Formula Copying; title: Create Easier-to-Understand Formulas with Named Ranges; title: Use Named Constants to Store Numbers; title: Total Without Using a Formula; title: Add or Multiply Two Columns Without Using Formulas; title: Join Two Text Columns; title: Join Text with a Date or Currency; title: Sort on One Portion of an Account ID; title: How to Isolate the Center Portion of an Account ID; title: How to Isolate Everything Before a Dash in a Column by Using Functions; title: How to Use Functions to Isolate Everything After a Dash in a Column; title: How to Use Functions to Isolate Everything After the Second Dash in a Column; title: How to Separate a Part Number into Three Columns; title: Excel Is Randomly Parsing Pasted Data; title: New! I Lose Leading Zeroes From CSV Files; title: New! Open CSV File With Dates in D/M/Y Format; title: New! Parse Data With Leader Lines; title: Change Smith, Jane to Jane Smith; title: New! Parse Multi-Line Cells; title: Convert Numbers to Text; title: Fill a Cell with Repeating Characters; title: New! CLEAN Hasn't Kept Up With The Times; title: Add the Worksheet Name as a Title; title: Use AutoSum to Quickly Enter a Total Formula; title: AutoSum Doesn't Always Predict My Data Correctly; title: Use the AutoSum Button to Enter Averages, Min, Max, and Count; title: New! Ditto The Formula Above; title: The Count Option of the AutoSum Dropdown Doesn't Appear to Work; title: New! Total the Red Cells; title: Automatically Number a List of Employees; title: Discover New Functions Using the fx Button; title: Get Help on Any Function While Entering a Formula; title: Yes, Formula Autocomplete Is Cool, if You Can Stop Entering the Opening Parentheses; title: Use F9 in the Formula Bar to Test a Formula; title: Quick Calculator; title: When Entering a Formula, You Get the Formula Instead of the Result; title: You Change a Cell in Excel but the Formulas Do Not Calculate; title: New! Calculate One Range; title: New! Why Use the Intersection Operator?; title: New! Find the Longest Win Streak; title: New! Add B5 On All Worksheets; title: New! Consider Formula Speed; title: New! Exact Formula Copy; title: Calculate a Loan Payment; title: Calculate Many Scenarios for Loan Payments; title: Back into an Answer Using Goal Seek; title: Create an Amortization Table; title: Do 40 What-if Analyses Quickly; title: New! What-If For 3 Or More Variables; title: Rank Scores; title: Rank a List Without Ties; title: Sorting with a Formula; title: New! Round Numbers; title: Round to the Nearest $0.05 with MROUND; title: Round Prices to the Next Highest $5; title: New! Round 0.5 towards Even Per ASTM-E29; title: New! Separate the Integer From the Decimals; title: Why Is This Price Showing $27.85000001 Cents?; title: Calculate a Percentage of Total; title: Calculate a Running Percentage of Total; title: Use the ^ Sign for Exponents; title: Raise a Number to a Fraction to Find the Square or Third Root; title: Calculate a Growth Rate; title: Find the Area of a Circle; title: Figure Out Lottery Probability; title: Help Your Kids with Their Math; title: Convert Units; title: Match Web Colors with HEX2DEC; title: New! Find the Second Largest Value; title: New! Format Every Other Row in Green; title: New! Use IF to Calculate a Bonus; title: New! IF with Two Conditions; title: New! Tiered Commission Plan with IF; title: New! Display Up/Down Arrows; title: New! Stop Showing Zeroes in Cell Links; title: Calculate Sales Over Quota; title: Count Records That Match a Criterion; title: Build a Table That Will Count by Criteria; title: New! Sum Records That Match a Criterion; title: Can the Results of a Formula Be Used in SUMIF?; title: Calculate Based on Multiple Conditions; title: New! Avoid Errors Using IFERROR; title: New! Multiple Conditions Using SUMPRODUCT; title: New! Use VLOOKUP to Join Two Tables; title: New! Every VLOOKUP Ends in False; title: New! Lookup Table Does Not Have to Be Sorted; title: New! Beware of #N/A from VLOOKUP; title: New! Add New Items to the Middle Of Your Lookup Table; title: Remove Leading and Trailing Spaces; title: New! Consider Naming the Lookup Table; title: New! Your Lookup Table Can Go Across; title: New! Copy a VLOOKUP Across Many Columns; title: New! INDEX Sounds Like AN Inane Function; title: New! You Already Know MATCH, Really!; title: New! INDEX Sounds Like an Inane Function - II; title: New! VLOOKUP Left; title: New! Fast Multi-Column VLOOKUP; title: New! Return the Next Larger Value in a LOOKUP; title: New! Two-Way Lookup; title: Combine Formulas into a Mega-Formula; title: Combine Two Lists Using VLOOKUP; title: Watch for Duplicates When Using VLOOKUP; title: New! Return the Last Entry; title: New! Return the Last Matching Value; title: New! Sum All of the LOOKUPs; title: New! Embed a Small Lookup Table In Formula; title: I Don't Want to Use a Lookup Table to Choose One of Five Choices; title: New! Lookup Two Values; title: Add Comments to a Formula; title: Create Random Numbers; title: Randomly Sequence a List; title: Play Dice Games with Excel; title: New! Generate Random Without Repeats; title: Calculate a Moving Average; title: Calculate a Trendline Forecast; title: Build a Model to Predict Sales Based on Multiple Regression; title: Measure the Accuracy of a Sales Forecast; title: Switching Columns into Rows Using a Formula; title: New! SUM a Range that is C5 Rows Tall; title: New! Whatever Happened to the @@ Function?; title: Tables Are Like a Database in Excel; title: New! Dealing with Table Formulas; title: Rename Your Tables; title: New! Charts, VLOOKUP & Pivots Expand With The Table; title: Before Deleting a Cell, Find out if Other Cells Rely on It; title: Calculate a Formula in Slow Motion; title: Which Cells Flow into This Cell?; title: New! Color all Precedents or Dependents; title: Monitor Distant Cells; title: New! Use Real Dates; title: New! How Can I Tell If Have Real Dates?; title: New! Convert Text Dates to Real Dates; title: New! Format Dates; title: New! Format Dates As Quarters or Weeks; title: Display Monthly Dates; title: New! Add a Column to Show Month or Weekday; title: New! Calculate First of Month; title: Calculate the Last Day of the Month; title: New! Calculate Invoice Due Dates; title: New! Calculate Receivable Aging; title: Now, OR Today?; title: New! Find the Last Sunday Of the Month; title: Calculate Work Days; title: New! Calculate Age in Years, Months, Days; title: New! Coerce an Array of Dates from 2 Dates; title: New! Use Real Times; title: Strangeness of TIme Formatting; title: New! Convert Time to Decimal Hours; title: New! Calculate with Time; title: Enter Minutes and Seconds; title: Convert Text to Time; title: Can Excel Track Negative Time?; title: New! Fill Blanks With Value Above; title: How to Set up Your Data for Easy Sorting and Subtotals; title: How to Fit a Multiline Heading into One Cell; title: New! No Tiny Blank Columns Between Columns; title: How to Sort Data; title: Sort Days of the Week; title: Sort a Report into a Custom Sequence; title: Sort All Red Cells to the Top of a Report; title: New! Sort Pictures With Data; title: Quickly Filter a List to Certain Records; title: New! Use Search While Filtering; title: New! Filter by Selection; title: Use AutoSum After Filtering; title: New! Filter Only Some Columns; title: Find the Unique Values in a Column; title: Use Advanced Filter; title: Replace Multiple Filter Criteria with a Single Row of Formulas; title: Add Subtotals to a Data set; title: Use Group & Outline Buttons to Collapse Subtotaled Data; title: Copy Just Totals from Subtotaled Data; title: New! Manually Apply Groups; title: New! Sort Largest Customers to the Top; title: Enter a Grand Total of Data Manually Subtotaled; title: New! Select 100 Columns in Subtotals; title: Add Other Text to the Subtotal Lines; title: Subtotals by Product Within Region; title: Format the Subtotal Rows; title: My Manager Wants a Blank Line After Each Subtotal; title: Subtotal One Column and COUNT Another Column; title: New! Can You Get Medians?; title: New! Horizontal Subtotals; title: Be Wary; title: Send Error Reports; title: Help Make Excel 2014 Better; title: Remove Blank Rows from a Range; title: Remove Blanks from a Range While Keeping the Original Sequence; title: double Space Your Data Set; title: Use Find to Find an Asterisk; title: Use an Ampersand in a Header; title: Hide Zeros & Other Custom Number Formatting Tricks; title: Use Consolidation to Combine Two Lists; title: Combine Four Quarterly Reports; title: Find Total Sales by Customer by Combining Duplicates; title: Remove Duplicates; title: Protect Cells That Contain Formulas; title: New! Find Differences In Two Lists; title: Number Each Record for a Customer, Starting at 1 for a New Customer; title: Add a Group Number to Each Set of Records That Has a Unique Customer Number; title: Deal with Data in Which Each Record Takes Five Physical Rows; title: Add a Customer Number to Each Detail Record; title: Use a Built-in Data Entry Form; title: New! Cell AutoComplete Stopped Working; title: Use a Pivot Table to Summarize Detailed Data; title: Your Manager Wants Your Report Changed; title: Add or Remove Fields from an Existing Pivot Table; title: Summarize Pivot Table Data by Three Measures; title: Why Does the Pivot Table Field List Keep Disappearing?; title: Move or Change Part of a Pivot Table; title: See Detail Behind One Number in a Pivot Table; title: Use Multiple Value Fields as a Column or Row Field; title: Update Data Behind a Pivot Table; title: New! Convert Your Data to a Table Before Adding Records; title: New! Create a Flattened Pivot Table for Reuse; title: Replace Blanks in a Pivot Table with Zeros; title: Collapse and Expand Pivot Fields; title: Specify a Number Format for a Pivot Table Field; title: New! Preserve Column Widths; title: New! Show Yes/No in a Pivot Table; title: Format Pivot Tables with the Gallery; title: None of the 46,273 Built-In Styles Do What My Manager Asks For; title: Select Pivot Table Parts For Formatting; title: Apply Conditional Formatting to a Pivot Table; title: New! Can I Save Formatting in a Template?; title: Manually Re-sequence the Order of Data in a Pivot Table; title: Present a Pivot Table in High-to-Low Order by Revenue; title: Group Daily Dates by Month in a Pivot Table; title: New! Create a Year-Over-Year Report; title: Group by Week in a Pivot Table; title: Limit a Pivot Report to Show Just the Top 5 Customers; title: Build a Better Top Five Using Groups; title: New! Build a Better Top Five with A Filter Hack; title: Why Aren't the Cool New Filters Available in My Pivot Table?; title: Limit a Report to Just One Region; title: Create an Ad-Hoc Reporting Tool; title: Create a Report for Every Customer; title: Create Pivot Charts; title: New for Excel 2010! Add Visual Filters to a Pivot Table; title: New for Excel 2010! Run Many Pivot Tables From one SLicer; title: Group Employees Into Age Bands; title: New! Create a Frequency Distribution; title: New! Grouping 1 Pivot Table Groups Them All; title: New! Reduce Size 50% Before Sending; title: New! Drag Fields to the Pivot Table; title: Why Can't Co-Workers with Excel 2003 Use My Pivot Table?; title: Create a Report That Shows Count, Min, Max, Average, Etc.; title: Better Calculations with Show Values As; title: New for Excel 2010! Pivot Ranks Don't Match RANK(); title: Calculated Fields in a Pivot Table; title: Add a Calculated Item to Group Items in a Pivot Table; title: Group Text Fields to BUild TerritoriesINstead of Using Calculated Items; title: New! Calculations Outside of Pivot Tables; title: New! Show Customer Account & Name; title: New! Show Months with Zero Sales; title: Create a Unique List of Customers with a Pivot Table; title: Use a Pivot Table to Compare Two Lists; title: Use a Pivot Table When There Is No Numeric Data; title: New! Report Text in a Pivot Table; title: New! Fix Misspelled Customer Names; title: Create a Pivot Table from Access Data; title: New! Whatever Happened to Multiple Consolidation Ranges in Pivot Tables?; title: New for Excel 2010 Power Pivot! Five Reasons to Use PowerPivot; title: New for Excel 2010 Power Pivot! Get the Correct Version of PowerPivot; title: New for Excel 2010 Power Pivot! Get Excel Data Into PowerPivot; title: New for Excel 2010 Power Pivot! Why Can't I Edit Data in PowerPivot?; title: New for Excel 2010 Power Pivot! Import External Data to PowerPivot; title: New for Excel 2010 Power Pivot! Define Relationships Between Tables; title: New for Excel 2010 Power Pivot! Adding Calculations In PowerPivot; title: New for Excel 2010 Power Pivot! Refer to a Related Table in a Formula; title: New for Excel 2010 Power Pivot! Hide Fields in PowerPivot; title: New for Excel 2010 Power Pivot! Missing the Point: Sorting & Filtering; title: New for Excel 2010 Power Pivot! Pivot Table, Pivot Charts, Tables & Charts, Charts & Charts; title: New for Excel 2010 Power Pivot! Using the PowerPivot Field List; title: New for Excel 2010 Power Pivot! PowerPivot Arranges Your Slicers; title: New for Excel 2010 Power Pivot! Month Names Don't Sort in PowerPivot; title: New for Excel 2010 Power Pivot! Feature X Won't Work in PowerPivot; title: New for Excel 2010 Power Pivot! Using Calculations Other Than Sum; title: New for Excel 2010 Power Pivot! Replace Calculated Fields with DAX; title: New for Excel 2010 Power Pivot! Calculate() is Like SUMIFS(); title: New for Excel 2010 Power Pivot! Unapply a Filter Using DAX; title: New for Excel 2010 Power Pivot! Unfilter Using Time Intelligence; title: New for Excel 2010 Power Pivot! Using MAXX, MINX, and SUMX; title: New for Excel 2010 Power Pivot! Convert PowerPivot to Formulas; title: New for Excel 2010 Power Pivot! January Actuals and February Plan; title: Web Queries Fail with Web 2.0; title: New! Use Easy-XL for Data Wrangling; title: Create a Chart with One Click; title: Teach Excel Your Favorite Chart; title: Move a Chart; title: New! Copy a Chart Detached from the Data; title: Add New Data to a Chart; title: Begin Formatting The Chart on Design; title: New! Continue Formatting with Layout; title: Legend At the Top; title: Display an Axis in Millions Using the Layout Tab's Built-in Menus; title: Display an Axis in Trillions Using the More Options Choice; title: Select Anything on a Chart to Format; title: The Format Dialog Box Offers a New Trick; title: Use Meaningful Chart Titles; title: Avoid 3-D Chart Types; title: New! Prevent the Drop to Zero; title: Explode One Slice of the Pie; title: New! Chart On a Coin; title: New! Move Small Pie Slices To Second Chart; title: Add a Trendline to a Chart; title: New! See Detail on Large & Small Data Points; title: Chart Two Series with Differing Orders of Magnitude; title: New! Interactive Chart to SHow Next Customer; title: New! Tie the Chart Title to a Cell; title: New! Use an Invisible Series to Float COlumns; title: New! Use Rogue Series for Shading; title: New! Two Stacked, One Clustered Column; title: New! Conditional Format a Chart; title: New! Scatter Charts are Versatile But Require a Different Workflow; title: New! When do I Use Which Chart Type?; title: New for Excel 2010! Create Tiny Charts with Sparklines; title: New for Excel 2010! Sparklines Are Not Scaled Together; title: New for Excel 2010! What is the Win Loss Sparkline For?; title: New for Excel 2010! Labeling Sparklines; title: New for Excel 2010! Shade the Normal Range in a Sparkline; title: Convert a Table of Numbers to a Visualization; title: New! Control Values for Each Icon; title: Add Icons to Only the Good Cells; title: New for Excel 2010! Data Bars Options in Excel 2010; title: New for Excel 2010! Comparative Histogram; title: Select Every Kid in Lake Wobegon; title: Color All Sales Green for a Day if Total Sales Exceed $1,000; title: New! There is a Font Optimized for Excel; title: New! Show Checkmarks in Excel; title: Use the Border Tab in Format Cells; title: Double Underline a Grand Total; title: New! Where Are My Excel 2003 Colors?; title: Transform Black-and-White Spreadsheets to Color by Using a Table; title: Fit a Slightly Too-Large Value in a Cell; title: Turn Off Wrap Text in Pasted Data; title: Delete All Pictures in Pasted Data; title: New! Prevent Long Text from Spilling; title: New! Show Two Values in a Split Cell; title: For Each Cell in Column A, Have Three Rows in Column B; title: Show Results as Fractions; title: New! Better SCientific Notation; title: New! Fill a Cell with Asterisks; title: Use Cell Styles to Change Formats; title: New! I type 152 and get 1.52; title: New! Add Your Own Styles; title: New! Share Styles Between Workbooks; title: Move Columns by Sorting Left to Right; title: Move Columns Using Insert Cut Cells; title: Move Rows or Columns with Shift Drag; title: Change the Width of All Columns with One Command; title: New! Copy Column Widths to a New Range; title: New! Copy Row Heights; title: Use White Text to Hide Data; title: New! Hide Values Using a Number Format; title: Hide and Unhide Data; title: Group Columns Instead of Hiding Them; title: Hide Error Cells When Printing; title: New! Unhide All Sheets; title: Organize Your Worksheet Tabs with Color; title: Copy Formatting to a New Range; title: Copy Without Changing Borders; title: Power Up Format Painter; title: New! Fill Formatting; title: Change All Red Font Cells to Blue Font; title: New! Replace Partially Bold Cells; title: Change the Look of Your Workbook with Document Themes; title: New! Create Your Own Theme; title: Change the Background of a Worksheet; title: Add a Printable Background to a Worksheet; title: Remove Hyperlinks Automatically Inserted by Excel; title: New! Select a Hyperlink Cell Without Following the Hyperlink; title: New! Pasted URLs Don't Become Hyperlinks; title: Leave Helpful Notes with Cell Comments; title: Debug Using a Printed Spreadsheet; title: Change the Appearance of Cell Comments; title: Control How Your Name  Appears in Comments; title: Force Certain Comments to Be Always Visible to Provide a Help System to Users of Your Spreadsheet; title: Change the Comment Shape to a Star; title: Add a Pop-up Picture of an Item in a Cell; title: Add a Pop-up Picture to Multiple Cells; title: Build Complex Reports Where Columns in Section 1 Don't Line Up with Section 2; title: Paste a Live Picture of a Cell; title: Add Formatting to Pictures in Excel; title: New! Remove Picture Background; title: New! Inserting a Screen Shot in Excel 2010; title: New! Draw an Arrow to Visually Illustrate That Two Cells Are Connected; title: Add Connectors to Join Shapes; title: Circle a Cell on Your Worksheet; title: Draw Perfect Circles; title: Add Text to Any Closed Shape; title: Place Cell Contents in a Shape; title: Rotate a Shape; title: Create Dozens of Lightning Bolts; title: Make a Logo into a Shape; title: Draw Business Diagrams with Excel; title: Choose the Right Type of SmartArt; title: Use the Text Pane to Build SmartArt; title: Change a SmartArt Layout; title: Format SmartArt; title: Switch to the Format Tab to Format Individual Shapes; title: Use Cell Values as the Source for SmartArt Content; title: Add WordArt to a Worksheet; title: Chart and SmartArt Text Is Automatically WordArt; title: Use MapPoint to Plot Data on a Map; title: Add a Dropdown to a Cell; title: Configure Validation to "Ease up"; title: Use Validation to Create Dependent Lists; title: Add a ToolTip to a Cell to Guide the Person Using the Workbook