Catalogue Search | MBRL
Are you sure you want to remove the book from the shelf?
{{itemTitle}}
1,291
result(s) for
"Electronic spreadsheets."
Sort by:
Excel data analysis
\"If you can get data into Excel, then you have a giant basket of data analysis tools at your fingertips. This book shows you how to access and use the features and techniques for organizing, manipulating, and summarizing just about anything that resides in a worksheet. So if you're familiar with Excel but lack a background in the technical aspects of data analysis, this user-friendly book makes it easy to start putting Excel to use for you\" -- Page 4 of cover.
Book
Excel data analysis for dummies
Turn jumbles of numbers into graphics, insights, and answers with Excel With Microsoft Excel, you can, well, excel at data analysis. And Excel Data Analysis For Dummies can help, with clear and easy explanations of the mountain of features for creating, visualizing, and analyzing data. PivotTables, charts, what-if analysis, statistical functions-it's all in here, with examples and ideas for Excel users of all skill levels. This latest edition covers the most recent updates to Excel and Microsoft 365. You'll beef up your data skills and learn powerful techniques for turning numbers into knowledge. For students, researchers, and business professionals, Excel is the spreadsheet and data application of choice-and Dummies is the best choice for learning how to make those numbers sing. Learn how to use Excel's built-in data analysis features and write your own functions to explore patterns in your data Create striking charts and visualizations, and discover multiple ways to tell the stories hidden in the numbers Clean up large datasets and identify statistical operations that will answer your questions Perform financial calculations, database operations, and more-without leaving Excel Excel Data Analysis For Dummies is the go-to resource for Excel users who are looking for better ways to crunch the numbers.
eBook
Excel VBA in easy steps, 4th edition
Get more out of Microsoft Excel and save time by learning Excel VBA (Visual Basic for Applications). Excel VBA in easy steps, 4th edition demonstrates VBA macro programming in a clear and concise manner, and will take your Excel proficiency to the next level:
* Write your own Excel macros so that you can do a series of tasks at the click of a button.
* Use VBA to automate repetitive tasks, and for functions and commands beyond Excel.
* Create dialog boxes for user interactions and then define processes to handle user input.
* Develop and share your Excel apps with colleagues – they'll be impressed!
Whether you're upgrading to Excel in Office 365 or new to macro programming, use this guide to master Excel VBA essentials – in easy steps!
Comes with free downloadable code to help you get started with Excel VBA right away!
eBook
Excel 2010 all-in-one for dummies
A reference guide explains how to use the diverse features of the spreadsheet program, discussing such topics as Excel basics, worksheet design, formulas and functions, charts and graphics, data management, VBA, Web applications, and data analysis.
Book
Excel all-in-one for dummies
Excel-erate your productivity with the only guide you'll need to the latest versions of Microsoft Excel
Microsoft Excel offers unsurpassed functionality and accessibility for data exploration and analysis to millions of users around the world. And learning to unlock its full potential is easier than you can imagine with help from Excel All-in-One For Dummies.
Follow along with Excel expert and veteran author Paul McFedries as he walks you through every feature and technique you need to know to get the most out of this powerful software. You'll learn how to design worksheets, use formulas and functions, collaborate with colleagues and review their work, create charts and graphics, manage and analyze data, and create macros. Plus, you'll discover all the capabilities Microsoft has included in the newest versions of Excel, including dark mode and accessibility features.
This indispensable reference allows you to:
* Get a firm grasp of Excel basics with the book's step-by-step guides before moving on to more advanced topics, like data analysis
* Access up-to-date information on all the new versions of Excel, including the ones bundled with Microsoft 365, Office 2021, and the LTSC/Enterprise Edition
* Enjoy the convenience of a single, comprehensive resource detailing everything you need to know about Excel
Perfect for people coming to Excel for the very first time, Excel All-in-One For Dummies, Office 2021 Edition is also a must-read resource for anyone looking for a refresher on foundational or advanced Excel techniques.
eBook
Excel 2016 formulas
\"Excel 2016 Formulas is fully updated to cover all of the tips, tricks, and techniques you need to maximize the power of Excel 2016 through the use of formulas. This comprehensive book explains how to create financial formulas, release the power of array formulas, develop custom worksheet functions with VBA, debug formulas, and much more. Whether you're a beginner, a power user, or somewhere in between this is your essential go-to for the latest on Excel formulas. When conducting simple math or building highly complicated spreadsheets that require formulas up to the task, leveraging the right formula can heighten the accuracy and efficiency of your work, and can improve the speed with which you compile and analyze data. Understanding which formulas to use and knowing how to create a formula when you need to are essential. Access tips, tricks, and techniques that have been fully updated to reflect the latest capabilities of Microsoft Excel; Create and use formulas that have the power to transform your Excel experience; Leverage supplemental material online, including sample files, templates, and worksheets from the book.\"--Www.amazon.com.
Book
Statistical analysis with Excel for dummies
Become astats superstarbyusingExceltorevealthepowerful secretsofstatistics
Microsoft Exceloffersnumerouspossibilities for statistical analysis—and you don't have to be amath wizard to unlock them. In Statistical Analysis with Excel For Dummies, fully updated for the 2021version of Excel, you'llhit the ground running withstraightforward techniquesandpracticalguidancetounlock the power of statistics in Excel.
Bypassunnecessary jargon and skip right tomastering formulas, functions, charts, probabilities, distributions, and correlations.Written forprofessionals and studentswithoutabackground instatistics or math, you'lllearn tocreate, interpret, and translate statistics—and have fun doing it!
In this bookyou'll find out how to:
* Understand, describe, andsummarizeany kind ofdata, from sports stats to sales figures
* Confidently drawconclusions from your analyses, makeaccuratepredictions, andcalculatecorrelations
* Model the probabilities of future outcomes based on past data
* Perform statistical analysis on any platform: Windows, Mac, or iPad
* Access additional resources and practice templates through Dummies.com
For anyonewho'sever wantedto unleashthe full potential ofstatistical analysis inExcel—and impressyourcolleagues or classmates along the way— Statistical Analysis with Excel For Dummies walks you throughthefoundational conceptsof analyzing statisticsand the step-by-stepmethods youuse to apply them.
eBook
Excel macros for dummies
Offers instructions on automating aspects of Excel in order to streamline workflow and minimize errors.
Book
Excel Power Pivot & Power Query For Dummies, 2nd Edition
Learn to crunch huge amounts of data with PowerPivot and Power QueryDo you have a ton of data you need to make sense of? Microsoft’s Excel program can handle amazingly large data sets, but you’ll need to get familiar with PowerPivot and Power Query to get started. And that’s where Dummies comes in. With step-by-step instructions—accompanied by ample screenshots—Excel PowerPivot & Power Query For Dummies will teach you how to save time, simplify your processes, and enhance your data analysis and reporting. Use Power Query to discover, connect to, and import your organization’s data. Then use PowerPivot to model it in Excel. You’ll also learn to: Make use of databases to store large amounts of dataUse custom functions to extend and enhance Power QueryAdd the functionality of formulas to PowerPivot and publish data to SharePointIf you’re expected to wrangle, interpret, and report on large amounts of data, Excel PowerPivot & Power Query For Dummies gives you the tools you need to get up to speed quickly.
eBook