Best Microsoft Excel Guides

Leading Microsoft BI consultants Marco Russo and Alberto Ferrari help you master everything from table functions through advanced code and model optimization. Marco Russo and Alberto Ferrari cofounded sqlbi.com, where they regularly publish articles about Microsoft PowerPivot, DAX, Power BI, and SQL Server Analysis Services.

Written by the world's foremost Power BI bloggers and practitioners, the book's concepts and approach are introduced in a simple, step-by-step manner tailored to the learning style of Excel users everywhere. The "pattern-like" techniques and best practices contained in this book have been developed and refined over several years of onsite training with Excel users around the world, and the key lessons from those seminars costing thousands of dollars per day are now available to you, within the pages of this easy-to-follow guide. Big thanks to our IndieGoGo crowdfunding supporters, who not only made it possible to print this book in full-gorgeous color, but also inspired us to burn the night oil in writing those last chapters. I sincerely believe that Power Pivot and Power BI can transform the lives of Excel users worldwide - after all I was one of them.

Master business modeling and analysis techniques with Microsoft Excel 2016, and transform data into bottom-line results. WAYNE L. WINSTON is Professor Emeritus of Decision Sciences at Indiana University’s Kelley School of Business and Visiting Professor of Decision and Information Sciences at University of Houston Bauer College of Business.

Ace your preparation for Microsoft Certification Exam 70-461 with this 2-in-1 Training Kit from Microsoft Press. He has also developed three courses for SolidQ: Data Modeling Essentials, Data Quality and Master Data Management, and Data Mining.

Updated new edition of Ralph Kimball's groundbreaking book on dimensional modeling for data warehousing and business intelligence! Fully updated with fresh insights and best practices, this book provides clear guidelines for designing dimensional models—and does so in a style that serves the needs of those new to data warehousing as well as experienced professionals. Practical design techniques—both basic and advanced—for dimension and fact tables 14 case studies, including retail sales, electronic commerce, customer relationship management, procurement, inventory, order management, accounting, human resources, financial services, healthcare, insurance, education, telecommunications, and transportation Sample data warehouse bus matrices for 12 case studies Dimensional modeling pitfalls and mistakes to avoid Enhanced slowly changing dimension techniques type 0 through 7 Bridge tables for ragged variable depth hierarchies and multivalued attributes Best practices for Big Data analytics Guidelines for collaborative, interactive design sessions with business stakeholders An overview of the Kimball DW/BI project lifecycle methodology Comprehensive review of extract, transformation, and load (ETL) systems and design considerations The 34 ETL subsystems and techniques to populate dimension and fact tables.

The leading book on Microsoft Office, now fully updated for Office 2010 Microsoft Office, the world's leading productivity suite, has been updated with new tools. They're a team — explore commands and features common to all the Office programs plus techniques to boost your productivity Working with Word — create letters, reports, newsletters, mass mailings, and more Improve your Outlook — manage your e-mail, track tasks, keep an address book and calendar, and organize your life Get your Point across — build livelier, more original PowerPoint presentations and even improve your delivery Excel at number crunching — design spreadsheets that are easy to understand, use data-validation rules, and analyze data Access your information — discover all the ways you can build and use an Access database Your own Publisher — turn out great brochures, pamphlets, and other publications A step beyond — check out the extra programs and customize your Office. The common tools you'll find in all Office applications Clear instructions for revising and collaborating on documents Tips on building tables, charts, and diagrams in Excel, Word, and PowerPoint Word's tools for creating scholarly reports and white papers Advice on scheduling events with Outlook Secrets of memorable PowerPoint presentations How to build an Access database from scratch Hints for creating newsletters in Publisher.

Discover how to maximize the advantages that the latest version of Microsoft Office offers with the focused approach found in MICROSOFT OFFICE 365 & OFFICE 2016: INTRODUCTORY.

In this new fifth edition, Michael Linenberger updates his longtime #1 bestselling Outlook book to cover Microsoft's new Outlook version 365, which includes desktop Outlook 2016 Windows and Mac (and Window Outlook 2013). Called the “Efficiency Guru” by The Detroit News, Michael Linenberger has been a management consultant and technology professional for more than 20 years.

PowerPoint 2016 For Dummies takes the pain out of working with PowerPoint, offering plain-English explanations of everything you need to know to get up and running with the latest version of the software. Create a slide presentation with special effects Work with master slides and templates Collaborate with other users in the cloud.