Catalogue Search | MBRL
Are you sure you want to remove the book from the shelf?
{{itemTitle}}
17,801
result(s) for
"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
Think you’re good with spreadsheets? Meet the Excel athletes
The best college spreadsheet warriors gathered in Las Vegas in December for the Microsoft Excel Collegiate Challenge to find out whose data skills will triumph.
Streaming Video
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
Peer review declaration
All conference organisers/editors are required to declare details about their peer review. Therefore, please provide the following information: • Type of peer review: Single-blind Single-anonymous: authors’ identities are known to the reviewers, reviewers’ identities are hidden from authors • Describe criteria used by Reviewers when accepting/declining papers. Was there the opportunity to resubmit articles after revisions? We advertised the conference with the expectation that each participant would author or co-author a presentation, and that most presentations would lead to a paper in the proceedings. Peer reviewers were directed to the IOPP Conference Series guidance, including the Proceedings peer review policy. Two peer reviewers were assigned to each paper: care was taken to ensure good mixing of pairings of reviewers. As many of the authors were students or early career researchers, we anticipated that there would be a need for multiple review iterations. Reviewer feedback was intended to be helpful and focussed on the technical content and the clarity of exposition. In addition to review of the technical content, there was also support for using the template, improving the layout of content, and referencing. We encouraged resubmissions and encouraged the authors to make as many improvements as would be feasible within reasonable amount of time. • Conference submission management system: The papers were numbered, and resubmitted versions were also numbered. Progress with the submission and the review process was monitored using a spreadsheet. • Number of submissions received: Initially, there were expected to be 35 papers, but one missed the abstract deadline, two did not register for the conference, and one withdrew after the conference. As a result, 31 paper submissions were received. • Number of submissions sent for review: 31 submissions were sent for review. • Number of submissions accepted: 27 submissions were accepted. • Acceptance Rate (Number of Submissions Accepted / Number of Submissions Received X 100): Acceptance rate = 87% • Average number of reviews per paper: Each paper was reviewed by two reviewers • Total number of reviewers involved: 13 reviewers • Any additional info on review process (ie plagiarism check system): Some support was provided for use of Word templates, English language grammar, checking accuracy of reference information. The two proceedings Editors provided support to reviewers and authors when required. • Contact person for queries: Alison McMillan a.mcmillan@glyndwr.ac.uk
Journal Article
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 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
Excel macros for dummies
Offers instructions on automating aspects of Excel in order to streamline workflow and minimize errors.
Book
Excel Formulas & Functions For Dummies, 6th Edition
Unlock the power of Excel with a step-by-step roadmap to its formulas and functionsThere's a Swiss Army knife in your digital toolbox that can multiply your productivity and make you the smartest guy or gal in almost any room. It's called Microsoft Excel. If you're like most people, you've barely scratched the surface of what this powerful tool's hundreds of built-in functions can do. But with a little help from Excel Formulas & Functions For Dummies, you'll soon be organizing, analyzing, and interpreting data like a pro. For those who don't know the difference between a spreadsheet and a bedsheet, the book gets you up to speed with formula and function basics first. But you can also skip ahead to the fancy stuff and learn about working with probabilities, significance tests, and lookup functions. This easy-to-use Excel formulas and functions survival guide shows you how to: Work with financial functions like PMT, PPMT, NPER, RATE, and PVCalculate mean, median, mode, standard deviation, and many more statistical functionsTroubleshoot formulas for common errors and validate your data to avoid mistakesWork with dates, times, logic operators, conditions, and basic and advanced mathematical functionsYou don't need a degree in data science or advanced mathematics to take advantage of the full functionality and flexibility of Microsoft Excel. Let Excel Formulas & Functions For Dummies show you how to transform this unassuming program into the most useful tool in your toolbox.
eBook