<div class="raw-html-embed"> Sonderangebot Stämpflis juristische Lehrbücher: Bis Ende November profitieren Sie von 20% Rabatt auf folgende <a href="/aktion-sjl-und-pds">Lehr- und Praxisbücher</a>.</div>

NL_Doormat: Hintergrundfarbe des Newsletter Banners unten in der Doormat. Mit # eingeben z.B. #1405BE

NL_Doormat: Verlinkung zur Newsletter Seite

Über uns

À propos de nous

Zahlung und Lieferung

Paiement et livraison

Nachhaltigkeit

Durabilité

Open Access

Datenschutz

Protection des données

Karriere

Carrière

Impressum

Mentions légales

LEXIA

LEXIA Arbeitsrecht

Was ist LEXIA?

C'est quoi LEXIA ?

LEXIA Familienrecht

Zeitschriften

Revues

recht

Pflegerecht

ZBJV

forumpoenale

ZStrR

Anwaltsrevue

Revue de l'avocat

RSAS

FamPra.ch

ASYL

Life Science Recht

BlAR

Sachbuch

Livres spécialisés

LOKI

Semaphor

Fokusthemen

Thèmes principaux

Thema

Recht studieren

Arbeitsrecht

Droit du travail

Studium

Études

Familienrecht

Droit de la famille

Sozialversicherungsrecht

Droit des assurances sociales

Strafrecht

Droit pénal

Publikationen

Publications

Literatur

Onlinemodule LEXIA

Modules en ligne LEXIA

Bücher

Livres

Buchreihen

Collections

Datenbanken

recht.ch

Studienliteratur

Littérature pour les études

Services

Dienstleistungen für

Corporate Books

Publishing Lösungen

Aktuelles

Kanzleien und Behörden

Professionnels

Corporate Publishing

Content solutions

Buchhandlungen

Librairies

Veranstaltungen

Événements

Presse

Dozierende

Enseignants

Studierende

Étudiants

Inserierende

Annonceurs

Newsletter

Blog

Autorinnen/Autoren

Auteurs

Unsere Schreibenden

Hilfe

Unsere Autorinnen und Autoren

Liste

Autorenlounge

Espace des auteurs

Bei uns publizieren

Publier chez nous

Autorenstimmen

Témoignages

Verlag

Éditions

Themen

Mehr wissen

Mitarbeitende

Collaborateurs

Geschichte

Histoire

Vision und Mission

Vision et mission

Unser Magazin

Notre magazine

Unternehmenskultur

Culture d'entreprise

Partner

Partenaires

Kontakt

Contact

Shop

Schweizer Recht

Ausländisches Recht

Über unseren Shop

Neuerscheinungen 2024

Nouveautés 2024

Infos, Tipps und Tricks

Infos, conseils et astuces

Vorankündigungen 2024/2025

Préavis 2024/2025

Nach Rechtsgebiet

Par domaine juridique

Kommentare

Commentaires

Alexander M: Excel 2019 Power
Programming with VBA

Excel 2019 Power Programming with VBA

Tech Today

Add to your Excel toolkit by learning to implement advanced AI and automation techniques for data analysis As technology evolves all around us, professionals must keep learning new skills just to keep up with the heightened expectations of our leaders. That's especially true when it comes to artificial intelligence-related advancements in the field of data analysis. In Excel Power Tools: Unlocking the Power of AI, Python, and Power Automate, veteran analytics educator George Mount delivers a practical guide for everyday Excel users seeking to leverage the software's advanced features to import, clean, and analyze data. You'll learn to automate your data analysis and discover how to use power user features like pattern recognition, forecasting, and fuzzy matching. You'll: <ul> <li>Develop a solid understanding of how to integrate AI into your work without radically changing the tools you use every day</li> <li>Learn to use Python to automate routine data tasks and become more productive and efficient</li> <li>Find real-world examples of AI integration that illustrate the simple and accessible concepts discussed in the book</li> </ul> Perfect for professionals in routine reporting roles, including accountants, data analysts, financial analysts, marketing coordinators, controllers, and operations analysts, Excel Power Tools is also a must-read for data science professionals and other technical experts who wish to unlock the full capabilities of Excel.

