Michael Alexander

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

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 objectsBuild forms, create tables, manipulate datasheets, and add data validationUse Visual Basic automation and XML Data Access Page designExchange 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.

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 workMaster formulas, formatting, pivot tables, and moreGet 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.

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.

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

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 techniquesLeverage templates and worksheets that put your new knowledge in action, and reinforce the skills introduced in the textAccess online resources, including the Power Utility Pak, that supplement the contentImprove 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.

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 ExcelCreate and use formulas that have the power to transform your Excel experienceLeverage supplemental material online, including sample files, templates, and worksheets from the book

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 objectsBuild forms, create tables, manipulate datasheets, and add data validationUse Visual Basic automation and XML Data Access Page designExchange 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.

From the people who brought you the bestselling Confessions of a GP. After sixteen years of high-pressure nursing, Michael Alexander has traded in his hospital uniform for the fresh air, comfort and routine of an International private school in the French Alps. Bliss! But it’s not long before he discovers that school nursing is not all permission slips, sniffles and gift baskets. Disastrous school trips; after hours dorm sleepovers; awkward sex education classes; culture clashes; swine flu panic; and kids with six-figure bank balances and a taste for bribery. This is nursing as you’ve never seen it before. What goes on behind the gates of one of the world’s most elite boarding schools? What happens when kids from all over the world – Russia, Africa, America, Saudi Arabia – live, learn and grow under one roof? What happens when it’s left to school staff to teach children the facts of life, and lust? Following on from the hugely successful Confessions of a Male Nurse, Michael Alexander is back with more touching, shocking and often laugh-out-loud funny tales of nursing. In Confessions of a School Nurse, Alexander tells all on boarding school life – as a nurse, parent, and Average Joe, he offers a unique perspective on this strange world.

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 formulaExplains and details how the formulas workLets you reuse or customize the given formula to address your particular needsHelps 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.

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.

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 effectiveDescribes how to use different perspectives to achieve better visibility into data, as well as how to slice data into various views on the flyShows how to automate redundant reporting and analysis processesWalks 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!

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

From the people who brought you the bestselling Confessions of a GP. From stampeding nudes to inebriated teenagers, young nurse Michael Alexander never really knew what he was getting himself into. But now, sixteen years since he was first launched into his nursing career – as the only man in a gynaecology ward – he’s pretty much dealt with everything: body parts that come off in his hands; teenagers with phantom pregnancies; doctors unable to tell the difference between their left and right; violent drunks; singing relatives; sexism… and a whole lot of nudity. Confessions of a Male Nurse is a touching, shocking and frequently hilarious account of one man’s life in nursing.

This easy, visual, full-color guide to Excel 2010 features friendly introductions and hands-on, step-by-step tasks to show novices and inexperienced upgraders the easiest, fastest, most direct way to accomplish many common tasks.