Excel Basics. Mastering Excel Foundation and Spreadsheets Efficiently through Formulas & Graphs

Mercury Learning and Information, Jeffrey Hsu, Gary Bronson

This book is designed for first-time or beginning Excel users, providing a comprehensive yet accessible introduction to mastering Microsoft Excel 2019 and previous versions. Starting with the basics, it guides readers through the foundational concepts and features of Excel, ensuring a solid understanding of this essential software. Key topics include an overview of Excel, formulas, functions, formatting, conditional features, graphs, charts, pivot tables, and using a spreadsheet as a database.The book is richly illustrated with screenshots, examples, applications, and exercises to reinforce learning. Suitable for professional reference, self-study, or instructor-led courses, it equips readers with the skills to enhance business and personal productivity. The content is structured to build from basic to advanced topics, making it a valuable resource for users at any stage of learning.With additional resources like tutorial videos, PowerPoint slides, sample syllabi, tests, and quizzes, this book ensures a thorough and engaging learning experience. By the end of the course, users will be proficient in Excel, capable of leveraging its full potential to streamline tasks and improve efficiency.

Mathematics for Business. Explore Essential Mathematical Concepts and Techniques for Decision Making

Mercury Learning and Information, Gary Bronson, Richard Bronson, Maureen Kieff

This course provides a comprehensive understanding of quantitative methods essential for economic forecasting, resource allocation, portfolio analysis, inventory management, data-mining, and addressing social and climate challenges. Starting with foundational topics like finite mathematics and the mathematics of finance, it progresses to differential calculus, optimization, and curve fitting. These concepts are vital for solving contemporary business problems.Learners will explore algebra, finite math, finance mathematics, calculus, optimization techniques, and curve fitting, applying these methods to realistic business scenarios. Topics include cash flow, amortization, interest, loans, annuities, revenue/cost models, break-even analysis, inventory control, and econometrics. Each section includes extensive examples and exercises, reinforced by key terms and concepts, making the material accessible and practical.The course begins with basic mathematical concepts and advances through increasingly complex topics. By the end, learners will have the tools to tackle various business problems using quantitative methods, making this course invaluable for anyone in the business field. This structured approach ensures both theoretical knowledge and practical application, preparing learners for real-world challenges.