Michael Alexander – författare

Your complete guide to Excel 365, written for newbies all the way to seasoned professionals Neatly organised and written using accessible language, Microsoft Excel 365 Bible contains everything that readers need to know to get up and running quickly with Excel. Covering the numerous updates to Excel 365 since the previous edition was published in 2022, this Second Edition contains many useful examples and tips and tricks that cover all essential aspects of Excel—from the basics, such as navigating the user interface, to more advanced topics, such as creating visualisations and crafting custom functions. Written by an accomplished team of authors with decades of Excel and business intelligence experience, this book explores topics including: Entering and editing worksheet data, with information on data types, formulas, dates, times and other cell contentsBuilding formulas with Excel table objects, correcting common formula errors and using formula variablesWorking with data series, changing basic chart elements and making use of chart customizationLoading data from other sources, performing common transformations and applying conditional logicMicrosoft Excel 365 Bible earns a well-deserved spot on the bookshelves of all professionals and individuals seeking to get the most out of Excel 365, from beginners with limited knowledge of the software all the way to advanced users with years of experience under their belts.

A fast, up-to-date, and convenient desk reference for Excel users of any skill level Drawn from the most important tasks in the latest bestselling Excel Bible , Excel Quick and Easy is your ticket to data mastery. Excel veterans Michael Alexander and Dick Kusleika distil the most essential and useful tasks you need to understand about the world's most popular spreadsheet program, from functions to charts, graphs, formulas and more. Prepare for a whirlwind tour of Excel, packed with simple and step-by-step guides to common and lesser-known Excel features. This book shows you how to: Create new spreadsheets and workbooks by entering and editing worksheet dataSimplify working with large amounts of data by naming and moving rangesMake calculations and draw conclusions from your data by using formulasVisualize and present your data by creating functional chartsThe secret weapon in your productivity arsenal Being great at Excel is quickly becoming a standard expectation for a ton of employers and organizations, in all sorts of industries. Sharpening your skills can boost your workplace performance and make it easier to land promotions or find new roles. Excel Quick and Easy makes it a breeze to develop the proficiencies that help you stand out from your peers. Unique features of this book Step-by-step guides to the most commonly used and productive Excel tasks, from basic worksheet operations to formatting spreadsheets for hardcopy printingIntuitive explanations for making your data tell a compelling story with visualizations, including charts, graphs, and tablesAdvanced number-crunching techniques, including formulas and functions, that help you unlock fresh insights and new conclusions from your dataExcel Quick and Easy is the perfect reference for brand-new Excel users trying to get up-to-speed quickly and confidently. It's also a must-read for anyone migrating from another spreadsheet program, like Google Sheets, or more experienced Excel users who need to solidify and improve their skills. If you're tired of stumbling through your spreadsheets and just “surviving” in Excel, grab a copy of Excel Quick and Easy and supercharge your productivity. You'll refine your understanding of the basics, learn brand-new skills and features, and become the Excel expert that every office desperately needs.

Unlock the full potential of automation in the online version of Excel online with this easy-to-follow guide Microsoft 365 Excel Office Scripts For Dummies, by experienced Microsoft MVP Michael Alexander, explains how to use Office Scripts to unlock VBA-like capabilities in the online version of Excel. Alexander demonstrates exactly how to automate repetitive tasks, streamline workflows, and customize your spreadsheet experience with the same power previously available only to users of Excel’s desktop version. This comprehensive guide walks you through the practical application of Office Scripts using TypeScript. It walks you through basic automation scripts before moving on to advanced integration features you can access with Power Automate. The author’s hands-on approach helps you master the techniques you need to transform your Excel online experience from repetitive drudgery to automated efficiency, showing you how to maximize your productivity in a huge variety of settings. Learn how to: Master TypeScript fundamentals specifically tailored for Excel automation and scriptingAutomate table formatting, data cleaning, and sorting processes to eliminate repetitive manual workCreate dynamic charts and enhance PivotTables with custom scripts for professional reportingIntegrate Power Automate features to build sophisticated workflows across Microsoft 365 applicationsApply range definitions and advanced scripting techniques for complex data manipulation tasksPerfect for business professionals, data analysts, and advanced Excel users who work mostly with the online version of Excel and who want to automate their workflows, Microsoft 365 Excel Office Scripts For Dummies is a must-read for everyone interested in managing large datasets, creating regular reports, and streamlining routine tasks.

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 dataUse custom functions to extend and enhance Power QueryAdd the functionality of formulas to PowerPivot and publish data to SharePointIf 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.

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.

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.

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.

