Equip your students with the skills and knowledge to solve real-world financial problems as Mayes' FINANCIAL ANALYSIS WITH MICROSOFT EXCEL, 9E combines the power of Excel with a solid foundation in corporate finance.

This edition provides a new focus on time series forecasting and Get & Transform tools (formerly Power Query). Comprehensive coverage addresses the corporate finance topics and tool most important to today's employers, including financial statements, cash budgets, the Security Market Security Line, pro forma financial statements, cost of capital, Visual Basic Applications (VBA) programming and pivot tables. A reader-friendly, self-directed learning approach and numerous study tools make this resource ideal for learners of all levels.

This edition begins with the basics before quickly moving into more advanced Excel features. The easy-to-understand presentation helps students solidify spreadsheet skills while strengthening an understanding of contemporary corporate finance.

Hone your advanced Excel 2016 skills. And earn the credential that proves it! Demonstrate your expertise with Microsoft Excel! Designed to help you practice and prepare for Microsoft Office Specialist (MOS): Excel Expert 2016 certification, this official Study Guide delivers: In-depth preparation for each MOS objective Detailed procedures to help build the skills measured by the exam Hands-on tasks to practice what you've learned Ready-made practice files Sharpen the skills measured by these objectives: Create and Manage Workbooks Apply Custom Formatting and Layouts Create Advanced Formulas Perform Data Analysis Create Advanced Charts and PivotTables

In Excel 2019 gibt es mehr als 400 Funktionen. Aber welche der vielen Funktionen erleichtert Ihnen Ihre Arbeit? Wie setzen Sie die Funktionen richtig ein? Wie lautet die Syntax? Dieses Buch stellt Excel-Einsteigern die 150 nA1/4tzlichsten Excel-Funktionen ausfA1/4hrlich vor. Sie lernen, wie Sie Formeln richtig fA1/4r Statistiken einsetzen, Prognosen erstellen und Wahrscheinlichkeiten berechnen und vieles mehr. Einige Funktionen erleichtern den Alltag mit Excel und lassen Sie schneller erreichen, was Sie eigentlich wollen. Der richtige Gebrauch der Funktionen wird Ihnen anhand von Beispielen verdeutlicht.

Excel Shortcuts: The 100 Top Best Powerful Excel Keyboard Shortcuts in 1 Day! Do you know the power of Microsoft's Excel? Are you able to use Excel to its fullest potential? Do you want to learn Excel fast, quick and easy? Want to skip all the formal training? Can't afford a college class or university class on Excel? Don't have the time? Just want to get started? Want all the formula's? Shortcuts that make using Excel easy? All you have to do is click BUY and your ready to start learning and using excel right away!

Excel Shortcuts: The 100 Top Best Powerful Excel Keyboard Shortcuts in 1 Day! Do you know the power of Microsoft's Excel? Are you able to use Excel to its fullest potential? Do you want to learn Excel fast, quick and easy? Want to skip all the formal training? Can't afford a college class or university class on Excel? Don't have the time? Just want to get started? Want all the formula's? Shortcuts that make using Excel easy? Buy Now!

This book is of paramount importance in the fields of engineering and applied sciences, given that through the values obtained by these procedures, many structures, like spillways of dams and highway culverts, are designed and constructed. The main aim of this book is to provide procedures for implementing many probability distribution functions, all of them based on using a standard and a common computational application known as Excel, which is available to any personal computer user. The computer procedures are given in enough detail, so readers can develop their own Excel worksheets. All the probability distribution functions in the book have schemes to estimate its parameters, quantiles, and confidence limits through the methods of moments and maximum likelihood.

"In this day and age of 'too much information and not enough time, ' the ability to get to the bottom line quickly and in a concise method is what excels companies to the top of their industry. The techniques in this book will allow you to do things you only dreamt of." -Jerry Kohl, president of Brighton Collectibles Develop your Excel macro programming skills using VBA instantly with proven techniques Automate Reports Handle Errors Master Pivot Tables Produce Charts Build User-Defined Functions Migrate to Excel 2007 Query Web Data Build Dialog Boxes Use Data Visualizations Automate Word You are an expert in Excel, but the macro recorder doesn't work and you can't make heads or tails out of the recorded code. If this is you, buy this book. Macros that you record today might work today but not tomorrow. Recorded macros might handle a dataset with 14 records but not one with 12 or 16 records. These are all common problems with the macro recorder that unfortunately cause too many Excel gurus to turn away from writing macros. This book shows you why the macro recorder fails and the steps needed to convert recorded code into code that will work every day with every dataset. The book assumes that you know Excel well, but there is no need for prior programming experience. This book describes everything you could conceivably need to know to automate reports and design applications in Excel VBA. Whether you want to automate reports for your office or design full-blown applications for others, this book is for you.

• Learn VBA syntax as easy-to-understand English
• Automate Excel's power tools: Pivot Tables, Charts, Advanced Filters
• Save hours per week by automating redundanttasks
• Create applications built on top of Excel with custom dialog boxes
• Automatically produce hundreds of Excel reports in seconds
• Understand how changes in Excel 2007 impact your VBA macros

Introduction 1 1 Unleash the Power of Excel with VBA 7 2 This Sounds Like BASIC, So Why Doesn't It Look Familiar? 29 3 Referring to Ranges 61 4 User-Defined Functions 75 5 Looping and Flow Control 101 6 R1C1-Style Formulas 121 7 What's New in Excel 2007 and What's Changed 135 8 Create and Manipulate Names in VBA 143 9 Event Programming 155 10 UserForms--An Introduction 177 11 Creating Charts 197 12 Data Mining with Advanced Filter 249 13 Using VBA to Create Pivot Tables 281 14 Excel Power 337 15 Data Visualizations and Conditional Formatting 373 16 Reading from and Writing to the Web 393 17 XML in Excel 2007 413 18 Automating Word 421 19 Arrays 441 20 Text File Processing 449 21 Using Access as a Back End to Enhance Multi-User Access to Data 461 22 Creating Classes, Records, and Collections 477 23 Advanced UserForm Techniques 493 24 Windows Application Programming Interface (API) 517 25 Handling Errors 529 26 Customizing the Ribbon to Run Macros 543 27 Creating Add-Ins 569 Index 577

Develop the Excel skills that you need to produce spreadsheet solutions to your business needs - instantly! There are an estimated 400 million Excel users, but the majority of them haven't worked out a way to effectively use Excel VBA (Visual Basic for Applications). This book is for those that use Excel at work and who want to use the advanced features of Excel but don't have the time to have extensive training. It takes you through each task (as all Brilliant books do) and describes everything you could want to find out, for example: - how to use the macro recorder - how to take that recorded code and turn it into something useful that will really help you day to day - how to automate reports and design applications Users will then improve their Excel skills so they can in the end save a lot of time and get more done. Brilliantguides allow you to find the info you need quickly, easily and without fuss. It guides you through all the tasks using a highly visual, step-by-step approach - providing exactly what you need to know when you need it.

"By guiding teachers and their students through the workings of Excel, this book ultimately leads to high-ordered decision making about data management and interpretation?a compelling reality of the 21^st century."
Nancy Tanner Edwards, Professor of Education
Missouri Western State College
St. Joseph, MO

"A wonderful tool for instruction in Excel. The authors have given a clear and concise explanation which is easy to comprehend, in addition to practical examples to use with students."
Peggy Miller, Technology Coordinator/Teacher
St. James/Seton School
Omaha, NE 

  Make Microsoft Excel™ work for you?in the classroom and at your desk!

Microsoft Excel is much more than a simple spreadsheet program. It is a sophisticated and flexible reporting, planning, and presentation tool that teachers can use effectively for curriculum prep, class projects, budget planning and reporting, and even as a database. Here is all you need to know on

• Understanding Excel
• Creating a gradebook
• Solving basic mathematics problems
• Building formulas and functions
• Creating charts and graphs
• Making Web pages
• Using color, fonts, and graphics in presentations

. . . and all of it built by tech experts and experienced educators, especially for teachers.

Using Excel in the Classroom is the essential how-to for teachers at all grade levels, filled with specific, classroom-tested templates, and techniques that teachers need most!

Microsoft Excel By: The simplest and quickest guide to operating Excel's complex system! Need to learn Excel quick and easy? Want to know the power of Excel spreadsheets? Tips and secrets revealed of the Microsoft giants program! Shortcuts, quick entries and anything else to make Excel an easy application Want to skip an entire semester or program learning excel? Everything from navigation, performing commands to formatting! Want a better understanding of excels power and functionality of formulas?How about charts or complex spreadsheets? One CLICK and that all gets answered so PURCHASE NOW!

Excel Crash Course for Engineers is a reader-friendly introductory guide to the features, functions, and applications of Microsoft Excel in engineering. The book provides readers with real-world examples and exercises that are directly related to engineering, and offers highly illustrated, step-by-step demonstrations of techniques to solve and visualize engineering problems and situations. The book includes an introduction to MS Excel, along with in-depth coverage of graphing and charting, functions and formulae, Excel's Visual Basic for Applications (VBA) programming language, and engineering data analysis. This powerful tutorial is a great resource for students, engineers, and other busy technical professionals who need to quickly acquire a solid understanding of Excel.

