Catalogue Search | MBRL
Are you sure you want to remove the book from the shelf?
{{itemTitle}}
168
result(s) for
"Electronic spreadsheets Data processing."
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
Want to take the guesswork out of analyzing data? Let Excel do all the work for you!Data collection, management and analysis is the key to making effective business decisions, and if you are like most people, you probably don't take full advantage of Excel's data analysis tools. With Excel Data Analysis For Dummies, 3rd Edition, you'll learn how to leverage Microsoft Excel to take your data analysis to new heights by uncovering what is behind all of those mind-numbing numbers. The beauty of Excel lies in its functionality as a powerful data analysis tool. This easy-to-read guide will show you how to use Excel in conjunction with external databases, how to fully leverage PivotTables and PivotCharts, tips and tricks for using Excel's statistical and financial functions, how to visually present your data so it makes sense, and information about the fancier, more advanced tools for those who have mastered the basics! Once you're up to speed, you can stop worrying about how to make use of all that data you have on your hands and get down to the business of discovering meaningful, actionable insights for your business or organization. Excel is the most popular business intelligence tool in the world, and the newest update – Microsoft Excel 2016 – features even more powerful features for data analysis and visualization. Users can slice and dice their data and create visual presentations that turn otherwise indecipherable reports into easy-to-digest presentations that can quickly and effectively illustrate the key insights you are seeking. Fully updated to cover the latest updates and features of Excel 2016 Learn useful details about statistics, analysis, and visual presentations for your dataFeatures coverage of database and statistics functions, descriptive statistics, inferential statistics, and optimization modeling with SolverHelps anyone who needs insight into how to get things done with data that is unwieldy and difficult to understandWith Excel Data Analysis For Dummies, 3rd Edition, you'll soon be quickly and easily performing key analyses that can drive organizational decisions and create competitive advantages.
eBook
Statistical analysis with Excel for dummies
There's nothing random about it this is the book on statistical analysis with Excel Stunned by statistics? Exhausted by Excel? Relax! Statistical Analysis with Excel For Dummies, 4th Edition shows you how to use the world's most popular spreadsheet program to crunch numbers and interpret statistics even if you've never taken a statistics or advanced math course. In no time, you'll learn to use Excel to create and translate statistics in everyday life, understand common statistical terms, and improve your classroom or professional skills. Statistics has a reputation for being a challenging, math-intensive pursuit but it doesn't have to make your palms sweat. Using a minimum of equations and assuming no prior knowledge of statistics or Excel, this hands-on guide cuts through the jargon and shows you how to make sense of formulas and functions, charts and PivotTables, samples and normal distributions, probabilities and related distributions, trends and correlations, and much more. * Use Excel's tools to analyze and understand data * Apply statistical analysis to predict trends and make decisions * Interpret sales figures, gambling odds, and sports stats * Develop a grading curve or medical correlations Forget the mumbo jumbo! This guide shows you that statistical analysis with Excel can be easy, fun, and useful!
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.
eBook
Office 2021 all-in-one for dummies
Say hello to Office productivity with this one-stop reference
With Office 2021 All-in-One For Dummies, you can get up and running with Microsoft's legendary software suite. This update covers all the tweaks you can find in the latest version of Word, Excel, PowerPoint, Outlook, and Teams. You'll also learn how to make these apps work harder for you, because we dig deep into the tips and features that casual Office users might not know about. This edition also offers expanded coverage of Teams and other collaborative tools, so you can nail working from home, or just get a few of those meetings out of the way without having to leave your desk.
How can you quickly give documents the same format in Word? What was that one useful Excel function, again? And how does setting up a meeting on Teams work? Office 2021 All-in-One For Dummies serves up quick and simple answers to these questions, along with hundreds of other answers you're expected to know when you work in Office.
* Learn how Microsoft Office works and get the most out of Word, Excel, PowerPoint, Outlook, and Teams
* Make amazing charts and graphs that you can plug into your documents, spreadsheets, and presentations
* Get better at working collaboratively with file sharing options and other neat features
* Do more, faster with expert tips and guidance on the full suite of Office software for 2021
Whether you're new to Office or just need a refresher for the newest updates, the nine mini-books inside are your keys to getting stuff done.
eBook
Financial modeling : an introductory guide to Excel and VBA applications in finance
This volume provides a comprehensive introduction to modern financial modelling using Excel, VBA, standards of financial modelling and model review. It offers guidance on essential modelling concepts around the four core financial activities in the modern financial industry today: financial management; corporate finance; portfolio management and financial derivatives.
Book
Orchestrating privacy-protected big data analyses of data from different resources with R and DataSHIELD
Combined analysis of multiple, large datasets is a common objective in the health- and biosciences. Existing methods tend to require researchers to physically bring data together in one place or follow an analysis plan and share results. Developed over the last 10 years, the DataSHIELD platform is a collection of R packages that reduce the challenges of these methods. These include ethico-legal constraints which limit researchers’ ability to physically bring data together and the analytical inflexibility associated with conventional approaches to sharing results. The key feature of DataSHIELD is that data from research studies stay on a server at each of the institutions that are responsible for the data. Each institution has control over who can access their data. The platform allows an analyst to pass commands to each server and the analyst receives results that do not disclose the individual-level data of any study participants. DataSHIELD uses Opal which is a data integration system used by epidemiological studies and developed by the OBiBa open source project in the domain of bioinformatics. However, until now the analysis of big data with DataSHIELD has been limited by the storage formats available in Opal and the analysis capabilities available in the DataSHIELD R packages. We present a new architecture (“ resources ”) for DataSHIELD and Opal to allow large, complex datasets to be used at their original location, in their original format and with external computing facilities. We provide some real big data analysis examples in genomics and geospatial projects. For genomic data analyses, we also illustrate how to extend the resources concept to address specific big data infrastructures such as GA4GH or EGA, and make use of shell commands. Our new infrastructure will help researchers to perform data analyses in a privacy-protected way from existing data sharing initiatives or projects. To help researchers use this framework, we describe selected packages and present an online book ( https://isglobal-brge.github.io/resource_bookdown ).
Journal Article