Unlocking the Power of AI, Python, and Power Automate

Excel Power Tools

Unlock the power of Excel with a step-by-step roadmap to its formulas and functions

There's a Swiss Army knife in your digital toolbox that can multiply your productivity and make you the smartest guy or gal in almost any room. It's called Microsoft Excel.

If you're like most people, you've barely scratched the surface of what this powerful tool's hundreds of built-in functions can do. But with a little help from Excel Formulas &amp; Functions For Dummies, you'll soon be organizing, analyzing, and interpreting data like a pro.

For those who don't know the difference between a spreadsheet and a bedsheet, the book gets you up to speed with formula and function basics first. But you can also skip ahead to the fancy stuff and learn about working with probabilities, significance tests, and lookup functions.

This easy-to-use Excel formulas and functions survival guide shows you how to:
* Work with financial functions like PMT, PPMT, NPER, RATE, and PV
* Calculate mean, median, mode, standard deviation, and many more statistical functions
* Troubleshoot formulas for common errors and validate your data to avoid mistakes
* Work with dates, times, logic operators, conditions, and basic and advanced mathematical functions

You don't need a degree in data science or advanced mathematics to take advantage of the full functionality and flexibility of Microsoft Excel. Let Excel Formulas &amp; Functions For Dummies show you how to transform this unassuming program into the most useful tool in your toolbox.

Unlock the power of Excel with a step-by-step roadmap to its formulas and functions

There's a Swiss Army knife in your digital toolbox that can multiply your productivity and make you the smartest guy or gal in almost any room. It's called Microsoft Excel.

If you're like most people, you've barely scratched the surface of what this powerful tool's hundreds of built-in functions can do. But with a little help from Excel Formulas &amp; Functions For Dummies, you'll soon be organizing, analyzing, and interpreting data like a pro.

For those who don't know the difference between a spreadsheet and a bedsheet, the book gets you up to speed with formula and function basics first. But you can also skip ahead to the fancy stuff and learn about working with probabilities, significance tests, and lookup functions.

This easy-to-use Excel formulas and functions survival guide shows you how to:
* Work with financial functions like PMT, PPMT, NPER, RATE, and PV
* Calculate mean, median, mode, standard deviation, and many more statistical functions
* Troubleshoot formulas for common errors and validate your data to avoid mistakes
* Work with dates, times, logic operators, conditions, and basic and advanced mathematical functions

You don't need a degree in data science or advanced mathematics to take advantage of the full functionality and flexibility of Microsoft Excel. Let Excel Formulas &amp; Functions For Dummies show you how to transform this unassuming program into the most useful tool in your toolbox.

Excel Formulas & Functions For Dummies

Wiley Corporate F&A

Praise for Advanced Excel Reporting for Management Accountants "Neale Blackwood, a long-time spreadsheet user and trainer, shares his knowledge of Excel reporting in a manner that's both thorough and easy to follow. He starts with the basics, and gradually introduces key topics that utilize commonly accepted best practices. This book will make your Excel reporting more useful and less prone to errors." --John Walkenbach, Author of Excel 2013 Bible "This book is essential reading for anyone involved in Excel reporting. It provides great insights about not only the most relevant and useful functions of Excel for reporting and management accounting, but also how to apply these in practical ways that will improve your thinking and make your reporting more efficient. Neale knows more about management accounting and Excel reporting than anyone I know, and this book allows you to benefit from his experience so you can avoid the pitfalls and dramatically improve your Excel reports." --Jeff Robson, CEO &amp; Principal Business Analyst, Access Analytic "Neale has brilliantly applied his considerable experience and expertise in writing this book. With clear descriptions and straightforward analogies, he gets inside the mind of the reporting analyst. With useful guidance on Excel reporting best practices, the reader does not waste time on unnecessary features but instead is guided to invaluable time-saving techniques. By applying the simple yet effective methodology described in this comprehensive book, even an experienced management reporting analyst will improve the efficiency, integrity, and robustness of their reporting tools. Definitely a career-booster!" --Danielle Stein Fairhurst, Financial Modelling Specialist &amp; Presenter, Plum Solutions "Neale is very well known for his practical Excel skills and knowledge. His new book, Advanced Excel Reporting for Management Accountants, is highly recommended and will be useful to both accounting students and professionals alike." --William Beattie, CPA, Business &amp; Finance Analyst "This book is chock-full of well-explained good ideas. With hundreds of tips, even if you simply choose any three to consistently implement, your management reports (and all your spreadsheets in general) will be greatly improved. Apply more than three and your work will significantly reduce the likelihood of both qualitative and quantitative errors. Although the book uses the title 'Advanced, ' the name relates more to the outputs than the user techniques; the language is approachable, and the book builds through from improving Excel program usability to improving the Excel spreadsheets. A great go-to manual to keep and re-read time and again." --Eve Blackall, Smart Accounting - the Science of Business Success

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.