A well-balanced and accessible introduction to the elementary quantitative methods and Microsoft(R) Office Excel(R) applications used to guide business decision making Featuring quantitative techniques essential for modeling modern business situations, Introduction to Quantitative Methods in Business: With Applications Using Microsoft(R) Office Excel(R) provides guidance to assessing real-world data sets using Excel. The book presents a balanced approach to the mathematical tools and techniques with applications used in the areas of business, finance, economics, marketing, and operations. The authors begin by establishing a solid foundation of basic mathematics and statistics before moving on to more advanced concepts. The first part of the book starts by developing basic quantitative techniques such as arithmetic operations, functions and graphs, and elementary differentiations (rates of change), and integration. After a review of these techniques, the second part details both linear and nonlinear models of business activity. Extensively classroom-tested, Introduction to Quantitative Methods in Business: With Applications Using Microsoft(R) Office Excel(R) also includes: * Numerous examples and practice problems that emphasize real-world business quantitative techniques and applications * Excel-based computer software routines that explore calculations for an assortment of tasks, including graphing, formula usage, solving equations, and data analysis * End-of-chapter sections detailing the Excel applications and techniques used to address data and solutions using large data sets * A companion website that includes chapter summaries, Excel data sets, sample exams and quizzes, lecture slides, and an Instructors Solutions Manual Introduction to Quantitative Methods in Business: With Applications Using Microsoft(R) Office Excel(R) is an excellent textbook for undergraduate-level courses on quantitative methods in business, economics, finance, marketing, operations, and statistics. The book is also an ideal reference for readers with little or no quantitative background who require a better understanding of basic mathematical and statistical concepts used in economics and business. Bharat Kolluri, Ph.D., is Professor of Economics in the Department of Economics, Finance, and Insurance at the University of Hartford. A member of the American Economics Association, his research interests include econometrics, business statistics, quantitative decision making, applied macroeconomics, applied microeconomics, and corporate finance. Michael J. Panik, Ph.D., is Professor Emeritus in the Department of Economics, Finance, and Insurance at the University of Hartford. He has served as a consultant to the Connecticut Department of Motor Vehicles as well as to a variety of health care organizations. In addition, Dr. Panik is the author of numerous books, including Growth Curve Modeling: Theory and Applications and Statistical Inference: A Short Course, both published by Wiley. Rao N. Singamsetti, Ph.D., is Associate Professor in the Department of Economics, Finance, and Insurance at the University of Hartford. A member of the American Economics Association, his research interests include the status of war on poverty in the United States since the 1960s and forecasting foreign exchange rates using econometric methods.

Learn to use Excel dashboards and reports to better conceptualize data

Updated for all the?latest features and capabilities of Excel 2013, this go-to resource provides you with in-depth coverage of the individual functions and tools that can be used to create?compelling Excel reports. Veteran author Michael Alexander walks you through the most effective ways to present and report data. Featuring a comprehensive review of a wide array of technical and analytical concepts, this essential guide helps you go from reporting data with simple tables full of dull numbers to presenting key information through the use of high-impact, meaningful reports and dashboards that will wow management both visually and substantively.Details how to analyze large amounts of data and report the results in a way that is both visually attractive and effectiveDescribes how to use different perspectives to achieve better visibility into data, as well as how to slice data into various views on the flyShows how to automate redundant reporting and analysis processesWalks you through creating impressive dashboards, eye-catching visualizations, and real-world What-If analyses

"Excel Dashboards and Reports, Second Edition" is part technical manual, part analytical guidebook, and exactly what you need to become your organization's dashboard?dynamo

Helping you quickly get up to speed, THE SHELLY CASHMAN SERIES (R) MICROSOFT (R) OFFICE 365 (R) & EXCEL (R) 2021 COMPREHENSIVE 1st edition, includes the latest on Microsoft 365 and Office 2021 features along with enhanced support for Mac users. Its trademark step-by-step, screen-by-screen, project-based approach enables you to expand your understanding of Office applications through hands-on experimentation and critical thinking. Module Learning Objectives are mapped to Microsoft Office Specialist (MOS) certification objectives, reinforcing the critical skills needed for college and career success. Other Ways boxes reveal alternate click paths to achieve a step, while BTW call-outs offer helpful hints as you work through your projects so you can make the most of Microsoft Office tools. In addition, MindTap and SAM (Skills Assessment Manager) online resources help maximize your study time -- and results.

