Customize and ramp-up Office 365 applications NOTE: Please click Downloads (located in the menu on the left) to download "Full Code Download." The revised 2019 edition of Mastering VBA Microsoft Office 365 offers an accessible guide that shows how to extend the capabilities of Office 365 applications with VBA programming. Written in clear terms and understandable language, the book includes systematic tutorials and contains both intermediate and advanced content for experienced VB developers. Designed to be comprehensive, the book addresses not just one Office application, but the entire Office suite. To enhance understanding, the content is explored in real-world projects in Word, Excel, Outlook, and PowerPoint. Since the technical programming methods in the Office applications continue to evolve, the updated 2019 edition reviews the changes to the program. Code libraries, the API, and the object model for each Office program have been modified during the three years since the last version of this book. Various elements within VBA have been deprecated or replaced, and the surface UI changed as well. The updated 2019 edition covers topics such as: - Recording macros and getting started with VBA - Learning how to work with VBA - Using loops and functions - Using message boxes, input boxes, and dialog boxes - Creating effective code - XML-based files, ActiveX, the developer tab, content controls, add-ins, embedded macros, and security Written for all levels of Microsoft Office 365 users, Mastering VBA Microsoft Office 365: 2019 Edition explains how to customize and automate the Office suite of applications.

Zero-defect software is the Holy Grail of all software developers. It has proved to be an elusive goal - until now. The Inspection techniques illustrated in this book have brought clear benefits in terms of lower (or even zero) defects, higher productivity, better project tracking and improved documentation.

Features

• Clear guidelines for the introduction and refinement of inspection techniques
  
• Numerous examples of successful implementations in organizations, such as AT&T and Douglas Aircraft
  
• Case studies based on actual experience with the method at IBM, Thorn EMI, Cary Research, Sema Group, Racal Redac and Applicon

"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

Cay Horstmann s seventh edition of Java Concepts provides an approachable introduction to fundamental programming techniques and design skills, helping students master basic concepts and become competent coders. Major rewrites and an updated visual design make this student-friendly text even more engaging. The text is known for its realistic programming examples, great quantity and variety of homework assignments, and lab exercises that build student problem-solving abilities. The seventh edition now includes problem solving sections, more example code online, and exercises from Science and Business.

Do you need to design efficient wireless communications systems? This unique text provides detailed coverage of radio resource allocation problems in wireless networks and the techniques that can be used to solve them. Covering basic principles and mathematical algorithms, and with a particular focus on power control and channel allocation, you will learn how to model, analyze, and optimize the allocation of resources in both physical and data link layers, and for a range of different network types. Both established and emerging networks are considered, including CDMA and OFDMA wireless networks, relay-based wireless networks, and cognitive radio networks. Numerous exercises help you put knowledge into practice, and provide the tools needed to address some of the current research problems in the field. This is an essential reference whether you are a graduate student, researcher or industry professional working in the field of wireless communication networks.

We live in an age of unparalleled opportunity for innovation. We're building more products than ever before, but most of them fail--not because we can't complete what we set out to build, but because we waste time, money, and effort building the wrong product.

What we need is a systematic process for quickly vetting product ideas and raising our odds of success. That's the promise of "Running Lean."

In this inspiring book, Ash Maurya takes you through an exacting strategy for achieving a "product/market fit" for your fledgling venture, based on his own experience in building a wide array of products from high-tech to no-tech. Throughout, he builds on the ideas and concepts of several innovative methodologies, including the Lean Startup, Customer Development, and bootstrapping.

"Running Lean" is an ideal tool for business managers, CEOs, small business owners, developers and programmers, and anyone who's interested in starting a business project.Find a problem worth solving, then define a solutionEngage your customers throughout the development cycleContinually test your product with smaller, faster iterationsBuild a feature, measure customer response, and verify/refute the ideaKnow when to "pivot" by changing your plan's courseMaximize your efforts for speed, learning, and focusLearn the ideal time to raise your "big round" of fundingGet on track with The Lean SeriesPresented by Eric Ries--bestselling author of "The Lean Startup: How Today's Entrepreneurs Use Continuous Innovation to Create Radically Successful Businesses"--The Lean Series gives you solid footing in a proven methodology that will help your business succeed.

