Power Excel with MrExcel: 617 Excel Mysteries Solved, 2017 Edition

In this Book

• Foreword
• Why Does Office 365 Have Better Features?
• Which Version of Office 365 Has Power Pivot?
• Why Do I Have to Sign in to Excel?
• How Can I Use Excel on Dual Monitors?
• How Can I Open the Same Workbook Twice?
• Find Icons on the Ribbon
• Where is File, Exit?
• Where are My Macros?
• Customizing the Ribbon
• Go Wide
• Minimize the Ribbon to Free up a Few More Rows
• Use a Wheel Mouse to Scroll Through the Ribbon Tabs
• Why Do the Charting Ribbon Tabs Keep Disappearing?
• Use Dialog Launchers for More Choices
• Icon, Dropdowns, and Hybrids
• Zoom is at the Bottom
• Make Your Most-Used Icons Always Visible
• The Excel 2003 Alt Keystrokes Still Work (If You Type Them Slowly Enough)
• Use Keyboard Shortcuts to Access the Ribbon
• Why Do I Have Only 65,536 Rows?
• Which File Format Should I Use?
• Why Does the File Menu Cover the Entire Screen?
• How Do I Close the File Menu?
• Increase the Number of Workbooks in the Recent Files List
• Change All Print Settings in Excel
• I Just Want the Old Print Preview Back
• Get Quick Access to Formatting Options Using the Mini Toolbar
• What is Protected Mode?
• Use a Trusted Location to Prevent Excel's Constant Warnings
• My Manager Wants Me to Create a New Expense Report from Scratch
• Open a Copy of a Workbook
• Open Excel with Ctrl+Alt+X
• Have Excel Always Open Certain Workbook(s)
• Set up Excel Icons to Open a Specific File on Startup
• Use a Macro to Customize Startup
• Control Settings for Every New Workbook and Worksheet
• Excel Says I Have Links, but I Can Not Find Them
• Automatically Move the Cell Pointer after Enter
• Return to the First Column after Typing the Last Column
• Enter Data in a Circle (Or Any Pattern)
• How to See Headings You Scroll around a Report
• How to See Headings and Row Labels as You Scroll around a Report
• Why is the Scrollbar Slider Suddenly Tiny?
• Why Won't My Scrollbar Scroll to My Charts?
• Jump to the Edge of the Data
• Jump to Next Corner of Selection
• Ctrl+Backspace brings the Active Cell into View
• Zoom with the Wheel Mouse
• Copy a Formula to All Data Rows
• Copy the Characters from a Cell Instead of Copying an Entire Cell
• A Faster Way to Paste Values
• Quickly Turn a Range on its Side
• Quickly Rearrange Rows or Columns
• Quickly Copy Worksheets
• Use Group Mode to Change All Worksheets
• Find Text Numbers
• Why Can't Excel Find a Number?
• Mix Formatting in a Single Cell
• Enter a Series of Months, Days, or More by Using the Fill Handle
• Have the Fill Handle Fill Your List of Part Numbers
• Teach Excel to Fill A, B, C
• Add Total to the End of Jan, Feb, … Dec
• Put Date & Time in a Cell
• Use Excel as a Word Processor
• Add Excel to Word
• Use Hyperlinks to Create an Opening Menu for a Workbook
• Spell Check a Region
• Stop Excel from Autocorrecting Certain Words
• Use Autocorrect to Enable a Shortcut
• Why Won't the Track Changes Feature Work in Excel?
• Simultaneously Collaborate on a Workbook with Excel Web App
• How to Print Titles at the Top of Each Page
• Print a Letter at the Top of Page 1 and Repeat Headings at the Top of Each Subsequent Page
• How to Print Page Numbers at the Bottom of Each Page
• How to Make a Wide Report Fit to One Page Wide by Many Pages Tall
• Add a Printable Watermark
• Print Multiple Ranges
• Add a Page Break at Each Change in Customer
• Save My Worksheet as a PDF File
• Send an Excel File as an Attachment
• Save Excel Data as a Text File
• Close All Open Workbooks
• I Just Closed an Unsaved Workbook
• Roll Back to an Autosaved Version
• Have Excel Talk to You
• Enter Special Symbols
• What Do All the Triangles Mean?
• Why Does Excel Insert Cell Addresses When I Edit in a Refedit Box?
• F4 Repeats Last Command
• Print All Excel Keyboard Shortcuts
• Create a Personal Macro Workbook
• Macro to Toggle Positive to Negative
• Assign a Macro to a Shortcut Key
• Assign a Macro to a Toolbar Icon
• Use a Macro to Change Case to Upper, Lower or Proper
• Get Free Excel Help
• Start a Formula with = or +
• Three Methods of Entering Formulas
• Why Does Excel 2013 Look like a Slot Machine?
• Use Parentheses to Control the Order of Calculations
• Long Formulas in the Formula Bar
• Copy a Formula That Contains Relative References
• Copy a Formula While Keeping One Reference Fixed
• Create a Multiplication Table
• Calculate a Sales Commission
• Simplify the Entry Dollar Signs in Formulas
• Learn R1C1 Referencing to Understand Formula Copying
• Create Easier-to-Understand Formulas with Named Ranges
• See All Named Ranges at 39% Zoom
• Use Named Constants to Store Numbers
• Total without Using a Formula
• Add or Multiply Two Columns without Using Formulas
• Type 123 to Enter 1.23
• Join Two Text Columns
• Concatenate Several Cells
• Join Text with a Date or Currency
• Break Data Apart Using Flash Fill
• Parse Data Using Text to Columns
• Excel is Randomly Parsing Pasted Data
• I Lose Leading Zeroes from CSV Files
• Open CSV File with Dates in D/M/Y Format
• Handle Dates in YYYYMMDD Format
• My G/L Software Uses a Trailing minus for Negative Numbers
• Parse Data with Leader Lines
• Parse Multi-Line Cells
• Change Smith, Jane to Jane Smith
• Convert Numbers to Text
• Fill a Cell with Repeating Characters
• Clean Hasn't Kept up with the Times
• Add the Worksheet Name as a Title
• Use Autosum to Quickly Enter a Total Formula
• AutoSum Doesn't Always Predict My Data Correctly
• Use the AutoSum Button to Enter Averages, Min, Max, and Count
• Ditto the Formula above
• The Count Option of the AutoSum Dropdown Doesn't Appear to Work
• Total the Red Cells
• Automatically Number a List of Employees
• Automatically Number the Visible Rows
• Discover New Functions Using the Fx Button
• Get Help on Any Function While Entering a Formula
• Yes, Formula Autocomplete is Cool, If You Can Stop Entering the Opening Parentheses
• Use F9 in the Formula Bar to Test a Formula
• Quick Calculator
• When Entering a Formula You Get the Formula Instead of the Result
• Highlight All Formula Cells Using Conditional for Matting
• You Change a Cell in Excel but the Formulas Do Not Calculate
• Calculate One Range
• Why Use the Intersection Operator?
• Understand Implicit Intersection
• Find the Longest Win Streak
• Add B5 on All Worksheets
• Consider Formula Speed
• Exact Formula Copy
• Calculate a Loan Payment
• Calculate Many Scenarios for Loan Payments
• Back into an Answer Using Goal Seek
• Create an Amortization Table
• Do 40 What-If Analyses Quickly
• Random Walk down Wall Street
• What-If for 3 or More Variables
• Rank Scores
• Rank a List without Ties
• Sorting with a Formula
• Round Numbers
• Round to the Nearest $0.05 with MROUND
• Round Prices to the Next Highest $5
• Round 0.5 towards Even per ASTM-E29
• Separate the Integer from the Decimals
• Why is This Price Showing $27.85000001 Cents?
• Calculate a Percentage of Total
• Calculate a Running Percentage of Total
• Use the ^ Sign for Exponents
• Raise a Number to a Fraction to Find the Square or Third Root
• Calculate a Growth Rate
• Find the Area of a Circle
• Figure Out Lottery Probability
• Help Your Kids with Their Math
• Convert Units
• XOR Only Works Correctly for Two Values
• Find the Second Largest Value
• Format Every other Row in Green
• Use If to Calculate a Bonus
• If with Two Conditions
• Tiered Commission Plan with If
• Display Up/Down Arrows
• Stop Showing Zeroes in Cell Links
• Count Records That Match a Criterion
• Build a Table That Will Count by Criteria
• Sum Records That Match a Criterion
• Can the Results of a Formula Be Used in Sumif?
• Calculate Based on Multiple Conditions
• Avoid Errors Using IFERROR
• Use VLOOKUP to Join Two Tables
• Every VLOOKUP Ends in False
• Lookup Table Does Not Have to Be Sorted
• Beware of #N/A from VLOOKUP
• Add New Items to the Middle of Your Lookup Table
• Consider Naming the Lookup Table
• Remove Leading and Trailing Spaces
• Your Lookup Table Can Go across
• Copy a VLOOKUP across Many Columns
• Index Sounds like an Inane Function
• You Already Know Match, Really!
• Index Sounds like an Inane Function - II
• VLOOKUP Left
• Fast Multi-Column VLOOKUP
• Speed up Your VLOOKUP
• Return the Next Larger Value in a Lookup
• Two-Way Lookup
• Combine Formulas into a Mega-Formula
• Combine Two Lists Using VLOOKUP
• Watch for Duplicates When Using VLOOKUP
• Return the Last Entry
• Return the Last Matching Value
• Sum All of the Lookups
• Embed a Small Lookup Table in Formula
• I Don't Want to Use a Lookup Table to Choose One of Five Choices
• Is There Something More Flexible than Choose?
• Lookup Two Values
• Add Comments to a Formula
• Create Random Numbers
• Randomly Sequence a List
• Play Dice Games with Excel
• Generate Random without Repeats
• Calculate a Trendline Forecast
• Forecast Data with Seasonality
• Build a Model to Predict Sales Basesd on Multiple Regression
• Switching Columns into Rows Using a Formula
• Sum a Range That is C5 Rows Tall Using Offset
• Replace Volatile Offset with Index
• How Can You Test for Volatility?
• Whatever Happened to the @@ Function?
• Tables are like a Database in Excel
• Dealing with Table Formulas
• Rename Your Tables
• Charts, VLOOKUP & Pivots Expand with the Table
• Before Deleting a Cell, Find Out If other Cells Rely on it
• Calculate a Formula in Slow Motion
• Which Cells Flow into This Cell?
• Color All Precedents or Dependents
• Monitor Distant Cells
• Auditing Worksheets with Inquire
• Use Real Dates
• How Can I Tell If Have Real Dates?
• Convert Text Dates to Real Dates
• Format Dates
• Format Dates as Quarters or Weeks
• Display Monthly Dates
• Add a Column to Show Month or Weekday
• Calculate First of Month
• Calculate the Last Day of the Month
• Calculate Invoice Due Dates
• Calculate Receivable Aging
• Now, or Today?
• Find the Last Sunday of the Month
• Calculate Work Days
• Calculate Work Days for a Farmers Market
• Calculate Age in Years, Months, Days
• Coerce an Array of Dates from 2 Dates
• Use Real Times
• Strangeness of Time Formatting
• Convert Time to Decimal Hours
• Calculate with Time
• Enter Minutes and Seconds
• Convert Text to Time
• Can Excel Track Negative Time?
• Fill Blanks with Value above
• See Formulas in Excel 2013
• Create a Bell Curve in Excel
• Change from Lower to Upper Case in Excel
• Spell Out Numbers in Excel
• Copy Macro Code from the Internet into an Add-in
• Return Data from a Webservice in Excel 2013
• Add New Functions to Excel with Fast Excel Speedtools Extras
• =SUM(B1:B5) is Better than =B1+B2+B3+B4+B5
• How to Set up Your Data for Easy Sorting and Subtotals
• How to Fit a Multiline Heading into One Cell
• No Tiny Blank Columns between Columns
• How to Sort Data
• Sort Days of the Week
• Sort a Report into a Custom Sequence
• Sort All Red Cells to the Top of a Report
• Sort Pictures with Data
• Quickly Filter a List to Certain Records
• Use Search While Filtering
• Filter by Selection
• Use Autosum after Filtering
• Filter Only Some Columns
• Find the Unique Values in a Column
• Use Advanced Filter
• Replace Multiple Filter Criteria with a Single Row of Formulas
• Add Subtotals to a Data Set
• Use Group & Outline Buttons to Collapse Subtotaled Data
• Manually Apply Groups
• Group Report Sections
• Copy Just Totals from Subtotaled Data
• Sort Largest Customers to the Top
• Select 100 Columns in Subtotals
• Enter a Grand Total of Data Manually Subtotaled
• Add other Text to the Subtotal Lines
• Subtotals by Product within Region
• Format the Subtotal Rows
• My Manager Wants a Blank Line after each Subtotal
• Subtotal One Column and Count Another Column
• Can You Get Medians?
• Horizontal Subtotals
• Be Wary
• Send Error Reports
• Help Make Excel Better
• Remove Blank Rows from a Range
• Remove Blanks from a Range While Keeping the Original Sequence
• Double Space Your Data Set
• Use Find to Find an Asterisk
• Use an Ampersand in a Header
• Hide Zeros & Other Custom Number Formatting Tricks
• Use Consolidation to Combine Two Lists
• Combine Four Quarterly Reports
• Find Total Sales by Customer by Combining Duplicates
• Remove Duplicates
• Preview Remove Duplicates without Removing Them
• Protect Cells That Contain Formulas
• Find Differences in Two Lists
• Number Each Record, Starting at 1 for a New Customer
• Add a Group Number to Each Set of Records That Has a Unique Customer Number
• Deal with Data in Which Each Record Takes Five Physical Rows
• Add a Customer Number to Each Detail Record
• Use a Built-in Data Entry Form
• Cell Autocomplete Stopped Working
• Data Cleansing with Flash Fill in Excel 2013
• Flash Fill Was There and is Now Gone
• Flash Fill Was Not Perfect
• Flash Fill Won't Fill Numbers
• Flash Fill and Dates
• Flash Fill and Ambiguous Data
• Use a Pivot Table to Summarize Detailed Data
• Your Manager Wants Your Report Changed
• Add or Remove Fields from an Existing Pivot Table
• Summarize Pivot Table Data by Three Measures
• Why Does the Pivot Table Field List Keep Disappearing?
• Move or Change Part of a Pivot Table
• See Detail behind One Number in a Pivot Table
• Use Multiple Value Fields as a Column or Row Field
• Update Data behind a Pivot Table
• Why Do I Get a Count Instead of a Sum?
• Convert Your Data to a Table before Adding Records
• Create a Flattened Pivot Table for Reuse
• Replace Blanks in a Pivot Table with Zeros
• Collapse and Expand Pivot Fields
• Specify a Number Format for a Pivot Table Field
• Preserve Column Widths
• Show Yes/No in a Pivot Table
• Pivot Table Format Defaults
• Format Pivot Tables with the Gallery
• None of the 46,273 Built-in Styles Do What My Manager Asks for
• Select Pivot Table Parts for Formatting
• Apply Conditional Formatting to a Pivot Table
• Can I save Formatting in a Template?
• Manually Re-Sequence the Order of Data in a Pivot Table
• Present a Pivot Table in High-to-Low Order by Revenue
• Excel 2016 Sometimes Auto-Groups Daily Dates to Month
• Group Daily Dates by Month in a Pivot Table
• Create a Year-over-Year Report
• Group by Week in a Pivot Table
• Limit a Pivot Report to Show Just the Top 5 Customers
• Build a Better Top Five Using Groups
• Build a Better Top Five with a Filter Hack
• Build a Better Top 5 Using the Data Model
• Limit a Report to Just One Region
• Create an Ad-Hoc Reporting Tool
• Create a Report for Every Customer
• Create Pivot Charts
• Add Visual Filters to a Pivot Table or Regular Table
• Run Many Pivot Tables from One Slicer
• Filter Dates Using a Timeline in Excel 2013 & Newer
• Group Employees into Age Bands
• Create a Frequency Distribution
• Grouping 1 Pivot Table Groups Them All
• Reduce Size 50% before Sending
• Drag Fields to the Pivot Table
• Create a Report That Shows Count, Min, Max, Average, etc
• Better Calculations with Show Values as
• Pivot Ranks Don't Match Rank()
• Calculated Fields in a Pivot Table
• Add a Calculated Item to Group Items in a Pivot Table
• Group Text Fields to Build Territories
• Calculations outside of Pivot Tables
• Show Customer Account & Name
• Show Months with Zero Sales
• Create a Unique List of Customers with a Pivot Table
• Use a Pivot Table to Compare Two Lists
• Use a Pivot Table When There is No Numeric Data
• Fix Misspelled Customer Names
• Create a Pivot Table from Access Data
• What Happened to Multiple Consolidation Ranges in Pivot Tables?
• What are the Products in Power BI and How Can I Get Them?
• Know if You Have 32-Bit or 64-Bit Excel
• Load and Clean Data with Power Query
• Power Query is Easier to Learn than VBA Macros
• I Have More than 1,048,576 Rows of Data
• Load a List of File Names into Excel
• Load a Folder of CSV Files into a Single Excel Worksheet
• My Headings Repeat Every 60 Rows
• Fill in Blanks with Values from above
• Use Power Query to Clean Data Already in Excel
• Pivot from Multiple Tables in Excel 2013 Data Model
• Reporting from the Smaller Side of the Relationship
• Use Joiner Tables between Tables
• Five Reasons to Use Power Pivot
• Why isn't Power Pivot Tab in the Ribbon?
• Get Excel Data into Power Pivot
• Open the Power Pivot Window
• Define Relationships between Tables
• Sort Month Name by Month Number
• Create a Calendar Table
• The Formulas are Called Dax
• Adding Calculations in the Power Pivot Grid
• Refer to a Related Table in a Formula
• Creating the Power Pivot Table
• Building the Pivot Table
• Feature X won't Work in Power Pivot
• Replace Calculated Fields with DAX
• Calculate() is like SUMIFS()
• Unapply a Filter Using DAX
• Unfilter Using Time Intelligence
• Convert Power Pivot to Formulas
• January Actuals and February Plan
• Power View is Replaced with Power BI
• Power BI Transforms Excel Data into Interactive Dashboards
• First Power BI Step—Get a Free Account for Power BI
• Optional Step 1—Take the Sample Dashboards for a Spin
• Use Q&A to Investigate Your Data
• Click a Dashboard Element to Open the Underlying Report
• Click in One Chart to Filter other Charts
• Enable Drill-down Mode
• Sorting is Hidden behind More Options
• Optional Step 2—Connect to an Existing Service
• Download Power BI Desktop to Your Computer
• Prepare Your Excel Data for Power BI
• Add a Calendar Table
• Three Icons in Power BI Desktop
• In Power BI Desktop, the Power Query Tools are Called Get Data
• Load Your Excel Data to Power BI Desktop
• In Power BI Desktop, the Power Pivot Tools are Called Modeling
• Define Relationships in Power BI Desktop
• Classify Your Geography Fields in Power BI Desktop
• Prevent Power BI from Adding up Year Fields
• Sort This by That
• Define Synonyms in Power BI Desktop
• Hide Columns So They Can't Be Chosen
• Three Ways to Build Visualizations in a Report
• Formatting a Chart
• Add Lines Using Analytics
• Adding More Visualizations to a Page
• It is Insanely Easy to Build a Hierarchy
• Open Source Visualizations
• Every Chart is a Slicer for other Charts
• A Report Can Have Multiple Pages
• Using Maps in Power BI Desktop
• Three Types of Filters
• Where is the Top 10 Filter?
• Add Titles, Logos, & Embelishments
• Don't Forget to save Your File!
• Share Your Dashboard to Power BI in the Cloud
• Use Quick Insights
• View Your Report in a Browser
• Q&A Works on Dashboards, Not Reports
• Share a Dashboard with Your Manager
• Wait a Second - A Sharing Link? Isn't This Dangerous?
• Consume Your Dashboard Using Power BI Mobile
• What Does All of This Cost?
• How Do I Update My Dashboard Every Day?
• That's All for Power BI in This Book
• Put a Pivot Table on a Map in Excel 2013 Power Map
• Tricks for Navigating the Map in Power Map
• Fine-Tuning Power Map
• Creating a Video from Power Map
• Use an Alternate Map for Power Map
• Filtering in Power Map
• Excel Data to Mailing Labels in Word
• Excel 2013 Allows Slicers on Regular Tables
• Use Power Query to Load Many Web Pages
• Create a Chart with One Click
• Teach Excel Your Favorite Chart
• Move a Chart
• Copy a Chart Detached from the Data
• Add New Data to a Chart
• Excel 2013 Offers Easy Chart Formatting
• Begin Excel 2010 Formatting on Design
• The Chart Layout Tab is Missing in Excel 2013
• Formatting Charts in Excel 2010 with Layout
• Legend at the Top
• The 2010 Format Dialog Box is a Task Pane in 2013
• Display an Axis in Millions
• Select Anything on a Chart to Format
• The Format Dialog Box Offers a New Trick
• Use Meaningful Chart Titles
• Avoid 3-D Chart Types
• Prevent the Drop to Zero
• Explode One Slice of the Pie
• Move Small Pie Slices to Second Chart
• Add a Trendline to a Chart
• See Detail on Large & Small Data Points
• Chart Two Series with Differing Orders of Magnitude
• Hide Subtotals from Chart in Excel 2013
• Create Pivot Charts from Detail Data in Excel 2013
• Use Formulas for Chart Labels in Excel 2013
• Interactive Chart to Show One Customer
• Tie the Chart Title to a Cell
• Excel 2016 Adds a Waterfall Chart
• Use an Invisible Series to Float Columns
• Use Rogue Series for Shading
• Two Stacked, One Clustered Column
• Conditional Format a Chart
• Scatter Charts are Versatile but Require a Different Workflow
• When Do I Use Which Chart Type?
• Track Sales Leads with a Funnel Chart
• Create Tiny Charts with Sparklines
• Sparklines are not Scaled Together
• What is the Win Loss Sparkline for?
• Labeling Sparklines
• Shade the Normal Range in a Sparkline
• Convert a Table of Numbers to a Visualization
• Control Values for Each Icon
• Add Icons to Only the Good Cells
• Use the Sign Function for Up/Flat/Down Icon Set
• Data Bars Options
• Comparative Histogram
• Select Every Kid in Lake Wobegon
• There is a Font Optimized for Excel
• Show Checkmarks in Excel
• Add Bullets to Excel
• Use the Border Tab in Format Cells
• Remove Borders from Filled Cells
• Double Underline a Grand Total
• Why Did the Colors Change in Excel 2013?
• Where are My Excel 2003 Colors?
• Transform Black-and-White Spreadsheets to Color by Using a Table
• Fit a Slightly Too-Large Value in a Cell
• Turn off Wrap Text in Pasted Data
• Delete All Pictures in Pasted Data
• Prevent Long Text from Spilling
• Show Two Values in a Split Cell
• For Each Cell in Column A, Have Three Rows in Column B
• Show Results as Fractions
• Better Scientific Notation
• Fill a Cell with Asterisks
• I Type 152 and Get 1.52
• Use Cell Styles to Change Formats
• Add Your Own Styles
• Share Styles between Workbooks
• Move Columns by Sorting Left to Right
• Move Columns Using Insert Cut Cells
• Move Rows or Columns with Shift Drag
• Select All Cells Using the Keyboard
• Change the Width of All Columns with One Command
• Copy Column Widths to a New Range
• Copy Row Heights
• Use White Text to Hide Data
• Hide Values Using a Number Format
• Hide and Unhide Data
• Group Columns Instead of Hiding Them
• Hide Error Cells When Printing
• Unhide All Sheets
• Very Hide a Worksheet
• Organize Your Worksheet Tabs with Color
• Copy Formatting to a New Range
• Copy without Changing Borders
• Power up Format Painter
• Fill Formatting
• Change All Red Font Cells to Blue Font
• Replace Partially Bold Cells
• Change the Look of Your Workbook with Document Themes
• Create Your Own Theme
• Bring Back the Office 2010 Colors and Shiny Objects
• Change the Background of a Worksheet
• Add a Printable Background to a Worksheet
• Remove Hyperlinks Automatically Inserted by Excel
• Select a Hyperlink Cell without following the Hyperlink
• Pasted Urls Don't Become Hyperlinks
• Debug Using a Printed Spreadsheet
• Leave Helpful Notes with Cell Comments
• Change the Appearance of Cell Comments
• Control How Your Name Appears in Comments
• Force Some Comments to Always Be Visible to Provide a Help System
• Change the Comment Shape to a Star
• Add a Pop-up Picture of an Item in a Cell
• Add a Pop-up Picture to Multiple Cells
• Build Reports Where Columns in Each Section 1 Don't Line up
• Paste a Live Picture of a Cell
• Add Formatting to Pictures in Excel
• Remove Picture Background
• Inserting a Screen Clipping
• Draw an Arrow to Visually Illustrate That Two Cells are Connected
• Add Connectors to Join Shapes
• Circle a Cell on Your Worksheet
• Draw Perfect Circles
• Add Text to Any Closed Shape
• Place Cell Contents in a Shape
• Rotate a Shape
• Create Dozens of Lightning Bolts
• Make a Logo into a Shape
• Draw Business Diagrams with Excel
• Choose the Right Type of Smartart
• Use the Text Pane to Build Smartart
• Change a Smartart Layout
• Format Smartart
• Switch to the Format Tab to Format Individual Shapes
• Use Cell Values as the Source for Smartart Content
• Add Wordart to a Worksheet
• Chart and Smartart Text is Automatically Wordart
• Excel 2013 Offers an Excel App Store
• Add a Dropdown to a Cell
• Configure Validation to “Ease up”
• Use Validation to Prevent Duplicate Data Entry
• Use Validation to Create Dependent Lists
• Add a Tooltip to a Cell to Guide the Person Using the Workbook
• Combine Validation with Autocomplete
• Afterword