Power excel with mrexcel : 654 excel mysteries solved / Bill Jelen.

Format:

Book

Author/Creator:

Jelen, Bill, author.

Language:

English

Subjects (All):

Microsoft Excel (Computer file).

Electronic spreadsheets.

Business--Computer programs.

Business.

Physical Description:

1 online resource (610 pages)

Edition:

2019 edition.

Place of Publication:

Merritt Island, Florida : Holy Macro! Books, 2019.

Summary:

Updating the previous edition's tips to include features in Office 365 and Excel 2019, this new edition of MrExcel'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.

Contents:

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

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.

Notes:

Includes index.

Description based on print version record.

Description based on publisher supplied metadata and other sources.

ISBN:

9781615472451

1615472452

OCLC:

1135667658