Search results for ""Author Michael Alexander""

Learn to use Excel dashboards and reports to better conceptualize data Updated for all the latest features and capabilities of Excel 2013, this go-to resource provides you with in-depth coverage of the individual functions and tools that can be used to create compelling Excel reports. Veteran author Michael Alexander walks you through the most effective ways to present and report data. Featuring a comprehensive review of a wide array of technical and analytical concepts, this essential guide helps you go from reporting data with simple tables full of dull numbers to presenting key information through the use of high-impact, meaningful reports and dashboards that will wow management both visually and substantively. Details how to analyze large amounts of data and report the results in a way that is both visually attractive and effective Describes how to use different perspectives to achieve better visibility into data, as well as how to slice data into various views on the fly Shows how to automate redundant reporting and analysis processes Walks you through creating impressive dashboards, eye-catching visualizations, and real-world What-If analyses Excel Dashboards and Reports, Second Edition is part technical manual, part analytical guidebook, and exactly what you need to become your organization's dashboard dynamo!

Read more less

By the 1920s, Jews were--by all economic, political, and cultural measures of the day--making it in America. But as these children of immigrants took their places in American society, many deliberately identified with groups that remained excluded. Despite their success, Jews embraced resistance more than acculturation, preferring marginal status to assimilation. The stories of Al Jolson, Felix Frankfurter, and Arnold Rothstein are told together to explore this paradox in the psychology of American Jewry. All three Jews were born in the 1880s, grew up around American Jewish ghettos, married gentile women, entered the middle class, and rose to national fame. All three also became heroes to the American Jewish community for their association with events that galvanized the country and defined the Jazz Age. Rothstein allegedly fixed the 1919 World Series--an accusation this book disputes. Frankfurter defended the Italian anarchists Sacco and Vanzetti. Jolson brought jazz music to Hollywood for the first talking film, The Jazz Singer, and regularly impersonated African Americans in blackface. Each of these men represented a version of the American outsider, and American Jews celebrated them for it. Michael Alexander's gracefully written account profoundly complicates the history of immigrants in America. It challenges charges that anti-Semitism exclusively or even mostly explains Jews' feelings of marginality, while it calls for a general rethinking of positions that have assumed an immigrant quest for inclusion into the white American mainstream. Rather, Alexander argues that Jewish outsider status stemmed from the group identity Jews brought with them to this country in the form of the theology of exile. Jazz Age Jews shows that most Jews felt culturally obliged to mark themselves as different--and believed that doing so made them both better Jews and better Americans.

Read more less

Delhi claims a noble history as the site of at least seven capitals dating from before the time of Alexander the Great. The glorious Mogul Empire brought great riches to the city and to Agra, where the world-famous Taj Mahal has excited awe in visitors for over 380 years. This Traveller's Reader is an indispensable and fascinating companion for the traveller who wants to understand the history of both cities, and who seeks the true spirit of the places. Delhi & Agra is a topographical anthology that explores the cities' sites of interest and recreates the key events, customs and lives of the past, drawing on diaries, letters, memoirs and commentaries written by residents and visitors over the course of 600 years. Extracts include Tamerlane's account of the sack of Delhi in 1398; descriptions of Shah Jahan building the Taj Mahal; recollections of Jesuits and mullahs debating the relative merits of their religions before the great Mogul emperor, Akbar; reports of cruelty and creativity, of addiction to drink and drugs; descriptions of elephant fights, suttee, the life of the bazaar and vice-regal banquets; and eyewitness accounts of the Indian Mutiny from both sides, and of the bloody aftermath of Partition. A great variety of topics are covered, vividly conveying an impression of how it would have been to live in, or visit, both cities from the recent past to hundreds of years ago.

Read more less

It’s time for some truly “Excel-lent” spreadsheet reporting Beneath the seemingly endless rows and columns of cells, the latest version of Microsoft Excel boasts an astonishing variety of features and capabilities. But how do you go about tapping into some of that power without spending all of your days becoming a spreadsheet guru? It’s easy. You grab a copy of the newest edition of Excel Dashboards & Reports For Dummies and get ready to blow the pants off your next presentation audience! With this book, you’ll learn how to transform those rows and columns of data into dynamic reports, dashboards, and visualizations. You’ll draw powerful new insights from your company’s numbers to share with your colleagues – and seem like the smartest person in the room while you’re doing it. Excel Dashboards & Reports For Dummies offers: Complete coverage of the latest version of Microsoft Excel provided in the Microsoft 365 subscription Strategies to automate your reporting so you don’t have to manually crunch the numbers every week, month, quarter, or year Ways to get new perspectives on old data, visualizing it so you can find solutions no one else has seen before If you’re ready to make your company’s numbers and spreadsheets dance, it’s time to get the book that’ll have them moving to your tune in no time. Get Excel Dashboards & Reports For Dummies today.