Be prepared for the arrival of automated decision making Once thought of as science fiction, major corporations are already beginning to use cognitive systems to assist in providing wealth advice and also in medication treatment. The use of Cognitive Analytics/Artificial Intelligence (AI) Systems is set to accelerate, with the expectation that it'll be considered 'mainstream' in the next 5 - 10 years. It'll change the way we as individuals interact with data and systems--and the way we run our businesses. Cognitive Analysis and AI prepares business users for the era of cognitive analytics / artificial intelligence. Building on established texts and commentary, it specifically prepares you in terms of expectation, impact on personal roles, and responsibilities. It focuses on the specific impact on key industries (retail, financial services, utilities and media) and also on key professions (such as accounting, operational management, supply chain and risk management). Shows you how users interact with the system in natural language Explains how cognitive analysis/AI can source 'big data' Provides a roadmap for implementation Gets you up to speed now before you get left behind If you're a decision maker or budget holder within the corporate context, this invaluable book helps you gain an advantage from the deployment of cognitive analytics tools.

John Maeda is one of the world's preeminent thinkers on technology and design, and in How to Speak Machine, he offers a set of simple laws that govern not only the computers of today, but the unimaginable machines of the future. Machines are already more powerful than we can comprehend, and getting more powerful at an exponential pace. Once set in motion, algorithms never tire. And when a program's size, speed and endlessness combine with its ability to learn and transform itself, the outcome can be unpredictable and dangerous. Take the seemingly instant transformation of Microsoft's chatbot into a hate-spewing racist, or how crime-predicting algorithms reinforce racial bias. How To Speak Machine provides a coherent framework for today's product designers, business leaders and policymakers to grasp this brave new world. Drawing on his wide-ranging experience from engineering to computer science to design, Maeda shows how businesses and individuals can identify opportunities afforded by technology to make world-changing and inclusive products while avoiding the pitfalls inherent to the medium.

Create a YouTube channel that draws subscribers with top-notch content YouTube has the eyes and ears of two billion monthly users. YouTube Channels for Dummies, 2nd Edition offers proven steps to attracting a chunk of those billions to your personal or business channel. This updated guide offers insight from a quartet of YouTube channel content creators, managers, marketers, and analysts as they share the secrets of creating great content, building an audience, and interacting with your viewers. The book includes information on: - Setting up a channel - Creating videos that attract viewers - Putting together a video studio - Editing your final product - Reaching your target audience - Interacting with your fans - Building a profitable business - Tips on copyright law Written for both the budding YouTube creator and the business professional seeking to boost their company's profile on the popular social networking site, YouTube Channels for Dummies allows its readers to access the over two billion active YouTube users who log on each day. Learn how to create a channel, build a YouTube following, and get insight on content creation, planning, and marketing from established YouTube creators.

Discover how blockchain will facilitate a new currency that will transcend space and time Largely inspired by The Denationalization of Money by Fredrich Hayek, Money Without Boundaries' ideological foundation is also inspired by economists and thought leaders like Milton Friedman and Irving Fisher, advancements in capital markets over the past 50 years, and the convergence of old and new technologies. Author Thomas J. Anderson explains how blockchain acts as the filter and the glue, making it all possible. Compared with other currencies, blockchain-managed money markets are more straightforward and transparent. It is easier to monitor, understand, and assess the quality of their "full-faith and credit." Money Without Boundaries shows how not only money, but also the process of borrowing and lending, will evolve to be conducted in a 100% trusted, secure, transparent, open architecture environment. Anderson begins with a history of money and discusses the rise of cryptocurrency, concluding with a comparison of decentralized money markets to all other alternatives. Money without Boundaries: - Demonstrates how blockchain technology allows full transparency - Explains how blockchain makes it possible for money to be fully commoditized - Explains how this fully market-based, decentralized, self-regulating system has vast implications throughout the global financial system - Shows how everyone will benefit when they have the opportunity to compete on "full faith in credit" If you are interested in cryptocurrency, money, monetary theory, or understanding how the applied uses of blockchain technology will change your everyday life, this is essential reading.

The deepest reference on Microsoft's productivity service Office 365 offers the same productivity power as past versions of Microsoft Office along with tools designed to boost collaboration in the workplace and instant access to the latest Office updates without buying a whole new software package. It's an ideal solution for both the office and home use. The author of the bestselling Office All-in-One For Dummies shares his advice on how to navigate the nuts and bolts of getting things done with Office 365. Look inside for step-by-step instructions on Excel, Outlook, Word, PowerPoint, Access, and OneNote along with a dive into the cloud services that come with Office 365. Access Office 365 Make sense of common Office tasks Use Excel, Word, outlook, PowerPoint and more Take advantage of 365 online services If you're a home or business user interested in having a complete reference on the suite, this book has you covered.

