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.

Step up your Excel skills with our 6-page laminated guide focusing on tips and tricks for using data efficiently while ensuring data quality. Curtis Frye, author of multiple books on Excel, creator of many Lynda.com videos and an experienced corporate trainer used his experience and knowledge to cover the most relevant functions for users at different levels. This is the second in the Excel 2016 series. Suggested uses: Workplace -- Kept conveniently at your desk for easy reference; Company Training -- reduce help-desk calls and keep productivity flowing for a team or for your entire company; Students/Teachers/Parents -- help for classroom or homework; College Professors/Students -- offers a range of guides for different levels.

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!

"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

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

"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!