A Guide to Microsoft Excel 2002 for Business and Management


Book Description

The indispensable guide for all managers and business students who wish to use Microsoft Excel to its full potential. As the industry standard spreadsheet for the analysis and presentation of results, Microsoft Excel is indispensable in the business world. This text provides a practical and straightforward guide to using the functions of Microsoft Excel to their full potential, guiding the reader from basic principles through to the more complicated areas such as modelling, the analysis of charts, reporting, and automatic importing of data from the web directly into an Excel workbook. Bernard Liengme has written this book specifically to meet the requirements of business students and professionals working with Microsoft Excel. The text is illustrated throughout with screen-shots, as well as a wide variety of examples and case studies based in real-world business contexts, introduced with a minimum of maths, and readily adaptable to workplace situations. The new edition has been brought fully up to date with the new Microsoft Office XP release of Excel 2002 but can be used alongside any previous version of Excel, with new Excel 2002 features clearly indicated throughout.




Excel 2002


Book Description

Guide to using the latest edition of the popular Excel spreadsheet program for Office XP from tips on using basic features to easy to understand explanations of advanced functions. By inputting or importing data, analyses for financial, statistical, engineering, or, other professional functions can be made.




Excel 2002 from A to Z


Book Description




Template-based Management


Book Description

The Template-based management (TBM) approach has been used since 2003 across the world in diverse contexts. It has evolved hand-in-hand with the evolution of business: Agile, Blueprints, Canvas, Design Thinking, or Kanban are only few of the many current concepts based on the approach. This book expands and upgrades the author's 2003 book 'Template-driven Consulting' (Springer) by tracing this evolution and offering the current state-of-the-art to practitioners. TBM combines structure and method: pre-structuring diverse processes, it helps to present complex activities and procedures in a simple, clear, and transparent manner and then implement them. The use of TBM ranges from conception or creative work in agencies to designing organizations and strategies, planning and monitoring initiatives and projects, to innovation management and optimizing cost structures, processes, or entire departments and divisions. The book also demonstrates how successful organizations use TBM to methodically and structurally apply the internal know-how in a cost and time-optimal way for attaining sustainable business success. Readers will learn to apply and use TBM, identify its importance, and benefit from a variety of case studies that illustrate the application and use for the entire business and management practice.




The Ferguson Guide to Résumés and Job Hunting Skills


Book Description

Presents a guide to preparing a résumé and conducting a job search, including information on looking beyond classified ads, creating a résumé, writing cover letters, and interviewing for positions.




Forthcoming Books


Book Description




Professional Excel Development


Book Description

The definitive guide to developing applications with Microsoft Excel, this book is written by four authors who are Excel MVPs and run their own companies developing Excel-based applications.




Data Mining for Business Analytics


Book Description

Data Mining for Business Analytics: Concepts, Techniques, and Applications in Python presents an applied approach to data mining concepts and methods, using Python software for illustration Readers will learn how to implement a variety of popular data mining algorithms in Python (a free and open-source software) to tackle business problems and opportunities. This is the sixth version of this successful text, and the first using Python. It covers both statistical and machine learning algorithms for prediction, classification, visualization, dimension reduction, recommender systems, clustering, text mining and network analysis. It also includes: A new co-author, Peter Gedeck, who brings both experience teaching business analytics courses using Python, and expertise in the application of machine learning methods to the drug-discovery process A new section on ethical issues in data mining Updates and new material based on feedback from instructors teaching MBA, undergraduate, diploma and executive courses, and from their students More than a dozen case studies demonstrating applications for the data mining techniques described End-of-chapter exercises that help readers gauge and expand their comprehension and competency of the material presented A companion website with more than two dozen data sets, and instructor materials including exercise solutions, PowerPoint slides, and case solutions Data Mining for Business Analytics: Concepts, Techniques, and Applications in Python is an ideal textbook for graduate and upper-undergraduate level courses in data mining, predictive analytics, and business analytics. This new edition is also an excellent reference for analysts, researchers, and practitioners working with quantitative methods in the fields of business, finance, marketing, computer science, and information technology. “This book has by far the most comprehensive review of business analytics methods that I have ever seen, covering everything from classical approaches such as linear and logistic regression, through to modern methods like neural networks, bagging and boosting, and even much more business specific procedures such as social network analysis and text mining. If not the bible, it is at the least a definitive manual on the subject.” —Gareth M. James, University of Southern California and co-author (with Witten, Hastie and Tibshirani) of the best-selling book An Introduction to Statistical Learning, with Applications in R




The Complete Idiot's Guide to Grammar and Style


Book Description

Provides information on grammatical rules and how to use them, with advice on adding variety to writing, and examples of the right and wrong way to say things.




Advanced Excel Reporting for Management Accountants


Book Description

The advanced tools accountants need to build automated, reliable, and scalable reports using Excel Learn about the functions that work together to automate many of the processes involved in Management Reporting. See how to take advantage of the many new features of Excel 2007 and 2010. Find out how to build validation structures into your spreadsheet reports. Discover how to identify missing or new codes, either in the creation process or in the day-to-day running of the reports. Do it all with Advanced Excel Reporting for Management Accountants. Explore the structures that simplify the report creation process and make the reports more maintainable Learn techniques to "cleanse" data so that it is ready for use in Pivot Tables and formula-based reports Find out the tips and tricks that can make the creation process quicker and easier Discover all you need to know about Excel's summing functions and how versatile they can be Written in a hands-on style that works towards the completion of two reporting case studies, Advanced Excel Reporting for Management Accountants explains and demonstrates techniques so that Management Accountants can learn how to automate many aspects of the reporting process.