Excel Spreadsheet

ISBN Number : 978-93-5299-708-4

Student Price : Rs.350

Student Dollar Price : 14$

Book Edition : First

Year of Publication : 2019

No. Of Pages : 182

Book Weight :0

About The Book

It is a great pleasure in presenting First Edition of this Book "EXCEL SPREADSHEET".

MS Excel, the most widely available spreadsheet on MS Windows machines, is often used for data collection, manipulation, and storage. Elementary and medium-complexity mathematical and statistical functions are included with Excel. More advanced and highly reliable statistical analysis in Excel requires an add-in package.

This book is a supplementary text to any introductory course in statistics. The book supports the instructor by giving students step-by-step screenshots showing access to state-of-the-art statistical computations in Excel directly from the menu bar in Excel. The book can also be used as a computational introduction by data analysts who already have basic statistical skills.

This book is targeted at the student that is looking for a single introductory Excel-based resource that covers three essential business skills—Data Analysis, Business Modeling, and Simulation. I have successfully used this material with undergraduates, MBAs, Executive MBAs and in Executive Education programs. The examples used in the books are flexible to guide teaching goals in many directions.

Key Features of this Book:

I have used a number of examples in this book that I have developed over many years of teaching and consulting. Some are brief and to the point; others are more complex and require considerable effort to digest. There is much to be learned from these examples, not only the analytical techniques, but also approaches to solving complex problems. These examples, as is always the case in real-world, messy problems, require making reasonable assumptions and some concession to simplification if a solution is to be obtained.

 

Contents -

1. Worksheets and Workgroups
2. Cells and Data
3. Managing Tables
4. Functions in Excel
5. Excel Charts and PivotTables
6. Advanced Formulas of Excel
Practicals
Excel 2013 Keyboard Shortcuts

About The Author

Prof. Kiran Gurbani, is currently Head of Computer Science, Department of R.K. Talreja College of Arts, Science & Commerce. She started journey of teaching from the year 1994 from Jondhale Engineering College, CDAC Center of Pune and Mumbai and later joined R.K.T. College. Subsequently, working for Post Graduate M.Sc. Computer Science and Information Technology and Professor in number of premium colleges. Overall 17+ years of experience as a Trainer / Academic In-charge / SME on varied technology platform.

She is a professor from last 17 years for various technologies, object oriented C++, Java, Visual Basic, DoT Net (VB.NET and ASP.NET), Unix shell scripting, Linux Administration, Oracle, SQL, Cloud Computing, Virtualization and Cloud management, web technologies, Software Engineering, Software testing, JBOSS and Web Logic, Parallel and Distributed computing, ADBMS, C# and Internet Technologies.

She is freelancer corporate trainer for the companies–Capgemini, Oracle, c-Edge, seed, CDAC for Unix shell scripting with Ant Technology, Linux, Cloud and Software Engineering (SSAD,OOAD), Networking CCNA and Middleware. She is a Guest faculty for ICWA, MMS Systems and Technologies and M.Sc. Computer Science and Information technology.

She has conducted several workshops and seminars for students and faculties of all over Mumbai. She is Freelancer trainer in various premium colleges of Mumbai and Thane for Troubleshooting of Linux for undergraduate and postgraduate and performed mini projects on Domain creation and uploading website of a company through apache web server, Mini project on Samba server for sharing Windows and Linux machines with Authenticated Users, Mini project of handling data and creating groups, users and authenticate them through Shell scripts of Linux. She is resource person in the training programs for organisations and premium colleges at University Level.

She is Leading as a Project Guide for Final Year Students of Undergraduate and Postgraduate for .NET & Android & Cloud management. She published books on Visual Basic, C++ Programming, Linux Operating System, Java and Data Structures.

She has published several papers:
(1) Different ICT Devices
(2) Problems Faced by Women’s in Career-building
(3) Different Mechanisms of Cloud Storage
(4) OpenStack Private Cloud with GitHub
(5) Probabilistic Independence Virtualization Database with NOSQL Database System Analysis in Bigdata.

Book Reviews

Login Form
Username:
Password: