Ken Bluttman – författare

Turn Excel into an unstoppable data-and number-crunching machine Microsoft Excel is the Swiss Army knife of apps. With over 470 built-in functions and countless custom formulas, the program can help make you the smartest guy or gal in any room. And now that it's been supercharged with Copilot—Microsoft's AI-powered helper—it's even easier to produce accurate and useful results anywhere, anytime. Best of all, it doesn't take an advanced degree in mathematics or data science to take full advantage of Excel's functionality. Just grab a copy of this latest edition of Excel Formulas & Functions For Dummies and get a flying start on the Excel functions and formulas that power up your data superpowers. With this book, you'll: Learn to create and use hundreds of formulas and functions, correct common mistakes, and make calculationsDiscover how to analyze data and calculate statistics, and even work with dates and timesUse the ever-evolving, AI-powered Copilot to expand Excel's functionality and make it easier to useGet ready to transform your copy of Excel at home or at work into an unstoppable toolkit equipped for almost any occasion. Grab a copy of Excel Formulas & Functions For Dummies today!

Develop cross-platform multimedia applications with HTML5

Now you can create rich, interactive content in the browser and deploy it across all platforms. HTML5 Multimedia Developer''s Guide shows you how. You''ll learn to use the revolutionary new features of HTML5, including the native audio, video, and drawing elements that eliminate the need for third-party plug-ins. New tags, the simplified doctype, local data storage, drag-and-drop, and geolocation are also covered. Detailed code examples illustrate the techniques discussed. By the end of the book, you''ll be able to develop amazing multimedia applications and websites with HTML5.

Use canvas for drawing, animation, effects, and eventsCreate and view videos with the native video elementAdd and play audio files with the native audio elementTake advantage of local data storage functionsApply drag-and-drop functionalityBuild location-aware web pages with the geolocation propertyDevelop well-structured pages using the new semantic layout tagsAdd functionality to web forms with the new form objectsLearn about new CSS3 properties and enhancementsUse the editable content and offline files featuresWork with JavaScript and other technologies

Discover everything you want to know about Photoshop Elements 10 in this easy to use guide, from the most essential tasks that you’ll want to perform, to solving the most common problems you’ll encounter.

 

Photoshop Elements 10  In Simple Stepscovers every practical aspect of using Photoshop Elements on your PC or laptop; from understanding the user interface and essential tools, to basic retouching and adjusting of photographs, to advanced techniques using filters, layers and special effects, through to organizing and sharing your photographs. This book is filled with easy to understand practical tasks that will help you to achieve immediate results.

 

 

This series of vibrant books will teach you exactly what you need to know using

A friendly, visual approach

Easy-to-understand language

Practical hands-on tasks

Full-colour large format screenshots

 

 

To build your confidence and help you to get the most out of your computer, practical hints, tips and shortcuts feature on every page:

 

§         ALERT!– Explains and provides practical solutions to the most commonly 

                       encountered problems

§         HOT TIPS– Time and effort saving shortcuts

§         SEE ALSO… -  Points you to other related tasks and information

§         DID YOU KNOW?  – Additional features to explore

§         WHAT DOES THIS MEAN? – Jargon and technical terms explained in plain English             

As part of the Microsoft Office suite, Access has become the industry's leading desktop database management program for organizing, accessing, and sharing information. But taking advantage of this product to build increasingly complex Access applications requires something more than your typical how-to book. What it calls for is Access Hacks from O'Reilly. This valuable guide provides direct, hands-on solutions that can help relieve the frustrations felt by users struggling to master the program's various complexities. For experienced users, Access Hacks offers a unique collection of proven techniques and tools that enable them to take their database skills and productivity to the next level. For Access beginners, it helps them acquire a firm grasp of the program's most productive features. A smart collection of insider tips and tricks, Access Hacks covers all of the program's finer points. Among the multitude of topics addressed, it shows users how to: work with Access in multi-user environments utilize SQL queries work with external data and programs integrate Access with third-party products Just imagine: a learning process without the angst.Well, Access Hacks delivers it with ease, thanks to these down-and-dirty techniques not collected together anywhere else. Part of O'Reilly's best-selling Hacks series, Access Hacks is based on author Ken Bluttman's two decades of real-world experience in database programming and business application building. It's because of his vast experiences that the book is able to offer such a deep understanding of the program's expanding possibilities.

