Informática

INGLÊS

Transformative Magic Of M Code In Power Query Excel & Power Bi - A Beginner'S Guide To Mastering The Art Of Data Metamorphosis To Get Just The Data Structure Needed To Create Insightful Data Analysis Solution

de Mike Excelisfun Girvin

~~14,87€~~ 11,90€ 20% IMEDIATO

DISPONIBILIDADE IMEDIATA

 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 data analysis jobs, using the SQL language to perform ETL (extract, transform and load) is the preferred tool. Maybe even R or Python. But if you use Power BI or Excel, you better also be masterful with M Code and Power Query. Together, they give you the power to connect to multiple data sources, structuring your data with ease, and load to the worksheet, the data model in Excel or Power BI or Dataflow' s Data Hub. As an accountant, professor, data analyst, author, Excel MVP and YouTuber for about 20 years, my specialty is in telling stories with videos and books to make complicated things less complicated and to inspire you to have fun with the power you can gain over data.
INGLÊS

Microsoft Excel Functions And Formulas

de Bernd Held, Brian Moriarty e Theodor Richardson

~~58,30€~~ 46,64€ 20% IMEDIATO

DISPONIBILIDADE IMEDIATA

 No detailed description available for "Microsoft Excel Functions and Formulas".
INGLÊS

Collect, Combine, And Transform Data Using Power Query In Power Bi And Excel

de Daniil Maslyuk e Gil Raviv

~~52,99€~~ 47,69€ 10% IMEDIATO

DISPONIBILIDADE IMEDIATA

 Transform your data analysis experience with Power Query, the ultimate tool for importing, reshaping, and cleansing data through a user-friendly interface. Whether you’re using Power BI, Excel, or other Microsoft products, Power Query’s capabilities are at your fingertips. Renowned Power Query experts Daniil Maslyuk and Gil Raviv guide you through mastering this indispensable tool, helping you eliminate tedious manual data preparation, tackle common issues, and avoid potential pitfalls. In this updated edition, you’ll delve into comprehensive analytics challenges, seamlessly integrating your skills into a realistic, final project. By the end, you’ll possess the expertise to handle any data and convert it into actionable insights. You will learn how to: <ul> <li>Effortlessly prepare data by utilizing Power Query in Power BI and Excel to transform your data quickly and efficiently</li> <li>Overcome common data preparation problems with intuitive mouse clicks and straightforward formula edits</li> <li>Combine data from various sources, multiple queries, and mismatched tables with ease</li> <li>Reshape tables to suit your analysis needs</li> <li>Use the Power Query M formula language to create flexible data mashups and tailor transformations to your requirements</li> <li>Address and overcome collaboration challenges by using Power Query’s powerful features</li> <li>Gain crucial insights from text feeds by enhancing your data analysis capabilities</li> <li>Profile data, diagnose queries, improve query performance, and more!</li> </ul> About This Book <ul> <li>For everyone who wants to get more done with Power Query in less time</li> <li>For business and financial professionals, developers, entrepreneurs, students, and others who need to efficiently manage and analyze data</li> </ul>
INGLÊS

Collect, Combine, And Transform Data Using Power Query In Power Bi And Excel

de Daniil Maslyuk e Gil Raviv

~~40,93€~~ 36,84€ 10% IMEDIATO

DISPONIBILIDADE IMEDIATA

 Transform your data analysis experience with Power Query, the ultimate tool for importing, reshaping, and cleansing data through a user-friendly interface. Whether you’re using Power BI, Excel, or other Microsoft products, Power Query’s capabilities are at your fingertips. Renowned Power Query experts Daniil Maslyuk and Gil Raviv guide you through mastering this indispensable tool, helping you eliminate tedious manual data preparation, tackle common issues, and avoid potential pitfalls. In this updated edition, you’ll delve into comprehensive analytics challenges, seamlessly integrating your skills into a realistic, final project. By the end, you’ll possess the expertise to handle any data and convert it into actionable insights. You will learn how to: <ul> <li>Effortlessly prepare data by utilizing Power Query in Power BI and Excel to transform your data quickly and efficiently</li> <li>Overcome common data preparation problems with intuitive mouse clicks and straightforward formula edits</li> <li>Combine data from various sources, multiple queries, and mismatched tables with ease</li> <li>Reshape tables to suit your analysis needs</li> <li>Use the Power Query M formula language to create flexible data mashups and tailor transformations to your requirements</li> <li>Address and overcome collaboration challenges by using Power Query’s powerful features</li> <li>Gain crucial insights from text feeds by enhancing your data analysis capabilities</li> <li>Profile data, diagnose queries, improve query performance, and more!</li> </ul> About This Book <ul> <li>For everyone who wants to get more done with Power Query in less time</li> <li>For business and financial professionals, developers, entrepreneurs, students, and others who need to efficiently manage and analyze data</li> </ul>
