|
Books > Computing & IT > Computer software packages > Spreadsheet software
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
Your personal, hands-on guide to the latest and most useful
features in Microsoft Excel 365 Excel 365 is Microsoft's latest
cloud-based version of its world-famous spreadsheet app. Powerful
and user-friendly, it's an ideal solution for businesses and people
looking to make sense of--and draw intelligence from--their data.
The Excel 365 Bible carries over the best content from the
best-selling Excel 2019 Bible while reflecting how a new generation
uses Excel in Excel 365. The authoring team with their decades of
Excel and business intelligence experience and recognition from the
Excel community as Excel MVPs delivers an accessible and
authoritative roadmap to Excel 365. Interested in the basics?
You'll learn to create spreadsheets and workbooks and navigate the
user interface. If you're ready for more advanced topics you can
skip right to the material on creating visualizations, crafting
custom functions, and using Visual Basic for Applications to script
automations. You'll also get: Over 900 pages of powerful tips,
tricks, and strategies to unlock the full potential of Microsoft
Excel 365 Guidance on how to import, manage, and analyze large
amounts of data Advice on how to craft predictions and "What-If
Analyses" based on data you already have Perfect for anyone new to
Excel, as well as experts and advanced users, the Excel 365 Bible
is your comprehensive, go-to guide for everything you need to know
about the world's most popular, easy-to-use spreadsheet software.
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.
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!
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.
|
|