Though often invisible, cryptography plays a critical role in our everyday lives. Broadly defined as a set of tools for establishing security in cyberspace, cryptography enables us to protect our information and share it securely. It underpins the security of mobile phone calls, card payments, web connections, internet messaging, Bitcoin transactions-in short, everything we do online. Clearly and concisely, Keith Martin reveals the many crucial ways we all rely on cryptographic technology and demystifies its controversial applications and the nuances behind alarming headlines about data breaches or Edward Snowden. Essential reading for anyone with a password, Cryptography offers a profound perspective on personal security, online and off.

Scientific Python is a significant public domain alternative to expensive proprietary software packages. This book teaches from scratch everything the working scientist needs to know using copious, downloadable, useful and adaptable code snippets. Readers will discover how easy it is to implement and test non-trivial mathematical algorithms and will be guided through the many freely available add-on modules. A range of examples, relevant to many different fields, illustrate the language's capabilities. The author also shows how to use pre-existing legacy code (usually in Fortran77) within the Python environment, thus avoiding the need to master the original code. In this new edition, several chapters have been re-written to reflect the IPython notebook style. With an extended index, an entirely new chapter discussing SymPy and a substantial increase in the number of code snippets, researchers and research students will be able to quickly acquire all the skills needed for using Python effectively.

The latest on SQL databases SQL All -In-One For Dummies, 3rd Edition, is a one-stop shop for everything you need to know about SQL and SQL-based relational databases. Everyone from database administrators to application programmers and the people who manage them will find clear, concise explanations of the SQL language and its many powerful applications. With the ballooning amount of data out there, more and more businesses, large and small, are moving from spreadsheets to SQL databases like Access, Microsoft SQL Server, Oracle databases, MySQL, and PostgreSQL. This compendium of information covers designing, developing, and maintaining these databases. Cope with any issue that arises in SQL database creation and management Get current on the newest SQL updates and capabilities Reference information on querying SQL-based databases in the SQL language Understand relational databases and their importance to today's organizations SQL All-In-One For Dummies is a timely update to the popular reference for readers who want detailed information about SQL databases and queries.

Donald Trump, the Arab Spring, Brexit: digital media have provided political actors and citizens with new tools to engage in politics. These tools are now routinely used by activists, candidates, non-governmental organizations, and parties to inform, mobilize, and persuade people. But what are the effects of this retooling of politics? Do digital media empower the powerless or are they breaking democracy? Have these new tools and practices fundamentally changed politics or is their impact just a matter of degree? This clear-eyed guide steps back from hyperbolic hopes and fears to offer a balanced account of what aspects of politics are being shaped by digital media and what remains unchanged. The authors discuss data-driven politics, the flow and reach of political information, the effects of communication interventions through digital tools, their use by citizens in coordinating political action, and what their impact is on political organizations and on democracy at large.

The A to Z guide to getting the most from your iPad Your iPad is a magical piece of technology connecting you to the rest of the world pretty much anytime and anywhere. Super thin and (well, almost) light as a feather, it allows you to keep up with your day to day duties, stay in touch with family and friends, catch up with work, relax with books and movies, or even create your own works of art! Given all it's capable of, it's essential to have a guide to help you make the most of your device. The latest edition of iPad and iPad Pro for Dummies helps users of all experience levels navigate this amazing looking glass. Assuming no prior knowledge, it takes you from the basics--including getting to know the iPad and adding useful accessories such as keyboards and pencils--to setting up email, connecting with other devices, maintaining files, and researching and installing the best apps for you. Discover the simple steps to get up and running Make your iPad work better and faster for you Explore the features of the brand new iPadOS Get easy fixes to common problems Pick up your copy today and find out just how sweet life in Apple tablet form can be!

Machine learning and big data is hot. It is, however, virtually unused in clinical trials. This is so, because randomization is applied to even out multiple variables Modern medical computer files often involve hundreds of variables like genes and other laboratory values, and computationally intensive methods are required This is the first publication of clinical trials that have been systematically analyzed with machine learning. In addition, all of the machine learning analyses were tested against traditional analyses. Step by step statistics for self-assessments are included The authors conclude, that machine learning is often more informative, and provides better sensitivities of testing than traditional analytic methods do