THE GUIDE FOR ANYONE AFRAID TO LEARN STATISTICS & ANALYTICS UPDATED WITH NEW EXAMPLES & EXERCISES This book discusses statistics and analytics using plain language and avoiding mathematical jargon. If you thought you couldn't learn these data analysis subjects because they were too technical or too mathematical, this book is for you! This edition delivers more everyday examples and end-of-chapter exercises and contains updated instructions for using Microsoft Excel. You'll use downloadable data sets and spreadsheet solutions, template-based solutions you can put right to work. Using this book, you will understand the important concepts of statistics and analytics, including learning the basic vocabulary of these subjects. Create tabular and visual summaries and learn to avoid common charting errors Gain experience working with common descriptive statistics measures including the mean, median, and mode; and standard deviation and variance, among others Understand the probability concepts that underlie inferential statistics Learn how to apply hypothesis tests, using Z, t, chi-square, ANOVA, and other techniques Develop skills using regression analysis, the most commonly-used Inferential statistical method Explore results produced by predictive analytics software Choose the right statistical or analytic techniques for any data analysis task Optionally, read the "Equation Blackboards," designed for readers who want to learn about the mathematical foundations of selected methods

Save time and become an Excel wizard with the world's leading Excel macro guide Do you love Excel and all the things you can do with it, but wish you could just work...faster? Excel macros--automated workflows that save you time and energy--might be just what you need. In Excel Macros For Dummies, you'll learn over 70 of the most productive, time-saving macros in less time than it takes to back up the files on your computer! Every chapter in the book gives you practical info and exercises you can put to work immediately, alongside step-by-step instructions and guidance on how to customize Excel to fit your every need. Inside, you'll find: Automations that take your Excel productivity to the next level, and beyond Fully updated macros compatible with the newest version of Excel included in Microsoft 365 Careful explanations of the basics as well as tips for the advanced user With something for everyone, Excel Macros For Dummies is the productivity supercharger you've been waiting for. Grab a copy today!

Turn jumbles of numbers into graphics, insights, and answers with Excel With Microsoft Excel, you can, well, excel at data analysis. And Excel Data Analysis For Dummies can help, with clear and easy explanations of the mountain of features for creating, visualizing, and analyzing data. PivotTables, charts, what-if analysis, statistical functions--it's all in here, with examples and ideas for Excel users of all skill levels. This latest edition covers the most recent updates to Excel and Microsoft 365. You'll beef up your data skills and learn powerful techniques for turning numbers into knowledge. For students, researchers, and business professionals, Excel is the spreadsheet and data application of choice--and Dummies is the best choice for learning how to make those numbers sing. Learn how to use Excel's built-in data analysis features and write your own functions to explore patterns in your data Create striking charts and visualizations, and discover multiple ways to tell the stories hidden in the numbers Clean up large datasets and identify statistical operations that will answer your questions Perform financial calculations, database operations, and more--without leaving Excel Excel Data Analysis For Dummies is the go-to resource for Excel users who are looking for better ways to crunch the numbers.

Updated for Excel 2021 and based on the bestselling editions from previous versions, Excel 2021 / Microsoft 365 Programming by Example is a practical, how-to book on Excel programming, suitable for readers already proficient with the Excel user interface. If you are looking to automate Excel routine tasks, this book will progressively introduce you to programming concepts via numerous illustrated hands-on exercises. More advanced topics are demonstrated via custom projects. From recording and editing a macro and writing VBA code from scratch to programming the Ribbon interface and working with XML documents, this book takes you on a programming journey that will change the way you work with Excel. The book provides information on performing automatic operations on files, folders, and other Microsoft Office applications. It also covers proper use of event procedures, testing and debugging, and guides you through programming more advanced Excel features, such as working with VBA classes and raising your own events in standalone class modules. Includes companion files with source code, hands-on projects, and figures.

Make Excel work for you Excel 2019 All-In-One For Dummies offers eight books in one!! It is completely updated to reflect the major changes Microsoft is making to Office with the 2019 release. From basic Excel functions, such as creating and editing worksheets, to sharing and reviewing worksheets, to editing macros with Visual Basic, it provides you with a broad scope of the most common Excel applications and functions--including formatting worksheets, setting up formulas, protecting worksheets, importing data, charting data, and performing statistical functions. The book covers importing data, building and editing worksheets, creating formulas, generating pivot tables, and performing financial functions, what-if scenarios, database functions, and Web queries. More advanced topics include worksheet sharing and auditing, performing error trapping, building and running macros, charting data, and using Excel in conjunction with Microsoft Power BI (Business Intelligence) to analyze, model, and visualize vast quantities of data from a variety of local and online sources. Get familiar with Worksheet design Find out how to work with charts and graphics Use Excel for data management, analysis, modeling, and visualization Make sense of macros and VBA If you're a new or inexperienced user looking to spend more time on your projects than trying to figure out how to make Excel work for you, this all-encompassing book makes it easy!