If you have large quantities of data in a Microsoft Access database, and need to study that data in depth, this book is a data cruncher's dream. "Access Data Analysis Cookbook" offers practical recipes to solve a variety of common problems that users have with extracting Access data and performing calculations on it. Each recipe includes a discussion on how and why the solution works. Whether you use Access 2007 or an earlier version, this book will teach you new methods to query data, different ways to move data in and out of Access, how to calculate answers to financial and investment issues, and more. Learn how to apply statistics to summarize business information, how to jump beyond SQL by manipulating data with VBA, how to process dates and times, and even how to reach into the Excel data analysis toolkit.The recipes demonstrate ways to: develop basic and sophisticated queries; apply aggregate functions, custom functions, regular expressions, and crosstabs; apply queries to perform non-passive activities such as inserting, updating, and deleting data; create and manipulate tables and queries programmatically; manage text-based data, including methods to isolate parts of a string and ways to work with numbers that are stored as text; use arrays, read and write to the Windows registry, encrypt data, and use transaction processing; and, use the FileSystemObject, use XML with XSLT, communicate with SQL Server, and exchange data with other Office products. They also demonstrate ways to: find answers from time-based data, such as how to add time, count elapsed time, work with leap years, and how to manage time zones in your calculations; deal with business and finance problems, including methods for calculating depreciation, loan paybacks, and Return on Investment (ROI); and, explore statistical techniques, such as frequency, variance, kurtosis, linear regression, combinations and permutations."Access Data Analysis Cookbook" is a one-stop-shop for extracting nuggets of valuable information from your database, and anyone with Access experience will benefit from these tips and techniques, including seasoned developers. If you want to use your data, and not just store it, you'll find this guide indispensable.

If you have large quantities of data in a Microsoft Access database, and need to study that data in depth, this book is a data cruncher''s dream. Access Data Analysis Cookbook offers practical recipes to solve a variety of common problems that users have with extracting Access data and performing calculations on it. Each recipe includes a discussion on how and why the solution works.Whether you use Access 2007 or an earlier version, this book will teach you new methods to query data, different ways to move data in and out of Access, how to calculate answers to financial and investment issues, and more. Learn how to apply statistics to summarize business information, how to jump beyond SQL by manipulating data with VBA, how to process dates and times, and even how to reach into the Excel data analysis toolkit. Recipes demonstrate ways to:

Develop basic and sophisticated queriesApply aggregate functions, custom functions, regular expressions, and crosstabsApply queries to perform non-passive activities such as inserting, updating, and deleting dataCreate and manipulate tables and queries programmaticallyManage text-based data, including methods to isolate parts of a string and ways to work with numbers that are stored as textUse arrays, read and write to the Windows registry, encrypt data, and use transaction processingUse the FileSystemObject, use XML with XSLT, communicate with SQL Server, and exchange data with other Office productsFind answers from time-based data, such as how to add time, count elapsed time, work with leap years, and how to manage time zones in your calculationsDeal with business and finance problems, including methods for calculating depreciation, loan paybacks, and Return on Investment (ROI)Explore statistical techniques, such as frequency, variance, kurtosis, linear regression, combinations and permutationsAccess Data Analysis Cookbook is a one-stop-shop for extracting nuggets of valuable information from your database, and anyone with Access experience will benefit from these tips and techniques, including seasoned developers. If you want to use your data, and not just store it, you''ll find this guide indispensable.

As part of the Microsoft Office suite, Access has become the industry''s leading desktop database management program for organizing, accessing, and sharing information. But taking advantage of this product to build increasingly complex Access applications requires something more than your typical how-to book. What it calls for is Access Hacks from O''Reilly.This valuable guide provides direct, hands-on solutions that can help relieve the frustrations felt by users struggling to master the program''s various complexities. For experienced users, Access Hacks offers a unique collection of proven techniques and tools that enable them to take their database skills and productivity to the next level. For Access beginners, it helps them acquire a firm grasp of the program''s most productive features.A smart collection of insider tips and tricks, Access Hacks covers all of the program''s finer points. Among the multitude of topics addressed, it shows users how to:

work with Access in multi-user environmentsutilize SQL querieswork with external data and programsintegrate Access with third-party productsJust imagine: a learning process without the angst. Well, Access Hacks delivers it with ease, thanks to these down-and-dirty techniques not collected together anywhere else.Part of O''Reilly''s best-selling Hacks series, Access Hacks is based on author Ken Bluttman''s two decades of real-world experience in database programming and business application building. It''s because of his vast experiences that the book is able to offer such a deep understanding of the program''s expanding possibilities.

As part of the Microsoft Office suite, Access has become the industry''s leading desktop database management program for organizing, accessing, and sharing information. But taking advantage of this product to build increasingly complex Access applications requires something more than your typical how-to book. What it calls for is Access Hacks from O''Reilly.This valuable guide provides direct, hands-on solutions that can help relieve the frustrations felt by users struggling to master the program''s various complexities. For experienced users, Access Hacks offers a unique collection of proven techniques and tools that enable them to take their database skills and productivity to the next level. For Access beginners, it helps them acquire a firm grasp of the program''s most productive features.A smart collection of insider tips and tricks, Access Hacks covers all of the program''s finer points. Among the multitude of topics addressed, it shows users how to:

