Spreadsheet software Books
ENI Publishing MOUS Excel 2003 Expert
Book Synopsis
£19.17
Taylor & Francis Ltd Using Data for Monitoring and Target Setting A Practical Guide for Teachers Educational Management S
a huge range and FREE tracked UK delivery on ALL orders.
£109.25
Taylor & Francis Microeconomics using Excel
a huge range and FREE tracked UK delivery on ALL orders.
£171.00
Taylor & Francis Microeconomics using Excel
Book SynopsisUsing Microsoft Excel, the market leading spreadsheet package, this book combines theory with modelling aspects and spreadsheet analysis. Microeconomics Using Excel provides students with the tools with which to better understand microeconomic analysis.It focuses on solving microeconomic problems by integrating economic theory, policy analysis and spreadsheet modelling. This unique approach facilitates a more comprehensive understanding of the link between theory and problem solving.It is divided into four core parts: analysis of price policies analysis of structural policies multi-market models budget policy and priority settings. The theory behind each problem is explained and each model is solved using Excel. Microeconomics using Excel will be of great interest to students studying economics as well as to professionals in economic and policy analysis.Publisherâs NoteTable of ContentsIntroduction Part A: Analysis of Price Policies 1. Supply, Demand and Price Policies 2. Welfare and Distributional Effects 3. Price Policy Instruments 4. Iso-Elastic Supply and Demand Functions 5. Policy Formulation and Trade-Offs 6. External Effects 7. Integrated Markets 8. World Market and Third Country Effects Part B: Analysis of Structural Policies 9. Shifts of the Supply Curve 10. Implications of Structural Policies over Time 11. Optimal Structural Policies Part C: Multi-Market Models 12. Interdependencies of Markets 13. Microeconomic Foundations 14. Formulation of a 4-Market Model 15. Model Framework for a 12-Market Model Part D: Budget Policy and Priority Setting 16. Optimization Approach 17. Multiple Objectives 18. Parametric Analysis
£56.04
Taylor & Francis Translation and Adaptation in Theatre and Film
a huge range and FREE tracked UK delivery on ALL orders.
£142.50
Taylor & Francis Ltd Excel 97 for Windows Made Simple Made Simple Books
a huge range and FREE tracked UK delivery on ALL orders.
£24.06
Cambridge University Press Data Analysis for Physical Scientists
a huge range and FREE tracked UK delivery on ALL orders.
£58.89
Cambridge University Press Intermediate Microeconomics with Microsoft Excel
a huge range and FREE tracked UK delivery on ALL orders.
£62.69
Pearson Education (US) Your Office
Book SynopsisAbout our authors Amy S. Kinser, Esq., Series Editor, holds a BA degree in chemistry with a business minor from Indiana University, and a JD from the Maurer School of Law, also at Indiana University. After working as an environmental chemist, starting her own technology consulting company, and practicing intellectual property law, she has spent the past 15 years teaching technology at the Kelley School of Business in Bloomington, Indiana. Currently, she serves as Director of Computer Skills and senior lecturer at the Kelley School of Business at Indiana University. She loves spending time with her two sons, Aidan and J. Matthew, and her husband, J. Eric. Kristyn A. Jacobson holds an MS degree in education from the University of Wisconsin-La Crosse and a BS degree in business education from the University of Wisconsin-Eau Claire. She has been a faculty member and department chair of the Business Technology department at Madison CollegTable of ContentsTable of Contents COMMON FEATURES Understanding the Common Features of Microsoft Office EXCEL EXCEL BUSINESS UNIT 1: UNDERSTANDING THE FUNDAMENTALS Create, Navigate, Work with, and Print Worksheets Formats, Functions, and Formulas Excel Business Unit 1 Capstone EXCEL BUSINESS UNIT 2: CONDUCTING BUSINESS ANALYSIS Cell References, Named Ranges, and Functions Effective Charts Excel Business Unit 2 Capstone EXCEL BUSINESS UNIT 3: INTEGRATING COMPLEX FUNCTIONS INTO BUSINESS ANALYSIS Complex Logical and Retrieval Functions Integrating Complex Functions into Business Analysis Excel Business Unit 3 Capstone EXCEL BUSINESS UNIT 4: BUILD AN APPLICATION WITH MULTIPLE WORKSHEETS AND WORKBOOKS Multiple Worksheets, Workbooks, and Templates Building an Application with Multiple Worksheets and Workbooks Excel Business Unit 4 Capstone EXCEL BUSINESS UNIT 5: MANIPULATING DATA SETS FOR DECISION MAKING Organize, Import, Export, and Cleanse Data Sets Data Tables, Scenario Manager, and Solver Excel Business Unit 5 Capstone EXCEL BUSINESS UNIT 6: BUILDING FINANCIAL AND STATISTICAL MODELS Loan Amortization, Investment Analysis, and Asset Depreciation Business Statistics and Regression Analysis Excel Business Unit 6 Capstone EXCEL BUSINESS UNIT 7 The Excel Data Model and Business Intelligence Visual Basic for Applications--VBA Excel Business Unit 7 Capstone Appendices Leveraging Microsoft’s Power Business Intelligence (‘BI’) Desktop Suite Mac Appendix MOS Core MOS Expert
£164.68
Pearson Education (US) Exploring Microsoft Office Excel 2019
Book SynopsisAbout our authors Mary Anne Poatsy, Series Editor, Windows 10 Author, is a senior faculty member at Montgomery County Community College, teaching various computer applications and concepts courses in face-to-face and online environments. She holds a BA in psychology and education from Mount Holyoke College and an MBA in finance from Northwestern University's Kellogg Graduate School of Management. Mary Anne has over 20 years of educational experience. She has taught at Montgomery County Community College and Muhlenberg College. She also engages in corporate training. Before teaching, she was Vice President at Shearson Lehman in the Municipal Bond Investment Banking Department. Dr. Keith Mulbery, Excel Author, is department chair and a professor in the Information Systems and Technology Department at Utah Valley University (UVU), where he currently teaches systems analysis and design, and global and ethical issues in informationTable of ContentsBrief Contents OFFICE Office 365 Common Features EXCEL Introduction to Excel Formulas and Functions Charts Datasets and Tables Subtotals, PivotTables, and PivotCharts What-If Analysis Specialized Functions Statistical Functions Multiple-Sheet Workbook Management Power Add-Ins Additional Specialized Functions Templates, Workbook Inspection, and Macros APPLICATION CAPSTONE EXERCISE Excel Application Capstone Exercise
£164.49
John Wiley & Sons Inc Excel 2010 Bible
Book SynopsisA comprehensive reference to the newest version of the world s most popular spreadsheet application: Excel 2010 John Walkenbach's name is synonymous with excellence in computer books that decipher complex technical topics. Known as Mr.
£33.24
John Wiley & Sons Inc Next Generation Excel
Book SynopsisTake Excel to the next level in accounting and financial modeling In this new Second Edition of Next Generation Excel, Isaac Gottlieb shows financial analysts how to harness the full power of Excel to move forward into the new world of accounting and finance. Companies of all sizes use financial models to analyze their finances and plan business operations, as well as to create financial accounting reports like balance sheets, income statements, and statements of cash flows. While many businesspeople are quite familiar with the reports created with financial models, most are not as familiar with the creation of the models themselves. This book shows them how to build an accurate and effective financial model using the solid functionality and easy usability of Excel. Fully updated and revised to include support for Apple users Written by a professor of management and statistics who has taught the discipline for fifteen years Table of ContentsForeword xv Preface xvii Acknowledgments xxi PART ONE Using Excel Efficiently 1 CHAPTER 1 AutoFill 3 AutoFill Options 8 Right-Drag AutoFill 8 Appendix: AutoFill in Excel 2003 and Excel Mac 2011 10 Review Questions 13 Answers 14 CHAPTER 2 Selecting Efficiently in Excel 15 Review Questions 18 Answers 19 CHAPTER 3 Formulas, Functions, and Relative and Absolute Addressing 21 Relative and Absolute Addressing 22 Other Functions 25 Appendix: Doing It in Mac Excel 2011 28 Review Questions 29 Answers 30 CHAPTER 4 Naming Cells and Ranges 31 Naming a Single Cell 31 Naming a Range of Cells 33 Using the Name Menu to Create Names 34 Appendix: Using the Names Menu in Excel 2003 and Mac Excel 2011 38 Review Questions 41 Answers 42 CHAPTER 5 Conditional and Advanced Conditional Formatting in Excel 45 Simple Conditional Formatting; Adding a Rule 45 New Conditional Formatting Features 46 Advanced Conditional Formatting 49 Appendix: Using the Conditional Formatting in Excel 2003 52 Review Questions 53 Answers 55 CHAPTER 6 Excel Charts 57 Quick/Instant Chart 57 Creating a Chart Using the Menu 57 Adding More Data to an Existing Chart 61 More about Charts 64 Three-Dimensional Charts—Column and Pie 66 Pie Charts 70 Appendix: Generating Charts in Excel 2003 and Mac Excel 2011 73 CHAPTER 7 Sparklines and Advanced Topics in Excel Charts 81 Sparklines 81 More about Charts 83 Review Questions 90 Answers 91 PART TWO IF Functions and Text Manipulations 93 CHAPTER 8 IF Functions 95 Simple IF Functions 95 Nested IF Functions 98 Nested IF—Payroll Example 99 Appendix: Using the IF Function in Mac Excel 2011 101 Review Questions 102 Answers 102 CHAPTER 9 Text Manipulation 103 Text to Columns 103 Appendix: Using Text to Column in Excel 2003 108 Review Questions 111 Answers 112 PART THREE Statistical Tools 113 CHAPTER 10 Descriptive Statistics 115 Descriptive Statistics 115 Appendix: Descriptive Statistics with the Mac Excel 2011 117 Review Questions 119 Answers 119 CHAPTER 11 Frequency Distributions 121 One More Example 126 Appendix: Frequency Distributions with Mac Excel 2011 129 Review Questions 129 Answers 130 CHAPTER 12 Statistical Regression 131 Using the Scatter Chart in Excel 131 Linear Regression—Using Excel Functions 133 Appendix: Using the Chart Feature to Create a Trend Line in Excel 2003 and Mac Excel 2011 137 Review Questions 140 Answers 140 CHAPTER 13 Data Analysis—The Excel Easy to Use Statistics Add-In 141 Descriptive Statistics 141 Frequency Distribution Using Histogram 143 Appendix: Using Data Analysis in Excel Mac 2011 and Excel 2003 148 Review Questions 148 Answers 149 CHAPTER 14 Data Analysis—Multi-Regression 151 Simple or Single Variable Regression 151 Multi-Regression 152 Appendix: Using Data Analysis in Excel Mac 2011 and Excel 2003 160 Review Questions 160 Answers 161 PART FOUR What-If Analysis 165 CHAPTER 15 Naming Cells—For Meaningful Decision Making and Modeling 167 One More Example—If You Have a Ready Model 168 Appendix: Create and Apply Names in Excel 2003 and Mac Excel 2011 170 Review Questions 175 Answers 175 CHAPTER 16 What-If Analysis and Goal Seek 177 Goal Seek 178 Appendix: Goal Seek in Excel 2003 and Mac Excel 2011 182 Review Questions 183 Answers 183 CHAPTER 17 Sensitivity Analysis—One- and Two-Way Data Tables 185 Two-Way Table 187 Data Tables—One More Example 189 Break-Even Point (BEP) Chart 190 Appendix: Sensitivity Analysis—One- and Two-Way Data Tables for Excel 2003 and Mac Excel 2011 192 Review Questions 193 Answers 195 CHAPTER 18 Using Scroll Bars for Sensitivity Analysis 199 Scroll Bar Limitations 203 Appendix: Adding a Scroll Bar in Excel 2003, 2007, and Mac Excel 2011 205 Review Questions 207 Answers 208 PART FIVE Multi-Page Systems and Lookups 211 CHAPTER 19 Multi-Page Budgets—Going to the Third Dimension 213 A Payroll Example 213 A Second Example—Bakers’ Supplies 217 Review Questions 219 Answers 220 CHAPTER 20 Lookup Tables 221 Range—Approximate Match Lookup 221 An Exact Match Lookup 224 Review Questions 227 Answers 228 PART SIX The Data Menu and Ribbon 229 CHAPTER 21 Sorting Data 231 Sorting by Multiple Parameters 233 Appendix: Sorting in Excel 2003 and Mac Excel 2011 236 Review Questions 238 Answers 239 CHAPTER 22 AutoFilter 241 Dates 241 Below and Above Average 243 Filter by Color 243 Appendix: AutoFilter in Excel 2003 244 Review Questions 246 Answers 247 CHAPTER 23 Data Forms and Features Eliminated in Excel 2007 and 2010 249 Appendix: The Data Form in Excel 2003 or Earlier versions and Mac Excel 2011 251 Review Questions 252 Answers 253 CHAPTER 24 Group and Outline Data 255 Appendix: Group and Outline Data Excel 2003 and Mac Excel 2011 258 Review Questions 260 Answers 261 CHAPTER 25 Excel Subtotals 263 One More Example—Function Applied to Multiple Categories 265 Copying Grouped Data 265 Second Example—Larger Database 269 Appendix: Creating Subtotals in Excel 2003 and Mac Excel 2011 269 Review Questions 273 Answers 273 CHAPTER 26 Pivot Tables 275 PivotTable Example 275 Appendix: The Pivot Table in Excel 2003 and Mac Excel 2011 282 Review Questions 286 Answers 286 CHAPTER 27 Data Mining Using Pivot Tables 289 Appendix: Advanced PivotTable Techniques in Excel 2003 296 Review Questions 297 Answers 298 CHAPTER 28 Using Slicers to Filter Pivot Tables 301 Format a Slicer 302 Sharing Slicers for More Than One Pivot Table 304 Review Questions 305 Answers 306 PART SEVEN Excel Financial Tools 307 CHAPTER 29 NPV and IRR—Evaluating Capital Investments 309 The Time Value of Money 309 IRR—Internal Rate of Return 311 Review Questions 313 Answers 313 CHAPTER 30 Unconventional Financial Functions: XNPV and XIRR 315 Excel XNPV—The Net Present Value Function for Uneven Intervals 315 Excel XIRR—The Internal Rate of Return Function for Uneven Intervals 316 Review Questions 318 Answers 318 CHAPTER 31 Frequently Used Financial Functions 319 Similar Excel Functions 320 Review Questions 323 Answers 323 CHAPTER 32 Amortization Tables 325 Amortization Example 325 Review Questions 334 Answers 334 CHAPTER 33 Accounting Depreciation Functions 337 SLD Straight Line Depreciation 337 SYD Sum of the Years Digits 337 Review Questions 339 Answers 339 PART EIGHT Using the Solver Add-In 341 CHAPTER 34 Beyond the Goal Seek—More Than One Changing Cell? Use the Solver 343 Example—Break-Even Point 343 Using the Solver 343 Appendix: Using the Solver in Excel 2003 and Mac Excel 2011 349 Review Questions 350 Answers 352 CHAPTER 35 The Solver Add-In—Optimizer 353 Solver Example 353 Nonlinear Example Using the Solver 355 Appendix: Using the Solver in Excel 2003 and Mac 2011 360 Review Questions 360 Answers 360 Appendix Summary Case Study—Supply Chain Management Example 365 About the Author 385 Index 387
£76.00
McGraw Hill Education India Looseleaf for Microsoft Office Excel 2016
Book Synopsis
£174.60
McGraw-Hill Education Looseleaf for Microsoft Excel 365 Complete In
Book Synopsis
£174.60
Barcharts, Inc Excel Tips Tricks Quick Study Computer
Book SynopsisExcel Tips & Tricks A handy resource for beginning, intermediate or advanced Excel users, this 3-panel (6-page) guide is jam-packed with information and helpful, time-saving hints on Microsoft's award-winning spreadsheet software. Featuring easy-to-see screen captures and icons, this guide is an ideal next-to-the-monitor reference.
£6.84
Barcharts, Inc Excel Advanced
Book Synopsis
£6.84
Barcharts, Inc Excel Pivot Tables Charts Quick Study Computer
Book SynopsisAmong the many data analyzing features to be found in Microsoft's Excel software, PivotTables and PivotCharts are two of the most useful. Find out how they can work for you with our jam-packed 3-panel guide, which features step-by-step instructions and full-color screen shots for easy reference.
£6.84
Barcharts, Inc Excel For Business Math Quick Study Computer
Book Synopsis
£6.88
Barcharts, Inc Excel Formulas Quick Study Computer
Book SynopsisGuide to developing and using functions and formulas in Excel. This clear and concise coverage of the ins and outs of formula creation and use touches on many forms of math from statistics & trig to financial math. The sheer volume and wealth of information in these 6 pages is equal to 30 pages or more from your average book on the same subject. Includes screen shots.
£8.34
Barcharts, Inc Excel 2016 Advanced Quick Study Computer
Book SynopsisQuick and easy 6-page laminated guide with locations of functions and how to perform them in Excel 2016. Whether you are a beginner or experienced user, the advanced version is more coverage of the most popular and useful functions that users may even discover and use for the first time. Curtis Frye, author of multiple books on Excel, creator of many Lynda.com videos and an experienced corporate trainer used his experience and knowledge to cover the most relevant functions for users at different levels. Look for Excel 2016, Excel 2016 'Tips and Tricks', 'Formulas' and 'Pivot Tables' QuickStudy guides to have a complete power-user reference set. Suggested uses: ⢠Workplace â flat for easy storage and access at a moments notice to find a function you need to use, or to jog your memory for a function you do not use often ⢠Company Training â reduce help-desk calls and keep productivity flowing for a team or for your entire company
£8.80
Barcharts, Inc Excel 2016 Formulas Quick Study Computer
Book SynopsisQuick and easy 6 page laminated guide focuses on creating and using formulas efficiently and effectively in Excel 2016. Whether you are a beginner or experienced user, formulas are Excel's superpower that can be yours. Curtis Frye, author of multiple books on Excel, creator of many Lynda.com videos and an experienced corporate trainer used his experience and knowledge to cover the most relevant use of formulas for users at different levels. Look for Excel 2016, Excel 2016 'Tips and Tricks', 'Advanced' and 'Pivot Tables' QuickStudy guides to have a complete power-user reference set. Suggested uses: o Workplace â flat for easy storage and access at a moments notice to find a formula function you need to use, or to jog your memory for a function you do not use often o Company Training â reduce help-desk calls and keep productivity flowing for a team or for your entire company Students/Professors â make lives easier for students in many majors needing
£7.37
Barcharts, Inc Excel 2016 Pivot Tables Quick Study Computer
Book SynopsisQuick and easy 6-page laminated guide focuses on creating and using pivot tables efficiently and effectively in Excel 2016. Whether you are a beginner or experienced user, pivot tables offer flexibility, doubling down on Excel's power. Curtis Frye, author of multiple books on Excel, creator of many Lynda.com videos and an experienced corporate trainer used his experience and knowledge to cover the most relevant use of pivot tables for users at different levels. Look for Excel 2016, Excel 2016 'Tips and Tricks', 'Advanced' and 'Formulas' QuickStudy guides to have a complete power-user reference set. Suggested uses: o Workplace â flat for easy storage and access at a moments notice to find the answer you need, or to jog your memory for a function you do not use often o Company Training â reduce help-desk calls and keep productivity flowing for a team or for your entire company o Students/Professors â make lives easier for students in many majors
£7.45
Holy Macro! Books Supercharge Excel
Book SynopsisData analysis expressions (DAX) is the formula language of Power Pivot. Learning the DAX language is key to empower Excel users so they can take advantage of these new Business Intelligence (BI) capabilities. This volume clearly explains the concepts of Power Pivot while at the same time offering hands-on practice to engage the reader and help new knowledge stick. This second edition has been updated for the Excel 2016 user interface while still providing a bridge for readers wanting to learn DAX in the Excel environment and then transfer their new DAX skills across to Power BI.
£24.26
Holy Macro! Books The Absolute Guide to Dashboarding and Reporting
Book SynopsisWritten by a member of Microsoft’s Power BI team, this resource provides a practical step by step guide on creating a financial dashboard. The book covers in detail how to combine and shape the relevant data, build the dashboard in Power BI, providing layout and design tips and tricks, prepare the model to work with fiscal dates, and show values used in many financial reports, including year-to-date, variance-to-target, percentage-of-total, and running totals reports.
£22.91
Holy Macro! Books Excel 2019 – Business Basics & Beyond
Book SynopsisAre you tired of tracking financial elements of your business manually, do you have to prepare staffing schedules by hand, or do you simply want to know how to get more information from your business data? Learn how to harness your business data and put it to use for you. Learn the basics of Excel, including a comprehensive review of every tab of the Excel Ribbon. See how to best display your data for maximum impact with formatting tools, Data Tables, Charts & Pivot Tables. Use customer information to create customized letters with Mail Merge. Import data using Power Query. Calculate the costs of doing business with financial formulas, learn where to find pre-packaged business templates, and much more. This book uses real-world business examples in operation with all these elements.
£24.26
Holy Macro! Books MrExcel LX The Holy Grail of Excel Tips: Covers
Book SynopsisThese are the 125 essential tips that all Excel users need to know. MrExcel LX provides users with a concise book that can be absorbed in under two hours. Includes a section with keyboard shortcuts. Anyone who uses Excel will be able to turn to any page and pick up tips that will save them hours of work.
£26.06
Holy Macro! Books Cool Excel Sh*t
Book SynopsisFifty Excel tricks that no one has ever seen before. Cool Excel Sh*t is designed with the Excel guru in mind, introducing advanced, creative solutions and hacks for the software's most challenging problems. Through a series of more than 50 techniques, formulas, dynamic arrays, and VBA macros, this guide details processes that may be used in any application and across all disciplines. Includes a section on techniques using Dynamic Arrays in Excel.
£19.76
Holy Macro! Books Power BI for the Excel Analyst: The essential
Book SynopsisThe essential guide for getting started with Power BI. Power BI is an amazing cloud-based business analytics service provided by Microsoft that allows people to transform data into rich, interactive visual reports that presents a 360-degree business view and improves business decision making. This book is designed to get the Excel analyst started with Power BI, touching on Power Query and Power Pivot.Table of ContentsIntroduction to the Power BI environmentBuild your first report in just a few minutesPreparing Dashboard DataDiving in to Power Query and understanding M codeCreating Interactive VisualizationsUsing custom visualizationsUsing PowerBI.com to add value to your reports
£29.71
Holy Macro! Books MrExcel 2022: Boosting Excel
Book SynopsisInspiring Excel tips designed to save 100 hours per year. Originally designed for Bill Jelen's live Power Excel seminars, the target audience already uses Excel 40 hours a week. These tips are the "aha" tips that uncover secret methods in Excel. The book covers general Excel functions, pivot tables, and formulas such as VLOOKUP and the new XLOOKUP. It introduces elements of modern Excel such as the Power Pivot Data Model and cleaning data with Power Query. Updated annually, this edition for 2022 adds information on collaboration features, LET and LAMBDA functions, amazing new data types, dynamic array formulas, and more.Table of Contents#1 Double-Click the Fill Handle to Copy a Formula#2 Break Apart Data#3 Filter by Selection#4 The Fill Handle Does Know 1, 2, 3…#5 Fast Worksheet Copy#6 Recover Unsaved Workbooks#7 Simultaneously Edit the Same Workbook in Office 365#8 New Threaded Comments Allow Conversations#9 Create Perfect One-Click Charts#10 Paste New Data on a Chart#11 Create Waterfall Charts#12 Creat a Bell Curve#13 Add Meaning to Reports Using Data Visualizations#14 Sort East, Central, and West Using a Custom List#15 Sort Left to Right#16 Sort Subtotals#17 Sort and Filter by Color or Icon#18 Consolidate Quarterly Worksheets#19 Get Ideas from Artificial Intelligence#20 Create Your First Pivot Table#21 Create a Year-over-Year Report in a Pivot Table#22 Find the True Top Five in a Pivot Table#23 Specify Defaults for All Future Pivot Tables#24 Replicate a Pivot Table for Each Rep#25 Use a Pivot Table to Compare Lists#26 Build Dashboards with Sparklines and Slicers#27 See Why GETPIVOTDATA Might Not Be Entirely Evil#28 Eliminate VLOOKUP with the Data Model#29 Compare Budget Versus Actual via Power Pivot#30 Slicers for Pivot Tables From Two Data Sets#31 Use F4 for Absolute Reference or Repeating Commands#32 Quickly Convert Formulas to Values#33 See All Formulas at Once#34 Discover New Functions by Using fx #35 Calculate Nonstandard Work Weeks#36 Turn Data Sideways with a Formula#37 Handle Multiple Conditions in IF#38 Troubleshoot VLOOKUP#39 Replace Nested IFs with a Lookup Table#40 Suppress Errors with IFERROR#41 Handle Plural Conditions with SUMIFS#42 Geography & Stock Data Types in Excel#43 Dynamic Arrays Can Spill#44 Sorting with a Formula#45 Formula for Unique or Distinct#46 Other Functions Can Now Accept Arrays as Arguments#47 One Hit Wonders with UNIQUE#48 SEQUENCE inside of other Functions such as IPMT#49 Replace a Pivot Table with 3 Dynamic Arrays#50 Complex Validation Using a Formula#51 Use A2:INDEX() as a Non-Volatile OFFSET#52 Subscribe to Office 365 for Monthly Features#53 Speed Up VLOOKUP#54 Protect All Formula Cells#55 Back into an Answer by Using Goal Seek#56 Do 60 What-If Analyses with a Sensitivity Analysis#57 Find Optimal Solutions with Solver#58 Improve Your Macro Recording#59 Clean Data with Power Query#60 Render Excel Data on an iPad Dashboard Using Power BI#61 Build a Pivot Table on a Map Using 3D Maps#62 The Forecast Sheet Can Handle Some Seasonality#63 Perform Sentiment Analysis in Excel#64 Fill in a Flash#65 Format as a Façade#66 Surveys & Forms in Excel#67 Use the Windows Magnifier#68 Word for Excellers#69 Avoid Whiplash with Speak Cells#70 Customize the Quick Access Toolbar#71 Favorite Keyboard Shortcuts#72 More Excel Tips
£27.86
Holy Macro! Books Mrexcel 2025
£24.93
