Power Excel with MrExcel : Master Pivot Tables, Subtotals, Charts, VLOOKUP, IF, Data Analysis in Excel 2010–2013.

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.

Description based on publisher supplied metadata and other sources.

Electronic reproduction. Ann Arbor, Michigan : ProQuest Ebook Central, 2024. Available via World Wide Web. Access may be limited to ProQuest Ebook Central affiliated libraries.