Ebook307 pages1 hour
Microsoft Excel Statistical and Advanced Functions for Decision Making
Rating: 4 out of 5 stars
4/5
()
About this ebook
Perform various data analysis using statistical functions, filters and histograms! Learn all about pivot tables and pivot charts! Use the Solver and Goal Seek to find optimum results! Perform sales forecasting and various predictions using Excel's built-in functions!
This book was written to help any users wanting to have a good grasp on the advanced functions and an analysis of the various statistical tools for the purpose of decision making. It goes further by introducing the concepts of filters, estimating and forecasting, data validation, conditional formatting, goal seek, using the solver, and finally, pivot tables and pivot charts.
Many books have been written on Excel. However, this book explains most of the advanced functions and features in a rather simplified manner with plenty of screen captures wherever possible. New users and existing users on Excel will find this book handy.
This book was written to help any users wanting to have a good grasp on the advanced functions and an analysis of the various statistical tools for the purpose of decision making. It goes further by introducing the concepts of filters, estimating and forecasting, data validation, conditional formatting, goal seek, using the solver, and finally, pivot tables and pivot charts.
Many books have been written on Excel. However, this book explains most of the advanced functions and features in a rather simplified manner with plenty of screen captures wherever possible. New users and existing users on Excel will find this book handy.
Read more from Palani Murugappan
Effective Budgeting Using Microsoft Excel Rating: 0 out of 5 stars0 ratingsCost Reduction Strategies for the Manufacturing Sector With Application of Microsoft Excel Rating: 0 out of 5 stars0 ratingsCost Reduction Strategies Rating: 0 out of 5 stars0 ratingsFinancial Modelling and Analysis Using Microsoft Excel - For Non Finance Personnel Rating: 0 out of 5 stars0 ratingsMastering Presentation Skills Using Microsoft Powerpoint Rating: 0 out of 5 stars0 ratingsEffective Budgetting Rating: 0 out of 5 stars0 ratingsExcel Functions for the Daily User Rating: 0 out of 5 stars0 ratingsInternet Explorer Rating: 0 out of 5 stars0 ratingsExcel Functions for the Daily User - Vol 2 Rating: 0 out of 5 stars0 ratings
Related to Microsoft Excel Statistical and Advanced Functions for Decision Making
Related ebooks
Microsoft Excel: Advanced Microsoft Excel Data Analysis for Business Rating: 0 out of 5 stars0 ratingsAn Introduction to Statistics using Microsoft Excel Rating: 0 out of 5 stars0 ratingsExcel Formulas That Automate Tasks You No Longer Have Time For Rating: 5 out of 5 stars5/5Excel Formulas and Functions 2020: Excel Academy, #1 Rating: 4 out of 5 stars4/5Statistics: Practical Concept of Statistics for Data Scientists Rating: 0 out of 5 stars0 ratingsSurviving Statistics: A Professor's Guide to Getting Through Rating: 0 out of 5 stars0 ratingsTop 20 MS Excel VBA Simulations, VBA to Model Risk, Investments, Growth, Gambling, and Monte Carlo Analysis Rating: 3 out of 5 stars3/5Microsoft Excel Statistical and Advanced Functions for Decision Making Rating: 5 out of 5 stars5/5Excel Dashboards and Reports Rating: 5 out of 5 stars5/5Microsoft Excel Functions Vol 1 Rating: 2 out of 5 stars2/5150 Most Poweful Excel Shortcuts: Secrets of Saving Time with MS Excel Rating: 3 out of 5 stars3/5Mastering Excel Macros: Introduction: Mastering Excel Macros, #1 Rating: 4 out of 5 stars4/5Top Secrets Of Excel Dashboards: Save Your Time With MS Excel Rating: 5 out of 5 stars5/5MrExcel LX The Holy Grail of Excel Tips: Covers Excel Backwards and Forwards Rating: 0 out of 5 stars0 ratingsExcel Tables: A Complete Guide for Creating, Using and Automating Lists and Tables Rating: 5 out of 5 stars5/5Excel 2019 Conditional Formatting: Easy Excel Essentials 2019, #3 Rating: 0 out of 5 stars0 ratingsExcel Statistics: Step by Step Rating: 4 out of 5 stars4/5Excel 2019 PivotTables: Easy Excel Essentials 2019, #1 Rating: 5 out of 5 stars5/5Pivot Tables In Depth For Microsoft Excel 2016 Rating: 3 out of 5 stars3/5Managing Data Using Excel Rating: 5 out of 5 stars5/5Guerilla Data Analysis Using Microsoft Excel Rating: 0 out of 5 stars0 ratingsExcel Dashboards and Reports for Dummies Rating: 4 out of 5 stars4/5More Excel Outside the Box: Unbelievable Excel Techniques from Excel MVP Bob Umlas Rating: 0 out of 5 stars0 ratingsPivot Tables: Easy Excel Essentials, #1 Rating: 0 out of 5 stars0 ratingsExcel Simulations Rating: 4 out of 5 stars4/5Excel Power Pivot and Power Query For Dummies Rating: 3 out of 5 stars3/5Statistical Analysis with Excel For Dummies Rating: 3 out of 5 stars3/5
Business For You
The Intelligent Investor, Rev. Ed: The Definitive Book on Value Investing Rating: 4 out of 5 stars4/5Emotional Intelligence: Exploring the Most Powerful Intelligence Ever Discovered Rating: 5 out of 5 stars5/5Your Next Five Moves: Master the Art of Business Strategy Rating: 5 out of 5 stars5/5The Book of Beautiful Questions: The Powerful Questions That Will Help You Decide, Create, Connect, and Lead Rating: 4 out of 5 stars4/5The Richest Man in Babylon: The most inspiring book on wealth ever written Rating: 5 out of 5 stars5/5Robert's Rules Of Order Rating: 5 out of 5 stars5/5Becoming Bulletproof: Protect Yourself, Read People, Influence Situations, and Live Fearlessly Rating: 4 out of 5 stars4/5Financial Words You Should Know: Over 1,000 Essential Investment, Accounting, Real Estate, and Tax Words Rating: 4 out of 5 stars4/5Grant Writing For Dummies Rating: 5 out of 5 stars5/5Collaborating with the Enemy: How to Work with People You Don’t Agree with or Like or Trust Rating: 4 out of 5 stars4/5Lying Rating: 4 out of 5 stars4/5Tools Of Titans: The Tactics, Routines, and Habits of Billionaires, Icons, and World-Class Performers Rating: 4 out of 5 stars4/5How to Get Ideas Rating: 5 out of 5 stars5/5Crucial Conversations: Tools for Talking When Stakes are High, Third Edition Rating: 4 out of 5 stars4/5Confessions of an Economic Hit Man, 3rd Edition Rating: 5 out of 5 stars5/5Crucial Conversations Tools for Talking When Stakes Are High, Second Edition Rating: 4 out of 5 stars4/5Good to Great: Why Some Companies Make the Leap...And Others Don't Rating: 4 out of 5 stars4/5Robert's Rules of Order: The Original Manual for Assembly Rules, Business Etiquette, and Conduct Rating: 4 out of 5 stars4/5High Conflict: Why We Get Trapped and How We Get Out Rating: 4 out of 5 stars4/5Law of Connection: Lesson 10 from The 21 Irrefutable Laws of Leadership Rating: 4 out of 5 stars4/5Ask for More: 10 Questions to Negotiate Anything Rating: 4 out of 5 stars4/5Summary of J.L. Collins's The Simple Path to Wealth Rating: 5 out of 5 stars5/5The Catalyst: How to Change Anyone's Mind Rating: 4 out of 5 stars4/5Capitalism and Freedom Rating: 4 out of 5 stars4/5Summary of Eve Rodsky's Fair Play Rating: 2 out of 5 stars2/5
Reviews for Microsoft Excel Statistical and Advanced Functions for Decision Making
Rating: 4 out of 5 stars
4/5
2 ratings1 review
- Rating: 3 out of 5 stars3/5found it somewhat basic - not advanced in my opinion
Book preview
Microsoft Excel Statistical and Advanced Functions for Decision Making - Palani Murugappan
Enjoying the preview?
Page 1 of 1