Articles by "Excel"

Showing posts with label Excel. Show all posts

Dawn Griffiths - 589 pages - Language: English - Publisher: ‎O'Reilly Media; (June, 2024) - ISBN-10: ‎1098143329 - ISBN-13: ‎978-1098143329.

Filled with tips, tricks, and techniques, this easy-to-use book is the perfect resource. You'll find more than 350 recipes for over a dozen topics covering formulas, PivotTables, charts, Power Query, and more. Each recipe poses a particular problem and outlines a solution that you can put to use right away—without having to comb through tutorial pages.

Whether you're a data analyst, project manager, financial analyst, or regular Excel user, author Dawn Griffiths directs you straight to the answers you need. Ideal as a quick reference, Excel Cookbook is also perfect for learning how to work in a more efficient way, leading to greater productivity on the job. With this book, you'll jump in and get answers to your questions—fast.

Build compelling charts and use Sparklines, 3D Maps, and other visualizations + Use PivotTables to slice, dice, and summarize datasets + Perform statistical and financial analyses using formulas, Forecast Sheets, the Analysis ToolPak, and more + Master dynamic array functions such as SEQUENCE, TEXTSPLIT, and FILTER + Use Power Query to import, shape, and combine datasets + Create custom functions using LAMBDA formulas + Use developer options to write VBA code and create custom UserForms.

David E. Clough, Steven C. Chapra ... Language: ‎English - Publisher: ‎CRC Press; (October, 2023).

Spreadsheet Problem Solving and Programming for Engineers and Scientists provides a comprehensive resource essential to a full understanding of modern spreadsheet skills needed for engineering and scientific computations.

Beginning with the basics of spreadsheets and programming, this book builds on the authors’ decades of experience teaching spreadsheets and programming to both university students and professional engineers and scientists. Following on from this, it covers engineering economics, key numerical methods, and applied statistics. Finally, this book details the Visual Basic for Applications (VBA) programming system that accompanies Excel.

With each chapter including examples and a set of exercises, this book is an ideal companion for all engineering courses and also for self-study. Based on the latest version of Excel (Microsoft Excel for Microsoft 365), it is also compatible with earlier versions of Excel dating back to Version 2013. Including numerous case studies, this book will be of interest to students and professionals working in all areas of engineering and science.

Language: English - Level: Beginner - Number of Lessons: 78 - Duration: 5 hours and 26 minutes.


Statistics for Business Analytics: Data Analysis with Excel is a training course on the importance of statistics in business and business data analysis in Excel software, published by Udemy Academy. Statistical modeling is a very important skill for data analysts, and in this training course you will practice this skill with Excel software. Today, data has included all parts of our lives, and the success of business and various decisions in various industries depends on access to appropriate data and their correct analysis. The world is moving day by day towards a purely data-centric direction, and in this direction, many job positions have been created for data engineers and analysts.

This course is completely comprehensive and includes all the details of statistical modeling and business analysis. What you will learn?: Data Analysis with Excel:Basic principles and basics of statistics and their application in the world of business and various industries + Carrying out data analysis and analysis projects in the powerful Excel software environment + Various statistical methods and their exploitation to solve business problems and finalize data-driven decisions + Statistical assumption test with Excel software + Data-driven decision making and its principles + Business data analysis with descriptive statistics and statistical inference in Excel software + Construction and interpretation of various statistical models based on business data + Implementation of statistical analysis or regression analysis in Excel software to predict the future + Different techniques for analyzing huge and large data sets + Evaluation of different scenarios using available data ...

Franz Kronthaler ... 367 pages - Language: English - Publisher: ‎Springer; (November, 2022) - ISBN-10: 3662643189 - ISBN-13: 978-3662643181.


This book shows you how to analyze data sets systematically and to use Excel 2019 to extract information from data almost effortlessly. Both are (not) an art! The statistical methods are presented and discussed using a single data set. This makes it clear how the methods build on each other and gradually more and more information can be extracted from the data. The Excel functions used are explained in detail - the procedure can be easily transferred to other data sets. 

Various didactic elements facilitate orientation and working with the book: At the checkpoints, the most important aspects from each chapter are briefly summarized. In the freak knowledge section, more advanced aspects are addressed to whet the appetite for more. All examples are calculated with hand and Excel. Numerous applications and solutions as well as further data sets are available on the author's internet platform.

Jonathan Schwabish ... 384 pages - Language: English - Publisher: A.K. Peters/CRC Press; (May, 2023) - ISBN-10: ‎1032343265 - ISBN-13: ‎978-1032343266.

This book closes the gap between what people think Excel can do and what they can achieve in the tool. Over the past few years, recognition of the importance of effectively visualizing data has led to an explosion of data analysis and visualization software tools. But for many people, Microsoft Excel continues to be the workhorse for their data visualization needs, not to mention the only tool that many data workers have access to. Although Excel is not a specialist data visualization platform, it does have strong capabilities. The default chart types do not need to be the limit of the tool’s data visualization capabilities, and users can extend its features by understanding some key elements and strategies.

Data Visualization in Excel provides a step-by-step guide to creating more advanced and often more effective data visualizations in Excel and is the perfect guide for anyone who wants to create better, more effective, and more engaging data visualizations.

James Jordan ... 497 pages - Language: ‎ English - Publisher: ‎Independently published; (September, 2021).


Microsoft has added over a hundred new features and enhancements to Excel over the past years! The tools outlined in this guide book are among those that offer some of the greatest opportunities to all levels of Excel users to improve their efficiency and proficiency. Therefore, as you gain access to these tools – and others sure to follow – be sure to consider how you and your team members can and should take advantage of them to boost productivity. This book is specially made for business men, corporate bodies, organization, individuals, etc. who are looking for a means of learning Excel from basics to advanced (formulas, functions, VBA, Macros,etc.) level.

In this Excel 2021 guide, you’ll: Learn How to Analyze the Quality of Your Data with Power Query + Learn How to use Dynamic Array(FILTER, SORT, RANDARRY, SEQUENCE, SORTBY, and UNIQUE) + Learn How to enter basic formulas and calculations in excel + Learn How to select, activate and edit cells in excel+ Learn How to Create and manage workbooks and worksheets + Learn How to create a spreadsheet in word + Learn How to create charts in excel: types and examples + Learn How to format an excel table + Learn powerful and essential Excel Formulas and Functions + Learn How to Illustrate using XLOOKUP + Learn How to Automate Data Analysis with Excel’s Ideas Feature + Get familiar with Worksheet design + Find out how to work with charts and graphics +Use Excel for data management, analysis, modeling, and visualization + Basic and Professional Excel tips and tricks and Lots more…

Rémy Lentzner ... 111 pages - Language: ‎English - Publisher: Remylent; (April, 2021).

Excel makes life easier because its powerful functions are easily accessible. With the spreadsheet you can handle numbers, dates, formulas or simply text. This book will be an asset to improve your skills by learning more complex functions and finally to save a lot of time. The examples presented in this manual will help you to analyse data better. Do not hesitate to test them in order to discover excel's strengths. It reflects real management situations. You can reproduce them with all Excel versions. Accessible to all, this manual guides you, step by step, to increase your knowledge.

T.J. Quirk ... 264 Pages - Language: ‎English - Publisher: ‎Springer; 2nd edition (March, 2021).


This textbook is a step-by-step guide for high school, community college, and undergraduate students who are taking a course in applied statistics and wish to learn how to use Excel to solve statistical problems. All of the statistics problems in this book come from the following fields of study: business, education, psychology, marketing, engineering and advertising. Students will learn how to perform key statistical tests in Excel without being overwhelmed by statistical theory.Each chapter briefly explains a topic and then demonstrates how to use Excel commands and formulas to solve specific statistics problems. The book offers guidance in using Excel in two different ways: (1) writing formulas (e.g., confidence interval about the mean, one-group t-test, two-group t-test, correlation) and (2) using Excel’s drop-down formula menus (e.g., simple linear regression, multiple correlations and multiple regression, and one-way ANOVA). Three practice problems are provided at the end of each chapter, along with their solutions in an appendix. An additional practice test allows readers to test their understanding of each chapter by attempting to solve a specific statistics problem using Excel; the solution to each of these problems is also given in an appendix. This book is a tool that can be used either by itself or along with any good statistics book.​

Ahmed Sheikh ... 92 pages - Language: English - Publisher: Independently published; (December, 2019) - ISBN-10: ‎1651129436 - ISBN-13: 978-1651129432.


Excel has its immense purposeful applications. 95% of the users apply the basic form. There are functions and advanced excel formula that can be used for complex calculations. The functions are designed for easy lookup and formatting of large pool of data whereas the advanced excel formula are implemented to get new information from a given particular set of data.

Allan Murray ... 368 pages - Publisher: ‎Apress; (December, 2020) - Language: English - ISBN-10 : 1484264665 - ISBN-13:‎ 978-1484264669.


Learn the Advanced Excel features and skills that are not taught in classes. Advanced Excel tricks, XLOOKUP, SUMPRODUCT, Power Query, Power Pivot and much more. This book is perfect for anyone who uses Excel regularly and wants to take the step to the next level. If you are a Beginner to Intermediate level Excel user, this book is a must-have. You will learn the advanced Excel features and techniques that others do not know.

In this book, you will learn: - Tricks and innovative ways to boost your productivity in Excel. - The best functions in Excel including XLOOKUP, FILTER, SORTBY, SWITCH and more with 'real world' examples. - Advanced formatting techniques to take your formatting to another level. - Create dynamic, interactive, and effective charts. - Power Query - possibly the greatest and most-important upgrade in the history of Excel. - Power Pivot - no more lookups. Learn to model your data, handle large volumes with ease and perform powerful DAX calculations. 

This book it a must-have to stay ahead of the crowd and be a success in the workplace. Take advantage of the power in modern Excel.

Peter John ... 573 pages - Language: ‎English - Publication: (September, 2021).


The need for the use of Word and Excel increases as time passes by. This user guide is all you need to meet up and learn Microsoft Word and Excel with ease as it comprises of detailed and well understood illustrative instructions and explanations. This user guide will allow you get acquainted to Word 2021 (Word 365 inclusive) user interface and how to create a professional looking document making use of features such as inserting page break, setting up and adjusting page margins, inserting header and footers, adjusting the text alignment, changing the font in your text, exploring word styles, creating and modifying tables, the proofing techniques, desktop publishing with Word, shortcuts, tips and tricks and lots more. For Excel 2021 (Excel 365 inclusive), you will be learning how to use Excel using the features such as inserting rows and columns, freezing and unfreezing rows and columns, managing worksheet, functions and formulas, cell referencing, solving some printing issues, working with tables and charts, and lots more. With this user guide, you are several steps ahead to learning the rudiments needed to help you harness your skills more, whether you are a beginner or an expert.

Glyn Davis, Branko Pecar.... Publication date: ‎(January, 2021) - Language: English.

Statistics for Business Students (ISBN: 978-1-63795-762-2) brings the teaching of statistics into the 21st century. Rather than focusing on mathematics behind formulae, this textbook uses two most used platforms to teach the subject, and these are Microsoft Excel and IBM SPSS. The emphasis is on applications, understanding what the functions deliver, and how to interpret the results.

A brief content of this 756-page book is: Preface + Chapter 1 Data Visualisation + Chapter 2 Descriptive statistics + Chapter 3 Probability distributions + Chapter 4 Sampling distributions + Chapter 5 Point and interval estimates + Chapter 6 Hypothesis testing + Chapter 7 Parametric hypothesis tests + Chapter 8 Nonparametric tests + Chapter 9 Linear correlation and regression analysis + Chapter 10 Introduction to time series data, long term forecasts and seasonality + Chapter 11 Short and medium-term forecasts + Appendices + Index.

Kevin Stratvert ... 120 pages - Publisher:  Independently published; (January, 2021) - Language: English - ISBN-13: ‎979-8702051451.