Best-selling author and professional nurse Michael Alexander offers practical and achievable advice on how you can get the best out of hospital visits and admission.In this short, fun and informative book, Michael Alexander, author of `Confessions of a Male Nurse’ explains how we, as patients, can have a hugely positive impact on our hospital treatment and care.Divided into three easy to read chapters, `Getting Out Alive’ looks at every stage of the health care cycle: before hospital, at hospital, and after discharge.Michael Alexander’s simple and easy guide to surviving hospital is essential reading for anyone in need of medical care, or likely to be in need of medical care in the future . . . Which is pretty much all of us.

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.

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.

CRUNCH ANY DATA, FROM ANY SOURCE, QUICKLY AND EASILY, WITH EXCEL 2013 PIVOT TABLES!

Use Excel 2013 pivot tables and pivot charts to produce powerful, dynamic reports in minutes instead of hours… understand exactly what’s going on in your business… take control, and stay in control!

 

Even if you’ve never created a pivot table before, this book will help you leverage all their amazing flexibility and analytical power. In just the first seven chapters, you learn how to generate complex pivot reports complete with drill-down capabilities and accompanying charts. Then, you go even further, discovering how to build a comprehensive, dynamic pivot table reporting system for any business task or function.

 

Learning advanced pivot table and pivot chart techniques for Excel 2013 or the newest Office 365 has never been easier. You’ll find simple, step-by-step instructions, real-world case studies, even complete, easy recipes for solving your most common business analysis problems.

 

•   Create, customize, and change your pivot tables and pivot charts

•   Transform gigantic data sets into crystal-clear summary reports

•   Summarize and analyze data even faster with new Excel 2013 recommended pivot tables

•   Instantly highlight your most (and least) profitable customers, products, or regions

•   Quickly filter pivot tables using slicers

•   Use dynamic dashboards using Power View to see exactly where your business stands right now

•   Revamp analyses on the fly by simply dragging and dropping fields

•   Build dynamic self-service reporting systems your entire team can use

•   Use PowerPivot or the Data Model to create pivot tables from multiple data sources and worksheets

•   Work with and analyze OLAP data, and much more

 

About MrExcel Library:  Every book in the MrExcel Library pinpoints a specific set of crucial Excel tasks and presents focused skills and examples for performing them rapidly and effectively. Selected by Bill Jelen, Microsoft Excel MVP and mastermind behind the leading Excel solutions website MrExcel.com, these books will

•   Dramatically increase your productivity—saving you 50 hours a year or more

•   Present proven, creative strategies for solving real-world problems

•   Show you how to get great results, no matter how much data you have

•   Help you avoid critical mistakes that even experienced users make

 

 CATEGORY: Spreadsheets

COVERS: Microsoft Office Excel 2013

 

Excel® 2016 PIVOT TABLE DATA CRUNCHING

CRUNCH DATA FROM ANY SOURCE, QUICKLY AND EASILY, WITH EXCEL 2016 PIVOT TABLES!

 

 

Use Excel 2016 pivot tables and pivot charts to produce powerful, dynamic reports in minutes instead of hours… understand exactly what’s going on in your business… take control, and stay in control! Even if you’ve never created a pivot table before, this book will help you leverage all their amazing flexibility and analytical power. Drawing on more than 40 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!

• Create, customize, and change pivot tables

• Transform huge data sets into clear summary reports

• Analyze data faster with Excel 2016’s new recommended pivot tables

• Instantly highlight your most profitable customers, products, or regions

• Quickly import, clean, and shape data with Power Query vBuild geographical pivot tables with Power Map

• Use Power View dynamic dashboards to see where your business stands

• Revamp analyses on the fly by dragging and dropping fields

• Build dynamic self-service reporting systems

• Combine multiple data sources into one pivot table

• Use Auto grouping to build date/time-based pivot tables faster vCreate data mashups with Power Pivot

• Automate pivot tables with macros and VBA

 

 

About MrExcel Library

 

Every book in the MrExcel Library pinpoints a specific set of crucial Excel tasks and presents focused skills and examples for performing them rapidly and effectively. Selected by Bill Jelen, Microsoft Excel MVP and mastermind behind the leading Excel solutions website MrExcel.com, these books will

• Dramatically increase your productivity—saving you 50 hours a year or more

• Present proven, creative strategies for solving real-world problems

• Show you how to get great results, no matter how much data you have

• Help you avoid critical mistakes that even experienced users make

 

Bill Jelen is MrExcel, the world’s #1 spreadsheet wizard. Jelen hosts MrExcel.com, the premier Excel solutions site, with more than 20 million page views annually. A Microsoft MVP for Excel, his best-sellers include Excel 2016 In Depth. Michael Alexander, Microsoft Certified Application Developer (MCAD) and Microsoft MVP, is author of several books on advanced business analysis with Excel and Access. He has more than 15 years of experience developing Office solutions.

 