work with Access in multi-user environmentsutilize SQL querieswork with external data and programsintegrate Access with third-party productsJust imagine: a learning process without the angst. Well, Access Hacks delivers it with ease, thanks to these down-and-dirty techniques not collected together anywhere else.Part of O''Reilly''s best-selling Hacks series, Access Hacks is based on author Ken Bluttman''s two decades of real-world experience in database programming and business application building. It''s because of his vast experiences that the book is able to offer such a deep understanding of the program''s expanding possibilities.

If you have large quantities of data in a Microsoft Access database, and need to study that data in depth, this book is a data cruncher''s dream. Access Data Analysis Cookbook offers practical recipes to solve a variety of common problems that users have with extracting Access data and performing calculations on it. Each recipe includes a discussion on how and why the solution works.Whether you use Access 2007 or an earlier version, this book will teach you new methods to query data, different ways to move data in and out of Access, how to calculate answers to financial and investment issues, and more. Learn how to apply statistics to summarize business information, how to jump beyond SQL by manipulating data with VBA, how to process dates and times, and even how to reach into the Excel data analysis toolkit. Recipes demonstrate ways to:

Develop basic and sophisticated queriesApply aggregate functions, custom functions, regular expressions, and crosstabsApply queries to perform non-passive activities such as inserting, updating, and deleting dataCreate and manipulate tables and queries programmaticallyManage text-based data, including methods to isolate parts of a string and ways to work with numbers that are stored as textUse arrays, read and write to the Windows registry, encrypt data, and use transaction processingUse the FileSystemObject, use XML with XSLT, communicate with SQL Server, and exchange data with other Office productsFind answers from time-based data, such as how to add time, count elapsed time, work with leap years, and how to manage time zones in your calculationsDeal with business and finance problems, including methods for calculating depreciation, loan paybacks, and Return on Investment (ROI)Explore statistical techniques, such as frequency, variance, kurtosis, linear regression, combinations and permutationsAccess Data Analysis Cookbook is a one-stop-shop for extracting nuggets of valuable information from your database, and anyone with Access experience will benefit from these tips and techniques, including seasoned developers. If you want to use your data, and not just store it, you''ll find this guide indispensable.

Turn Excel into an unstoppable data-and number-crunching machine

Microsoft Excel is the Swiss Army knife of apps. With over 470 built-in functions and countless custom formulas, the program can help make you the smartest guy or gal in any room. And now that it''s been supercharged with Copilot—Microsoft''s AI-powered helper—it''s even easier to produce accurate and useful results anywhere, anytime.

Best of all, it doesn''t take an advanced degree in mathematics or data science to take full advantage of Excel''s functionality. Just grab a copy of this latest edition of Excel Formulas & Functions For Dummies and get a flying start on the Excel functions and formulas that power up your data superpowers. With this book, you''ll:

Learn to create and use hundreds of formulas and functions, correct common mistakes, and make calculations Discover how to analyze data and calculate statistics, and even work with dates and times Use the ever-evolving, AI-powered Copilot to expand Excel''s functionality and make it easier to use

Get ready to transform your copy of Excel at home or at work into an unstoppable toolkit equipped for almost any occasion. Grab a copy of Excel Formulas & Functions For Dummies today!

Turn Excel into an unstoppable data-and number-crunching machine

Microsoft Excel is the Swiss Army knife of apps. With over 470 built-in functions and countless custom formulas, the program can help make you the smartest guy or gal in any room. And now that it''s been supercharged with Copilot—Microsoft''s AI-powered helper—it''s even easier to produce accurate and useful results anywhere, anytime.

Best of all, it doesn''t take an advanced degree in mathematics or data science to take full advantage of Excel''s functionality. Just grab a copy of this latest edition of Excel Formulas & Functions For Dummies and get a flying start on the Excel functions and formulas that power up your data superpowers. With this book, you''ll:

Learn to create and use hundreds of formulas and functions, correct common mistakes, and make calculations Discover how to analyze data and calculate statistics, and even work with dates and times Use the ever-evolving, AI-powered Copilot to expand Excel''s functionality and make it easier to use

Get ready to transform your copy of Excel at home or at work into an unstoppable toolkit equipped for almost any occasion. Grab a copy of Excel Formulas & Functions For Dummies today!

Get into the nitty gritty of Excel, the all-important spreadsheet tool Microsoft 365 Excel All-in-One For Dummies offers an all-new way to tackle data in Excel. Start with the basics of inputting, formatting, and organizing data and work your way to pro techniques that help with any career field or reason for using the app. Gain the skills to apply advanced formulas and functions, create stunning data visualizations, build dashboards and reports, and automate your spreadsheets. You'll also get a glimpse into how AI tools can boost your work. Eight mini-books come together in this expanded Excel reference. With Microsoft 365 Excel All-in-One For Dummies, you'll soon be the go-to Excel guru in your office or school. Learn the basics of Excel—organizing data, performing calculations, and formatting your spreadsheet.Use functions to handle advanced math and financial analysis.Create data visualizations and summaries to help tell your storyApply basic programming skills using VBAThis book is perfect for professionals or students who need to up their Excel game with insight from pros who know the classic spreadsheet app inside and out.