Advanced Excel Reporting for Management Accountants

Missing Manuals

Fast-paced and easy to use, this new book teaches you the basics of Excel 2007 so you can start using the program right away. This concise guide shows readers how to work with Excel's most useful features and its completely redesigned interface. With clear explanations, step-by-step instructions, lots of illustrations, and plenty of timesaving advice, Excel 2007 for Starters: The Missing Manual will quickly teach you to: Build spreadsheets Add and format information Print reports Create charts and graphics Use basic formulas and functions and more &gt;Unfortunately, Microsoft's documentation is as scant as ever, so even if you find the features you need, you still may not know what to do with them. But with this book, you can breeze through the new user interface and its timesaving features in no time. Excel 2007 for Starters: The Missing Manual is the perfect primer for small businesses with no techie to turn to, as well as those who want to organize household and office information.

Aims to teach the basics of Excel 2007. This book helps the readers learn to build spreadsheets, add and format information, print reports, create charts and graphics, and use basic formulas and functions.

Excel 2007 for Starters

Interactive Technologies

Prototyping is a key step in the development of successful products. Yet budgetary restrictions, deadlines, and lack of access to sophisticated tools often lead to sloppy, ineffective prototyping. Designers need efficient visualization tools that quickly communicate ideas, and help improve the realization of their ideas. Effective Prototyping for Excel offers just that by illustrating how anyone can use basic Excel skills to create prototypes. Excel is available on virtually every desktop, and most professionals are proficient with at least its basic functionality. This book offers step-by-step guidance of how to see a prototyping project through from start to finish, in the context of collaborative teams and respective work environment. A range of software design problems and business demands are solved as practical examples complemented by full color illustrations, offering the a fast, cost-effective and reliable tool for prototyping.

A Practical Handbook for Developers and Designers

Effective Prototyping with Excel

Statistically speaking, Excel® does it all Data can tell you interesting things, if you know how to ask. Statistical Analysis with&nbsp;Excel® For Dummies will coach you through formulating the right questions. Create graphs, calculate means and medians, and whip up some conclusions with analysis of variance, regression analysis, and more. Then, when you're feeling lucky, dive into probability and modeling. We make it all come to life with step-by-step guidance, downloadable spreadsheets, and everything you need to Excel in stats. Inside... <ul><li>Updated for Microsoft 365®</li> <li> New-logistic regression</li> <li> Creating simulations</li> <li> Organizing data</li> <li> Visualizing data with charts</li> <li> Confidence intervals, sampling distributions, t-tests, and more</li> <li> Non-parametric statistics</li></ul>

Become a stats superstar by using Excel to reveal the powerful secrets of statistics

Microsoft Excel offers numerous possibilities for statistical analysis--and you don't have to be a math wizard to unlock them. In Statistical Analysis with Excel For Dummies, fully updated for the 2021 version of Excel, you'll hit the ground running with straightforward techniques and practical guidance to unlock the power of statistics in Excel.

Bypass unnecessary jargon and skip right to mastering formulas, functions, charts, probabilities, distributions, and correlations. Written for professionals and students without a background in statistics or math, you'll learn to create, interpret, and translate statistics--and have fun doing it!

In this book you'll find out how to:
* Understand, describe, and summarize any kind of data, from sports stats to sales figures
* Confidently draw conclusions from your analyses, make accurate predictions, and calculate correlations
* Model the probabilities of future outcomes based on past data
* Perform statistical analysis on any platform: Windows, Mac, or iPad
* Access additional resources and practice templates through Dummies.com

For anyone who's ever wanted to unleash the full potential of statistical analysis in Excel--and impress your colleagues or classmates along the way--Statistical Analysis with Excel For Dummies walks you through the foundational concepts of analyzing statistics and the step-by-step methods you use to apply them.

Statistical Analysis with Excel For Dummies

Wiley Finance

Economics / Investments &amp; Securities

Praise for Reverse Engineering Deals on Wall Street with Microsoft Excel

"Allman has written an excellent sequel to his first book Modeling Structured Finance Cash Flows with Microsoft Excel, providing a simple guide on how to deconstruct cash flows through modeling and understanding the collateral by analyzing the prospectus. Whether you are new to the structured finance industry or steeped in structured financing-this book is a must-read."
-Ralph Armenta, PMI Mortgage Insurance/Structured Transactions

"The credit crisis has shown that more financial institutions and analysts need to be able to reverse-engineer structured finance deals to assess their values and risks for themselves. Keith Allman has produced a thorough guide for creating reverse-engineered models that both beginners and experienced analysts will find invaluable."
-Chandan Sengupta, author of Financial Modeling Using Excel and VBA

A serious source of information for those looking to reverse-engineer business deals

How does Wall Street keep track of the competition? They reverse-engineer deals by taking a prospectus or term sheet and recreating a model from it. The skills involved in this task are sophisticated, but are important to understand-especially in today's dynamic business environment.

In this practical resource, financial professional Keith Allman demystifies the process by interpreting complicated legal terminology and clearly showing how it can be organized into a dynamic model. Step by step, Allman walks you through this endeavor with textual excerpts from the prospectus and details how it directly transfers to a model. Each chapter begins with a discussion of concepts with exact references to an example prospectus, followed by a section called "Model Builder," in which Allman translates the theory into a fully functioning model for the example deal. In addition, the companion CD-ROM features all of the modeling exercises, as well as a final version of the model that is outlined in the text.

A serious source of information for those looking to reverse engineer business deals  It's clear from the current turbulence on Wall Street that the inner workings of its most complex transactions are poorly understood. Wall Street deals parse risk using intricate legal terminology that is difficult to translate into an analytical model.

A Step-by-Step Guide

Reverse Engineering Deals on Wall Street with Microsoft Excel, + Website

This practical guide teaches analysts a useful subset of Excel skills that will enable them to access and interpret financial information--without any prior programming experience.ence.

This practical guide teaches analysts a useful subset of Excel skills that will enable them to access and interpret financial information—without any prior programming experience.

A Practical Guide to Technology for Equity and Fixed Income Analysts

Unlocking Financial Data

Do you use Excel for simple lists, but get confused and frustrated when it comes to actually doing something useful with all that data? Stop tearing your hair out: Head First Excel helps you painlessly move from spreadsheet dabbler to savvy user. Whether you're completely new to Excel or an experienced user looking to make the program work better for you, this book will help you incorporate Excel into every aspect of your workflow, from a scratch pad for data-based brainstorming to exploratory analysis with PivotTables, optimizing outcomes with Goal Seek, and presenting your conclusions with sophisticated data visualizations. * Organize and clearly present information in a spreadsheet * Make calculations across a number of worksheets * Change your point of view with sorting, zooming, and filtering * Manipulate numerical data to extract and use just what you need * Leverage Excel as a grid-based layout program * Write formulas for optimal functionality * Nest formulas for more complex operations * Create sophisticated data visualizations with charts and graphs * Use Goal Seek to optimize possible outcomes based on different assumptions * Create summaries from large data sets for exploratory data analysis with PivotTables We think your time is too valuable to waste struggling with new concepts. Using the latest research in cognitive science and learning theory to craft a multi-sensory learning experience, Head First Excel uses a visually rich format designed for the way your brain works, rather than a text-heavy approach that will put you to sleep.

Whether you're completely new to Excel, or an experienced user looking to make the program work better for you, this book helps you incorporate Excel into the various aspects of your workflow, from a scratch pad for data-based brainstorming, to exploratory analysis with PivotTables, and presenting your conclusions with data visualizations.

