647 Chapters

About the Author

Dedication

Acknowledgments

Foreword

Why Does Office 365 Have Better Features?

Should I Buy Office 2019 or Subscribe to Office 365?

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?

Collapse the Search Box

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

How to See Headings as 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

Ctrl+Click to Unselect Cells

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

Simultaneously Collaborate on an Excel Workbook

Beware the AutoSave If You Are Not Co-Authoring

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

eXPORT 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

Prevent Cell Addresses When EditING 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

Change the Default File Location

Copy the Current File Location

Get Free Excel Help

Start a Formula with = or +

Three Methods of Entering Formulas

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 of 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

Use the Function Arguments Dialog with Nested Functions

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 Formatting

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

Sensitivity Analysis with 100K Formulas

Random Walk Down Wall Street

What-If For 3 Or More Variables

Rank Scores

Rank a List Without Ties

Sorting with a Formula

Sorting with Dynamic Arrays

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 Based 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 Next to the Answer

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

Add New Functions to Excel with Fast Excel SpeedTools Extras

=SUM(B1:B5) is Better Than =B1+B2+B3+B4+B5

Geography, Stock, and Exchange Rate Data Types

Getting Exchange Rates Using Stock Data Types

Get Stock Quotes

Dynamic Arrays: Formulas Can Now Spill

What Happens if A Formula can't spill?

If Your Formula Points to a Table, the Array Will Expand

Using the New Array Reference Notation: E3#

A Simple Sort with One Argument

A Sort Based on Two or More Columns of Results

A Random Sort Using SORT and RANDARRAY

A Sort by Something That Is Not in the Results

Using The FILTER Function With One Condition

Using FILTER with Multiple Conditions

Syntax of the UNIQUE Function

Understanding Unique Versus Distinct

Nesting Array Functions: SORT, UNIQUE, and FILTER

Generating a Range of Sequential Numbers

Using SEQUENCE Inside Another Function

Generating an Array of Random Numbers with RANDARRAY

Replacing a What-If Data Table with One Formula

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

Filter To Rows Over a Certain Threshold

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

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

Format One Cell in a Pivot Table

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 Stack 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 or Excel Files into a Single Excel Worksheet

Fill in Blanks with Values from Above

Use Power Query to Clean Data Already in Excel

Total Numbers From Data Alt-Entered

Use Power Query to Load Many Web Pages

Merge Columns in Power Query

Use Column From Examples to Learn Power Query Formulas

Dive into M Code For More Power Query

Pivot from Multiple Tables Using The 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

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 Using 3D Map

Tricks for Navigating the Map in 3D Map

Fine-Tuning 3D Maps

Creating a Video from 3D Map

Use an Alternate Map for 3D Map

Filtering in 3D Map

Excel Data to Mailing Labels in Word

Excel 2013 Allows Slicers on Regular Tables

Use One Slicer For Pivot Tables From Different Data Sets

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

Legend At the Top

Finding Settings in the Chart Task Pane

Display an Axis in Millions

Select Anything on a Chart to Format

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

Get Ideas from Artificial Intelligence

Use Formulas for Chart Labels in Excel

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

Use Filled Map Charts

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

Highlight Items Above Average

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?

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

Make any Picture Transparent

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

Threaded Comments Debut in 2019

Leave Helpful comments with Cell Notes

Change the Appearance of Cell Notes

Control How Your Name Appears in Notess

Force Some Notes to ALWAYS Be Visible to Provide a Help System

Change the Note Shape to a Star

Add a Pop-up Picture of an Item in a Cell

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

Add a ToolTip to a Cell to Guide the Person Using the Workbook

Combine Validation with AutoComplete

Afterword

Index

Power Excel with MrExcel: Master Pivot Tables, Subtotals, VLOOKUP, Power Query, Dynamic Arrays & Data Analysis

What do you get with eBook?

Key benefits

Description

Who is this book for?

What you will learn

Product Details

What do you get with eBook?

Product Details

Frequently bought together

Table of Contents

Recommendations for you

About the authors

FAQs

Power Excel with MrExcel: Master Pivot Tables, Subtotals, VLOOKUP, Power Query, Dynamic Arrays & Data Analysis

What do you get with eBook?

Key benefits

Description

Who is this book for?

What you will learn

Product Details

What do you get with eBook?

Product Details

Packt Subscriptions

Frequently bought together

Table of Contents

Recommendations for you

About the authors

FAQs