Read more less

Now reissued in an updated paperback edition, this groundbreaking account of the Medieval Revival movement examines the ways in which the style of the medieval period was re-established in post-Enlightenment England—from Walpole and Scott, Pugin, Ruskin, and Tennyson to Pound, Tolkien, and Rowling. “Medievalism . . . takes a panoramic view of the ‘recovery’ of the Medieval in English literature, visual arts and culture. . . . Ambitious, sweeping, sometimes idiosyncratic, but always interesting.”—Rosemary Ashton, Times Literary Supplement “Deeply researched and stylishly written, Medievalism is an unalloyed delight that will instruct and amuse a wide readership.”—Edward Short, Books & Culture

Read more less

This comprehensive text traces the development of one of the world’s richest literatures from the Old English period through to the present day, discussing a wide range of key authors without losing its clarity or verve. Building on the book's established reputation and success, the third edition has been revised and updated throughout. It now provides a full final chapter on the contemporary scene, with more on genres and the impact of globalization. This accessible book remains the essential companion for students of English literature and literary history, or for anyone wishing to follow the unfolding of writing in England from its beginnings. It is ideal for those who know a few landmark texts, but little of the literary landscape that surrounds them; those who want to know what English literature consists of; and those who simply want to read its fascinating story. New to this Edition: - Fully revised throughout - A full final chapter on contemporary writing, with closer attention paid to the growing diversity of literatures in English in the British Isles

Read more less

Beowulf is the greatest surviving work of literature in Old English, unparalleled in its epic grandeur and scope. It tells the story of the heroic Beowulf and of his battles, first with the monster Grendel, who has laid waste to the great hall of the Danish king Hrothgar, then with Grendel's avenging mother, and finally with a dragon that threatens to devastate his homeland. Through its blend of myth and history, Beowulf vividly evokes a twilight world in which men and supernatural forces live side by side. And it celebrates the endurance of the human spirit in a transient world."Alexander's translation is marked by a conviction that it is possible to be both ambitious and faithful [and] ...communicates the poem with a care which goes beyond fidelity-to-meaning and reaches fidelity of implication. May it go on ... to another half-million copies." - Tom Shippey, Bulletin of the International Association of University Professors of English

Read more less

Wie Sie mit Microsoft Power Pivot und Power Query große Datenmengen in Excel zusammenführen, untersuchen und weiterführende Erkenntnisse daraus gewinnen, zeigt Ihnen dieses Buch. Angefangen bei der Anbindung an Datenbanken bis hin zur Verwendung eigener Formeln und Funktionen: Sie erfahren, wie Sie Daten aus verschiedenen Datenquellen in einem einheitlichen Datenmodell verarbeiten, interpretieren und übersichtlich in Berichten darstellen. Schritt-für-Schritt-Anleitungen und wertvolle Praxistipps unterstützen Sie dabei, Analysen und Geschäftsprozesse weiter zu optimieren.

Read more less

Alexander’s A History of Old English Literature is an outstanding introduction to a difficult period of literary history. It provides a simple historical and cultural context for the study of the Anglo-Saxons, and offers a history, illustrated by many passages in translation, of the whole of the literature that survives. While it contains solid, insightful and sensible criticism of individual literary works, its overall historical organization suggests that Old English literature was created in a cultural context that changed from one century to another. Although its intentions are scholarly, this history of Old English literature is also an introduction, assuming little knowledge of this period or its surviving products, and none of its language. This edition has been revised and rewritten throughout, and offers a new preface as well as an updated bibliography.

Read more less

Learn to crunch huge amounts of data with PowerPivot and Power Query Do you have a ton of data you need to make sense of? Microsoft’s Excel program can handle amazingly large data sets, but you’ll need to get familiar with PowerPivot and Power Query to get started. And that’s where Dummies comes in. With step-by-step instructions—accompanied by ample screenshots—Excel PowerPivot & Power Query For Dummies will teach you how to save time, simplify your processes, and enhance your data analysis and reporting. Use Power Query to discover, connect to, and import your organization’s data. Then use PowerPivot to model it in Excel. You’ll also learn to: Make use of databases to store large amounts of data Use custom functions to extend and enhance Power Query Add the functionality of formulas to PowerPivot and publish data to SharePoint If you’re expected to wrangle, interpret, and report on large amounts of data, Excel PowerPivot & Power Query For Dummies gives you the tools you need to get up to speed quickly.