For courses in corporate finance or financial management at the undergraduate and graduate level. Excel Modeling in Corporate Finance approaches building and estimating models with Microsoft(r) Excel(r). Students are shown the steps involved in building models, rather than already-completed spreadsheets.

Master business modeling and analysis techniques with Microsoft Excel and transform data into bottom-line results. Award-winning educator Wayne Winston's hands-on, scenario-focused guide helps you use today's Excel to ask the right questions and get accurate, actionable answers. More extensively updated than any previous edition, new coverage ranges from one-click data analysis to STOCKHISTORY, dynamic arrays to Power Query, and includes six new chapters. Practice with over 900 problems, many based on real challenges faced by working analysts. Solve real problems with Microsoft Excel-and build your competitive advantage Quickly transition from Excel basics to sophisticated analytics Use recent Power Query enhancements to connect, combine, and transform data sources more effectively Use the LAMBDA and LAMBDA helper functions to create Custom Functions without VBA Use New Data Types to import data including stock prices, weather, information on geographic areas, universities, movies, and music Build more sophisticated and compelling charts Use the new XLOOKUP function to revolutionize your lookup formulas Master new Dynamic Array formulas that allow you to sort and filter data with formulas and find all UNIQUE entries Illuminate insights from geographic and temporal data with 3D Maps Improve decision-making with probability, Bayes' theorem, and Monte Carlo simulation and scenarios Use Excel trend curves, multiple regression, and exponential smoothing for predictive analytics Use Data Model and Power Pivot to effectively build and use relational data sources inside an Excel workbook

For introductory computer courses on Microsoft Office 2010 or courses in computer concepts with a lab component for Microsoft Office 2010 applications. The goal of the Exploring series has been to move students beyond the point and click, helping them understand the why and how behind each skill. The Exploring series for Office 2010 also enables students to extend the learning beyond the classroom. Students go to college now with a different set of skills than they did five years ago. With this in mind, the Exploring series seeks to move students beyond the basics of the software at a faster pace, without sacrificing coverage of the fundamental skills that everybody needs to know. A lot of learning takes place outside of the classroom, and the Exploring series provides learning tools that students can access anytime, anywhere. The goal of the Exploring series has been to move students beyond the point and click, helping them understand the why and how behind each skill.

For introductory courses in Engineering and Computer Science. Teach your students to program and design user interfaces using Excel 2007. Introduction to VBA for Excel is an introductory text that is designed to instruct engineering and science students on how to develop programs using VBA within the Microsoft Excel environment. It is written for students at all levels and does not assume any previous programming experience.

Turn your financial data into insightful decisions with this straightforward guide to financial modeling with Excel Interested in learning how to build practical financial models and forecasts but concerned that you don't have the math skills or technical know-how? We've got you covered! Financial decision-making has never been easier than with Financial Modeling in Excel For Dummies. Whether you work at a mom-and-pop retail store or a multinational corporation, you can learn how to build budgets, project your profits into the future, model capital depreciation, value your assets, and more. You'll learn by doing as this book walks you through practical, hands-on exercises to help you build powerful models using just a regular version of Excel, which you've probably already got on your PC. You'll also: Master the tools and strategies that help you draw insights from numbers and data you've already got Build a successful financial model from scratch, or work with and modify an existing one to your liking Create new and unexpected business strategies with the ideas and conclusions you generate with scenario analysis Don't go buying specialized software or hiring that expensive consultant when you don't need either one. If you've got this book and a working version of Microsoft Excel, you've got all the tools you need to build sophisticated and useful financial models in no time!

Risks are everywhere in the business world. "Mastering Risk Modelling" provides the busy financial manager with useful tips andpractical templates for assessing, applying and modelling risk and uncertainty in Excel. The book is designed specifically to be of help to you if you don't have time to start from scratch - it will improve your abilities in Excel and give you a library of basic examples that you can use as a basis for further development.

It covers:

- Review of model design

- Risk and uncertainty

- Credit risk

- Project finance

- Financial analysis

- Valuation

- Options

- Bonds

- Equities

- Value at risk

- Simulation

This second edition contains brand new chapters:

- Revised models

- More material on credit risk modelling e.g. portfolios, bankruptcy models

- Shows dual 2003/2007 Excel key strokes

- More theory especially on statistics in Excel

- Basic statistics in Excel - tools and methods

- Capacity to borrow and repay

- Finding optimum mix of risk and return

- Fixed income risk models

- Visual Basic approach