The REPT() Function: Repeating a CharacterĮxtracting First Name, Last Name, and Middle Initial

Removing Unwanted Characters from a String Part II: Harnessing the Power of Functionsĭisplaying When a Workbook Was Last Updated Using Names with the Intersection OperatorĬopying a Formula Without Adjusting Relative Referencesĭisplaying a Cell’s Formula Using FORMULATEXT()Ĭase Study: Avoiding #NAME? Errors When Deleting Range Names Pasting a List of Range Names in a WorksheetĪdjusting Range Name Coordinates Automatically Part I: Mastering Excel Ranges and FormulasĪpplying Conditional Formatting to a RangeĬhanging the Scope to Define Sheet-Level Names

Help you avoid critical mistakes that even experienced users make.

Show you how to get great results, no matter how much data you have.

Present proven, creative strategies for solving real-world problems.

Dramatically increase your productivity-saving you 50 hours a year or more.

Selected by Bill Jelen, Microsoft Excel MVP and mastermind behind the leading Excel solutions website, these books will

Validate data, troubleshoot problems, and build more accurate, trustworthy spreadsheetsĪbout MrExcel Library: Every book in the MrExcel Library pinpoints a specific set of crucial Excel tasks and presents focused skills and examples for performing them rapidly and effectively.

Build loan, investment, and discount formulas.

Use regression to track trends and make forecasts.

Use complex criteria to filter data in lists.

Analyze your data with standard tables and PivotTables.

Use conditional formatting to instantly reveal anomalies, problems, or opportunities.

Quickly create powerful spreadsheets with FlashFill.

Along the way, you discover the fastest, best ways to handle essential day-to-day tasks ranging from generating account numbers to projecting the impact of inflation.īecoming an Excel expert has never been easier! You’ll find crystal-clear instructions insider insights even complete step-by-step projects for building timesheets, projecting cash flow, aging receivables, analyzing defects, and more. Using real-world examples, McFedries helps you get the absolute most out of features and improvements ranging from FlashFill to Excel’s newest functions. Master core Excel 2013 tools for building powerful, reliable spreadsheets!Įxcel expert Paul McFedries shows how to use Excel 2013’s core features to solve problems and get the answers you need.

Activate solver in excel 2013