CATEGORY:   Spreadsheets

COVERS:   Microsoft Excel 2016

This selection of the earliest poems in English comprises works from an age in which verse was not written down, but recited aloud and remembered. Heroic poems celebrate courage, loyalty and strength, in excerpts from Beowulf and in The Battle of Brunanburgh, depicting King Athelstan’s defeat of his northern enemies in 937 AD, while The Wanderer and The Seafarer reflect on exile, loss and destiny. The Gnomic Verses are proverbs on the natural order of life, and the Exeter Riddles are witty linguistic puzzles. Love elegies include emotional speeches from an abandoned wife and separated lovers, and devotional poems include a vision of Christ’s cross in The Dream of the Rood, and Caedmon’s Hymn, perhaps the oldest poem in English, speaking in praise of God.

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

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

Author Michael Alexander: Michael Alexander is Emeritus Professor of English Literature, University of St Andrews, UK. He is a poet and translator and has international experience of teaching English literature, both medieval and modern.Author Michael Alexander: Michael Alexander is Emeritus Professor of English Literature, University of St Andrews, UK. He is a poet and translator and has international experience of teaching English literature, both medieval and modern.

This volume starts with the writings of Bede and covers the range of Medieval literature up to the time of Thomas More. The Old English selections which include extracts from Beowulf and well-known riddles and elegies, are in modern English translation. The Middle English writings, from Langland, Chaucer, Malory and many others, are presented in the original language with marginal notes, or with a full translation where appropriate. This anthology contains new translations of some well-known works, and provides an illuminating insight into this fascinating period.

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.

This book is aimed squarely at Excel users who want to harness the power of the VBA language in their Excel applications. At all times, the VBA language is presented in the context of Excel, not just as a general application programming language.

The Primer has been written for those who are new to VBA programming and the Excel object model. It introduces the VBA language and the features of the language that are common to all VBA applications. It explains the relationship between collections, objects, properties, methods, and events and shows how to relate these concepts to Excel through its object model. It also shows how to use the Visual Basic Editor and its multitude of tools, including how to obtain help.

The middle section of the book takes the key objects in Excel and shows, through many practical examples, how to go about working with those objects. The techniques presented have been developed through the exchange of ideas of many talented Excel VBA programmers over many years and show the best way to gain access to workbooks, worksheets, charts, ranges, and so on. The emphasis is on efficiency—that is, how to write code that is readable and easy to maintain and that runs at maximum speed. In addition, the chapters devoted to accessing external databases detail techniques for accessing data in a range of formats.

The final four chapters of the book address the following advanced issues: linking Excel to the Internet, writing code for international compatibility, programming the Visual Basic Editor, and how to use the functions in the Win32 API (Windows 32-bit Application Programming Interface).

The ultimate handbook for Excel analysts who need reporting solutions using AccessExcel 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 AccessBeyond Select QueriesTransforming Your Data with AccessWorking with Calculations and DatesPerforming Conditional AnalysisAdding Dimension with Subqueries and Domain Aggregate FunctionsRunning Descriptive Statistics in AccessScheduling and Running Batch AnalysisLeveraging VBA to Enhance Data AnalysisReports, Dashboards, and Visualization in AccessPresenting Data with Access ReportsUsing Pivot Tables and Pivot Charts in AccessEnhancing Queries and Reports with VisualizationsAdvanced Excel and Access Integration TechniquesGetting Access Data into ExcelUsing VBA to Move Data between Excel and AccessExploring Excel and Access AutomationIntegrating Excel and Access with XMLIntegrating Excel and Other Office ApplicationsAccess VBA FundamentalsUnderstanding and Using SQLand 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.

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.

An introduction to Ezra Pound's work. Alexander shows how he contributed to the modernist movement through his own writing as well as through his impact on Yeats, Eliot, Joyce and others.This title is part of UC Press's Voices Revived program, which commemorates University of California Press's mission to seek out and cultivate the brightest minds and give them voice, reach, and impact. Drawing on a backlist dating to 1893, Voices Revived makes high-quality, peer-reviewed scholarship accessible once again using print-on-demand technology. This title was originally published in 1979.An introduction to Ezra Pound's work. Alexander shows how he contributed to the modernist movement through his own writing as well as through his impact on Yeats, Eliot, Joyce and others.This title is part of UC Press's Voices Revived program,

An introduction to Ezra Pound''s work. Alexander shows how he contributed to the modernist movement through his own writing as well as through his impact on Yeats, Eliot, Joyce and others.This title is part of UC Press''s Voices Revived program, which commemorates University of California Press''s mission to seek out and cultivate the brightest minds and give them voice, reach, and impact. Drawing on a backlist dating to 1893, Voices Revived makes high-quality, peer-reviewed scholarship accessible once again using print-on-demand technology. This title was originally published in 1979.An introduction to Ezra Pound''s work. Alexander shows how he contributed to the modernist movement through his own writing as well as through his impact on Yeats, Eliot, Joyce and others.This title is part of UC Press''s Voices Revived program,