Read more less

The ultimate handbook for Excel analysts who need reporting solutions using Access Excel and Access are intended to work together. This book offers a comprehensive review of the extensive analytical and reporting functionality that Access provides and how it enhances Excel reporting functions. Sales managers, operations analysts, administrative assistants, office managers, and many others who rely heavily on data can benefit from learning to integrate Excel and Access, and this book shows you how. Coverage includes: Data Analysis in Access & the Basics of Access Beyond Select Queries Transforming Your Data with Access Working with Calculations and Dates Performing Conditional Analysis Adding Dimension with Subqueries and Domain Aggregate Functions Running Descriptive Statistics in Access Scheduling and Running Batch Analysis Leveraging VBA to Enhance Data Analysis Reports, Dashboards, and Visualization in Access Presenting Data with Access Reports Using Pivot Tables and Pivot Charts in Access Enhancing Queries and Reports with Visualizations Advanced Excel and Access Integration Techniques Getting Access Data into Excel Using VBA to Move Data between Excel and Access Exploring Excel and Access Automation Integrating Excel and Access with XML Integrating Excel and Other Office Applications Access VBA Fundamentals Understanding and Using SQL and more! The Excel Analyst's Guide to Access helps you get more from both applications. Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.

Read more less

Renowned Excel experts Bill Jelen (MrExcel) and Michael Alexander help you crunch data from any source with Excel 2019 pivot tables. Use Excel 2019 pivot tables and pivot charts to produce powerful, dynamic reports in minutes instead of hours, to take control of your data and your business. Even if you’ve never created a pivot table before, this book will help you leverage all their remarkable flexibility and analytical power–including valuable improvements in Excel 2019 and Excel in Office 365. Drawing on more than 45 combined years of Excel experience, Bill Jelen and Michael Alexander offer practical “recipes” for solving real business problems, help you avoid common mistakes, and present tips and tricks you’ll find nowhere else. By reading this book, you will: • Master easy, powerful ways to create, customize, change, and control pivot tables • Control all future pivot tables using new pivot table defaults • Transform huge data sets into clear summary reports • Instantly highlight your most profitable customers, products, or regions • Use Power Query to quickly import, clean, shape, and analyze disparate data sources • Build geographical pivot tables with 3D Map • Construct and share state-of-the-art dynamic dashboards • Revamp analyses on the fly by dragging and dropping fields • Build dynamic self-service reporting systems • Share your pivot tables with colleagues • Create data mashups using the full Power Pivot capabilities of Excel 2019 and Excel in Office 365 • Automate pivot tables with macros and VBA • Save time by adapting reports with GetPivotData • Discover today’s most useful pivot table tips and shortcuts

Read more less

Leverage the full power of Excel formulas Excel 2016 Formulas is fully updated to cover all of the tips, tricks, and techniques you need to maximize the power of Excel 2016 through the use of formulas. This comprehensive book explains how to create financial formulas, release the power of array formulas, develop custom worksheet functions with VBA, debug formulas, and much more. Whether you're a beginner, a power user, or somewhere in between this is your essential go-to for the latest on Excel formulas. When conducting simple math or building highly complicated spreadsheets that require formulas up to the task, leveraging the right formula can heighten the accuracy and efficiency of your work, and can improve the speed with which you compile and analyze data. Understanding which formulas to use and knowing how to create a formula when you need to are essential. Access tips, tricks, and techniques that have been fully updated to reflect the latest capabilities of Microsoft Excel Create and use formulas that have the power to transform your Excel experience Leverage supplemental material online, including sample files, templates, and worksheets from the book

Read more less