INGLÊS

Excel'S Not Dead

de William Mcburnie

~~7,94€~~ 7,15€ 10% IMEDIATO

DISPONIBILIDADE IMEDIATA

 A new way of working with Excel spreadsheets never seen before that will transform how we work with Excel now and in the future. A game changing system of data manipulation based on a single discovery.This book will take you step by step from the discovery and it''s simple application through to how to apply it to create fully dynamic dashboards. The things that you could previously only do with Pivot Tables are now available to everyone from Excel beginners to professionals. A comprehensive Excel toolkit to ensure you have all the tools you need to tackle all the exercises and complete your journey.I hear too often from IT professionals that "Excel is Dead" but every day I see It becoming more and more essential in every work environment from single person start ups to large corporations. This book will show that not only is excel not dead, with the system I will teach you it''s getting stronger and stronger.
INGLÊS

Mrexcel 2024 - Igniting Excel

de Bill Jelen

~~14,87€~~ 13,38€ 10% IMEDIATO

DISPONIBILIDADE IMEDIATA

 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 Query. Updated annually, this edition for 2021 adds information on LET and LAMBDA functions, amazing new data types, dynamic array formulas, and more.
INGLÊS

Excel Cookbook

de Dawn Griffiths

~~54,31€~~ 43,45€ 20% IMEDIATO

DISPONIBILIDADE IMEDIATA

 Filled with tips, tricks, and techniques, this easy-to-use book is the perfect resource for intermediate to advanced users of Excel. You'll find complete recipes for more than a dozen topics covering formulas, PivotTables, charts, Power Query, and more.
INGLÊS

Excel Cookbook - Recipes For Mastering Microsoft Excel

de Dawn Griffiths

~~54,31€~~ 43,45€ 20% IMEDIATO

DISPONIBILIDADE IMEDIATA

 Filled with tips, tricks, and techniques, this easy-to-use book is the perfect resource for intermediate to advanced users of Excel. You'll find complete recipes for more than a dozen topics covering formulas, PivotTables, charts, Power Query, and more.
INGLÊS

Extending Excel With Python And R - Unlock The Potential Of Analytics Languages For Advanced Data Manipulation And Visualization

de David Kun e Steven Sanderson

~~35,76€~~ 32,18€ 10% IMEDIATO

DISPONIBILIDADE IMEDIATA

 <![CDATA[Seamlessly integrate the Python and R programming languages with spreadsheet-based data analysis to maximize productivity<h4>Key Features</h4><ul><li>Perform advanced data analysis and visualization techniques with R and Python on Excel data</li><li>Use exploratory data analysis and pivot table analysis for deeper insights into your data</li><li>Integrate R and Python code directly into Excel using VBA or API endpoints</li><li>Purchase of the print or Kindle book includes a free PDF eBook</li></ul><h4>Book Description</h4>For businesses, data analysis and visualization are crucial for informed decision-making; however, Excel’s limitations can make these tasks time-consuming and challenging. Extending Excel with Python and R is a game changer resource written by experts Steven Sanderson, the author of the healthyverse suite of R packages, and David Kun, co-founder of Functional Analytics, the company behind the ownR platform engineering solution for R, Python, and other data science languages.This comprehensive guide transforms the way you work with spreadsheet-based data by integrating Python and R with Excel to automate tasks, execute statistical analysis, and create powerful visualizations. Working through the chapters, you’ll find out how to perform exploratory data analysis, time series analysis, and even integrate APIs for maximum efficiency. Whether you''re a beginner or an expert, this book has everything you need to unlock Excel''s full potential and take your data analysis skills to the next level.By the end of this book, you’ll be able to import data from Excel, manipulate it in R or Python, and perform the data analysis tasks in your preferred framework while pushing the results back to Excel for sharing with others as needed.<h4>What you will learn</h4><ul><li>Read and write Excel files with R and Python libraries</li><li>Automate Excel tasks with R and Python scripts</li><li>Use R and Python to execute Excel VBA macros</li><li>Format Excel sheets using R and Python packages</li><li>Create graphs with ggplot2 and Matplotlib in Excel</li><li>Analyze Excel data with statistical methods and time series analysis</li><li>Explore various methods to call R and Python functions from Excel</li></ul><h4>Who this book is for</h4>If you’re a data analyst or data scientist, or a quants, actuaries, or data practitioner looking to enhance your Excel skills and expand your data analysis capabilities with R and Python, this book is for you. It provides a comprehensive introduction to the topics covered, making it suitable for both beginners and intermediate learners. A basic understanding of Excel, Python, and R is all you need to get started.]]>