A Learner's Guide to Spreadsheets

Head First Excel

Hacks

Millions of users create and share Excel spreadsheets every day, but few go deeply enough to learn the techniques that will make their work much easier. There are many ways to take advantage of Excel's advanced capabilities without spending hours on advanced study. Excel Hacks provides more than 130 hacks -- clever tools, tips and techniques -- that will leapfrog your work beyond the ordinary. Now expanded to include Excel 2007, this resourceful, roll-up-your-sleeves guide gives you little known "backdoor" tricks for several Excel versions using different platforms and external applications. Think of this book as a toolbox. When a need arises or a problem occurs, you can simply use the right tool for the job. Hacks are grouped into chapters so you can find what you need quickly, including ways to: <ul> <li>Reduce workbook and worksheet frustration -- manage how users interact with worksheets, find and highlight information, and deal with debris and corruption.</li> <li>Analyze and manage data -- extend and automate these features, moving beyond the limited tasks they were designed to perform.</li> <li>Hack names -- learn not only how to name cells and ranges, but also how to create names that adapt to the data in your spreadsheet.</li> <li>Get the most out of PivotTables -- avoid the problems that make them frustrating and learn how to extend them.</li> <li>Create customized charts -- tweak and combine Excel's built-in charting capabilities.</li> <li>Hack formulas and functions -- subjects range from moving formulas around to dealing with datatype issues to improving recalculation time.</li> <li>Make the most of macros -- including ways to manage them and use them to extend other features.</li> <li>Use the enhanced capabilities of Microsoft Office 2007 to combine Excel with Word, Access, and Outlook.</li> </ul> You can either browse through the book or read it from cover to cover, studying the procedures and scripts to learn more about Excel. However you use it, Excel Hacks will help you increase productivity and give you hours of "hacking" enjoyment along the way.

Millions of users create and share Excel spreadsheets every day, but few go deeply enough to learn the techniques that can make their work much easier. this work provides more than 130 hacks - clever tools, tips and techniques - that can leapfrog your work beyond the ordinary. It also includes ways to create customized charts.

Excel Hacks

Electronic spreadsheet analysis has become part of the everyday work of researchers in all areas of engineering and science. Microsoft Excel, as the industry standard spreadsheet, has a range of scientific and engineering functions that can be used for modeling, analysis, and presentation of technical problems. This text provides a practical and straightforward guide to using these functions of Microsoft Excel to their full potential, guiding the reader from basic principles through to the more complicated areas such as formulae, charts, curve-fitting, equation solving, integration, macros, statistical functions, and reporting/formatting results.

Electronic spreadsheet analysis has become part of the work in areas of engineering and science. Microsoft Excel, as the industry standard spreadsheet, has a range of scientific functions that can be utilized for the modeling, analysis and presentation of quantitative data. This text provides a guide to using these functions of Excel Microsoft.

A Guide to Microsoft Excel 2007 for Scientists and Engineers

Deriving business value from analytics is a challenging process. Turning data into information requires a business analyst who is adept at multiple technologies including databases, programming tools, and commercial analytics tools. This practical guide shows programmers who understand analysis concepts how to build the skills necessary to achieve business value. Author Deanne Larson, data science practitioner and academic, helps you bridge the technical and business worlds to meet these requirements. You'll focus on developing these skills with R and Python using real-world examples. You'll also learn how to leverage methodologies for successful delivery. Learning methodology combined with open source tools is key to delivering successful business analytics and value. This book shows you how to: <ul> <li>Apply business analytics methodologies to achieve successful results </li><li>Cleanse and transform data using R and Python </li><li>Use R and Python to complete exploratory data analysis </li><li>Create predictive models to solve business problems in R and Python </li><li>Use Python, R, and business analytics tools to handle large volumes of data </li><li>Commit code to GitHub to collaborate with data engineers and data scientists </li><li>Measure success in business analytics </li></ul>

Increasing the Value of Your Data with Python and R

Modern Business Analytics

Excel 2019 Power Programming with VBA

Bibliografische Angaben

Schlagworte

Bibliografische Angaben

Schlagworte

Weitere Titel zum Thema