Mr. Spreadsheet has done it again with 101 easy-to-apply Excel formulas 101 Ready-to-Use Excel Formulas is filled with the most commonly-used, real-world Excel formulas that can be repurposed and put into action, saving you time and increasing your productivity. Each segment of this book outlines a common business or analysis problem that needs to be solved and provides the actual Excel formulas to solve the problem—along with detailed explanation of how the formulas work. Written in a user-friendly style that relies on a tips and tricks approach, the book details how to perform everyday Excel tasks with confidence. 101 Ready-to-Use Excel Formulas is sure to become your well-thumbed reference to solve your workplace problems. The recipes in the book are structured to first present the problem, then provide the formula solution, and finally show how it works so that it can be customized to fit your needs. The companion website to the book allows readers to easily test the formulas and provides visual confirmation of the concepts presented. Teaches you how to implement the required Excel formula Explains and details how the formulas work Lets you reuse or customize the given formula to address your particular needs Helps you make the formulas a regular part of your new, more efficient workflow Specific real-world scenarios are used to demonstrate how to most effectively apply Excel and its powerful formulas to complete tasks faster and with greater accuracy than ever before. Now you can save time, automate, and be more efficient and productive with 101 Ready-to-Use Excel Formulas.

Read more less

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.

Read more less

Maximize your Excel experience with VBA Excel 2019 Power Programming with VBA is fully updated to cover all the latest tools and tricks of Excel 2019. Encompassing an analysis of Excel application development and a complete introduction to Visual Basic for Applications (VBA), this comprehensive book presents all of the techniques you need to develop both large and small Excel applications. Over 800 pages of tips, tricks, and best practices shed light on key topics, such as the Excel interface, file formats, enhanced interactivity with other Office applications, and improved collaboration features. Understanding how to leverage VBA to improve your Excel programming skills can enhance the quality of deliverables that you produce—and can help you take your career to the next level. Explore fully updated content that offers comprehensive coverage through over 900 pages of tips, tricks, and techniques Leverage templates and worksheets that put your new knowledge in action, and reinforce the skills introduced in the text Improve your capabilities regarding Excel programming with VBA, unlocking more of your potential in the office Excel 2019 Power Programming with VBA is a fundamental resource for intermediate to advanced users who want to polish their skills regarding spreadsheet applications using VBA.

Read more less

Excel-Makros sind ein Mysterium für Sie? Sie haben das Ziel, selbst Makros zu schreiben? Oder wollen wissen, wie Sie mit Excel Makros wertvolle Zeit sparen können? In dieser aktualisierten Auflage hat Michael Alexander die 70 gebräuchlichsten Excel-Makro-Anwendungen für Sie zusammengestellt. Er beginnt mit einer knappen Einführung in die Makrogrundlagen und VBA, erläutert aber auch, wie Sie Makros anwenden, an Ihre Bedürfnisse anpassen und sie selbst schreiben. So lernen Sie Makros effizient einsetzen und das Fehlerpotenzial manueller Eingaben reduzieren.

Read more less

Collects the Latest Research Involving the Application of Process Algebra to ComputingExploring state-of-the-art applications, Process Algebra for Parallel and Distributed Processing shows how one formal method of reasoning—process algebra—has become a powerful tool for solving design and implementation challenges of concurrent systems. Parallel ProgrammingDivided into three parts, the book begins by parallelizing an algorithm for the Cell Broadband Engine processor of IBM, Sony, and Toshiba. It also develops a runtime environment that can be ported to different parallel platforms and describes the formal model of action systems. Distributed SystemsThe next part presents a process algebra (mCRL2) that targets distributed applications, looks at how to turn prose descriptions into unambiguous specifications, extends pi-calculus to create a service-oriented mobility abstract machine, and introduces the Channel Ambient Machine for mobile applications. Embedded SystemsThe final section combines state-based Z with the event-based process algebra CSP in a formal methodology called Circus. It also develops a pair of process algebras (PARS) to address the problem of scheduling in real-time embedded systems and emphasizes the reuse of concurrent artifacts across different hardware platforms.Highlighting recent research work, this volume addresses multicore programming problems and the evolution of the growing body of concurrency-enabled languages. It proposes solutions to the problems of designing and implementing today’s concurrency-constrained multicore processor and cloud architectures.

Read more less

Maximize your Excel experience with VBA Excel 2016 Power Programming with VBA is fully updated to cover all the latest tools and tricks of Excel 2016. Encompassing an analysis of Excel application development and a complete introduction to Visual Basic for Applications (VBA), this comprehensive book presents all of the techniques you need to develop both large and small Excel applications. Over 800 pages of tips, tricks, and best practices shed light on key topics, such as the Excel interface, file formats, enhanced interactivity with other Office applications, and improved collaboration features. In addition to the procedures, tips, and ideas that will expand your capabilities, this resource provides you with access to over 100 online example Excel workbooks and the Power Utility Pak, found on the Mr. Spreadsheet website. Understanding how to leverage VBA to improve your Excel programming skills can enhance the quality of deliverables that you produce—and can help you take your career to the next level. Explore fully updated content that offers comprehensive coverage through over 900 pages of tips, tricks, and techniques Leverage templates and worksheets that put your new knowledge in action, and reinforce the skills introduced in the text Access online resources, including the Power Utility Pak, that supplement the content Improve your capabilities regarding Excel programming with VBA, unlocking more of your potential in the office Excel 2016 Power Programming with VBA is a fundamental resource for intermediate to advanced users who want to polish their skills regarding spreadsheet applications using VBA.

