Power Excel 2019 with MrExcel

Name: Power Excel 2019 with MrExcel | Master Pivot Tables, Subtotals, VLOOKUP, Power Query, Dynamic Arrays and Data Analysis
Brand: Holy Macro! Books
Price: 25.99 EUR
Availability: OnlineOnly

Master Pivot Tables, Subtotals, VLOOKUP, Power Query, Dynamic Arrays and Data Analysis

Bill Jelen(Autor*in)

Holy Macro! Books (Verlag)

Erschienen am 1. Februar 2019

610 Seiten

E-Book

PDF mit Adobe-DRM

Systemvoraussetzungen

978-1-61547-245-1 (ISBN)

25,99 €inkl. 7% MwSt.

Systemvoraussetzungen

für PDF mit Adobe-DRM

E-Book Einzellizenz

Als Download verfügbar

Beschreibung

Weitere Details

Weitere Ausgaben

Inhalt

Intro
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

Systemvoraussetzungen

Als PDF speichern Als Link merken