Get into the nitty gritty of Excel, the all-important spreadsheet tool

Microsoft 365 Excel All-in-One For Dummies offers an all-new way to tackle data in Excel. Start with the basics of inputting, formatting, and organizing data and work your way to pro techniques that help with any career field or reason for using the app. Gain the skills to apply advanced formulas and functions, create stunning data visualizations, build dashboards and reports, and automate your spreadsheets. You''ll also get a glimpse into how AI tools can boost your work. Eight mini-books come together in this expanded Excel reference. With Microsoft 365 Excel All-in-One For Dummies, you''ll soon be the go-to Excel guru in your office or school.

Learn the basics of Excel—organizing data, performing calculations, and formatting your spreadsheet. Use functions to handle advanced math and financial analysis. Create data visualizations and summaries to help tell your story Apply basic programming skills using VBA

This book is perfect for professionals or students who need to up their Excel game with insight from pros who know the classic spreadsheet app inside and out.

Die wichtigsten Excel-Funktionen auf einen Blick In Excel gibt es mehr als 470 Funktionen. Aber welche davon erleichtert Ihnen die Arbeit? Wie setzen Sie Excel-Formeln und Funktionen richtig ein? Wie lautet die Syntax? Dieses Buch stellt Excel-Einsteigern die nützlichsten Excel-Funktionen ausführlich vor. Sie lernen, wie Sie Formeln richtig für Statistiken einsetzen, Prognosen erstellen, Wahrscheinlichkeiten berechnen und mit Copilot die Funktionalität von Excel um KI erweitern. Praktische Beispiele verdeutlichen Ihnen den richtigen Gebrauch der Formeln und Funktionen und zeigen Ihnen Anwendungsmöglichkeiten in Ihrem Arbeitsalltag. Sie erfahren Welche wichtigen Formeln und Funktionen Sie kennen solltenWie Sie einfache Berechnungen, effektive Analysen und komplexe Reports erstellenWie Sie Datenbankfunktionen nutzen und Statistiken auswerten

Das unverzichtbare Nachschlagewerk für Excel-Wissen Dieses Buch lässt keine Excel-Wünsche offen! Es zeigt Ihnen verständlich, grundlegend und umfassend, wie Excel funktioniert und welche Möglichkeiten Excel für Sie bereithält. Es bietet Neulingen einen leichten Einstieg, und geübten Excel-Nutzern dient es als ein praktisches Nachschlagewerk. Von der ersten Tabelle und Formel über Datenanalyse und Visualisierung bis hin zum Arbeiten mit Makros und Pivot-Tabellen erhalten Sie Antworten auf alle Ihre Excel-Fragen. Außerdem erfahren Sie, wie KI-Tools Ihre Arbeit verbessern können. Also los, entfesseln Sie den Excel-Guru in sich! Sie erfahren Wie Sie Arbeitsblätter anlegen, bearbeiten und teilenWie Sie Daten importieren und analysierenWie Sie Pivot-Tabellen erzeugen, Daten abfragen und Berichte erstellenWie Sie Excel mit Makros automatisieren

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 nützlichsten Excel-Funktionen ausführlich vor. Sie lernen, wie Sie Formeln richtig für 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.

In Excel 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 nützlichsten Excel-Funktionen ausführlich vor. Sie lernen, wie Sie Formeln richtig für Statistiken einsetzen, Prognosen erstellen, 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.

Die wichtigsten Excel-Funktionen auf einen Blick

In Excel gibt es mehr als 470 Funktionen. Aber welche davon erleichtert Ihnen die Arbeit? Wie setzen Sie Excel-Formeln und Funktionen richtig ein? Wie lautet die Syntax? Dieses Buch stellt Excel-Einsteigern die nützlichsten Excel-Funktionen ausführlich vor. Sie lernen, wie Sie Formeln richtig für Statistiken einsetzen, Prognosen erstellen, Wahrscheinlichkeiten berechnen und mit Copilot die Funktionalität von Excel um KI erweitern. Praktische Beispiele verdeutlichen Ihnen den richtigen Gebrauch der Formeln und Funktionen und zeigen Ihnen Anwendungsmöglichkeiten in Ihrem Arbeitsalltag.

Sie erfahren

Welche wichtigen Formeln und Funktionen Sie kennen sollten Wie Sie einfache Berechnungen, effektive Analysen und komplexe Reports erstellen Wie Sie Datenbankfunktionen nutzen und Statistiken auswerten