Excel is a powerful spreadsheet application that plays important role in our world today. This book is a great material you need to learn about the application. It will guide you through on the basics in Excel. It is easy to follow guide with clear graphical illustrations.

Among the arears covered in this book are as follow: Detailed explanation on Excel application + Creating of sheets and Editing + Sharing and collaboration + Reviewing + Sheets and workbook protection + Basic Excel functions and task completions + Customization + How to complete tasks through different tabs of the application + Use of formulas + Charts + How to use Excel application in smart phones and many more.

Lindo What'sBest! v17.0.0.0 x64 [Size: 57.7 MB] ... What'sBest! is an add-in to Excel that allows you to build large scale optimization models in a free form layout within a spreadsheet. What'sBest! combines the proven power of Linear, Nonlinear (convex and nonconvex/Global), Quadratic, Quadratically Constrained, Second Order Cone, Semi-Definite, Stochastic, and Integer optimization with Microsoft Excel - the most popular and flexible business modeling environment in use today. The recently released What'sBest! 15.0 includes a number of significant enhancements and new features. Enhancements to the Simplex solvers boost performance on linear models. Large models solve an average of 20% faster using primal simplex and 15% faster for dual simplex. New symmetry detection capabilities dramatically reduce the time required to prove optimality on certain classes of models with integer variables. Performance has been improved on Markowitz portfolio problems with minimum buy quantities, and/or limit on number of instruments at nonzero level. Other enhancements provide faster solutions on certain task assignment-like models. Stability and robustness of the Global solver has been improved through several enhancements to quadratic recognition and range reduction. Improved exploitation of convexity of certain ratio constraints, e.g., as found in heat exchanger network design problems. Several new functions and constraint types are recognized, e.g., the =WBALLDIFF() All Different constraint, for general integer variables. The =WBALLDIFF() function allows one to specify a set of integer variables, such that each variable in the set must have a unique value, different from all other variables in the set.

Thomas Cleff ... 497 pages - Publisher: Springer; (July, 2019) ... Language: English - AmazonSIN: B07V82V6L6.

This textbook will familiarize students in economics and business, as well as practitioners, with the basic principles, techniques, and applications of applied statistics, statistical testing, and multivariate data analysis. Drawing on practical examples from the business world, it demonstrates the methods of univariate, bivariate, and multivariate statistical analysis. The textbook covers a range of topics, from data collection and scaling to the presentation and simple univariate analysis of quantitative data, while also providing advanced analytical procedures for assessing multivariate relationships. Accordingly, it addresses all topics typically covered in university courses on statistics and advanced applied data analysis. In addition, it does not limit itself to presenting applied methods, but also discusses the related use of Excel, SPSS, and Stata.

Hector Guerrero ... 346 pages - Publisher: Springer; 2nd edition (December, 2018) ... Language: English - ISBN-10: 3030012786 - ISBN-13: 978-3030012786.

This book offers a comprehensive and readable introduction to modern business and data analytics. It is based on the use of Excel, a tool that virtually all students and professionals have access to. The explanations are focused on understanding the techniques and their proper application, and are supplemented by a wealth of in-chapter and end-of-chapter exercises. In addition to the general statistical methods, the book also includes Monte Carlo simulation and optimization. The second edition has been thoroughly revised: new topics, exercises and examples have been added, and the readability has been further improved. The book is primarily intended for students in business, economics and government, as well as professionals, who need a more rigorous introduction to business and data analytics – yet also need to learn the topic quickly and without overly academic explanations.

Microsoft Office Professional Plus 2019 v1912 Build 12325.20298 [Size: 3.76 GB for x64] ... Office Professional Plus 2019 includes Access, Excel, Outlook, PowerPoint, Publisher, Word, and Skype for Business. There isn’t a 2019 version of OneNote, but OneNote 2016 is available for Office 2019.

We recommend that you uninstall existing versions of Office before you deploy Office 2019. If you’re uninstalling previous versions of Office products that were installed with Windows Installer (MSI), the Office Deployment Tool can remove most of those for you as part of the installation of Office 2019. After downloading the installation files, internet access isn’t required to install, activate, or use Office 2019. There isn’t a 2019 version of SharePoint Designer or InfoPath. The last version for both products is 2013. Office 2019 is a valuable update for customers who aren’t yet ready for the cloud. And each time we release a new on-premises version of Office, customers ask us if this will be our last. We’re pleased to confirm that we’re committed to another on-premises release in the future.