INGLÊS

Modern Data Analytics In Excel

de George Mount

~~54,31€~~ 43,45€ 20% IMEDIATO

DISPONIBILIDADE IMEDIATA

 If you haven't modernized your data cleaning and reporting processes in Microsoft Excel, you're missing out on big productivity gains. This practical book serves as an introduction to the modern Excel suite of features along with other powerful tools for analytics.
INGLÊS

Modern Data Analytics In Excel - Using Power Query, Power Pivot, And More For Enhanced Data Analytics

de George Mount

~~54,31€~~ 43,45€ 20% IMEDIATO

DISPONIBILIDADE IMEDIATA

 If you haven't modernized your data cleaning and reporting processes in Microsoft Excel, you're missing out on big productivity gains. This practical book serves as an introduction to the modern Excel suite of features along with other powerful tools for analytics.
imagem não disponível

Microsoft Excel 365 Tips & Tricks - 2019

eBook 20%

INGLÊS

Microsoft Excel 365 Tips & Tricks - 2019 - A Quickstudy Software Reference Guide

de Curtis Frye

~~9,21€~~ 7,37€ 20% IMEDIATO

DISPONIBILIDADE IMEDIATA

 Quick and easy answers to the essentials of Excel, handy enough to keep you working without Internet searches or long videos. Our author and expert Curtis Frye owns a corporate training company specifically for Excel, is also a LinkedIn Learning video author (formerly Lynda.com) and a Microsoft author. The ability to choose what is covered in this reference comes from his vast experience working directly with users. This expertise is streamlined through clear and succinct answers provided to help accomplish tasks. Includes labeled screen grabs and icons in a color-coded design. Durable and portable, this digital guide can be stored and accessed quickly so you can find what you need fast. Corporations ranging from Ford Motor Company to the FBI have purchased QuickStudy software guides for their employee’s workspace to improve productivity and reduce support calls. Digital guide includes: <ul><li>Managing Excel</li><li>Selecting Cells & Navigating Efficiently</li><li>Summarizing Data Efficiently</li><li>Verifying Data Entry Using Data Validation Rules</li><li>Auditing Formulas</li><li>Organizing Data Using Named Ranges & Tables</li><li>Optimizing Data Display</li><li>Applying Cell Formats</li><li>Managing Lists of Values</li><li>Managing Hyperlinks</li><li>Managing Worksheets & Workbooks</li></ul>
imagem não disponível

Microsoft Excel 365 - 2019

eBook 20%

INGLÊS

Microsoft Excel 365 - 2019 - A Quickstudy Sotware Reference Guide

de Curtis Frye

~~9,21€~~ 7,37€ 20% IMEDIATO

DISPONIBILIDADE IMEDIATA

 Quick and easy answers to the essentials of Excel, handy enough to keep you working without Internet searches or long videos. Our author and expert Curtis Frye owns a corporate training company specifically for Excel, is also a LinkedIn Learning video author (formerly Lynda.com) and a Microsoft author. The ability to choose what is covered in this reference comes from his vast experience working directly with users. This expertise is streamlined through clear and succinct answers provided to help accomplish tasks. Also includes labeled screen grabs and icons in a color-coded design. Durable and portable, this digital guide can be stored and accessed quickly so you can find what you need fast. Corporations ranging from Ford Motor Company to the FBI have purchased QuickStudy software guides for their employee’s workspace to improve productivity and reduce support calls. Digital guide includes: <ul><li> Main Window </li><li> New Features </li><li> The Ribbon </li><li> Document File Formats </li><li> Microsoft Accounts </li><li> Entering & Editing Cell Data </li><li> Undo & Redo Changes </li><li> Managing Cells, Rows, Columns & Data </li><li> Formatting Cell Data </li><li> Creating Formulas </li><li> Creating Formulas Using Functions </li><li> Defining Excel Tables </li><li> Managing Workbooks & Worksheets </li><li> Sorting & Filtering Data </li></ul>
INGLÊS

Python 3 And Feature Engineering

de Oswald Campesato

~~45,32€~~ 36,26€ 20% IMEDIATO

