Power Excel with MrExcel : 567 Excel mysteries solved / Bill Jelen.

Format:

Book

Author/Creator:

Jelen, Bill, author.

Language:

English

Subjects (All):

Electronic spreadsheets.

Business--Computer programs.

Business.

Microsoft Excel (Computer file).

Physical Description:

1 online resource (561 pages)

Edition:

4th ed.

Place of Publication:

Uniontown, OH : Holy Macro! Books, [2015]

Summary:

Updating the previous edition's tips to include features in Excel 2013, this new edition of Mr. Excel's popular software guide even incorporates suggestions sent in by readers. Each featured topic has a problem statement and description, followed by a broad strategy for solving the problem. Mr. Excel then walks readers through the specific steps to solve the issue. Alternate strategies are also provided, along with common scenarios that trip users up, leaving readers with not only answers to their specific dilemmas but also new and quicker ways to use formulas and spreadsheets.

Contents:

Front Cover

Title Page

Copyright

Table of Contents

About the Author

Dedication

Acknowledgments

Foreword

What is Office 365? Do I have to work in a Browser?

Why Do I Have to Sign in to Excel 2013?

Why Facebook, LinkedIn and Twitter?

How Can I Use Excel on Dual Monitors?

Find Icons on the Ribbon

Seriously, I Really Can't Find This

Where Are My Macros?

What Happened to Tools, Options?

Customizing the Ribbon

Go Wide

Minimize the Ribbon to Make Excel Feel a Bit More Like Excel 2003

Use a Wheel Mouse to Scroll Through The Ribbon Tabs

Why Do The Charting Ribbon Tabs Keep Disappearing?

Use Dialog Launchers to Access the Excel 2003 Dialog

Icon, Dropdowns, and Hybrids

All Commands Start at the Top (Except for 2 Controls at the Bottom)

Make Your Most-Used Icons Always Visible

The Excel 2003 Alt Keystrokes Still Work (If You Type Them Slowly Enough)

Use New 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

Use Live Preview

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

Excel's Obsession with Security Has Hampered Linked Workbooks

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.

Automatically Move the Cell Pointer in a Direction After Entering a Number

Return to the First Column After Typing the Last Column

Enter Data in a Circle (Or Any Pattern)

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?

Jump to the Edge of the Data

Jump to Next Corner of Selection

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 Special

Quickly Turn a Range on Its Side

Quickly Rearrange Rows Or Columns

Copy Cells from One Worksheet to Many Other Worksheets

Quickly Copy 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

Use Excel as a Word Processor

Add Excel to Word

Use Hyperlinks to Create an Opening Menu for a Workbook

Arrange Windows to See Two or More Open Workbooks

Compare Two Worksheets Side by Side

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

Translate with Excel

I am a Lobbyist Writing Policy Papers for the White House

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

Use a Laser Printer to Have Excel Calculate Faster

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?

Edit your Excel Workbooks on the Web

Create an Online Survey in Excel

Embed Your Dashboard in a Blog Post

Sort, Filter, Chart Your HTML Tables

Print all Excel Keyboard Shortcuts

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

Join Text with a Date or Currency

Sort on One Portion of an Account ID

How to Isolate the Center Portion of an Account ID

How to Isolate Everything Before a Dash in a Column by Using Functions

How to Use Functions to Isolate Everything After a Dash

How to Use Functions to Isolate Everything After the Second Dash in a Column

How to Separate a Part Number into Three Columns

Excel Is Randomly Parsing Pasted Data

I Lose Leading Zeroes From CSV Files.

Open CSV File With Dates in D/M/Y Format

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

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

Match Web Colors with HEX2DEC

Will XOR Find People Who Chose a Single Value?

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

Multiple Conditions Using SUMPRODUCT

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

Lookup Two Values

Add Comments to a Formula

Create Random Numbers

Randomly Sequence a List

Play Dice Games with Excel.

Generate Random Without Repeats.

Notes:

"Master pivot tables, subtotals, charts, VLOOKUP, IF, data analysis in Excel 2010-2013"--Cover.

Includes index.

Description based on print version record.

ISBN:

9781615471256

1615471251

9781615473489

1615473483

OCLC:

935256097