Catalogue Search | MBRL
Are you sure you want to remove the book from the shelf?
{{itemTitle}}
1,599
result(s) for
"EXCEL"
Sort by:
Microsoft excel expert certification MO-201: results, analysis and key tips to succeed
Microsoft Excel skills are imperative in today’s competitive market and the skill is highly demanded by businesses. The MOS Excel Expert Certification (MO-201) validates the competency that one should build to meet employers’ expectations. The paper addresses the statistical mean rank difference in four skill groups of the certification test. Results of the four groups of the test were compared, using the Kruskal-Wallis’s test. The null hypothesis of the equality of the means for different groups was rejected at the 5% level of significance. Because the null hypothesis was rejected, the Conover post hoc test was applied for multiple pairwise comparisons, to discern which of the sample pair combinations were significantly different. The paper examines some of the concepts of groups 2 and 3 questions where students struggled the most and rendered insights to overcome those hurdles.
Journal Article
Excel formulas & functions for dummies
Unlock the power of Excel with a step-by-step roadmap to its formulas and functions There'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 PV Calculate mean, median, mode, standard deviation, and many more statistical functions Troubleshoot formulas for common errors and validate your data to avoid mistakes Work with dates, times, logic operators, conditions, and basic and advanced mathematical functions You 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
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
A user-friendly method to merge Scopus and Web of Science data during bibliometric analysis
Bibliometric studies in management and related fields are growing exponentially due to the need to systematize and summarize the growing body of publications. To do so, scholars mostly retrieve publications and metadata from either Scopus or Web of Science. Only a few bibliometric studies merge the two databases to conduct a single integrated analysis. Recent studies demonstrated the benefits of merging data from Scopus and Web of Science and presented methods for the merging. In this paper we build upon a recent method to simplify some of the key steps of merging datasets when using the R package Bibliometrix to perform bibliometric analyses. The result is a user friendly, accessible, three-step method that allows researchers to save time without compromising the integrity of the data, and the analysis. Our method is particularly beneficial for a wider application as it does not require coding skills, and neither proprietary nor shareware software.
Journal Article
Data Organization in Spreadsheets
Spreadsheets are widely used software tools for data entry, storage, analysis, and visualization. Focusing on the data entry and storage aspects, this article offers practical recommendations for organizing spreadsheet data to reduce errors and ease later analyses. The basic principles are: be consistent, write dates like YYYY-MM-DD, do not leave any cells empty, put just one thing in a cell, organize the data as a single rectangle (with subjects as rows and variables as columns, and with a single header row), create a data dictionary, do not include calculations in the raw data files, do not use font color or highlighting as data, choose good names for things, make backups, use data validation to avoid data entry errors, and save the data in plain text files.
Journal Article