DISPONIBILIDADE IMEDIATA

 This book is designed for data scientists, machine learning practitioners, and anyone with a foundational understanding of Python 3.x. In the evolving field of data science, the ability to manipulate and understand datasets is crucial. The book offers content for mastering these skills using Python 3. The book provides a fast-paced introduction to a wealth of feature engineering concepts, equipping readers with the knowledge needed to transform raw data into meaningful information. Inside, youll find a detailed exploration of various types of data, methodologies for outlier detection using Scikit-Learn, strategies for robust data cleaning, and the intricacies of data wrangling. The book further explores feature selection, detailing methods for handling imbalanced datasets, and gives a practical overview of feature engineering, including scaling and extraction techniques necessary for different machine learning algorithms. It concludes with a treatment of dimensionality reduction, where youll navigate through complex concepts like PCA and various reduction techniques, with an emphasis on the powerful Scikit-Learn framework.
INGLÊS

Excel - Mastering Data Analysis, Visualization, And Automation For Success With Microsoft 365

de Sam O.A

~~17,21€~~ 13,77€ 20% IMEDIATO

DISPONIBILIDADE IMEDIATA

 Are you ready to unlock the full potential of Microsoft 365''s most powerful tool?In "Excel: Mastering Data Analysis, Visualization, and Automation for Success with Microsoft 365," embark on a transformative journey that will forever change the way you approach data. Whether you''re an aspiring data analyst, a seasoned professional, or a business leader seeking a competitive edge, this book is your key to unleashing the true power of Excel. If you''ve ever felt overwhelmed by rows of numbers or struggled to derive meaningful insights from your data, this book is your guiding light. "Excel" takes you by the hand and demystifies the world of data analysis.Dive deep into the art of data manipulation and discover how to extract hidden trends and patterns that others miss. With step-by-step tutorials and real-world examples, you''ll develop the skills needed to turn raw data into actionable intelligence. Imagine having the ability to create stunning visualizations that captivate your audience and drive your message home. With Excel, you''ll not only master the art of charts and graphs but also learn advanced techniques that will elevate your reports and presentations to a whole new level.Don''t miss your chance to revolutionize your career and become a data-driven decision-maker. Take control of your destiny and harness the full potential of Microsoft 365. "Excel: Mastering Data Analysis, Visualization, and Automation for Success with Microsoft 365" is your indispensable companion on this exciting journey.Inside this book, you''ll discover:<ul><li>Comprehensive Data Analysis: Learn the techniques and functions that transform data into valuable insights. From sorting and filtering to pivot tables and beyond, become a data wizard.</li><li>Masterful Visualization: Elevate your data presentations with captivating charts, interactive dashboards, and eye-catching graphs. Your data will speak volumes.</li><li>Advanced Automation: Discover the world of macros and automation to streamline your tasks and boost productivity. Say goodbye to repetitive work.</li><li>Real-World Applications: Gain practical knowledge with hands-on examples and case studies from various industries. See how Excel is changing the game in businesses just like yours.</li><li>Expert Tips and Tricks: Unlock the secrets of Excel''s power users. Learn shortcuts and strategies that will save you time and frustration.</li></ul>Don''t let Excel remain a mere spreadsheet tool. Turn it into your secret weapon for success. Whether you''re aiming to enhance your career prospects, improve your business operations, or simply increase your data literacy, this "Mastering Data Analysis, Visualization, and Automation for Success with Microsoft 365" book is your definitive guide.Join the ranks of those who have harnessed the full potential of Excel and witness the transformation of your data-driven world. Success is just a click away. Grab your copy now and start your journey towards becoming an Excel master!
Excel Vba In Easy Steps, 4th Edition

de Mike Mcgrath

~~20,64€~~ 16,51€ 20% IMEDIATO

DISPONIBILIDADE IMEDIATA

 Excel VBA in easy steps, 4thedition shows the reader how to record and edit macro procedures to manipulateExcel worksheet entries, and how to create their own macro programs in theVisual Basic Editor, all in easy steps. This 4th edition is updated for Microsoft 365.
Microsoft Excel In Easy Steps

de Mike & Price, Michael Mcgrath

~~19,07€~~ 15,26€ 20% IMEDIATO

DISPONIBILIDADE IMEDIATA

 Microsoft Excel in easy steps guides you through the essential functions of Microsoft Excel â€" whether you are new to Excel and the spreadsheet concept, or just upgrading from an older version. This edition is illustrated using the most up-to-date version of Excel in Microsoft 365 at the time of printing.
imagem não disponível

Excel Workbook

eBook 20%

INGLÊS

Excel Workbook - 160 Exercises With Solutions And Comments

de Davide Del Corno

~~34,73€~~ 27,78€ 20% IMEDIATO

