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!

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.

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.

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