An introduction to Ezra Pound's work. Alexander shows how he contributed to the modernist movement through his own writing as well as through his impact on Yeats, Eliot, Joyce and others.This title is part of UC Press's Voices Revived program, which commemorates University of California Press's mission to seek out and cultivate the brightest minds and give them voice, reach, and impact. Drawing on a backlist dating to 1893, Voices Revived makes high-quality, peer-reviewed scholarship accessible once again using print-on-demand technology. This title was originally published in 1979.An introduction to Ezra Pound's work. Alexander shows how he contributed to the modernist movement through his own writing as well as through his impact on Yeats, Eliot, Joyce and others.This title is part of UC Press's Voices Revived program,

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.

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.

PivotTables may be Excel's most powerful feature, but Microsoft has estimated that only 15% of Excel users take advantage of them. That's because PivotTables (and their companion feature, PivotCharts) have a reputation for being difficult to learn. Not any more! In this book, Excel legends Bill Jelen ("MrExcel") and Michael Alexander teach PivotTables and PivotCharts step-by-step, using realistic business scenarios that any Excel user can intuitively understand. Jelen and Alexander go far beyond merely explaining PivotTables and PivotCharts: they present practical "recipes" for solving a wide range of business problems. Drawing on more than 30 combined years of Excel experience, they provide tips and tricks you won't find anywhere else, and show exactly how to sidestep common mistakes. Coverage includes: " Creating PivotTables, customizing them, and changing the way you view them " Performing calculations within PivotTables " Using PivotCharts and other visualizations " Analyzing multiple data sources with PivotTables " Sharing PivotTables with others " Working with and analyzing OLAP data " Making the most of Excel 2010's powerful new PowerPivot feature " Using Excel 2010's Slicer to dynamically filter PivotTables " Enhancing PivotTables with macros and VBA code This book is part of the new MrExcel Library series, edited by Bill Jelen, world-renowned Excel expert and host of the enormously popular Excel help site, MrExcel.com.

 

Teaches PivotTables, PivotCharts, and Excel 2010's new PowerPivot feature through real-world scenarios that make intuitive sense to users at all levels Includes proven PivotTable recipes for instant on-the-job results Helps Excel users avoid common pitfalls and mistakes Part of the brand-new MrExcel Library series, edited by Excel legend Bill Jelen

PivotTables may be Excel's most powerful feature, but Microsoft has estimated that only 15% of Excel users take advantage of them. That's because PivotTables (and their companion feature, PivotCharts) have a reputation for being difficult to learn. Not any more! In this book, Excel legends Bill Jelen ("MrExcel") and Michael Alexander teach PivotTables and PivotCharts step-by-step, using realistic business scenarios that any Excel user can intuitively understand. Jelen and Alexander go far beyond merely explaining PivotTables and PivotCharts: they present practical "recipes" for solving a wide range of business problems. Drawing on more than 30 combined years of Excel experience, they provide tips and tricks you won't find anywhere else, and show exactly how to sidestep common mistakes. Coverage includes: " Creating PivotTables, customizing them, and changing the way you view them " Performing calculations within PivotTables " Using PivotCharts and other visualizations " Analyzing multiple data sources with PivotTables " Sharing PivotTables with others " Working with and analyzing OLAP data " Making the most of Excel 2010's powerful new PowerPivot feature " Using Excel 2010's Slicer to dynamically filter PivotTables " Enhancing PivotTables with macros and VBA code This book is part of the new MrExcel Library series, edited by Bill Jelen, world-renowned Excel expert and host of the enormously popular Excel help site, MrExcel.com.

 

Teaches PivotTables, PivotCharts, and Excel 2010's new PowerPivot feature through real-world scenarios that make intuitive sense to users at all levels Includes proven PivotTable recipes for instant on-the-job results Helps Excel users avoid common pitfalls and mistakes Part of the brand-new MrExcel Library series, edited by Excel legend Bill Jelen

Using a unique analytical framework based on host-stranger relations, this book explores the response of cities to the arrival and settlement of labour immigrants. Comparing the local policies of four cities - Paris, Amsterdam, Rome and Tel Aviv - Michael Alexander charts the development of migrant policies over time and situates them within the broader social context. Grounded in multi-city, multi-domain empirical findings, the work provides a fuller understanding of the interaction between cities and their migrant populations. Filling a gap in existing literature on migrant policy between national-level theorizing and local-level study, the book will provide an important basis for future research in the area.