Read more less

The complete guide to Excel 2019 Whether you are just starting out or an Excel novice, the Excel 2019 Bible is your comprehensive, go-to guide for all your Excel 2019 needs. Whether you use Excel at work or at home, you will be guided through the powerful new features and capabilities to take full advantage of what the updated version offers. Learn to incorporate templates, implement formulas, create pivot tables, analyze data, and much more. Navigate this powerful tool for business, home management, technical work, and much more with the only resource you need, Excel 2019 Bible. Create functional spreadsheets that work Master formulas, formatting, pivot tables, and more Get acquainted with Excel 2019's new features and tools Whether you need a walkthrough tutorial or an easy-to-navigate desk reference, the Excel 2019 Bible has you covered with complete coverage and clear expert guidance.

Read more less

Master database creation and management Access 2016 Bible is your, comprehensive reference to the world's most popular database management tool. With clear guidance toward everything from the basics to the advanced, this go-to reference helps you take advantage of everything Access 2016 has to offer. Whether you're new to Access or getting started with Access 2016, you'll find everything you need to know to create the database solution perfectly tailored to your needs, with expert guidance every step of the way. The companion website features all examples and databases used in the book, plus trial software and a special offer from Database Creations. Start from the beginning for a complete tutorial, or dip in and grab what you need when you need it. Access enables database novices and programmers to store, organize, view, analyze, and share data, as well as build powerful, integrable, custom database solutions � but databases can be complex, and difficult to navigate. This book helps you harness the power of the database with a solid understanding of their purpose, construction, and application. Understand database objects and design systems objects Build forms, create tables, manipulate datasheets, and add data validation Use Visual Basic automation and XML Data Access Page design Exchange data with other Office applications, including Word, Excel, and more From database fundamentals and terminology to XML and Web services, this book has everything you need to maximize Access 2016 and build the database you need.

Read more less

A comprehensive reference to the updated and new features of Access 2013 As the world's most popular database management tool, Access enables you to organize, present, analyze, and share data as well as build powerful database solutions. However, databases can be complex. That's why you need the expert guidance in this comprehensive reference. Access 2013 Bible helps you gain a solid understanding of database purpose, construction, and application so that whether you're new to Access or looking to upgrade to the 2013 version, this well-rounded resource provides you with a thorough look at everything Access can do. Explains how to create tables, manipulate datasheets, and work with multiple tables Teaches you how to apply the seven-step design method to build databases that are tailored to your needs Covers building forms with wizards, creating bound and unbound forms, and adding data validation Shows you ways to automate query parameters, create functions and subroutines, and add programmed error routines Features a bonus website with content that contains all source code from the book as well as bonus shareware, freeware, trial, demo, and evaluation programs If you are looking for a comprehensive book on all things Access, look no further than Access 2013 Bible.

Read more less

Master database creation and management Access 2019 Bible is your, comprehensive reference to the world's most popular database management tool. With clear guidance toward everything from the basics to the advanced, this go-to reference helps you take advantage of everything Access 2019 has to offer. Whether you're new to Access or getting started with Access 2019, you'll find everything you need to know to create the database solution perfectly tailored to your needs, with expert guidance every step of the way. The companion website features all examples and databases used in the book, plus trial software and a special offer from Database Creations. Start from the beginning for a complete tutorial, or dip in and grab what you need when you need it. Access enables database novices and programmers to store, organize, view, analyze, and share data, as well as build powerful, integrable, custom database solutions — but databases can be complex, and difficult to navigate. This book helps you harness the power of the database with a solid understanding of their purpose, construction, and application. Understand database objects and design systems objects Build forms, create tables, manipulate datasheets, and add data validation Use Visual Basic automation and XML Data Access Page design Exchange data with other Office applications, including Word, Excel, and more From database fundamentals and terminology to XML and Web services, this book has everything you need to maximize Access 2019 and build the database you need.

Read more less