DISPONIBILIDADE IMEDIATA

 Excel is the most popular and widely used productivity software in all business environments, and it is an irreplaceable companion in ordinary work as in the analysis of large amounts of complex data. Nevertheless, the majority of users knows and uses only a very limited number of features, often in an elementary way. This workbook shows in practice the use of a wide variety of formulas, func-tions and features (like charts, pivot tables, macros or the Solver add-in) that allow to effectively and professionally work with Excel. The workbook starts with the basics and gets progressively to deal with very com-plex cases. It is a valuable support for college students, professionals and manag-ers who want to learn the basics or to improve the knowledge of Excel up to an advanced level. DigitaBook format includes the digital edition of the book with all the initial and solved fi les available to carry out the exercises and check the solutions. Over 80 exercises are commented, to highlight the basic concepts and clarify the most complex ones.
INGLÊS

Microsoft Excel Functions And Formulas - With Excel 2021 / Microsoft 365

de Bernd Held, Brian Moriarty e Theodor Richardson

~~51,47€~~ 41,18€ 20% IMEDIATO

DISPONIBILIDADE IMEDIATA

 No detailed description available for "Microsoft Excel Functions and Formulas".
Mrexcel Live - The 54 Greatest Excel Tips Of All Time

de Bill Jelen

~~14,87€~~ 11,90€ 20% IMEDIATO

DISPONIBILIDADE IMEDIATA

 The 54 essential tips that all Excel users need to know. MrExcel LIVe provides users with a concise book that can be absorbed in under an hour. Includes a section with keyboard shortcuts. Anyone who uses Excel will be able to turn to any page and pick up tips that will save them hours of work.
Mrexcel Live - The 54 Greatest Excel Tips Of All Time

de Bill Jelen

~~14,87€~~ 11,90€ 20% IMEDIATO

DISPONIBILIDADE IMEDIATA

 The 54 essential tips that all Excel users need to know. MrExcel LIVe provides users with a concise book that can be absorbed in under an hour. Includes a section with keyboard shortcuts. Anyone who uses Excel will be able to turn to any page and pick up tips that will save them hours of work.
Don'T Fear The Spreadsheet - A Beginner'S Guide To Overcoming Excel'S Frustrations

de Bill Jelen, Kevin Jones, Tom Urtis e Tyler Nash

~~9,26€~~ 7,41€ 20% IMEDIATO

DISPONIBILIDADE IMEDIATA

 Written in a question-and-answer format, this lowest-level beginner book covers the extreme basics of using spreadsheets in Excel. Instead of delving into advanced topics that scare most Excel novices away, the guide starts at a much more basic level, quickly providing a passable knowledge of the program and allowing users to overcome their fears and frustrations. It answers hundreds of common questions, including Can I delete data from a spreadsheet without changing the formatting? How can I merge two cells, columns, or rows? How do I use text-wrapping? How do I create custom functions? and What is a Macro and how do I go about creating it? Intended for the roughly 40 percent Excel users who have never even entered a formula, this book will demystify the problems and confusion that prevent them from using the program to its potential.
Excel 2007 For Scientists And Engineers

de Dr. Gerard Verschuuren

~~12,85€~~ 10,28€ 20% IMEDIATO

DISPONIBILIDADE IMEDIATA

 With examples from the world of science and engineering, this reference teaches scientists how to create graphs, analyze statistics and regressions, and plot and organize scientific data. Physicists and engineers can learn the tips and techniques of Excel-and tailor them specifically to their experiments, designs, and research. They will learn when to use NORMDIST vs NORMSDist and CONFIDENCE vs Z, how to keep data-validation lists on a hidden worksheet, use pivot tables to chart frequency distribution, generate random samples with various characteristics, and much more. Ideal for students and professionals alike, this handbook will enable greater productivity and efficiency.
Slaying Excel Dragons - A Beginners Guide To Conquering Excel'S Frustrations And Making Excel Fun

de Mike Excelisfun Girvin

~~19,80€~~ 15,84€ 20% IMEDIATO

DISPONIBILIDADE IMEDIATA

 This enthusiastic introduction provides support for Excel beginners and focuses on using the program immediately for maximum efficiency. With 1,104 screenshots and explicit information on everything from rows, columns, and cells to subtotaling, sorting, and pivot tables, this guide aims to alleviate the frustrations that come with using the program for the first time. This manual offers strategies for avoiding problems and streamlining efficiency and assists readers from start to finish, turning Excel 2010 novices into experts.
A carregar resultados...

Ver mais resultados

Cesto de Compras

/ Folhas de Cálculo