This value-packed packed set for the serious CISSP certification candidate combines the bestselling (ISC)(2) CISSP Certified Information Systems Security Professional Official Study Guide, 8th Edition with an all new collection of Practice Exams to give you the best preparation ever for the high-stakes CISSP Exam. (ISC)(2) CISSP Study Guide, 8th Edition has been completely updated for the latest 2018 CISSP Body of Knowledge. This bestselling Sybex study guide covers 100% of all exam objectives. You'll prepare for the exam smarter and faster with Sybex thanks to expert content, real-world examples, advice on passing each section of the exam, access to the Sybex online interactive learning environment, and much more. Reinforce what you've learned with key topic exam essentials and chapter review questions. Along with the book, you also get access to Sybex's superior online interactive learning environment that includes four unique 250 question practice exams to help you identify where you need to study more, more than 650 Electronic Flashcards to reinforce your learning and give you last-minute test prep before the exam, a searchable glossary in PDF to give you instant access to the key terms you need to know for the exam. Add to that the all-new (ISC)(2) CISSP Certified Information Systems Security Professional Official Practice Tests, 2nd edition with 2 more complete 250-question exams and another 100 questions for each of the 8 domains and you'll be as ready as you can be for the CISSP exam. Coverage of all of the exam topics in each book means you'll be ready for: Security and Risk Management Asset Security Security Engineering Communication and Network Security Identity and Access Management Security Assessment and Testing Security Operations Software Development Security

If you're one of many developers still uncertain about concurrent and multithreaded development, this practical cookbook will change your mind. With more than 85 code-rich recipes in this updated second edition, author Stephen Cleary demonstrates parallel processing and asynchronous programming techniques using libraries and language features in .NET and C# 8.0. Concurrency is now more common in responsive and scalable application development, but it's still extremely difficult to code. The detailed solutions in this cookbook show you how modern tools raise the level of abstraction, making concurrency much easier than before. Complete with ready-to-use code and discussions about how and why solutions work, these recipes help you: Get up to speed on concurrency and async and parallel programming Use async and await for asynchronous operations Enhance your code with asynchronous streams Explore parallel programming with .NET's Task Parallel Library Create dataflow pipelines with .NET's TPL Dataflow library Understand the capabilities that System.Reactive builds on top of LINQ Utilize threadsafe and immutable collections Learn how to conduct unit testing with concurrent code Make the thread pool work for you Enable clean, cooperative cancellation Examine scenarios for combining concurrent approaches Dive into asynchronous-friendly object-oriented programming Recognize and write adapters for code using older asynchronous styles

Bring your computer literacy course back to the BASICS. COMPUTER LITERACY BASICS: A COMPREHENSIVE GUIDE TO IC3 provides an introduction to computer concepts and skills, which maps to the newest Computing Core Certification (IC3) standards. Designed with new learners in mind, this text covers Computing Fundamentals, Key Applications, and Living Online - everything students need to pass the IC3 exam, and finish the course as confident computer users.

The human brain has some capabilities that the brains of other animals lack. It is to these distinctive capabilities that our species owes its dominant position. Other animals have stronger muscles or sharper claws, but we have cleverer brains. If machine brains one day come to surpass human brains in general intelligence, then this new superintelligence could become very powerful. As the fate of the gorillas now depends more on us humans than on the gorillas themselves, so the fate of our species then would come to depend on the actions of the machine superintelligence. But we have one advantage: we get to make the first move. Will it be possible to construct a seed AI or otherwise to engineer initial conditions so as to make an intelligence explosion survivable? How could one achieve a controlled detonation? To get closer to an answer to this question, we must make our way through a fascinating landscape of topics and considerations. Read the book and learn about oracles, genies, singletons; about boxing methods, tripwires, and mind crime; about humanity's cosmic endowment and differential technological development; indirect normativity, instrumental convergence, whole brain emulation and technology couplings; Malthusian economics and dystopian evolution; artificial intelligence, and biological cognitive enhancement, and collective intelligence. This profoundly ambitious and original book picks its way carefully through a vast tract of forbiddingly difficult intellectual terrain. Yet the writing is so lucid that it somehow makes it all seem easy. After an utterly engrossing journey that takes us to the frontiers of thinking about the human condition and the future of intelligent life, we find in Nick Bostrom's work nothing less than a reconceptualization of the essential task of our time.