Kenneth R. Baker ... 392 pages - Publisher: Wiley; 3rd edition (July, 2015) ... Language: English - ISBN-10: 1118937694 - ISBN-13: 978-1118937693.

Updated and revised, Optimization Modeling with Spreadsheets, Third Edition emphasizes model building skills in optimization analysis. By emphasizing both spreadsheet modeling and optimization tools in the freely available Microsoft® Office Excel® Solver, the book illustrates how to find solutions to real-world optimization problems without needing additional specialized software.

The Third Edition includes many practical applications of optimization models as well as a systematic framework that illuminates the common structures found in many successful models. With focused coverage on linear programming, nonlinear programming, integer programming, and heuristic programming, Optimization Modeling with Spreadsheets, Third Edition features: An emphasis on model building using Excel Solver as well as appendices with additional instructions on more advanced packages such as Analytic Solver Platform and OpenSolver * Additional space devoted to formulation principles and model building as opposed to algorithms * New end-of-chapter homework exercises specifically for novice model builders * Presentation of the Sensitivity Toolkit for sensitivity analysis with Excel Solver * Classification of problem types to help readers see the broader possibilities for application * Specific chapters devoted to network models and data envelopment analysis * A companion website with interactive spreadsheets and supplementary homework exercises for additional practice. Optimization Modeling with Spreadsheets, Third Edition is an excellent textbook for upper-undergraduate and graduate-level courses that include deterministic models, optimization, spreadsheet modeling, quantitative methods, engineering management, engineering modeling, operations research, and management science. The book is an ideal reference for readers wishing to advance their knowledge of Excel and modeling and is also a useful guide for MBA students and modeling practitioners in business and non-profit sectors interested in spreadsheet optimization.

Bichara B. Muvdi, Souhail Elhouar ... 728 pages - Publisher: CRC Press; (May, 2016) ... Language: English - ISBN-10: 1466570717 - ISBN-13: 978-1466570719. 

Mechanics of Materials: With Applications in Excel covers the fundamentals of the mechanics of materials―or strength of materials―in a clear and easily understandable way. Each chapter explains the theory of the underlying principles and the applicable mathematical relations, offering examples that illustrate the application of the mathematical relations to physical situations. Then, homework problems―arranged from the simplest to the most demanding―are presented, along with a number of challenging review problems, to ensure comprehension of key concepts. What makes this book unique is that it also instills practical skills for developing Microsoft Excel applications to solve mechanics of materials problems using numerical techniques. Mechanics of Materials: With Applications in Excel provides editable Excel spreadsheets representing all the examples featured in the text, PowerPoint lecture slides, multimedia simulations, graphics files, and a solutions manual with qualifying course adoption.

Conrad Carlberg ... 568 pages - Publisher: Que Publishing; (December, 2017) ... Language: English - ISBN-10: 0789759055 - ISBN-13: 978-0789759054

Nationally recognized Excel expert Conrad Carlberg shows you how to use Excel 2016 to perform core statistical tasks every business professional, student, and researcher should master. Using real-world examples and downloadable workbooks, Carlberg helps you choose the right technique for each problem and get the most out of Excel’s statistical features. Along the way, he clarifies confusing statistical terminology and helps you avoid common mistakes. You’ll learn how to use correlation and regression, analyze variance and covariance, and test statistical hypotheses using the normal, binomial, t, and F distributions. To help you make accurate inferences based on samples from a population, Carlberg offers insightful coverage of crucial topics ranging from experimental design to the statistical power of F tests. Updated for Excel 2016, this guide covers both modern consistency functions and legacy compatibility functions. Becoming an expert with Excel statistics has never been easier! In this book, you’ll find crystal-clear instructions, insider insights, and complete step-by-step guidance.

Contact Form

Name

Email *

Message *

Powered by Blogger.