56 Ergebnisse - Zeige 1 von 20.

This book is about Power Query and M Code. Power Query and the functional language M Code (M) are the heart and soul of Microsoft's power data analysis tools: Excel, Power BI Desktop and Dataflows. The beautiful data driven and insightful PivotTables, Power BI solutions and Dashboards that you create usually require that you use Power Query and M Code to get, transform and load the data before you create the final reports and visuals. For many...

Array Formulas have been around since the beginning of Excel. The author wrote a whole book about them back in 2012. Array Formulas were powerful, but complicated. Then Microsoft invented the new Worksheet Calculation Engine in Microsoft 365 Excel and just like that, 40 years of Excel worksheet formula methods changed overnight. Dynamic Spilled Array Formulas, born inside this new calc engine, can now spill results from a single cell and dynam...

Secret methods for charting in Excel. Charting in Microsoft Excel is complex. Every day, in Excel forums across the Internet, people are constantly trying to create an informative chart, but Excel just won't let you do it. In this book, Excel MVP Jon Peltier solves many of the unsolvable charting problems in Excel. The examples include simple-to-complicated approaches to achieving desired chart appearance and functionality, making use of commo...

Excel tips to skyrocket white-collar productivity. Originally designed for Bill Jelen's live Power Excel seminars, the target audience already uses Excel 40 hours a week. These tips are the "aha" tips that uncover secret methods in Excel. The book covers general Excel functions, pivot tables, and formulas such as VLOOKUP and the new XLOOKUP. It introduces elements of modern Excel such as the Power Pivot Data Model and cleaning data with Power ...

Neither an exposé of the dark underbelly of wrestling nor a justification of its existence, Red Headed Geek is a loving, firsthand look inside the regional wrestling circuits of yesteryear by a former manager who's been tossed from the ring, bashed with a folding chair, and had painfully honest conversations with the wrestlers themselves. Billy C. Wirtz gives a distinct view of the strange world of wrestling, offering a look into the actual wo...

Keine Beschreibung.

Keine Beschreibung.

Vintage and modern examples of charms are interwoven throughout the pages of this exploration of charm jewelry, revealing how they have been worn, collected, interpreted, cherished, and even worshipped. Complete with lavish, full-color photographs, this work includes sentimental stories of charms and jewelry--from travel memories and family histories to commemorating important events, holidays, or occasions.

Fifty Excel tricks that no one has ever seen before. Cool Excel Sh*t is designed with the Excel guru in mind, introducing advanced, creative solutions and hacks for the software's most challenging problems. Through a series of more than 50 techniques, formulas, dynamic arrays, and VBA macros, this guide details processes that may be used in any application and across all disciplines. Includes a section on techniques using Dynamic Arrays in Excel.

Written specifically for finance managers, Excel for the CFO explains the best features of Excel that allow for the automation of regular processes and help reduce the processing time spent on analytics. The book explores the entire gamut of finance-related functions and is focused on practical approaches to using Excel--including Pivot Tables, Goal Seek, Scenario Builder, and VBA--in problem solving to deliver quality results. Using case stud...

For scientists and engineers tired of trying to learn Excel with examples from accounting, this self-paced tutorial is loaded with informative samples from the world of science and engineering. Techniques covered include creating a multifactorial or polynomial trendline, generating random samples with various characteristics, and tips on pivoting tables to create frequency distributions.

Keine Beschreibung.

Keine Beschreibung.

Drawn from actual excel conundrums posted on the author's website, www.mrexcel.com, this high-level resource is designed for people who want to stretch Excel to its limits. Tips for solving 100 incredibly difficult problems are covered in depth and include extracting the first letter of each word in a paragraph, validating URL's, generating random numbers without repeating, and hiding rows if cells are empty. The answers to these and other que...

Keine Beschreibung.

Keine Beschreibung.

Keine Beschreibung.

Keine Beschreibung.

Keine Beschreibung.

Keine Beschreibung.